API tools faq
paste
Advertisement
Guest User

log mysql

a guest
Aug 28th, 2014
284
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 12.28 KB | None | 0 0
raw download clone embed print report
  1. 140828  0:04:02 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
  2. 140828  0:04:02 [Note] Plugin 'FEDERATED' is disabled.
  3. 140828  0:04:02 InnoDB: The InnoDB memory heap is disabled
  4. 140828  0:04:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  5. 140828  0:04:02 InnoDB: Compressed tables use zlib 1.2.3.4
  6. 140828  0:04:02 InnoDB: Initializing buffer pool, size = 128.0M
  7. 140828  0:04:02 InnoDB: Completed initialization of buffer pool
  8. InnoDB: The first specified data file ./ibdata1 did not exist:
  9. InnoDB: a new database to be created!
  10. 140828  0:04:02  InnoDB: Setting file ./ibdata1 size to 10 MB
  11. InnoDB: Database physically writes the file full: wait...
  12. 140828  0:04:02  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
  13. InnoDB: Setting log file ./ib_logfile0 size to 5 MB
  14. InnoDB: Database physically writes the file full: wait...
  15. 140828  0:04:02  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
  16. InnoDB: Setting log file ./ib_logfile1 size to 5 MB
  17. InnoDB: Database physically writes the file full: wait...
  18. InnoDB: Doublewrite buffer not found: creating new
  19. InnoDB: Doublewrite buffer created
  20. InnoDB: 127 rollback segment(s) active.
  21. InnoDB: Creating foreign key constraint system tables
  22. InnoDB: Foreign key constraint system tables created
  23. 140828  0:04:03  InnoDB: Waiting for the background threads to start
  24. 140828  0:04:04 InnoDB: 5.5.38 started; log sequence number 0
  25. 140828  0:04:04  InnoDB: Starting shutdown...
  26. 140828  0:04:05  InnoDB: Shutdown completed; log sequence number 1595675
  27. 140828  0:04:05 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
  28. 140828  0:04:05 [Note] Plugin 'FEDERATED' is disabled.
  29. 140828  0:04:05 InnoDB: The InnoDB memory heap is disabled
  30. 140828  0:04:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  31. 140828  0:04:05 InnoDB: Compressed tables use zlib 1.2.3.4
  32. 140828  0:04:05 InnoDB: Initializing buffer pool, size = 128.0M
  33. 140828  0:04:05 InnoDB: Completed initialization of buffer pool
  34. 140828  0:04:05 InnoDB: highest supported file format is Barracuda.
  35. 140828  0:04:05  InnoDB: Waiting for the background threads to start
  36. 140828  0:04:06 InnoDB: 5.5.38 started; log sequence number 1595675
  37. 140828  0:04:06  InnoDB: Starting shutdown...
  38. 140828  0:04:07  InnoDB: Shutdown completed; log sequence number 1595675
  39. 140828  0:04:07 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
  40. 140828  0:04:07 [Note] Plugin 'FEDERATED' is disabled.
  41. 140828  0:04:07 InnoDB: The InnoDB memory heap is disabled
  42. 140828  0:04:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  43. 140828  0:04:07 InnoDB: Compressed tables use zlib 1.2.3.4
  44. 140828  0:04:07 InnoDB: Initializing buffer pool, size = 128.0M
  45. 140828  0:04:07 InnoDB: Completed initialization of buffer pool
  46. 140828  0:04:07 InnoDB: highest supported file format is Barracuda.
  47. 140828  0:04:07  InnoDB: Waiting for the background threads to start
  48. 140828  0:04:08 InnoDB: 5.5.38 started; log sequence number 1595675
  49. ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
  50. 140828  0:04:08 [ERROR] Aborting
  51.  
  52. 140828  0:04:08  InnoDB: Starting shutdown...
  53. 140828  0:04:08  InnoDB: Shutdown completed; log sequence number 1595675
  54. 140828  0:04:08 [Note] /usr/sbin/mysqld: Shutdown complete
  55.  
  56. 140828  0:04:08 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
  57. 140828  0:04:08 [Note] Plugin 'FEDERATED' is disabled.
  58. 140828  0:04:08 InnoDB: The InnoDB memory heap is disabled
  59. 140828  0:04:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  60. 140828  0:04:08 InnoDB: Compressed tables use zlib 1.2.3.4
  61. 140828  0:04:08 InnoDB: Initializing buffer pool, size = 128.0M
  62. 140828  0:04:08 InnoDB: Completed initialization of buffer pool
  63. 140828  0:04:08 InnoDB: highest supported file format is Barracuda.
  64. 140828  0:04:09  InnoDB: Waiting for the background threads to start
  65. 140828  0:04:10 InnoDB: 5.5.38 started; log sequence number 1595675
  66. 140828  0:04:10  InnoDB: Starting shutdown...
  67. 140828  0:04:10  InnoDB: Shutdown completed; log sequence number 1595675
  68. 140828  0:04:10 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
  69. 140828  0:04:10 [Note] Plugin 'FEDERATED' is disabled.
  70. 140828  0:04:10 InnoDB: The InnoDB memory heap is disabled
  71. 140828  0:04:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  72. 140828  0:04:10 InnoDB: Compressed tables use zlib 1.2.3.4
  73. 140828  0:04:10 InnoDB: Initializing buffer pool, size = 128.0M
  74. 140828  0:04:10 InnoDB: Completed initialization of buffer pool
  75. 140828  0:04:10 InnoDB: highest supported file format is Barracuda.
  76. 140828  0:04:10  InnoDB: Waiting for the background threads to start
  77. 140828  0:04:11 InnoDB: 5.5.38 started; log sequence number 1595675
  78. ERROR: 1050  Table 'plugin' already exists
  79. 140828  0:04:11 [ERROR] Aborting
  80.  
  81. 140828  0:04:11  InnoDB: Starting shutdown...
  82. 140828  0:04:12  InnoDB: Shutdown completed; log sequence number 1595675
  83. 140828  0:04:12 [Note] /usr/sbin/mysqld: Shutdown complete
  84.  
  85. 140828  0:04:12 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
  86. 140828  0:04:12 [Note] Plugin 'FEDERATED' is disabled.
  87. 140828  0:04:12 InnoDB: The InnoDB memory heap is disabled
  88. 140828  0:04:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  89. 140828  0:04:12 InnoDB: Compressed tables use zlib 1.2.3.4
  90. 140828  0:04:12 InnoDB: Initializing buffer pool, size = 128.0M
  91. 140828  0:04:12 InnoDB: Completed initialization of buffer pool
  92. 140828  0:04:12 InnoDB: highest supported file format is Barracuda.
  93. 140828  0:04:13  InnoDB: Waiting for the background threads to start
  94. 140828  0:04:14 InnoDB: 5.5.38 started; log sequence number 1595675
  95. 140828  0:04:14 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  96. 140828  0:04:14 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
  97. 140828  0:04:14 [Note] Server socket created on IP: '127.0.0.1'.
  98. 140828  0:04:14 [Note] Event Scheduler: Loaded 0 events
  99. 140828  0:04:14 [Note] /usr/sbin/mysqld: ready for connections.
  100. Version: '5.5.38-0ubuntu0.12.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  101. 140828  4:45:09 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
  102. 140828  4:45:10 [Note] Plugin 'FEDERATED' is disabled.
  103. 140828  4:45:10 InnoDB: The InnoDB memory heap is disabled
  104. 140828  4:45:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  105. 140828  4:45:10 InnoDB: Compressed tables use zlib 1.2.3.4
  106. 140828  4:45:10 InnoDB: Initializing buffer pool, size = 128.0M
  107. 140828  4:45:10 InnoDB: Completed initialization of buffer pool
  108. 140828  4:45:10 InnoDB: highest supported file format is Barracuda.
  109. InnoDB: The log sequence number in ibdata files does not match
  110. InnoDB: the log sequence number in the ib_logfiles!
  111. 140828  4:45:10  InnoDB: Database was not shut down normally!
  112. InnoDB: Starting crash recovery.
  113. InnoDB: Reading tablespace information from the .ibd files...
  114. InnoDB: Restoring possible half-written data pages from the doublewrite
  115. InnoDB: buffer...
  116. 140828  4:45:12  InnoDB: Waiting for the background threads to start
  117. 140828  4:45:13 InnoDB: 5.5.38 started; log sequence number 1598217
  118. 140828  4:45:13 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  119. 140828  4:45:13 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
  120. 140828  4:45:13 [Note] Server socket created on IP: '127.0.0.1'.
  121. 140828  4:45:13 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
  122. 140828  4:45:13 [Warning] Checking table:   './mysql/user'
  123. 140828  4:45:13 [ERROR] 1 client is using or hasn't closed the table properly
  124. 140828  4:45:13 [ERROR] /usr/sbin/mysqld: Table './mysql/db' is marked as crashed and should be repaired
  125. 140828  4:45:13 [Warning] Checking table:   './mysql/db'
  126. 140828  4:45:13 [ERROR] 1 client is using or hasn't closed the table properly
  127. 140828  4:45:15 [Note] Event Scheduler: Loaded 0 events
  128. 140828  4:45:15 [Note] /usr/sbin/mysqld: ready for connections.
  129. Version: '5.5.38-0ubuntu0.12.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  130. 140828  4:45:18 [ERROR] /usr/sbin/mysqld: Table './mysql/proc' is marked as crashed and should be repaired
  131. 140828  4:45:18 [Warning] Checking table:   './mysql/proc'
  132. 140828  4:45:18 [ERROR] /usr/sbin/mysqld: Table './intersango/purses' is marked as crashed and should be repaired
  133. 140828  4:45:18 [Warning] Checking table:   './intersango/purses'
  134. 140828 13:54:42 [Note] /usr/sbin/mysqld: Normal shutdown
  135.  
  136. 140828 13:54:42 [Note] Event Scheduler: Purging the queue. 0 events
  137. 140828 13:54:42  InnoDB: Starting shutdown...
  138. 140828 13:54:43  InnoDB: Shutdown completed; log sequence number 1598217
  139. 140828 13:54:43 [Note] /usr/sbin/mysqld: Shutdown complete
  140.  
  141. 140828 13:55:22 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
  142. 140828 13:55:22 [Note] Plugin 'FEDERATED' is disabled.
  143. 140828 13:55:22 InnoDB: The InnoDB memory heap is disabled
  144. 140828 13:55:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  145. 140828 13:55:22 InnoDB: Compressed tables use zlib 1.2.3.4
  146. 140828 13:55:22 InnoDB: Initializing buffer pool, size = 128.0M
  147. 140828 13:55:22 InnoDB: Completed initialization of buffer pool
  148. 140828 13:55:22 InnoDB: highest supported file format is Barracuda.
  149. 140828 13:55:23  InnoDB: Waiting for the background threads to start
  150. 140828 13:55:24 InnoDB: 5.5.38 started; log sequence number 1598217
  151. 140828 13:55:24 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  152. 140828 13:55:24 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
  153. 140828 13:55:24 [Note] Server socket created on IP: '127.0.0.1'.
  154. 140828 13:55:24 [Note] Event Scheduler: Loaded 0 events
  155. 140828 13:55:24 [Note] /usr/sbin/mysqld: ready for connections.
  156. Version: '5.5.38-0ubuntu0.12.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
  157. 140828 15:13:14 [Note] /usr/sbin/mysqld: Normal shutdown
  158.  
  159. 140828 15:13:14 [Note] Event Scheduler: Purging the queue. 0 events
  160. 140828 15:13:16 [Warning] /usr/sbin/mysqld: Forcing close of thread 55  user: 'root'
  161.  
  162. 140828 15:13:16 [Warning] /usr/sbin/mysqld: Forcing close of thread 54  user: 'root'
  163.  
  164. 140828 15:13:16  InnoDB: Starting shutdown...
  165. 140828 15:13:16  InnoDB: Shutdown completed; log sequence number 1607700
  166. 140828 15:13:16 [Note] /usr/sbin/mysqld: Shutdown complete
  167.  
  168. 140828 15:13:54 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
  169. 140828 15:13:54 [Note] Plugin 'FEDERATED' is disabled.
  170. 140828 20:12:30 InnoDB: The InnoDB memory heap is disabled
  171. 140828 20:12:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  172. 140828 20:12:30 InnoDB: Compressed tables use zlib 1.2.3.4
  173. 140828 20:12:30 InnoDB: Initializing buffer pool, size = 128.0M
  174. 140828 20:12:30 InnoDB: Completed initialization of buffer pool
  175. 140828 20:12:30 InnoDB: highest supported file format is Barracuda.
  176. 140828 20:12:31  InnoDB: Waiting for the background threads to start
  177. 140828 20:12:32 InnoDB: 5.5.38 started; log sequence number 1607700
  178. 140828 20:12:32 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  179. 140828 20:12:32 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
  180. 140828 20:12:32 [Note] Server socket created on IP: '127.0.0.1'.
  181. 140828 20:12:32 [Note] Event Scheduler: Loaded 0 events
  182. 140828 20:12:32 [Note] /usr/sbin/mysqld: ready for connections.
  183. Version: '5.5.38-0ubuntu0.12.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
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!