Re: select failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ian Cass" <ian(dot)cass(at)mblox(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: select failure
Date: 2002-06-09 19:28:07
Message-ID: 6842.1023650887@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Ian Cass" <ian(dot)cass(at)mblox(dot)com> writes:
> FATAL 2: open of /var/lib/postgres/data/pg_clog/0534 failed: No such file
> or directory

We have seen a couple reports like this one, eg
http://archives.postgresql.org/pgsql-general/2002-03/msg00179.php
http://archives.postgresql.org/pgsql-novice/2002-06/msg00027.php

It could be that all of you have been bitten by hardware problems
(viz, dropped bits in xmin/xmax fields), or there might be some
software bug that's leading to this failure. So far, no one's
been very cooperative about digging into a failure case to try to
determine exactly what happened...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Gunther Schadow 2002-06-09 20:01:42 Re: select failure
Previous Message Tom Lane 2002-06-09 19:00:58 Re: Support for distributed queries with semijoins could be possible, if ...