Bug #10219 any table query results in ERROR 1032 (HY000): Can't find record in ...

• Submitted: 27 Apr 2005 22:00
• Modified: 2 Jun 2005 6:13
• Reporter: Matthew Burgoon
• Status: No Feedback
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 4.1.11 max
• OS: Linux (Linux)
• CPU Architecture: Any

[27 Apr 2005 22:00] Matthew Burgoon

Description:
I seem to have some sort of corruption in this NDB table (test environment.)

I can select a number of individual records, but a blanket select * will result in a 'ERROR 1032 (HY000): Can't find record in ...' error message. Limit works through the first 29 records, but going from limit 29 to limit 30 it breaks.

I was playing with cluster, ended up mucking it up, and having to do an ndb_restore, and in restarting a couple of things, I may have involved mixing 4.1.7 and 4.1.11 versions, but at this moment all NDB storage nodes and MySQL clients are on 4.1.11. I can see nothing in the clusterlog file when I turn overly verbose logging on.

How to repeat:
I will try and reproduce, but I doubt that I'll have much luck.

[2 May 2005 6:13] Martin Skold

This is too little information to able to do any analyzing
what the problem could be.
You can try use command line tools such as
ndb_select_count to verify that the number of records is
what it should be and ndb_select_all to look at all records
of a table (of not too many).

[2 Jun 2005 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".