Re: Unexpected error when attempting to delete a database volume

Quoting Neil Brown <[email protected]>:

> Hi,
>
> I would like to be able to delete a volume but get the following error log.
> Any advice on how to force through the deletion would be greatly
> appreciated.
>
> Thanks
>
> Neil
>

> 2007-04-25 10:01:14      0x9F0 ERR 20006 Kernel    +   Header [ 7608142 -
> data - inv - checksumData - empty ]

the page seems to be part of an index tree - as the pagetype 'inv' indicates.
You can try to identify the concerned index file and drop or recreate it.
...
> 2007-04-25 10:01:20      0x9F0 ERR 20039 IOMan    Bad data page - Requested
> pageno 7608142 (perm) read pageno 7608142
> 2007-04-25 10:01:20      0x9F0 ERR 20020 Data     Bad data page 7608142
> belongs to root 2147483647 which is of filetype 'Table'

the root '2147483647' equals to '-1', the invalid root, so there is no
hint to identify the file :-(
Start a check of the database structure (best in admin mode) to identify
the corrupted file, recreate it and free the way for the deletion of the
volume.

> 2007-04-25 10:01:36      0x11C ERR 51080 SYSERROR unexpected error
> 2007-04-25 10:01:36      0x11C ERR 20076 IOMan    Drop data volume failed -
> volume 36 still contains 2 pages

The volume still contains two pages, the single corrupted page and the
internal info page, which is OK.


   Henrik


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]