1) HA_ERR_KEY_NOT_FOUND UPDATE_ROWS_EVENT: write 'Before Image' of the record, and then update it DELETE_ROWS_EVENT: write the record and then delete it , or just ignore the error
--------> Worked fine for both the events.
2)HA_ERR_FOUND_DUPP_KEY
WRITE_ROWS_EVENT: just overwrite the record
UPDATE_ROWS_EVENT : delete the duplicated record and then update (if the error is caused because of duplicated unique key and the table also has a primary key , the fix may failed and all changes can be rollback)
Worked for WRITE_ROWS_EVENT but failed for UPDATE_ROWS_EVENT for primary key as well unique key (on non primary key column).
@hickey, @yinfeng,
Thanks for the patch. I tested the latest patch on latest PS bzr head and the patch applied well and built. -- http:// sprunge. us/abXX
My.cnf -- http:// sprunge. us/JZKD
Now,
1) HA_ERR_ KEY_NOT_ FOUND
UPDATE_ ROWS_EVENT: write 'Before Image' of the record, and then update it
DELETE_ ROWS_EVENT: write the record and then delete it , or just ignore the error
--------> Worked fine for both the events.
2)HA_ERR_ FOUND_DUPP_ KEY ROWS_EVENT: just overwrite the record ROWS_EVENT : delete the duplicated record and then update (if the error is caused because of duplicated unique key and the table also has a primary key , the fix may failed and all changes can be rollback)
WRITE_
UPDATE_
Worked for WRITE_ROWS_EVENT but failed for UPDATE_ROWS_EVENT for primary key as well unique key (on non primary key column).
I will also attach full master and slave log.