Страница 1 из 1

Не стартует MySQL

Добавлено: 31 янв 2016, 21:46
trissys
вырубили свет и после этого вот что в логах-
2016-01-21 14:34:01 2172 [Note] Plugin 'FEDERATED' is disabled.
2016-01-21 14:34:01 2172 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-21 14:34:01 2172 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-21 14:34:01 2172 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-21 14:34:01 2172 [Note] InnoDB: Memory barrier is not used
2016-01-21 14:34:01 2172 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-21 14:34:01 2172 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-21 14:34:01 2172 [Note] InnoDB: Initializing buffer pool, size = 20.0M
2016-01-21 14:34:01 2172 [Note] InnoDB: Completed initialization of buffer pool
2016-01-21 14:34:01 2172 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-21 14:34:01 2172 [Note] InnoDB: The log sequence numbers 36388115 and 36388115 in ibdata files do not match the log sequence number 36418748 in the ib_logfiles!
2016-01-21 14:34:01 2172 [Note] InnoDB: Database was not shutdown normally!
2016-01-21 14:34:01 2172 [Note] InnoDB: Starting crash recovery.
2016-01-21 14:34:01 2172 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-21 14:34:05 2172 [Note] InnoDB: Restoring possible half-written data pages 
2016-01-21 14:34:05 2172 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 26476, file name mysql-bin.000113
2016-01-21 14:34:09 2172 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-21 14:34:09 2172 [Note] InnoDB: Waiting for purge to start
2016-01-21 14:34:09 2172 [Note] InnoDB: 5.6.22 started; log sequence number 36418748
2016-01-21 14:34:09 2172 [Note] Recovering after a crash using mysql-bin
2016-01-21 14:34:09 2172 [Note] Starting crash recovery...
2016-01-21 14:34:09 2172 [Note] Crash recovery finished.
2016-01-21 14:34:10 2172 [Note] Server hostname (bind-address): '192.168.1.77'; port: 3306
2016-01-21 14:34:10 2172 [Note]   - '192.168.1.77' resolves to '192.168.1.77';
2016-01-21 14:34:10 2172 [Note] Server socket created on IP: '192.168.1.77'.
2016-01-21 14:34:11 2172 [Note] Event Scheduler: Loaded 0 events
2016-01-21 14:34:11 2172 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.22-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-01-21 14:56:10 2172 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Normal shutdown

2016-01-21 14:56:10 2172 [Note] Giving 0 client threads a chance to die gracefully
2016-01-21 14:56:10 2172 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-21 14:56:10 2172 [Note] Shutting down slave threads
2016-01-21 14:56:10 2172 [Note] Forcefully disconnecting 0 remaining clients
2016-01-21 14:56:10 2172 [Note] Binlog end
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'partition'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-21 14:56:11 2172 [Note] Shutting down plugin 'InnoDB'
2016-01-21 14:56:11 2172 [Note] InnoDB: FTS optimize thread exiting.
2016-01-21 14:56:11 2172 [Note] InnoDB: Starting shutdown...
2016-01-21 14:56:12 2172 [Note] InnoDB: Shutdown completed; log sequence number 36418870
2016-01-21 14:56:12 2172 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-21 14:56:12 2172 [Note] Shutting down plugin 'ARCHIVE'
2016-01-21 14:56:12 2172 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-21 14:56:12 2172 [Note] Shutting down plugin 'MyISAM'
2016-01-21 14:56:12 2172 [Note] Shutting down plugin 'MEMORY'
2016-01-21 14:56:12 2172 [Note] Shutting down plugin 'CSV'
2016-01-21 14:56:12 2172 [Note] Shutting down plugin 'sha256_password'
2016-01-21 14:56:12 2172 [Note] Shutting down plugin 'mysql_old_password'
2016-01-21 14:56:12 2172 [Note] Shutting down plugin 'mysql_native_password'
2016-01-21 14:56:12 2172 [Note] Shutting down plugin 'binlog'
2016-01-21 14:56:12 2172 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Shutdown complete

2016-01-21 14:56:13 248 [Note] Plugin 'FEDERATED' is disabled.
2016-01-21 14:56:13 248 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-21 14:56:13 248 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-21 14:56:13 248 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-21 14:56:13 248 [Note] InnoDB: Memory barrier is not used
2016-01-21 14:56:13 248 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-21 14:56:13 248 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-21 14:56:13 248 [Note] InnoDB: Initializing buffer pool, size = 20.0M
2016-01-21 14:56:13 248 [Note] InnoDB: Completed initialization of buffer pool
2016-01-21 14:56:14 248 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-21 14:56:15 248 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-21 14:56:15 248 [Note] InnoDB: Waiting for purge to start
2016-01-21 14:56:15 248 [Note] InnoDB: 5.6.22 started; log sequence number 36418870
2016-01-21 14:56:15 248 [Note] Server hostname (bind-address): '192.168.1.77'; port: 3306
2016-01-21 14:56:15 248 [Note]   - '192.168.1.77' resolves to '192.168.1.77';
2016-01-21 14:56:15 248 [Note] Server socket created on IP: '192.168.1.77'.
2016-01-21 14:56:15 248 [Note] Event Scheduler: Loaded 0 events
2016-01-21 14:56:15 248 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.22-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-01-21 15:10:16 248 [ERROR] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Table '.\amxbanstris\amx_serverinfo' is marked as crashed and should be repaired
2016-01-21 15:10:16 248 [Warning] Checking table:   '.\amxbanstris\amx_serverinfo'
2016-01-22 22:57:50 248 [ERROR] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Table '.\amxbanstris\amx_webadmins' is marked as crashed and should be repaired
2016-01-22 22:57:50 248 [Warning] Checking table:   '.\amxbanstris\amx_webadmins'
2016-01-23 00:03:25 248 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Normal shutdown

2016-01-23 00:03:25 248 [Note] Giving 0 client threads a chance to die gracefully
2016-01-23 00:03:25 248 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-23 00:03:25 248 [Note] Shutting down slave threads
2016-01-23 00:03:25 248 [Note] Forcefully disconnecting 0 remaining clients
2016-01-23 00:03:25 248 [Note] Binlog end
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'partition'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-23 00:03:25 248 [Note] Shutting down plugin 'InnoDB'
2016-01-23 00:03:25 248 [Note] InnoDB: FTS optimize thread exiting.
2016-01-23 00:03:25 248 [Note] InnoDB: Starting shutdown...
2016-01-23 00:03:27 248 [Note] InnoDB: Shutdown completed; log sequence number 36452492
2016-01-23 00:03:27 248 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-23 00:03:27 248 [Note] Shutting down plugin 'ARCHIVE'
2016-01-23 00:03:27 248 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-23 00:03:27 248 [Note] Shutting down plugin 'MyISAM'
2016-01-23 00:03:27 248 [Note] Shutting down plugin 'MEMORY'
2016-01-23 00:03:27 248 [Note] Shutting down plugin 'CSV'
2016-01-23 00:03:27 248 [Note] Shutting down plugin 'sha256_password'
2016-01-23 00:03:27 248 [Note] Shutting down plugin 'mysql_old_password'
2016-01-23 00:03:27 248 [Note] Shutting down plugin 'mysql_native_password'
2016-01-23 00:03:27 248 [Note] Shutting down plugin 'binlog'
2016-01-23 00:03:27 248 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Shutdown complete

