From: | Gena Makhomed <makhomed(at)gmail(dot)com> |
---|---|
To: | pgsql-pkg-yum(at)lists(dot)postgresql(dot)org |
Subject: | systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL. |
Date: | 2024-02-25 08:50:15 |
Message-ID: | CAKYxhBmpx8-ch_38EprbEMu3G3sYm=-eZUySLzW5xP3B1bexuw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-pkg-yum |
Previously posted to pgsql-bugs mail list
<https://www.postgresql.org/message-id/18361-1a3f843f5f6ce694%40postgresql.org>
as BUG #18361, but as I understand later, this may not be the PostgreSQL
bug itself, but it may be the rpm/yum/dnf packaging bug?
Can you please help to fix this bug, or find a workaround?
Because killing postgres via SIGKILL is not a good idea.
---------- Forwarded message ---------
От: PG Bug reporting form <noreply(at)postgresql(dot)org>
Date: сб, 24 февр. 2024 г. в 14:52
Subject: BUG #18361: systemd[1]: postgresql-16.service: Killing process
25992 (postgres) with signal SIGKILL.
To: <pgsql-bugs(at)lists(dot)postgresql(dot)org>
The following bug has been logged on the website:
Bug reference: 18361
PostgreSQL version: 16.2
Operating system: Rocky Linux release 9.3
Description:
PostgreSQL 16.2 installed on the Rocky Linux release 9.3 server from
official repository with official instruction from page
https://www.postgresql.org/download/linux/redhat/
when I execute command
# systemctl stop postgresql-16.service ; systemctl status
postgresql-16.service
I see, what PostgreSQL 16.2 was killed by SIGKILL.
this is a bug, as I understand, because database will be corrupted.
Is it possible to fix this bug and stop killing PostgreSQL with signal
SIGKILL ?
# systemctl stop postgresql-16.service ; systemctl status
postgresql-16.service
○ postgresql-16.service - PostgreSQL 16 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-16.service; enabled;
preset: disabled)
Active: inactive (dead) since Sat 2024-02-24 12:47:19 UTC; 6ms ago
Duration: 3.525s
Docs: https://www.postgresql.org/docs/16/static/
Process: 26666 ExecStartPre=/usr/pgsql-16/bin/postgresql-16-check-db-dir
${PGDATA} (code=exited, status=0/SUCCESS)
Process: 26671 ExecStart=/usr/pgsql-16/bin/postgres -D ${PGDATA}
(code=exited, status=0/SUCCESS)
Main PID: 26671 (code=exited, status=0/SUCCESS)
CPU: 43ms
Feb 24 12:47:15 postgres-16.example.net systemd[1]: Starting PostgreSQL 16
database server...
Feb 24 12:47:15 postgres-16.example.net postgres[26671]: 2024-02-24
12:47:15.985 UTC [26671] LOG: redirecting log output to logging collector
process
Feb 24 12:47:15 postgres-16.example.net postgres[26671]: 2024-02-24
12:47:15.985 UTC [26671] HINT: Future log output will appear in directory
"log".
Feb 24 12:47:15 postgres-16.example.net systemd[1]: Started PostgreSQL 16
database server.
Feb 24 12:47:19 postgres-16.example.net systemd[1]: Stopping PostgreSQL 16
database server...
Feb 24 12:47:19 postgres-16.example.net systemd[1]: postgresql-16.service:
Killing process 26672 (postgres) with signal SIGKILL.
Feb 24 12:47:19 postgres-16.example.net systemd[1]: postgresql-16.service:
Deactivated successfully.
Feb 24 12:47:19 postgres-16.example.net systemd[1]: Stopped PostgreSQL 16
database server.
--
*Please consider the environment before printing*
From | Date | Subject | |
---|---|---|---|
Next Message | Tender Wang | 2024-02-25 13:32:43 | "type with xxxx does not exist" when doing ExecMemoize() |
Previous Message | Thomas Munro | 2024-02-25 03:21:36 | Re: BUG #18362: unaccent rules and Old Greek text |
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2024-02-26 09:19:09 | Re: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL. |
Previous Message | PG Bug reporting form | 2024-02-24 12:51:42 | BUG #18361: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL. |