[Info-ingres] W_DM500C_ORPHAN_DATA_PAGE

[Martin Bowes]

And an addendum...

I copied the data to disk and loaded it into a temp database. The expected number of rows  came with it and the verifydb said the same thing on the temp database.

I modified the table to reconstruct with nocompression and the verifydb problem disappeared.

So I've decided that the message is probably more incendiary than real.

Marty

From: Martin Bowes [mailto:martin.bowes at ndph.ox.ac.uk]
Sent: 08 October 2018 10:51
To: info-ingres at lists.planetingres.org
Subject: [Info-ingres] W_DM500C_ORPHAN_DATA_PAGE

Hi All,

Recently had a need to run verifydb over every table in a  database. How concerned should I be about:

W_DM502B_INVALID_BT_KIDS   WARNING:  index/leaf page 1 is unreadable because bt_kids has invalid value
of 511.  (Valid values range from 0 to 510.)
...
W_DM500C_ORPHAN_DATA_PAGE  WARNING:  data page 326618 is an unreferenced page (or orphan).  All data on this
page or any overflow pages chained to it is effectively lost.

How concerned should I be given these are warnings?

The table in question is a btree unique. It has data and key compression.

Martin Bowes

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20181008/abfc59df/attachment.html>