2016-01-23 00:03:32 3864 [Note] Plugin 'FEDERATED' is disabled.
2016-01-23 00:03:32 3864 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-23 00:03:32 3864 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 00:03:32 3864 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 00:03:32 3864 [Note] InnoDB: Memory barrier is not used
2016-01-23 00:03:32 3864 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 00:03:32 3864 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 00:03:32 3864 [Note] InnoDB: Initializing buffer pool, size = 20.0M
2016-01-23 00:03:32 3864 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 00:03:32 3864 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 00:03:35 3864 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 00:03:35 3864 [Note] InnoDB: Waiting for purge to start
2016-01-23 00:03:35 3864 [Note] InnoDB: 5.6.22 started; log sequence number 36452492
2016-01-23 00:03:35 3864 [Note] Server hostname (bind-address): '192.168.1.77'; port: 3306
2016-01-23 00:03:35 3864 [Note]   - '192.168.1.77' resolves to '192.168.1.77';
2016-01-23 00:03:35 3864 [Note] Server socket created on IP: '192.168.1.77'.
2016-01-23 00:03:36 3864 [Note] Event Scheduler: Loaded 0 events
2016-01-23 00:03:36 3864 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.22-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-01-23 03:48:32 3864 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Normal shutdown

2016-01-23 03:48:33 3864 [Note] Giving 0 client threads a chance to die gracefully
2016-01-23 03:48:33 3864 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-23 03:48:33 3864 [Note] Shutting down slave threads
2016-01-23 03:48:33 3864 [Note] Forcefully disconnecting 0 remaining clients
2016-01-23 03:48:33 3864 [Note] Binlog end
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'partition'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-23 03:48:33 3864 [Note] Shutting down plugin 'InnoDB'
2016-01-23 03:48:33 3864 [Note] InnoDB: FTS optimize thread exiting.
2016-01-23 03:48:33 3864 [Note] InnoDB: Starting shutdown...
2016-01-23 03:48:34 3864 [Note] InnoDB: Shutdown completed; log sequence number 36456589
2016-01-23 03:48:34 3864 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-23 03:48:34 3864 [Note] Shutting down plugin 'ARCHIVE'
2016-01-23 03:48:34 3864 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-23 03:48:34 3864 [Note] Shutting down plugin 'MyISAM'
2016-01-23 03:48:34 3864 [Note] Shutting down plugin 'MEMORY'
2016-01-23 03:48:34 3864 [Note] Shutting down plugin 'CSV'
2016-01-23 03:48:34 3864 [Note] Shutting down plugin 'sha256_password'
2016-01-23 03:48:34 3864 [Note] Shutting down plugin 'mysql_old_password'
2016-01-23 03:48:34 3864 [Note] Shutting down plugin 'mysql_native_password'
2016-01-23 03:48:34 3864 [Note] Shutting down plugin 'binlog'
2016-01-23 03:48:34 3864 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Shutdown complete

2016-01-23 03:51:03 2760 [Note] Plugin 'FEDERATED' is disabled.
2016-01-23 03:51:04 2760 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-23 03:51:04 2760 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 03:51:04 2760 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 03:51:04 2760 [Note] InnoDB: Memory barrier is not used
2016-01-23 03:51:04 2760 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 03:51:04 2760 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 03:51:04 2760 [Note] InnoDB: Initializing buffer pool, size = 20.0M
2016-01-23 03:51:05 2760 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 03:51:05 2760 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 03:51:16 2760 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 03:51:16 2760 [Note] InnoDB: Waiting for purge to start
2016-01-23 03:51:16 2760 [Note] InnoDB: 5.6.22 started; log sequence number 36456589
2016-01-23 03:51:18 2760 [Note] Server hostname (bind-address): '192.168.1.77'; port: 3306
2016-01-23 03:51:18 2760 [Note]   - '192.168.1.77' resolves to '192.168.1.77';
2016-01-23 03:51:18 2760 [Note] Server socket created on IP: '192.168.1.77'.
2016-01-23 03:51:20 2760 [Note] Event Scheduler: Loaded 0 events
2016-01-23 03:51:20 2760 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.22-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-01-23 03:56:57 2760 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Normal shutdown

