• aelkin/elkin@koti.dsl.inet.fi's avatar
    Bug#31552 Replication breaks when deleting rows from out-of-sync table · d8d6db6f
    aelkin/elkin@koti.dsl.inet.fi authored
        without PK
    Bug#31609 Not all RBR slave errors reported as errors
    bug#32468 delete rows event on a table with foreign key constraint fails
    
    The first two bugs comprise idempotency issues.
    First, there was no error code reported under conditions of the bug
    description although the slave sql thread halted.
    Second, executions were different with and without presence of prim key in
    the table.
    Third, there was no way to instruct the slave whether to ignore an error
    and skip to the following event or to halt.
    Fourth, there are handler errors which might happen due to idempotent
    applying of binlog but those were not listed among the "idempotent" error
    list.
    
    All the named issues are addressed.
    Wrt to the 3rd, there is the new global system variable, changeble at run
    time, which controls the slave sql thread behaviour.
    The new variable allows further extensions to mimic the sql_mode
    session/global variable.
    To address the 4th, the new bug#32468 had to be fixed as it was staying
    in the way.
    d8d6db6f
rpl_foreign_key_innodb.result 1.28 KB