Bug 1421745 - command spacewalk-reports repositories failed with SQL error
Summary: command spacewalk-reports repositories failed with SQL error
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 2.6
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Jan Dobes
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space27
TreeView+ depends on / blocked
 
Reported: 2017-02-13 15:05 UTC by Pavel Studeník
Modified: 2017-09-27 19:31 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-09-27 19:31:43 UTC
Embargoed:


Attachments (Terms of Use)

Description Pavel Studeník 2017-02-13 15:05:48 UTC
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')

Comment 1 Pavel Studeník 2017-07-03 16:04:09 UTC
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

Comment 2 Eric Herget 2017-09-27 19:31:43 UTC
Spacewalk 2.7 has been released.

https://github.com/spacewalkproject/spacewalk/wiki/ReleaseNotes27


Note You need to log in before you can comment on or make changes to this bug.