For what reason could the database fail - terminating connection because of crash of another server process?

Question

PostgreSQL

Good afternoon.

I ran into a problem, the connection to the database fell off, opened the log:
/var/log/postgres/postgres-12-main.log
And saw the following logs:

terminating connection because of crash of another server process

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.

In a moment you should be able to reconnect to the database and repeat your command.

[email protected]_name WARNING: terminating connection because of crash of another server process

cat /var/log/syslog | grep postgres  > /var/log/syslog_psql

Oct 29 10:04:52 www [email protected][2737628]: Cluster is not running.
Oct 29 10:04:52 www systemd[1]: [email protected]: Control process exited, code=exited, status=2/INVALIDARGUMENT
Oct 29 10:04:52 www systemd[1]: [email protected] -main.service: Failed with result 'exit-code'.

System log:
https://pastebin.com/R0KY3FND

What could be causing this behavior?

Answer 1

Running out of disk space, OOM, or even a segfault with a lot of luck. Find the details in the database log, they will be before all "terminating connection because of crash of another server process"