Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.5, 10.4(EOL)
-
None
Description
mtr test mariabackup.mdev-14447 fails randomly in 10.5.1 tree with:
CURRENT_TEST: mariabackup.mdev-14447
|
sh: line 1: 21349 Aborted (core dumped) /home/my/maria-10.5/extr
|
a/mariabackup/mariabackup --prepare --verbose --apply-log-only --target-dir=/hom
|
e/my/maria-10.5/mysql-test/var/4/tmp/backup --incremental-dir=/home/my/maria-10.
|
5/mysql-test/var/4/tmp/backup_inc1 2>&1
|
mysqltest: At line 35: exec of '/home/my/maria-10.5/extra/mariabackup/mariabacku
|
p --prepare --verbose --apply-log-only --target-dir=/home/my/maria-10.5/mysql-te
|
st/var/4/tmp/backup --incremental-dir=/home/my/maria-10.5/mysql-test/var/4/tmp/b
|
ackup_inc1 2>&1' failed, error: 34304, status: 134, errno: 2
|
|
The result from queries just before the failure was:
|
call mtr.add_suppression("InnoDB: New log files created");
|
CREATE TABLE t(a varchar(40) PRIMARY KEY, b varchar(40), c varchar(40), d varchar(40), index(b,c,d)) ENGINE INNODB;
|
# Create full backup , modify table, then create incremental/differential backup
|
BEGIN;
|
INSERT INTO t select uuid(), uuid(), uuid(), uuid() from seq_1_to_100000;
|
COMMIT;
|
SELECT count(*) FROM t;
|
count(*)
|
100000
|
FOUND 1 /Checksum mismatch in datafile/ in backup.log
|
# Prepare full backup, apply incremental one
|
|
mariabackup: /my/maria-10.5/storage/innobase/log/log0recv.cc:2649: bool recv_parse_log_recs(lsn_t, store_t*, ulint, bool): Assertion `recv_sys.mlog_checkpoint_lsn <= recv_sys.recovered_lsn' failed.
|
#3 0x00007fc00dae2160 in raise () from /lib64/libc.so.6
|
#4 0x00007fc00dae3741 in abort () from /lib64/libc.so.6
|
#5 0x00007fc00dada75a in __assert_fail_base () from /lib64/libc.so.6
|
#6 0x00007fc00dada7d2 in __assert_fail () from /lib64/libc.so.6
|
#7 0x000000000124cd9e in recv_parse_log_recs (checkpoint_lsn=34221332, store=0x7ffd40828884, available_mem=67371008, apply=true) at /my/maria-10.5/storage/innobase/log/log0recv.cc:2649
|
#8 0x000000000124df2a in recv_scan_log_recs (available_mem=67371008, store_to_hash=0x7ffd40828884, log_block=0x7fc009b21000 "", checkpoint_lsn=34221332, start_lsn=34221056, end_lsn=34286592, contiguous_lsn=0x7ffd40828a98, group_scanned_lsn=0x2628c98 <log_sys+664>) at /my/maria-10.5/storage/innobase/log/log0recv.cc:3110
|
#9 0x000000000124e4a5 in recv_group_scan_log_recs (checkpoint_lsn=34221332, contiguous_lsn=0x7ffd40828a98, last_phase=false) at /my/maria-10.5/storage/innobase/log/log0recv.cc:3198
|
#10 0x000000000124fb89 in recv_recovery_from_checkpoint_start (flush_lsn=64240) at /my/maria-10.5/storage/innobase/log/log0recv.cc:3507
|
#11 0x0000000001395450 in srv_start (create_new_db=false) at /my/maria-10.5/storage/innobase/srv/srv0start.cc:1743
|
#12 0x00000000007842a2 in innodb_init () at /my/maria-10.5/extra/mariabackup/xtrabackup.cc:1975
|
#13 0x000000000078e232 in xtrabackup_prepare_func (argv=0x3817150) at /my/maria-10.5/extra/mariabackup/xtrabackup.cc:5529
|
#14 0x0000000000790251 in main_low (argv=0x3817150) at /my/maria-10.5/extra/mariabackup/xtrabackup.cc:6318
|
#15 0x000000000078fa8e in main (argc=6, argv=0x7ffd40830208) at /my/maria-10.5/extra/mariabackup/xtrabackup.cc:6108
|
When trying to repeat, I also found this issue during shutdown
sql/signal_handler.cc:209(handle_fatal_signal)[0xbee896]
|
/lib64/libpthread.so.0(+0x12360)[0x7f2f68a3e360]
|
/lib64/libpthread.so.0(pthread_cond_wait+0x1fd)[0x7f2f68a3990d]
|
/usr/lib64/libstdc++.so.6(_ZNSt18condition_variable4waitERSt11unique_lockISt5mutexE+0xc)[0x7f2f672bfb4c]
|
tpool/task.cc:63(tpool::waitable_task::wait())[0x1478852]
|
srv/srv0srv.cc:2233(srv_shutdown_purge_tasks())[0x123710d]
|
srv/srv0srv.cc:2304(srv_purge_shutdown())[0x123758e]
|
srv/srv0start.cc:2296(innodb_preshutdown())[0x1240491]
|
sql/handler.cc:886(plugin_pre_shutdown(THD*, st_plugin_int**, void*))[0xbf3000]
|
sql/sql_plugin.cc:2452(plugin_foreach_with_mask(THD*, char (*)(THD*, st_plugin_int**, void*), int, unsigned int, void*))[0x8ce920]
|
sql/handler.cc:895(ha_pre_shutdown())[0xbf302c]
|
sql/mysqld.cc:5731(mysqld_main(int, char**))[0x774752]
|
Attachments
Issue Links
- relates to
-
MDEV-13830 Assertion failed: recv_sys->mlog_checkpoint_lsn <= recv_sys->recovered_lsn
- Closed
-
MDEV-29943 MariaBackup loses a DML operation after server restart
- Open