[MDEV-13269] Upgrade tests for InnoDB undo log - Jira

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Fix Version/s: N/A
Component/s: Tests
Labels:
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

MDEV-12288 Reset DB_TRX_ID when the history is removed, to speed up MVCC

Closed

MDEV-12289 Keep 128 persistent rollback segments for compatibility and performance

Closed

MDEV-13437 InnoDB fails to return error for XA COMMIT or XA ROLLBACK in read-only mode

Closed

MDEV-13438 Assertion `(&(&LOCK_log)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&LOCK_log)->m_mutex)->thread)' failed in MYSQL_BIN_LOG::open or Assertion `info.dry_run || total_ha_2pc>(ulong)opt_bin_log' failed in ha_recover

Closed

MDEV-13520 InnoDB attempts UPDATE with DB_TRX_ID=0 if innodb_force_recovery=3

Closed

MDEV-13475 InnoDB: Failing assertion: lsn == log_sys->lsn || srv_force_recovery == SRV_FORCE_NO_LOG_REDO

Closed

MDEV-13476 TRX_UNDO_PAGE_TYPE mismatch when writing undo log after upgrade

Closed

MDEV-13495 Crash in rollback of a recovered INSERT transaction after upgrade

Closed

MDEV-22257 Assertion `trx_id > 0 || (flags & BTR_KEEP_SYS_FLAG)' failed in btr_cur_optimistic_update | Assertion `id' failed in trx_write_trx_id

Closed

(5 relates to)

Activity

Ascending order - Click to sort in descending order

View 4 older comments

Marko Mäkelä added a comment - 2017-08-14 12:38

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

Marko Mäkelä added a comment - 2017-08-14 12:38 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

Elena Stepanova added a comment - 2017-08-15 18:10 - edited

10.3 347d9456e4eb

2017-08-14 17:34:15

trial	type	pagesize	OLD version	file format	encrypted	compressed		NEW version	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

Elena Stepanova added a comment - 2017-08-15 18:10 - edited 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

Elena Stepanova added a comment - 2017-08-16 17:45

10.2 c354cb66b

2017-08-15 23:21:02

trial	type	pagesize	OLD version	file format	encrypted	compressed		NEW version	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

Elena Stepanova added a comment - 2017-08-16 17:45 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

Elena Stepanova added a comment - 2017-08-16 20:02

10.3 92f9be495

2017-08-16 16:08:10

trial	type	pagesize	OLD version	file format	encrypted	compressed		NEW version	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

Elena Stepanova added a comment - 2017-08-16 20:02 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

Elena Stepanova added a comment - 2017-09-08 13:29 - edited

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.

Elena Stepanova added a comment - 2017-09-08 13:29 - edited 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.

MariaDB Server

Upgrade tests for InnoDB undo log