[Spacewalk-list] Spacewalk Error Messages After Upgrade from 2.6 to 2.7
Kobus Bensch
kobus at giffgaff.co.uk
Fri Jan 27 09:57:24 UTC 2017
A quick look to me points to the DB. Did you perform the DB upgrade. This bit makes me think it is db related:
> ERROR: ('ERROR: column cs.ssl_ca_cert_id does not exist\nLINE 5: on cs.ssl_ca_cert_id = k1.id\n ^\n', <connection object at 0x307f620; dsn: 'password=xxxxxxx dbname=spaceschema user=spaceuser', closed: 0>, '\n select k1.key as ca_cert, k2.key as client_cert, k3.key as client_key\n from rhncontentsource cs\n join rhncryptokey k1\n on cs.ssl_ca_cert_id = k1.id\n left outer join rhncryptokey k2\n on cs.ssl_client_cert_id = k2.id\n left outer join rhncryptokey k3\n on cs.ssl_client_key_id = k3.id\n where cs.id = %(repo_id)s\n ‘)
HTH
> On 27 Jan 2017, at 08:07, catborise <catborise at yahoo.com> wrote:
>
> Hi,
>
> After upgrade spacewalk breaks and cannot update repositories. Web ui access normal but whenever i try to update repos it gives error like below...
> I tried to downgrade 2.6 and it does not work...
> There is not any information about that error. How can i fix that problem. If you will help me, i will appreciate...
>
> [root at spacewalk ~]# spacewalk-repo-sync -c oraclelinux6-x86_64-uek-r4
> 10:54:34 ======================================
> 10:54:34 | Channel: oraclelinux6-x86_64-uek-r4
> 10:54:34 ======================================
> 10:54:34 Sync of channel started.
> 10:54:34 Repo URL: http://public-yum.oracle.com/repo/OracleLinux/OL6/UEKR4/x86_64
> 10:54:35 ERROR: ('ERROR: column cs.ssl_ca_cert_id does not exist\nLINE 5: on cs.ssl_ca_cert_id = k1.id\n ^\n', <connection object at 0x307f620; dsn: 'password=xxxxxxx dbname=spaceschema user=spaceuser', closed: 0>, '\n select k1.key as ca_cert, k2.key as client_cert, k3.key as client_key\n from rhncontentsource cs\n join rhncryptokey k1\n on cs.ssl_ca_cert_id = k1.id\n left outer join rhncryptokey k2\n on cs.ssl_client_cert_id = k2.id\n left outer join rhncryptokey k3\n on cs.ssl_client_key_id = k3.id\n where cs.id = %(repo_id)s\n ')
> Traceback (most recent call last):
> File "/usr/bin/spacewalk-repo-sync", line 247, in <module>
> sys.exit(abs(main() or 0))
> File "/usr/bin/spacewalk-repo-sync", line 232, in main
> elapsed_time, channel_ret_code = sync.sync()
> File "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/reposync.py", line 336, in sync
> self.update_date()
> File "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/reposync.py", line 363, in update_date
> h.execute(channel=self.channel['label'])
> File "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 151, in execute
> return self._execute_wrapper(self._execute, *p, **kw)
> File "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 303, in _execute_wrapper
> raise sql_base.SQLSchemaError(error_code, e.pgerror, e)
> spacewalk.server.rhnSQL.sql_base.SQLSchemaError: (99999, 'ERROR: current transaction is aborted, commands ignored until end of transaction block', '', InternalError('current transaction is aborted, commands ignored until end of transaction block\n',))
>
>
> $ rpm -qa|grep spacewalk
> spacewalk-backend-applet-2.7.24-1.el7.noarch
> spacewalk-client-repo-2.6-0.el7.noarch
> spacewalk-common-2.6.1-1.el7.noarch
> spacewalk-config-2.7.1-1.el7.noarch
> spacewalk-backend-xmlrpc-2.7.24-1.el7.noarch
> spacewalk-schema-2.7.6-1.el7.noarch
> spacewalk-backend-iss-export-2.7.24-1.el7.noarch
> spacewalk-certs-tools-2.5.3-1.el7.noarch
> spacewalk-postgresql-2.6.1-1.el7.noarch
> spacewalk-backend-sql-postgresql-2.7.24-1.el7.noarch
> spacewalk-backend-tools-2.7.24-1.el7.noarch
> spacewalk-backend-config-files-tool-2.7.24-1.el7.noarch
> spacewalk-base-2.7.1-1.el7.noarch
> rhn-org-httpd-ssl-key-pair-spacewalk.tuik.ulakbim-1.0-2.noarch
> spacewalk-java-postgresql-2.7.22-1.el7.noarch
> spacewalk-backend-config-files-common-2.7.24-1.el7.noarch
> spacewalk-branding-2.7.2-1.el7.noarch
> spacewalk-java-2.7.22-1.el7.noarch
> spacewalk-backend-config-files-2.7.24-1.el7.noarch
> spacewalk-taskomatic-2.7.22-1.el7.noarch
> spacewalk-setup-2.6.2-1.el7.noarch
> spacewalk-backend-usix-2.7.24-1.el7.noarch
> spacewalk-java-config-2.7.22-1.el7.noarch
> spacewalk-backend-2.7.24-1.el7.noarch
> spacewalk-backend-server-2.7.24-1.el7.noarch
> spacewalk-selinux-2.7.1-1.el7.noarch
> spacewalk-html-2.7.1-1.el7.noarch
> spacewalk-admin-2.6.1-1.el7.noarch
> spacewalk-jpp-workaround-2.3.5-1.el7.noarch
> spacewalk-setup-jabberd-2.3.2-1.el7.noarch
> spacewalk-backend-libs-2.7.24-1.el7.noarch
> spacewalk-backend-sql-2.7.24-1.el7.noarch
> spacewalk-base-minimal-2.7.1-1.el7.noarch
> spacewalk-utils-2.7.1-1.el7.noarch
> spacewalk-backend-iss-2.7.24-1.el7.noarch
> spacewalk-oscap-2.6.1-1.el7.noarch
> spacewalk-doc-indexes-2.5.2-1.el7.noarch
> spacewalk-backend-xml-export-libs-2.7.24-1.el7.noarch
> spacewalk-reports-2.7.2-1.el7.noarch
> spacewalk-base-minimal-config-2.7.1-1.el7.noarch
> spacewalk-backend-package-push-server-2.7.24-1.el7.noarch
> spacewalk-repo-2.6-0.el7.noarch
> spacewalk-search-2.6.1-1.el7.noarch
> spacewalk-setup-postgresql-2.6.2-1.el7.noarch
> spacewalk-java-lib-2.7.22-1.el7.noarch
> spacewalk-backend-app-2.7.24-1.el7.noarch
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20170127/082e1bfc/attachment.htm>
More information about the Spacewalk-list
mailing list