MySQL Bugs: #35510: Error: "Can't find record in 'users'" in mysql cluster system (6.3.101.7)

Bug #35510	Error: "Can't find record in 'users'" in mysql cluster system (6.3.101.7)
Submitted:	24 Mar 2008 7:52	Modified:	22 May 2008 12:57
Reporter:	Glen CAO	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	6.3.101.7	OS:	Linux (RedHat ES4)
Assigned to:		CPU Architecture:	Any
Tags:	can't find record, cluster, delete

Description:
Hi,

I am using mysql cluster and got a exception when I did a DELETE operation.
Mysql throw the exception: "Can't find record in ''".

Below is the definition of the table:
CREATE TABLE users (user_key varchar(128) NOT NULL default '',... ...,UNIQUE KEY user_idx(user_key)) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

And the version of Mysql/cluster:
Mysql  6.3.101.7 
Mysql Cluster 6.3.101.7 

And the ENGINE of all the tables in my system is 'ndbcluster'

Of course, there're also other tables in my system and the exception is thrown out everytime the DELETE operation goes to the table 'users'...

Please help to forward this bug to the right sub-forum if this is not the right place to ask this kind of question.

Thanks,
Glen

How to repeat:
Create table:
CREATE TABLE users (user_key varchar(128) NOT NULL default '',... ...,UNIQUE KEY user_idx(user_key)) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

Operation:
Insert some records;
Delete from users where user_key='xxx';

Thank you for the report.

I can not repeat described behavior in test environment.

Please provide full output of SHOW CREATE TABLE users, your cluster and mysqld log files and indicate how many records has table users.

Hi,

Currently, the error occurs when write table 'comm_stgs_ps'.
I uploaded the files as you request and provided .sql file and all the details I have in readme.txt.
Please read the readme.txt first to prepare your test environment.

Thanks,
Glen

Hi,

Can you reproduce the issue in your lab?
Any updates?

Thanks,
Glen

Any updates?
I am not sure if I have some wrong configurations or not... Just want to know if there are any finding, solution or workaround...

Thanks,
Glen

Thank you for the provided data.

We are analysing it currently. No results so far.

updates?...

Thank you for the feedback.

In file ndb_2_error.log there is error: "Error data: Illegal configuration change. Initial start needs to be performed  when changing no of replicas (1 != 2)"

Also in file many errors like (real names ahve been removed):

080324 16:37:47 [ERROR] /opt/proxy/mysql/libexec/mysqld: Incorrect information in file: './database/table.frm'

Did you do any configuration changes after tables were created? Also there is no table users in provided dump. What is the real name of table users?

Thanks for the reply.

I am not sure what change belongs to 'configuration changes' as you mentioned, could you please tell me more about this?
I altered some tables (add new fields) after they were created, that would be the reason?

Actually, I found this issue by doing writing operations on user table firstly, but I didn't save the data of that table in time. And then I also found the same issue when I did operations on tables 'comm_stgs_ps', so I saved the data and gathered more details.

Thanks,
Glen

Thank you for the feedback.

As 'configuration changes' I mean changes in configuration files.

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".