Bug #5786 Duplicate key error after restore
Submitted: 28 Sep 2004 14:42 Modified: 1 Oct 2004 22:19
Reporter: Johan Andersson
Status: Closed
Category:Server: Cluster Severity:S2 (Serious)
Version:mysql 4.1.6 OS:Fermi Linux LTS 3.01
Assigned to: Tomas Ulin Target Version:

[28 Sep 2004 14:42] Johan Andersson 
Description:
4 node cluster.

See "How to repeat"

How to repeat:
start a 4 node cluster.

create database foo;
use foo;
create table bar (a bigint(20), b integer) type=ndb;

insert into bar values(0,0);

* Stop mysqld

* Take backup

* all restart -i

* restore from backup (-m -n 1, then -r -n 1..4)

* run mysqld

mysql> insert into bar values(0,0);
Query OK, 1 row affected (0.04 sec)

mysql> insert into bar values(0,0);
Query OK, 1 row affected (0.04 sec)

mysql> insert into bar values(0,0);
ERROR 1062 (23000): Duplicate entry '' for key 65
[1 Oct 2004 22:19] Tomas Ulin 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html