Problem with a transaction on dump

From: "Froggy / Froggy Corp(dot)" <froggy(at)froggycorp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with a transaction on dump
Date: 2007-04-04 11:39:04
Message-ID: 46138E58.E3F39011@froggycorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

It is the second time i got this error message (sorry, its french, i
prefer to c/p this one than making a bad translation) :

-------8<------------8<-----------8<-----------

pg_dump: ERREUR: Impossible d'accéder au statut de la transaction
892415538
DETAIL: Impossible d'ouvrir le fichier
«/var/lib/postgresql/7.4/main/pg_clog/0353» : Aucun fichier ou
répertoire de ce type
pg_dump: La commande SQL de sauvegarde du contenu de la table "facture"
a échoué : échec de PQendcopy().
pg_dump: Message d'erreur du serveur : ERREUR: Impossible d'accéder au
statut de la transaction 892415538
DETAIL: Impossible d'ouvrir le fichier
«/var/lib/postgresql/7.4/main/pg_clog/0353» : Aucun fichier ou
répertoire de ce type
pg_dump: La commande était : COPY public.facture ([...]) TO stdout;

-------8<------------8<-----------8<-----------

It say that it cant access to the transaction id 892415538 because the
file /var/lib/postgresql/7.4/main/pg_clog/0353 dont exist. And this file
doesn't exist.
I use PG 7.4.16 on linux debian etch. I already made a HD & memory test,
and i find nothing wrong.

Last time i got this error, the only solution was to get a "safe" backup
and lost some data. But i didnt have time to manage this server, so this
error is here for a couple of day, and im afraid about how many data may
be lost.

So if someone have an idea to have a "safe" backup and start on a clean
database...

Thx in advance,
Regards,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Silvela 2007-04-04 12:37:17 Re: COPY FROM - how to identify results?
Previous Message Huynh Ngoc Doan 2007-04-04 09:42:20 Need your help on using "partion"