mysql.log

gistfile1.txt

2016-09-07T15:46:09.985077Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
2016-09-07T15:56:37.567578Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-09-07T15:56:37.780346Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-09-07T15:56:37.782649Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.14) starting as process 11055 ...
2016-09-07T15:56:37.787253Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-09-07T15:56:37.787283Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-07T15:56:37.787290Z 0 [Note] InnoDB: Uses event mutexes
2016-09-07T15:56:37.787298Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2016-09-07T15:56:37.787303Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-07T15:56:37.787308Z 0 [Note] InnoDB: Using Linux native AIO
2016-09-07T15:56:37.787562Z 0 [Note] InnoDB: Number of pools: 1
2016-09-07T15:56:37.787672Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-09-07T15:56:37.789478Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-09-07T15:56:37.798992Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-09-07T15:56:37.801724Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-09-07T15:56:37.813548Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-09-07T15:56:37.828037Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-09-07T15:56:37.828123Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-09-07T15:56:37.849350Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-09-07T15:56:37.850106Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-09-07T15:56:37.850118Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-09-07T15:56:37.851071Z 0 [Note] InnoDB: Waiting for purge to start
2016-09-07T15:56:37.901231Z 0 [Note] InnoDB: 5.7.14 started; log sequence number 1485230
2016-09-07T15:56:37.901800Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2016-09-07T15:56:37.901928Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160907 11:56:37
2016-09-07T15:56:37.901951Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-09-07T15:56:37.906520Z 0 [Warning] System table 'plugin' is expected to be transactional.
2016-09-07T15:56:37.906984Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-09-07T15:56:37.907068Z 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-09-07T15:56:37.907520Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-09-07T15:56:37.908290Z 0 [Note] IPv6 is available.
2016-09-07T15:56:37.908308Z 0 [Note]   - '::' resolves to '::';
2016-09-07T15:56:37.908326Z 0 [Note] Server socket created on IP: '::'.
2016-09-07T15:56:37.910369Z 0 [Warning] Failed to open optimizer cost constant tables

2016-09-07T15:56:37.910730Z 0 [ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade.
2016-09-07T15:56:37.910795Z 0 [ERROR] Aborting

2016-09-07T15:56:37.910807Z 0 [Note] Binlog end
2016-09-07T15:56:37.910857Z 0 [Note] Shutting down plugin 'ngram'
2016-09-07T15:56:37.910866Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-09-07T15:56:37.910870Z 0 [Note] Shutting down plugin 'partition'
2016-09-07T15:56:37.910873Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-09-07T15:56:37.910877Z 0 [Note] Shutting down plugin 'MyISAM'
2016-09-07T15:56:37.910885Z 0 [Note] Shutting down plugin 'CSV'
2016-09-07T15:56:37.910891Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-09-07T15:56:37.910895Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-09-07T15:56:37.910898Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-09-07T15:56:37.910902Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-09-07T15:56:37.910905Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-09-07T15:56:37.910908Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-09-07T15:56:37.910912Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-09-07T15:56:37.910915Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-09-07T15:56:37.910918Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-09-07T15:56:37.910921Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-09-07T15:56:37.910929Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-09-07T15:56:37.910933Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-09-07T15:56:37.910936Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-09-07T15:56:37.910939Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-09-07T15:56:37.910942Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-09-07T15:56:37.910946Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-09-07T15:56:37.910949Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-09-07T15:56:37.910952Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-09-07T15:56:37.910956Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-09-07T15:56:37.910959Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-09-07T15:56:37.910965Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-09-07T15:56:37.910968Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-09-07T15:56:37.910971Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-09-07T15:56:37.910974Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-09-07T15:56:37.910978Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-09-07T15:56:37.910981Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-09-07T15:56:37.910984Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-09-07T15:56:37.910987Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-09-07T15:56:37.910991Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-09-07T15:56:37.910994Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-09-07T15:56:37.910997Z 0 [Note] Shutting down plugin 'InnoDB'
2016-09-07T15:56:37.911062Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-09-07T15:56:37.911149Z 0 [Note] InnoDB: Starting shutdown...
2016-09-07T15:56:38.011300Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2016-09-07T15:56:38.011796Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160907 11:56:38
2016-09-07T15:56:39.516947Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1485249
2016-09-07T15:56:39.519390Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-09-07T15:56:39.519403Z 0 [Note] Shutting down plugin 'MEMORY'
2016-09-07T15:56:39.519419Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-09-07T15:56:39.519487Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-09-07T15:56:39.519493Z 0 [Note] Shutting down plugin 'sha256_password'
2016-09-07T15:56:39.519497Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-09-07T15:56:39.519632Z 0 [Note] Shutting down plugin 'binlog'
2016-09-07T15:56:39.519840Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2016-09-07T15:56:39.530388Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended