Образовательный проект «SnakeProject» Михаила Козлова

⇒ FreeBSD and Nix ⇐

CISCO

Voice(Asterisk\Cisco)

Microsoft

Powershell

Python

SQL\T-SQL

1С

Общая

WEB Разработка

ORACLE SQL \ JAVA

Мото

Стрельба, пневматика, оружие

Саморазвитие и психология

Postgresql: database system was interrupted while in recovery

Postgresql: database system was interrupted while in recovery

При получении ошибки типа:
2020-01-27 12:23:04 MSK LOG:  database system was interrupted while in recovery at 2020-01-27 13:23:40 MSK
2020-01-27 12:23:04 MSK HINT:  This probably means that some data is corrupted and you will have to use the last backup for recovery.
2020-01-27 12:23:04 MSK FATAL:  the database system is starting up
2020-01-27 12:23:05 MSK LOG:  database system was not properly shut down; automatic recovery in progress
2020-01-27 12:23:05 MSK LOG:  redo starts at 26/63EE7208
2020-01-27 12:23:06 MSK FATAL:  the database system is starting up
2020-01-27 12:23:06 MSK LOG:  record with zero length at 26/64183728
2020-01-27 12:23:06 MSK LOG:  redo done at 26/641836E8
2020-01-27 12:23:06 MSK LOG:  last completed transaction was at log time 2020-01-27 12:34:11
2020-01-27 12:23:06 MSK WARNING:  page 22 of relation base/12200/20110 did not exist
2020-01-27 12:23:06 MSK PANIC:  WAL contains references to invalid pages
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
2020-01-27 12:23:06 MSK LOG:  startup process (PID 3080) exited with exit code 3
2020-01-27 12:23:06 MSK LOG:  aborting startup due to startup process failure

Видим, что Postgresql не может завершить начатые транзакции

Далее вы делаете на свой страх и риск!!!! Бэкапьтесь!!!

# pg_controldata /data/pgdata
***
Latest checkpoint's NextXID:          0/243412
Latest checkpoint's NextOID:          3932122
***

Сброс:
# pg_resetxlog -o 3932122 -x 243412 /data/pgdata

В логах:
Transaction log reset

Комментарии пользователей