[MDEV-14916] Innodb reports warning for "Purge reached the head of the history list" should be removed. Created: 2018-01-11 Updated: 2020-08-25 Resolved: 2018-01-11 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB, Storage Engine - XtraDB |
| Affects Version/s: | 5.5.33a, 10.0.6, 10.1.0, 10.2.0, 10.3.0 |
| Fix Version/s: | 5.5.59, 10.0.34, 10.3.4, 10.1.31, 10.2.13 |
| Type: | Bug | Priority: | Major |
| Reporter: | Nilnandan Joshi | Assignee: | Marko Mäkelä |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
This warning should appear only in debug version and as it doesn't occur any corruption the msg in misleading. Below is the test case. As the history list length limit is 2000000, we have apply patch to mysqld and change it to 0x1234 = 4660 so we can test it bit faster. Step:1 Create table like "CREATE TABLE t ENGINE=InnoDB SELECT 1 a;” Step:4 After 30K update, start one more session 2 with `START TRANSACTION WITH CONSISTENT SNAPSHOT;` Got warnings in error log like,
|
| Comments |
| Comment by Nilnandan Joshi [ 2018-01-11 ] |
|
Looks like this : https://bugs.mysql.com/bug.php?id=82213 |
| Comment by Marko Mäkelä [ 2018-01-11 ] |
|
Some further analysis of this is in my commit message. |