pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed"could not open file" issue
8+ messages / 3 participants
[nested] [flat]
* "could not open file" issue
@ 2006-04-24 16:17 Daniel Caune <daniel.caune@ubisoft.com>
0 siblings, 2 replies; 8+ messages in thread
From: Daniel Caune @ 2006-04-24 16:17 UTC (permalink / raw)
To: pgsql-sql
Hi,
Is there any way to solve the following issue without dropping the
table?
select count(*) from eventplayerleaveroom;
ERROR: could not access status of transaction 3164404766
DETAIL: could not open file "pg_clog/0BC9": No such file or directory
Regards,
P.S.: PostgreSQL server 8.1.3
--
Daniel CAUNE
Ubisoft Online Technology
(514) 4090 2040 ext. 5418
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "could not open file" issue
@ 2006-04-24 19:02 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Daniel Caune <daniel.caune@ubisoft.com>
1 sibling, 0 replies; 8+ messages in thread
From: Andrew Sullivan @ 2006-04-24 19:02 UTC (permalink / raw)
To: pgsql-sql
On Mon, Apr 24, 2006 at 12:17:07PM -0400, Daniel Caune wrote:
> Hi,
>
> Is there any way to solve the following issue without dropping the
> table?
I doubt you'll be able to drop the table. I think you have some sort
of corruption. Assuming your hardware is good, you maybe oughta take
this over to -general to see if the wizards can identify your
problem. (But check your hardware first.)
A
--
Andrew Sullivan | ajs@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "could not open file" issue
@ 2006-04-24 19:21 Alvaro Herrera <alvherre@commandprompt.com>
parent: Daniel Caune <daniel.caune@ubisoft.com>
1 sibling, 0 replies; 8+ messages in thread
From: Alvaro Herrera @ 2006-04-24 19:21 UTC (permalink / raw)
To: Daniel Caune <daniel.caune@ubisoft.com>; +Cc: pgsql-sql
Daniel Caune wrote:
> Hi,
>
> Is there any way to solve the following issue without dropping the
> table?
>
> select count(*) from eventplayerleaveroom;
> ERROR: could not access status of transaction 3164404766
> DETAIL: could not open file "pg_clog/0BC9": No such file or directory
Are the files in pg_clog close to the vicinity of 0BC9?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "could not open file" issue
@ 2006-04-24 19:44 Daniel Caune <daniel.caune@ubisoft.com>
0 siblings, 1 reply; 8+ messages in thread
From: Daniel Caune @ 2006-04-24 19:44 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: pgsql-sql
> De : Alvaro Herrera [mailto:alvherre@commandprompt.com]
>
> Daniel Caune wrote:
> > Hi,
> >
> > Is there any way to solve the following issue without dropping the
> > table?
> >
> > select count(*) from eventplayerleaveroom;
> > ERROR: could not access status of transaction 3164404766
> > DETAIL: could not open file "pg_clog/0BC9": No such file or directory
>
> Are the files in pg_clog close to the vicinity of 0BC9?
>
I don't have any skill in PostgreSQL administration. However I took a look at /var/lib/postgresql/8.1/main/pg_clog and there is no file close to the vicinity of 0BC9 ; the last file in that directory is:
-rw------- 1 postgres postgres 221184 2006-04-24 19:27 00C9
A bit far from 0BC9... Do you have any diagnostic?
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "could not open file" issue
@ 2006-04-24 20:35 Alvaro Herrera <alvherre@commandprompt.com>
parent: Daniel Caune <daniel.caune@ubisoft.com>
0 siblings, 0 replies; 8+ messages in thread
From: Alvaro Herrera @ 2006-04-24 20:35 UTC (permalink / raw)
To: Daniel Caune <daniel.caune@ubisoft.com>; +Cc: pgsql-sql
Daniel Caune wrote:
>
> > De : Alvaro Herrera [mailto:alvherre@commandprompt.com]
> >
> > Daniel Caune wrote:
> > >
> > > select count(*) from eventplayerleaveroom;
> > > ERROR: could not access status of transaction 3164404766
> > > DETAIL: could not open file "pg_clog/0BC9": No such file or directory
> >
> > Are the files in pg_clog close to the vicinity of 0BC9?
>
> I don't have any skill in PostgreSQL administration. However I took a
> look at /var/lib/postgresql/8.1/main/pg_clog and there is no file
> close to the vicinity of 0BC9 ; the last file in that directory is:
>
> -rw------- 1 postgres postgres 221184 2006-04-24 19:27 00C9
>
> A bit far from 0BC9... Do you have any diagnostic?
I'd say you have a corrupted table. How corrupted I don't know. You
could try extracting a portion of the table, playing with LIMIT/OFFSET
to find out the exact records that are corrupted.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "could not open file" issue
@ 2006-04-24 20:38 Daniel Caune <daniel.caune@ubisoft.com>
0 siblings, 0 replies; 8+ messages in thread
From: Daniel Caune @ 2006-04-24 20:38 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: pgsql-sql
> De : Alvaro Herrera [mailto:alvherre@commandprompt.com]
>
> Daniel Caune wrote:
> >
> > > De : Alvaro Herrera [mailto:alvherre@commandprompt.com]
> > >
> > > Daniel Caune wrote:
> > > >
> > > > select count(*) from eventplayerleaveroom;
> > > > ERROR: could not access status of transaction 3164404766
> > > > DETAIL: could not open file "pg_clog/0BC9": No such file or
> directory
> > >
> > > Are the files in pg_clog close to the vicinity of 0BC9?
> >
> > I don't have any skill in PostgreSQL administration. However I took a
> > look at /var/lib/postgresql/8.1/main/pg_clog and there is no file
> > close to the vicinity of 0BC9 ; the last file in that directory is:
> >
> > -rw------- 1 postgres postgres 221184 2006-04-24 19:27 00C9
> >
> > A bit far from 0BC9... Do you have any diagnostic?
>
> I'd say you have a corrupted table. How corrupted I don't know. You
> could try extracting a portion of the table, playing with LIMIT/OFFSET
> to find out the exact records that are corrupted.
>
Yes, I tried playing with the LIMIT clause, and LIMIT 90 is the better I can pass... :-(
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "could not open file" issue
@ 2006-04-24 21:02 Daniel Caune <daniel.caune@ubisoft.com>
0 siblings, 1 reply; 8+ messages in thread
From: Daniel Caune @ 2006-04-24 21:02 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
> De : pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-
> owner@postgresql.org] De la part de Andrew Sullivan
>
> On Mon, Apr 24, 2006 at 12:17:07PM -0400, Daniel Caune wrote:
> > Hi,
> >
> > Is there any way to solve the following issue without dropping the
> > table?
>
> I doubt you'll be able to drop the table. I think you have some sort
> of corruption. Assuming your hardware is good, you maybe oughta take
> this over to -general to see if the wizards can identify your
> problem. (But check your hardware first.)
>
It seems that was possible: I tried first to truncate the table (it passed), and finally I tried to drop the table (it also passed). Then I created the table. I'm not sure that it fixes my problem. I modified my fstab file so that Linux checks my file system's health on the next boot.
>
> --
> Andrew Sullivan | ajs@crankycanuck.ca
> "The year's penultimate month" is not in truth a good way of saying
> November.
> --H.W. Fowler
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "could not open file" issue
@ 2006-04-24 21:40 Alvaro Herrera <alvherre@commandprompt.com>
parent: Daniel Caune <daniel.caune@ubisoft.com>
0 siblings, 0 replies; 8+ messages in thread
From: Alvaro Herrera @ 2006-04-24 21:40 UTC (permalink / raw)
To: Daniel Caune <daniel.caune@ubisoft.com>; +Cc: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
Daniel Caune wrote:
> It seems that was possible: I tried first to truncate the table (it
> passed), and finally I tried to drop the table (it also passed). Then
> I created the table. I'm not sure that it fixes my problem. I
> modified my fstab file so that Linux checks my file system's health on
> the next boot.
If you experienced memory corruption, it would be wise to run some
hardware diagnosys tools, just to be sure. For example memtest86,
badblocks, etc.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2006-04-24 21:40 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-24 16:17 "could not open file" issue Daniel Caune <daniel.caune@ubisoft.com>
2006-04-24 19:02 ` Andrew Sullivan <ajs@crankycanuck.ca>
2006-04-24 19:21 ` Alvaro Herrera <alvherre@commandprompt.com>
2006-04-24 19:44 Re: "could not open file" issue Daniel Caune <daniel.caune@ubisoft.com>
2006-04-24 20:35 ` Alvaro Herrera <alvherre@commandprompt.com>
2006-04-24 20:38 Re: "could not open file" issue Daniel Caune <daniel.caune@ubisoft.com>
2006-04-24 21:02 Re: "could not open file" issue Daniel Caune <daniel.caune@ubisoft.com>
2006-04-24 21:40 ` Alvaro Herrera <alvherre@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox