BUG #17093: invalid primary checkpoint record

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17093: invalid primary checkpoint record
Дата
Msg-id 17093-3d9fd04cfa74d04a@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17093: invalid primary checkpoint record  (Mohan Nagandlla <nagandllamohan@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17093
Logged by:          Mohan nagandlla
Email address:      nagandllamohan@gmail.com
PostgreSQL version: 13.3
Operating system:   Alpine
Description:

HI Team i am facing this issue "invalid primary checkpoint record" more
times. When i got this error i am doing pg_resetwal -f . the wal showing
success and server also running fine. But after some time again the issue is
repeating. I am not sure why this is happening most frequently. 
```
2021-07-08 04:16:24.729 UTC [22167] LOG:  starting PostgreSQL 13.2 on
x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203,
64-bit
2021-07-08 04:16:24.729 UTC [22167] LOG:  listening on IPv4 address
"0.0.0.0", port 5432
2021-07-08 04:16:24.729 UTC [22167] LOG:  listening on IPv6 address "::",
port 5432
2021-07-08 04:16:24.732 UTC [22167] LOG:  listening on Unix socket
"/tmp/.s.PGSQL.5432"
2021-07-08 04:16:24.777 UTC [22168] LOG:  database system was interrupted;
last known up at 2021-07-08 01:52:08 UTC
2021-07-08 04:16:33.441 UTC [22168] LOG:  invalid primary checkpoint
record
2021-07-08 04:16:33.441 UTC [22168] PANIC:  could not locate a valid
checkpoint record
2021-07-08 04:16:33.443 UTC [22167] LOG:  startup process (PID 22168) was
terminated by signal 6: Aborted
2021-07-08 04:16:33.443 UTC [22167] LOG:  aborting startup due to startup
process failure
2021-07-08 04:16:33.448 UTC [22167] LOG:  database system is shut down
2021-07-08 04:16:53.617 UTC [22332] LOG:  starting PostgreSQL 13.2 on
x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203,
64-bit
2021-07-08 04:16:53.617 UTC [22332] LOG:  listening on IPv4 address
"0.0.0.0", port 5432
2021-07-08 04:16:53.617 UTC [22332] LOG:  listening on IPv6 address "::",
port 5432
2021-07-08 04:16:53.619 UTC [22332] LOG:  listening on Unix socket
"/tmp/.s.PGSQL.5432"
2021-07-08 04:16:53.662 UTC [22333] LOG:  database system was interrupted;
last known up at 2021-07-08 01:52:08 UTC
2021-07-08 04:16:57.053 UTC [22352] FATAL:  the database system is starting
up
2021-07-08 04:16:57.055 UTC [22353] FATAL:  the database system is starting
up
2021-07-08 04:17:00.985 UTC [22333] LOG:  invalid primary checkpoint
record
2021-07-08 04:17:00.985 UTC [22333] PANIC:  could not locate a valid
checkpoint record
2021-07-08 04:17:00.987 UTC [22332] LOG:  startup process (PID 22333) was
terminated by signal 6: Aborted
2021-07-08 04:17:00.987 UTC [22332] LOG:  aborting startup due to startup
process failure
2021-07-08 04:17:00.992 UTC [22332] LOG:  database system is shut down
2021-07-08 04:17:31.189 UTC [22540] LOG:  starting PostgreSQL 13.2 on
x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203,
64-bit
2021-07-08 04:17:31.189 UTC [22540] LOG:  listening on IPv4 address
"0.0.0.0", port 5432
2021-07-08 04:17:31.189 UTC [22540] LOG:  listening on IPv6 address "::",
port 5432
2021-07-08 04:17:31.192 UTC [22540] LOG:  listening on Unix socket
"/tmp/.s.PGSQL.5432"
2021-07-08 04:17:31.259 UTC [22541] LOG:  database system was interrupted;
last known up at 2021-07-08 01:52:08 UTC
2021-07-08 04:17:35.643 UTC [22560] FATAL:  the database system is starting
up
2021-07-08 04:17:35.644 UTC [22561] FATAL:  the database system is starting
up
2021-07-08 04:17:38.812 UTC [22541] LOG:  invalid primary checkpoint
record
2021-07-08 04:17:38.812 UTC [22541] PANIC:  could not locate a valid
checkpoint record
2021-07-08 04:17:38.813 UTC [22540] LOG:  startup process (PID 22541) was
terminated by signal 6: Aborted
2021-07-08 04:17:38.813 UTC [22540] LOG:  aborting startup due to startup
process failure
2021-07-08 04:17:38.818 UTC [22540] LOG:  database system is shut down
```


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17088: FailedAssertion in prepagg.c
Следующее
От: Richard Guo
Дата:
Сообщение: Re: BUG #17088: FailedAssertion in prepagg.c