Bug 1412617

Summary: cdn-sync --count-package doesn't work with oracle backend
Product: Red Hat Satellite 5 Reporter: Pavel Studeník <pstudeni>
Component: Satellite SynchronizationAssignee: Gennadii Altukhov <galtukho>
Status: CLOSED CURRENTRELEASE QA Contact: Pavel Studeník <pstudeni>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 580CC: galtukho, rdrazny, tlestach
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: spacewalk-backend-2.5.3-49-sat Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-06-21 12:17:31 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: 1340444    

Description Pavel Studeník 2017-01-12 12:56:57 UTC
Description of problem:
I try to count packages for syncing on satellite 5.8 with oracle db.

>> cdn-sync --count-package
07:53:35 Number of channels: 1417
07:53:35 Number of repositories: 1575
Traceback (most recent call last):
  File "/usr/bin/cdn-sync", line 159, in <module>
    sys.exc_info()[2])
  File "/usr/bin/cdn-sync", line 107, in <module>
    cdnsync.count_packages(channels=args.channel)
  File "/usr/lib/python2.6/site-packages/spacewalk/cdn_tools/cdnsync.py", line 354, in count_packages
    yum_repo = self._create_yum_repo(source)
  File "/usr/lib/python2.6/site-packages/spacewalk/cdn_tools/cdnsync.py", line 247, in _create_yum_repo
    repo_plugin.set_ssl_options(str(keys['ca_cert']), str(keys['client_cert']), str(keys['client_key']))
Exception: SYNC ERROR: attempting to display as much information as possible
 LOB variable no longer valid after subsequent fetch

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

Version-Release number of selected component (if applicable):
spacewalk-backend-cdn-2.5.3-48.el6sat.noarch

How reproducible:
oracle

Steps to Reproduce:
1. activate satellite
2. sync some channels from cdn
3. try to count packages

Actual results:
error

Expected results:
it works

Comment 1 Gennadii Altukhov 2017-01-12 15:43:16 UTC
patch is available in upstream, spacewalk.git:
e57b709301244fed2315c5934985c1c566e700f6

Comment 4 Pavel Studeník 2017-03-22 14:56:35 UTC
Verified spacewalk-backend-cdn-2.5.3-87.el6sat.noarch