[mysqld] early-plugin-load=keyring_file.so keyring_file_data=/export/umesh/server/binaries/Trunk/mysql-8.0.1/keyring innodb_redo_log_encrypt=ON innodb_undo_tablespaces=77 innodb_undo_logs=77 innodb_undo_log_encrypt=ON rm -rf 85969/ bin/mysqld --defaults-file=./my.cnf --basedir=$PWD --datadir=$PWD/85969 --log-error=$PWD/85969/mysql.err --initialize-insecure bin/mysqld --defaults-file=./my.cnf --log-bin --server-id=1 --basedir=$PWD --datadir=$PWD/85969 --log-error=$PWD/85969/mysql.err --core-file 2>&1 & -- 2017-04-18T07:04:43.779821Z 1 [Note] InnoDB: Read redo log encryption metadata successful. 2017-04-18T07:04:43.792914Z 1 [Note] InnoDB: Opened 77 undo tablespaces 2017-04-18T07:04:43.792928Z 1 [Note] InnoDB: 77 undo tablespaces made active 2017-04-18T07:04:43.832611Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-04-18T07:04:43.832689Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-04-18T07:04:43.848619Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-04-18T07:04:43.849633Z 1 [Note] InnoDB: 32 rollback segment(s) are active in the temporary tablespace. 2017-04-18T07:04:43.852607Z 1 [Note] InnoDB: 8.0.1 started; log sequence number 11309750 2017-04-18T07:04:43.854691Z 1 [Note] InnoDB: Waiting for purge to start 2017-04-18T07:04:43.905020Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/Trunk/mysql-8.0.1/85969/ib_buffer_pool 2017-04-18T07:04:43.912278Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170418 9:04:43 2017-04-18T07:04:43.971315Z 1 [Note] Found data dictionary with version 1 2017-04-18T07:04:43.974717Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-04-18T07:04:43.975099Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2017-04-18T07:04:43.975144Z 0 [Note] IPv6 is available. 2017-04-18T07:04:43.975157Z 0 [Note] - '::' resolves to '::'; 2017-04-18T07:04:43.975194Z 0 [Note] Server socket created on IP: '::'. 2017-04-18T07:04:44.034282Z 0 [Note] bin/mysqld: ready for connections. Version: '8.0.1-dmr' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) -- root@localhost [test]> use test; Database changed root@localhost [test]> drop table if exists keyvalue; Query OK, 0 rows affected, 1 warning (0.00 sec) root@localhost [test]> CREATE TABLE `keyvalue` ( -> `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, -> `name1` varchar(250), -> `name2` varchar(250), -> `name3` varchar(250), -> `name4` varchar(250), -> PRIMARY KEY (`id`, name1(10)) -> ) ENGINE=innodb; Query OK, 0 rows affected (0.01 sec) root@localhost [test]> root@localhost [test]> set @id:=0; Query OK, 0 rows affected (0.00 sec) root@localhost [test]> root@localhost [test]> insert into `keyvalue` values -> (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)); Query OK, 4 rows affected (0.01 sec) Records: 4 Duplicates: 0 Warnings: 0 root@localhost [test]> root@localhost [test]> insert into `keyvalue`(`id`,`name1`,`name2`,`name3`,`name4`) -> select @id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000) from -> `keyvalue` k1, `keyvalue` k2, `keyvalue` k3, `keyvalue` k4,`keyvalue` k5,`keyvalue` k6, `keyvalue` k7, `keyvalue` k8, `keyvalue` k9, -> `keyvalue` k0,`keyvalue` ka, `keyvalue` kb, `keyvalue` kc, `keyvalue` kd limit 5000000; Query OK, 5000000 rows affected (1 min 52.99 sec) Records: 5000000 Duplicates: 0 Warnings: 0 root@localhost [test]> root@localhost [test]> alter table keyvalue encryption='Y'; ERROR 2013 (HY000): Lost connection to MySQL server during query root@localhost [test]> ^^ kill -9 `pidof mysqld` -- restarted again, but no issues 2017-04-18T07:11:02.807766Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2017-04-18T07:11:02.818963Z 1 [Note] InnoDB: Completed initialization of buffer pool 2017-04-18T07:11:02.821719Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-04-18T07:11:02.834328Z 1 [Note] InnoDB: Read redo log encryption metadata successful. 2017-04-18T07:11:02.836941Z 1 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1524816079 2017-04-18T07:11:02.975964Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1530058752 2017-04-18T07:11:03.001442Z 1 [Note] InnoDB: Read encryption metadata from ./test/#sql-6497_5.ibd successfully, encryption of this tablespace enabled. 2017-04-18T07:11:03.115842Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1535301632 2017-04-18T07:11:03.255542Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1540544512 2017-04-18T07:11:03.395116Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1545787392 2017-04-18T07:11:03.534656Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1551030272 2017-04-18T07:11:03.674121Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1556273152 2017-04-18T07:11:03.813666Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1561516032 2017-04-18T07:11:03.953245Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1566758912 2017-04-18T07:11:04.092770Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1572001792 2017-04-18T07:11:04.232304Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1577244672 2017-04-18T07:11:04.270899Z 1 [Note] InnoDB: Read encryption metadata from .//undo040 successfully, encryption of this tablespace enabled. 2017-04-18T07:11:04.320363Z 1 [Note] InnoDB: Read encryption metadata from .//undo041 successfully, encryption of this tablespace enabled. 2017-04-18T07:11:04.372388Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1582487552 2017-04-18T07:11:04.518337Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1528551424 2017-04-18T07:11:04.665693Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1533794304 2017-04-18T07:11:04.812973Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1539037184 2017-04-18T07:11:04.960289Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1544280064 2017-04-18T07:11:05.107685Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1549522944 2017-04-18T07:11:05.255037Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1554765824 2017-04-18T07:11:05.402367Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1560008704 2017-04-18T07:11:05.549663Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1565251584 2017-04-18T07:11:05.696983Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1570494464 2017-04-18T07:11:05.844289Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1575737344 2017-04-18T07:11:05.991776Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1580980224 2017-04-18T07:11:06.139200Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1586223104 2017-04-18T07:11:06.286553Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1591465984 2017-04-18T07:11:06.308653Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1592251992 2017-04-18T07:11:06.309650Z 1 [Note] InnoDB: Database was not shutdown normally! 2017-04-18T07:11:06.309661Z 1 [Note] InnoDB: Starting crash recovery. 2017-04-18T07:11:06.334327Z 1 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 2017-04-18T07:11:07.203081Z 1 [Note] InnoDB: Apply batch completed 2017-04-18T07:11:07.626058Z 1 [Note] InnoDB: Opened 77 undo tablespaces 2017-04-18T07:11:07.626082Z 1 [Note] InnoDB: 77 undo tablespaces made active 2017-04-18T07:11:07.664751Z 1 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 18 row operations to undo 2017-04-18T07:11:07.664768Z 1 [Note] InnoDB: Trx id counter is 2048 2017-04-18T07:11:07.847439Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-04-18T07:11:07.847471Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-04-18T07:11:07.847593Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-04-18T07:11:07.864422Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-04-18T07:11:07.865302Z 1 [Note] InnoDB: 32 rollback segment(s) are active in the temporary tablespace. 2017-04-18T07:11:07.867311Z 1 [Note] InnoDB: 8.0.1 started; log sequence number 1592251992 2017-04-18T07:11:07.867398Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5046ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2017-04-18T07:11:07.871850Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2017-04-18T07:11:07.871894Z 0 [Note] InnoDB: Rolling back trx with id 1587, 18 rows to undo 2017-04-18T07:11:07.872065Z 1 [Note] InnoDB: Waiting for purge to start 2017-04-18T07:11:07.874256Z 0 [Note] InnoDB: Rollback of trx with id 1587 completed 2017-04-18T07:11:07.874280Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2017-04-18T07:11:07.922335Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/Trunk/mysql-8.0.1/85969/ib_buffer_pool 2017-04-18T07:11:07.927390Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170418 9:11:07 2017-04-18T07:11:07.987872Z 1 [Note] Found data dictionary with version 1 2017-04-18T07:11:07.991151Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-04-18T07:11:07.991554Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2017-04-18T07:11:07.991597Z 0 [Note] IPv6 is available. 2017-04-18T07:11:07.991608Z 0 [Note] - '::' resolves to '::'; 2017-04-18T07:11:07.991650Z 0 [Note] Server socket created on IP: '::'. 2017-04-18T07:11:08.051391Z 0 [Note] bin/mysqld: ready for connections. Version: '8.0.1-dmr' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)