Satellite throws a traceback error for RHEV Hypervisors

Solution Verified - Updated -

Issue

  • Satellite throws a traceback error for 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',))
  • Database logs shows the error below:
        rhnschema=# select rhn_entitlements.repoll_virt_guest_entitlements(1000020470);
        ERROR:  LIMIT must not be negative
        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
                        )"

Environment

  • Red Hat Satellite 5.6
  • 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