Hi All,



I have an installation running II 9.1.1 (a64.lnx/103)NPTL + 13001.



A database with a table that looks like...

create table reviewed_bloods(

cid integer not null not default,

trid integer not null not default,

test_type integer not null not default,

app_user varchar(25) not null not default

)

Its btree unique on the first, second and third columns.



Just threw some major wobblies...

E_DM9351_BTREE_BAD_TID Btree Error on table (reviewed_bloods,
harpdba) of database 'sharp_live' : Leaf page references non existent
tuple : Bid (15048, 38), Tid (0, 2), Key is '......:.....'
(000a000000003a0100000000).

E_DM9350_BTREE_INCONSIST Inconsistency found in Btree index.

E_DM9261_DM1B_GET Error occurred getting a record.

E_DM9100_LOAD_TABLE_ERROR Error occurred while loading a table for a
modify, index, or load table operation.

E_DM0091_ERROR_MODIFYING_TABLE Error modifying a table.

E_QE0083_ERROR_MODIFYING_TABLE Error modifying a table.



The table could not be modified insitu. E_QE0083 errors.



I found the only way to repair it was to copy it out, destroy the table
and then copy it back in...with backups before and after and no other
users in the database.



We found the auditdb trail was corrupted...

Before the error was noticed the auditdb produces...

Begin : Transaction Id 000048a250ff3c3c 26-Apr-2010 11:59:27.51
Username webdb

Insert/Append : Transaction Id 000048a250ff3c3c Id (670,0)
Table [reviewed_bloods,harpdba]

Record:
4d3600003448000003000000060064617669646c0000000000 0000000000000000000000
000000



Since the drop and recreate the auditdb is now producing...

Begin : Transaction Id 000048a2510025b4 26-Apr-2010 15:14:31.07
Username webdb

Insert/Append : Transaction Id 000048a2510025b4 Id (11146,0)
Table [reviewed_bloods,harpdba]

Record: <52500|7116|0|davidl>



Note the differefference in the 'Record' field...



verifydb on the table before hand was also pretty nasty.



Has anyone seen anything like this before?



I've schedulled a full database verifydb as well as a catalog level
check for tomorrow morning.



Martin Bowes