[Spacewalk-list] reposync error

[Thomas Bendler]

Hi @all,

I got a strange reposync error when I try to update a FC channel:

8/385 : wine-common-1.1.38-1.fc12-0.noarch
ERRORException reported from sw.xxxx.de
Time: Fri Feb 19 17:45:26 2010
Exception type server.rhnSQL.sql_base.SQLError

Exception Handler Information
Traceback (most recent call last):
  File "/usr/share/rhn/satellite_tools/reposync.py", line 136, in
import_packages
    self.upload_package(pack, path)
  File "/usr/share/rhn/satellite_tools/reposync.py", line 170, in
upload_package
    org_id=self.channel['org_id'])
  File "/usr/share/rhn/server/rhnPackageUpload.py", line 171, in
push_package
    importer.run()
  File "/usr/share/rhn/server/importlib/importLib.py", line 655, in run
    self.fix()
  File "/usr/share/rhn/server/importlib/packageImport.py", line 296, in fix
    ChannelPackageSubscription.fix(self)
  File "/usr/share/rhn/server/importlib/packageImport.py", line 67, in fix
    self.backend.lookupChecksums(self.checksums)
  File "/usr/share/rhn/server/importlib/backend.py", line 432, in
lookupChecksums
    h.execute(ctype=ctype, csum=csum)
  File "/usr/share/rhn/server/rhnSQL/sql_base.py", line 168, in execute
    return apply(self._execute_wrapper, (self._execute, ) + p, kw)
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 119, in
_execute_wrapper
    raise apply(sql_base.SQLError, ret)
SQLError: (1422, 'ORA-01422: exact fetch returns more than requested number
of rows\nORA-06512: at "SPACEWALK.LOOKUP_CHECKSUM", line 12\n', 'select
lookup_checksum(:ctype, :csum) id from dual')

I got this error multiple times but only with this one FC channel. Somebody
know how to fix? Look like, this is a SQL statement that return more than
one value but expect only one.

Kind regards, Thomas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100219/c597e7a8/attachment.htm>