Bug 1421745
| Summary: | command spacewalk-reports repositories failed with SQL error | ||
|---|---|---|---|
| Product: | [Community] Spacewalk | Reporter: | Pavel Studeník <pstudeni> |
| Component: | Server | Assignee: | Jan Dobes <jdobes> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Red Hat Satellite QA List <satqe-list> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 2.6 | CC: | eherget |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2017-09-27 19:31:43 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 1484117 | ||
It looks that it is fixed for SW Nightly (2.7). spacewalk-reports-2.7.5-1.el6.noarch spacewalk-java-2.7.92-1.el6.noarch Spacewalk 2.7 has been released. https://github.com/spacewalkproject/spacewalk/wiki/ReleaseNotes27 |
Description of problem: I received SQL traceback ORA-00904: "CS"."SSL_CLIENT_KEY_ID": invalid identifier.. when I try to show report of all repositories. >> spacewalk-report repositories SQL error occurred, traceback follows... Traceback (most recent call last): File "/usr/bin/spacewalk-report", line 243, in <module> h.execute(**dict(report.params.items() + the_dict_where.items())) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 151, in execute return self._execute_wrapper(self._execute, *p, **kw) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 122, in _execute_wrapper raise_with_tb(sql_base.SQLStatementPrepareError(errno, errmsg, self.sql), sys.exc_info()[2]) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 113, in _execute_wrapper retval = function(*p, **kw) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 205, in _execute return self._execute_(args, kwargs) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 167, in _execute_ self._real_cursor.execute(*(None, ), **params) spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError: ('ORA-00904: "CS"."SSL_CLIENT_KEY_ID": invalid identifier\n', 904, 'select * from ( select cs.org_id, cs.id, cs.label as repo_label, cst.label as repo_type, cs.source_url, ck_key.description as client_key_descr, ck_key.crypto_key_type_id as client_key_type, ck_key.key as client_key, ck_cert.description as client_cert_descr, ck_cert.crypto_key_type_id as client_cert_type, ck_cert.key as client_cert, ck_ca.description as ca_descr, ck_ca.crypto_key_type_id as ca_type, ck_ca.key as ca_key from rhncontentsource cs left outer join rhncryptokey ck_key on ck_key.id = cs.ssl_client_key_id left outer join rhncryptokey ck_cert on ck_cert.id = cs.ssl_client_cert_id left outer join rhncryptokey ck_ca on ck_ca.id = cs.ssl_ca_cert_id join rhncontentsourcetype cst on cs.type_id = cst.id where cs.org_id is not null ) X order by org_id, id') Version-Release number of selected component (if applicable): spacewalk-reports-2.7.2-1.el6.noarch How reproducible: always on postgresql and oracle Steps to Reproduce: 1. spacewalk-report repositories Actual results: SQL traceaback Expected results: it works Additional info: On postgresql the traceback looks following: SQL error occurred, traceback follows... Traceback (most recent call last): File "/usr/bin/spacewalk-report", line 243, in <module> h.execute(**dict(report.params.items() + the_dict_where.items())) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 151, in execute return self._execute_wrapper(self._execute, *p, **kw) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 306, in _execute_wrapper raise sql_base.SQLStatementPrepareError(self.dbh, e.pgerror, self.sql) spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError: ('ERROR: column cs.ssl_client_key_id does not exist\nLINE 8: ...eft outer join rhncryptokey ck_key on ck_key.id = cs.ssl_cli...\n ^\n', <connection object at 0xe262f0; dsn: 'password=xxxxxxx dbname=spaceschema user=spaceuser', closed: 0>, '\n select * from (\n select cs.org_id, cs.id, cs.label as repo_label, cst.label as repo_type, cs.source_url,\n ck_key.description as client_key_descr, ck_key.crypto_key_type_id as client_key_type, ck_key.key as client_key,\n ck_cert.description as client_cert_descr, ck_cert.crypto_key_type_id as client_cert_type, ck_cert.key as client_cert,\n ck_ca.description as ca_descr, ck_ca.crypto_key_type_id as ca_type, ck_ca.key as ca_key\n from rhncontentsource cs\n left outer join rhncryptokey ck_key on ck_key.id = cs.ssl_client_key_id\n left outer join rhncryptokey ck_cert on ck_cert.id = cs.ssl_client_cert_id\n left outer join rhncryptokey ck_ca on ck_ca.id = cs.ssl_ca_cert_id\n join rhncontentsourcetype cst on cs.type_id = cst.id\n where cs.org_id is not null\n ) X\n -- where placeholder\n order by org_id, id\n')