From: Michael Monnerie <michael.monnerie@is.it-management.at>
To: pgsql-admin@postgresql.org
Subject: Re: 8.3.5 broken after power fail
Date: Tue, 17 Feb 2009 23:55:15 +0100
Message-ID: <43a3a0bccd3684972f33e0051b45f2b4@webmail.zmi.at> (raw)
In-Reply-To: <de3f3b06f55e4f88b0ced132435bcd96@webmail.zmi.at>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: michael.monnerie@is.it-management.at
Subject: Re: 8.3.5 broken after power fail
In-Reply-To: <43a3a0bccd3684972f33e0051b45f2b4@webmail.zmi.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox