engine notifier logs report "PSQLException: FATAL: sorry, too many clients already"
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.