Jump to content

encom

Members
  • Posts

    11
  • Joined

  • Last visited

About encom

  • Rank
    Newbie
    Newbie

Profile Information

  • Location
    USA
  1. Hi, today i run OVA server at 6am. Not work. I check now and server works. 170327 07:20:58 mysqld_safe Logging to '/var/log/mysqld.log'. 170327 07:20:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-27 07:20:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-27 07:20:58 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 3044 ... 2017-03-27 07:20:58 3044 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-27 07:20:58 3044 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-27 07:20:58 3044 [Note] Plugin 'FEDERATED' is disabled. 2017-03-27 07:20:58 3044 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-27 07:20:58 3044 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-27 07:20:58 3044 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-27 07:20:58 3044 [Note] InnoDB: Memory barrier is not used 2017-03-27 07:20:58 3044 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-27 07:20:58 3044 [Note] InnoDB: Using Linux native AIO 2017-03-27 07:20:58 3044 [Note] InnoDB: Using CPU crc32 instructions 2017-03-27 07:20:58 3044 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-27 07:20:58 3044 [Note] InnoDB: Completed initialization of buffer pool 2017-03-27 07:20:58 3044 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-27 07:20:58 3044 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-27 07:20:58 3044 [Note] InnoDB: Waiting for purge to start 2017-03-27 07:20:58 3044 [Note] InnoDB: 5.6.35 started; log sequence number 1627505 2017-03-27 07:20:58 3044 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-27 07:20:58 3044 [Note] IPv6 is available. 2017-03-27 07:20:58 3044 [Note] - '::' resolves to '::'; 2017-03-27 07:20:58 3044 [Note] Server socket created on IP: '::'. 2017-03-27 07:20:58 3044 [Note] Event Scheduler: Loaded 0 events 2017-03-27 07:20:58 3044 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 170328 12:27:32 mysqld_safe Logging to '/var/log/mysqld.log'. 170328 12:27:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-28 12:27:33 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-28 12:27:33 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2459 ... 2017-03-28 12:27:34 2459 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-28 12:27:34 2459 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-28 12:27:34 2459 [Note] Plugin 'FEDERATED' is disabled. 2017-03-28 12:27:34 2459 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-28 12:27:34 2459 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-28 12:27:34 2459 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-28 12:27:34 2459 [Note] InnoDB: Memory barrier is not used 2017-03-28 12:27:34 2459 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-28 12:27:34 2459 [Note] InnoDB: Using Linux native AIO 2017-03-28 12:27:34 2459 [Note] InnoDB: Using CPU crc32 instructions 2017-03-28 12:27:34 2459 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-28 12:27:34 2459 [Note] InnoDB: Completed initialization of buffer pool 2017-03-28 12:27:34 2459 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-28 12:27:34 2459 [Note] InnoDB: The log sequence numbers 1627505 and 1627505 in ibdata files do not match the log sequence number 111711284 in the ib_logfiles! 2017-03-28 12:27:34 2459 [Note] InnoDB: Database was not shutdown normally! 2017-03-28 12:27:34 2459 [Note] InnoDB: Starting crash recovery. 2017-03-28 12:27:34 2459 [Note] InnoDB: Reading tablespace information from the .ibd files... 2017-03-28 12:27:35 2459 [Note] InnoDB: Restoring possible half-written data pages 2017-03-28 12:27:35 2459 [Note] InnoDB: from the doublewrite buffer... 2017-03-28 12:27:35 2459 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-28 12:27:35 2459 [Note] InnoDB: Waiting for purge to start 2017-03-28 12:27:35 2459 [Note] InnoDB: 5.6.35 started; log sequence number 111711284 2017-03-28 12:27:35 2459 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-28 12:27:35 2459 [Note] IPv6 is available. 2017-03-28 12:27:35 2459 [Note] - '::' resolves to '::'; 2017-03-28 12:27:35 2459 [Note] Server socket created on IP: '::'. 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_45` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_4f` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_66` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_3` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_2` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_e` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_33` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_56` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_138` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_141` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_13b` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_59` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_32` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_139` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:36 2459 [Note] Event Scheduler: Loaded 0 events 2017-03-28 12:27:36 2459 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-03-28 12:30:02 2459 [Note] /usr/sbin/mysqld: Normal shutdown 2017-03-28 12:30:02 2459 [Note] Giving 0 client threads a chance to die gracefully 2017-03-28 12:30:02 2459 [Note] Event Scheduler: Purging the queue. 0 events 2017-03-28 12:30:02 2459 [Note] Shutting down slave threads 2017-03-28 12:30:02 2459 [Note] Forcefully disconnecting 0 remaining clients 2017-03-28 12:30:02 2459 [Note] Binlog end 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'partition' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_METRICS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMP' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_TRX' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'InnoDB' 2017-03-28 12:30:02 2459 [Note] InnoDB: FTS optimize thread exiting. 2017-03-28 12:30:02 2459 [Note] InnoDB: Starting shutdown... 2017-03-28 12:30:04 2459 [Note] InnoDB: Shutdown completed; log sequence number 111723958 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'BLACKHOLE' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'ARCHIVE' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'MRG_MYISAM' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'MyISAM' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'MEMORY' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'CSV' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'sha256_password' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'mysql_old_password' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'mysql_native_password' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'binlog' 2017-03-28 12:30:04 2459 [Note] /usr/sbin/mysqld: Shutdown complete 170328 12:30:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 170328 12:56:20 mysqld_safe Logging to '/var/log/mysqld.log'. 170328 12:56:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-28 12:56:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-28 12:56:24 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2566 ... 2017-03-28 12:56:25 2566 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-28 12:56:25 2566 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-28 12:56:25 2566 [Note] Plugin 'FEDERATED' is disabled. 2017-03-28 12:56:25 2566 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-28 12:56:25 2566 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-28 12:56:25 2566 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-28 12:56:25 2566 [Note] InnoDB: Memory barrier is not used 2017-03-28 12:56:25 2566 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-28 12:56:25 2566 [Note] InnoDB: Using Linux native AIO 2017-03-28 12:56:25 2566 [Note] InnoDB: Using CPU crc32 instructions 2017-03-28 12:56:25 2566 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-28 12:56:29 2566 [Note] InnoDB: Completed initialization of buffer pool 2017-03-28 12:56:30 2566 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-28 12:56:33 2566 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-28 12:56:33 2566 [Note] InnoDB: Waiting for purge to start 2017-03-28 12:56:33 2566 [Note] InnoDB: 5.6.35 started; log sequence number 111723958 2017-03-28 12:56:34 2566 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-28 12:56:34 2566 [Note] IPv6 is available. 2017-03-28 12:56:34 2566 [Note] - '::' resolves to '::'; 2017-03-28 12:56:34 2566 [Note] Server socket created on IP: '::'. 2017-03-28 12:56:34 2566 [Note] Event Scheduler: Loaded 0 events 2017-03-28 12:56:34 2566 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-03-28 13:40:33 2566 [Note] /usr/sbin/mysqld: Normal shutdown 2017-03-28 13:40:33 2566 [Note] Giving 0 client threads a chance to die gracefully 2017-03-28 13:40:33 2566 [Note] Event Scheduler: Purging the queue. 0 events 2017-03-28 13:40:33 2566 [Note] Shutting down slave threads 2017-03-28 13:40:33 2566 [Note] Forcefully disconnecting 0 remaining clients 2017-03-28 13:40:33 2566 [Note] Binlog end 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'partition' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_METRICS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMP' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_TRX' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'InnoDB' 2017-03-28 13:40:33 2566 [Note] InnoDB: FTS optimize thread exiting. 2017-03-28 13:40:33 2566 [Note] InnoDB: Starting shutdown... 2017-03-28 13:40:35 2566 [Note] InnoDB: Shutdown completed; log sequence number 111723968 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'BLACKHOLE' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'ARCHIVE' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'MRG_MYISAM' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'MyISAM' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'MEMORY' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'CSV' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'sha256_password' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'mysql_old_password' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'mysql_native_password' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'binlog' 2017-03-28 13:40:35 2566 [Note] /usr/sbin/mysqld: Shutdown complete 170328 13:40:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 170329 05:36:28 mysqld_safe Logging to '/var/log/mysqld.log'. 170329 05:36:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-29 05:36:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-29 05:36:29 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2563 ... 2017-03-29 05:36:29 2563 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-29 05:36:29 2563 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-29 05:36:29 2563 [Note] Plugin 'FEDERATED' is disabled. 2017-03-29 05:36:30 2563 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-29 05:36:30 2563 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-29 05:36:30 2563 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-29 05:36:30 2563 [Note] InnoDB: Memory barrier is not used 2017-03-29 05:36:30 2563 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-29 05:36:30 2563 [Note] InnoDB: Using Linux native AIO 2017-03-29 05:36:30 2563 [Note] InnoDB: Using CPU crc32 instructions 2017-03-29 05:36:30 2563 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-29 05:36:31 2563 [Note] InnoDB: Completed initialization of buffer pool 2017-03-29 05:36:31 2563 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-29 05:36:32 2563 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-29 05:36:32 2563 [Note] InnoDB: Waiting for purge to start 2017-03-29 05:36:33 2563 [Note] InnoDB: 5.6.35 started; log sequence number 111723968 2017-03-29 05:36:33 2563 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-29 05:36:33 2563 [Note] IPv6 is available. 2017-03-29 05:36:33 2563 [Note] - '::' resolves to '::'; 2017-03-29 05:36:33 2563 [Note] Server socket created on IP: '::'. 2017-03-29 05:36:33 2563 [Note] Event Scheduler: Loaded 0 events 2017-03-29 05:36:33 2563 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 170329 09:30:43 mysqld_safe Logging to '/var/log/mysqld.log'. 170329 09:30:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-29 09:30:43 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-29 09:30:43 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 1306 ... 2017-03-29 09:30:43 1306 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-29 09:30:43 1306 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-29 09:30:43 1306 [Note] Plugin 'FEDERATED' is disabled. 2017-03-29 09:30:43 1306 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-29 09:30:43 1306 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-29 09:30:43 1306 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-29 09:30:43 1306 [Note] InnoDB: Memory barrier is not used 2017-03-29 09:30:43 1306 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-29 09:30:43 1306 [Note] InnoDB: Using Linux native AIO 2017-03-29 09:30:43 1306 [Note] InnoDB: Using CPU crc32 instructions 2017-03-29 09:30:43 1306 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-29 09:30:43 1306 [Note] InnoDB: Completed initialization of buffer pool 2017-03-29 09:30:43 1306 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-29 09:30:43 1306 [Note] InnoDB: The log sequence numbers 111723968 and 111723968 in ibdata files do not match the log sequence number 111723978 in the ib_logfiles! 2017-03-29 09:30:43 1306 [Note] InnoDB: Database was not shutdown normally! 2017-03-29 09:30:43 1306 [Note] InnoDB: Starting crash recovery. 2017-03-29 09:30:43 1306 [Note] InnoDB: Reading tablespace information from the .ibd files... 2017-03-29 09:30:44 1306 [Note] InnoDB: Restoring possible half-written data pages 2017-03-29 09:30:44 1306 [Note] InnoDB: from the doublewrite buffer... 2017-03-29 09:30:45 1306 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-29 09:30:45 1306 [Note] InnoDB: Waiting for purge to start 2017-03-29 09:30:45 1306 [Note] InnoDB: 5.6.35 started; log sequence number 111723978 2017-03-29 09:30:45 1306 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-29 09:30:45 1306 [Note] IPv6 is available. 2017-03-29 09:30:45 1306 [Note] - '::' resolves to '::'; 2017-03-29 09:30:45 1306 [Note] Server socket created on IP: '::'. 2017-03-29 09:30:45 1306 [Note] Event Scheduler: Loaded 0 events 2017-03-29 09:30:45 1306 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 170329 09:37:06 mysqld_safe Logging to '/var/log/mysqld.log'. 170329 09:37:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-29 09:37:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-29 09:37:08 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2466 ... 2017-03-29 09:37:09 2466 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-29 09:37:09 2466 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-29 09:37:09 2466 [Note] Plugin 'FEDERATED' is disabled. 2017-03-29 09:37:09 2466 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-29 09:37:09 2466 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-29 09:37:09 2466 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-29 09:37:09 2466 [Note] InnoDB: Memory barrier is not used 2017-03-29 09:37:09 2466 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-29 09:37:09 2466 [Note] InnoDB: Using Linux native AIO 2017-03-29 09:37:09 2466 [Note] InnoDB: Using CPU crc32 instructions 2017-03-29 09:37:09 2466 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-29 09:37:09 2466 [Note] InnoDB: Completed initialization of buffer pool 2017-03-29 09:37:10 2466 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-29 09:37:10 2466 [Note] InnoDB: The log sequence numbers 111723968 and 111723968 in ibdata files do not match the log sequence number 111723988 in the ib_logfiles! 2017-03-29 09:37:10 2466 [Note] InnoDB: Database was not shutdown normally! 2017-03-29 09:37:10 2466 [Note] InnoDB: Starting crash recovery. 2017-03-29 09:37:10 2466 [Note] InnoDB: Reading tablespace information from the .ibd files... 2017-03-29 09:37:11 2466 [Note] InnoDB: Restoring possible half-written data pages 2017-03-29 09:37:11 2466 [Note] InnoDB: from the doublewrite buffer... 2017-03-29 09:37:12 2466 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-29 09:37:12 2466 [Note] InnoDB: Waiting for purge to start 2017-03-29 09:37:12 2466 [Note] InnoDB: 5.6.35 started; log sequence number 111723988 2017-03-29 09:37:13 2466 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-29 09:37:13 2466 [Note] IPv6 is available. 2017-03-29 09:37:13 2466 [Note] - '::' resolves to '::'; 2017-03-29 09:37:13 2466 [Note] Server socket created on IP: '::'. 2017-03-29 09:37:13 2466 [Note] Event Scheduler: Loaded 0 events 2017-03-29 09:37:13 2466 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 170330 06:31:09 mysqld_safe Logging to '/var/log/mysqld.log'. 170330 06:31:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-30 06:31:10 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-30 06:31:10 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2573 ... 2017-03-30 06:31:10 2573 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-30 06:31:10 2573 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-30 06:31:10 2573 [Note] Plugin 'FEDERATED' is disabled. 2017-03-30 06:31:10 2573 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-30 06:31:10 2573 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-30 06:31:10 2573 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-30 06:31:10 2573 [Note] InnoDB: Memory barrier is not used 2017-03-30 06:31:10 2573 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-30 06:31:10 2573 [Note] InnoDB: Using Linux native AIO 2017-03-30 06:31:10 2573 [Note] InnoDB: Using CPU crc32 instructions 2017-03-30 06:31:10 2573 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-30 06:31:11 2573 [Note] InnoDB: Completed initialization of buffer pool 2017-03-30 06:31:12 2573 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-30 06:31:12 2573 [Note] InnoDB: The log sequence numbers 111723968 and 111723968 in ibdata files do not match the log sequence number 116085649 in the ib_logfiles! 2017-03-30 06:31:12 2573 [Note] InnoDB: Database was not shutdown normally! 2017-03-30 06:31:12 2573 [Note] InnoDB: Starting crash recovery. 2017-03-30 06:31:12 2573 [Note] InnoDB: Reading tablespace information from the .ibd files... 2017-03-30 06:31:17 2573 [Note] InnoDB: Restoring possible half-written data pages 2017-03-30 06:31:17 2573 [Note] InnoDB: from the doublewrite buffer... 2017-03-30 06:31:19 2573 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-30 06:31:19 2573 [Note] InnoDB: Waiting for purge to start 2017-03-30 06:31:19 2573 [Note] InnoDB: 5.6.35 started; log sequence number 116085649 2017-03-30 06:31:19 2573 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-30 06:31:19 2573 [Note] IPv6 is available. 2017-03-30 06:31:19 2573 [Note] - '::' resolves to '::'; 2017-03-30 06:31:19 2573 [Note] Server socket created on IP: '::'. 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_8_8b` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_7_e7` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_8_98` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_6_2` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_8_5` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_7_e1` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_7_e2` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_7_e4` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_7_3c` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_8_bb` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_8_97` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 2573 [Note] Event Scheduler: Loaded 0 events 2017-03-30 06:31:19 2573 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 170403 09:14:36 mysqld_safe Logging to '/var/log/mysqld.log'. 170403 09:14:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-04-03 07:14:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-04-03 07:14:40 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 4064 ... 2017-04-03 07:14:40 4064 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-04-03 07:14:40 4064 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-04-03 07:14:40 4064 [Note] Plugin 'FEDERATED' is disabled. 2017-04-03 07:14:40 4064 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-04-03 07:14:40 4064 [Note] InnoDB: The InnoDB memory heap is disabled 2017-04-03 07:14:40 4064 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-04-03 07:14:40 4064 [Note] InnoDB: Memory barrier is not used 2017-04-03 07:14:40 4064 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-04-03 07:14:40 4064 [Note] InnoDB: Using Linux native AIO 2017-04-03 07:14:40 4064 [Note] InnoDB: Using CPU crc32 instructions 2017-04-03 07:14:40 4064 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-04-03 07:14:40 4064 [Note] InnoDB: Completed initialization of buffer pool 2017-04-03 07:14:41 4064 [Note] InnoDB: Highest supported file format is Barracuda. 2017-04-03 07:14:41 4064 [Note] InnoDB: The log sequence numbers 111723968 and 111723968 in ibdata files do not match the log sequence number 163110611 in the ib_logfiles! 2017-04-03 07:14:41 4064 [Note] InnoDB: Database was not shutdown normally! 2017-04-03 07:14:41 4064 [Note] InnoDB: Starting crash recovery. 2017-04-03 07:14:41 4064 [Note] InnoDB: Reading tablespace information from the .ibd files... 2017-04-03 07:14:45 4064 [Note] InnoDB: Restoring possible half-written data pages 2017-04-03 07:14:45 4064 [Note] InnoDB: from the doublewrite buffer... 2017-04-03 07:14:46 4064 [Note] InnoDB: 128 rollback segment(s) are active. 2017-04-03 07:14:46 4064 [Note] InnoDB: Waiting for purge to start 2017-04-03 07:14:46 4064 [Note] InnoDB: 5.6.35 started; log sequence number 163110611 2017-04-03 07:14:46 4064 [Note] Server hostname (bind-address): '*'; port: 3306 2017-04-03 07:14:46 4064 [Note] IPv6 is available. 2017-04-03 07:14:46 4064 [Note] - '::' resolves to '::'; 2017-04-03 07:14:46 4064 [Note] Server socket created on IP: '::'. 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_b_4cb` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_b_4da` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_a_79f` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_a_900` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_a_909` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_5_ded` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_5_df0` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_7_d4` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_b_37f` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_7_d5` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_5_2` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_5_df2` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_7_fc` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_5_df1` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_a_90b` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 4064 [ERROR] /usr/sbin/mysqld: Incorrect information in file: '/tmp/#sqla0d_7_100.frm' 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_a_90a` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_b_4a4` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:46 7fe748d38740 InnoDB: Error: table `tmp`.`#sqla0d_b_4a5` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-04-03 07:14:47 4064 [Note] Event Scheduler: Loaded 0 events 2017-04-03 07:14:47 4064 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
  2. 170327 07:20:58 mysqld_safe Logging to '/var/log/mysqld.log'. 170327 07:20:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-27 07:20:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-27 07:20:58 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 3044 ... 2017-03-27 07:20:58 3044 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-27 07:20:58 3044 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-27 07:20:58 3044 [Note] Plugin 'FEDERATED' is disabled. 2017-03-27 07:20:58 3044 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-27 07:20:58 3044 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-27 07:20:58 3044 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-27 07:20:58 3044 [Note] InnoDB: Memory barrier is not used 2017-03-27 07:20:58 3044 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-27 07:20:58 3044 [Note] InnoDB: Using Linux native AIO 2017-03-27 07:20:58 3044 [Note] InnoDB: Using CPU crc32 instructions 2017-03-27 07:20:58 3044 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-27 07:20:58 3044 [Note] InnoDB: Completed initialization of buffer pool 2017-03-27 07:20:58 3044 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-27 07:20:58 3044 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-27 07:20:58 3044 [Note] InnoDB: Waiting for purge to start 2017-03-27 07:20:58 3044 [Note] InnoDB: 5.6.35 started; log sequence number 1627505 2017-03-27 07:20:58 3044 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-27 07:20:58 3044 [Note] IPv6 is available. 2017-03-27 07:20:58 3044 [Note] - '::' resolves to '::'; 2017-03-27 07:20:58 3044 [Note] Server socket created on IP: '::'. 2017-03-27 07:20:58 3044 [Note] Event Scheduler: Loaded 0 events 2017-03-27 07:20:58 3044 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 170328 12:27:32 mysqld_safe Logging to '/var/log/mysqld.log'. 170328 12:27:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-28 12:27:33 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-28 12:27:33 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2459 ... 2017-03-28 12:27:34 2459 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-28 12:27:34 2459 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-28 12:27:34 2459 [Note] Plugin 'FEDERATED' is disabled. 2017-03-28 12:27:34 2459 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-28 12:27:34 2459 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-28 12:27:34 2459 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-28 12:27:34 2459 [Note] InnoDB: Memory barrier is not used 2017-03-28 12:27:34 2459 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-28 12:27:34 2459 [Note] InnoDB: Using Linux native AIO 2017-03-28 12:27:34 2459 [Note] InnoDB: Using CPU crc32 instructions 2017-03-28 12:27:34 2459 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-28 12:27:34 2459 [Note] InnoDB: Completed initialization of buffer pool 2017-03-28 12:27:34 2459 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-28 12:27:34 2459 [Note] InnoDB: The log sequence numbers 1627505 and 1627505 in ibdata files do not match the log sequence number 111711284 in the ib_logfiles! 2017-03-28 12:27:34 2459 [Note] InnoDB: Database was not shutdown normally! 2017-03-28 12:27:34 2459 [Note] InnoDB: Starting crash recovery. 2017-03-28 12:27:34 2459 [Note] InnoDB: Reading tablespace information from the .ibd files... 2017-03-28 12:27:35 2459 [Note] InnoDB: Restoring possible half-written data pages 2017-03-28 12:27:35 2459 [Note] InnoDB: from the doublewrite buffer... 2017-03-28 12:27:35 2459 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-28 12:27:35 2459 [Note] InnoDB: Waiting for purge to start 2017-03-28 12:27:35 2459 [Note] InnoDB: 5.6.35 started; log sequence number 111711284 2017-03-28 12:27:35 2459 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-28 12:27:35 2459 [Note] IPv6 is available. 2017-03-28 12:27:35 2459 [Note] - '::' resolves to '::'; 2017-03-28 12:27:35 2459 [Note] Server socket created on IP: '::'. 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_45` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_4f` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_66` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_3` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_2` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_e` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_33` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_56` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_138` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_141` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_13b` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_59` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_16_32` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:35 7fa30ee11740 InnoDB: Error: table `tmp`.`#sqlbe4_18_139` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-28 12:27:36 2459 [Note] Event Scheduler: Loaded 0 events 2017-03-28 12:27:36 2459 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-03-28 12:30:02 2459 [Note] /usr/sbin/mysqld: Normal shutdown 2017-03-28 12:30:02 2459 [Note] Giving 0 client threads a chance to die gracefully 2017-03-28 12:30:02 2459 [Note] Event Scheduler: Purging the queue. 0 events 2017-03-28 12:30:02 2459 [Note] Shutting down slave threads 2017-03-28 12:30:02 2459 [Note] Forcefully disconnecting 0 remaining clients 2017-03-28 12:30:02 2459 [Note] Binlog end 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'partition' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_METRICS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_CMP' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'INNODB_TRX' 2017-03-28 12:30:02 2459 [Note] Shutting down plugin 'InnoDB' 2017-03-28 12:30:02 2459 [Note] InnoDB: FTS optimize thread exiting. 2017-03-28 12:30:02 2459 [Note] InnoDB: Starting shutdown... 2017-03-28 12:30:04 2459 [Note] InnoDB: Shutdown completed; log sequence number 111723958 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'BLACKHOLE' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'ARCHIVE' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'MRG_MYISAM' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'MyISAM' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'MEMORY' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'CSV' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'sha256_password' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'mysql_old_password' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'mysql_native_password' 2017-03-28 12:30:04 2459 [Note] Shutting down plugin 'binlog' 2017-03-28 12:30:04 2459 [Note] /usr/sbin/mysqld: Shutdown complete 170328 12:30:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 170328 12:56:20 mysqld_safe Logging to '/var/log/mysqld.log'. 170328 12:56:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-28 12:56:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-28 12:56:24 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2566 ... 2017-03-28 12:56:25 2566 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-28 12:56:25 2566 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-28 12:56:25 2566 [Note] Plugin 'FEDERATED' is disabled. 2017-03-28 12:56:25 2566 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-28 12:56:25 2566 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-28 12:56:25 2566 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-28 12:56:25 2566 [Note] InnoDB: Memory barrier is not used 2017-03-28 12:56:25 2566 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-28 12:56:25 2566 [Note] InnoDB: Using Linux native AIO 2017-03-28 12:56:25 2566 [Note] InnoDB: Using CPU crc32 instructions 2017-03-28 12:56:25 2566 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-28 12:56:29 2566 [Note] InnoDB: Completed initialization of buffer pool 2017-03-28 12:56:30 2566 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-28 12:56:33 2566 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-28 12:56:33 2566 [Note] InnoDB: Waiting for purge to start 2017-03-28 12:56:33 2566 [Note] InnoDB: 5.6.35 started; log sequence number 111723958 2017-03-28 12:56:34 2566 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-28 12:56:34 2566 [Note] IPv6 is available. 2017-03-28 12:56:34 2566 [Note] - '::' resolves to '::'; 2017-03-28 12:56:34 2566 [Note] Server socket created on IP: '::'. 2017-03-28 12:56:34 2566 [Note] Event Scheduler: Loaded 0 events 2017-03-28 12:56:34 2566 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-03-28 13:40:33 2566 [Note] /usr/sbin/mysqld: Normal shutdown 2017-03-28 13:40:33 2566 [Note] Giving 0 client threads a chance to die gracefully 2017-03-28 13:40:33 2566 [Note] Event Scheduler: Purging the queue. 0 events 2017-03-28 13:40:33 2566 [Note] Shutting down slave threads 2017-03-28 13:40:33 2566 [Note] Forcefully disconnecting 0 remaining clients 2017-03-28 13:40:33 2566 [Note] Binlog end 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'partition' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_METRICS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_CMP' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'INNODB_TRX' 2017-03-28 13:40:33 2566 [Note] Shutting down plugin 'InnoDB' 2017-03-28 13:40:33 2566 [Note] InnoDB: FTS optimize thread exiting. 2017-03-28 13:40:33 2566 [Note] InnoDB: Starting shutdown... 2017-03-28 13:40:35 2566 [Note] InnoDB: Shutdown completed; log sequence number 111723968 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'BLACKHOLE' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'ARCHIVE' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'MRG_MYISAM' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'MyISAM' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'MEMORY' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'CSV' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'sha256_password' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'mysql_old_password' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'mysql_native_password' 2017-03-28 13:40:35 2566 [Note] Shutting down plugin 'binlog' 2017-03-28 13:40:35 2566 [Note] /usr/sbin/mysqld: Shutdown complete 170328 13:40:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 170329 05:36:28 mysqld_safe Logging to '/var/log/mysqld.log'. 170329 05:36:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-29 05:36:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-29 05:36:29 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2563 ... 2017-03-29 05:36:29 2563 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-29 05:36:29 2563 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-29 05:36:29 2563 [Note] Plugin 'FEDERATED' is disabled. 2017-03-29 05:36:30 2563 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-29 05:36:30 2563 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-29 05:36:30 2563 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-29 05:36:30 2563 [Note] InnoDB: Memory barrier is not used 2017-03-29 05:36:30 2563 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-29 05:36:30 2563 [Note] InnoDB: Using Linux native AIO 2017-03-29 05:36:30 2563 [Note] InnoDB: Using CPU crc32 instructions 2017-03-29 05:36:30 2563 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-29 05:36:31 2563 [Note] InnoDB: Completed initialization of buffer pool 2017-03-29 05:36:31 2563 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-29 05:36:32 2563 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-29 05:36:32 2563 [Note] InnoDB: Waiting for purge to start 2017-03-29 05:36:33 2563 [Note] InnoDB: 5.6.35 started; log sequence number 111723968 2017-03-29 05:36:33 2563 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-29 05:36:33 2563 [Note] IPv6 is available. 2017-03-29 05:36:33 2563 [Note] - '::' resolves to '::'; 2017-03-29 05:36:33 2563 [Note] Server socket created on IP: '::'. 2017-03-29 05:36:33 2563 [Note] Event Scheduler: Loaded 0 events 2017-03-29 05:36:33 2563 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 170329 09:30:43 mysqld_safe Logging to '/var/log/mysqld.log'. 170329 09:30:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-29 09:30:43 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-29 09:30:43 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 1306 ... 2017-03-29 09:30:43 1306 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-29 09:30:43 1306 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-29 09:30:43 1306 [Note] Plugin 'FEDERATED' is disabled. 2017-03-29 09:30:43 1306 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-29 09:30:43 1306 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-29 09:30:43 1306 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-29 09:30:43 1306 [Note] InnoDB: Memory barrier is not used 2017-03-29 09:30:43 1306 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-29 09:30:43 1306 [Note] InnoDB: Using Linux native AIO 2017-03-29 09:30:43 1306 [Note] InnoDB: Using CPU crc32 instructions 2017-03-29 09:30:43 1306 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-29 09:30:43 1306 [Note] InnoDB: Completed initialization of buffer pool 2017-03-29 09:30:43 1306 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-29 09:30:43 1306 [Note] InnoDB: The log sequence numbers 111723968 and 111723968 in ibdata files do not match the log sequence number 111723978 in the ib_logfiles! 2017-03-29 09:30:43 1306 [Note] InnoDB: Database was not shutdown normally! 2017-03-29 09:30:43 1306 [Note] InnoDB: Starting crash recovery. 2017-03-29 09:30:43 1306 [Note] InnoDB: Reading tablespace information from the .ibd files... 2017-03-29 09:30:44 1306 [Note] InnoDB: Restoring possible half-written data pages 2017-03-29 09:30:44 1306 [Note] InnoDB: from the doublewrite buffer... 2017-03-29 09:30:45 1306 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-29 09:30:45 1306 [Note] InnoDB: Waiting for purge to start 2017-03-29 09:30:45 1306 [Note] InnoDB: 5.6.35 started; log sequence number 111723978 2017-03-29 09:30:45 1306 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-29 09:30:45 1306 [Note] IPv6 is available. 2017-03-29 09:30:45 1306 [Note] - '::' resolves to '::'; 2017-03-29 09:30:45 1306 [Note] Server socket created on IP: '::'. 2017-03-29 09:30:45 1306 [Note] Event Scheduler: Loaded 0 events 2017-03-29 09:30:45 1306 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 170329 09:37:06 mysqld_safe Logging to '/var/log/mysqld.log'. 170329 09:37:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-29 09:37:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-29 09:37:08 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2466 ... 2017-03-29 09:37:09 2466 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-29 09:37:09 2466 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-29 09:37:09 2466 [Note] Plugin 'FEDERATED' is disabled. 2017-03-29 09:37:09 2466 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-29 09:37:09 2466 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-29 09:37:09 2466 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-29 09:37:09 2466 [Note] InnoDB: Memory barrier is not used 2017-03-29 09:37:09 2466 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-29 09:37:09 2466 [Note] InnoDB: Using Linux native AIO 2017-03-29 09:37:09 2466 [Note] InnoDB: Using CPU crc32 instructions 2017-03-29 09:37:09 2466 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-29 09:37:09 2466 [Note] InnoDB: Completed initialization of buffer pool 2017-03-29 09:37:10 2466 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-29 09:37:10 2466 [Note] InnoDB: The log sequence numbers 111723968 and 111723968 in ibdata files do not match the log sequence number 111723988 in the ib_logfiles! 2017-03-29 09:37:10 2466 [Note] InnoDB: Database was not shutdown normally! 2017-03-29 09:37:10 2466 [Note] InnoDB: Starting crash recovery. 2017-03-29 09:37:10 2466 [Note] InnoDB: Reading tablespace information from the .ibd files... 2017-03-29 09:37:11 2466 [Note] InnoDB: Restoring possible half-written data pages 2017-03-29 09:37:11 2466 [Note] InnoDB: from the doublewrite buffer... 2017-03-29 09:37:12 2466 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-29 09:37:12 2466 [Note] InnoDB: Waiting for purge to start 2017-03-29 09:37:12 2466 [Note] InnoDB: 5.6.35 started; log sequence number 111723988 2017-03-29 09:37:13 2466 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-29 09:37:13 2466 [Note] IPv6 is available. 2017-03-29 09:37:13 2466 [Note] - '::' resolves to '::'; 2017-03-29 09:37:13 2466 [Note] Server socket created on IP: '::'. 2017-03-29 09:37:13 2466 [Note] Event Scheduler: Loaded 0 events 2017-03-29 09:37:13 2466 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 170330 06:31:09 mysqld_safe Logging to '/var/log/mysqld.log'. 170330 06:31:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-30 06:31:10 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-30 06:31:10 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2573 ... 2017-03-30 06:31:10 2573 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-30 06:31:10 2573 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-30 06:31:10 2573 [Note] Plugin 'FEDERATED' is disabled. 2017-03-30 06:31:10 2573 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-30 06:31:10 2573 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-30 06:31:10 2573 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-30 06:31:10 2573 [Note] InnoDB: Memory barrier is not used 2017-03-30 06:31:10 2573 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-30 06:31:10 2573 [Note] InnoDB: Using Linux native AIO 2017-03-30 06:31:10 2573 [Note] InnoDB: Using CPU crc32 instructions 2017-03-30 06:31:10 2573 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-30 06:31:11 2573 [Note] InnoDB: Completed initialization of buffer pool 2017-03-30 06:31:12 2573 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-30 06:31:12 2573 [Note] InnoDB: The log sequence numbers 111723968 and 111723968 in ibdata files do not match the log sequence number 116085649 in the ib_logfiles! 2017-03-30 06:31:12 2573 [Note] InnoDB: Database was not shutdown normally! 2017-03-30 06:31:12 2573 [Note] InnoDB: Starting crash recovery. 2017-03-30 06:31:12 2573 [Note] InnoDB: Reading tablespace information from the .ibd files... 2017-03-30 06:31:17 2573 [Note] InnoDB: Restoring possible half-written data pages 2017-03-30 06:31:17 2573 [Note] InnoDB: from the doublewrite buffer... 2017-03-30 06:31:19 2573 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-30 06:31:19 2573 [Note] InnoDB: Waiting for purge to start 2017-03-30 06:31:19 2573 [Note] InnoDB: 5.6.35 started; log sequence number 116085649 2017-03-30 06:31:19 2573 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-30 06:31:19 2573 [Note] IPv6 is available. 2017-03-30 06:31:19 2573 [Note] - '::' resolves to '::'; 2017-03-30 06:31:19 2573 [Note] Server socket created on IP: '::'. 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_8_8b` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_7_e7` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_8_98` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_6_2` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_8_5` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_7_e1` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_7_e2` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_7_e4` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_7_3c` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_8_bb` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 7fc6e268b740 InnoDB: Error: table `tmp`.`#sql9a2_8_97` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: hxxp://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2017-03-30 06:31:19 2573 [Note] Event Scheduler: Loaded 0 events 2017-03-30 06:31:19 2573 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) /var/log/mysqld.log Any help?
  3. THX How allow to ping DNS name era server? Server is join to Windows Server domain.
  4. When it's works i have problem with agent on client machine. Agent don't see server. Not recognize DNS name. When i deploy agent i put ip and he change to dns name. WTF Where it's option to change this? Now i use ERA 5 and all works fine. Deploy and all conections. Its any option to connect ESET EV ENDPOINT 6.5 to ERA 5? Last replication 2017-Mar-29 07:56:44 Error: CReplicationManager: Replication (network) connection to 'host: "era.domain.local" port: 2222' failed with: Unable to resolve any endpoints.resolve: (0x2af9), Unknow host
  5. ... 2017-03-29 09:36:58 Information: Kernel [Thread 7f8c19108740]: Initializing module CDatabaseModule 2017-03-29 09:36:59 Information: CDatabaseModule [Thread 7f8c19108740]: Startup configuration builder builds successfully ... 2017-03-29 09:37:00 Error: CDatabaseModule [Thread 7f8c19108740]: Probing database connection failed. Next connection attempt will be in 10 seconds. 11 more attempts will be made. The database access layer reported: [unixODBC][MySQL][ODBC 5.3(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111) (2003) Problem it's mysql. ESET you checked it out before release? Pls check you ova images. trace_log.txt
  6. I thought everything was working on new VM. But after a few reboots i have Login failed: Connection has failed with state 'Not connected'
  7. Hi, I have problem with Static Group Synchronization. I put all credentials. And when I check connection in "SYNCHRONIZATION SETTINGS" DISTINGUISHED NAME i get error Error loading data: Active directory browsing failed. Check input server parameters and AD availability.: Trace info: SearchLdap: 'kinit' failed with 1, stdout: stderr: kinit: Cannot contact any KDC for realm 'ERA.LOCAL' while getting initial credentials All pings IP, DNS names works ok. Server is ova on virtualbox. Server join to windows server domain. PS. I wonder why error comunicate show realm 'ERA.LOCAL' should be ERA.domain?
  8. 170316 12:32:42 mysqld_safe Logging to '/var/log/mysqld.log'. 170316 12:32:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-16 12:32:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-16 12:32:42 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 3049 ... 2017-03-16 12:32:42 3049 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-16 12:32:42 3049 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-16 12:32:42 3049 [Note] Plugin 'FEDERATED' is disabled. 2017-03-16 12:32:42 3049 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-16 12:32:42 3049 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-16 12:32:42 3049 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-16 12:32:42 3049 [Note] InnoDB: Memory barrier is not used 2017-03-16 12:32:42 3049 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-16 12:32:42 3049 [Note] InnoDB: Using Linux native AIO 2017-03-16 12:32:42 3049 [Note] InnoDB: Using CPU crc32 instructions 2017-03-16 12:32:42 3049 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-16 12:32:42 3049 [Note] InnoDB: Completed initialization of buffer pool 2017-03-16 12:32:42 3049 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-16 12:32:42 3049 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-16 12:32:42 3049 [Note] InnoDB: Waiting for purge to start 2017-03-16 12:32:42 3049 [Note] InnoDB: 5.6.35 started; log sequence number 1627505 2017-03-16 12:32:42 3049 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-16 12:32:42 3049 [Note] IPv6 is available. 2017-03-16 12:32:42 3049 [Note] - '::' resolves to '::'; 2017-03-16 12:32:42 3049 [Note] Server socket created on IP: '::'. 2017-03-16 12:32:42 3049 [Note] Event Scheduler: Loaded 0 events 2017-03-16 12:32:42 3049 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-03-16 12:38:57 3049 [Note] /usr/sbin/mysqld: Normal shutdown 2017-03-16 12:38:57 3049 [Note] Giving 8 client threads a chance to die gracefully 2017-03-16 12:38:57 3049 [Note] Event Scheduler: Purging the queue. 0 events 2017-03-16 12:38:57 3049 [Note] Shutting down slave threads 2017-03-16 12:38:59 3049 [Note] Forcefully disconnecting 8 remaining clients 2017-03-16 12:38:59 3049 [Warning] /usr/sbin/mysqld: Forcing close of thread 22 user: 'era' 2017-03-16 12:38:59 3049 [Warning] /usr/sbin/mysqld: Forcing close of thread 23 user: 'era' 2017-03-16 12:38:59 3049 [Warning] /usr/sbin/mysqld: Forcing close of thread 24 user: 'era' 2017-03-16 12:38:59 3049 [Warning] /usr/sbin/mysqld: Forcing close of thread 25 user: 'era' 2017-03-16 12:38:59 3049 [Warning] /usr/sbin/mysqld: Forcing close of thread 26 user: 'era' 2017-03-16 12:38:59 3049 [Warning] /usr/sbin/mysqld: Forcing close of thread 27 user: 'era' 2017-03-16 12:38:59 3049 [Warning] /usr/sbin/mysqld: Forcing close of thread 28 user: 'era' 2017-03-16 12:38:59 3049 [Warning] /usr/sbin/mysqld: Forcing close of thread 29 user: 'era' 2017-03-16 12:38:59 3049 [Note] Binlog end 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'partition' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_METRICS' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_CMP' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'INNODB_TRX' 2017-03-16 12:38:59 3049 [Note] Shutting down plugin 'InnoDB' 2017-03-16 12:38:59 3049 [Note] InnoDB: FTS optimize thread exiting. 2017-03-16 12:38:59 3049 [Note] InnoDB: Starting shutdown... 2017-03-16 12:39:01 3049 [Note] InnoDB: Shutdown completed; log sequence number 35643324 2017-03-16 12:39:01 3049 [Note] Shutting down plugin 'BLACKHOLE' 2017-03-16 12:39:01 3049 [Note] Shutting down plugin 'ARCHIVE' 2017-03-16 12:39:01 3049 [Note] Shutting down plugin 'MRG_MYISAM' 2017-03-16 12:39:01 3049 [Note] Shutting down plugin 'MyISAM' 2017-03-16 12:39:01 3049 [Note] Shutting down plugin 'MEMORY' 2017-03-16 12:39:01 3049 [Note] Shutting down plugin 'CSV' 2017-03-16 12:39:01 3049 [Note] Shutting down plugin 'sha256_password' 2017-03-16 12:39:01 3049 [Note] Shutting down plugin 'mysql_old_password' 2017-03-16 12:39:01 3049 [Note] Shutting down plugin 'mysql_native_password' 2017-03-16 12:39:01 3049 [Note] Shutting down plugin 'binlog' 2017-03-16 12:39:01 3049 [Note] /usr/sbin/mysqld: Shutdown complete 170316 12:39:01 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 170316 12:42:03 mysqld_safe Logging to '/var/log/mysqld.log'. 170316 12:42:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2017-03-16 12:42:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-03-16 12:42:04 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 2542 ... 2017-03-16 12:42:04 2542 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2017-03-16 12:42:04 2542 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2017-03-16 12:42:04 2542 [Note] Plugin 'FEDERATED' is disabled. 2017-03-16 12:42:04 2542 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-03-16 12:42:04 2542 [Note] InnoDB: The InnoDB memory heap is disabled 2017-03-16 12:42:04 2542 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-03-16 12:42:04 2542 [Note] InnoDB: Memory barrier is not used 2017-03-16 12:42:04 2542 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-03-16 12:42:04 2542 [Note] InnoDB: Using Linux native AIO 2017-03-16 12:42:04 2542 [Note] InnoDB: Using CPU crc32 instructions 2017-03-16 12:42:04 2542 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2017-03-16 12:42:07 2542 [Note] InnoDB: Completed initialization of buffer pool 2017-03-16 12:42:08 2542 [Note] InnoDB: Highest supported file format is Barracuda. 2017-03-16 12:42:10 2542 [Note] InnoDB: 128 rollback segment(s) are active. 2017-03-16 12:42:10 2542 [Note] InnoDB: Waiting for purge to start 2017-03-16 12:42:10 2542 [Note] InnoDB: 5.6.35 started; log sequence number 35643324 2017-03-16 12:42:10 2542 [Note] Server hostname (bind-address): '*'; port: 3306 2017-03-16 12:42:10 2542 [Note] IPv6 is available. 2017-03-16 12:42:10 2542 [Note] - '::' resolves to '::'; 2017-03-16 12:42:10 2542 [Note] Server socket created on IP: '::'. 2017-03-16 12:42:11 2542 [Note] Event Scheduler: Loaded 0 events 2017-03-16 12:42:11 2542 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.35' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) VM run on VirtualBox 5.1.18 r114002 (Qt5.6.2)
  9. No it's not work. I have new error: Login failed: Communication error But in webmin i can log in to MySQL.
  10. Hi, I download new version era_appliance.ova for VirtualBox and everything works fine for the first time. After restart/shutdown server I have a problem with logging to the console era. I get this error: Login failed: Connection has failed with state 'Not connected' I can log in to the server (putty / webmin). I only add server to domain and update webmin to newest version. I do 4 new instance. Always get this problem after restart server. ... 2017-03-16 12:41:52 Error: CDatabaseModule [Thread 7f31c4b8e740]: Probing database connection failed. Next connection attempt will be in 10 seconds. 11 more attempts will be made. The database access layer reported: [unixODBC][MySQL][ODBC 5.3(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111) (2003) ● mysqld.service - MySQL Community Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since Thu 2017-03-16 12:42:11 CET; 1h 11min ago Process: 2270 ExecStartPost=/usr/bin/mysql-systemd-start post (code=exited, status=0/SUCCESS) Process: 654 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 2269 (mysqld_safe) CGroup: /system.slice/mysqld.service ├─2269 /bin/sh /usr/bin/mysqld_safe --basedir=/usr └─2542 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock Mar 16 13:41:43 era.loc.com systemd[1]: Starting MySQL Community Server... Mar 16 12:42:03 era.loc.com mysqld_safe[2269]: 170316 12:42:03 mysqld_safe Logging to '/var/log/mysqld.log'. Mar 16 12:42:03 era.loc.com mysqld_safe[2269]: 170316 12:42:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Mar 16 12:42:11 era.loc.com systemd[1]: Started MySQL Community Server. trace_log.txt
×
×
  • Create New...