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 <[email protected]> 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@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
> [email protected]
> https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
