ERA 6.5 Virtual Appliances not work after restert.

encom · March 16, 2017

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

Edited March 30, 2017 by Marcos
Log moved to a file

MartinK · March 16, 2017

It may take some time until MySQL database is fully operational, even if it's service (daemon) is started. Therefore ERA check for connection for some time - and in your log, only first attempt to connect to database is traced. This is considered as normal behavior.

Does it work now, or connection to database was not possible even after minutes?

encom · March 16, 2017

No it's not work. I have new error:

Login failed: Communication error

But in webmin i can log in to MySQL.

MartinK · March 16, 2017

Please check /var/log/mysqld.log for suspicious entries - especially whether MySQL server is listening on IPv4 TCP port 3306. I would also expect connection attempts of user "era" to be logged.

encom · March 17, 2017

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)

Edited March 17, 2017 by encom

encom · March 29, 2017

I thought everything was working on new VM. But after a few reboots i have Login failed: Connection has failed with state 'Not connected'

encom · March 30, 2017

...
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

Edited March 30, 2017 by Marcos
Log moved to a file

encom · March 30, 2017

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

encom · March 31, 2017

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?

encom · April 3, 2017

Zero support form ESET thx.

tmuster2k · April 3, 2017

ENDPOINT V6 client cannot connect to ERA 5. I would recommend reverting back to your snapshot before the 6.5 Component Upgrade. Before doing upgrade after reverting to snapshot then create a new native admin account with no special characters in password. Log into with this temp account and run components upgrade. Make sure you set TARGET to ALL and let it run overnight.

encom · April 3, 2017

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)

MichalJ · April 3, 2017

@encom This is not an official ESET support site. This is a community forum, where other ESET users, or some ESET employees, including support people are trying to help answering problems / questions. If you have any issue with our software, you should contact your local representative of ESET (partner, that have sold you the license). From there, it should be handled as a ticket, eventually it would come to our support, and will be resolved.

Without additional data, it might be difficult for us, to answer just by seeing the log file. It might be a problem with the corrupted DB, corrupted DB disk storage (by power outage...), or even when the DB was restored from the backup, by just copying the files. We do not know, there are more questions to be asked. But in case of serious issues, I encourage you to contact your local ESET reseller, or nationwide distributor.

Sign In

ERA 6.5 Virtual Appliances not work after restert.

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Recently Browsing 0 members

Quick search

FAQ

Topics