Bug #5786 Duplicate key error after restore
Submitted: 28 Sep 2004 12:42 Modified: 1 Oct 2004 20:19
Reporter: Johan Andersson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysql 4.1.6 OS:Fermi Linux LTS 3.01
Assigned to: Tomas Ulin CPU Architecture:Any

[28 Sep 2004 12: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 20: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