2016-01-23 03:56:57 2760 [Note] Giving 0 client threads a chance to die gracefully
2016-01-23 03:56:57 2760 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-23 03:56:57 2760 [Note] Shutting down slave threads
2016-01-23 03:56:57 2760 [Note] Forcefully disconnecting 0 remaining clients
2016-01-23 03:56:57 2760 [Note] Binlog end
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'partition'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-23 03:56:57 2760 [Note] Shutting down plugin 'InnoDB'
2016-01-23 03:56:57 2760 [Note] InnoDB: FTS optimize thread exiting.
2016-01-23 03:56:57 2760 [Note] InnoDB: Starting shutdown...
2016-01-23 03:56:58 2760 [Note] InnoDB: Shutdown completed; log sequence number 36456599
2016-01-23 03:56:58 2760 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-23 03:56:58 2760 [Note] Shutting down plugin 'ARCHIVE'
2016-01-23 03:56:58 2760 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-23 03:56:58 2760 [Note] Shutting down plugin 'MyISAM'
2016-01-23 03:56:58 2760 [Note] Shutting down plugin 'MEMORY'
2016-01-23 03:56:58 2760 [Note] Shutting down plugin 'CSV'
2016-01-23 03:56:58 2760 [Note] Shutting down plugin 'sha256_password'
2016-01-23 03:56:58 2760 [Note] Shutting down plugin 'mysql_old_password'
2016-01-23 03:56:58 2760 [Note] Shutting down plugin 'mysql_native_password'
2016-01-23 03:56:58 2760 [Note] Shutting down plugin 'binlog'
2016-01-23 03:56:58 2760 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Shutdown complete

2016-01-23 03:58:58 2108 [Note] Plugin 'FEDERATED' is disabled.
2016-01-23 03:58:58 2108 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-23 03:58:58 2108 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 03:58:58 2108 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 03:58:58 2108 [Note] InnoDB: Memory barrier is not used
2016-01-23 03:58:58 2108 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 03:58:58 2108 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 03:58:59 2108 [Note] InnoDB: Initializing buffer pool, size = 20.0M
2016-01-23 03:58:59 2108 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 03:58:59 2108 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 03:59:02 2108 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 03:59:02 2108 [Note] InnoDB: Waiting for purge to start
2016-01-23 03:59:02 2108 [Note] InnoDB: 5.6.22 started; log sequence number 36456599
2016-01-23 03:59:02 2108 [Note] Server hostname (bind-address): '192.168.1.77'; port: 3306
2016-01-23 03:59:02 2108 [Note]   - '192.168.1.77' resolves to '192.168.1.77';
2016-01-23 03:59:02 2108 [Note] Server socket created on IP: '192.168.1.77'.
2016-01-23 03:59:06 2108 [Note] Event Scheduler: Loaded 0 events
2016-01-23 03:59:06 2108 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.22-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-01-30 16:38:21 2108 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Normal shutdown

2016-01-30 16:38:21 2108 [Note] Giving 0 client threads a chance to die gracefully
2016-01-30 16:38:21 2108 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-30 16:38:21 2108 [Note] Shutting down slave threads
2016-01-30 16:38:22 2108 [Note] Forcefully disconnecting 0 remaining clients
2016-01-30 16:38:22 2108 [Note] Binlog end
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'partition'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-30 16:38:27 2108 [Note] Shutting down plugin 'InnoDB'
2016-01-30 16:38:27 2108 [Note] InnoDB: FTS optimize thread exiting.
2016-01-30 16:38:27 2108 [Note] InnoDB: Starting shutdown...
2016-01-30 16:38:33 2108 [Note] InnoDB: Shutdown completed; log sequence number 36607075
2016-01-30 16:38:33 2108 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-30 16:38:33 2108 [Note] Shutting down plugin 'ARCHIVE'
2016-01-30 16:38:33 2108 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-30 16:38:34 2108 [Note] Shutting down plugin 'MyISAM'
2016-01-30 16:38:34 2108 [Note] Shutting down plugin 'MEMORY'
2016-01-30 16:38:34 2108 [Note] Shutting down plugin 'CSV'
2016-01-30 16:38:34 2108 [Note] Shutting down plugin 'sha256_password'
2016-01-30 16:38:34 2108 [Note] Shutting down plugin 'mysql_old_password'
2016-01-30 16:38:34 2108 [Note] Shutting down plugin 'mysql_native_password'
2016-01-30 16:38:34 2108 [Note] Shutting down plugin 'binlog'
2016-01-30 16:38:34 2108 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Shutdown complete

