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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In