Postgre 7.3.2 pg_clog error
| От | Rao Kumar |
|---|---|
| Тема | Postgre 7.3.2 pg_clog error |
| Дата | |
| Msg-id | NBEEJBHFGDGFKNKHGGAFGEHBCGAA.raokumar@netwolves.com обсуждение исходный текст |
| Ответы |
Re: Postgre 7.3.2 pg_clog error
(Michael Brusser <michael@synchronicity.com>)
Re: Postgre 7.3.2 pg_clog error (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | 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
В списке pgsql-admin по дате отправления: