Hi Tilo, here is the output of the SQL commands, executed from SQLStudio, logged as DBA, DBA:
1) SELECT * FROM SYSDBM.INFO_BAD_INDEXES SYSDBFILESYSTEM CONTAINER CONTAINER_INDEX SYSDBFILESYSTEM INODE INODE_INDEX_1 SYSDBFILESYSTEM INODE INODE_INDEX_2 2) SELECT * FROM SYSDBM.INFO_BAD_INDEXES WHERE "Schema Name"='SYSDBFILESYSTEM' AND "Table Name"='INODE' AND "Index Name"='INODE_INDEX_1' SYSDBFILESYSTEM INODE INODE_INDEX_1 3) select BADINDEXES from SYSDD.DBM_STATE Returns: 3 4) select * from SYSDD.BAD_INDEXES SYSDBFILESYSTEM SYSDBFILESYSTEM CONTAINER CONTAINER_INDEX SYSDBFILESYSTEM SYSDBFILESYSTEM INODE INODE_INDEX_1 SYSDBFILESYSTEM SYSDBFILESYSTEM INODE INODE_INDEX_2 How should I log into DBMCLI in order to execute the sql_recreateindex command? Maybe that is the source of the problem, since the tables you mentioned seem to have the expected information. Best regards, Martin On 12/27/05, Heinrich, Tilo <[EMAIL PROTECTED]> wrote: > 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] > > -- 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]
