After restoring from 7.4 to 7.6, with the database in online mode, the following indexes are reported BAD by DBMGUI, all from the schema SYSDBFILESYSTEM:
INODE.INODE_INDEX1 INODE.INODE_INDEX2 CONTAINER.CONTAINER_INDEX When trying to rebuild any of these indexes an error occurs: ./dbmcli on prod>sql_recreateindex SYSDBFILESYSTEM.INODE.INODE_INDEX_1 ERR -24988,ERR_SQL: Sql error 100,Row not found A "check extended" reported these problems: 2005-12-22 18:44:45 24 ERR 53019 CHECK Base error: index_not_accessib 2005-12-22 18:44:45 24 ERR 53019 CHECK Root pageNo: 140762 2005-12-22 18:44:45 24 ERR 53019 CHECK Base error: index_not_accessib 2005-12-22 18:44:45 24 ERR 53019 CHECK Root pageNo: 89427 2005-12-22 18:44:45 24 ERR 53019 CHECK Base error: index_not_accessib 2005-12-22 18:44:45 24 ERR 53019 CHECK Root pageNo: 106262 I already updated system tables several times (load_systab), also updated statistics on system tables (sql_updatestat_per_systemtable). Is there a workaround for this problem? Best regards, Martin -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
