Обсуждение: BUG #17666: Unexpected shutdown

Поиск
Список
Период
Сортировка

BUG #17666: Unexpected shutdown

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      17666
Logged by:          Carlos Gonzalez
Email address:      carlos.gonzalez@nologin.es
PostgreSQL version: 11.13
Operating system:   Red Hat Enterprise Linux Server release 7.9 (Maipo
Description:

Good morning,

Last October 2nd the postgresql service shut down the database
unexpectedly.

We only have this entry in the log file. Please, is there any way to
investigate the problem with so little information?

2022-10-02 04:33:18.884 CDT pid: [9246] db:  user:  id: 6231c4b5.241e
sqlstate: 00000 > LOG:  received immediate shutdown request

Thank you very much


Re: BUG #17666: Unexpected shutdown

От
Tom Lane
Дата:
PG Bug reporting form <noreply@postgresql.org> writes:
> Last October 2nd the postgresql service shut down the database
> unexpectedly.
> We only have this entry in the log file. Please, is there any way to
> investigate the problem with so little information?

> 2022-10-02 04:33:18.884 CDT pid: [9246] db:  user:  id: 6231c4b5.241e
> sqlstate: 00000 > LOG:  received immediate shutdown request

That is a commanded shutdown: something sent the postmaster process
a SIGQUIT signal.  The cause is very unlikely to be within Postgres
itself.  You should be thinking in terms of operator error or a
misbehaving administrative script.

            regards, tom lane