BUG #9756: Inconsistent database after OS restart
От | sdl@mnppsaturn.ru |
---|---|
Тема | BUG #9756: Inconsistent database after OS restart |
Дата | |
Msg-id | 20140328075830.26598.25849@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #9756: Inconsistent database after OS restart
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 9756 Logged by: Dmitry Samokhin Email address: sdl@mnppsaturn.ru PostgreSQL version: 9.2.8 Operating system: Windows XP, 7 Description: After every Windows restart, database couldn't be shut down properly and recovering actions are performed on the next startup. But if we control the service manually by the Windows Services snap-in, no problem with the correct DB cluster shutdown. Looks like there's something wrong with the correct autovacuum process shutdown which leads to the DB inconsistency. Custom configuration options: autovacuum_naptime = '1d' The others are default. Here is the log entries: *** Manual service start *** 2014-03-28 11:36:05 MSK LOG: database system was shut down at 2014-03-28 11:35:39 MSK 2014-03-28 11:36:05 MSK LOG: database system is ready to accept connections 2014-03-28 11:36:05 MSK LOG: autovacuum launcher started *** Manual service stop *** 2014-03-28 11:36:41 MSK LOG: received fast shutdown request 2014-03-28 11:36:41 MSK LOG: aborting any active transactions 2014-03-28 11:36:41 MSK LOG: autovacuum launcher shutting down 2014-03-28 11:36:41 MSK LOG: shutting down 2014-03-28 11:36:41 MSK LOG: database system is shut down *** Manual service start again*** 2014-03-28 11:37:02 MSK LOG: database system was shut down at 2014-03-28 11:36:41 MSK 2014-03-28 11:37:02 MSK LOG: database system is ready to accept connections 2014-03-28 11:37:02 MSK LOG: autovacuum launcher started *** Windows restart: *** -- Stopping: 2014-03-28 11:37:34 MSK LOG: received fast shutdown request 2014-03-28 11:37:34 MSK LOG: aborting any active transactions 2014-03-28 11:37:34 MSK LOG: autovacuum launcher shutting down 2014-03-28 11:37:34 MSK ERROR: canceling statement due to user request -- Starting: 2014-03-28 11:38:08 MSK LOG: database system was interrupted; last known up at 2014-03-28 11:37:02 MSK 2014-03-28 11:38:08 MSK LOG: database system was not properly shut down; automatic recovery in progress 2014-03-28 11:38:08 MSK FATAL: the database system is starting up 2014-03-28 11:38:08 MSK LOG: record with zero length at 0/1B44FF0 2014-03-28 11:38:08 MSK LOG: redo is not required 2014-03-28 11:38:09 MSK LOG: database system is ready to accept connections 2014-03-28 11:38:09 MSK LOG: autovacuum launcher started Thanks, Dmitry
В списке pgsql-bugs по дате отправления: