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