[Spacewalk-list] Yan: Spacewalk Error Messages After Upgrade from 2.6 to 2.7

[catborise]

i check postgresdb, i found that rhncontentsource table does not contain ssl information. Latest updates move them to rhncontentsourcessl and rhncontentssl tables. The problem is related with spacewalk-repo-sync script. It is actually checks rhncontentsource for ssl. i think it is a problem/bug.
may be you can help me to start repo sync other way or could you update spacewalk-repo-sync script...

thanks 

    27 Ocak 2017 11:07 Cuma tarihinde catborise <catborise at yahoo.com> şöyle yazdı:
 

 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-r410:54:34 ======================================10:54:34 | Channel: oraclelinux6-x86_64-uek-r410:54:34 ======================================10:54:34 Sync of channel started.10:54:34 Repo URL: http://public-yum.oracle.com/repo/OracleLinux/OL6/UEKR4/x86_6410: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 spacewalkspacewalk-backend-applet-2.7.24-1.el7.noarchspacewalk-client-repo-2.6-0.el7.noarchspacewalk-common-2.6.1-1.el7.noarchspacewalk-config-2.7.1-1.el7.noarchspacewalk-backend-xmlrpc-2.7.24-1.el7.noarchspacewalk-schema-2.7.6-1.el7.noarchspacewalk-backend-iss-export-2.7.24-1.el7.noarchspacewalk-certs-tools-2.5.3-1.el7.noarchspacewalk-postgresql-2.6.1-1.el7.noarchspacewalk-backend-sql-postgresql-2.7.24-1.el7.noarchspacewalk-backend-tools-2.7.24-1.el7.noarchspacewalk-backend-config-files-tool-2.7.24-1.el7.noarchspacewalk-base-2.7.1-1.el7.noarchrhn-org-httpd-ssl-key-pair-spacewalk.tuik.ulakbim-1.0-2.noarchspacewalk-java-postgresql-2.7.22-1.el7.noarchspacewalk-backend-config-files-common-2.7.24-1.el7.noarchspacewalk-branding-2.7.2-1.el7.noarchspacewalk-java-2.7.22-1.el7.noarchspacewalk-backend-config-files-2.7.24-1.el7.noarchspacewalk-taskomatic-2.7.22-1.el7.noarchspacewalk-setup-2.6.2-1.el7.noarchspacewalk-backend-usix-2.7.24-1.el7.noarchspacewalk-java-config-2.7.22-1.el7.noarchspacewalk-backend-2.7.24-1.el7.noarchspacewalk-backend-server-2.7.24-1.el7.noarchspacewalk-selinux-2.7.1-1.el7.noarchspacewalk-html-2.7.1-1.el7.noarchspacewalk-admin-2.6.1-1.el7.noarchspacewalk-jpp-workaround-2.3.5-1.el7.noarchspacewalk-setup-jabberd-2.3.2-1.el7.noarchspacewalk-backend-libs-2.7.24-1.el7.noarchspacewalk-backend-sql-2.7.24-1.el7.noarchspacewalk-base-minimal-2.7.1-1.el7.noarchspacewalk-utils-2.7.1-1.el7.noarchspacewalk-backend-iss-2.7.24-1.el7.noarchspacewalk-oscap-2.6.1-1.el7.noarchspacewalk-doc-indexes-2.5.2-1.el7.noarchspacewalk-backend-xml-export-libs-2.7.24-1.el7.noarchspacewalk-reports-2.7.2-1.el7.noarchspacewalk-base-minimal-config-2.7.1-1.el7.noarchspacewalk-backend-package-push-server-2.7.24-1.el7.noarchspacewalk-repo-2.6-0.el7.noarchspacewalk-search-2.6.1-1.el7.noarchspacewalk-setup-postgresql-2.6.2-1.el7.noarchspacewalk-java-lib-2.7.22-1.el7.noarchspacewalk-backend-app-2.7.24-1.el7.noarch


   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20170213/616b1966/attachment.htm>