Comment 3 for bug 1018685

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

@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
      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).

I will also attach full master and slave log.