Re: error : could not access status of transaction

Lists: pgsql-jdbcpgsql-sql
From: Pavan Kumar <pavan(at)netcore(dot)co(dot)in>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: error : could not access status of transaction
Date: 2006-05-18 05:45:25
Message-ID: 1147931125.13859.49.camel@pavan.psmw
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc pgsql-sql

Hi all

could any body tell me what does following error message means
i get this error when i perform select operation on a table.
Error Message :

could not access status of transaction 265224192
DETAIL: could not open file "pg_clog/00FC": No such file or directory


From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Pavan Kumar <pavan(at)netcore(dot)co(dot)in>
Cc: pgsql-jdbc(at)postgresql(dot)org, PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: error : could not access status of transaction
Date: 2006-05-18 09:41:10
Message-ID: 446C4136.90202@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc pgsql-sql

Hi, Pavan,

Pavan Kumar wrote:

> could any body tell me what does following error message means
> i get this error when i perform select operation on a table.
> Error Message :
>
> could not access status of transaction 265224192
> DETAIL: could not open file "pg_clog/00FC": No such file or directory

This sounds like a broken PostgreSQL data directory, not a jdbc problem.

You should check whether you can access the table via psql or other
non-jdbc tools, and if not, ask on
PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
or pgsql-general.

Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org