From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
---|---|
To: | Reimer <carlosreimer(at)terra(dot)com(dot)br> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: URGENT! could not access status of transaction |
Date: | 2006-03-24 14:05:52 |
Message-ID: | 20060324140552.GK90527@pervasive.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Mar 24, 2006 at 10:51:25AM -0300, Reimer wrote:
> I forgot to mention postgreSQL version: 7.4.6
Had you been running the latest 7.4 release, this probably wouldn't have
happened. There's been a number of data-loss bugs fixed since 7.4.6.
> Thanks!
> ----- Original Message -----
> From: Reimer
> To: pgsql-general(at)postgresql(dot)org
> Sent: Friday, March 24, 2006 10:41 AM
> Subject: [GENERAL] URGENT! could not access status of transaction
>
>
> Hello,
>
> We had some disk problems here and now pg_dump is complaining with:
>
> pg_dump: ERROR: could not access status of transaction 1768711534
> DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0696": Arquivo ou dire
> t?rio n?o encontrado
> pg_dump: SQL command to dump the contents of table "tt_fin" failed: PQendcopy() fa
> iled.
> pg_dump: Error message from server: ERROR: could not access status of transaction
> 1768711534
> DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0696": Arquivo ou dire
> t?rio n?o encontrado
> pg_dump: The command was: COPY "REIMER".tt_fin (codfil, sequen, tipger, tipnum, co
> dusu, filger, filnum, filusu, seqger, seqnum, datope, vlrmov, seqtrn, codctr, codc
> us, numdoc, observ, flgfin, chvtrn, atu_em) TO stdout;
>
> I know is something related with the hardware and not with postgresql but I don?t want to restore all the database.
>
> How is the best way to fix? pg_resetxlog?
>
> Thanks in advance!
>
> Reimer
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
From | Date | Subject | |
---|---|---|---|
Next Message | roman.motyka | 2006-03-24 14:38:20 | ADO.NET ExecuteReader returns no rows |
Previous Message | John D. Burger | 2006-03-24 13:56:18 | Re: another seemingly simple encoding question |