Re: error : could not access status of transaction

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: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2006-05-18 11:02:55 Re: connection time out
Previous Message Pavan Kumar 2006-05-18 05:45:25 error : could not access status of transaction

Browse pgsql-sql by date

  From Date Subject
Next Message Thusitha Kodikara 2006-05-18 11:21:19 Encryption functions
Previous Message Michael Artz 2006-05-18 09:21:17 Re: Question about SQL Control Structure(if then, for loop)