https://bugs.koozali.org/show_bug.cgi?id=12355
Bug ID: 12355
Summary: Shutdown errors detected and logged during shutdown of
Postgres 13.
Classification: Contribs
Product: SME Contribs
Version: 10.0
Hardware: ---
OS: ---
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: smeserver-postgresql
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Target Milestone: ---
Shutting down postgres (systemctl stop postgresql-13) causes errors in the
database as it is not shut down properly. Here is a log snip:
2023-05-14 07:59:07.995 +04 [34429] LOG: received smart shutdown request
2023-05-14 08:00:12.527 +04 [39095] LOG: starting PostgreSQL 13.11 on
x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.
8.5-44), 64-bit
2023-05-14 08:00:12.527 +04 [39095] LOG: listening on IPv4 address "0.0.0.0",
port 50750
2023-05-14 08:00:12.527 +04 [39095] LOG: listening on IPv6 address "::", port
50750
2023-05-14 08:00:12.532 +04 [39095] LOG: listening on Unix socket
"/var/run/postgresql/.s.PGSQL.50750"
2023-05-14 08:00:12.549 +04 [39095] LOG: listening on Unix socket
"/tmp/.s.PGSQL.50750"
2023-05-14 08:00:12.557 +04 [39097] LOG: database system was interrupted; last
known up at 2023-05-14 07:54:44 +04
2023-05-14 08:00:13.189 +04 [39097] LOG: recovered replication state of node 1
to 7/B0FB2778
2023-05-14 08:00:13.189 +04 [39097] LOG: database system was not properly shut
down; automatic recovery in progress
2023-05-14 08:00:13.193 +04 [39097] LOG: redo starts at 0/7CEECB8
2023-05-14 08:00:13.193 +04 [39097] LOG: invalid record length at 0/7CEEDA0:
wanted 24, got 0
2023-05-14 08:00:13.193 +04 [39097] LOG: redo done at 0/7CEED68
2023-05-14 08:00:13.222 +04 [39095] LOG: database system is ready to accept
connections
2023-05-14 08:00:13.251 +04 [39104] LOG: logical replication apply worker for
subscription "pops_sub" has started
Version 12 of PG did not do this.
2023-05-13 20:59:23.925 PDT [41882] LOG: received fast shutdown request
2023-05-13 20:59:23.929 PDT [41882] LOG: aborting any active transactions
2023-05-13 20:59:23.929 PDT [41892] FATAL: terminating connection due to
administrator command
2023-05-13 20:59:23.930 PDT [42862] FATAL: terminating connection due to
administrator command
2023-05-13 20:59:23.936 PDT [41882] LOG: background worker "logical
replication launcher" (PID 41890) exited with exit code 1
2023-05-13 20:59:23.939 PDT [41885] LOG: shutting down
2023-05-13 20:59:24.050 PDT [41882] LOG: database system is shut down
2023-05-13 20:59:34.854 PDT [43656] LOG: database system was shut down at
2023-05-13 20:59:23 PDT
2023-05-13 20:59:34.876 PDT [43653] LOG: database system is ready to accept
connections
--
You are receiving this mail because:
You are the QA Contact for the bug.
You are the assignee for the bug._______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at https://lists.contribs.org/mailman/public/contribteam/
