Bug #71270 | Failures to end bulk insert for partitioned tables handled incorrectly | ||
---|---|---|---|
Submitted: | 2 Jan 2014 9:08 | Modified: | 6 Jan 2014 9:28 |
Reporter: | Laurynas Biveinis (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Storage Engine API | Severity: | S3 (Non-critical) |
Version: | 5.6.15 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | end_bulk_insert, ha_end_bulk_insert, handler, partition, TokuDB |
[2 Jan 2014 9:08]
Laurynas Biveinis
[2 Jan 2014 9:11]
Laurynas Biveinis
Testcase and fix (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Contribution: bug71720.patch (text/x-diff), 2.19 KiB.
[2 Jan 2014 9:19]
Laurynas Biveinis
s/71720/71270 in the patch
[2 Jan 2014 10:11]
MySQL Verification Team
Hello Laurynas, Thank you for the bug report and contribution. Verified as described. Thanks, Umesh
[6 Jan 2014 9:28]
Laurynas Biveinis
The testcase credit goes to Rich Prohaska. It seems that creating a testcase that uses MyISAM instead of error injection should be quite doable, we already have seen something similar in Percona Server RQG testing: https://bugs.launchpad.net/percona-server/+bug/1204871: 2013-07-20 15:52:08 17093 [Warning] Warning: Enabling keys got errno 137 on query018293.t1, retrying 2013-07-20 15:52:08 17093 [Warning] Warning: Enabling keys got errno 137 on query018293.t1, retrying 2013-07-20 15:52:08 17093 [Warning] Warning: Enabling keys got errno 137 on query018293.t1, retrying 2013-07-20 15:52:08 17093 [Warning] Warning: Enabling keys got errno 137 on query018293.t1, retrying 2013-07-20 15:52:08 17093 [Warning] Warning: Enabling keys got errno 137 on query018293.t1, retrying 2013-07-20 15:52:08 17093 [Warning] Warning: Enabling keys got errno 137 on query018293.t1, retrying 2013-07-20 15:52:08 17093 [Warning] Warning: Enabling keys got errno 137 on query018293.t1, retrying 2013-07-20 15:52:08 17093 [Warning] Warning: Enabling keys got errno 137 on query018293.t1, retrying 2013-07-20 15:52:08 17093 [Warning] Warning: Enabling keys got errno 137 on query018293.t1, retrying mysqld: /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/ha_partition.cc:4438: virtual int ha_partition::end_bulk_insert(): Assertion `0' failed. It appears one would need a partitioned MyISAM table and conditions as in e.g. bug 57168, such as too small myisam_sort_buffer_size.