2016-01-30 16:53:55 2972 [Note] Plugin 'FEDERATED' is disabled.
2016-01-30 16:53:55 2972 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-30 16:53:55 2972 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-30 16:53:55 2972 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-30 16:53:55 2972 [Note] InnoDB: Memory barrier is not used
2016-01-30 16:53:55 2972 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-30 16:53:56 2972 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-30 16:53:56 2972 [Note] InnoDB: Initializing buffer pool, size = 20.0M
2016-01-30 16:53:56 2972 [Note] InnoDB: Completed initialization of buffer pool
2016-01-30 16:53:56 2972 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-30 16:53:58 2972 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-30 16:53:59 2972 [Note] InnoDB: Waiting for purge to start
2016-01-30 16:53:59 2972 [Note] InnoDB: 5.6.22 started; log sequence number 36607075
2016-01-30 16:53:59 2972 [Note] Server hostname (bind-address): '192.168.1.77'; port: 3306
2016-01-30 16:53:59 2972 [Note]   - '192.168.1.77' resolves to '192.168.1.77';
2016-01-30 16:53:59 2972 [Note] Server socket created on IP: '192.168.1.77'.
2016-01-30 16:54:02 2972 [Note] Event Scheduler: Loaded 0 events
2016-01-30 16:54:02 2972 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.22-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-01-30 17:20:24 2972 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Normal shutdown

2016-01-30 17:20:24 2972 [Note] Giving 0 client threads a chance to die gracefully
2016-01-30 17:20:24 2972 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-30 17:20:24 2972 [Note] Shutting down slave threads
2016-01-30 17:20:24 2972 [Note] Forcefully disconnecting 0 remaining clients
2016-01-30 17:20:24 2972 [Note] Binlog end
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'partition'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-30 17:20:24 2972 [Note] Shutting down plugin 'InnoDB'
2016-01-30 17:20:24 2972 [Note] InnoDB: FTS optimize thread exiting.
2016-01-30 17:20:24 2972 [Note] InnoDB: Starting shutdown...
2016-01-30 17:20:25 2972 [Note] InnoDB: Shutdown completed; log sequence number 36612040
2016-01-30 17:20:25 2972 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-30 17:20:25 2972 [Note] Shutting down plugin 'ARCHIVE'
2016-01-30 17:20:25 2972 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-30 17:20:25 2972 [Note] Shutting down plugin 'MyISAM'
2016-01-30 17:20:25 2972 [Note] Shutting down plugin 'MEMORY'
2016-01-30 17:20:25 2972 [Note] Shutting down plugin 'CSV'
2016-01-30 17:20:25 2972 [Note] Shutting down plugin 'sha256_password'
2016-01-30 17:20:26 2972 [Note] Shutting down plugin 'mysql_old_password'
2016-01-30 17:20:26 2972 [Note] Shutting down plugin 'mysql_native_password'
2016-01-30 17:20:26 2972 [Note] Shutting down plugin 'binlog'
2016-01-30 17:20:26 2972 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Shutdown complete

2016-01-30 18:28:22 1700 [Note] Plugin 'FEDERATED' is disabled.
2016-01-30 18:28:23 1700 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-30 18:28:23 1700 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-30 18:28:23 1700 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-30 18:28:23 1700 [Note] InnoDB: Memory barrier is not used
2016-01-30 18:28:23 1700 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-30 18:28:23 1700 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-30 18:28:23 1700 [Note] InnoDB: Initializing buffer pool, size = 20.0M
2016-01-30 18:28:23 1700 [Note] InnoDB: Completed initialization of buffer pool
2016-01-30 18:28:23 1700 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-30 18:28:26 1700 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-30 18:28:26 1700 [Note] InnoDB: Waiting for purge to start
2016-01-30 18:28:26 1700 [Note] InnoDB: 5.6.22 started; log sequence number 36612040
2016-01-30 18:28:27 1700 [Note] Server hostname (bind-address): '192.168.1.77'; port: 3306
2016-01-30 18:28:27 1700 [Note]   - '192.168.1.77' resolves to '192.168.1.77';
2016-01-30 18:28:27 1700 [Note] Server socket created on IP: '192.168.1.77'.
2016-01-30 18:28:29 1700 [Note] Event Scheduler: Loaded 0 events
2016-01-30 18:28:29 1700 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.22-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-01-30 19:42:19 2140 [Note] Plugin 'FEDERATED' is disabled.
2016-01-30 19:42:20 2140 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-30 19:42:20 2140 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-30 19:42:20 2140 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-30 19:42:20 2140 [Note] InnoDB: Memory barrier is not used
2016-01-30 19:42:20 2140 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-30 19:42:20 2140 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-30 19:42:20 2140 [Note] InnoDB: Initializing buffer pool, size = 20.0M
2016-01-30 19:42:20 2140 [Note] InnoDB: Completed initialization of buffer pool
2016-01-30 19:42:21 2140 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-30 19:42:21 2140 [Note] InnoDB: The log sequence numbers 36612040 and 36612040 in ibdata files do not match the log sequence number 36612050 in the ib_logfiles!
2016-01-30 19:42:21 2140 [Note] InnoDB: Database was not shutdown normally!
2016-01-30 19:42:21 2140 [Note] InnoDB: Starting crash recovery.
2016-01-30 19:42:21 2140 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-30 19:42:24 2140 [Note] InnoDB: Restoring possible half-written data pages 
2016-01-30 19:42:24 2140 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 1765, file name mysql-bin.000119
2016-01-30 19:42:28 2140 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-30 19:42:28 2140 [Note] InnoDB: Waiting for purge to start
2016-01-30 19:42:28 2140 [Note] InnoDB: 5.6.22 started; log sequence number 36612050
d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Error on delete of '.\mysql-bin.index' (Errcode: 22 - Invalid argument)
d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Error on rename of '.\mysql-bin.index_crash_safe' to '.\mysql-bin.index' (Errcode: 22 - Invalid argument)
2016-01-30 19:42:28 2140 [ERROR] MYSQL_BIN_LOG::move_crash_safe_index_file_to_index_file failed to move crash_safe_index_file to index file.
2016-01-30 19:42:28 2140 [ERROR] MYSQL_BIN_LOG::add_log_to_index failed to move crash safe index file to index file.
16:42:29 UTC - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

key_buffer_size=26214400
read_buffer_size=2097152
max_used_connections=0
max_threads=30
thread_count=0
connection_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 118043 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
66c170    mysqld.exe!my_b_gets()
630c7e    mysqld.exe!?opt_sum_query@@YAHPAVTHD@@PAUTABLE_LIST@@AAV?$List@VItem@@@@PAVItem@@@Z()
63149b    mysqld.exe!?opt_sum_query@@YAHPAVTHD@@PAUTABLE_LIST@@AAV?$List@VItem@@@@PAVItem@@@Z()
635917    mysqld.exe!?opt_sum_query@@YAHPAVTHD@@PAUTABLE_LIST@@AAV?$List@VItem@@@@PAVItem@@@Z()
411c0d    mysqld.exe!?init_common_variables@@YAHXZ()
412548    mysqld.exe!?win_main@@YAHHPAPAD@Z()
412ab7    mysqld.exe!?mysql_service@@YAHPAX@Z()
8a340a    mysqld.exe!my_mb_ctype_mb()
7c817077    kernel32.dll!RegisterWaitForInputIdle()
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Error on rename of '.\mysql-bin.index_crash_safe' to '.\mysql-bin.index' (Errcode: 22 - Invalid argument)
2016-01-30 19:43:00 3268 [ERROR] MYSQL_BIN_LOG::open_index_file failed to move crash_safe_index_file to index file.
2016-01-30 19:43:00 3268 [ERROR] Aborting

2016-01-30 19:43:00 3268 [Note] Binlog end
2016-01-30 19:43:00 3268 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Shutdown complete

d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Error on rename of '.\mysql-bin.index_crash_safe' to '.\mysql-bin.index' (Errcode: 22 - Invalid argument)
2016-01-31 00:15:45 616 [ERROR] MYSQL_BIN_LOG::open_index_file failed to move crash_safe_index_file to index file.
2016-01-31 00:15:45 616 [ERROR] Aborting

2016-01-31 00:15:45 616 [Note] Binlog end
2016-01-31 00:15:45 616 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Shutdown complete

d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Error on rename of '.\mysql-bin.index_crash_safe' to '.\mysql-bin.index' (Errcode: 22 - Invalid argument)
2016-01-31 19:13:18 2344 [ERROR] MYSQL_BIN_LOG::open_index_file failed to move crash_safe_index_file to index file.
2016-01-31 19:13:18 2344 [ERROR] Aborting

2016-01-31 19:13:18 2344 [Note] Binlog end
2016-01-31 19:13:18 2344 [Note] d:\openserver\modules\database\MySQL-5.6\bin\mysqld.exe: Shutdown complete

Re: Не стартует MySQL

Добавлено: 31 янв 2016, 22:01
Максим
Перейдите в папку с данными текущего mysql модуля (в userdata). Сделайте резервную копию всех файлов mysql-bin.*, после чего удалите все файлы mysql-bin.* и пробуйте запустить сервер.

Re: Не стартует MySQL

Добавлено: 31 янв 2016, 22:49
trissys
Максим писал(а):Перейдите в папку с данными текущего mysql модуля (в userdata). Сделайте резервную копию всех файлов mysql-bin.*, после чего удалите все файлы mysql-bin.* и пробуйте запустить сервер.
спс1 о великий! все заработало!

Re: Не стартует MySQL

Добавлено: 25 мар 2022, 21:51
keka
Добрый день, подскажите, пожалуйста, можно что-то сделать с битой базой.
В процессе установки Drupal, винда зависла синим экраном и в результате имеется битая база MySQL, которая не даёт серверу запуститься.

Вот такой лог:
2022-03-25T18:05:35.818800Z 0 [Note] d:\openserver\modules\database\MySQL-5.7-x64\bin\mysqld.exe (mysqld 5.7.25) starting as process 7984 ...
2022-03-25T18:05:35.968800Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-03-25T18:05:35.969800Z 0 [Note] InnoDB: Uses event mutexes
2022-03-25T18:05:35.969800Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2022-03-25T18:05:35.969800Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-25T18:05:35.969800Z 0 [Note] InnoDB: Number of pools: 1
2022-03-25T18:05:35.969800Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-03-25T18:05:35.971800Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-03-25T18:05:35.978800Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-25T18:05:36.154800Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-03-25T18:05:36.158800Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 264670734
2022-03-25T18:05:36.158800Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 264670781
2022-03-25T18:05:36.158800Z 0 [Note] InnoDB: Database was not shutdown normally!
2022-03-25T18:05:36.158800Z 0 [Note] InnoDB: Starting crash recovery.
2022-03-25T18:05:41.448800Z 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2022-03-25T18:05:41.448800Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-03-25T18:05:41.448800Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-03-25T18:05:41.448800Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\kazis_p11\batch.ibd' OS error: 103
2022-03-25T18:05:41.449800Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `kazis_p11/batch`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/ ... adict.html for how to resolve the issue.
2022-03-25T18:05:41.449800Z 0 [Warning] InnoDB: Ignoring tablespace `kazis_p11/batch` because it could not be opened.
2022-03-25T18:05:41.449800Z 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2022-03-25T18:05:41.449800Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-03-25T18:05:41.449800Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-03-25T18:05:41.449800Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\kazis_p11\block_content.ibd' OS error: 103
2022-03-25T18:05:41.450800Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `kazis_p11/block_content`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/ ... adict.html for how to resolve the issue.
2022-03-25T18:05:41.450800Z 0 [Warning] InnoDB: Ignoring tablespace `kazis_p11/block_content` because it could not be opened.
2022-03-25T18:05:41.450800Z 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2022-03-25T18:05:41.450800Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-03-25T18:05:41.450800Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-03-25T18:05:41.450800Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\kazis_p11\block_content__body.ibd' OS error: 103
2022-03-25T18:05:41.450800Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `kazis_p11/block_content__body`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/ ... adict.html for how to resolve the issue.

