- Welcome BMC Customer Support Site Guest User
Knowledge Article
Control-M Server for Unix and Microsoft Windows, installed on AIX and using dedicated PostgreSQL database crashes due error message “sorry, too many clients already”
Control-M Server for Unix and Microsoft Windows, installed on AIX and using dedicated PostgreSQL database crashes due error message “sorry, too many clients already”
Control-M/Server for UNIX and Microsoft Windows
Control-M/Server for UNIX and Microsoft Windows
Control-M Server 9.0.19, 9.0.20.000, 9.0.21.000 and 9.0.21.100
The Control-M Server Postgres database crashes with error message “sorry, too many clients already” Several messages can be seen in databases logs EDTFATAL: sorry, too many clients already EDTFATAL: sorry, too many clients already EDTFATAL: sorry, too many clients already EDTFATAL: sorry, too many clients already EDTFATAL: sorry, too many clients already Control-M Server may continue working for some time but eventually database will become unresponsive and crashes, it's necessary to recycle the host machine to have the database working again |
CTM-3653 & CTM-9416 on AIX - PG - Control-M/Server CE process creates many new database connections, and eventually the PG server returns the error “sorry, too many clients already” to attempts to create a new connection
CTM-3653 and CTM-9416 were created for this issue and the problem is resolved when upgrading PG to 15.3 that supports memory type “sysv”. if Dedicated PG is used then upgrade Control-M/Server to 9.0.21.200 and then upgrade PG to 15.3. Add the line: shared_memory_type=sysv to postgresql.conf file • Requires DB restart • PG 10.4, unlike previous versions comes bundled with shared_memory_type “mmap” • AIX cannot really support “mmap” for very frequest logins/logouts. It requires the value of “sysv”.which is supported from PG 15.3 |
Attachment(s):