[MDEV-14188] mariabackup.incremental_encrypted failed in buildbot with wrong result Created: 2017-10-29  Updated: 2018-07-06  Resolved: 2018-07-06

Status: Closed
Project: MariaDB Server
Component/s: Backup, Tests
Affects Version/s: 10.2
Fix Version/s: 10.2.17, 10.3.9

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-15740 Galera does not recover prepared XA-t... Closed
Sprint: 10.2.14

 Description   

Note: The failure is old-ish, it's possible that the problem has been already fixed. If so, please feel free to close the report.

http://buildbot.askmonty.org/buildbot/builders/p8-rhel6-bintar-debug/builds/1249/steps/test/logs/stdio

mariabackup.incremental_encrypted '64k,innodb' w2 [ fail ]
        Test ended at 2017-09-25 12:29:56
 
CURRENT_TEST: mariabackup.incremental_encrypted
/home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/extra/mariabackup/mariabackup based on MariaDB server 10.2.9-MariaDB Linux (ppc64) 
170925 12:29:47 [01] Copying ibdata1 to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/ibdata1
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./xtrabackup_info to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/xtrabackup_info
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./ib_buffer_pool to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/ib_buffer_pool
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./aria_log_control to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/aria_log_control
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./aria_log.00000001 to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/aria_log.00000001
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./performance_schema/db.opt to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/performance_schema/db.opt
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/global_suppressions.TRG to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/global_suppressions.TRG
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/gs_insert.TRN to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/gs_insert.TRN
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/global_suppressions.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/global_suppressions.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/global_suppressions.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/global_suppressions.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/global_suppressions.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/global_suppressions.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/test_suppressions.TRG to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/test_suppressions.TRG
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/ts_insert.TRN to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/ts_insert.TRN
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/test_suppressions.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/test_suppressions.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/test_suppressions.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/test_suppressions.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/test_suppressions.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/test_suppressions.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mtr/db.opt to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mtr/db.opt
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/gtid_slave_pos.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/gtid_slave_pos.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/gtid_slave_pos.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/gtid_slave_pos.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/gtid_slave_pos.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/gtid_slave_pos.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/index_stats.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/index_stats.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/index_stats.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/index_stats.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/index_stats.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/index_stats.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/column_stats.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/column_stats.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/column_stats.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/column_stats.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/column_stats.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/column_stats.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/table_stats.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/table_stats.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/table_stats.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/table_stats.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/table_stats.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/table_stats.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/proxies_priv.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/proxies_priv.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/proxies_priv.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/proxies_priv.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/proxies_priv.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/proxies_priv.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/innodb_index_stats.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/innodb_index_stats.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/innodb_table_stats.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/innodb_table_stats.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/event.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/event.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/event.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/event.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/event.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/event.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/slow_log.CSV to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/slow_log.CSV
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/slow_log.CSM to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/slow_log.CSM
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/slow_log.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/slow_log.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/general_log.CSV to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/general_log.CSV
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/general_log.CSM to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/general_log.CSM
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/general_log.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/general_log.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/procs_priv.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/procs_priv.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/procs_priv.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/procs_priv.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/procs_priv.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/procs_priv.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/proc.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/proc.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/proc.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/proc.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/proc.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/proc.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_leap_second.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_leap_second.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_leap_second.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_leap_second.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_leap_second.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_leap_second.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_transition_type.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_transition_type.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_transition_type.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_transition_type.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_transition_type.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_transition_type.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_transition.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_transition.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_transition.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_transition.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_transition.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_transition.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_name.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_name.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_name.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_name.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/time_zone_name.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/time_zone_name.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_keyword.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_keyword.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_keyword.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_keyword.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_keyword.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_keyword.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_relation.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_relation.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_relation.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_relation.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_relation.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_relation.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_category.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_category.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_category.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_category.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_category.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_category.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_topic.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_topic.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_topic.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_topic.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/help_topic.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/help_topic.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/columns_priv.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/columns_priv.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/columns_priv.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/columns_priv.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/columns_priv.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/columns_priv.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/tables_priv.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/tables_priv.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/tables_priv.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/tables_priv.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/tables_priv.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/tables_priv.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/servers.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/servers.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/servers.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/servers.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/servers.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/servers.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/plugin.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/plugin.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/plugin.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/plugin.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/plugin.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/plugin.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/func.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/func.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/func.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/func.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/func.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/func.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/roles_mapping.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/roles_mapping.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/roles_mapping.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/roles_mapping.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/roles_mapping.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/roles_mapping.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/user.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/user.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/user.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/user.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/user.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/user.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/host.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/host.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/host.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/host.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/host.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/host.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/db.MYD to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/db.MYD
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/db.MYI to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/db.MYI
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/db.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/db.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/innodb_table_stats.ibd to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/innodb_table_stats.ibd
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./mysql/innodb_index_stats.ibd to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/mysql/innodb_index_stats.ibd
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./test/t.frm to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/test/t.frm
170925 12:29:47 [01]        ...done
170925 12:29:47 [01] Copying ./test/t.ibd to /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/var/2/mysqld.1/data/test/t.ibd
170925 12:29:47 [01]        ...done
170925 12:29:47 completed OK!

--- /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/suite/mariabackup/incremental_encrypted.result	2017-09-25 10:51:16.730026897 -0400
+++ /home/buildbot/maria-slave/p8-rhel6-bintar-debug/build/mysql-test/suite/mariabackup/incremental_encrypted.reject	2017-09-25 12:29:55.860026896 -0400
@@ -16,5 +16,4 @@
 SELECT * FROM t;
 i
 1
-2
 DROP TABLE t;
 
mysqltest: Result length mismatch



 Comments   
Comment by Marko Mäkelä [ 2018-07-06 ]

To me, it looks like the test is badly written. The last INSERT before invoking backup is not necessarily persisted to redo log, because innodb_flush_log_at_trx_commit is not 1, but 2, which I verified by adding the following before the INSERT statement:

SELECT @@GLOBAL.innodb_flush_log_at_trx_commit;

So, the outcome is expected to be nondeterministic. A deterministic test on the persistence of transaction state should enforce a redo log write with innodb_flush_log_at_trx_commit=1 at some point.

Comment by Marko Mäkelä [ 2018-07-06 ]

If the result difference keeps occurring, then it should be due to MDEV-15740. Time will tell.

If adding the SET GLOBAL innodb_flush_log_at_trx_commit=1 actually cured the intermittent failures, then we should consider changing something in Mariabackup to make it work even when this setting is not used. (That something could be the server-side backup proposed in MDEV-14992.)

Generated at Thu Feb 08 08:11:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.