From: | liam saffioti <liam(dot)saffiotti(at)gmail(dot)com> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | autoovacuum launcher process |
Date: | 2021-09-12 10:03:23 |
Message-ID: | CAGHjuabpW8M=h=1FfCR9LgAFGASMKKnz+kE7d5oqNMvSOsOcxA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
...... (similar lots of log)
Thanks a lot.
Liam
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-09-12 14:12:23 | Re: autoovacuum launcher process |
Previous Message | Gokan Atmaca | 2021-09-11 15:41:28 | Re: PgBackRest PITR restore |