MySQL Forums :: Cluster :: Strange Issue with NDB (Possibly Index)
Strange Issue with NDB (Possibly Index)
Posted by: Jonathan Jones
Date: January 14, 2013 03:29AM
I have a strange issue that I cant quite pin point and am struggling to know where to look.
We have an NDB table (across 2 nodes) that contains around 2.5 million records.
Recently (this has happened twice) a record has been attempted to be deleted from that table via the application sitting on top of it. This errorred.
If we go to the database via the SQL Workbench and try and delete that same record (by querying over fields other than the ID field) we get the message 0 rows affected. Likewise if we try and modify the record (via the ID) the changes dont take and the row is returned in its original state.
Furthermore, if we search for the record based on its ID, no results are found. However if we search using ID > (OURID -1) we can see it in the results. Other queries (not using the ID) also return the record.
Suspecting a corruption with indexes or the schema we have exported the data, killed the schema, recreated it and reimported the data. This then allows us to remove that record, however the issue eventually happens again on a different record.
Any thoughts of what or how to check this out would be greatly appreciated.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.