Data recovery from BINLOGS on NDBCLUSTER

[Ivan Ivanov]

We execute UPDATE command on a ndbcluster:
mysql> UPDATE TESTBASE.CACHE SET STATE_ID=300 WHERE CACHE_ID=1166576;

As a result 2 operations INSERT which loadings at attempt call an error get to a binary log:

ERROR 1062 (23000): Duplicate entry '1166576' for key 'PRIMARY'

All operations "UPDATE" are substituted on "INSERT"
How correctly to load such data?

#mysqlbinlog -v log-bin.0001:
BINLOG '
ubenShMBAAAARgAAP1uLwMAADEAAAAAAAAAB1NLWNFTkQABUNBQ0hFABMICAMDAwMDAwMDBAcH
DwgDBwMDAwT/AAAABA==
ubenShMBAAAAPgAAADtvLwMAABAAAAAAAAAABW15c3FsABBuZGJfYXBwbHlfc3RhdHVzAAUDCA8I
CAL/AAA=
ubenShcBAAAAOwAAAHZvLwMAABAAAAAAAAABR/gAQAAAAsAAAD9GwAAAAAAAAAAAAAAAAAAAAAA
AAA=
### INSERT INTO mysql.ndb_apply_status
### SET
### @1=1
### @2=30773440675851
### @3=''
### @4=0
### @5=0
ubenShcBAAAALAAAKJvLwMQADEAAAAAAAEAE0EAAPzwzBEAAAAAACwBAAA=
'/*!*/;
### INSERT INTO TESTBASE.CACHE
### SET
### @1=84442493013196817
### @7=NULL
### INSERT INTO TESTBASE.CACHE
### SET
### @1=0
### @7=0
# at 53440418



Edited 2 time(s). Last edit at 09/09/2009 08:20AM by Ivan Ivanov.