The following bug has been logged online: Bug reference: 4591 Logged by: Steblina OLeg Email address: oldn...@ukrlink.net PostgreSQL version: 8.1 Operating system: Windows XP pro sp2 Description: postgres.exe more than 150 processes runned Details:
http://apoc.org.ua/oldnick/images/pgsql_processes.jpg Processes start each other and hang, doing nothing. Connections with base are not made, for a night 177 processes postgres.exe. I used version 8.1 instead of newer 8.3 for the reason that the service in version 8.3 is started and at once stops. Computer configuration: Q6600, 2Gb, WinXPproSP2 And some part of log (about 300Kb per day): autovacuum process (PID 2344) was terminated by signal 66 2008-12-21 16:48:54 LOG: terminating any other active server processes 2008-12-21 16:48:54 LOG: all server processes terminated; reinitializing 2008-12-21 16:48:54 LOG: database system was interrupted at 2008-12-21 16:47:53 Греция, Турция (зима) 2008-12-21 16:48:54 LOG: checkpoint record is at 0/55D720 2008-12-21 16:48:54 LOG: redo record is at 0/55D720; undo record is at 0/0; shutdown TRUE 2008-12-21 16:48:54 LOG: next transaction ID: 733; next OID: 17233 2008-12-21 16:48:54 LOG: next MultiXactId: 1; next MultiXactOffset: 0 2008-12-21 16:48:54 LOG: database system was not properly shut down; automatic recovery in progress 2008-12-21 16:48:54 LOG: record with zero length at 0/55D768 2008-12-21 16:48:54 LOG: redo is not required 2008-12-21 16:48:54 LOG: database system is ready 2008-12-21 16:48:54 LOG: transaction ID wrap limit is 2147484148, limited by database "postgres" 2008-12-21 16:49:54 LOG: autovacuum process (PID 4016) was terminated by signal 66 2008-12-21 16:49:54 LOG: terminating any other active server processes 2008-12-21 16:49:55 LOG: all server processes terminated; reinitializing 2008-12-21 16:49:55 LOG: database system was interrupted at 2008-12-21 16:48:54 Греция, Турция (зима) 2008-12-21 16:49:55 LOG: checkpoint record is at 0/55D768 2008-12-21 16:49:55 LOG: redo record is at 0/55D768; undo record is at 0/0; shutdown TRUE 2008-12-21 16:49:55 LOG: next transaction ID: 733; next OID: 17233 2008-12-21 16:49:55 LOG: next MultiXactId: 1; next MultiXactOffset: 0 2008-12-21 16:49:55 LOG: database system was not properly shut down; automatic recovery in progress 2008-12-21 16:49:55 LOG: record with zero length at 0/55D7B0 2008-12-21 16:49:55 LOG: redo is not required 2008-12-21 16:49:55 LOG: database system is ready 2008-12-21 16:49:55 LOG: transaction ID wrap limit is 2147484148, limited by database "postgres" 2008-12-21 16:50:55 LOG: autovacuum process (PID 7512) was terminated by signal 66 2008-12-21 16:50:55 LOG: terminating any other active server processes 2008-12-21 16:50:55 LOG: all server processes terminated; reinitializing 2008-12-21 16:50:55 LOG: database system was interrupted at 2008-12-21 16:49:55 Греция, Турция (зима) 2008-12-21 16:50:55 LOG: checkpoint record is at 0/55D7B0 2008-12-21 16:50:55 LOG: redo record is at 0/55D7B0; undo record is at 0/0; shutdown TRUE 2008-12-21 16:50:55 LOG: next transaction ID: 733; next OID: 17233 2008-12-21 16:50:55 LOG: next MultiXactId: 1; next MultiXactOffset: 0 2008-12-21 16:50:55 LOG: database system was not properly shut down; automatic recovery in progress 2008-12-21 16:50:55 LOG: record with zero length at 0/55D7F8 2008-12-21 16:50:55 LOG: redo is not required 2008-12-21 16:50:55 LOG: database system is ready 2008-12-21 16:50:55 LOG: transaction ID wrap limit is 2147484148, limited by database "postgres" -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
