RHVM database is runing out of memory

Solution Verified - Updated -

Issue

  • RHV is behaving inconsistently
  • In the logs, we see:
2020-02-10 18:26:59,526+01 ERROR [org.ovirt.engine.core.bll.SearchQuery] (default task-10) [eef1cab0-4ec3-11ea-9fc0-54e1ad17645a] Query 'SearchQuery' failed: StatementCallback; SQL [SELECT * FROM ((SELECT distinct audit_log.* FROM  audit_log   WHERE not deleted)  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100]; Ran out of memory retrieving query results.; nested exception is org.postgresql.util.PSQLException: Ran out of memory retrieving query results.
2020-02-10 18:26:59,526+01 ERROR [org.ovirt.engine.core.bll.SearchQuery] (default task-10) [eef1cab0-4ec3-11ea-9fc0-54e1ad17645a] Exception: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [SELECT * FROM ((SELECT distinct audit_log.* FROM  audit_log   WHERE not deleted)  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100]; Ran out of memory retrieving query results.; nested exception is org.postgresql.util.PSQLException: Ran out of memory retrieving query results.

Environment

Red Hat Virtualization 4.x

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