The following bug has been logged online: Bug reference: 4339 Logged by: Bhaskar Sirohi Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Windows 2003 Server Description: The postgreSQL service stops abnormally Details:
Hi All, The postgreSQL service stops abnormally,I can't restart it until I enter the password for the \postgre login account. Once I do that, everything is fine again. Below are the snaps of pg_logs 2008-07-29 09:14:46 EDT LOG: database system was interrupted; last known up at 2008-07-28 23:13:20 EDT 2008-07-29 09:14:46 EDT LOG: database system was not properly shut down; automatic recovery in progress 2008-07-29 09:14:46 EDT LOG: record with zero length at 2/D0E47B88 2008-07-29 09:14:46 EDT LOG: redo is not required 2008-07-29 09:14:46 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-29 09:14:46 EDT FATAL: the database system is starting up 2008-07-29 09:14:46 EDT LOG: database system is ready to accept connections 2008-07-29 09:14:46 EDT LOG: autovacuum launcher started 2008-07-29 09:14:47 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-29 09:15:29 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-29 16:26:19 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-29 16:41:03 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-29 16:50:57 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-29 16:51:27 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-29 17:30:13 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-30 03:03:44 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-30 05:35:15 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-30 10:27:35 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-07-30 15:05:01 EDT LOG: checkpoints are occurring too frequently (28 seconds apart) 2008-07-30 15:05:01 EDT HINT: Consider increasing the configuration parameter "checkpoint_segments". 2008-07-30 15:13:34 EDT LOG: checkpoints are occurring too frequently (29 seconds apart) 2008-07-30 15:13:34 EDT HINT: Consider increasing the configuration parameter "checkpoint_segments". 2008-07-30 15:18:50 EDT LOG: checkpoints are occurring too frequently (28 seconds apart) 2008-07-30 15:18:50 EDT HINT: Consider increasing the configuration parameter "checkpoint_segments". 2008-07-30 15:19:21 EDT LOG: received fast shutdown request 2008-07-30 15:19:21 EDT LOG: aborting any active transactions 2008-07-30 15:19:21 EDT ERROR: canceling statement due to user request 2008-07-30 15:19:21 EDT STATEMENT: COMMIT 2008-07-30 15:19:21 EDT ERROR: canceling statement due to user request 2008-07-30 15:19:21 EDT STATEMENT: ROLLBACK 2008-07-30 15:19:21 EDT ERROR: current transaction is aborted, commands ignored until end of transaction block 2008-07-30 15:19:21 EDT STATEMENT: SELECT type, cino, ctime FROM folder WHERE ino = 2 AND name = 'Michael H. Modee' AND dtime = 0 2008-07-30 15:19:21 EDT ERROR: current transaction is aborted, commands ignored until end of transaction block 2008-07-30 15:19:21 EDT STATEMENT: SELECT type, cino, ctime FROM folder WHERE ino = 2 AND name = 'Michael H. Modee' AND dtime = 0 2008-07-30 15:19:21 EDT ERROR: canceling autovacuum task 2008-07-30 15:19:21 EDT CONTEXT: automatic analyze of table "notebookbkp.public.bmap" 2008-07-30 15:19:21 EDT FATAL: terminating connection due to administrator command 2008-07-30 15:19:21 EDT FATAL: terminating connection due to administrator command 2008-07-30 15:19:21 EDT LOG: autovacuum launcher shutting down 2008-07-30 15:19:24 EDT LOG: shutting down 2008-07-30 15:19:24 EDT LOG: database system is shut down -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
