Re: [HACKERS] Index corruption
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] Index corruption |
Дата | |
Msg-id | 199912291407.JAA02208@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] Index corruption (Adriaan Joubert <a.joubert@albourne.com>) |
Список | pgsql-hackers |
> Further to my problem: I've run the vacuum in a backend under the debugger and > at least figured out in which > loop the zillions of files are created. It is in md.c. In the stack trace > below, you can see that blockno has got a totally stupid value and in the loop > in lines 1049-1063 in md.c (v 6.5.3. sources) it opens zillions of files. If > anybody knows where this comes from I'd appreciate it. In the meantime I'll > try to dig a bit further. Were you the person I told to use pg_upgrade and re-initdb your database? If not, I would recommend that as the fix. You may need to re-enable pg_upgrade by editing the script. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: