Re: autoovacuum launcher process

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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. 

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux