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"
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 |