LoginSignup
0
0

More than 1 year has passed since last update.

Docker PostgreSQLのエラー PANIC: could not locate a valid checkpoint record

Posted at

Docker PostgreSQLで
今まで普通に動いていたのに、急に動かなくなった

db_1   | 
db_1   | PostgreSQL Database directory appears to contain a database; Skipping initialization
db_1   | 
db_1   | 2022-08-30 06:07:15.130 UTC [1] LOG:  starting PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
db_1   | 2022-08-30 06:07:15.130 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
db_1   | 2022-08-30 06:07:15.130 UTC [1] LOG:  listening on IPv6 address "::", port 5432
db_1   | 2022-08-30 06:07:15.135 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1   | 2022-08-30 06:07:15.171 UTC [27] LOG:  database system was shut down at 2022-08-30 02:50:13 UTC
db_1   | 2022-08-30 06:07:15.180 UTC [27] LOG:  record length 2013368472 at 0/7BDF4248 too long
db_1   | 2022-08-30 06:07:15.180 UTC [27] LOG:  invalid primary checkpoint record
db_1   | 2022-08-30 06:07:15.180 UTC [27] PANIC:  could not locate a valid checkpoint record
db_1   | 2022-08-30 06:07:15.181 UTC [1] LOG:  startup process (PID 27) was terminated by signal 6: Aborted
db_1   | 2022-08-30 06:07:15.181 UTC [1] LOG:  aborting startup due to startup process failure
db_1   | 2022-08-30 06:07:15.184 UTC [1] LOG:  database system is shut down
backend_db_1 exited with code 1

dockerの設定ファイルなど、いろんな記事を見て変更したが、変わらず。。。。。

解決手順

backend/tmp/db 配下を削除後、
再度
db:create
で解決

dbで不整合が起こっていたみたい

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0