Postgres Pro
Downloads
Home   >   mailing lists

Re: autoovacuum launcher process - Mailing list pgsql-admin

From liam saffioti
Subject Re: autoovacuum launcher process
Date
Msg-id CAGHjuaZLHwK0+8ugyEC40t43Tu799OjcFnLzk00kv29KPhbsxg@mail.gmail.com
Whole thread Raw
In response to Re: autoovacuum launcher process  (Avinash Vallarapu <avinash.vallarapu@gmail.com>)
Responses Re: autoovacuum launcher process
List pgsql-admin
Tree view
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@gmail.com>, 13 Eyl 2021 Pzt, 07:12 tarihinde şunu yazdı:
Hi Liam,

On Mon, Sep 13, 2021 at 12:52 AM liam saffioti <liam.saffiotti@gmail.com> 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@sss.pgh.pa.us>, 12 Eyl 2021 Paz, 17:12 tarihinde şunu yazdı:
liam saffioti <liam.saffiotti@gmail.com> 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. 

pgsql-admin by date:

Previous
From: Avinash Vallarapu
Date:
Subject: Re: autoovacuum launcher process
Next
From: Firthouse banu
Date:
Subject: Table column with numeric and string values