Satellite-sync on Red Hat Satellite 5.x is failing with "ProgrammingError: function lookup_checksum_fast(unknown, unknown) does not exist" error.

Solution Unverified - Updated -

Issue

  • Satellite-sync is failing with below traceback:
Exception Handler Information
Traceback (most recent call last):
  File "/usr/bin/satellite-sync", line 139, in main
    return satsync.Runner().main()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 229, in main
    ret = method()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 343, in _step_packages
    self._affected_channels = self.syncer.import_packages()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1603, in import_packages
    return self._link_channel_packages()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1632, in _link_channel_packages
    importer = sync_handlers.link_channel_packages(uq_pkg_data)
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/sync_handlers.py", line 393, in link_channel_packages
    importer.run()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", line 646, in run
    self.fix()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", line 74, in fix
    self.backend.lookupChecksums(self.checksums)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backendOracle.py", line 686, in lookupChecksums
    raise e
ProgrammingError: function lookup_checksum_fast(unknown, unknown) does not exist
LINE 1: select lookup_checksum_fast(E'md5', E'732bd90ddce0648830539a...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Environment

  • Red Hat Satellite 5.x
  • satellite-sync

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.