Satellite sync fails with error: "SQLSchemaError: 99999, 'ERROR: function lock_org_counts(integer) does not exist"
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.