engine notifier logs report "PSQLException: FATAL: sorry, too many clients already"

Solution Verified - Updated -

Issue

  • engine notifier logs in /var/log/ovirt-engine/notifier/notifier.log report "PSQLException: FATAL: sorry, too many clients already".

  • Too many connections to postgres database are made.

netstat output:

$ netstat -tp | grep $( ps -fuovirt | grep org.ovirt.engine.core.notifier.Notifier | awk '{ print $2 }' )
tcp        0      0 localhost:50894             localhost:postgres          ESTABLISHED 59332/java
tcp        0      0 localhost:49948             localhost:postgres          ESTABLISHED 59332/java
tcp        0      0 localhost:50614             localhost:postgres          ESTABLISHED 59332/java
tcp        0      0 localhost:51137             localhost:postgres          ESTABLISHED 59332/java
tcp        0      0 localhost:51219             localhost:postgres          ESTABLISHED 59332/java
tcp        0      0 localhost:51243             localhost:postgres          ESTABLISHED 59332/java
tcp        0      0 localhost:50600             localhost:postgres          ESTABLISHED 59332/java
tcp        0      0 localhost:50260             localhost:postgres          ESTABLISHED 59332/java
.
.

ps output:

postgres 59345 48052  0 Jan24 ?        Ss     0:00  \_ postgres: engine engine 127.0.0.1(49940) idle
postgres 59346 48052  0 Jan24 ?        Ss     0:00  \_ postgres: engine engine 127.0.0.1(49941) idle
postgres 59349 48052  0 Jan24 ?        Ss     0:00  \_ postgres: engine engine 127.0.0.1(49942) idle
postgres 59472 48052  0 Jan24 ?        Ss     0:00  \_ postgres: engine engine 127.0.0.1(49944) idle
postgres 59483 48052  0 Jan24 ?        Ss     0:00  \_ postgres: engine engine 127.0.0.1(49945) idle
postgres 59494 48052  0 Jan24 ?        Ss     0:00  \_ postgres: engine engine 127.0.0.1(49947) idle
postgres 59511 48052  0 Jan24 ?        Ss     0:00  \_ postgres: engine engine 127.0.0.1(49948) idle
postgres 59522 48052  0 Jan24 ?        Ss     0:00  \_ postgres: engine engine 127.0.0.1(49950) idle
postgres 59536 48052  0 Jan24 ?        Ss     0:00  \_ postgres: engine engine 127.0.0.1(49951) idle
postgres 59547 48052  0 Jan24 ?        Ss     0:00  \_ postgres: engine engine 127.0.0.1(49952) idle
  • The number of connections/process reduce to normal when engine-notifierd service is restarted.

Environment

  • Red Hat Enterprise Virtualization (RHEV) 3.1

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