Hi Tilo: In addition, an attempt to check the database structure ends with this error message:
./dbmcli -d prod -u dbm,dbm ./dbmcli on prod>db_execute check data ERR -24988,ERR_SQL: Sql error -9041,00000000030000000003 Database error file shows this: 2005-12-27 15:52:11 24 ERR 53019 CHECK Base error: index_not_accessib 2005-12-27 15:52:11 24 ERR 53019 CHECK Root pageNo: 140762 2005-12-27 15:52:11 24 ERR 53019 CHECK Base error: index_not_accessib 2005-12-27 15:52:11 24 ERR 53019 CHECK Root pageNo: 89427 2005-12-27 15:52:11 24 ERR 53019 CHECK Base error: index_not_accessib 2005-12-27 15:52:11 24 ERR 53019 CHECK Root pageNo: 106262 2005-12-27 16:14:23 24 ERR 53000 CHECK Check data finished unsuccessfully Best regards, Martin Cordova -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com On 12/27/05, Martin Cordova <[EMAIL PROTECTED]> wrote: > 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]
