Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
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
Attachments
Issue Links
- is blocked by
-
MDEV-13430 InnoDB upgrade from previous versions to 10.3 is not possible
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
(5 relates to)
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] |
| Description |
Marko wrote:
{quote} We'd need that for 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 {quote} |
Marko wrote:
{quote} We'd need that for 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 I’d appreciate such a test with bb-10.3-marko {quote} |
| Link |
This issue relates to |
| Link |
This issue relates to |
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
|
....
|
| Link |
This issue relates to |
| Link |
This issue relates to |
| Status | Open [ 1 ] | In Progress [ 3 ] |
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.
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Link |
This issue is blocked by |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Link |
This issue relates to |
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.
|
| Link |
This issue relates to |
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
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, |
|
| 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, |
|
| 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 |
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, |
|
| 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, |
|
| 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, |
|
| 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, |
|
| 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 |
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, |
|
| 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, |
|
| 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 |
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.
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Link | This issue is part of TODO-27 [ TODO-27 ] |
| Link |
This issue relates to |
| Workflow | MariaDB v3 [ 81590 ] | MariaDB v4 [ 133300 ] |
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 pool2017-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 mode2017-08-02 15:26:03 140179066781760 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2595] with error Read only transaction2017-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: InnoDB2017-08-02 15:26:03 140179066781760 [ERROR] Aborting