MySQL Forums :: NDB clusters :: Strange Issue with NDB (Possibly Index)

Advanced Search

Strange Issue with NDB (Possibly Index)
Posted by: Jonathan Jones ()
Date: January 14, 2013 03:29AM

Hi everyone.

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.

Kind regards


Options: ReplyQuote

Subject Views Written By Posted
Strange Issue with NDB (Possibly Index) 1233 Jonathan Jones 01/14/2013 03:29AM
Re: Strange Issue with NDB (Possibly Index) 663 Ted Wennmark 01/14/2013 06:15AM
Re: Strange Issue with NDB (Possibly Index) 615 Jonathan Jones 01/14/2013 08:00AM

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.