- start server with SEQUENCE and InnoDB
- kill server (do not shut down, make it die)
- start server without SEQUENCE
  => server does not start

--source include/have_innodb.inc

--echo # Shutdown the server...

--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server 10
--source include/wait_until_disconnected.inc

--echo # Restart the server with SEQUENCE enabled....

--exec echo "restart:--sequence --plugin-load-add=ha_sequence.so" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc

select engine, support from information_schema.engines;

--echo # Kill the server....

--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server 0
--source include/wait_until_disconnected.inc

--echo # Restart the server without SEQUENCE....

--exec echo "restart:--loose-skip-sequence" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc

select engine, support from information_schema.engines;

--echo # All done.

2015-09-11 20:15:30 139911419701088 [ERROR] Recovery failed! You must enable exactly 3 storage engines that support two-phase commit protocol
2015-09-11 20:15:30 139911419701088 [ERROR] Crash recovery failed. Either correct the problem (if it's, for example, out of memory error) and restart, or delete tc log and start mysqld with --tc-heuristic-recover={commit|rollback}
2015-09-11 20:15:30 139911419701088 [ERROR] Can't init tc log
2015-09-11 20:15:30 139911419701088 [ERROR] Aborting