[Info-ingres] W_DM500C_ORPHAN_DATA_PAGE

[Martin Bowes]

We tried.

It didn't.

I was disappointed.

Marty

From: Laframboise, André (BAC/LAC) [mailto:andre.laframboise at canada.ca]
Sent: 09 October 2018 13:53
To: Martin Bowes; info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] W_DM500C_ORPHAN_DATA_PAGE

Hi,

Errors look related to an indexing structure problem. Data pages themselves seem to be intact. A verifydb -table operation may have also fixed it.

André Laframboise

Conseiller Principal Base de Données, Direction générale de l'Innovation et du Dirigeant principal de l'information
Bibliothèque et Archives Canada<http://www.bac-lac.gc.ca/fra/Pages/bac-web.aspx> / Gouvernement du Canada
andre.laframboise at canada.ca<mailto:andre.laframboise at canada.ca> / Tél. : 613-298-1346

Senior Database Advisor, Innovation and Chief Information Officer Branch
Library and Archives Canada<http://www.bac-lac.gc.ca/eng/Pages/lac-web.aspx> / Government of Canada
andre.laframboise at canada.ca<mailto:andre.laframboise at canada.ca> / Tel: 613-298-1346

[Image removed by sender. http://www.bac-lac.gc.ca/eng/events/PublishingImages/banner.jpg]<http://www.bac-lac.gc.ca/eng/events/Pages/events.aspx>

From: info-ingres-bounces at lists.planetingres.org <info-ingres-bounces at lists.planetingres.org> On Behalf Of Martin Bowes
Sent: Monday, October 8, 2018 6:46 AM
To: Martin Bowes <martin.bowes at ndph.ox.ac.uk>; info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] W_DM500C_ORPHAN_DATA_PAGE

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<mailto: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/20181010/7b20c721/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 752 bytes
Desc: image001.jpg
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20181010/7b20c721/attachment.jpg>