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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
