From: | "Rao Kumar" <raokumar(at)netwolves(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Postgre 7.3.2 pg_clog error |
Date: | 2003-03-21 15:11:43 |
Message-ID: | NBEEJBHFGDGFKNKHGGAFGEHBCGAA.raokumar@netwolves.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
We are running into a pg_clog problem since we recently upgraded to 7.3.2
version. The error log reports:
PANIC: open of /usr/local/pgsql/data/pg_clog/0002 failed: No such file or
directory
2003-03-19 05:46:40 LOG: recycled transaction log file 00000001000000B8
2003-03-19 05:51:02 PANIC: open of /usr/local/pgsql/data/pg_clog/0020
failed: No such file or directory
Following the error, the database shuts down and goes into recovery mode,
sometimes
corrupting the index/data files making the database irrecoverable.
To give you a quick background, We run an OLTP application on postgres with
large transaction volume. We were able to successfully test our app with
simulators producing
these high transaction volumes with 7.1.3. But ever since we upgraded the
database to
7.3.2, we are encountering the above pg_clog error during high transaction
volume/activity.
If you need further information ( such as the .conf file), please email me
and I will be more than glad to provide you.
Thank You
Rao Kumar
2003-03-17 01:32:32 FATAL: The database system is starting up
2003-03-17 01:32:32 FATAL: The database system is starting up
2003-03-17 01:32:32 FATAL: The database system is starting up
2003-03-17 01:32:33 FATAL: The database system is starting up
2003-03-17 01:32:33 FATAL: The database system is starting up
2003-03-17 01:32:33 FATAL: The database system is starting up
2003-03-17 01:32:33 LOG: recycled transaction log file 0000001700000092
2003-03-17 01:32:33 LOG: recycled transaction log file 0000001700000093
2003-03-17 01:32:33 LOG: database system is ready
2003-03-17 01:32:44 PANIC: open of /usr/local/pgsql/data/pg_clog/0000
failed: No such file or directory
2003-03-17 01:32:44 LOG: server process (pid 39313) was terminated by
signal 6
2003-03-17 01:32:44 LOG: terminating any other active server processes
2003-03-17 01:32:44 LOG: all server processes terminated; reinitializing
shared memory and semaphores
2003-03-17 01:32:44 FATAL: The database system is starting up
2003-03-17 01:32:44 LOG: database system was interrupted at 2003-03-17
01:32:33 EST
2003-03-17 01:32:44 LOG: checkpoint record is at 17/96B42798
2003-03-17 01:32:44 LOG: redo record is at 17/96B42798; undo record is at
0/0; shutdown TRUE
2003-03-17 01:32:44 LOG: next transaction id: 3584774; next oid: 5063218
2003-03-17 01:32:44 LOG: database system was not properly shut down;
automatic recovery in progress
2003-03-17 01:32:44 FATAL: The database system is starting up
2003-03-17 01:32:45 FATAL: The database system is starting up
2003-03-17 01:32:45 FATAL: The database system is starting up
2003-03-17 01:32:45 LOG: redo starts at 17/96B427D8
2003-03-17 01:32:45 FATAL: The database system is starting up
2003-03-17 01:32:45 FATAL: The database system is starting up
2003-03-17 01:32:45 LOG: ReadRecord: record with zero length at 17/96F60DF4
2003-03-17 01:32:45 LOG: redo done at 17/96F60DD0
2003-03-17 01:32:45 FATAL: The database system is starting up
2003-03-17 01:32:45 FATAL: The database system is starting up
2003-03-17 01:32:45 FATAL: The database system is starting up
003-03-17 01:32:47 FATAL: The database system is starting up
2003-03-17 01:32:47 FATAL: The database system is starting up
2003-03-17 01:32:48 FATAL: The database system is starting up
2003-03-17 01:32:48 FATAL: The database system is starting up
2003-03-17 01:32:48 LOG: recycled transaction log file 0000001700000095
2003-03-17 01:32:48 LOG: recycled transaction log file 0000001700000094
2003-03-17 01:32:48 LOG: database system is ready
2003-03-17 01:32:54 PANIC: open of /usr/local/pgsql/data/pg_clog/0000
failed: No such file or directory
2003-03-17 01:32:54 LOG: server process (pid 39349) was terminated by
signal 6
2003-03-17 01:32:54 LOG: terminating any other active server processes
2003-03-17 01:32:54 LOG: all server processes terminated; reinitializing
shared memory and semaphores
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 LOG: database system was interrupted at 2003-03-17
01:32:49 EST
2003-03-17 01:32:55 LOG: checkpoint record is at 17/96F60DF4
2003-03-17 01:32:55 LOG: redo record is at 17/96F60DF4; undo record is at
0/0; shutdown TRUE
2003-03-17 01:32:55 LOG: next transaction id: 3584892; next oid: 5071410
2003-03-17 01:32:55 LOG: database system was not properly shut down;
automatic recovery in progress
2003-03-17 01:32:55 LOG: redo starts at 17/96F60E34
2003-03-17 01:32:55 LOG: ReadRecord: record with zero length at 17/97202654
2003-03-17 01:32:55 LOG: redo done at 17/97202630
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:55 FATAL: The database system is starting up
2003-03-17 01:32:56 FATAL: The database system is starting up
2003-03-17 01:32:56 FATAL: The database system is starting up
2003-03-17 01:32:56 FATAL: The database system is starting up
2003-03-17 01:32:56 FATAL: The database system is starting up
2003-03-17 01:32:56 FATAL: The database system is starting up
2003-03-17 01:32:56 FATAL: The database system is starting up
2003-03-17 01:32:56 FATAL: The database system is starting up
2003-03-17 01:32:56 FATAL: The database system is starting up
2003-03-17 01:32:56 FATAL: The database system is starting up
2003-03-17 01:32:57 FATAL: The database system is starting up
2003-03-17 01:32:57 FATAL: The database system is starting up
2003-03-17 01:32:57 FATAL: The database system is starting up
2003-03-17 01:32:57 FATAL: The database system is starting up
2003-03-17 01:32:57 FATAL: The database system is starting up
2003-03-17 01:32:57 FATAL: The database system is starting up
2003-03-17 01:32:57 FATAL: The database system is starting up
From | Date | Subject | |
---|---|---|---|
Next Message | Jodi Kanter | 2003-03-21 15:41:53 | indexes not being used! |
Previous Message | Tom Lane | 2003-03-21 15:10:49 | Re: psql invokation |