[MDEV-13269] Upgrade tests for InnoDB undo log Created: 2017-07-06  Updated: 2020-04-16  Resolved: 2017-09-08

Status: Closed
Project: MariaDB Server
Component/s: Tests
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-13430 InnoDB upgrade from previous versions... Closed
PartOf
Relates
relates to MDEV-12288 Reset DB_TRX_ID when the history is r... Closed
relates to MDEV-12289 Keep 128 persistent rollback segments... Closed
relates to MDEV-13437 InnoDB fails to return error for XA C... Closed
relates to MDEV-13438 Assertion `(&(&LOCK_log)->m_mutex)->c... Closed
relates to MDEV-13520 InnoDB attempts UPDATE with DB_TRX_ID... Closed
relates to MDEV-13475 InnoDB: Failing assertion: lsn == log... Closed
relates to MDEV-13476 TRX_UNDO_PAGE_TYPE mismatch when writ... Closed
relates to MDEV-13495 Crash in rollback of a recovered INSE... Closed
relates to MDEV-22257 Assertion `trx_id > 0 || (flags & BTR... Closed

 Description   

Marko wrote:

We'd need that for MDEV-12288. I manually tested for one (the default) innodb_page_size (I think this change is not really dependent on it). I'd suggest this, similar to innodb.read_only_recovery:
1. Start the old version (any, even 5.5) with --innodb-change-buffering=none and run quite a bit of DML
2. Kill & restart with --innodb-force-recovery=3 (important, to preserve the undo logs!)
3. Restart the new version with --innodb-read-only (this would refuse to start up if the change buffer is not empty), run some DML (say, CHECK TABLE on every InnoDB table)
4. Restart the new version normally, and run some more DML workload and CHECK TABLE.

we'd actually have needed it already for MDEV-12289 (which made the 10.2.6 undo log compatible with 10.1 or earlier)

I’d appreciate such a test with bb-10.3-marko

 Comments   
Comment by Elena Stepanova [ 2017-08-02 ]

This scenario, however, fails on step 3 when an actual upgrade is performed (e.g. 10.1=>10.2), because the server refuses to upgrade with read-only:

2017-08-02 15:26:03 140179066781760 [Note] InnoDB: Completed initialization of buffer pool
 
2017-08-02 15:26:03 140179066781760 [Note] InnoDB: Highest supported file format is Barracuda.
 
2017-08-02 15:26:03 140179066781760 [ERROR] InnoDB: Cannot create system tables in read-only mode
 
2017-08-02 15:26:03 140179066781760 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2595] with error Read only transaction
 
2017-08-02 15:26:03 140179066781760 [Note] InnoDB: Starting shutdown...
 
2017-08-02 15:26:03 140179066781760 [ERROR] Plugin 'InnoDB' init function returned error.
 
2017-08-02 15:26:03 140179066781760 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
 
2017-08-02 15:26:03 140179066781760 [Note] Plugin 'FEEDBACK' is disabled.
 
2017-08-02 15:26:03 140179066781760 [ERROR] Unknown/unsupported storage engine: InnoDB
 
2017-08-02 15:26:03 140179066781760 [ERROR] Aborting

Comment by Elena Stepanova [ 2017-08-03 ]

It also fails on the same step even when no actual upgrade is performed (e.g. 10.2 => 10.2), regardless of innodb-read-only, if binlog is enabled:

2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Highest supported file format is Barracuda.
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Transaction 9668 was in the XA prepared state.
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Transaction 9680 was in the XA prepared state.
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Transaction 9691 was in the XA prepared state.
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: 3 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Trx id counter is 10496
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: 5.7.18 started; log sequence number 11313556
 
2017-08-03 15:26:29 140005776658496 [Note] Plugin 'FEEDBACK' is disabled.
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Starting recovery for XA transactions...
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Transaction 9691 in prepared state after recovery
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Transaction contains changes to 1 rows
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Transaction 9680 in prepared state after recovery
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Transaction contains changes to 1 rows
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Transaction 9668 in prepared state after recovery
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: Transaction contains changes to 1 rows
 
2017-08-03 15:26:29 140005776658496 [Note] InnoDB: 3 transactions in prepared state after recovery
 
2017-08-03 15:26:29 140005776658496 [Note] Found 3 prepared transaction(s) in InnoDB
 
2017-08-03 15:26:29 140005776658496 [ERROR] Found 3 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
 
2017-08-03 15:26:29 140005776658496 [ERROR] Aborting

Setting --tc-heuristic-recover=ROLLBACK does not make things any better:

2017-08-03 15:40:23 140181774782528 [Note] Heuristic crash recovery mode
 
2017-08-03 15:40:24 140181774782528 [Note] InnoDB: Starting recovery for XA transactions...
 
