Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.4(EOL), 10.5, 10.6, 10.7(EOL)
-
None
Description
Note: the test case is made universal (10.4-10.7) for convenience. For the branch-specific regression test suite, at least the conditional logic of setting the variable shouldn't be needed
--source include/have_innodb.inc
|
--source include/have_partition.inc
|
|
# For 10.6+ |
if (`select count(*) from information_schema.system_variables where variable_name = 'innodb_read_only_compressed'`) |
{
|
SET @read_only_compressed.save= @@innodb_read_only_compressed; |
SET GLOBAL innodb_read_only_compressed= OFF; |
}
|
|
CREATE TABLE t (pk INT PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED; |
|
--exec $XTRABACKUP --backup --target-dir=$MYSQL_TMP_DIR/backup_0 --protocol=tcp --port=$MASTER_MYPORT --user=root
|
|
ALTER TABLE t PARTITION BY KEY(pk); |
|
--exec $XTRABACKUP --backup --target-dir=$MYSQL_TMP_DIR/backup_1 --incremental-basedir=$MYSQL_TMP_DIR/backup_0 --protocol=tcp --port=$MASTER_MYPORT --user=root > $MYSQL_TMP_DIR/backup_1.log 2>&1
|
--exec $XTRABACKUP --prepare --target-dir=$MYSQL_TMP_DIR/backup_0 --user=root > $MYSQL_TMP_DIR/backup_prepare_0.log 2>&1
|
--exec $XTRABACKUP --prepare --target-dir=$MYSQL_TMP_DIR/backup_0 --incremental-dir=$MYSQL_TMP_DIR/backup_1 --user=root > $MYSQL_TMP_DIR/backup_prepare_1.log
|
--cat_file $MYSQL_TMP_DIR/backup_prepare_1.log
|
|
# Cleanup
|
DROP TABLE t; |
# For 10.6+ |
if (`select @read_only_compressed.save is not null`) |
{
|
SET GLOBAL innodb_read_only_compressed= @read_only_compressed.save; |
}
|
On 10.5-10.7 it crashes with sigsegv in buf_is_zeroes:
bb-10.5-release 8635be6a2 |
#2 <signal handler called>
|
#3 __memcmp_avx2_movbe () at ../sysdeps/x86_64/multiarch/memcmp-avx2-movbe.S:70
|
#4 0x000055a4aecbb83f in buf_is_zeroes (buf=...) at /data/src/bb-10.5-release/storage/innobase/buf/buf0buf.cc:708
|
#5 0x000055a4aeee3f84 in page_zip_verify_checksum (data=0x55a4b0b64000 "{\343n\351", size=8192) at /data/src/bb-10.5-release/storage/innobase/page/page0zip.cc:4648
|
#6 0x000055a4aecbbb52 in buf_page_is_corrupted (check_lsn=false, read_buf=0x55a4b0b64000 "{\343n\351", fsp_flags=41) at /data/src/bb-10.5-release/storage/innobase/buf/buf0buf.cc:820
|
#7 0x000055a4aed6a049 in Datafile::validate_first_page (this=0x55a4b0b47640, flush_lsn=0x7ffce6ff5f08) at /data/src/bb-10.5-release/storage/innobase/fsp/fsp0file.cc:573
|
#8 0x000055a4ae367a61 in xb_load_single_table_tablespace (dirname=0x7ffce6ff5fc0 "test", filname=0x7ffce6ff6fa0 "t.ibd", is_remote=false, skip_node_page0=false) at /data/src/bb-10.5-release/extra/mariabackup/xtrabackup.cc:3313
|
#9 0x000055a4ae36884e in enumerate_ibd_files (callback=0x55a4ae3677cc <xb_load_single_table_tablespace(char const*, char const*, bool, bool)>) at /data/src/bb-10.5-release/extra/mariabackup/xtrabackup.cc:3686
|
#10 0x000055a4ae368ed0 in xb_load_tablespaces () at /data/src/bb-10.5-release/extra/mariabackup/xtrabackup.cc:3862
|
#11 0x000055a4ae370319 in xtrabackup_prepare_func (argv=0x55a4b0aff388) at /data/src/bb-10.5-release/extra/mariabackup/xtrabackup.cc:5925
|
#12 0x000055a4ae372efb in main_low (argv=0x55a4b0aff388) at /data/src/bb-10.5-release/extra/mariabackup/xtrabackup.cc:6883
|
#13 0x000055a4ae37272b in main (argc=5, argv=0x7ffce6ff8a18) at /data/src/bb-10.5-release/extra/mariabackup/xtrabackup.cc:6681
|
On 10.4 it fails on an assertion:
bb-10.4-release a19ab67318 |
mariabackup: /data/src/bb-10.4-release/extra/mariabackup/xtrabackup.cc:5305: pfs_os_file_t xb_delta_open_matching_space(const char*, const char*, const xb_delta_info_t&, char*, size_t, bool*): Assertion `fil_space_t::physical_size(flags) == info.page_size' failed.
|
211106 1:18:03 [ERROR] mysqld got signal 6 ;
|
|
sigaction.c:0(__restore_rt)[0x7f8a17d9f3c0]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7f8a177e918b]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7f8a177c8859]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x25729)[0x7f8a177c8729]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x36f36)[0x7f8a177d9f36]
|
mariabackup/xtrabackup.cc:5307(xb_delta_open_matching_space(char const*, char const*, xb_delta_info_t const&, char*, unsigned long, bool*))[0x5624aceb6bcf]
|
mariabackup/xtrabackup.cc:5405(xtrabackup_apply_delta(char const*, char const*, char const*, void*))[0x5624aceb7081]
|
mariabackup/xtrabackup.cc:5790(xb_process_datadir(char const*, char const*, unsigned long (*)(char const*, char const*, char const*, void*), void*))[0x5624aceb8cd2]
|
mariabackup/xtrabackup.cc:5828(xtrabackup_apply_deltas())[0x5624aceb8dd8]
|
mariabackup/xtrabackup.cc:6060(xtrabackup_prepare_func(char**))[0x5624aceba582]
|
mariabackup/xtrabackup.cc:7065(main_low(char**))[0x5624acebd346]
|
mariabackup/xtrabackup.cc:6861(main)[0x5624acebcb5e]
|
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3)[0x7f8a177ca0b3]
|
Not reproducible on 10.3.
At least on my machine the failure is deterministic.
Attachments
Issue Links
- duplicates
-
MDEV-18589 Assertion `fil_space_t::physical_size(flags) == info.page_size' failed in xb_delta_open_matching_space upon prepare on the incremental backup
- Closed
- is caused by
-
MDEV-18493 Remove page_size_t
- Closed
- relates to
-
MDEV-28473 field_ref_zero is not initialized in xtrabackup_prepare_func()
- Closed