Thread: could not fork new process and out of memory issues PG 11.5
Hi Support
I experience a "out of memory and could not fork new process " problem on PG 11.5. This problem occur sometimes. On that time the workload not very high.
Linux system have enough free memory. New connection unable to connect to database.
Some connected connection will throw memeory not enough releated errors. I am not clearly what problem caused this issue. I feel I have allocate enough resource to this system.
Would you like to help me narow down this issue ? I attach the logs and database configuration for your reference. Thanks
Env:
PG 11.5
Linux Centos 7.5
Memory: 8G
Totally DB size: 700MB
Errors:
2020-12-26 21:00:47.141 CST,"zabbix","postgres",24739,"127.0.0.1:48814",5fe733ff.60a3,3,"SELECT",2020-12-26 21:00:47 CST,19/442688,0,ERROR,53200,"out of memory","Failed on request of size 200 in memory context ""MessageContext"".",,,,,"select count(*) AS server_connections from pg_stat_activity where backend_type = 'client backend';",,,"psql" 2020-12-26 21:00:47.144 CST,"zabbix","postgres",24739,"127.0.0.1:48814",5fe733ff.60a3,4,"SELECT",2020-12-26 21:00:47 CST,19/442689,0,ERROR,53200,"out of memory","Failed on request of size 16 in memory context ""MessageContext"".",,,,,"select count(*) AS locks_waiting from pg_stat_activity where backend_type = 'client backend' and wait_event_type like '%Lock%';",,,"psql"
2020-12-27 00:28:01.520 CST,,,63552,,5facd1fc.f840,9,,2020-11-12 14:11:08 CST,,0,LOG,00000,"could not fork autovacuum worker process: Cannot allocate memory",,,,,,,,,"" 2020-12-27 00:28:02.521 CST,,,63552,,5facd1fc.f840,10,,2020-11-12 14:11:08 CST,,0,LOG,00000,"could not fork autovacuum worker process: Cannot allocate memory",,,,,,,,,"" 2020-12-27 00:28:03.522 CST,,,63552,,5facd1fc.f840,11,,2020-11-12 14:11:08 CST,,0,LOG,00000,"could not fork autovacuum worker process: Cannot allocate memory",,,,,,,,,"" 2020-12-27 00:28:04.524 CST,,,63552,,5facd1fc.f840,12,,2020-11-12 14:11:08 CST,,0,LOG,00000,"could not fork autovacuum worker process: Cannot allocate memory",,,,,,,,,"" 2020-12-27 00:28:05.525 CST,,,63552,,5facd1fc.f840,13,,2020-11-12 14:11:08 CST,,0,LOG,00000,"could not fork autovacuum worker process: Cannot allocate memory",,,,,,,,,"" 2020-12-27 00:28:06.526 CST,,,63552,,5facd1fc.f840,14,,2020-11-12 14:11:08 CST,,0,LOG,00000,"could not fork autovacuum worker process: Cannot allocate memory",,,,,,,,,"" 2020-12-27 00:28:07.527 CST,,,63552,,5facd1fc.f840,15,,2020-11-12 14:11:08 CST,,0,LOG,00000,"could not fork autovacuum worker process: Cannot allocate memory",,,,,,,,,"" 2020-12-27 00:28:08.528 CST,,,63552,,5facd1fc.f840,16,,2020-11-12 14:11:08 CST,,0,LOG,00000,"could not fork autovacuum worker process: Cannot allocate memory",,,,,,,,,"" 2020-12-27 00:28:09.007 CST,,,63552,,5facd1fc.f840,17,,2020-11-12 14:11:08 CST,,0,LOG,00000,"could not fork new process for connection: Cannot allocate memory",,,,,,,,,"" |
徐志宇（Jack）
Database Engineer
DB Team,ITS. Lenovo China
Phone: 86-18910860709
Email:xuzy13@lenovo.com
No.6 Shangdi West Road, Haidian District Beijing, China, 100085