Satellite sync fails with error: "SQLSchemaError: 99999, 'ERROR: function lock_org_counts(integer) does not exist"
Issue
satellite-synccommand 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-synccommand 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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
