Hello,
I have 3 nodes patroni cluster with PG12.6 on RHEL 7.9.
I encountered an error indicating that the database has entered recovery mode. I didn't understand why this happened.
There are no similar error messages before the error, such INFO-ERROR-WARNING-FATAL so on.
Moreover, I run vacuumdb in crontab everyday. (vacuumdb -a -j12 -z --skip-locked)
>>> Do you think vacuumdb could be the case that this is causing such an error?
>>> What else could cause this autovacuum launcher process to exit?
2021-09-10 01:00:33.356 110257 LOG: autovacuum launcher process (PID 156668) exited with exit code 1
2021-09-10 01:00:33.356 110257 LOG: terminating any other active server processes
2021-09-10 01:00:33.447 10.26.105.11 aioc aioc pgmoon 144929 idle WARNING: terminating connection because of crash of another server process
2021-09-10 01:00:33.447 10.26.105.11 aioc aioc pgmoon 144929 idle DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally an
d possibly corrupted shared memory.
2021-09-10 01:00:33.447 10.26.105.11 aioc aioc pgmoon 144929 idle HINT: In a moment you should be able to reconnect to the database and repeat your command.
2021-09-10 01:00:33.448 10.26.105.14 aioc aioc pgmoon 144895 idle WARNING: terminating connection because of crash of another server process
2021-09-10 01:00:33.448 10.26.105.14 aioc aioc pgmoon 144895 idle DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally an
d possibly corrupted shared memory.
I have 3 nodes patroni cluster with PG12.6 on RHEL 7.9.
I encountered an error indicating that the database has entered recovery mode. I didn't understand why this happened.
There are no similar error messages before the error, such INFO-ERROR-WARNING-FATAL so on.
Moreover, I run vacuumdb in crontab everyday. (vacuumdb -a -j12 -z --skip-locked)
>>> Do you think vacuumdb could be the case that this is causing such an error?
>>> What else could cause this autovacuum launcher process to exit?
2021-09-10 01:00:33.356 110257 LOG: autovacuum launcher process (PID 156668) exited with exit code 1
2021-09-10 01:00:33.356 110257 LOG: terminating any other active server processes
2021-09-10 01:00:33.447 10.26.105.11 aioc aioc pgmoon 144929 idle WARNING: terminating connection because of crash of another server process
2021-09-10 01:00:33.447 10.26.105.11 aioc aioc pgmoon 144929 idle DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally an
d possibly corrupted shared memory.
2021-09-10 01:00:33.447 10.26.105.11 aioc aioc pgmoon 144929 idle HINT: In a moment you should be able to reconnect to the database and repeat your command.
2021-09-10 01:00:33.448 10.26.105.14 aioc aioc pgmoon 144895 idle WARNING: terminating connection because of crash of another server process
2021-09-10 01:00:33.448 10.26.105.14 aioc aioc pgmoon 144895 idle DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally an
d possibly corrupted shared memory.
...... (similar lots of log)
Thanks a lot.
Liam
