Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.
Bug 1354497 - spacewalk-report repositories fails on rhel5 with psycopg2.ProgrammingError: relation "rhncontentssl" does not exist
Summary: spacewalk-report repositories fails on rhel5 with psycopg2.ProgrammingError: ...
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 560
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-07-11 12:33 UTC by Lukas Pramuk
Modified: 2016-07-11 13:18 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-07-11 13:18:56 UTC
Target Upstream Version:


Attachments (Terms of Use)

Description Lukas Pramuk 2016-07-11 12:33:59 UTC
Description of problem:
spacewalk-report repositories fails on rhel5 with psycopg2.ProgrammingError: relation "rhncontentssl" does not exist at character 537

Version-Release number of selected component (if applicable):
satellite-schema-5.6.0.29-1.el5sat

How reproducible:
100%

Steps to Reproduce:
1.# spacewalk-report repositories
Traceback (most recent call last):
  File "/usr/bin/spacewalk-report", line 243, in ?
    h.execute(**dict(report.params.items() + the_dict_where.items()))
  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 163, in execute
    return apply(self._execute_wrapper, (self._execute, ) + p, kw)
  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 273, in _execute_wrapper
    retval = apply(function, p, kw)
  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 217, in _execute
    return self._execute_(args, kwargs)
  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 287, in _execute_
    self._real_cursor.execute(self.sql, params)
psycopg2.ProgrammingError: relation "rhncontentssl" does not exist at character 537


Actual results:
psycopg2.ProgrammingError, repositories cannot be exported from sat560 rhel5

Expected results:
repositories are exported

Additional info:

Comment 1 Lukas Pramuk 2016-07-11 12:38:03 UTC
Reproduced with:
spacewalk-reports-2.0.1-14.el5sat

Comment 2 Lukas Pramuk 2016-07-11 12:40:57 UTC
While on satellite-schema-5.6.0.29-1.el6sat it works:

# spacewalk-report repositories
org_id,id,repo_label,repo_type,source_url,client_key_descr,client_key_type,client_key,client_cert_descr,client_cert_type,client_cert,ca_descr,ca_type,ca_key
1,500,swexport-testrepo1-1468172796883819693,yum,REPO1_URL_1468172796883819693,,,,,,,,,
1,501,swexport-testrepo2-1468172796883819693,yum,REPO2_URL_1468172796883819693,,,,,,,,,
1,520,auto-yumRepo-4748-modified,yum,http://dl.fedoraproject.org/pub/epel/5/x86_64/modified,,,,,,,,,

Comment 3 Lukas Pramuk 2016-07-11 12:48:42 UTC
[OK] spacewalk-reports-2.0.1-14.el6sat.noarch 
/usr/share/spacewalk/reports/data/repositories:40
            left outer join rhncontentsourcessl css on css.content_source_id = cs.id


vs.

[BUG] spacewalk-reports-2.0.1-14.el5sat.noarch 
/usr/share/spacewalk/reports/data/repositories:40
            left outer join rhncontentssl css on css.content_source_id = cs.id


Are we releasing the same content to rhel6 and rhel5 channels?

Comment 4 Lukas Pramuk 2016-07-11 13:18:56 UTC
NOTABUG.

Content to rhel6 and rhel5 is the same.
I accidentally patched rhel5 downstream with upstream bits (little too agile)

Change in upstream doesn't break anything:

[root@SW-nightly ~] # spacewalk-report repositories
org_id,id,repo_label,repo_type,source_url,client_key_descr,client_key_type,client_key,client_cert_descr,client_cert_type,client_cert,ca_descr,ca_type,ca_key
1,501,swexport-testrepo1-1468196057851987707,yum,REPO1_URL_1468196057851987707,,,,,,,,,
1,502,swexport-testrepo2-1468196057851987707,yum,REPO2_URL_1468196057851987707,,,,,,,,,


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