Test innodb.percona_changed_pages is unstable
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
In Progress
|
Low
|
Unassigned | |||
5.7 |
In Progress
|
Low
|
Unassigned |
Bug Description
On 5.6 trunk:
innodb.
Test ended at 2017-01-31 14:40:03
CURRENT_TEST: innodb.
--- /mnt/workspace/
+++ /mnt/workspace/
@@ -189,7 +189,7 @@
SELECT COUNT(*) FROM INFORMATION_
WHERE START_LSN <= (@min_start_lsn - 1) OR END_LSN >= (@max_end_lsn + 1);
COUNT(*)
-0
+1
SELECT COUNT(*) FROM INFORMATION_
WHERE (START_LSN > @cond_test_max_lsn AND END_LSN < @cond_test_max_lsn)
OR (START_LSN > @cond_test_max_lsn + 10 AND END_LSN < @cond_test_max_lsn - 10);
@@ -197,7 +197,7 @@
0
SELECT @total_
should_be_1
-1
+0
SELECT @r1_r2_
should_be_1
1
tags: | added: bitmap ci |
With diagnostics:
include/assert.inc [No bitmap data must exist with END_LSN > @max_end_lsn] SCHEMA. INNODB_ CHANGED_ PAGES WHERE END_LSN > @max_end_lsn' SCHEMA. INNODB_ CHANGED_ PAGES WHERE END_LSN > @max_end_lsn' SCHEMA. INNODB_ CHANGED_ PAGES WHERE END_LSN > @max_end_lsn;;
######## Test assertion failed: No bitmap data must exist with END_LSN > @max_end_lsn ########
Dumping debug info:
Assertion text: 'No bitmap data must exist with END_LSN > @max_end_lsn'
Assertion condition: 'COUNT(*) = 0 FROM INFORMATION_
Assertion condition, interpolated: 'COUNT(*) = 0 FROM INFORMATION_
Assertion result: '0'
Assertion debug statement:
SELECT * FROM INFORMATION_
space_id page_id start_lsn end_lsn
0 5 1637007 1637017
safe_process[5896]: Child process: 5897, exit: 1
Thus, it is the transaction system header that gets updated