<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/>
