<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">A quick look to me points to the DB. Did you perform the DB upgrade. This bit makes me think it is db related:<div class=""><br class=""></div><div class=""><blockquote type="cite" class=""><div class=""><div class="" style="background-color: rgb(255, 255, 255); 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_1485503945060_5405" class="">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></div></blockquote><div class=""><br class=""></div><div class=""><br class=""></div><div class="">HTH</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><br class=""><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 27 Jan 2017, at 08:07, catborise <<a href="mailto:catborise@yahoo.com" class="">catborise@yahoo.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class=""><div style="background-color: rgb(255, 255, 255); font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 16px;" class=""><div id="yui_3_16_0_ym19_1_1485503945060_5179" class="">Hi,</div><div id="yui_3_16_0_ym19_1_1485503945060_5179" class=""><br class=""></div><div id="yui_3_16_0_ym19_1_1485503945060_5179" class="">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="yui_3_16_0_ym19_1_1485503945060_5179" class="">I tried to downgrade 2.6 and it does not work...</div><div id="yui_3_16_0_ym19_1_1485503945060_5179" dir="ltr" class="">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="yui_3_16_0_ym19_1_1485503945060_5179" class=""><br class=""></div><div id="yui_3_16_0_ym19_1_1485503945060_5399" class="">[root@spacewalk ~]# spacewalk-repo-sync -c oraclelinux6-x86_64-uek-r4</div><div id="yui_3_16_0_ym19_1_1485503945060_5400" class="">10:54:34 ======================================</div><div id="yui_3_16_0_ym19_1_1485503945060_5401" class="">10:54:34 | Channel: oraclelinux6-x86_64-uek-r4</div><div id="yui_3_16_0_ym19_1_1485503945060_5402" class="">10:54:34 ======================================</div><div id="yui_3_16_0_ym19_1_1485503945060_5403" class="">10:54:34 Sync of channel started.</div><div id="yui_3_16_0_ym19_1_1485503945060_5404" class="">10:54:34 Repo URL: <a href="http://public-yum.oracle.com/repo/OracleLinux/OL6/UEKR4/x86_64" class="">http://public-yum.oracle.com/repo/OracleLinux/OL6/UEKR4/x86_64</a></div><div id="yui_3_16_0_ym19_1_1485503945060_5405" class="">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="yui_3_16_0_ym19_1_1485503945060_5406" class="">Traceback (most recent call last):</div><div id="yui_3_16_0_ym19_1_1485503945060_5407" class=""> File "/usr/bin/spacewalk-repo-sync", line 247, in <module></div><div id="yui_3_16_0_ym19_1_1485503945060_5408" class=""> sys.exit(abs(main() or 0))</div><div id="yui_3_16_0_ym19_1_1485503945060_5409" class=""> File "/usr/bin/spacewalk-repo-sync", line 232, in main</div><div id="yui_3_16_0_ym19_1_1485503945060_5410" class=""> elapsed_time, channel_ret_code = sync.sync()</div><div id="yui_3_16_0_ym19_1_1485503945060_5411" class=""> File "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/reposync.py", line 336, in sync</div><div id="yui_3_16_0_ym19_1_1485503945060_5412" class=""> self.update_date()</div><div id="yui_3_16_0_ym19_1_1485503945060_5413" class=""> File "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/reposync.py", line 363, in update_date</div><div id="yui_3_16_0_ym19_1_1485503945060_5414" class=""> h.execute(channel=self.channel['label'])</div><div id="yui_3_16_0_ym19_1_1485503945060_5415" class=""> File "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 151, in execute</div><div id="yui_3_16_0_ym19_1_1485503945060_5416" class=""> return self._execute_wrapper(self._execute, *p, **kw)</div><div id="yui_3_16_0_ym19_1_1485503945060_5417" class=""> File "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 303, in _execute_wrapper</div><div id="yui_3_16_0_ym19_1_1485503945060_5418" class=""> raise sql_base.SQLSchemaError(error_code, e.pgerror, e)</div><div id="yui_3_16_0_ym19_1_1485503945060_5419" class="">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="yui_3_16_0_ym19_1_1485503945060_5420" class=""><br id="yui_3_16_0_ym19_1_1485503945060_5421" class=""></div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5420" class=""><br class=""></div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5420" class=""><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5504" class="">$ rpm -qa|grep spacewalk</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5505" class="">spacewalk-backend-applet-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5506" class="">spacewalk-client-repo-2.6-0.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5507" class="">spacewalk-common-2.6.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5508" class="">spacewalk-config-2.7.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5509" class="">spacewalk-backend-xmlrpc-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5510" class="">spacewalk-schema-2.7.6-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5511" class="">spacewalk-backend-iss-export-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5512" class="">spacewalk-certs-tools-2.5.3-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5513" class="">spacewalk-postgresql-2.6.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5514" class="">spacewalk-backend-sql-postgresql-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5515" class="">spacewalk-backend-tools-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5516" class="">spacewalk-backend-config-files-tool-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5517" class="">spacewalk-base-2.7.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5518" class="">rhn-org-httpd-ssl-key-pair-spacewalk.tuik.ulakbim-1.0-2.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5519" class="">spacewalk-java-postgresql-2.7.22-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5520" class="">spacewalk-backend-config-files-common-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5521" class="">spacewalk-branding-2.7.2-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5522" class="">spacewalk-java-2.7.22-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5523" class="">spacewalk-backend-config-files-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5524" class="">spacewalk-taskomatic-2.7.22-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5525" class="">spacewalk-setup-2.6.2-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5526" class="">spacewalk-backend-usix-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5527" class="">spacewalk-java-config-2.7.22-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5528" class="">spacewalk-backend-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5529" class="">spacewalk-backend-server-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5530" class="">spacewalk-selinux-2.7.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5531" class="">spacewalk-html-2.7.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5532" class="">spacewalk-admin-2.6.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5533" class="">spacewalk-jpp-workaround-2.3.5-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5534" class="">spacewalk-setup-jabberd-2.3.2-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5535" class="">spacewalk-backend-libs-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5536" class="">spacewalk-backend-sql-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5537" class="">spacewalk-base-minimal-2.7.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5538" class="">spacewalk-utils-2.7.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5539" class="">spacewalk-backend-iss-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5540" class="">spacewalk-oscap-2.6.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5541" class="">spacewalk-doc-indexes-2.5.2-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5542" class="">spacewalk-backend-xml-export-libs-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5543" class="">spacewalk-reports-2.7.2-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5544" class="">spacewalk-base-minimal-config-2.7.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5545" class="">spacewalk-backend-package-push-server-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5546" class="">spacewalk-repo-2.6-0.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5547" class="">spacewalk-search-2.6.1-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5548" class="">spacewalk-setup-postgresql-2.6.2-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5549" class="">spacewalk-java-lib-2.7.22-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5550" class="">spacewalk-backend-app-2.7.24-1.el7.noarch</div><div dir="ltr" id="yui_3_16_0_ym19_1_1485503945060_5551" class=""><br id="yui_3_16_0_ym19_1_1485503945060_5552" class=""></div></div></div></div>_______________________________________________<br class="">Spacewalk-list mailing list<br class=""><a href="mailto:Spacewalk-list@redhat.com" class="">Spacewalk-list@redhat.com</a><br class="">https://www.redhat.com/mailman/listinfo/spacewalk-list</div></blockquote></div><br class=""></div></div></body></html>