Re: 8.3.5 broken after power fail

Поиск
Список
Период
Сортировка
От Michael Monnerie
Тема Re: 8.3.5 broken after power fail
Дата
Msg-id 43a3a0bccd3684972f33e0051b45f2b4@webmail.zmi.at
обсуждение исходный текст
Ответ на Re: 8.3.5 broken after power fail  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Ответы Re: 8.3.5 broken after power fail SOLVED  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Список pgsql-admin
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



В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: lseek
Следующее
От: Isabella Ghiurea
Дата:
Сообщение: Upgrade 8.3.6 issues