Reason:
------
Partition table are handled using ha_partition handler which in turn creates
"n" different ha_innodb handlers one for each partition.
When data is inserted in partitioned table to avoid repeat bin-logging
partition handler disables bin-logging while invoking ha_innodb interface and
re-enables it on completion. bin-logging is then done as part of ha_partition
handler interface.
ha_innodb skips key-append if bin-logging is disabled (and especially with LDI
involved). [This is looks like a design choice than bug]
Without append_key, statement can't be be forward to galera plugin for
certification which actually causes LDI to fail.
Solution:
--------
Relax the append-key condition to consider involvement of LDI with partitioned
table.
commit 7caf48a7fcdd365 aec979eabbf0699 b336068668
Author: Krunal Bauskar <email address hidden>
Date: Thu Nov 5 13:51:31 2015 +0530
- Disabling intermittently failing TCs. File JIRA issue to track them
commit 555f152b7a1793c 76e2d784ee751db bbf084f3f9
Author: Krunal Bauskar <email address hidden>
Date: Thu Nov 5 10:22:00 2015 +0530
- PXC#467: LDI on partitioned table fails
Issue:
-----
LDI on partitioned table fails
Reason:
------
Partition table are handled using ha_partition handler which in turn creates
"n" different ha_innodb handlers one for each partition.
When data is inserted in partitioned table to avoid repeat bin-logging
partition handler disables bin-logging while invoking ha_innodb interface and
re-enables it on completion. bin-logging is then done as part of ha_partition
handler interface.
ha_innodb skips key-append if bin-logging is disabled (and especially with LDI
involved). [This is looks like a design choice than bug]
Without append_key, statement can't be be forward to galera plugin for
certification which actually causes LDI to fail.
Solution:
--------
Relax the append-key condition to consider involvement of LDI with partitioned
table.