database corruption?
От | Chris Jones |
---|---|
Тема | database corruption? |
Дата | |
Msg-id | x6d7pc80vv.fsf@reddwarf.rightnowtech.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] database corruption?
|
Список | pgsql-general |
Hi, all. I'm relatively new to PostgreSQL, but I've been quite impressed with it so far. This may be due to too much experience with MySQL. :) I'm currently getting this error on my nightly vacuum. These two indices (as you may have guessed already) are on columns named interface and ewhen, on a table named error. The error table is constantly being updated. (No comments about the implications of that, please.) NOTICE: Index error_interface_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS HEAP' (226765) NOTICE: Index error_ewhen_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS HEAP' (226765) NOTICE: Index error_interface_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS HEAP' (226765) NOTICE: Index error_ewhen_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS HEAP' (226765) Is this indicative of a serious problem? If this were MySQL, I'd assume I had a corrupt table, and I'd run isamchk on it. But I don't see a similar utility for PgSQL. AFAIK, nothing really bad has happened to the host; it hasn't crashed or anything, though it was rebooted ungracefully a few weeks ago. This is on an i386 running NetBSD 1.4.1, if that makes a difference. TIA for any help. Chris -- ---------------------------------------------------- cjones@rightnowtech.com Chris Jones System Administrator, Right Now Technologies, Inc. "Is this going to be a stand-up programming session, sir, or another bug hunt?"
В списке pgsql-general по дате отправления: