Re: Help desperately needed: reoccurring invalid page
От | Ian Westmacott |
---|---|
Тема | Re: Help desperately needed: reoccurring invalid page |
Дата | |
Msg-id | 1114693098.13031.16.camel@spectre.intellivid.com обсуждение исходный текст |
Ответ на | Help desperately needed: reoccurring invalid page header (Mauri Sahlberg <Mauri.Sahlberg@claymountain.com>) |
Ответы |
Re: Help desperately needed: reoccurring invalid page
|
Список | pgsql-admin |
Mauri, I'm no expert but I can tell you what I know. We have experienced this same problem, and I asked a similar question not too long ago. - This is probably due to some sort of I/O problem. In our case, it occurs very frequently on reboots, and it appears to be related to dirty buffers not being flushed out when the partition is unmounted. Look into a newer kernel, and/or newer/different filesystem (we have seen this in various flavors of the 2.4.6 kernel with XFS, JFS and EXT3). - If you have invalid page headers, you should take a look at the run-time parameter zero_damaged_pages. You can use this to fix up a table (losing the data on the bad pages). - We have not found a way around the missing log file problem. This appears to end up locking some rows forever. Others on this list may be able to tell you about tools for examining/fixing corrupt tables and log files. --Ian
В списке pgsql-admin по дате отправления: