The following bug has been logged online:
Bug reference: 4591
Logged by: Steblina OLeg
Email address: oldnick@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"