[MDEV-20389] The test innodb.innodb_bug84958 fails intermittently Created: 2019-08-19 Updated: 2019-08-20 Resolved: 2019-08-20 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB, Tests |
| Affects Version/s: | 10.2, 10.3, 10.4 |
| Fix Version/s: | 10.2.27, 10.3.18, 10.4.8 |
| Type: | Bug | Priority: | Major |
| Reporter: | Marko Mäkelä | Assignee: | Aleksey Midenkov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | tests | ||
| Issue Links: |
|
||||||||
| Description |
|
I observed the following test failure locally once:
In my opinion, such SELECT expressions should be better replaced with something that reports a useful value on failure, like this:
Please perform this change locally (or just remove the <500 in case the number is stable) and then repeat the test for many times locally. You should also make sure that there is no other workload from previous tests that could cause innodb_buffer_pool_read_requests to be incremented. Either you should somehow force a rebootstrap, or you must ensure that the following have been performed:
For the change buffer merge, it probably is easiest to do
For ensuring the completion of purge, you should use wait_all_purged.inc, with the necessary preparation at the start of the test or immediately after server restart:
You should probably also ensure that no read-ahead is enabled. |