Unable to explain DB error

From: Steven Rosenstein <srosenst(at)us(dot)ibm(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Unable to explain DB error
Date: 2005-07-28 17:00:05
Message-ID: OFFB0048A5.CE2093BE-ON8525704C.005CB3DF-8525704C.005D646E@us.ibm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Postgres V7.3.9-2.

While executing a query in psql, the following error was generated:

vsa=# select * from vsa.dtbl_logged_event_20050318 where id=2689472;
PANIC: open of /vsa/db/pg_clog/0FC0 failed: No such file or directory
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#

I checked in the /vsa/db/pg_clog directory, and the files have monotonically increasing filenames starting with 0000. The most recent names are:

-rw------- 1 postgres postgres 262144 Jul 25 21:39 04CA
-rw------- 1 postgres postgres 262144 Jul 26 01:10 04CB
-rw------- 1 postgres postgres 262144 Jul 26 05:39 04CC
-rw------- 1 postgres postgres 262144 Jul 28 00:01 04CD
-rw------- 1 postgres postgres 237568 Jul 28 11:31 04CE

Any idea why Postgres would be looking for a clog file name 0FC0 when the most recent filename is 04CE?

Any help and suggestions for recovery are appreciated.

--- Steve
___________________________________________________________________________________

Steven Rosenstein
IT Architect/Developer | IBM Virtual Server Administration
Voice/FAX: 845-689-2064 | Cell: 646-345-6978 | Tieline: 930-6001
Text Messaging: 6463456978 @ mobile.mycingular.com
Email: srosenst @ us.ibm.com

"Learn from the mistakes of others because you can't live long enough to
make them all yourself." -- Eleanor Roosevelt

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Hoover 2005-07-28 17:34:54 Re: Fwd: Help with view performance problem
Previous Message Chris Travers 2005-07-28 16:55:53 Re: Left joining against two empty tables makes a query