Bug #119744 mysqlbackup_page_track_purge_up_to not working

• Submitted: 22 Jan 9:52
• Reporter: WANG jiaming
• Status: Open
• Category: MySQL Server: InnoDB storage engine
• Severity: S2 (Serious)
• Version: 9.6.0
• OS: Any
• CPU Architecture: Any
• Tags: innodb

[22 Jan 9:52] WANG jiaming

Description:
udf  mysqlbackup_page_track_purge_up_to not working, not purging tracked page data.

How to repeat:
 install component 'file://component_mysqlbackup';

1. Run sysbench read write, keep running.
2. Execute: select mysqlbackup_page_track_purge_up_to(1); --start page tracking
3. Execute: select mysqlbackup_page_track_purge_up_to(0); --stop page tracking
4. Eepeat step 2-3 to generate more page groups in datadir/#ib_archive
  in my datadir/#ib_archive, there for page groups:
page_group_609152609  page_group_609721374  page_group_609798113  page_group_609887157

5. Restart the mysqld
6. Execute: select mysqlbackup_page_track_purge_up_to(609721374);
+-----------------------------------------------+
| mysqlbackup_page_track_purge_up_to(609721374) |
+-----------------------------------------------+
|                           9223372036854775807 |
+-----------------------------------------------+
1 row in set (22.09 sec)
and didn't purge any page groups.

Suggested fix:
Sort arch_page_sys->m_group_list with start_lsn or use the ordered_map for Arch_Dir_Group_Info_Map.