Re: autoovacuum launcher process

[liam saffioti <liam.saffiotti@xxxxxxxxx>]

Ok, my extensions list is;

 hypopg            
 pg_buffercache    
 pg_partman        
 pg_stat_kcache    
 pg_stat_statements

timescaledb

powa

postgres_fdw

btree_gin

btree_gist

plpythonu

uuid-ossp

plpgsql

>> It would also be wise to look at dmesg or /var/log/messages and see if there is anything interesting around what could have terminated one of the processes. 

I looked /var/log/messages, I suspected OOM killer, but there is no any log about it, or "terminate" etc.

Sep 10 01:00:41 pg_rhel02 patroni: 2021-09-10 01:00:41,186 INFO: Lock owner: pg_rhel02; I am pg_rhel02
Sep 10 01:00:41 pg_rhel02 patroni: 2021-09-10 01:00:41,667 INFO: establishing a new patroni connection to the postgres cluster
Sep 10 01:00:44 pg_rhel02 patroni: 2021-09-10 01:00:44,708 WARNING: Retry got exception: 'connection problems'
Sep 10 01:00:45 pg_rhel02 journal: Suppressed 89852 messages from /system.slice/auditd.service
Sep 10 01:00:47 pg_rhel02 patroni: localhost:5432 - no response
Sep 10 01:00:47 pg_rhel02 patroni: 2021-09-10 01:00:47,764 INFO: Error communicating with PostgreSQL. Will try again later
Sep 10 01:00:51 pg_rhel02 patroni: 2021-09-10 01:00:51,186 INFO: Lock owner: pg_rhel02; I am pg_rhel02
Sep 10 01:00:51 pg_rhel02 patroni: 2021-09-10 01:00:51,186 INFO: establishing a new patroni connection to the postgres cluster
Sep 10 01:00:54 pg_rhel02 patroni: 2021-09-10 01:00:54,832 INFO: establishing a new patroni connection to the postgres cluster
Sep 10 01:00:57 pg_rhel02 patroni: 2021-09-10 01:00:57,837 WARNING: Retry got exception: 'connection problems'
Sep 10 01:01:00 pg_rhel02 patroni: localhost:5432 - no response

Avinash Vallarapu <avinash.vallarapu@xxxxxxxxx>, 13 Eyl 2021 Pzt, 07:12 tarihinde şunu yazdı:

Hi Liam,

On Mon, Sep 13, 2021 at 12:52 AM liam saffioti <liam.saffiotti@xxxxxxxxx> wrote:

Hello again,

I grepped the db log with PID 156668, the result is below;

# more pg_cluster-Fri.log | grep 156668
2021-09-10 01:00:32.691     156668  FATAL:  cannot read pg_class without having selected a database

Though it sounds like an unrelated question, what is the unique list of extensions you got in all your database(s) ?

\dx

2021-09-10 01:00:33.356     110257  LOG:  autovacuum launcher process (PID 156668) exited with exit code 1

It would also be wise to look at dmesg or /var/log/messages and see if there is anything interesting around what could have terminated one of the processes. 

sincerely,

Liam

Tom Lane <tgl@xxxxxxxxxxxxx>, 12 Eyl 2021 Paz, 17:12 tarihinde şunu yazdı:

liam saffioti <liam.saffiotti@xxxxxxxxx> writes:
> 2021-09-10 01:00:33.356     110257  LOG:  autovacuum launcher process (PID
> 156668) exited with exit code 1

The interesting log entry(s) would be before this one.  You sure PID
156668 didn't log anything before dying?

                        regards, tom lane

--

Regards,
Avinash Vallarapu

CEO

MigOps, Inc.