[MDEV-10156] Group commit tests fail on 10.2 InnoDB (branch bb-10.2-jan) Created: 2016-05-31 Updated: 2016-09-02 Resolved: 2016-08-30 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB, Tests |
| Affects Version/s: | 10.2 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Jan Lindström (Inactive) | Assignee: | Michael Widenius |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
bb-10.2-jan |
| Comments |
| Comment by Jan Lindström (Inactive) [ 2016-05-31 ] | ||||||||||||||||||||||||||||||
|
innodb.group_commit_binlog_pos [ disabled ] | ||||||||||||||||||||||||||||||
| Comment by Jan Lindström (Inactive) [ 2016-08-12 ] | ||||||||||||||||||||||||||||||
|
This with InnoDB 5.7 in branch bb-10.2-jan (please wait for email about status):
| ||||||||||||||||||||||||||||||
| Comment by Michael Widenius [ 2016-08-29 ] | ||||||||||||||||||||||||||||||
|
In 10.2 base, the first 2 INSERT statements are committed and the last INSERT is in prepared stage when the server is forced to restart. This causes the binlog file position to be different, as this points to where in the binlog the last row was committed, which is now different. This can be see in this part of the mysqld.1.err log for the new tree: One possible reason for this is that the signalling of the condition con1_loop is now done before the transaction is fully committed. | ||||||||||||||||||||||||||||||
| Comment by Michael Widenius [ 2016-08-30 ] | ||||||||||||||||||||||||||||||
|
Bug fix given to Jan |