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