another lockup, this time due to pgstat_write_statsfile :-(
2006-10-24 17:01:17 [5412] LOG: XX000: could not rename temporary
statistics file global/pgstat.tmp to global/pgstat.stat: A blocking
operation was interrupted by a call to WSACancelBlockingCall.
2006-10-24 17:01:17 [5412] LOCATION: pgstat_write_statsfile, pgstat.c:2008
2006-10-24 17:23:23 [3280] LOG: 0: received fast shutdown request
2006-10-24 17:23:23 [3280] LOCATION: pmdie, postmaster.c:1903
2006-10-24 17:23:23 [3280] LOG: 0: aborting any active transactions
2006-10-24 17:23:23 [3280] LOCATION: pmdie, postmaster.c:1910
2006-10-24 17:23:23 [3468] FATAL: 57P01: terminating connection due to
administrator command
2006-10-24 17:23:23 [3468] LOCATION: ProcessInterrupts, postgres.c:2465
this is what filemon reports (~10 times a second):
17:23:18 postgres.exe:1432 OPEN
D:\DB\PostgreSQL-8.2\data\pg_xlog\0001000400DB DELETE PEND
Options: Open Access: 00110080
17:23:18 postgres.exe:1432 OPEN
D:\DB\PostgreSQL-8.2\data\pg_xlog\0001000400DB DELETE PEND
Options: Open Access: 00110080
17:23:18 postgres.exe:1432 OPEN
D:\DB\PostgreSQL-8.2\data\pg_xlog\0001000400DB DELETE PEND
Options: Open Access: 00110080
sorry for flooding. just tell me if i shall rather stop.
- thomas
- Original Message -
From: Thomas H. [EMAIL PROTECTED]
To: pgsql-bugs@postgresql.org
Sent: Tuesday, October 24, 2006 3:15 PM
Subject: Re: [BUGS] could not rename xlog (was: BUG #2712)
Peter Brant [EMAIL PROTECTED] writes:
The same problem exists in 8.1 too. See this thread
http://archives.postgresql.org/pgsql-bugs/2006-04/msg00177.php
Tom and Magnus tracked down a cause, but I don't think a fix was ever
implemented.
Thomas seems to have two different issues there: the could not rename
file problem on the pg_xlog file is probably explained by the mechanism
we identified back then (and I'm not sure why no fix has been
installed)
just had another total lockdown. the writer-process was trying to rename
the C1 to CA which failed:
2006-10-24 14:27:58 [5196] LOG: 0: could not rename file
pg_xlog/0001000400C1 to pg_xlog/0001000400CA,
continuing to try
2006-10-24 14:27:58 [5196] LOCATION: pgrename, dirmod.c:142
when checking the process with process explorer, it reveals that it has
this file handles to pg_xlog open:
D:\DB\PostgreSQL-8.2\data\pg_xlog
D:\DB\PostgreSQL-8.2\data\pg_xlog\0001000400C3
under normal operation, writer process does not seem to have a file
handle to the xlog directory (D:\DB\PostgreSQL-8.2\data\pg_xlog)
the last error log entry prior to the lockdown was about 15min, so
probably the two problems are unrelated.
unfortunately, before i could try to get more informations, i had to
restart the pg_ctl due to the system being in half-productive mode. that
leads me to the question: what are the chances of me being helpful with
getting more informations? i can have the db run like that for some more
days, but for long term i can't babysit our application and might have to
go back to 8.1.
thanks,
thomas
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq