Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.1(EOL)
-
None
Description
Note: 10.2 and 10.3 crash the same way while trying to startup on this data, but I have no information whether it's the fault of the server which performs the recovery or of which initially created the data, and in the latter case, whether other versions are affected, so I'm filing it for 10.1 only for now.
|
10.1 ef0b91e |
2019-01-27 10:50:33 140031557658496 [ERROR] InnoDB: Database page corruption on disk or a failed file read of tablespace ./ibdata1 page [page id: space=0, page number=5]. You may have to recover from a backup.
|
2019-01-27 10:50:33 7f5ba3406780 InnoDB: Page dump in ascii and hex (65536 bytes):
|
...
|
InnoDB: End of page dump
|
2019-01-27 10:50:33 7f5ba3406780 InnoDB: uncompressed page, stored checksum in field1 1815576519, calculated checksums for field1: crc32 3572139883, innodb 1815576519, none 3735928559, stored checksum in field2 2064831440, calculated checksums for field2: crc32 3572139883, innodb 866585586, none 3735928559, page LSN 0 24674042, low 4 bytes of LSN at page end 17346260, page number (if stored to page already) 5, space id (if created with >= MySQL-4.1.1 and stored already) 0
|
InnoDB: page type 7 meaning TRX_SYS
|
InnoDB: Page may be a transaction system page
|
2019-01-27 10:50:33 140031557658496 [ERROR] InnoDB: Ending processing because of a corrupt database page.
|
2019-01-27 10:50:33 7f5ba3406780 InnoDB: Assertion failure in thread 140031557658496 in file ha_innodb.cc line 22037
|
|
|
#5 0x00007f5ba1382028 in abort () from /lib/x86_64-linux-gnu/libc.so.6
|
#6 0x0000563f471dbaed in ib_logf (level=IB_LOG_LEVEL_FATAL, format=0x563f4773b8e8 "Ending processing because of a corrupt database page.") at /home/travis/src/storage/xtradb/handler/ha_innodb.cc:22037
|
#7 0x0000563f473c36e2 in buf_page_io_complete (bpage=0x7f5b7bff35f0) at /home/travis/src/storage/xtradb/buf/buf0buf.cc:5023
|
#8 0x0000563f473e1c08 in buf_read_page_low (err=0x7fffaa2e5a1c, sync=true, mode=132, space=0, zip_size=0, unzip=0, tablespace_version=1, offset=5, trx=0x0, should_buffer=false) at /home/travis/src/storage/xtradb/buf/buf0rea.cc:279
|
#9 0x0000563f473e2104 in buf_read_page (space_id=0, zip_size=0, offset=5, trx=0x0) at /home/travis/src/storage/xtradb/buf/buf0rea.cc:512
|
#10 0x0000563f473bf57b in buf_page_get_gen (space=0, zip_size=0, offset=5, rw_latch=2, guess=0x0, mode=10, file=0x563f477266c8 "/home/travis/src/storage/xtradb/include/trx0sys.ic", line=103, mtr=0x7fffaa2e5fd0, err=0x0) at /home/travis/src/storage/xtradb/buf/buf0buf.cc:3211
|
#11 0x0000563f47353947 in trx_sysf_get (mtr=0x7fffaa2e5fd0) at /home/travis/src/storage/xtradb/include/trx0sys.ic:103
|
#12 0x0000563f47354953 in trx_rseg_get_n_undo_tablespaces (space_ids=0x7fffaa2e6520) at /home/travis/src/storage/xtradb/trx/trx0rseg.cc:383
|
#13 0x0000563f4732ce22 in srv_undo_tablespaces_init (create_new_db=0, backup_mode=0, n_conf_tablespaces=0, n_opened=0x563f47d575c0 <srv_undo_tablespaces_open>) at /home/travis/src/storage/xtradb/srv/srv0start.cc:1494
|
#14 0x0000563f4732e9ba in innobase_start_or_create_for_mysql () at /home/travis/src/storage/xtradb/srv/srv0start.cc:2503
|
#15 0x0000563f471bd46f in innobase_init (p=0x563f49a01670) at /home/travis/src/storage/xtradb/handler/ha_innodb.cc:4525
|
#16 0x0000563f46e7e865 in ha_initialize_handlerton (plugin=0x563f499f32c0) at /home/travis/src/sql/handler.cc:522
|
#17 0x0000563f46c4e843 in plugin_initialize (tmp_root=0x7fffaa2eb5f0, plugin=0x563f499f32c0, argc=0x563f47f11968 <remaining_argc>, argv=0x563f499ae598, options_only=false) at /home/travis/src/sql/sql_plugin.cc:1409
|
#18 0x0000563f46c4f471 in plugin_init (argc=0x563f47f11968 <remaining_argc>, argv=0x563f499ae598, flags=2) at /home/travis/src/sql/sql_plugin.cc:1687
|
#19 0x0000563f46b6bba7 in init_server_components () at /home/travis/src/sql/mysqld.cc:5169
|
#20 0x0000563f46b6cc7b in mysqld_main (argc=32, argv=0x563f499ae598) at /home/travis/src/sql/mysqld.cc:5760
|
#21 0x0000563f46b62175 in main (argc=32, argv=0x7fffaa2ec3a8) at /home/travis/src/sql/main.cc:25
|
Test scenario was a crash-upgrade from the previous 10.1 release (10.1.37) downloaded from here:
https://downloads.mariadb.com/MariaDB/mariadb-10.1/bintar-linux-glibc_214-x86_64/mariadb-10.1.37-linux-glibc_214-x86_64.tar.gz
The data directory after the enforced crash before any attempts to upgrade can be found here:
ftp://ftp.askmonty.org/public/mdev18395-data.tar.gz
To reproduce the failure, unpack it and start 10.1 server with
--file-key-management --file-key-management-filename=/data/bld/keys.txt --plugin-load-add=file_key_management.so --innodb-encrypt-tables --innodb-encrypt-log --innodb-encryption-threads=4 --aria-encrypt-tables=1 --encrypt-tmp-disk-tables=1 --encrypt-binlog --innodb-page-size=64K --innodb-compression-algorithm=none --loose-innodb-file-format=Barracuda --loose-innodb-file-per-table=1 --loose-max-statement-time=20 --loose-lock-wait-timeout=20 --loose-innodb-lock-wait-timeout=10 --loose-innodb_log_compressed_pages=on
|
(Modify the path to the key file as needed)
Notes on the origin of the report
Please note that it might be not reproducible easily the same way.
https://travis-ci.org/elenst/travis-tests/jobs/484824862 [2602 9 7]
|
elenst-jira-refs 56fe472 toolbox 572674d |
perl /home/travis/rqg//runall-new.pl --grammar=conf/mariadb/oltp-transactional.yy --grammar2=conf/mariadb/oltp_and_ddl.yy --gendata=conf/mariadb/innodb_upgrade.zz --gendata-advanced --mysqld=--server-id=111 --scenario=CrashUpgrade --duration=90 --basedir1=/home/travis/old --basedir2=/home/travis/server --mysqld=--file-key-management --mysqld=--file-key-management-filename=/home/travis/mariadb-toolbox/travis/../data/keys.txt --mysqld=--plugin-load-add=file_key_management.so --mysqld=--innodb-encrypt-tables --mysqld=--innodb-encrypt-log --mysqld=--innodb-encryption-threads=4 --mysqld=--aria-encrypt-tables=1 --mysqld=--encrypt-tmp-disk-tables=1 --mysqld=--encrypt-binlog --mysqld=--innodb-page-size=64K --mysqld=--innodb-compression-algorithm=none --mysqld=--loose-innodb-file-format=Barracuda --mysqld=--loose-innodb-file-per-table=1 --gendata=conf/mariadb/innodb_upgrade.zz --no-mask --seed=1548585422 --threads=4 --queries=100M --mysqld=--loose-max-statement-time=20 --mysqld=--loose-lock-wait-timeout=20 --mysqld=--loose-innodb-lock-wait-timeout=10 --mysqld=--loose-innodb_log_compressed_pages=on --mtr-build-thread=300 --vardir1=/home/travis/logs/current1_1
|