BUG #4591: postgres.exe more than 150 processes runned - Mailing list pgsql-bugs

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"