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,
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" |