Test innodb.percona_changed_page_bmp_requests is unstable

Bug #1689989 reported by Laurynas Biveinis
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
New
Low
Unassigned
5.6
Fix Released
Low
Laurynas Biveinis
5.7
Fix Released
Low
Laurynas Biveinis

Bug Description

On 5.6 trunk:

innodb.percona_changed_page_bmp_requests w4 [ fail ]
        Test ended at 2017-05-09 15:57:20

CURRENT_TEST: innodb.percona_changed_page_bmp_requests
--- /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/ubuntu-zesty-32bit/mysql-test/suite/innodb/r/percona_changed_page_bmp_requests.result 2017-05-09 16:58:02.292490480 +0300
+++ /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/ubuntu-zesty-32bit/build/mysql-test/var/4/log/percona_changed_page_bmp_requests.reject 2017-05-09 22:57:19.926342839 +0300
@@ -16,18 +16,16 @@
 ib_modified_log_1
 After RESETs and restart:
 ib_modified_log_1
-ib_modified_log_2
 PURGE CHANGED_PAGE_BITMAPS BEFORE 1;
 After PURGE ... BEFORE 1:
 ib_modified_log_1
-ib_modified_log_2
 PURGE CHANGED_PAGE_BITMAPS BEFORE 100000000;
 PURGE CHANGED_PAGE_BITMAPS BEFORE 100000000;
 INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
 After PURGE ... BEFORE 100000000 and restart:
+ib_modified_log_2
 ib_modified_log_3
 ib_modified_log_4
-ib_modified_log_5
 PURGE CHANGED_PAGE_BITMAPS BEFORE 5+5;
 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+5' at line 1
 PURGE CHANGED_PAGE_BITMAPS BEFORE -12;
@@ -57,26 +55,26 @@
 0
 FLUSH CHANGED_PAGE_BITMAPS;
 Before the PURGE with tracking disabled
+ib_modified_log_2
 ib_modified_log_3
 ib_modified_log_4
-ib_modified_log_5
 PURGE CHANGED_PAGE_BITMAPS BEFORE 1;
 After the PURGE that deletes nothing:
+ib_modified_log_2
 ib_modified_log_3
 ib_modified_log_4
-ib_modified_log_5
 PURGE CHANGED_PAGE_BITMAPS BEFORE 100000000;
 After the PURGE that deletes everything but the last file:
-ib_modified_log_5
+ib_modified_log_4
 PURGE CHANGED_PAGE_BITMAPS BEFORE 100000000;
 After the repeated PURGE:
-ib_modified_log_5
+ib_modified_log_4
 call mtr.add_suppression("last tracked LSN");
 INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
 Before the RESET while tracking disabled:
+ib_modified_log_4
 ib_modified_log_5
 ib_modified_log_6
-ib_modified_log_7
 RESET CHANGED_PAGE_BITMAPS;
 After the RESET with tracking disabled:
 Created dummy bitmap files

Tags: bitmap ci
tags: added: bitmap ci
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2272

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.