.......
Часть лога выкинута, чтобы сократь общий текст сообщения.
Идут повторы строк: одна строка с [Warning], затем пять строк с [ERROR] для разных таблиц.
.......

2022-03-25T18:05:41.499800Z 0 [Warning] InnoDB: Ignoring tablespace `kazis_p11/users_data` because it could not be opened.
2022-03-25T18:05:41.499800Z 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2022-03-25T18:05:41.499800Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-03-25T18:05:41.499800Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-03-25T18:05:41.499800Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\kazis_p11\users_field_data.ibd' OS error: 103
2022-03-25T18:05:41.499800Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `kazis_p11/users_field_data`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/ ... adict.html for how to resolve the issue.
2022-03-25T18:05:41.500800Z 0 [Warning] InnoDB: Ignoring tablespace `kazis_p11/users_field_data` because it could not be opened.
2022-03-25T18:05:41.500800Z 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2022-03-25T18:05:41.500800Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-03-25T18:05:41.500800Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-03-25T18:05:41.500800Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\kazis_p11\watchdog.ibd' OS error: 103
2022-03-25T18:05:41.500800Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `kazis_p11/watchdog`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/ ... adict.html for how to resolve the issue.
2022-03-25T18:05:41.500800Z 0 [Warning] InnoDB: Ignoring tablespace `kazis_p11/watchdog` because it could not be opened.
2022-03-25T18:05:41.934800Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-03-25T18:05:41.934800Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-25T18:05:41.935800Z 0 [Note] InnoDB: Setting file 'd:\openserver\userdata\MySQL-5.7-x64\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-25T18:05:42.198800Z 0 [Note] InnoDB: File 'd:\openserver\userdata\MySQL-5.7-x64\ibtmp1' size is now 12 MB.
2022-03-25T18:05:42.203800Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-03-25T18:05:42.204800Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-03-25T18:05:42.207800Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6226ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2022-03-25T18:05:42.253800Z 0 [Note] InnoDB: 5.7.25 started; log sequence number 264670781
2022-03-25T18:05:42.255800Z 0 [Note] InnoDB: Loading buffer pool(s) from d:\openserver\userdata\MySQL-5.7-x64\ib_buffer_pool
2022-03-25T18:05:42.256800Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-03-25T18:05:42.460800Z 0 [ERROR] InnoDB: Failed to find tablespace for table `kazis_p11`.`batch` in the cache. Attempting to load the tablespace with space id 994
2022-03-25T18:05:42.462800Z 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2022-03-25T18:05:42.462800Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-03-25T18:05:42.464800Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\kazis_p11\batch.ibd' OS error: 103
2022-03-25T18:05:42.465800Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `kazis_p11/batch`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/ ... adict.html for how to resolve the issue.
18:05:42 UTC - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.

key_buffer_size=26214400
read_buffer_size=2097152
max_used_connections=0
max_threads=30
thread_count=0
connection_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 118125 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x13785a40
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
1405b7f96    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
1406e51cc    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
1406e4d1f    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
1406e6412    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
14069ebf1    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
14069e34d    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
14069e142    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
1404d64af    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
1404d76ae    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
76e7652d    kernel32.dll!BaseThreadInitThunk()
770ac521    ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): 
Connection ID (thread ID): 0
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Можно как-то эту битую базу удалить не запуская Open Server?

Нашёл совет от 2016 года, но не нашёл у себя файлов mysql-bin.*, видимо в текущей версии Open Server их нет.
Максим писал(а): 31 янв 2016, 22:01 Перейдите в папку с данными текущего mysql модуля (в userdata). Сделайте резервную копию всех файлов mysql-bin.*, после чего удалите все файлы mysql-bin.* и пробуйте запустить сервер.