Satellite throws traceback error for RHEV Hypervisors

Solution Verified - Updated -

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.

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