E_US0082 Error ... when trying destroy a database

[dbrooks]

I am getting the following message when I try to do a destroydb on an old test database ...

(Note: I see some mention of this error when I search around but not with respect to dropping a whole database, and that's what has me a bit more concerned.)

E_US0082 Error occurred updating the IIDATABASE table in the IIDBDB
database.
Check error log (errlog.log) for more information.
(Tue Jan 31 11:45:02 2012)
Destruction of database 'test' abnormally terminated.

The errlog.log has this to say ...

SERVER ::[32812, 06774900]: Tue Jan 31 11:45:02 2012 E_DM9385_NO_INDEX_TUPLE
Cannot locate secondary index row for base table row at TID 6144.

SERVER ::[32812, 06774900]: Tue Jan 31 11:45:02 2012 E_DM9387_INDEX_UPDATE_ERROR
Update failed due to inability to update secondary index table.

SERVER ::[32812, 06774900]: Tue Jan 31 11:45:02 2012 E_DM9386_SEC_INDEX_ERROR
Error updating secondary index,iidbid_idx, for change to base table row at TID 6144.

SERVER ::[32812, 06774900]: Tue Jan 31 11:45:02 2012 E_DM9387_INDEX_UPDATE_ERROR
Update failed due to inability to update secondary index table.

Never had a problem like this before. Could it mean a general problem across the installation or just this database?

This is on ...
II 2.6/0604 (su4.us5/00)
SP5
Solaris 10

Thanks for any guidance.

David.

[kschendel]

Try sysmod iidbdb. It sounds like the index on the iidatabase catalog is hosed for some reason. If the base catalog is OK, a sysmod has a good chance of fixing it.

[dbrooks]

Thanks Karl. Will try and advise if it worked ... will let the client do it though.