2017-08-03 15:40:24 140181774782528 [Note] InnoDB: Transaction 9581 in prepared state after recovery
 
2017-08-03 15:40:24 140181774782528 [Note] InnoDB: Transaction contains changes to 1 rows
 
2017-08-03 15:40:24 140181774782528 [Note] InnoDB: Transaction 9578 in prepared state after recovery
 
2017-08-03 15:40:24 140181774782528 [Note] InnoDB: Transaction contains changes to 1 rows
 
2017-08-03 15:40:24 140181774782528 [Note] InnoDB: Transaction 9575 in prepared state after recovery
 
2017-08-03 15:40:24 140181774782528 [Note] InnoDB: Transaction contains changes to 1 rows
 
2017-08-03 15:40:24 140181774782528 [Note] InnoDB: Transaction 9573 in prepared state after recovery
 
2017-08-03 15:40:24 140181774782528 [Note] InnoDB: Transaction contains changes to 1 rows
 
2017-08-03 15:40:24 140181774782528 [Note] InnoDB: 4 transactions in prepared state after recovery
 
2017-08-03 15:40:24 140181774782528 [Note] Found 4 prepared transaction(s) in InnoDB
 
2017-08-03 15:40:24 140181774782528 [Note] rollback xid 'MySQLXid\0\0\0\0\0\0\0\0B\'\0\0\0\0\0\0'
 
mysqld: /data/src/10.2/storage/innobase/mtr/mtr0mtr.cc:569: void mtr_t::commit(): Assertion `!srv_read_only_mode || m_impl.m_log_mode == MTR_LOG_NO_REDO' failed.
 
170803 15:40:24 [ERROR] mysqld got signal 6 ;

10.2 488f46f3de51070fa91e5eadcc215b6a4e343f7b

 
#7  0x00007f7e9aadeee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
 
#8  0x000055ea87663172 in mtr_t::commit (this=0x7ffc3a485580) at /data/src/10.2/storage/innobase/mtr/mtr0mtr.cc:568
 
#9  0x000055ea877a7fa3 in trx_rollback_low (trx=0x7f7e850dd508) at /data/src/10.2/storage/innobase/trx/trx0roll.cc:239
 
#10 0x000055ea877a816a in trx_rollback_for_mysql (trx=0x7f7e850dd508) at /data/src/10.2/storage/innobase/trx/trx0roll.cc:288
 
#11 0x000055ea875af370 in innobase_rollback_trx (trx=0x7f7e850dd508) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:4978
 
#12 0x000055ea875cad1d in innobase_rollback_by_xid (hton=0x55ea8a84c670, xid=0x7f7e70c92080) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:17993
 
#13 0x000055ea872a79d3 in xarecover_handlerton (unused=0x0, plugin=0x7ffc3a485ea8, arg=0x7ffc3a485f40) at /data/src/10.2/sql/handler.cc:1885
 
#14 0x000055ea87052a1c in plugin_foreach_with_mask (thd=0x0, func=0x55ea872a75fa <xarecover_handlerton(THD*, plugin_ref, void*)>, type=1, state_mask=4294967287, arg=0x7ffc3a485f40) at /data/src/10.2/sql/sql_plugin.cc:2381
 
#15 0x000055ea872a7c5f in ha_recover (commit_list=0x0) at /data/src/10.2/sql/handler.cc:1928
 
#16 0x000055ea873b5c6b in TC_LOG::using_heuristic_recover (this=0x55ea885a42c0 <mysql_bin_log>) at /data/src/10.2/sql/log.cc:9295
 
#17 0x000055ea873b5d52 in MYSQL_BIN_LOG::open (this=0x55ea885a42c0 <mysql_bin_log>, opt_name=0x55ea8a82a0f8 "mysql-bin") at /data/src/10.2/sql/log.cc:9318
 
#18 0x000055ea86f5d584 in init_server_components () at /data/src/10.2/sql/mysqld.cc:5400
 
#19 0x000055ea86f5e0d7 in mysqld_main (argc=22, argv=0x55ea8a7e77e8) at /data/src/10.2/sql/mysqld.cc:5845
 
#20 0x000055ea86f52fb0 in main (argc=22, argv=0x7ffc3a486a28) at /data/src/10.2/sql/main.cc:25

The assertion failure is also reproducible with 10.0/10.1.
With 5.5, no assertion failure, but the server cannot start either:

5.5 c8a0244e957bc4beff453f09c881bb51752d682c

 
170803 15:57:57 InnoDB: highest supported file format is Barracuda.
 
170803 15:57:57  InnoDB: Starting crash recovery from checkpoint LSN=3392945
 
InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
 
InnoDB: Transaction 6905 was in the XA prepared state.
 
InnoDB: Since innodb_force_recovery > 0, we will rollback it anyway.
 
InnoDB: Transaction 6907 was in the XA prepared state.
 
InnoDB: Since innodb_force_recovery > 0, we will rollback it anyway.
 
InnoDB: Transaction 6908 was in the XA prepared state.
 
InnoDB: Since innodb_force_recovery > 0, we will rollback it anyway.
 
InnoDB: 4 transaction(s) which must be rolled back or cleaned up
 
InnoDB: in total 4 row operations to undo
 
InnoDB: Trx id counter is 6B00
 
170803 15:57:58  InnoDB: Starting final batch to recover 381 pages from redo log
 
InnoDB: Last MySQL binlog file position 0 7196406, file name ./mysql-bin.000001
 
170803 15:57:58  InnoDB: Waiting for the background threads to start
 
170803 15:57:59  InnoDB: Waiting for the background threads to start
 
170803 15:58:00  InnoDB: Waiting for the background threads to start
 
170803 15:58:01  InnoDB: Waiting for the background threads to start
 
170803 15:58:02  InnoDB: Waiting for the background threads to start
 
170803 15:58:03  InnoDB: Waiting for the background threads to start
 
170803 15:58:04  InnoDB: Waiting for the background threads to start
 
170803 15:58:05  InnoDB: Waiting for the background threads to start
 
170803 15:58:06  InnoDB: Waiting for the background threads to start
 
170803 15:58:07  InnoDB: Waiting for the background threads to start
 
170803 15:58:08  InnoDB: Waiting for the background threads to start
 
170803 15:58:09  InnoDB: Waiting for the background threads to start
 
170803 15:58:10  InnoDB: Waiting for the background threads to start
 
170803 15:58:11  InnoDB: Waiting for the background threads to start
 
170803 15:58:12  InnoDB: Waiting for the background threads to start
 
....

Comment by Elena Stepanova [ 2017-08-04 ]

The module has been pushed into branch mdev13269:
https://github.com/elenst/rqg/tree/mdev13269

After remaining questions have been sorted, it should be merged into experimental and eventually into master.

Summary as of Aug 4th:

Minimal configuration (without binlog enabled, server defaults)

10.3 => 10.3, 10.2.6 => 10.2, 10.0 => 10.1 – WORKS

10.2 => 10.3, 10.3.0 => 10.3 – FAILS on step 3 (1st restart after upgrade, with innodb-read-only)

2017-08-04 19:50:06 139627172507712 [Note] InnoDB: Completed initialization of buffer pool
 
2017-08-04 19:50:06 139627172507712 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.2.8.
 
2017-08-04 19:50:06 139627172507712 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2215] with error Generic error
 
2017-08-04 19:50:07 139627172507712 [Note] InnoDB: Starting shutdown...
 
2017-08-04 19:50:07 139627172507712 [ERROR] Plugin 'InnoDB' init function returned error.
 
2017-08-04 19:50:07 139627172507712 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
 
2017-08-04 19:50:07 139627172507712 [Note] Plugin 'FEEDBACK' is disabled.
 
2017-08-04 19:50:07 139627172507712 [ERROR] Unknown/unsupported storage engine: InnoDB
 
2017-08-04 19:50:07 139627172507712 [ERROR] Aborting

Sometimes the message about crash upgrade is not printed, which makes it even more confusing:

2017-08-04 19:23:06 139881193066560 [Note] InnoDB: Completed initialization of buffer pool
 
2017-08-04 19:23:06 139881193066560 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2215] with error Generic error
 
2017-08-04 19:23:07 139881193066560 [Note] InnoDB: Starting shutdown...
 
2017-08-04 19:23:07 139881193066560 [ERROR] Plugin 'InnoDB' init function returned error.
 
2017-08-04 19:23:07 139881193066560 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
 
2017-08-04 19:23:07 139881193066560 [Note] Plugin 'FEEDBACK' is disabled.
 
2017-08-04 19:23:07 139881193066560 [ERROR] Unknown/unsupported storage engine: InnoDB
 
2017-08-04 19:23:07 139881193066560 [ERROR] Aborting

10.1 => 10.2 – FAILS on step 3 (1st restart after upgrade, with innodb-read-only)

2017-08-04 19:40:14 140048691904576 [Note] InnoDB: Highest supported file format is Barracuda.
 
2017-08-04 19:40:14 140048691904576 [ERROR] InnoDB: Cannot create system tables in read-only mode
 
2017-08-04 19:40:14 140048691904576 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2595] with error Read only transaction
 
2017-08-04 19:40:14 140048691904576 [Note] InnoDB: Starting shutdown...
 
2017-08-04 19:40:14 140048691904576 [ERROR] Plugin 'InnoDB' init function returned error.
 
2017-08-04 19:40:14 140048691904576 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
 
2017-08-04 19:40:14 140048691904576 [Note] Plugin 'FEEDBACK' is disabled.
 
2017-08-04 19:40:14 140048691904576 [ERROR] Unknown/unsupported storage engine: InnoDB
 
2017-08-04 19:40:14 140048691904576 [ERROR] Aborting

5.5 => 10.0 – FAILS on step 2 (crash recovery with innodb-force-recovery=3 on 5.5)
keeps doing it forever:

170804 20:03:40  InnoDB: Waiting for the background threads to start
 
170804 20:03:41  InnoDB: Waiting for the background threads to start
 
170804 20:03:42  InnoDB: Waiting for the background threads to start
 
170804 20:03:43  InnoDB: Waiting for the background threads to start
 
170804 20:03:44  InnoDB: Waiting for the background threads to start
 
170804 20:03:45  InnoDB: Waiting for the background threads to start
 
170804 20:03:46  InnoDB: Waiting for the background threads to start
 
170804 20:03:47  InnoDB: Waiting for the background threads to start

Other scenarios will be checked after these generic ones are sorted out.

With binlog enabled

10.2 => 10.2 (and other combinations) – FAILS on step 3 (1st restart after upgrade, with innodb-read-only)

2017-08-04 20:07:52 140256879255616 [Note] InnoDB: Highest supported file format is Barracuda.
 
2017-08-04 20:07:53 140256879255616 [Note] InnoDB: Transaction 8724 was in the XA prepared state.
 
2017-08-04 20:07:53 140256879255616 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
 
2017-08-04 20:07:53 140256879255616 [Note] InnoDB: Trx id counter is 9728
 
2017-08-04 20:07:53 140256879255616 [Note] InnoDB: 5.7.18 started; log sequence number 10081483
 
2017-08-04 20:07:53 140256879255616 [Note] Plugin 'FEEDBACK' is disabled.
 
2017-08-04 20:07:53 140256879255616 [Note] InnoDB: Starting recovery for XA transactions...
 
2017-08-04 20:07:53 140256879255616 [Note] InnoDB: Transaction 8724 in prepared state after recovery
 
2017-08-04 20:07:53 140256879255616 [Note] InnoDB: Transaction contains changes to 1 rows
 
2017-08-04 20:07:53 140256879255616 [Note] InnoDB: 1 transactions in prepared state after recovery
 
2017-08-04 20:07:53 140256879255616 [Note] Found 1 prepared transaction(s) in InnoDB
 
2017-08-04 20:07:53 140256879255616 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.

FYI marko.

Comment by Elena Stepanova [ 2017-08-14 ]

Summary of Aug 14th (10.3 revision 347d9456e4eb)

10.1.20 => 10.3
Failed on the 2nd step, old server restart with ifr=3 after crash
Unrelated to upgrade. I assume it's a 10.1.20 problem fixed in recent 10.1

# 2017-08-14T09:33:12 [43513] | 49 InnoDB: Error: trying to access page number 1 in space 10,
 
# 2017-08-14T09:33:12 [43513] | InnoDB: space name test/t5,
 
# 2017-08-14T09:33:12 [43513] | InnoDB: which is outside the tablespace bounds.
 
# 2017-08-14T09:33:12 [43513] | InnoDB: Byte offset 0, len 65536, i/o type 10.
 
# 2017-08-14T09:33:12 [43513] | InnoDB: If you get this error at mysqld startup, please check that
 
# 2017-08-14T09:33:12 [43513] | InnoDB: your my.cnf matches the ibdata files that you have in the
 
# 2017-08-14T09:33:12 [43513] | InnoDB: MySQL server.
 
# 2017-08-14T09:33:12 [43513] | 2017-08-14 09:33:11 7f82c9cc1780  InnoDB: Assertion failure in thread 140199708071808 in file fil0fil.cc line 5931

10.1 => 10.3
Failed on the 2nd step, old server restart with ifr=3 after crash
Unrelated to upgrade. Need to make a bug report about it for 10.1

# 2017-08-14T09:38:35 [43731] | 2017-08-14  9:38:33 139695152883584 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
 
# 2017-08-14T09:38:35 [43731] | 2017-08-14 09:38:34 7f0d4ff6e780  InnoDB: Assertion failure in thread 139695152883584 in file os0sync.cc line 339
 
# 2017-08-14T09:38:35 [43731] | InnoDB: Failing assertion: event

10.1.20 => 10.3, 10.1 => 10.3
Failed on the 3rd step, new server start with read-only
As discussed, the read-only upgrade is not applicable to 10.1 => 10.3. Need to modify the scenario

# 2017-08-14T09:49:30 [44160] | 2017-08-14  9:49:29 140171267110720 [Note] InnoDB: Completed initialization of buffer pool
 
# 2017-08-14T09:49:30 [44160] | 2017-08-14  9:49:30 140171267110720 [ERROR] InnoDB: Cannot create system tables in read-only mode
 
# 2017-08-14T09:49:30 [44160] | 2017-08-14  9:49:30 140171267110720 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2580] with error Read only transaction
 
# 2017-08-14T09:49:30 [44160] | 2017-08-14  9:49:30 140171267110720 [Note] InnoDB: Starting shutdown...

10.2 => 10.3, 10.3.0 => 10.3
Failed after the 4th step
Unrelated to upgrade. MDEV-13512

2017-08-14 11:40:30 0x7fd2fdc8a700  InnoDB: Assertion failure in file /home/elenst/git/10.3/storage/innobase/page/page0zip.cc line 3075
 
InnoDB: Failing assertion: !memcmp(FIL_PAGE_TYPE + page, FIL_PAGE_TYPE + page_zip->data, PAGE_HEADER - FIL_PAGE_TYPE)

10.1.20 => 10.3
Failed on 2nd step
Unrelated to upgrade. Might be 10.1.20 failure only, need to try to get it on recent trees.

# 2017-08-14T05:45:50 [31943] | InnoDB: Warning: database page corruption or a failed
 
# 2017-08-14T05:45:50 [31943] | InnoDB: file read of space 0 page 624.
 
# 2017-08-14T05:45:50 [31943] | InnoDB: Trying to recover it from the doublewrite buffer.
 
# 2017-08-14T05:45:50 [31943] | InnoDB: Dump of the page:
 
# 2017-08-14T05:45:50 [31943] | 2017-08-14 05:45:49 7f54eb5ab780 InnoDB: Page dump in ascii and hex (8192 bytes):
 
...
 
# 2017-08-14T05:45:50 [31943] | 2017-08-14 05:45:49 7f54eb5ab780 InnoDB: uncompressed page, stored checksum in field1 3887984507, calculated checksums for field1: crc32 3550797666, innodb 1228661961, none 3735928559, stored checksum in field2 44434364, calculated checksums for field2: crc32 3550797666, innodb 44434364, none 3735928559, page LSN 0 10495857, low 4 bytes of LSN at page end 10495857, page number (if stored to page already) 624, space id (if created with >= MySQL-4.1.1 and stored already) 0
 
# 2017-08-14T05:45:50 [31943] | InnoDB: page type 2 meaning UNDO LOG
 
# 2017-08-14T05:45:50 [31943] | InnoDB: Also the page in the doublewrite buffer is corrupt.
 
# 2017-08-14T05:45:50 [31943] | InnoDB: Cannot continue operation.
 
# 2017-08-14T05:45:50 [31943] | InnoDB: You can try to recover the database with the my.cnf
 
# 2017-08-14T05:45:50 [31943] | InnoDB: option:
 
# 2017-08-14T05:45:50 [31943] | InnoDB: innodb_force_recovery=6
 
# 2017-08-14T05:45:50 [31943] | 2017-08-14 05:45:49 7f54eb5ab780  InnoDB: Assertion failure in thread 140002702571392 in file buf0dblwr.cc line 601

10.3 => 10.3
Failed on 2nd step
Unrelated to upgrade. Something wrong with crash recovery.

mysqld: /home/elenst/git/10.3/storage/innobase/btr/btr0cur.cc:3800: dberr_t btr_cur_optimistic_update(ulint, btr_cur_t*, ulint**, mem_heap_t**, const upd_t*, ulint, que_thr_t*, trx_id_t, mtr_t*): Assertion `trx_id > 0 || (flags & BTR_KEEP_SYS_FLAG)' failed.
 
170814  5:50:45 [ERROR] mysqld got signal 6 ;

10.3 => 10.3
Failed on 2nd step
Unrelated to upgrade. MDEV-13103

# 2017-08-14T08:01:50 [39117] | 2017-08-14  8:01:48 139991503341376 [Note] InnoDB: Starting crash recovery from checkpoint LSN=9840311
 
# 2017-08-14T08:01:50 [39117] | 2017-08-14  8:01:49 139991503341376 [ERROR] InnoDB: Corruption: Page is marked as compressed space: 40 name: test/t043 but uncompress failed with error: -3 size: 4920 len: 8192 compression method: ZLIB.
 
# 2017-08-14T08:01:50 [39117] | 2017-08-14  8:01:49 139991503341376 [Note] InnoDB: Page dump in ascii and hex (8192 bytes):
 
...
 
# 2017-08-14T08:01:50 [39117] | mysqld: /home/elenst/git/10.3/storage/innobase/buf/buf0buf.cc:1355: void buf_page_print(const byte*, const page_
 
size_t&, ulint): Assertion `flags & BUF_PAGE_PRINT_NO_CRASH' failed.

Comment by Marko Mäkelä [ 2017-08-14 ]

The "Something wrong with crash recovery" is actually a problem with executing SQL when InnoDB should be read-only.
MDEV-13520 InnoDB fails to refuse UPDATE if innodb_force_recovery=3

Comment by Elena Stepanova [ 2017-08-15 ]

10.3 347d9456e4eb

2017-08-14 17:34:15

trial type pagesize OLD version file format encrypted compressed   NEW version file format encrypted compressed readonly result notes
1 undo 64 10.1.27 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
2 undo 4 10.1.27 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
3 undo 8 10.1.27 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
4 undo 32 10.1.27 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
5 undo 16 10.1.27 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
6 undo 64 10.2.8 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
7 undo 16 10.2.8 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
8 undo 8 10.2.8 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
9 undo 4 10.2.8 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
10 undo 32 10.2.8 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
11 undo 4 5.7.14 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
12 undo 16 5.7.14 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
13 undo 64 5.7.14 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
14 undo 8 5.7.14 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
15 undo 32 5.7.14 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
16 undo 32 10.1.20 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
17 undo 8 10.1.20 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
18 undo 16 10.1.20 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
19 undo 64 10.1.20 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.20 crashed upon recovery)
20 undo 4 10.1.20 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
21 undo 32 10.1.20 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
22 undo 16 10.1.20 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.20 crashed upon shutdown)
23 undo 64 10.1.20 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
24 undo 8 10.1.20 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
25 undo 4 10.1.20 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
26 undo 8 10.3.1 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
27 undo 64 10.3.1 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
28 undo 32 10.3.1 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
29 undo 4 10.3.1 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
30 undo 16 10.3.1 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
31 undo 16 10.3.0 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
32 undo 64 10.3.0 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
33 undo 4 10.3.0 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
34 undo 8 10.3.0 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
35 undo 32 10.3.0 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
36 undo 16 10.3.0 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
37 undo 4 10.3.0 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
38 undo 64 10.3.0 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
39 undo 32 10.3.0 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
40 undo 8 10.3.0 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
41 undo 16 10.3.1 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
42 undo 4 10.3.1 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
43 undo 8 10.3.1 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
44 undo 64 10.3.1 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
45 undo 32 10.3.1 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
46 undo 32 10.1.20 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
47 undo 64 10.1.20 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - FAIL Pre-upgrade failure (10.1.20 crashed upon recovery)
48 undo 8 10.1.20 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
49 undo 16 10.1.20 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
50 undo 4 10.1.20 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
51 undo 4 10.1.27 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
52 undo 16 10.1.27 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - FAIL Post-upgrade failure (10.3 crashed during normal operation, MDEV-13512)
53 undo 8 10.1.27 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
54 undo 32 10.1.27 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
55 undo 64 10.1.27 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
56 undo 16 10.1.20 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
57 undo 8 10.1.20 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
58 undo 32 10.1.20 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
59 undo 4 10.1.20 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
60 undo 64 10.1.20 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - FAIL Pre-upgrade failure (10.1.20 crashed upon recovery)
61 undo 32 10.2.8 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
62 undo 16 10.2.8 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
63 undo 8 10.2.8 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
64 undo 64 10.2.8 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
65 undo 4 10.2.8 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
66 undo 64 10.1.27 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
67 undo 4 10.1.27 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
68 undo 32 10.1.27 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
69 undo 8 10.1.27 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.27 crashed upon recovery, MDEV-13537)
70 undo 16 10.1.27 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
71 undo 64 10.1.27 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
72 undo 4 10.1.27 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
73 undo 8 10.1.27 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
74 undo 32 10.1.27 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
75 undo 16 10.1.27 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
Comment by Elena Stepanova [ 2017-08-16 ]

10.2 c354cb66b

2017-08-15 23:21:02

trial type pagesize OLD version file format encrypted compressed   NEW version file format encrypted compressed readonly result notes
1 undo 4 10.1.27 (InnoDB plugin) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
2 undo 32 10.1.27 (InnoDB plugin) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
3 undo 8 10.1.27 (InnoDB plugin) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
4 undo 64 10.1.27 (InnoDB plugin) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
5 undo 16 10.1.27 (InnoDB plugin) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
6 undo 16 10.1.20 (InnoDB plugin) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
7 undo 32 10.1.20 (InnoDB plugin) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
8 undo 64 10.1.20 (InnoDB plugin) Barracuda on - => 10.2.8 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.20 crashed upon recovery)
9 undo 8 10.1.20 (InnoDB plugin) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
10 undo 4 10.1.20 (InnoDB plugin) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
11 undo 8 10.1.27 (InnoDB plugin) Barracuda on - => 10.2.8 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.27 crashed upon recovery, MDEV-13537)
12 undo 32 10.1.27 (InnoDB plugin) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
13 undo 64 10.1.27 (InnoDB plugin) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
14 undo 16 10.1.27 (InnoDB plugin) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
15 undo 4 10.1.27 (InnoDB plugin) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
16 undo 16 10.2.6 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
17 undo 64 10.2.6 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
18 undo 32 10.2.6 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
19 undo 8 10.2.6 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
20 undo 4 10.2.6 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
21 undo 16 10.2.8 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
22 undo 64 10.2.8 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
23 undo 32 10.2.8 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
24 undo 8 10.2.8 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
25 undo 4 10.2.8 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
26 undo 32 10.1.27 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
27 undo 64 10.1.27 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
28 undo 8 10.1.27 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
29 undo 4 10.1.27 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
30 undo 16 10.1.27 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
31 undo 4 10.2.8 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
32 undo 64 10.2.8 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
33 undo 8 10.2.8 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
34 undo 16 10.2.8 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
35 undo 32 10.2.8 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
36 undo 32 10.1.20 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
37 undo 8 10.1.20 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
38 undo 4 10.1.20 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
39 undo 16 10.1.20 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - FAIL Post-upgrade failure (10.2 crashed during normal operation, MDEV-13512)
40 undo 64 10.1.20 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
41 undo 16 10.1.20 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
42 undo 32 10.1.20 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
43 undo 64 10.1.20 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - FAIL Pre-upgrade failure (10.1.20 crashed upon recovery)
44 undo 8 10.1.20 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - FAIL Pre-upgrade failure (10.1.20 crashed upon shutdown after recovery)
45 undo 4 10.1.20 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
46 undo 32 10.1.27 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
47 undo 8 10.1.27 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.27 crashed upon recovery, MDEV-13537)
48 undo 4 10.1.27 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
49 undo 16 10.1.27 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - FAIL Post-upgrade failure (10.2 crashed during normal operation, MDEV-13512)
50 undo 64 10.1.27 (inbuilt) Barracuda on - => 10.2.8 (inbuilt)   on - - OK  
51 undo 4 5.7.14 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
52 undo 64 5.7.14 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
53 undo 8 5.7.14 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
54 undo 16 5.7.14 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
55 undo 32 5.7.14 (inbuilt) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
56 undo 16 10.1.20 (InnoDB plugin) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
57 undo 64 10.1.20 (InnoDB plugin) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
58 undo 32 10.1.20 (InnoDB plugin) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
59 undo 8 10.1.20 (InnoDB plugin) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
60 undo 4 10.1.20 (InnoDB plugin) Barracuda - - => 10.2.8 (inbuilt)   - - - OK  
Comment by Elena Stepanova [ 2017-08-16 ]

10.3 92f9be495

2017-08-16 16:08:10

trial type pagesize OLD version file format encrypted compressed   NEW version file format encrypted compressed readonly result notes
1 undo 64 10.1.27 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
2 undo 4 10.1.27 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
3 undo 8 10.1.27 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
4 undo 32 10.1.27 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
5 undo 16 10.1.27 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
6 undo 64 10.2.8 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
7 undo 16 10.2.8 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
8 undo 8 10.2.8 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
9 undo 4 10.2.8 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
10 undo 32 10.2.8 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
11 undo 4 5.7.14 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
12 undo 16 5.7.14 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
13 undo 64 5.7.14 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
14 undo 8 5.7.14 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
15 undo 32 5.7.14 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
16 undo 32 10.1.20 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
17 undo 8 10.1.20 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.20 crashed upon recovery, MDEV-13537)
18 undo 16 10.1.20 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
19 undo 64 10.1.20 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.20 crashed upon recovery)
20 undo 4 10.1.20 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
21 undo 32 10.1.20 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
22 undo 16 10.1.20 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - FAIL Post-upgrade failure (10.3 crashed during normal operation, MDEV-13512)
23 undo 64 10.1.20 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.20 crashed upon recovery)
24 undo 8 10.1.20 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.20 crashed upon shutdown after recovery)
25 undo 4 10.1.20 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - FAIL Pre-upgrade failure (10.1.20 crashed upon shutdown after recovery)
26 undo 8 10.3.1 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
27 undo 64 10.3.1 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
28 undo 32 10.3.1 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
29 undo 4 10.3.1 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
30 undo 16 10.3.1 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
31 undo 16 10.3.0 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
32 undo 64 10.3.0 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
33 undo 4 10.3.0 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
34 undo 8 10.3.0 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
35 undo 32 10.3.0 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
36 undo 16 10.3.0 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
37 undo 4 10.3.0 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
38 undo 64 10.3.0 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
39 undo 32 10.3.0 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
40 undo 8 10.3.0 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
41 undo 16 10.3.1 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
42 undo 4 10.3.1 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
43 undo 8 10.3.1 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
44 undo 64 10.3.1 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
45 undo 32 10.3.1 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
46 undo 32 10.1.20 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
47 undo 64 10.1.20 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - FAIL Pre-upgrade failure (10.1.20 crashed upon shutdown after recovery)
48 undo 8 10.1.20 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
49 undo 16 10.1.20 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
50 undo 4 10.1.20 (InnoDB plugin) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
51 undo 4 10.1.27 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
52 undo 16 10.1.27 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
53 undo 8 10.1.27 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
54 undo 32 10.1.27 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
55 undo 64 10.1.27 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
56 undo 16 10.1.20 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
57 undo 8 10.1.20 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
58 undo 32 10.1.20 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - FAIL Pre-upgrade failure (10.1.20 crashed upon recovery)
59 undo 4 10.1.20 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
60 undo 64 10.1.20 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
61 undo 32 10.2.8 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
62 undo 16 10.2.8 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
63 undo 8 10.2.8 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
64 undo 64 10.2.8 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
65 undo 4 10.2.8 (inbuilt) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
66 undo 64 10.1.27 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
67 undo 4 10.1.27 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
68 undo 32 10.1.27 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
69 undo 8 10.1.27 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
70 undo 16 10.1.27 (InnoDB plugin) Barracuda on - => 10.3.1 (inbuilt)   on - - OK  
71 undo 64 10.1.27 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
72 undo 4 10.1.27 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
73 undo 8 10.1.27 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
74 undo 32 10.1.27 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
75 undo 16 10.1.27 (inbuilt) Barracuda - - => 10.3.1 (inbuilt)   - - - OK  
Comment by Elena Stepanova [ 2017-09-08 ]

Undo upgrade tests have been set up for running regularly in travis, in 10.x-innodb-upgrade branches (along with other kinds of upgrade and recovery tests):
https://travis-ci.org/elenst/mariadb-tests/branches

The algorithm is pretty much the same as in the initial description, with one change – instead of running with innodb-read-only, the server on the step 3 is just made unavailable for client connections, it seems to be a more realistic scenario and does not set unnecessary limitations.

The scenario is implemented via RQG as upgrade-test=undo, which triggers UpgradeUndoLogs reporter. The code is in github.com/elenst/rqg, branch experimental (which will be merged into master with time).

As of now (Sep 8th, 2017), the current combinations of undo tests are running:

10.0 branch

  • upgrade from the latest released 10.0, page sizes 4K, 8K, 16K;
  • upgrade from 10.0.18, page sizes 4K, 8K, 16K;
  • upgrade from the latest released MySQL 5.6, page sizes 4K, 8K, 16K

10.1 branch

  • upgrade from the latest released 10.1, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from 10.1.22, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from the latest released 10.0, page sizes 4K, 8K, 16K, encryption turn-on*/OFF;
  • upgrade from 10.0.18, page sizes 4K, 8K, 16K, encryption turn-on*/OFF;
  • upgrade from the latest released MySQL 5.6, page sizes 4K, 8K, 16K, encryption turn-on*/OFF;

10.2 branch

  • upgrade from the latest released 10.2, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from 10.2.6, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from the latest released 10.1, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from 10.1.22, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from the latest released 10.0, page sizes 4K, 8K, 16K, encryption turn-on*/OFF;
  • upgrade from 10.0.18, page sizes 4K, 8K, 16K, encryption turn-on*/OFF;
  • upgrade from the latest released MySQL 5.7, page sizes 4K, 8K, 16K, 32K, 64K, encryption turn-on*/OFF;
  • upgrade from the latest released MySQL 5.6, page sizes 4K, 8K, 16K, encryption turn-on*/OFF;

10.3 branch

  • upgrade from the latest released 10.3, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from the latest released 10.2, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from 10.2.6, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from the latest released 10.1, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from 10.1.22, page sizes 4K, 8K, 16K, 32K, 64K, encryption ON/OFF, compression none/zlib;
  • upgrade from the latest released 10.0, page sizes 4K, 8K, 16K, encryption turn-on*/OFF;
  • upgrade from 10.0.18, page sizes 4K, 8K, 16K, encryption turn-on*/OFF;
  • upgrade from the latest released MySQL 5.7, page sizes 4K, 8K, 16K, 32K, 64K, encryption turn-on*/OFF;
  • upgrade from the latest released MySQL 5.6, page sizes 4K, 8K, 16K, encryption turn-on*/OFF;
    —
    * encryption turn-on means that encryption was off (or unavailable) on the old server, but ON on the new server

Tests are currently affected by MDEV-13103, MDEV-13112, MDEV-13512, MDEV-13165, and MySQL 5.6 sporadically hanging on shutdown.

Further improvements and additions to the tests will be made outside the scope of this task.

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