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.
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 |