RHEV-M reports ceases to work after some time

Solution Unverified - Updated -

Issue

The reports portal was found to be unavailable.

Both the data warehouse service and the jasperserver logs had references to database connections exhaustion, e.g:

ovirt-engine-dwhd.log:2014-02-06 19:00:24|PanvZ8|NaG6rr|EOxIEr|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java Exception|tJDBCConnection_1|org.postgresql.util.PSQLException:FATAL: sorry, too many clients already|1

server.log:2014-02-06 17:32:19,283 INFO  [stdout] (ServerService Thread Pool -- 37) Caused by: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already

A restart of the data warehouse service allowed it to continue, but the reports portal was still inaccessible.

Environment

  • Red Hat Enterprise Virtualization (RHEV) 3.2
  • Remote (external) PostgreSQL database for RHEV

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