From: Matthieu Roger <matthieu.roger@gene6.com>
To: pgsql-admin@postgresql.org
Subject: Crash with pg_clog file not found
Date: Mon, 3 Nov 2008 08:41:50 +0100
Message-ID: <30111ec50811022341q688ca946j8269cee93b206a3d@mail.gmail.com> (raw)
Hello,
OS: Windows 2003 64bits
Cpu : 2x Opteron Dual core
Ram : 8Go Ram
Disk : Areca Raid10 6x 200Go sata
Postgresql 8.3.4
we're experiencing problems since some weeks with always the same
error (same transaction 0 and same pg_clog file 0000) :
2008-10-31 20:14:27 CET 10.0.0.119 exile PANIC: could not access
status of transaction 0
2008-10-31 20:14:27 CET 10.0.0.119 exile DETAIL: Could not open file
"pg_clog/0000": No such file or directory.
2008-10-31 20:14:27 CET 10.0.0.119 exile STATEMENT: SELECT
sp_execute_processes();
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
2008-10-31 20:17:32 CET 10.0.0.119 exile FATAL: connection limit
exceeded for non-superusers
[...]
We try to stop the service :
2008-10-31 20:39:30 CET LOG: received fast shutdown request
2008-10-31 20:39:30 CET LOG: aborting any active transactions
2008-10-31 20:39:30 CET 10.0.0.119 exile FATAL: terminating
connection due to administrator command
Line above repeated again and again
2008-10-31 20:44:20 CET LOG: server process (PID 2772) exited with
exit code 3
2008-10-31 20:44:20 CET LOG: terminating any other active server processes
2008-10-31 20:44:20 CET 10.0.0.119 vitevendu WARNING: terminating
connection because of crash of another server process
2008-10-31 20:44:20 CET 10.0.0.119 vitevendu DETAIL: The postmaster
has commanded this server process to roll back the current transaction
and exit, because another server process exited abnormally and
possibly corrupted shared memory.
2008-10-31 20:44:20 CET 10.0.0.119 vitevendu HINT: In a moment you
should be able to reconnect to the database and repeat your command.
Last block above repeated with all bases many times, then :
2008-10-31 20:44:21 CET 10.0.0.119 exile FATAL: the database system
is shutting down
[...]
2008-10-31 20:44:22 CET LOG: abnormal database system shutdown
Event log :
20:14:32 : Faulting application postgres.exe, version 8.3.4.8262,
faulting module postgres.exe, version 8.3.4.8262, fault address
0x0024a529.
When it crashes the service can't be restarted, no postmaster.pid file
to remove, it does not want to restart, we need to reboot server then
it recovers but we have strange data and duplicated content so we need
to recover from a backup.
We vacuum regularly, autovacuum is enabled, cpu usage is ok (<50%) as
well as mem usage. I set log to debug1.
I don't know what the problem can be :-/
New crash with debug1 (not much info) :
2008-11-03 01:15:45 CET 10.0.0.119 exile LOG: 00000: duration:
2688.000 ms statement: SELECT sp_execute_processes();
2008-11-03 01:15:45 CET 10.0.0.119 exile LOCATION: exec_simple_query,
.\src\backend\tcop\postgres.c:1063
2008-11-03 01:15:46 CET 10.0.0.119 exile PANIC: 58P01: could not
access status of transaction 0
2008-11-03 01:15:46 CET 10.0.0.119 exile DETAIL: Could not open file
"pg_clog/0000": No such file or directory.
2008-11-03 01:15:46 CET 10.0.0.119 exile LOCATION: SlruReportIOError,
.\src\backend\access\transam\slru.c:845
2008-11-03 01:15:46 CET 10.0.0.119 exile STATEMENT: SELECT
sp_execute_processes();
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
Matthieu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: matthieu.roger@gene6.com
Subject: Re: Crash with pg_clog file not found
In-Reply-To: <30111ec50811022341q688ca946j8269cee93b206a3d@mail.gmail.com>
References: <30111ec50811022341q688ca946j8269cee93b206a3d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox