From: | Vikas Sharma <shavikas(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child |
Date: | 2019-02-12 16:20:09 |
Message-ID: | CAN6gwKziTexwb4t8eN4SWVL0Jk-DzxJ4txxSVT2gPouALyFeLQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello All,
I have a 4 node PostgreSQL 9.6 cluster with streaming replication. we
encounter today the Out of Memory Error on the Master which resulted in
All postres processes restarted and cluster recovered itself. Please let
me know the best way to diagnose this issue.
The error seen in the postgresql log:
2019-02-12 10:55:17 GMT LOG: terminating any other active server processes
2019-02-12 10:55:17 GMT WARNING: terminating connection because of crash
of another server process
2019-02-12 10:55:17 GMT DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2019-02-12 10:55:17 GMT HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2019-02-12 10:55:17 GMT WARNING: terminating connection because of crash
of another server process
2019-02-12 10:55:17 GMT DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2019-02-12 10:55:17 GMT HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2019-02-12 10:55:17 GMT WARNING: terminating connection because of crash
of another server process
-----
Error from dmesg on linux:
-----------------------------------
[4331093.885622] Out of memory: Kill process nnnnn (postmaster) score nn or
sacrifice child
[4331093.890225] Killed process nnnnn (postmaster) total-vm:18905944kB,
anon-rss:1747460kB, file-rss:4kB, shmem-rss:838220kB
Thanks & Best Regards
Vikas Sharma
From | Date | Subject | |
---|---|---|---|
Next Message | pabloa98 | 2019-02-12 16:31:11 | Re: postgresql v11.1 Segmentation fault: signal 11: by running SELECT... JIT Issue? |
Previous Message | Alvaro Aguayo Garcia-Rada | 2019-02-12 15:14:41 | Re: BDR 1.0: background worker wants to start that should not be there |