Re: [GENERAL] database corruption?

Elmar.Haneke@gmx.de writes:

> Chris Jones schrieb:
>
> > 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)
>
> The Index does not contain tuples having NULL in the indexed field.
> You should check if you have an tuple containing NULL in your table.
> If so remove or change the tuple or ignore the message.

Table    = error
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| id                               | int4 not null default nextval (  |     4 |
| type                             | int2 not null                    |     2 |
| ewhen                            | datetime not null                |     8 |
| interface                        | varchar() not null               |    40 |
| severity                         | varchar()                        |     5 |
| extra                            | text                             |   var |
+----------------------------------+----------------------------------+-------+
Indices:  error_ewhen_idx
          error_extra_idx
          error_pkey

Since I wrote the original message, I've gotten rid of the "interface"
index and added the "extra" index, but I haven't changed any of the
columns in the table itself.  As you can see, they're declared as "not
null."

Dropping and re-creating the indices made the warning go away, though.

In addition, I started getting this two nights ago:

NOTICE:  Index pg_class_relname_index: NUMBER OF INDEX' TUPLES (74) IS NOT THE SAME AS HEAP' (75)
NOTICE:  Index pg_class_oid_index: NUMBER OF INDEX' TUPLES (74) IS NOT THE SAME AS HEAP' (75)

Needless to say, I haven't changed the schema for the PostgreSQL
system tables at all.

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?"