autoovacuum launcher process

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

Responses

Browse pgsql-admin by date

  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