Satellite throws traceback error for RHEV Hypervisors
Issue
- Satellite throws traceback error messages for Red Hat Enteprise Virtualization (RHEV) Hypervisors
SQL Error generated: (99999, 'ERROR: current transaction is aborted, commands ignored until end of transaction block', '', InternalError('current transaction is aborted, commands ignored until end of transaction block\n',))
Exception Handler Information
Traceback (most recent call last):
File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py", line 122, in call_function
response = func(*params)
File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 913, in virt_notify
rhnVirtualization._virt_notify(server_id, actions)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnVirtualization.py", line 806, in _virt_notify
handler.handle(server_id, action)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnVirtualization.py", line 211, in handle
handler(system_id, timestamp, properties)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnVirtualization.py", line 241, in _handle_domain_exists
row = self.__db_get_domain(system_id, uuid)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnVirtualization.py", line 513, in __db_get_domain
query.execute(host_id = host_id, uuid = uuid)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 147, in execute
return self._execute_wrapper(self._execute, *p, **kw)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 292, in _execute_wrapper
raise sql_base.SQLSchemaError(error_code, e.pgerror, e)
SQLSchemaError: (99999, 'ERROR: current transaction is aborted, commands ignored until end of transaction block', '', InternalError('current transaction is aborted, commands ignored until end of transaction block\n',))
- PostgreSQL logs shows the error on the
rhn_entitlements.repoll_virt_guest_entitlements
PL/SQL:
2015-03-10 23:44:02.343 EDT ERROR: LIMIT must not be negative
2015-03-10 23:44:02.343 EDT CONTEXT: SQL statement "UPDATE rhnServerChannel sc set is_fve = 'Y'
where sc.server_id in (
select vi.virtual_system_id
from rhnServerFveCapable sfc
inner join rhnVirtualInstance vi on vi.virtual_system_id = sfc.server_id
where vi.host_system_id = server_id_in
and sfc.channel_family_id = family.channel_family_id
order by vi.modified desc
limit free_slots
)"
PL/pgSQL function rhn_entitlements.repoll_virt_guest_entitlements(numeric) line 102 at SQL statement
2015-03-10 23:44:02.343 EDT STATEMENT: SELECT rhn_entitlements.repoll_virt_guest_entitlements(1000020471)
2015-03-10 23:44:02.345 EDT ERROR: current transaction is aborted, commands ignored until end of transaction block
Environment
- Red Hat Satellite 5.7
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.