postgresql - 恐慌:无法在 postgres 13.2 上找到有效的检查点记录
问题描述
无法重新启动 postgres 13.2-alpine 映像。
PostgreSQL 数据库目录似乎包含一个数据库;跳过初始化
2021-05-06 03:45:04.728 UTC [1] 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-05-06 03:45:04.730 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2021-05-06 03:45:04.731 UTC [1] LOG: listening on IPv6 address "::", port 5432
2021-05-06 03:45:04.737 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-05-06 03:45:04.745 UTC [20] LOG: database system was shut down at 2021-05-06 03:26:11 UTC
2021-05-06 03:45:04.745 UTC [20] LOG: invalid resource manager ID 58 at 0/1933908
2021-05-06 03:45:04.745 UTC [20] LOG: invalid primary checkpoint record
2021-05-06 03:45:04.745 UTC [20] PANIC: could not locate a valid checkpoint record
2021-05-06 03:45:04.977 UTC [1] LOG: startup process (PID 20) was terminated by signal 6: Aborted
2021-05-06 03:45:04.977 UTC [1] LOG: aborting startup due to startup process failure
2021-05-06 03:45:04.979 UTC [1] LOG: database system is shut down
PostgreSQL Database directory appears to contain a database; Skipping initialization
2021-05-06 03:45:12.426 UTC [1] 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-05-06 03:45:12.428 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2021-05-06 03:45:12.429 UTC [1] LOG: listening on IPv6 address "::", port 5432
2021-05-06 03:45:12.434 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-05-06 03:45:12.440 UTC [20] LOG: database system was shut down at 2021-05-06 03:26:11 UTC
2021-05-06 03:45:12.440 UTC [20] LOG: invalid resource manager ID 58 at 0/1933908
2021-05-06 03:45:12.440 UTC [20] LOG: invalid primary checkpoint record
2021-05-06 03:45:12.440 UTC [20] PANIC: could not locate a valid checkpoint record
2021-05-06 03:45:12.679 UTC [1] LOG: startup process (PID 20) was terminated by signal 6: Aborted
2021-05-06 03:45:12.679 UTC [1] LOG: aborting startup due to startup process failure
2021-05-06 03:45:12.681 UTC [1] LOG: database system is shut down
解决方案
推荐阅读
- java - 每次我必须改变一些东西来反映
- android - 使用 Flutter/Dart 构建的应用空间
- apache-kafka - 卡夫卡 ISR 缩小且不扩展
- vba - Excel VBA宏根据其他工作表中的值将粘贴值复制到其他工作表
- python - Argparse:根据位置参数计算默认值
- android - 在 XWalkView (CrossWalk) 中打开不受信任的 SSL 链接时出现 SSL 错误
- magento2 - Magento 2 Algolia Search 按最低价格排序等显示损坏的结果
- google-cloud-platform - 谷歌云计算引擎虚拟机关闭的未知原因?
- pandas - 使用数据着色器、全息视图和散景进行地理映射的麻烦
- javascript - 检查数组是否在javascript中仅包含一次值