API tools faq
paste
Advertisement
Guest User

Error log File MySQL

a guest
May 6th, 2014
750
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 71.63 KB | None | 0 0
raw download clone embed print report
  1. 2014-05-05 12:54:19 2148 [Warning] You need to use --log-bin to make --binlog-format work.
  2. 2014-05-05 12:54:19 2148 [Note] Plugin 'FEDERATED' is disabled.
  3. 2014-05-05 12:54:19 2148 [Note] InnoDB: Using atomics to ref count buffer pool pages
  4. 2014-05-05 12:54:19 2148 [Note] InnoDB: The InnoDB memory heap is disabled
  5. 2014-05-05 12:54:19 2148 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  6. 2014-05-05 12:54:19 2148 [Note] InnoDB: Compressed tables use zlib 1.2.3
  7. 2014-05-05 12:54:19 2148 [Note] InnoDB: Not using CPU crc32 instructions
  8. 2014-05-05 12:54:19 2148 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  9. 2014-05-05 12:54:19 2148 [Note] InnoDB: Completed initialization of buffer pool
  10. 2014-05-05 12:54:19 2148 [Note] InnoDB: The first specified data file .\ibdata1 did not exist: a new database to be created!
  11. 2014-05-05 12:54:19 2148 [Note] InnoDB: Setting file .\ibdata1 size to 12 MB
  12. 2014-05-05 12:54:19 2148 [Note] InnoDB: Database physically writes the file full: wait...
  13. 2014-05-05 12:54:19 2148 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
  14. 2014-05-05 12:54:21 2148 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB
  15. 2014-05-05 12:54:23 2148 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
  16. 2014-05-05 12:54:23 2148 [Warning] InnoDB: New log files created, LSN=45781
  17. 2014-05-05 12:54:23 2148 [Note] InnoDB: Doublewrite buffer not found: creating new
  18. 2014-05-05 12:54:23 2148 [Note] InnoDB: Doublewrite buffer created
  19. 2014-05-05 12:54:23 2148 [Note] InnoDB: 128 rollback segment(s) are active.
  20. 2014-05-05 12:54:23 2148 [Warning] InnoDB: Creating foreign key constraint system tables.
  21. 2014-05-05 12:54:23 2148 [Note] InnoDB: Foreign key constraint system tables created
  22. 2014-05-05 12:54:23 2148 [Note] InnoDB: Creating tablespace and datafile system tables.
  23. 2014-05-05 12:54:23 2148 [Note] InnoDB: Tablespace and datafile system tables created.
  24. 2014-05-05 12:54:23 2148 [Note] InnoDB: Waiting for purge to start
  25. 2014-05-05 12:54:23 2148 [Note] InnoDB: 5.6.16 started; log sequence number 0
  26. 2014-05-05 12:54:23 2148 [Note] Server hostname (bind-address): '*'; port: 3306
  27. 2014-05-05 12:54:26 2148 [Note] IPv6 is not available.
  28. 2014-05-05 12:54:26 2148 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  29. 2014-05-05 12:54:26 2148 [Note] Server socket created on IP: '0.0.0.0'.
  30. 2014-05-05 12:54:26 2148 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  31. 2014-05-05 12:54:26 2148 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
  32. 2014-05-05 12:54:26 2148 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  33. 2014-05-05 12:54:26 2148 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  34. 2014-05-05 12:54:26 2148 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
  35. 2014-05-05 12:54:26 2148 [Note] Event Scheduler: Loaded 0 events
  36. 2014-05-05 12:54:26 2148 [Note] mysql\bin\mysqld.exe: ready for connections.
  37. Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
  38. 2014-05-05 15:03:26 2160 [Warning] You need to use --log-bin to make --binlog-format work.
  39. 2014-05-05 15:03:26 2160 [Note] Plugin 'FEDERATED' is disabled.
  40. 2014-05-05 15:03:26 2160 [Note] InnoDB: Using atomics to ref count buffer pool pages
  41. 2014-05-05 15:03:26 2160 [Note] InnoDB: The InnoDB memory heap is disabled
  42. 2014-05-05 15:03:26 2160 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  43. 2014-05-05 15:03:26 2160 [Note] InnoDB: Compressed tables use zlib 1.2.3
  44. 2014-05-05 15:03:26 2160 [Note] InnoDB: Not using CPU crc32 instructions
  45. 2014-05-05 15:03:26 2160 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  46. 2014-05-05 15:03:26 2160 [Note] InnoDB: Completed initialization of buffer pool
  47. 2014-05-05 15:03:27 2160 [Note] InnoDB: Highest supported file format is Barracuda.
  48. 2014-05-05 15:03:27 2160 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600607 in the ib_logfiles!
  49. 2014-05-05 15:03:27 2160 [Note] InnoDB: Database was not shutdown normally!
  50. 2014-05-05 15:03:27 2160 [Note] InnoDB: Starting crash recovery.
  51. 2014-05-05 15:03:27 2160 [Note] InnoDB: Reading tablespace information from the .ibd files...
  52. 2014-05-05 15:03:27 2160 [Note] InnoDB: Restoring possible half-written data pages
  53. 2014-05-05 15:03:27 2160 [Note] InnoDB: from the doublewrite buffer...
  54. 2014-05-05 15:03:28 2160 [Note] InnoDB: 128 rollback segment(s) are active.
  55. 2014-05-05 15:03:29 2160 [Note] InnoDB: Waiting for purge to start
  56. 2014-05-05 15:03:29 2160 [Note] InnoDB: 5.6.16 started; log sequence number 1600607
  57. 2014-05-05 15:03:29 2160 [Note] Server hostname (bind-address): '*'; port: 3306
  58. 2014-05-05 15:03:31 2160 [Note] IPv6 is not available.
  59. 2014-05-05 15:03:31 2160 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  60. 2014-05-05 15:03:31 2160 [Note] Server socket created on IP: '0.0.0.0'.
  61. 2014-05-05 15:03:32 2160 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  62. 2014-05-05 15:03:32 2160 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
  63. 2014-05-05 15:03:32 2160 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  64. 2014-05-05 15:03:32 2160 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  65. 2014-05-05 15:03:32 2160 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
  66. 2014-05-05 15:03:33 2160 [Note] Event Scheduler: Loaded 0 events
  67. 2014-05-05 15:03:33 2160 [Note] mysql\bin\mysqld.exe: ready for connections.
  68. Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
  69. 2014-05-05 15:08:23 2160 [Note] mysql\bin\mysqld.exe: Normal shutdown
  70.  
  71. 2014-05-05 15:08:23 2160 [Note] Giving 1 client threads a chance to die gracefully
  72. 2014-05-05 15:08:23 2160 [Note] Event Scheduler: Purging the queue. 0 events
  73. 2014-05-05 15:08:23 2160 [Note] Shutting down slave threads
  74. 2014-05-05 15:08:23 2160 [Note] Forcefully disconnecting 0 remaining clients
  75. 2014-05-05 15:08:23 2160 [Note] Binlog end
  76. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'partition'
  77. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  78. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  79. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  80. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  81. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  82. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  83. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  84. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  85. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  86. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  87. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  88. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  89. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  90. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  91. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  92. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  93. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_METRICS'
  94. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  95. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  96. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  97. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  98. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  99. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  100. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_CMPMEM'
  101. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  102. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_CMP'
  103. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  104. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_LOCKS'
  105. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'INNODB_TRX'
  106. 2014-05-05 15:08:23 2160 [Note] Shutting down plugin 'InnoDB'
  107. 2014-05-05 15:08:23 2160 [Note] InnoDB: FTS optimize thread exiting.
  108. 2014-05-05 15:08:23 2160 [Note] InnoDB: Starting shutdown...
  109. 2014-05-05 15:08:24 2160 [Note] InnoDB: Shutdown completed; log sequence number 1600617
  110. 2014-05-05 15:08:24 2160 [Note] Shutting down plugin 'BLACKHOLE'
  111. 2014-05-05 15:08:24 2160 [Note] Shutting down plugin 'ARCHIVE'
  112. 2014-05-05 15:08:24 2160 [Note] Shutting down plugin 'MRG_MYISAM'
  113. 2014-05-05 15:08:24 2160 [Note] Shutting down plugin 'MyISAM'
  114. 2014-05-05 15:08:24 2160 [Note] Shutting down plugin 'MEMORY'
  115. 2014-05-05 15:08:25 2160 [Note] Shutting down plugin 'CSV'
  116. 2014-05-05 15:08:25 2160 [Note] Shutting down plugin 'sha256_password'
  117. 2014-05-05 15:08:25 2160 [Note] Shutting down plugin 'mysql_old_password'
  118. 2014-05-05 15:08:25 2160 [Note] Shutting down plugin 'mysql_native_password'
  119. 2014-05-05 15:08:25 2160 [Note] Shutting down plugin 'binlog'
  120. 2014-05-05 15:08:25 2160 [Note] mysql\bin\mysqld.exe: Shutdown complete
  121.  
  122. 2014-05-05 15:08:31 648 [Warning] You need to use --log-bin to make --binlog-format work.
  123. 2014-05-05 15:08:31 648 [Note] Plugin 'FEDERATED' is disabled.
  124. 2014-05-05 15:08:31 648 [Note] InnoDB: Using atomics to ref count buffer pool pages
  125. 2014-05-05 15:08:31 648 [Note] InnoDB: The InnoDB memory heap is disabled
  126. 2014-05-05 15:08:31 648 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  127. 2014-05-05 15:08:31 648 [Note] InnoDB: Compressed tables use zlib 1.2.3
  128. 2014-05-05 15:08:31 648 [Note] InnoDB: Not using CPU crc32 instructions
  129. 2014-05-05 15:08:31 648 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  130. 2014-05-05 15:08:32 648 [Note] InnoDB: Completed initialization of buffer pool
  131. 2014-05-05 15:08:32 648 [Note] InnoDB: Highest supported file format is Barracuda.
  132. 2014-05-05 15:08:32 648 [Note] InnoDB: 128 rollback segment(s) are active.
  133. 2014-05-05 15:08:32 648 [Note] InnoDB: Waiting for purge to start
  134. 2014-05-05 15:08:32 648 [Note] InnoDB: 5.6.16 started; log sequence number 1600617
  135. 2014-05-05 15:08:32 648 [Note] Server hostname (bind-address): '*'; port: 3306
  136. 2014-05-05 15:08:34 648 [Note] IPv6 is not available.
  137. 2014-05-05 15:08:34 648 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  138. 2014-05-05 15:08:34 648 [Note] Server socket created on IP: '0.0.0.0'.
  139. 2014-05-05 15:08:34 648 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  140. 2014-05-05 15:08:34 648 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
  141. 2014-05-05 15:08:34 648 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  142. 2014-05-05 15:08:34 648 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  143. 2014-05-05 15:08:34 648 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
  144. 2014-05-05 15:08:34 648 [Note] Event Scheduler: Loaded 0 events
  145. 2014-05-05 15:08:34 648 [Note] mysql\bin\mysqld.exe: ready for connections.
  146. Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
  147. 2014-05-05 15:12:56 648 [Note] mysql\bin\mysqld.exe: Normal shutdown
  148.  
  149. 2014-05-05 15:12:56 648 [Note] Giving 0 client threads a chance to die gracefully
  150. 2014-05-05 15:12:56 648 [Note] Event Scheduler: Purging the queue. 0 events
  151. 2014-05-05 15:12:56 648 [Note] Shutting down slave threads
  152. 2014-05-05 15:12:56 648 [Note] Forcefully disconnecting 0 remaining clients
  153. 2014-05-05 15:12:56 648 [Note] Binlog end
  154. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'partition'
  155. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  156. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  157. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  158. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  159. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  160. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  161. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  162. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  163. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  164. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  165. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  166. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  167. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  168. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  169. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  170. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  171. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_METRICS'
  172. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  173. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  174. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  175. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  176. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  177. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  178. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_CMPMEM'
  179. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  180. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_CMP'
  181. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  182. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_LOCKS'
  183. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'INNODB_TRX'
  184. 2014-05-05 15:12:56 648 [Note] Shutting down plugin 'InnoDB'
  185. 2014-05-05 15:12:56 648 [Note] InnoDB: FTS optimize thread exiting.
  186. 2014-05-05 15:12:56 648 [Note] InnoDB: Starting shutdown...
  187. 2014-05-05 15:12:57 648 [Note] InnoDB: Shutdown completed; log sequence number 1600627
  188. 2014-05-05 15:12:57 648 [Note] Shutting down plugin 'BLACKHOLE'
  189. 2014-05-05 15:12:57 648 [Note] Shutting down plugin 'ARCHIVE'
  190. 2014-05-05 15:12:57 648 [Note] Shutting down plugin 'MRG_MYISAM'
  191. 2014-05-05 15:12:57 648 [Note] Shutting down plugin 'MyISAM'
  192. 2014-05-05 15:12:57 648 [Note] Shutting down plugin 'MEMORY'
  193. 2014-05-05 15:12:57 648 [Note] Shutting down plugin 'CSV'
  194. 2014-05-05 15:12:57 648 [Note] Shutting down plugin 'sha256_password'
  195. 2014-05-05 15:12:57 648 [Note] Shutting down plugin 'mysql_old_password'
  196. 2014-05-05 15:12:57 648 [Note] Shutting down plugin 'mysql_native_password'
  197. 2014-05-05 15:12:57 648 [Note] Shutting down plugin 'binlog'
  198. 2014-05-05 15:12:57 648 [Note] mysql\bin\mysqld.exe: Shutdown complete
  199.  
  200. 2014-05-05 15:12:59 2356 [Warning] You need to use --log-bin to make --binlog-format work.
  201. 2014-05-05 15:12:59 2356 [Note] Plugin 'FEDERATED' is disabled.
  202. 2014-05-05 15:12:59 2356 [Note] InnoDB: Using atomics to ref count buffer pool pages
  203. 2014-05-05 15:12:59 2356 [Note] InnoDB: The InnoDB memory heap is disabled
  204. 2014-05-05 15:12:59 2356 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  205. 2014-05-05 15:12:59 2356 [Note] InnoDB: Compressed tables use zlib 1.2.3
  206. 2014-05-05 15:12:59 2356 [Note] InnoDB: Not using CPU crc32 instructions
  207. 2014-05-05 15:12:59 2356 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  208. 2014-05-05 15:12:59 2356 [Note] InnoDB: Completed initialization of buffer pool
  209. 2014-05-05 15:12:59 2356 [Note] InnoDB: Highest supported file format is Barracuda.
  210. 2014-05-05 15:12:59 2356 [Note] InnoDB: 128 rollback segment(s) are active.
  211. 2014-05-05 15:12:59 2356 [Note] InnoDB: Waiting for purge to start
  212. 2014-05-05 15:12:59 2356 [Note] InnoDB: 5.6.16 started; log sequence number 1600627
  213. 2014-05-05 15:12:59 2356 [Note] Server hostname (bind-address): '*'; port: 3306
  214. 2014-05-05 15:13:02 2356 [Note] IPv6 is not available.
  215. 2014-05-05 15:13:02 2356 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  216. 2014-05-05 15:13:02 2356 [Note] Server socket created on IP: '0.0.0.0'.
  217. 2014-05-05 15:13:02 2356 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  218. 2014-05-05 15:13:02 2356 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
  219. 2014-05-05 15:13:02 2356 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  220. 2014-05-05 15:13:02 2356 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  221. 2014-05-05 15:13:02 2356 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
  222. 2014-05-05 15:13:02 2356 [Note] Event Scheduler: Loaded 0 events
  223. 2014-05-05 15:13:02 2356 [Note] mysql\bin\mysqld.exe: ready for connections.
  224. Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
  225. 2014-05-05 15:36:44 3792 [Warning] You need to use --log-bin to make --binlog-format work.
  226. 2014-05-05 15:36:44 3792 [Note] Plugin 'FEDERATED' is disabled.
  227. 2014-05-05 15:36:44 3792 [Note] InnoDB: Using atomics to ref count buffer pool pages
  228. 2014-05-05 15:36:44 3792 [Note] InnoDB: The InnoDB memory heap is disabled
  229. 2014-05-05 15:36:44 3792 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  230. 2014-05-05 15:36:44 3792 [Note] InnoDB: Compressed tables use zlib 1.2.3
  231. 2014-05-05 15:36:44 3792 [Note] InnoDB: Not using CPU crc32 instructions
  232. 2014-05-05 15:36:44 3792 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  233. 2014-05-05 15:36:44 3792 [Note] InnoDB: Completed initialization of buffer pool
  234. 2014-05-05 15:36:44 3792 [Note] InnoDB: Highest supported file format is Barracuda.
  235. 2014-05-05 15:36:44 3792 [Note] InnoDB: The log sequence numbers 1600627 and 1600627 in ibdata files do not match the log sequence number 1600637 in the ib_logfiles!
  236. 2014-05-05 15:36:44 3792 [Note] InnoDB: Database was not shutdown normally!
  237. 2014-05-05 15:36:44 3792 [Note] InnoDB: Starting crash recovery.
  238. 2014-05-05 15:36:44 3792 [Note] InnoDB: Reading tablespace information from the .ibd files...
  239. 2014-05-05 15:36:45 3792 [Note] InnoDB: Restoring possible half-written data pages
  240. 2014-05-05 15:36:45 3792 [Note] InnoDB: from the doublewrite buffer...
  241. 2014-05-05 15:36:46 3792 [Note] InnoDB: 128 rollback segment(s) are active.
  242. 2014-05-05 15:36:47 3792 [Note] InnoDB: Waiting for purge to start
  243. 2014-05-05 15:36:47 3792 [Note] InnoDB: 5.6.16 started; log sequence number 1600637
  244. 2014-05-05 15:36:47 3792 [Note] Server hostname (bind-address): '*'; port: 3306
  245. 2014-05-05 15:36:49 3792 [Note] IPv6 is not available.
  246. 2014-05-05 15:36:49 3792 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  247. 2014-05-05 15:36:49 3792 [Note] Server socket created on IP: '0.0.0.0'.
  248. 2014-05-05 15:36:50 3792 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  249. 2014-05-05 15:36:50 3792 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
  250. 2014-05-05 15:36:50 3792 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  251. 2014-05-05 15:36:50 3792 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  252. 2014-05-05 15:36:50 3792 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
  253. 2014-05-05 15:36:50 3792 [Note] Event Scheduler: Loaded 0 events
  254. 2014-05-05 15:36:50 3792 [Note] mysql\bin\mysqld.exe: ready for connections.
  255. Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
  256. 2014-05-05 18:57:30 1820 [Warning] You need to use --log-bin to make --binlog-format work.
  257. 2014-05-05 18:57:30 1820 [Note] Plugin 'FEDERATED' is disabled.
  258. 2014-05-05 18:57:30 1820 [Note] InnoDB: Using atomics to ref count buffer pool pages
  259. 2014-05-05 18:57:30 1820 [Note] InnoDB: The InnoDB memory heap is disabled
  260. 2014-05-05 18:57:30 1820 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  261. 2014-05-05 18:57:30 1820 [Note] InnoDB: Compressed tables use zlib 1.2.3
  262. 2014-05-05 18:57:30 1820 [Note] InnoDB: Not using CPU crc32 instructions
  263. 2014-05-05 18:57:30 1820 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  264. 2014-05-05 18:57:30 1820 [Note] InnoDB: Completed initialization of buffer pool
  265. 2014-05-05 18:57:31 1820 [Note] InnoDB: Highest supported file format is Barracuda.
  266. 2014-05-05 18:57:31 1820 [Note] InnoDB: The log sequence numbers 1600627 and 1600627 in ibdata files do not match the log sequence number 1600647 in the ib_logfiles!
  267. 2014-05-05 18:57:31 1820 [Note] InnoDB: Database was not shutdown normally!
  268. 2014-05-05 18:57:31 1820 [Note] InnoDB: Starting crash recovery.
  269. 2014-05-05 18:57:31 1820 [Note] InnoDB: Reading tablespace information from the .ibd files...
  270. 2014-05-05 18:57:31 1820 [Note] InnoDB: Restoring possible half-written data pages
  271. 2014-05-05 18:57:31 1820 [Note] InnoDB: from the doublewrite buffer...
  272. 2014-05-05 18:57:32 1820 [Note] InnoDB: 128 rollback segment(s) are active.
  273. 2014-05-05 18:57:32 1820 [Note] InnoDB: Waiting for purge to start
  274. 2014-05-05 18:57:33 1820 [Note] InnoDB: 5.6.16 started; log sequence number 1600647
  275. 2014-05-05 18:57:33 1820 [Note] Server hostname (bind-address): '*'; port: 3306
  276. 2014-05-05 18:57:35 1820 [Note] IPv6 is not available.
  277. 2014-05-05 18:57:35 1820 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  278. 2014-05-05 18:57:35 1820 [Note] Server socket created on IP: '0.0.0.0'.
  279. 2014-05-05 18:57:36 1820 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  280. 2014-05-05 18:57:36 1820 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
  281. 2014-05-05 18:57:36 1820 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  282. 2014-05-05 18:57:36 1820 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  283. 2014-05-05 18:57:36 1820 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
  284. 2014-05-05 18:57:36 1820 [Note] Event Scheduler: Loaded 0 events
  285. 2014-05-05 18:57:36 1820 [Note] mysql\bin\mysqld.exe: ready for connections.
  286. Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
  287. 2014-05-05 19:15:00 1820 [Note] mysql\bin\mysqld.exe: Normal shutdown
  288.  
  289. 2014-05-05 19:15:00 1820 [Note] Giving 0 client threads a chance to die gracefully
  290. 2014-05-05 19:15:00 1820 [Note] Event Scheduler: Purging the queue. 0 events
  291. 2014-05-05 19:15:00 1820 [Note] Shutting down slave threads
  292. 2014-05-05 19:15:00 1820 [Note] Forcefully disconnecting 0 remaining clients
  293. 2014-05-05 19:15:00 1820 [Note] Binlog end
  294. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'partition'
  295. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  296. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  297. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  298. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  299. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  300. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  301. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  302. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  303. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  304. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  305. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  306. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  307. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  308. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  309. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  310. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  311. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_METRICS'
  312. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  313. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  314. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  315. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  316. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  317. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  318. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_CMPMEM'
  319. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  320. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_CMP'
  321. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  322. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_LOCKS'
  323. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'INNODB_TRX'
  324. 2014-05-05 19:15:00 1820 [Note] Shutting down plugin 'InnoDB'
  325. 2014-05-05 19:15:00 1820 [Note] InnoDB: FTS optimize thread exiting.
  326. 2014-05-05 19:15:00 1820 [Note] InnoDB: Starting shutdown...
  327. 2014-05-05 19:15:01 1820 [Note] InnoDB: Shutdown completed; log sequence number 1600657
  328. 2014-05-05 19:15:01 1820 [Note] Shutting down plugin 'BLACKHOLE'
  329. 2014-05-05 19:15:01 1820 [Note] Shutting down plugin 'ARCHIVE'
  330. 2014-05-05 19:15:01 1820 [Note] Shutting down plugin 'MRG_MYISAM'
  331. 2014-05-05 19:15:01 1820 [Note] Shutting down plugin 'MyISAM'
  332. 2014-05-05 19:15:01 1820 [Note] Shutting down plugin 'MEMORY'
  333. 2014-05-05 19:15:01 1820 [Note] Shutting down plugin 'CSV'
  334. 2014-05-05 19:15:01 1820 [Note] Shutting down plugin 'sha256_password'
  335. 2014-05-05 19:15:01 1820 [Note] Shutting down plugin 'mysql_old_password'
  336. 2014-05-05 19:15:01 1820 [Note] Shutting down plugin 'mysql_native_password'
  337. 2014-05-05 19:15:01 1820 [Note] Shutting down plugin 'binlog'
  338. 2014-05-05 19:15:01 1820 [Note] mysql\bin\mysqld.exe: Shutdown complete
  339.  
  340. 2014-05-05 19:15:03 3508 [Warning] You need to use --log-bin to make --binlog-format work.
  341. 2014-05-05 19:15:03 3508 [Note] Plugin 'FEDERATED' is disabled.
  342. 2014-05-05 19:15:03 3508 [Note] InnoDB: Using atomics to ref count buffer pool pages
  343. 2014-05-05 19:15:03 3508 [Note] InnoDB: The InnoDB memory heap is disabled
  344. 2014-05-05 19:15:03 3508 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  345. 2014-05-05 19:15:03 3508 [Note] InnoDB: Compressed tables use zlib 1.2.3
  346. 2014-05-05 19:15:03 3508 [Note] InnoDB: Not using CPU crc32 instructions
  347. 2014-05-05 19:15:03 3508 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  348. 2014-05-05 19:15:03 3508 [Note] InnoDB: Completed initialization of buffer pool
  349. 2014-05-05 19:15:03 3508 [Note] InnoDB: Highest supported file format is Barracuda.
  350. 2014-05-05 19:15:03 3508 [Note] InnoDB: 128 rollback segment(s) are active.
  351. 2014-05-05 19:15:03 3508 [Note] InnoDB: Waiting for purge to start
  352. 2014-05-05 19:15:03 3508 [Note] InnoDB: 5.6.16 started; log sequence number 1600657
  353. 2014-05-05 19:15:03 3508 [Note] Server hostname (bind-address): '*'; port: 3306
  354. 2014-05-05 19:15:06 3508 [Note] IPv6 is not available.
  355. 2014-05-05 19:15:06 3508 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  356. 2014-05-05 19:15:06 3508 [Note] Server socket created on IP: '0.0.0.0'.
  357. 2014-05-05 19:15:06 3508 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  358. 2014-05-05 19:15:06 3508 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
  359. 2014-05-05 19:15:06 3508 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  360. 2014-05-05 19:15:06 3508 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  361. 2014-05-05 19:15:06 3508 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
  362. 2014-05-05 19:15:06 3508 [Note] Event Scheduler: Loaded 0 events
  363. 2014-05-05 19:15:06 3508 [Note] mysql\bin\mysqld.exe: ready for connections.
  364. Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
  365. 2014-05-05 19:15:06 2624 [Warning] You need to use --log-bin to make --binlog-format work.
  366. 2014-05-05 19:15:06 2624 [Note] Plugin 'FEDERATED' is disabled.
  367. 2014-05-05 19:15:06 2624 [Note] InnoDB: Using atomics to ref count buffer pool pages
  368. 2014-05-05 19:15:06 2624 [Note] InnoDB: The InnoDB memory heap is disabled
  369. 2014-05-05 19:15:06 2624 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  370. 2014-05-05 19:15:06 2624 [Note] InnoDB: Compressed tables use zlib 1.2.3
  371. 2014-05-05 19:15:06 2624 [Note] InnoDB: Not using CPU crc32 instructions
  372. 2014-05-05 19:15:06 2624 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  373. 2014-05-05 19:15:06 2624 [Note] InnoDB: Completed initialization of buffer pool
  374. 2014-05-05 19:15:06 2624 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode
  375. 2014-05-05 19:15:06 2624 [ERROR] InnoDB: The system tablespace must be writable!
  376. 2014-05-05 19:15:06 2624 [ERROR] Plugin 'InnoDB' init function returned error.
  377. 2014-05-05 19:15:06 2624 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  378. 2014-05-05 19:15:06 2624 [ERROR] Unknown/unsupported storage engine: InnoDB
  379. 2014-05-05 19:15:06 2624 [ERROR] Aborting
  380.  
  381. 2014-05-05 19:15:06 2624 [Note] Binlog end
  382. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'partition'
  383. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  384. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  385. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  386. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  387. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  388. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  389. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  390. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  391. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  392. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  393. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  394. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  395. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  396. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  397. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  398. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  399. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_METRICS'
  400. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  401. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  402. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  403. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  404. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  405. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  406. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_CMPMEM'
  407. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  408. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_CMP'
  409. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  410. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_LOCKS'
  411. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'INNODB_TRX'
  412. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'BLACKHOLE'
  413. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'ARCHIVE'
  414. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'MRG_MYISAM'
  415. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'MyISAM'
  416. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'MEMORY'
  417. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'CSV'
  418. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'sha256_password'
  419. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'mysql_old_password'
  420. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'mysql_native_password'
  421. 2014-05-05 19:15:06 2624 [Note] Shutting down plugin 'binlog'
  422. 2014-05-05 19:15:06 2624 [Note] mysql\bin\mysqld.exe: Shutdown complete
  423.  
  424. 2014-05-05 19:15:13 3508 [Note] mysql\bin\mysqld.exe: Normal shutdown
  425.  
  426. 2014-05-05 19:15:13 3508 [Note] Giving 0 client threads a chance to die gracefully
  427. 2014-05-05 19:15:13 3508 [Note] Event Scheduler: Purging the queue. 0 events
  428. 2014-05-05 19:15:13 3508 [Note] Shutting down slave threads
  429. 2014-05-05 19:15:13 3508 [Note] Forcefully disconnecting 0 remaining clients
  430. 2014-05-05 19:15:13 3508 [Note] Binlog end
  431. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'partition'
  432. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  433. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  434. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  435. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  436. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  437. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  438. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  439. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  440. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  441. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  442. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  443. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  444. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  445. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  446. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  447. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  448. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_METRICS'
  449. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  450. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  451. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  452. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  453. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  454. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  455. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_CMPMEM'
  456. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  457. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_CMP'
  458. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  459. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_LOCKS'
  460. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'INNODB_TRX'
  461. 2014-05-05 19:15:13 3508 [Note] Shutting down plugin 'InnoDB'
  462. 2014-05-05 19:15:13 3508 [Note] InnoDB: FTS optimize thread exiting.
  463. 2014-05-05 19:15:13 3508 [Note] InnoDB: Starting shutdown...
  464. 2014-05-05 19:15:14 3508 [Note] InnoDB: Shutdown completed; log sequence number 1600667
  465. 2014-05-05 19:15:14 3508 [Note] Shutting down plugin 'BLACKHOLE'
  466. 2014-05-05 19:15:14 3508 [Note] Shutting down plugin 'ARCHIVE'
  467. 2014-05-05 19:15:14 3508 [Note] Shutting down plugin 'MRG_MYISAM'
  468. 2014-05-05 19:15:14 3508 [Note] Shutting down plugin 'MyISAM'
  469. 2014-05-05 19:15:14 3508 [Note] Shutting down plugin 'MEMORY'
  470. 2014-05-05 19:15:14 3508 [Note] Shutting down plugin 'CSV'
  471. 2014-05-05 19:15:14 3508 [Note] Shutting down plugin 'sha256_password'
  472. 2014-05-05 19:15:14 3508 [Note] Shutting down plugin 'mysql_old_password'
  473. 2014-05-05 19:15:14 3508 [Note] Shutting down plugin 'mysql_native_password'
  474. 2014-05-05 19:15:14 3508 [Note] Shutting down plugin 'binlog'
  475. 2014-05-05 19:15:14 3508 [Note] mysql\bin\mysqld.exe: Shutdown complete
  476.  
  477. 2014-05-05 19:15:20 2644 [Warning] You need to use --log-bin to make --binlog-format work.
  478. 2014-05-05 19:15:20 2644 [Note] Plugin 'FEDERATED' is disabled.
  479. 2014-05-05 19:15:20 2644 [Note] InnoDB: Using atomics to ref count buffer pool pages
  480. 2014-05-05 19:15:20 2644 [Note] InnoDB: The InnoDB memory heap is disabled
  481. 2014-05-05 19:15:20 2644 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  482. 2014-05-05 19:15:20 2644 [Note] InnoDB: Compressed tables use zlib 1.2.3
  483. 2014-05-05 19:15:20 2644 [Note] InnoDB: Not using CPU crc32 instructions
  484. 2014-05-05 19:15:20 2644 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  485. 2014-05-05 19:15:20 2644 [Note] InnoDB: Completed initialization of buffer pool
  486. 2014-05-05 19:15:20 2644 [Note] InnoDB: Highest supported file format is Barracuda.
  487. 2014-05-05 19:15:21 2644 [Note] InnoDB: 128 rollback segment(s) are active.
  488. 2014-05-05 19:15:21 2644 [Note] InnoDB: Waiting for purge to start
  489. 2014-05-05 19:15:21 2644 [Note] InnoDB: 5.6.16 started; log sequence number 1600667
  490. 2014-05-05 19:15:21 2644 [Note] Server hostname (bind-address): '*'; port: 3306
  491. 2014-05-05 19:15:23 2644 [Note] IPv6 is not available.
  492. 2014-05-05 19:15:23 2644 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  493. 2014-05-05 19:15:23 2644 [Note] Server socket created on IP: '0.0.0.0'.
  494. 2014-05-05 19:15:23 2644 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  495. 2014-05-05 19:15:23 2644 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
  496. 2014-05-05 19:15:23 2644 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  497. 2014-05-05 19:15:23 2644 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  498. 2014-05-05 19:15:23 2644 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
  499. 2014-05-05 19:15:23 2644 [Note] Event Scheduler: Loaded 0 events
  500. 2014-05-05 19:15:23 2644 [Note] mysql\bin\mysqld.exe: ready for connections.
  501. Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
  502. 2014-05-05 19:33:41 2644 [Note] mysql\bin\mysqld.exe: Normal shutdown
  503.  
  504. 2014-05-05 19:33:41 2644 [Note] Giving 0 client threads a chance to die gracefully
  505. 2014-05-05 19:33:41 2644 [Note] Event Scheduler: Purging the queue. 0 events
  506. 2014-05-05 19:33:41 2644 [Note] Shutting down slave threads
  507. 2014-05-05 19:33:41 2644 [Note] Forcefully disconnecting 0 remaining clients
  508. 2014-05-05 19:33:41 2644 [Note] Binlog end
  509. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'partition'
  510. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  511. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  512. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  513. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  514. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  515. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  516. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  517. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  518. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  519. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  520. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  521. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  522. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  523. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  524. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  525. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  526. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_METRICS'
  527. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  528. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  529. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  530. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  531. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  532. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  533. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_CMPMEM'
  534. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  535. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_CMP'
  536. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  537. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_LOCKS'
  538. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'INNODB_TRX'
  539. 2014-05-05 19:33:41 2644 [Note] Shutting down plugin 'InnoDB'
  540. 2014-05-05 19:33:41 2644 [Note] InnoDB: FTS optimize thread exiting.
  541. 2014-05-05 19:33:41 2644 [Note] InnoDB: Starting shutdown...
  542. 2014-05-05 19:33:42 2644 [Note] InnoDB: Shutdown completed; log sequence number 1600677
  543. 2014-05-05 19:33:42 2644 [Note] Shutting down plugin 'BLACKHOLE'
  544. 2014-05-05 19:33:42 2644 [Note] Shutting down plugin 'ARCHIVE'
  545. 2014-05-05 19:33:42 2644 [Note] Shutting down plugin 'MRG_MYISAM'
  546. 2014-05-05 19:33:42 2644 [Note] Shutting down plugin 'MyISAM'
  547. 2014-05-05 19:33:42 2644 [Note] Shutting down plugin 'MEMORY'
  548. 2014-05-05 19:33:42 2644 [Note] Shutting down plugin 'CSV'
  549. 2014-05-05 19:33:42 2644 [Note] Shutting down plugin 'sha256_password'
  550. 2014-05-05 19:33:42 2644 [Note] Shutting down plugin 'mysql_old_password'
  551. 2014-05-05 19:33:42 2644 [Note] Shutting down plugin 'mysql_native_password'
  552. 2014-05-05 19:33:42 2644 [Note] Shutting down plugin 'binlog'
  553. 2014-05-05 19:33:42 2644 [Note] mysql\bin\mysqld.exe: Shutdown complete
  554.  
  555. 2014-05-05 19:33:47 4012 [Warning] You need to use --log-bin to make --binlog-format work.
  556. 2014-05-05 19:33:47 4012 [Note] Plugin 'FEDERATED' is disabled.
  557. 2014-05-05 19:33:47 4012 [Note] InnoDB: Using atomics to ref count buffer pool pages
  558. 2014-05-05 19:33:47 4012 [Note] InnoDB: The InnoDB memory heap is disabled
  559. 2014-05-05 19:33:47 4012 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  560. 2014-05-05 19:33:47 4012 [Note] InnoDB: Compressed tables use zlib 1.2.3
  561. 2014-05-05 19:33:47 4012 [Note] InnoDB: Not using CPU crc32 instructions
  562. 2014-05-05 19:33:47 4012 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  563. 2014-05-05 19:33:47 4012 [Note] InnoDB: Completed initialization of buffer pool
  564. 2014-05-05 19:33:47 4012 [Note] InnoDB: Highest supported file format is Barracuda.
  565. 2014-05-05 19:33:48 4012 [Note] InnoDB: 128 rollback segment(s) are active.
  566. 2014-05-05 19:33:48 4012 [Note] InnoDB: Waiting for purge to start
  567. 2014-05-05 19:33:48 4012 [Note] InnoDB: 5.6.16 started; log sequence number 1600677
  568. 2014-05-05 19:33:48 4012 [Note] Server hostname (bind-address): '*'; port: 3306
  569. 2014-05-05 19:33:50 4012 [Note] IPv6 is not available.
  570. 2014-05-05 19:33:50 4012 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  571. 2014-05-05 19:33:50 4012 [Note] Server socket created on IP: '0.0.0.0'.
  572. 2014-05-05 19:33:50 4012 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  573. 2014-05-05 19:33:50 4012 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
  574. 2014-05-05 19:33:50 4012 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  575. 2014-05-05 19:33:50 4012 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
  576. 2014-05-05 19:33:50 4012 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
  577. 2014-05-05 19:33:50 4012 [Note] Event Scheduler: Loaded 0 events
  578. 2014-05-05 19:33:50 4012 [Note] mysql\bin\mysqld.exe: ready for connections.
  579. Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
  580. 2014-05-05 21:58:27 d5c InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
  581. 2014-05-05 21:58:36 cd0 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
  582. 2014-05-05 21:58:36 cd0 InnoDB: Error: Fetch of persistent statistics requested for table "wp20"."wp_yarpp_related_cache" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
  583. 2014-05-05 22:04:34 d5c InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
  584. 2014-05-05 22:04:34 d5c InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
  585. 2014-05-05 22:04:34 d5c InnoDB: Error: Fetch of persistent statistics requested for table "wp182"."wp_yarpp_related_cache" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
  586. 2014-05-06 00:41:07 820 [Warning] You need to use --log-bin to make --binlog-format work.
  587. 2014-05-06 00:41:07 820 [Note] Plugin 'FEDERATED' is disabled.
  588. 2014-05-06 00:41:07 820 [Note] InnoDB: Using atomics to ref count buffer pool pages
  589. 2014-05-06 00:41:07 820 [Note] InnoDB: The InnoDB memory heap is disabled
  590. 2014-05-06 00:41:07 820 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  591. 2014-05-06 00:41:07 820 [Note] InnoDB: Compressed tables use zlib 1.2.3
  592. 2014-05-06 00:41:07 820 [Note] InnoDB: Not using CPU crc32 instructions
  593. 2014-05-06 00:41:07 820 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  594. 2014-05-06 00:41:07 820 [Note] InnoDB: Completed initialization of buffer pool
  595. 2014-05-06 00:41:07 820 [Note] InnoDB: Highest supported file format is Barracuda.
  596. 2014-05-06 00:41:08 820 [Note] InnoDB: The log sequence numbers 1600677 and 1600677 in ibdata files do not match the log sequence number 1614525 in the ib_logfiles!
  597. 2014-05-06 00:41:08 820 [Note] InnoDB: Database was not shutdown normally!
  598. 2014-05-06 00:41:08 820 [Note] InnoDB: Starting crash recovery.
  599. 2014-05-06 00:41:08 820 [Note] InnoDB: Reading tablespace information from the .ibd files...
  600. 2014-05-06 00:41:08 820 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd. Cannot open tablespace wp182/wp_yarpp_related_cache which uses space ID: 2 at filepath: .\wp182\wp_yarpp_related_cache.ibd
  601. 2014-05-06 00:41:08 324 InnoDB: Operating system error number 997 in a file operation.
  602. InnoDB: Some operating system error numbers are described at
  603. InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
  604. InnoDB: Error: could not open single-table tablespace file .\wp182\wp_yarpp_related_cache.ibd
  605. InnoDB: We do not continue the crash recovery, because the table may become
  606. InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
  607. InnoDB: To fix the problem and start mysqld:
  608. InnoDB: 1) If there is a permission problem in the file and mysqld cannot
  609. InnoDB: open the file, you should modify the permissions.
  610. InnoDB: 2) If the table is not needed, or you can restore it from a backup,
  611. InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
  612. InnoDB: crash recovery and ignore that table.
  613. InnoDB: 3) If the file system or the disk is broken, and you cannot remove
  614. InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
  615. InnoDB: and force InnoDB to continue crash recovery here.
  616. 2014-05-06 01:13:25 1320 [Warning] You need to use --log-bin to make --binlog-format work.
  617. 2014-05-06 01:13:25 1320 [Note] Plugin 'FEDERATED' is disabled.
  618. 2014-05-06 01:13:25 1320 [Note] InnoDB: Using atomics to ref count buffer pool pages
  619. 2014-05-06 01:13:25 1320 [Note] InnoDB: The InnoDB memory heap is disabled
  620. 2014-05-06 01:13:25 1320 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  621. 2014-05-06 01:13:25 1320 [Note] InnoDB: Compressed tables use zlib 1.2.3
  622. 2014-05-06 01:13:25 1320 [Note] InnoDB: Not using CPU crc32 instructions
  623. 2014-05-06 01:13:25 1320 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  624. 2014-05-06 01:13:25 1320 [Note] InnoDB: Completed initialization of buffer pool
  625. 2014-05-06 01:13:25 1320 [Note] InnoDB: Highest supported file format is Barracuda.
  626. 2014-05-06 01:13:25 1320 [Note] InnoDB: The log sequence numbers 1600677 and 1600677 in ibdata files do not match the log sequence number 1614525 in the ib_logfiles!
  627. 2014-05-06 01:13:25 1320 [Note] InnoDB: Database was not shutdown normally!
  628. 2014-05-06 01:13:25 1320 [Note] InnoDB: Starting crash recovery.
  629. 2014-05-06 01:13:25 1320 [Note] InnoDB: Reading tablespace information from the .ibd files...
  630. 2014-05-06 01:13:26 1320 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd. Cannot open tablespace wp182/wp_yarpp_related_cache which uses space ID: 2 at filepath: .\wp182\wp_yarpp_related_cache.ibd
  631. 2014-05-06 01:13:26 f20 InnoDB: Operating system error number 997 in a file operation.
  632. InnoDB: Some operating system error numbers are described at
  633. InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
  634. InnoDB: Error: could not open single-table tablespace file .\wp182\wp_yarpp_related_cache.ibd
  635. InnoDB: We do not continue the crash recovery, because the table may become
  636. InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
  637. InnoDB: To fix the problem and start mysqld:
  638. InnoDB: 1) If there is a permission problem in the file and mysqld cannot
  639. InnoDB: open the file, you should modify the permissions.
  640. InnoDB: 2) If the table is not needed, or you can restore it from a backup,
  641. InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
  642. InnoDB: crash recovery and ignore that table.
  643. InnoDB: 3) If the file system or the disk is broken, and you cannot remove
  644. InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
  645. InnoDB: and force InnoDB to continue crash recovery here.
  646. 2014-05-06 01:13:28 2844 [Warning] You need to use --log-bin to make --binlog-format work.
  647. 2014-05-06 01:13:28 2844 [Note] Plugin 'FEDERATED' is disabled.
  648. 2014-05-06 01:13:28 2844 [Note] InnoDB: Using atomics to ref count buffer pool pages
  649. 2014-05-06 01:13:28 2844 [Note] InnoDB: The InnoDB memory heap is disabled
  650. 2014-05-06 01:13:28 2844 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  651. 2014-05-06 01:13:28 2844 [Note] InnoDB: Compressed tables use zlib 1.2.3
  652. 2014-05-06 01:13:28 2844 [Note] InnoDB: Not using CPU crc32 instructions
  653. 2014-05-06 01:13:28 2844 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  654. 2014-05-06 01:13:28 2844 [Note] InnoDB: Completed initialization of buffer pool
  655. 2014-05-06 01:13:28 2844 [Note] InnoDB: Highest supported file format is Barracuda.
  656. 2014-05-06 01:13:28 2844 [Note] InnoDB: The log sequence numbers 1600677 and 1600677 in ibdata files do not match the log sequence number 1614525 in the ib_logfiles!
  657. 2014-05-06 01:13:28 2844 [Note] InnoDB: Database was not shutdown normally!
  658. 2014-05-06 01:13:28 2844 [Note] InnoDB: Starting crash recovery.
  659. 2014-05-06 01:13:28 2844 [Note] InnoDB: Reading tablespace information from the .ibd files...
  660. 2014-05-06 01:13:29 2844 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd. Cannot open tablespace wp182/wp_yarpp_related_cache which uses space ID: 2 at filepath: .\wp182\wp_yarpp_related_cache.ibd
  661. 2014-05-06 01:13:29 b20 InnoDB: Operating system error number 997 in a file operation.
  662. InnoDB: Some operating system error numbers are described at
  663. InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
  664. InnoDB: Error: could not open single-table tablespace file .\wp182\wp_yarpp_related_cache.ibd
  665. InnoDB: We do not continue the crash recovery, because the table may become
  666. InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
  667. InnoDB: To fix the problem and start mysqld:
  668. InnoDB: 1) If there is a permission problem in the file and mysqld cannot
  669. InnoDB: open the file, you should modify the permissions.
  670. InnoDB: 2) If the table is not needed, or you can restore it from a backup,
  671. InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
  672. InnoDB: crash recovery and ignore that table.
  673. InnoDB: 3) If the file system or the disk is broken, and you cannot remove
  674. InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
  675. InnoDB: and force InnoDB to continue crash recovery here.
  676. 2014-05-06 09:35:33 640 [Warning] You need to use --log-bin to make --binlog-format work.
  677. 2014-05-06 09:35:33 640 [Note] Plugin 'FEDERATED' is disabled.
  678. 2014-05-06 09:35:33 640 [Note] InnoDB: Using atomics to ref count buffer pool pages
  679. 2014-05-06 09:35:33 640 [Note] InnoDB: The InnoDB memory heap is disabled
  680. 2014-05-06 09:35:33 640 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  681. 2014-05-06 09:35:33 640 [Note] InnoDB: Compressed tables use zlib 1.2.3
  682. 2014-05-06 09:35:33 640 [Note] InnoDB: Not using CPU crc32 instructions
  683. 2014-05-06 09:35:33 640 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  684. 2014-05-06 09:35:33 640 [Note] InnoDB: Completed initialization of buffer pool
  685. 2014-05-06 09:35:34 640 [Note] InnoDB: Highest supported file format is Barracuda.
  686. 2014-05-06 09:35:34 640 [Note] InnoDB: The log sequence numbers 1600677 and 1600677 in ibdata files do not match the log sequence number 1614525 in the ib_logfiles!
  687. 2014-05-06 09:35:34 640 [Note] InnoDB: Database was not shutdown normally!
  688. 2014-05-06 09:35:34 640 [Note] InnoDB: Starting crash recovery.
  689. 2014-05-06 09:35:34 640 [Note] InnoDB: Reading tablespace information from the .ibd files...
  690. 2014-05-06 09:35:35 640 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd. Cannot open tablespace wp182/wp_yarpp_related_cache which uses space ID: 2 at filepath: .\wp182\wp_yarpp_related_cache.ibd
  691. 2014-05-06 09:35:35 338 InnoDB: Operating system error number 997 in a file operation.
  692. InnoDB: Some operating system error numbers are described at
  693. InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
  694. InnoDB: Error: could not open single-table tablespace file .\wp182\wp_yarpp_related_cache.ibd
  695. InnoDB: We do not continue the crash recovery, because the table may become
  696. InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
  697. InnoDB: To fix the problem and start mysqld:
  698. InnoDB: 1) If there is a permission problem in the file and mysqld cannot
  699. InnoDB: open the file, you should modify the permissions.
  700. InnoDB: 2) If the table is not needed, or you can restore it from a backup,
  701. InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
  702. InnoDB: crash recovery and ignore that table.
  703. InnoDB: 3) If the file system or the disk is broken, and you cannot remove
  704. InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
  705. InnoDB: and force InnoDB to continue crash recovery here.
  706. 2014-05-06 09:35:40 2248 [Warning] You need to use --log-bin to make --binlog-format work.
  707. 2014-05-06 09:35:40 2248 [Note] Plugin 'FEDERATED' is disabled.
  708. 2014-05-06 09:35:40 2248 [Note] InnoDB: Using atomics to ref count buffer pool pages
  709. 2014-05-06 09:35:40 2248 [Note] InnoDB: The InnoDB memory heap is disabled
  710. 2014-05-06 09:35:40 2248 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  711. 2014-05-06 09:35:40 2248 [Note] InnoDB: Compressed tables use zlib 1.2.3
  712. 2014-05-06 09:35:40 2248 [Note] InnoDB: Not using CPU crc32 instructions
  713. 2014-05-06 09:35:40 2248 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  714. 2014-05-06 09:35:40 2248 [Note] InnoDB: Completed initialization of buffer pool
  715. 2014-05-06 09:35:40 2248 [Note] InnoDB: Highest supported file format is Barracuda.
  716. 2014-05-06 09:35:42 2248 [Note] InnoDB: The log sequence numbers 1600677 and 1600677 in ibdata files do not match the log sequence number 1614525 in the ib_logfiles!
  717. 2014-05-06 09:35:42 2248 [Note] InnoDB: Database was not shutdown normally!
  718. 2014-05-06 09:35:42 2248 [Note] InnoDB: Starting crash recovery.
  719. 2014-05-06 09:35:42 2248 [Note] InnoDB: Reading tablespace information from the .ibd files...
  720. 2014-05-06 09:35:43 2248 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd. Cannot open tablespace wp182/wp_yarpp_related_cache which uses space ID: 2 at filepath: .\wp182\wp_yarpp_related_cache.ibd
  721. 2014-05-06 09:35:43 8cc InnoDB: Operating system error number 997 in a file operation.
  722. InnoDB: Some operating system error numbers are described at
  723. InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
  724. InnoDB: Error: could not open single-table tablespace file .\wp182\wp_yarpp_related_cache.ibd
  725. InnoDB: We do not continue the crash recovery, because the table may become
  726. InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
  727. InnoDB: To fix the problem and start mysqld:
  728. InnoDB: 1) If there is a permission problem in the file and mysqld cannot
  729. InnoDB: open the file, you should modify the permissions.
  730. InnoDB: 2) If the table is not needed, or you can restore it from a backup,
  731. InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
  732. InnoDB: crash recovery and ignore that table.
  733. InnoDB: 3) If the file system or the disk is broken, and you cannot remove
  734. InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
  735. InnoDB: and force InnoDB to continue crash recovery here.
  736. 2014-05-06 09:36:53 4048 [Warning] You need to use --log-bin to make --binlog-format work.
  737. 2014-05-06 09:36:53 4048 [Note] Plugin 'FEDERATED' is disabled.
  738. 2014-05-06 09:36:53 4048 [Note] InnoDB: Using atomics to ref count buffer pool pages
  739. 2014-05-06 09:36:53 4048 [Note] InnoDB: The InnoDB memory heap is disabled
  740. 2014-05-06 09:36:53 4048 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  741. 2014-05-06 09:36:53 4048 [Note] InnoDB: Compressed tables use zlib 1.2.3
  742. 2014-05-06 09:36:53 4048 [Note] InnoDB: Not using CPU crc32 instructions
  743. 2014-05-06 09:36:53 4048 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  744. 2014-05-06 09:36:53 4048 [Note] InnoDB: Completed initialization of buffer pool
  745. 2014-05-06 09:36:53 4048 [Note] InnoDB: Highest supported file format is Barracuda.
  746. 2014-05-06 09:36:53 4048 [Note] InnoDB: The log sequence numbers 1600677 and 1600677 in ibdata files do not match the log sequence number 1614525 in the ib_logfiles!
  747. 2014-05-06 09:36:53 4048 [Note] InnoDB: Database was not shutdown normally!
  748. 2014-05-06 09:36:53 4048 [Note] InnoDB: Starting crash recovery.
  749. 2014-05-06 09:36:53 4048 [Note] InnoDB: Reading tablespace information from the .ibd files...
  750. 2014-05-06 09:36:53 4048 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd. Cannot open tablespace wp182/wp_yarpp_related_cache which uses space ID: 2 at filepath: .\wp182\wp_yarpp_related_cache.ibd
  751. 2014-05-06 09:36:53 fd4 InnoDB: Operating system error number 997 in a file operation.
  752. InnoDB: Some operating system error numbers are described at
  753. InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
  754. InnoDB: Error: could not open single-table tablespace file .\wp182\wp_yarpp_related_cache.ibd
  755. InnoDB: We do not continue the crash recovery, because the table may become
  756. InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
  757. InnoDB: To fix the problem and start mysqld:
  758. InnoDB: 1) If there is a permission problem in the file and mysqld cannot
  759. InnoDB: open the file, you should modify the permissions.
  760. InnoDB: 2) If the table is not needed, or you can restore it from a backup,
  761. InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
  762. InnoDB: crash recovery and ignore that table.
  763. InnoDB: 3) If the file system or the disk is broken, and you cannot remove
  764. InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
  765. InnoDB: and force InnoDB to continue crash recovery here.
  766. 2014-05-06 09:38:41 180 [Warning] You need to use --log-bin to make --binlog-format work.
  767. 2014-05-06 09:38:41 180 [Note] Plugin 'FEDERATED' is disabled.
  768. 2014-05-06 09:38:41 180 [Note] InnoDB: Using atomics to ref count buffer pool pages
  769. 2014-05-06 09:38:41 180 [Note] InnoDB: The InnoDB memory heap is disabled
  770. 2014-05-06 09:38:41 180 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  771. 2014-05-06 09:38:41 180 [Note] InnoDB: Compressed tables use zlib 1.2.3
  772. 2014-05-06 09:38:41 180 [Note] InnoDB: Not using CPU crc32 instructions
  773. 2014-05-06 09:38:41 180 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  774. 2014-05-06 09:38:41 180 [Note] InnoDB: Completed initialization of buffer pool
  775. 2014-05-06 09:38:41 180 [Note] InnoDB: Highest supported file format is Barracuda.
  776. 2014-05-06 09:38:41 180 [Note] InnoDB: The log sequence numbers 1600677 and 1600677 in ibdata files do not match the log sequence number 1614525 in the ib_logfiles!
  777. 2014-05-06 09:38:41 180 [Note] InnoDB: Database was not shutdown normally!
  778. 2014-05-06 09:38:41 180 [Note] InnoDB: Starting crash recovery.
  779. 2014-05-06 09:38:41 180 [Note] InnoDB: Reading tablespace information from the .ibd files...
  780. 2014-05-06 09:38:41 180 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd. Cannot open tablespace wp182/wp_yarpp_related_cache which uses space ID: 2 at filepath: .\wp182\wp_yarpp_related_cache.ibd
  781. 2014-05-06 09:38:41 670 InnoDB: Operating system error number 997 in a file operation.
  782. InnoDB: Some operating system error numbers are described at
  783. InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
  784. InnoDB: Error: could not open single-table tablespace file .\wp182\wp_yarpp_related_cache.ibd
  785. InnoDB: We do not continue the crash recovery, because the table may become
  786. InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
  787. InnoDB: To fix the problem and start mysqld:
  788. InnoDB: 1) If there is a permission problem in the file and mysqld cannot
  789. InnoDB: open the file, you should modify the permissions.
  790. InnoDB: 2) If the table is not needed, or you can restore it from a backup,
  791. InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
  792. InnoDB: crash recovery and ignore that table.
  793. InnoDB: 3) If the file system or the disk is broken, and you cannot remove
  794. InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
  795. InnoDB: and force InnoDB to continue crash recovery here.
  796. 2014-05-06 09:38:44 160 [Warning] You need to use --log-bin to make --binlog-format work.
  797. 2014-05-06 09:38:44 160 [Note] Plugin 'FEDERATED' is disabled.
  798. 2014-05-06 09:38:44 160 [Note] InnoDB: Using atomics to ref count buffer pool pages
  799. 2014-05-06 09:38:44 160 [Note] InnoDB: The InnoDB memory heap is disabled
  800. 2014-05-06 09:38:44 160 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  801. 2014-05-06 09:38:44 160 [Note] InnoDB: Compressed tables use zlib 1.2.3
  802. 2014-05-06 09:38:44 160 [Note] InnoDB: Not using CPU crc32 instructions
  803. 2014-05-06 09:38:44 160 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  804. 2014-05-06 09:38:44 160 [Note] InnoDB: Completed initialization of buffer pool
  805. 2014-05-06 09:38:44 160 [Note] InnoDB: Highest supported file format is Barracuda.
  806. 2014-05-06 09:38:44 160 [Note] InnoDB: The log sequence numbers 1600677 and 1600677 in ibdata files do not match the log sequence number 1614525 in the ib_logfiles!
  807. 2014-05-06 09:38:44 160 [Note] InnoDB: Database was not shutdown normally!
  808. 2014-05-06 09:38:44 160 [Note] InnoDB: Starting crash recovery.
  809. 2014-05-06 09:38:44 160 [Note] InnoDB: Reading tablespace information from the .ibd files...
  810. 2014-05-06 09:38:44 160 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd. Cannot open tablespace wp182/wp_yarpp_related_cache which uses space ID: 2 at filepath: .\wp182\wp_yarpp_related_cache.ibd
  811. 2014-05-06 09:38:44 ac InnoDB: Operating system error number 997 in a file operation.
  812. InnoDB: Some operating system error numbers are described at
  813. InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
  814. InnoDB: Error: could not open single-table tablespace file .\wp182\wp_yarpp_related_cache.ibd
  815. InnoDB: We do not continue the crash recovery, because the table may become
  816. InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
  817. InnoDB: To fix the problem and start mysqld:
  818. InnoDB: 1) If there is a permission problem in the file and mysqld cannot
  819. InnoDB: open the file, you should modify the permissions.
  820. InnoDB: 2) If the table is not needed, or you can restore it from a backup,
  821. InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
  822. InnoDB: crash recovery and ignore that table.
  823. InnoDB: 3) If the file system or the disk is broken, and you cannot remove
  824. InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
  825. InnoDB: and force InnoDB to continue crash recovery here.
  826. 2014-05-06 09:48:39 1060 [Warning] You need to use --log-bin to make --binlog-format work.
  827. 2014-05-06 09:48:39 1060 [Note] Plugin 'FEDERATED' is disabled.
  828. 2014-05-06 09:48:39 1060 [Note] InnoDB: Using atomics to ref count buffer pool pages
  829. 2014-05-06 09:48:39 1060 [Note] InnoDB: The InnoDB memory heap is disabled
  830. 2014-05-06 09:48:39 1060 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  831. 2014-05-06 09:48:39 1060 [Note] InnoDB: Compressed tables use zlib 1.2.3
  832. 2014-05-06 09:48:39 1060 [Note] InnoDB: Not using CPU crc32 instructions
  833. 2014-05-06 09:48:39 1060 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  834. 2014-05-06 09:48:39 1060 [Note] InnoDB: Completed initialization of buffer pool
  835. 2014-05-06 09:48:39 1060 [Note] InnoDB: Highest supported file format is Barracuda.
  836. 2014-05-06 09:48:39 1060 [Note] InnoDB: The log sequence numbers 1600677 and 1600677 in ibdata files do not match the log sequence number 1614525 in the ib_logfiles!
  837. 2014-05-06 09:48:39 1060 [Note] InnoDB: Database was not shutdown normally!
  838. 2014-05-06 09:48:39 1060 [Note] InnoDB: Starting crash recovery.
  839. 2014-05-06 09:48:39 1060 [Note] InnoDB: Reading tablespace information from the .ibd files...
  840. 2014-05-06 09:48:39 1060 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd. Cannot open tablespace wp182/wp_yarpp_related_cache which uses space ID: 2 at filepath: .\wp182\wp_yarpp_related_cache.ibd
  841. 2014-05-06 09:48:39 c78 InnoDB: Operating system error number 997 in a file operation.
  842. InnoDB: Some operating system error numbers are described at
  843. InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
  844. InnoDB: Error: could not open single-table tablespace file .\wp182\wp_yarpp_related_cache.ibd
  845. InnoDB: We do not continue the crash recovery, because the table may become
  846. InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
  847. InnoDB: To fix the problem and start mysqld:
  848. InnoDB: 1) If there is a permission problem in the file and mysqld cannot
  849. InnoDB: open the file, you should modify the permissions.
  850. InnoDB: 2) If the table is not needed, or you can restore it from a backup,
  851. InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
  852. InnoDB: crash recovery and ignore that table.
  853. InnoDB: 3) If the file system or the disk is broken, and you cannot remove
  854. InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
  855. InnoDB: and force InnoDB to continue crash recovery here.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!