160424 13:00:28 [Note] /usr/sbin/mysqld: Normal shutdown 160424 13:00:28 [Note] Event Scheduler: Purging the queue. 0 events 160424 13:00:28 InnoDB: Starting shutdown... 160424 13:00:30 InnoDB: Shutdown completed; log sequence number 1651365 160424 13:00:30 [Note] /usr/sbin/mysqld: Shutdown complete 2016-04-24T09:09:19.320150Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-04-24T09:09:19.335245Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.11-0ubuntu6) starting as process 24326 ... 2016-04-24T09:09:19.497284Z 0 [Note] InnoDB: PUNCH HOLE support available 2016-04-24T09:09:19.497331Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-04-24T09:09:19.497340Z 0 [Note] InnoDB: Uses event mutexes 2016-04-24T09:09:19.497347Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2016-04-24T09:09:19.497357Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-04-24T09:09:19.497367Z 0 [Note] InnoDB: Using Linux native AIO 2016-04-24T09:09:19.502750Z 0 [Note] InnoDB: Number of pools: 1 2016-04-24T09:09:19.510800Z 0 [Note] InnoDB: Using CPU crc32 instructions 2016-04-24T09:09:19.520072Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-04-24T09:09:19.542357Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-04-24T09:09:19.545165Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-04-24T09:09:19.622326Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-04-24T09:09:19.776813Z 0 [Note] InnoDB: Creating tablespace and datafile system tables. 2016-04-24T09:09:19.865107Z 0 [Note] InnoDB: Tablespace and datafile system tables created. 2016-04-24T09:09:19.920923Z 0 [Warning] InnoDB: Upgrading redo log: 2*3072 pages, LSN=1655743 2016-04-24T09:09:20.132291Z 0 [Warning] InnoDB: Starting to delete and rewrite log files. 2016-04-24T09:09:20.133014Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2016-04-24T09:09:20.888881Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2016-04-24T09:09:22.489831Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2016-04-24T09:09:22.489939Z 0 [Warning] InnoDB: New log files created, LSN=1655743 2016-04-24T09:09:22.490981Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-04-24T09:09:22.491052Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-04-24T09:09:22.712535Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2016-04-24T09:09:22.715053Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-04-24T09:09:22.715099Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-04-24T09:09:22.715870Z 0 [Note] InnoDB: Creating sys_virtual system tables. 2016-04-24T09:09:22.768383Z 0 [Note] InnoDB: sys_virtual table created 2016-04-24T09:09:22.774179Z 0 [Note] InnoDB: Waiting for purge to start 2016-04-24T09:09:22.824361Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 0 2016-04-24T09:09:22.824745Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2016-04-24T09:09:22.824793Z 0 [ERROR] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory 2016-04-24T09:09:22.825412Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-04-24T09:09:22.868349Z 0 [Warning] System table 'plugin' is expected to be transactional. 2016-04-24T09:09:22.878183Z 0 [Note] Salting uuid generator variables, current_pid: 24326, server_start_time: 1461488959, bytes_sent: 0, 2016-04-24T09:09:22.881618Z 0 [Note] Generated uuid: '3c4311fe-09fc-11e6-9381-805c495ae981', server_start_time: 6847160284924931141, bytes_sent: 54281600 2016-04-24T09:09:22.881687Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 3c4311fe-09fc-11e6-9381-805c495ae981. 2016-04-24T09:09:22.924758Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-04-24T09:09:22.947050Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2016-04-24T09:09:22.947126Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2016-04-24T09:09:22.947185Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2016-04-24T09:09:22.947224Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2016-04-24T09:09:22.947667Z 0 [Warning] Failed to open optimizer cost constant tables 2016-04-24T09:09:23.038481Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional. 2016-04-24T09:09:23.038532Z 0 [Warning] System table 'time_zone_name' is expected to be transactional. 2016-04-24T09:09:23.038538Z 0 [Warning] System table 'time_zone' is expected to be transactional. 2016-04-24T09:09:23.038544Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional. 2016-04-24T09:09:23.038549Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional. 2016-04-24T09:09:23.125623Z 0 [Warning] System table 'servers' is expected to be transactional. 2016-04-24T09:09:23.152305Z 0 [ERROR] Column count of performance_schema.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50549, now running 50711. Please use mysql_upgrade to fix this error. 2016-04-24T09:09:23.152676Z 0 [ERROR] Column count of performance_schema.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50549, now running 50711. Please use mysql_upgrade to fix this error. 2016-04-24T09:09:23.153054Z 0 [ERROR] Column count of performance_schema.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50549, now running 50711. Please use mysql_upgrade to fix this error. 2016-04-24T09:09:23.153109Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2016-04-24T09:09:23.153813Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11). 2016-04-24T09:09:23.153873Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2016-04-24T09:09:23.153906Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2016-04-24T09:09:23.166018Z 0 [ERROR] Column count of performance_schema.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50549, now running 50711. Please use mysql_upgrade to fix this error. 2016-04-24T09:09:23.166404Z 0 [ERROR] Column count of performance_schema.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50549, now running 50711. Please use mysql_upgrade to fix this error. 2016-04-24T09:09:23.166473Z 0 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2016-04-24T09:09:23.166878Z 0 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2016-04-24T09:09:23.166939Z 0 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2016-04-24T09:09:23.167642Z 0 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2016-04-24T09:09:23.167686Z 0 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure 2016-04-24T09:09:23.168539Z 0 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure 2016-04-24T09:09:23.169093Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure 2016-04-24T09:09:23.169133Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure 2016-04-24T09:09:23.169175Z 0 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure 2016-04-24T09:09:23.169516Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 3. Created with MySQL 50549, now running 50711. Please use mysql_upgrade to fix this error. 2016-04-24T09:09:23.169555Z 0 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure 2016-04-24T09:09:23.169583Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure 2016-04-24T09:09:23.169617Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure 2016-04-24T09:09:23.169650Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure 2016-04-24T09:09:23.169683Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure 2016-04-24T09:09:23.169712Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure 2016-04-24T09:09:23.169750Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure 2016-04-24T09:09:23.169780Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure 2016-04-24T09:09:23.169812Z 0 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure 2016-04-24T09:09:23.169839Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2016-04-24T09:09:23.169870Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2016-04-24T09:09:23.169903Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2016-04-24T09:09:23.169934Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2016-04-24T09:09:23.169964Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2016-04-24T09:09:23.169993Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2016-04-24T09:09:23.170026Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure 2016-04-24T09:09:23.170055Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure 2016-04-24T09:09:23.170091Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure 2016-04-24T09:09:23.170118Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure 2016-04-24T09:09:23.170147Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure 2016-04-24T09:09:23.170176Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure 2016-04-24T09:09:23.170208Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure 2016-04-24T09:09:23.170237Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure 2016-04-24T09:09:23.170271Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure 2016-04-24T09:09:23.170302Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure 2016-04-24T09:09:23.170338Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure 2016-04-24T09:09:23.170380Z 0 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2016-04-24T09:09:23.170433Z 0 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2016-04-24T09:09:23.170492Z 0 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2016-04-24T09:09:23.170540Z 0 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2016-04-24T09:09:23.170590Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2016-04-24T09:09:23.170623Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2016-04-24T09:09:23.170657Z 0 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2016-04-24T09:09:23.170688Z 0 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure 2016-04-24T09:09:23.170719Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure 2016-04-24T09:09:23.170750Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure 2016-04-24T09:09:23.170778Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure 2016-04-24T09:09:23.170805Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure 2016-04-24T09:09:23.170836Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure 2016-04-24T09:09:23.170866Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure 2016-04-24T09:09:23.170902Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure 2016-04-24T09:09:23.170930Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure 2016-04-24T09:09:23.170962Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure 2016-04-24T09:09:23.170990Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure 2016-04-24T09:09:23.171019Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure 2016-04-24T09:09:23.171046Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure 2016-04-24T09:09:23.171077Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure 2016-04-24T09:09:23.171105Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure 2016-04-24T09:09:23.171137Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure 2016-04-24T09:09:23.171167Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure 2016-04-24T09:09:23.171198Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure 2016-04-24T09:09:23.171223Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure 2016-04-24T09:09:23.171252Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure 2016-04-24T09:09:23.171282Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure 2016-04-24T09:09:23.171310Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure 2016-04-24T09:09:23.171336Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure 2016-04-24T09:09:23.171364Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure 2016-04-24T09:09:23.171393Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure 2016-04-24T09:09:23.171424Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure 2016-04-24T09:09:23.171451Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure 2016-04-24T09:09:23.171566Z 0 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(32), found type char(16). 2016-04-24T09:09:23.171601Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28 2016-04-24T09:09:23.191757Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2016-04-24T09:09:23.191953Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.11-0ubuntu6' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2016-04-24T09:09:47.295564Z 5 [Warning] System table 'servers' is expected to be transactional. 2016-04-24T09:13:49.519318Z 0 [Note] Giving 0 client threads a chance to die gracefully 2016-04-24T09:13:49.519359Z 0 [Note] Shutting down slave threads 2016-04-24T09:13:49.519371Z 0 [Note] Forcefully disconnecting 0 remaining clients 2016-04-24T09:13:49.519776Z 0 [Note] Binlog end 2016-04-24T09:13:49.545957Z 0 [Note] Shutting down plugin 'ngram' 2016-04-24T09:13:49.546028Z 0 [Note] Shutting down plugin 'ARCHIVE' 2016-04-24T09:13:49.546047Z 0 [Note] Shutting down plugin 'partition' 2016-04-24T09:13:49.546063Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2016-04-24T09:13:49.546079Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2016-04-24T09:13:49.546094Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-04-24T09:13:49.546108Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-04-24T09:13:49.546121Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-04-24T09:13:49.546135Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-04-24T09:13:49.546148Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-04-24T09:13:49.546161Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-04-24T09:13:49.546174Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-04-24T09:13:49.546188Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-04-24T09:13:49.546201Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-04-24T09:13:49.546215Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-04-24T09:13:49.546228Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-04-24T09:13:49.546241Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-04-24T09:13:49.546254Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-04-24T09:13:49.546268Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-04-24T09:13:49.546281Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-04-24T09:13:49.546294Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2016-04-24T09:13:49.546307Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2016-04-24T09:13:49.546321Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-04-24T09:13:49.546334Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-04-24T09:13:49.546348Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-04-24T09:13:49.546361Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-04-24T09:13:49.546374Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-04-24T09:13:49.546387Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-04-24T09:13:49.546400Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-04-24T09:13:49.546413Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-04-24T09:13:49.546427Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2016-04-24T09:13:49.546439Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-04-24T09:13:49.546452Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-04-24T09:13:49.546465Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2016-04-24T09:13:49.546478Z 0 [Note] Shutting down plugin 'InnoDB' 2016-04-24T09:13:49.546658Z 0 [Note] InnoDB: FTS optimize thread exiting. 2016-04-24T09:13:49.546884Z 0 [Note] InnoDB: Starting shutdown... 2016-04-24T09:13:49.647310Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2016-04-24T09:13:49.647984Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160424 14:43:49 2016-04-24T09:13:51.375563Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2816172 2016-04-24T09:13:51.378145Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-04-24T09:13:51.378175Z 0 [Note] Shutting down plugin 'MEMORY' 2016-04-24T09:13:51.378183Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-04-24T09:13:51.378209Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2016-04-24T09:13:51.378215Z 0 [Note] Shutting down plugin 'MyISAM' 2016-04-24T09:13:51.378223Z 0 [Note] Shutting down plugin 'CSV' 2016-04-24T09:13:51.378230Z 0 [Note] Shutting down plugin 'sha256_password' 2016-04-24T09:13:51.378235Z 0 [Note] Shutting down plugin 'mysql_native_password' 2016-04-24T09:13:51.378240Z 0 [Note] Shutting down plugin 'keyring_file' 2016-04-24T09:13:51.378447Z 0 [Note] Shutting down plugin 'binlog' 2016-04-24T09:13:51.378763Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2016-04-24T09:13:52.433282Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-04-24T09:13:52.433833Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.11-0ubuntu6) starting as process 383 ... 2016-04-24T09:13:52.439616Z 0 [Note] InnoDB: PUNCH HOLE support available 2016-04-24T09:13:52.439661Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-04-24T09:13:52.439670Z 0 [Note] InnoDB: Uses event mutexes 2016-04-24T09:13:52.439677Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2016-04-24T09:13:52.439687Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-04-24T09:13:52.439694Z 0 [Note] InnoDB: Using Linux native AIO 2016-04-24T09:13:52.439967Z 0 [Note] InnoDB: Number of pools: 1 2016-04-24T09:13:52.440082Z 0 [Note] InnoDB: Using CPU crc32 instructions 2016-04-24T09:13:52.448473Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-04-24T09:13:52.457815Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-04-24T09:13:52.459912Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-04-24T09:13:52.471959Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-04-24T09:13:52.573067Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-04-24T09:13:52.573168Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-04-24T09:13:52.796331Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2016-04-24T09:13:52.798527Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-04-24T09:13:52.798567Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-04-24T09:13:52.799692Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 2816172 2016-04-24T09:13:52.799989Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2016-04-24T09:13:52.800149Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-04-24T09:13:52.803120Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160424 14:43:52 2016-04-24T09:13:52.803539Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2016-04-24T09:13:52.803562Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2016-04-24T09:13:52.803588Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2016-04-24T09:13:52.803608Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2016-04-24T09:13:52.812917Z 0 [Note] Event Scheduler: Loaded 0 events 2016-04-24T09:13:52.813393Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.11-0ubuntu6' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2016-04-24T09:13:53.322586Z 6 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2016-04-24T09:20:35.914278Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2016-04-24T09:20:35.914393Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2016-04-24T09:20:36.517240Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-04-24T09:20:36.751431Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.11-0ubuntu6) starting as process 975 ... 2016-04-24T09:20:38.768347Z 0 [Note] InnoDB: PUNCH HOLE support available 2016-04-24T09:20:38.768392Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-04-24T09:20:38.768400Z 0 [Note] InnoDB: Uses event mutexes 2016-04-24T09:20:38.768406Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2016-04-24T09:20:38.768412Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-04-24T09:20:38.768418Z 0 [Note] InnoDB: Using Linux native AIO 2016-04-24T09:20:38.965664Z 0 [Note] InnoDB: Number of pools: 1 2016-04-24T09:20:39.183043Z 0 [Note] InnoDB: Using CPU crc32 instructions 2016-04-24T09:20:39.190892Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-04-24T09:20:39.277202Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-04-24T09:20:39.315948Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-04-24T09:20:39.940946Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-04-24T09:20:40.533110Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2816191 2016-04-24T09:20:40.533149Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2816200 2016-04-24T09:20:40.533610Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2816200 2016-04-24T09:20:40.533636Z 0 [Note] InnoDB: Database was not shutdown normally! 2016-04-24T09:20:40.533643Z 0 [Note] InnoDB: Starting crash recovery. 2016-04-24T09:20:46.219615Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-04-24T09:20:46.219658Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-04-24T09:20:46.219740Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-04-24T09:20:46.739928Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2016-04-24T09:20:46.740795Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-04-24T09:20:46.740808Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-04-24T09:20:46.741336Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7426ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2016-04-24T09:20:46.741350Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 2816200 2016-04-24T09:20:46.741632Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-04-24T09:20:46.741792Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2016-04-24T09:20:46.844957Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160424 14:50:46 2016-04-24T09:20:47.344014Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2016-04-24T09:20:47.344060Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2016-04-24T09:20:47.344073Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2016-04-24T09:20:47.344092Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2016-04-24T09:20:50.847321Z 0 [Note] Event Scheduler: Loaded 0 events 2016-04-24T09:20:50.847540Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.11-0ubuntu6' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2016-04-24T09:20:50.971787Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)