BUG #4591: postgres.exe more than 150 processes runned

From: "Steblina OLeg" <oldnick(at)ukrlink(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4591: postgres.exe more than 150 processes runned
Date: 2008-12-21 14:54:28
Message-ID: 200812211454.mBLEsSKg014830@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4591
Logged by: Steblina OLeg
Email address: oldnick(at)ukrlink(dot)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"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2008-12-22 00:42:03 Re: BUG #4591: postgres.exe more than 150 processes runned
Previous Message dane manship 2008-12-21 11:55:34 Postgresql