From: | João Eugenio Marynowski <joaoem(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | table corrupted |
Date: | 2009-10-22 16:35:21 |
Message-ID: | 840f304c0910220935u422ed5b1s329f82adca06d52e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi everybody,
Can someone help me how to repair the problem below, I'm using Postgres
8.2.5:
- after appeared the erros below in selects, vacuum and dump in one table:
2009-10-16 16:07:06 BRT 192.168.0.87 ERROR: could not access status of
transaction 29024764
2009-10-16 16:07:06 BRT 192.168.0.87 DETAIL: Could not open file
"pg_clog/001B": No such file or directory.
2009-10-16 16:07:06 BRT 192.168.0.87 STATEMENT: select ...
2009-10-16 16:11:47 BRT 192.168.0.29 ERROR: invalid page header in block
462821 of relation "..."
2009-10-16 16:11:47 BRT 192.168.0.29 STATEMENT: select ....
I created the file pg_clog/001B with 256kB of /dev/zero
That resolve the problem with vacuum but began other error in selects and
dump to the same table ended all connections and stay up after showing the
error:
2009-10-19 13:50:03 BRT LOG: server process (PID 1544) was terminated by
signal 11
2009-10-19 13:50:03 BRT LOG: terminating any other active server processes
2009-10-19 13:50:03 BRT 192.168.0.253 WARNING: terminating connection
because of crash of another server process
2009-10-19 13:50:03 BRT 192.168.0.253 DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2009-10-19 13:50:03 BRT 192.168.0.253 HINT: In a moment you should be able
to reconnect to the database and repeat your command.
Was habilited the zero_damage_pages option then executed selects, vacuums,
and dumps but not changed...
Was identified 2 register that if refered cause error.
The BD was restored in backup server with 8.2.7 and executed vacuums ok but
select and reindex crashed...
Instaled 8.3.8 version and used pg_dump but error
And then the select below show the problem where the codentrega from where
clause differ from select answer:
LOGIST=# select codentrega from entregas where codentrega='9879622';
codentrega
------------
z879622
(1 registro)
Any idea?
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-10-22 16:42:49 | Re: Fwd: Reversing flow of WAL shipping |
Previous Message | David Jantzen | 2009-10-22 16:34:42 | Fwd: Reversing flow of WAL shipping |