Hello Martin, DBM command sql_recreateindex tries to determine, whether SYSDBFILESYSTEM.INODE.INODE_INDEX_1 is marked as bad or not. It therefore, executes the following SQL command:
SELECT * FROM SYSDBM.INFO_BAD_INDEXES WHERE "Schema Name"='SYSDBFILESYSTEM' AND "Table Name"='INODE' AND "Index Name"='INODE_INDEX_1'" It seems, that no result is returned for the select, hence the answer "Row not found". Please verify this. Please execute also an "sql_execute select BADINDEXES from SYSDD.DBM_STATE" and a "sql_execute select * from SYSDD.BAD_INDEXES" and post the result too. Best regards Tilo Heinrich -----Original Message----- From: Martin Cordova [mailto:[EMAIL PROTECTED] Sent: Monday, December 26, 2005 4:37 PM To: maxdb Subject: "Row not found" error when recreating index... 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
