<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1486993359305_6324" dir="ltr"><span id="yui_3_16_0_ym19_1_1486993359305_7009">i check postgresdb, i found that </span>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.</div><div id="yui_3_16_0_ym19_1_1486993359305_6324" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1486993359305_6324" dir="ltr">may be you can help me to start repo sync other way or could you update spacewalk-repo-sync script...</div><div id="yui_3_16_0_ym19_1_1486993359305_6324"><span><br></span></div><div id="yui_3_16_0_ym19_1_1486993359305_6358"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1486993359305_6378"><i>thanks</i></div> <div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1486993359305_7041"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1486993359305_8483" style="display: block;"> <div style="font-family: HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1486993359305_8482"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1486993359305_8481"> <div dir="ltr" id="yui_3_16_0_ym19_1_1486993359305_8492"><font size="2" face="Arial" id="yui_3_16_0_ym19_1_1486993359305_8491"> 27 Ocak 2017 11:07 Cuma tarihinde catborise <catborise@yahoo.com> şöyle yazdı:<br></font></div> <br><br> <div class="y_msg_container" id="yui_3_16_0_ym19_1_1486993359305_8486"><div id="yiv4535329045"><div id="yui_3_16_0_ym19_1_1486993359305_8485"><div style="color:#000;background-color:#fff;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;" id="yui_3_16_0_ym19_1_1486993359305_8484"><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5179">Hi,</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5179"><br></div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5179">After upgrade spacewalk breaks and cannot update repositories. Web ui access normal but whenever i try to update repos it gives error like below...</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5179">I tried to downgrade 2.6 and it does not work...</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5179" dir="ltr">There is not any information about that error. How can i fix that problem. If you will help me, i will appreciate...</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5179"><br></div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5399">[root@spacewalk ~]# spacewalk-repo-sync -c oraclelinux6-x86_64-uek-r4</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5400">10:54:34 ======================================</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5401">10:54:34 | Channel: oraclelinux6-x86_64-uek-r4</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5402">10:54:34 ======================================</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5403">10:54:34 Sync of channel started.</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5404">10:54:34 Repo URL: http://public-yum.oracle.com/repo/OracleLinux/OL6/UEKR4/x86_64</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5405">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 ')</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5406">Traceback (most recent call last):</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5407"> File "/usr/bin/spacewalk-repo-sync", line 247, in <module></div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5408"> sys.exit(abs(main() or 0))</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5409"> File "/usr/bin/spacewalk-repo-sync", line 232, in main</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5410"> elapsed_time, channel_ret_code = sync.sync()</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5411"> File "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/reposync.py", line 336, in sync</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5412"> self.update_date()</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5413"> File "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/reposync.py", line 363, in update_date</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5414"> h.execute(channel=self.channel['label'])</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5415"> File "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 151, in execute</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5416"> return self._execute_wrapper(self._execute, *p, **kw)</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5417"> File "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 303, in _execute_wrapper</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5418"> raise sql_base.SQLSchemaError(error_code, e.pgerror, e)</div><div id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5419">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',))</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5420"><br id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5421"></div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5420"><br></div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5420"><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5504">$ rpm -qa|grep spacewalk</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5505">spacewalk-backend-applet-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5506">spacewalk-client-repo-2.6-0.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5507">spacewalk-common-2.6.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5508">spacewalk-config-2.7.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5509">spacewalk-backend-xmlrpc-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5510">spacewalk-schema-2.7.6-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5511">spacewalk-backend-iss-export-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5512">spacewalk-certs-tools-2.5.3-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5513">spacewalk-postgresql-2.6.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5514">spacewalk-backend-sql-postgresql-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5515">spacewalk-backend-tools-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5516">spacewalk-backend-config-files-tool-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5517">spacewalk-base-2.7.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5518">rhn-org-httpd-ssl-key-pair-spacewalk.tuik.ulakbim-1.0-2.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5519">spacewalk-java-postgresql-2.7.22-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5520">spacewalk-backend-config-files-common-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5521">spacewalk-branding-2.7.2-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5522">spacewalk-java-2.7.22-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5523">spacewalk-backend-config-files-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5524">spacewalk-taskomatic-2.7.22-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5525">spacewalk-setup-2.6.2-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5526">spacewalk-backend-usix-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5527">spacewalk-java-config-2.7.22-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5528">spacewalk-backend-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5529">spacewalk-backend-server-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5530">spacewalk-selinux-2.7.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5531">spacewalk-html-2.7.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5532">spacewalk-admin-2.6.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5533">spacewalk-jpp-workaround-2.3.5-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5534">spacewalk-setup-jabberd-2.3.2-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5535">spacewalk-backend-libs-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5536">spacewalk-backend-sql-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5537">spacewalk-base-minimal-2.7.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5538">spacewalk-utils-2.7.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5539">spacewalk-backend-iss-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5540">spacewalk-oscap-2.6.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5541">spacewalk-doc-indexes-2.5.2-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5542">spacewalk-backend-xml-export-libs-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5543">spacewalk-reports-2.7.2-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5544">spacewalk-base-minimal-config-2.7.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5545">spacewalk-backend-package-push-server-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5546">spacewalk-repo-2.6-0.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5547">spacewalk-search-2.6.1-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5548">spacewalk-setup-postgresql-2.6.2-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5549">spacewalk-java-lib-2.7.22-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5550">spacewalk-backend-app-2.7.24-1.el7.noarch</div><div dir="ltr" id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5551"><br id="yiv4535329045yui_3_16_0_ym19_1_1485503945060_5552"></div></div></div></div></div><br><br></div> </div> </div> </div></div></body></html>