Re: autoovacuum launcher process

From: Avinash Vallarapu <avinash(dot)vallarapu(at)gmail(dot)com>
To: liam saffioti <liam(dot)saffiotti(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: autoovacuum launcher process
Date: 2021-09-13 04:11:48
Message-ID: CAN0Tujckx4ZVxZUhr3EkrVOBDny+8-RTAqhXUL-GWbNT0Sm3Ow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Liam,

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message liam saffioti 2021-09-13 05:03:58 Re: autoovacuum launcher process
Previous Message liam saffioti 2021-09-13 03:52:26 Re: autoovacuum launcher process