table corrupted
От | João Eugenio Marynowski |
---|---|
Тема | table corrupted |
Дата | |
Msg-id | 840f304c0910220935u422ed5b1s329f82adca06d52e@mail.gmail.com обсуждение исходный текст |
Список | pgsql-hackers |
<div class="gmail_quote">Hi everybody,<br />Can someone help me how to repair the problem below, I'm using Postgres 8.2.5:<br/>- after appeared the erros below in selects, vacuum and dump in one table:<br />2009-10-16 16:07:06 BRT 192.168.0.87ERROR: could not access status of transaction 29024764<br /> 2009-10-16 16:07:06 BRT 192.168.0.87 DETAIL: Couldnot open file "pg_clog/001B": No such file or directory.<br /> 2009-10-16 16:07:06 BRT 192.168.0.87 STATEMENT: select...<br />2009-10-16 16:11:47 BRT 192.168.0.29 ERROR: invalid page header in block 462821 of relation "..."<br />2009-10-1616: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 with vacuum but began other error in selects and dump to the same table ended allconnections and stay up after showing the error:<br /> 2009-10-19 13:50:03 BRT LOG: server process (PID 1544) was terminatedby signal 11<br />2009-10-19 13:50:03 BRT LOG: terminating any other active server processes<br />2009-10-1913:50:03 BRT 192.168.0.253 WARNING: terminating connection because of crash of another server process<br />2009-10-19 13:50:03 BRT 192.168.0.253 DETAIL: The postmaster has commanded this server process to roll back the currenttransaction and exit, because another server process exited abnormally and possibly corrupted shared memory.<br />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 yourcommand.<br />Was habilited the zero_damage_pages option then 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 inbackup server with 8.2.7 and executed vacuums ok but select and reindex crashed...<br /></div><div class="gmail_quote"><fontcolor="#888888"><font color="#000000">Instaled 8.3.8 version and used pg_dump but error</font></font></div><divclass="gmail_quote">And then the select below show the problem where the codentrega from whereclause differ from select answer:<br /></div><font color="#888888">LOGIST=# select codentrega from entregas where codentrega='9879622';<br/> codentrega<br />------------<br /> z879622<br />(1 registro)<br /></font><br />Any idea?<br /></div><br/>
В списке pgsql-hackers по дате отправления: