Skip navigation links

MySQL Forums :: Data Recovery :: Data recovery from BINLOGS on NDBCLUSTER


Advanced Search

Data recovery from BINLOGS on NDBCLUSTER
Posted by: Ivan Ivanov ()
Date: September 04, 2009 02:39PM

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.

Options: ReplyQuote


Subject Views Written By Posted
Data recovery from BINLOGS on NDBCLUSTER 3053 Ivan Ivanov 09/04/2009 02:39PM
Re: Data recovery from BINLOGS on NDBCLUSTER 1945 Ivan Ivanov 09/14/2009 12:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.