table corrupted
| От | João Eugenio Marynowski |
|---|---|
| Тема | table corrupted |
| Дата | |
| Msg-id | 840f304c0910220928u26ca57f2wf2928cc26b358c79@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: table corrupted
Re: table corrupted Re: table corrupted |
| Список | pgsql-hackers |
Hi<br /><br />Can someone help me how to repair the problem below, I'm using Postgres 8.2.5:<br />- after appeared the errosbelow in selects, vacuum and dump in one table:<br />2009-10-16 16:07:06 BRT 192.168.0.87 ERROR: could not access statusof transaction 29024764<br /> 2009-10-16 16:07:06 BRT 192.168.0.87 DETAIL: Could not open file "pg_clog/001B": Nosuch file or directory.<br /> 2009-10-16 16:07:06 BRT 192.168.0.87 STATEMENT: select ...<br />2009-10-16 16:11:47 BRT192.168.0.29 ERROR: invalid page header in block 462821 of relation "..."<br />2009-10-16 16:11:47 BRT 192.168.0.29 STATEMENT: select ....<br /> I created the file pg_clog/001B with 256kB of /dev/zero <br />That resolve the problem withvacuum but began other error in selects and dump to the same table ended all connections and stay up after showing theerror:<br /> 2009-10-19 13:50:03 BRT LOG: server process (PID 1544) was terminated by signal 11<br />2009-10-19 13:50:03BRT LOG: terminating any other active server processes<br />2009-10-19 13:50:03 BRT 192.168.0.253 WARNING: terminatingconnection because of crash of another server process<br /> 2009-10-19 13:50:03 BRT 192.168.0.253 DETAIL: Thepostmaster has commanded this server process to roll back the current transaction and exit, because another server processexited abnormally and possibly corrupted shared memory.<br /> 2009-10-19 13:50:03 BRT 192.168.0.253 HINT: In a momentyou should be able to reconnect to the database and repeat your command.<br />Was habilited the zero_damage_pages optionthen executed selects, vacuums, and dumps but not changed...<br />Was identified 2 register that if refered cause error.<br/><div class="gmail_quote">The BD was restored in backup server with 8.2.7 and executed vacuums ok but select andreindex crashed...<br /></div><div class="gmail_quote"><font color="#888888"><font color="#000000">Instaled 8.3.8 versionand used pg_dump but error</font></font></div><div class="gmail_quote">And then the select below show the problemwhere the codentrega from where clause differ from select answer:<br /></div><font color="#888888">LOGIST=# selectcodentrega from entregas where codentrega='9879622';<br /> codentrega<br />------------<br /> z879622<br />(1 registro)<br/></font><br />Any idea?<br />
В списке pgsql-hackers по дате отправления: