Re: 8.3.5 broken after power fail

News! The server even crashes when accessing certain messageblks:

The "physmessage" table contains mails with date, mails are stored in pieces
in "messageblks" (see ER model at
http://www.dbmail.org/dokuwiki/doku.php?id=er-model ). I try to find first
and last message with a problem, here the last:

select substring(m.messageblk,0,5) from dbmail_messageblks m join
dbmail_physmessage p on (p.id=m.physmessage_id) where p.id >= 1831634;

But that crashes the server completely:

2009-02-17 23:48:43 CET pid=5481 1/2 idle: LOG:  statement: select
substring(m.messageblk,0,5) from dbmail_messageblks m join
dbmail_physmessage p on (p.id=m.physmessage_id) where p.id >= 1831634;
2009-02-17 23:48:44 CET pid=5482  /usr/bin/postmaster: LOG:  connection
received: host=[local]
2009-02-17 23:48:44 CET pid=5413  : LOG:  server process (PID 5481) was
terminated by signal 11: Segmentation fault
2009-02-17 23:48:44 CET pid=5413  : LOG:  terminating any other active
server processes
2009-02-17 23:48:44 CET pid=5413  : LOG:  all server processes terminated;
reinitializing
2009-02-17 23:48:44 CET pid=5483 -1/0 : LOG:  database system was
interrupted; last known up at 2009-02-17 23:48:32 CET
2009-02-17 23:48:44 CET pid=5483 -1/0 : LOG:  database system was not
properly shut down; automatic recovery in progress
2009-02-17 23:48:44 CET pid=5483 -1/0 : LOG:  record with zero length at
E/382481B8
2009-02-17 23:48:44 CET pid=5483 -1/0 : LOG:  redo is not required
2009-02-17 23:48:44 CET pid=5483 -1/0 : LOG:  checkpoint starting: shutdown
immediate
2009-02-17 23:48:44 CET pid=5483 -1/0 : LOG:  checkpoint complete: wrote 0
buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled;
write=0.003 s, sync=0.000 s, total=0.013 s
2009-02-17 23:48:44 CET pid=5486 -1/0 : LOG:  autovacuum launcher started
2009-02-17 23:48:44 CET pid=5413  : LOG:  database system is ready to accept
connections

Damn, that crash really busted my db. I'd only like to have the rest of the
data from that table...

mfg zmi