Satellite sync fails with error: "SQLSchemaError: 99999, 'ERROR: function lock_org_counts(integer) does not exist"

Solution Verified - Updated -

Issue

  • satellite-sync command fails with below error:
SQLSchemaError: (99999, 'ERROR:  function lock_org_counts(integer) does not exist', 'LINE 1: SELECT lock_org_counts(1)\n               ^\nHINT:  No function matches the given name and argument types. You might need to add explicit type casts.\n', ProgrammingError('function lock_org_counts(integer) does not exist\nLINE 1: SELECT lock_org_counts(1)\n               ^\nHINT:  No function matches the given name and argument types. You might need to add explicit type casts.\n',))
  • satellite-sync command fails with below traceback
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 236, in main
    ret = method()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 316, in _step_channel_families
    self.syncer.syncCert()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 588, in syncCert
    return self._process_cert(cert, store_cert)
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 613, in _process_cert
    rhnSQL.Procedure('lock_org_counts')(satCerts.get_org_id())
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 112, in __call__
    result = Function.__call__(self, *args)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 89, in __call__
    raise sql_base.SQLSchemaError(error_code, e.pgerror, e)
SQLSchemaError: (99999, 'ERROR:  function lock_org_counts(integer) does not exist', 'LINE 1: SELECT lock_org_counts(1)\n               ^\nHINT:  No function matches the given name and argument types. You might need to add explicit type casts.\n', ProgrammingError('function lock_org_counts(integer) does not exist\nLINE 1: SELECT lock_org_counts(1)\n               ^\nHINT:  No function matches the given name and argument types. You might need to add explicit type casts.\n',))

Environment

  • Red Hat Satellite 5.7

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content