API tools faq
paste
Advertisement
DonDaniello

/var/log/mysql/mysqld.err

DonDaniello
Mar 19th, 2011
39
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.54 KB | None | 0 0
raw download clone embed print report
  1. 110319 22:00:26 [Note] Plugin 'FEDERATED' is disabled.
  2. 110319 22:00:26 [Warning] option 'innodb-buffer-pool-size': signed value 8388608 adjusted to 33554432
  3. InnoDB: The InnoDB memory heap is disabled
  4. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  5. InnoDB: Compressed tables use zlib 1.2.3.3
  6. 110319 22:00:26 InnoDB: Initializing buffer pool, size = 32.0M
  7. 110319 22:00:26 InnoDB: Completed initialization of buffer pool
  8. InnoDB: The first specified data file /var/lib/mysql/ibdata1 did not exist:
  9. InnoDB: a new database to be created!
  10. 110319 22:00:26 InnoDB: Setting file /var/lib/mysql/ibdata1 size to 10 MB
  11. InnoDB: Database physically writes the file full: wait...
  12. 110319 22:00:29 InnoDB: Log file /var/lib/mysql/ib_logfile0 did not exist: new to be created
  13. InnoDB: Setting log file /var/lib/mysql/ib_logfile0 size to 128 MB
  14. InnoDB: Database physically writes the file full: wait...
  15. InnoDB: Progress in MB: 100
  16. 110319 22:00:44 InnoDB: Log file /var/lib/mysql/ib_logfile1 did not exist: new to be created
  17. InnoDB: Setting log file /var/lib/mysql/ib_logfile1 size to 128 MB
  18. InnoDB: Database physically writes the file full: wait...
  19. InnoDB: Progress in MB: 100
  20. 110319 22:00:58 InnoDB: Log file /var/lib/mysql/ib_logfile2 did not exist: new to be created
  21. InnoDB: Setting log file /var/lib/mysql/ib_logfile2 size to 128 MB
  22. InnoDB: Database physically writes the file full: wait...
  23. InnoDB: Progress in MB: 100
  24. 110319 22:01:17 InnoDB: Log file /var/lib/mysql/ib_logfile3 did not exist: new to be created
  25. InnoDB: Setting log file /var/lib/mysql/ib_logfile3 size to 128 MB
  26. InnoDB: Database physically writes the file full: wait...
  27. InnoDB: Progress in MB: 100
  28. InnoDB: Doublewrite buffer not found: creating new
  29. InnoDB: Doublewrite buffer created
  30. InnoDB: Creating foreign key constraint system tables
  31. InnoDB: Foreign key constraint system tables created
  32. 110319 22:01:28 Percona XtraDB (http://www.percona.com) 1.0.15-12.6 started; log sequence number 0
  33. 110319 22:01:32 InnoDB: Starting shutdown...
  34. 110319 22:01:33 InnoDB: Shutdown completed; log sequence number 45342
  35. 110319 22:01:34 [Note] Plugin 'FEDERATED' is disabled.
  36. 110319 22:01:34 [Warning] option 'innodb-buffer-pool-size': signed value 8388608 adjusted to 33554432
  37. InnoDB: The InnoDB memory heap is disabled
  38. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  39. InnoDB: Compressed tables use zlib 1.2.3.3
  40. 110319 22:01:34 InnoDB: Initializing buffer pool, size = 32.0M
  41. 110319 22:01:35 InnoDB: Completed initialization of buffer pool
  42. 110319 22:01:35 InnoDB: highest supported file format is Barracuda.
  43. 110319 22:01:35 Percona XtraDB (http://www.percona.com) 1.0.15-12.6 started; log sequence number 45342
  44. 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
  45. 110319 22:01:36 [ERROR] Aborting
  46.  
  47. 110319 22:01:36 InnoDB: Starting shutdown...
  48. 110319 22:01:36 InnoDB: Shutdown completed; log sequence number 45356
  49. 110319 22:01:36 [Note] /usr/sbin/mysqld: Shutdown complete
  50.  
  51. 110319 22:01:37 [Note] Plugin 'FEDERATED' is disabled.
  52. 110319 22:01:37 [Warning] option 'innodb-buffer-pool-size': signed value 8388608 adjusted to 33554432
  53. InnoDB: The InnoDB memory heap is disabled
  54. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  55. InnoDB: Compressed tables use zlib 1.2.3.3
  56. 110319 22:01:37 InnoDB: Initializing buffer pool, size = 32.0M
  57. 110319 22:01:37 InnoDB: Completed initialization of buffer pool
  58. 110319 22:01:37 InnoDB: highest supported file format is Barracuda.
  59. 110319 22:01:37 Percona XtraDB (http://www.percona.com) 1.0.15-12.6 started; log sequence number 45356
  60. 110319 22:01:38 InnoDB: Starting shutdown...
  61. 110319 22:01:39 InnoDB: Shutdown completed; log sequence number 45356
  62. 110319 22:01:39 [Note] Plugin 'FEDERATED' is disabled.
  63. 110319 22:01:39 [Warning] option 'innodb-buffer-pool-size': signed value 8388608 adjusted to 33554432
  64. InnoDB: The InnoDB memory heap is disabled
  65. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  66. InnoDB: Compressed tables use zlib 1.2.3.3
  67. 110319 22:01:39 InnoDB: Initializing buffer pool, size = 32.0M
  68. 110319 22:01:39 InnoDB: Completed initialization of buffer pool
  69. 110319 22:01:39 InnoDB: highest supported file format is Barracuda.
  70. 110319 22:01:39 Percona XtraDB (http://www.percona.com) 1.0.15-12.6 started; log sequence number 45356
  71. ERROR: 1050 Table 'plugin' already exists
  72. 110319 22:01:40 [ERROR] Aborting
  73.  
  74. 110319 22:01:40 InnoDB: Starting shutdown...
  75. 110319 22:01:40 InnoDB: Shutdown completed; log sequence number 45356
  76. 110319 22:01:40 [Note] /usr/sbin/mysqld: Shutdown complete
  77.  
  78. 110319 22:01:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  79. 110319 22:01:41 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
  80. 110319 22:01:41 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
  81. 110319 22:01:41 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
  82. 110319 22:01:41 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
  83. 110319 22:01:41 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
  84. 110319 22:01:41 [Note] Flashcache bypass: disabled
  85. 110319 22:01:41 [Note] Flashcache setup error is : ioctl failed
  86.  
  87. 110319 22:01:41 [Note] Plugin 'FEDERATED' is disabled.
  88. 110319 22:01:41 [Warning] option 'innodb-buffer-pool-size': signed value 8388608 adjusted to 33554432
  89. InnoDB: The InnoDB memory heap is disabled
  90. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  91. InnoDB: Compressed tables use zlib 1.2.3.3
  92. 110319 22:01:41 InnoDB: Initializing buffer pool, size = 32.0M
  93. 110319 22:01:41 InnoDB: Completed initialization of buffer pool
  94. 110319 22:01:41 InnoDB: highest supported file format is Barracuda.
  95. 110319 22:01:42 Percona XtraDB (http://www.percona.com) 1.0.15-12.6 started; log sequence number 45356
  96. 110319 22:01:42 [Note] Event Scheduler: Loaded 0 events
  97. 110319 22:01:42 [Note] /usr/sbin/mysqld: ready for connections.
  98. Version: '5.1.55-rel12.6-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Percona Server (GPL), 12.6 , Revision 200)
  99.  
  100. Status information:
  101.  
  102. Current dir: /var/lib/mysql/
  103. Running threads: 0 Stack size: 196608
  104. Current locks:
  105. lock: 0x15088e8:
  106.  
  107. lock: 0x153b5c8:
  108.  
  109. lock: 0x14b2c38:
  110.  
  111. lock: 0x143d6c8:
  112.  
  113. lock: 0x1464be8:
  114.  
  115. lock: 0x143c238:
  116.  
  117. lock: 0x1482948:
  118.  
  119. lock: 0x1447fe8:
  120.  
  121. lock: 0x1456228:
  122.  
  123. lock: 0x13fb560:
  124.  
  125. lock: 0x1496d30:
  126.  
  127. lock: 0x14ca7a8:
  128.  
  129. lock: 0x14c82d8:
  130.  
  131. lock: 0x14c5a98:
  132.  
  133. lock: 0x14c36b8:
  134.  
  135. lock: 0x14c1338:
  136.  
  137. lock: 0x14ac0b8:
  138.  
  139. lock: 0x14a93c8:
  140.  
  141. lock: 0x14a45c8:
  142.  
  143. lock: 0x14a0188:
  144.  
  145. lock: 0x149cd68:
  146.  
  147. lock: 0x1499688:
  148.  
  149. lock: 0x14756f8:
  150.  
  151.  
  152. Key caches:
  153. default
  154. Buffer_size: 8388608
  155. Block_size: 1024
  156. Division_limit: 100
  157. Age_limit: 300
  158. blocks used: 1
  159. not flushed: 0
  160. w_requests: 40
  161. writes: 10
  162. r_requests: 30
  163. reads: 0
  164.  
  165.  
  166. handler status:
  167. read_key: 0
  168. read_next: 0
  169. read_rnd 0
  170. read_first: 9
  171. write: 1016
  172. delete 0
  173. update: 0
  174.  
  175. Table status:
  176. Opened tables: 264
  177. Open tables: 23
  178. Open files: 49
  179. Open streams: 0
  180.  
  181. Alarm status:
  182. Active alarms: 0
  183. Max used alarms: 1
  184. Next alarm time: 0
  185.  
  186. Begin safemalloc memory dump:
  187.  
  188. End safemalloc memory dump.
  189.  
  190. Memory status:
  191. Non-mmapped space allocated from system: 9454024
  192. Number of free chunks: 45
  193. Number of fastbin blocks: 0
  194. Number of mmapped regions: 10
  195. Space in mmapped regions: 14458880
  196. Maximum total allocated space: 0
  197. Space available in freed fastbin blocks: 0
  198. Total allocated space: 7158584
  199. Total free space: 2295440
  200. Top-most, releasable space: 1768704
  201. Estimated memory (with thread stack): 23912904
  202.  
  203.  
  204.  
  205. Events status:
  206. LLA = Last Locked At LUA = Last Unlocked At
  207. WOC = Waiting On Condition DL = Data Locked
  208.  
  209. Event scheduler status:
  210. State : INITIALIZED
  211. Thread id : 0
  212. LLA : n/a:0
  213. LUA : n/a:0
  214. WOC : NO
  215. Workers : 0
  216. Executed : 0
  217. Data locked: NO
  218.  
  219. Event queue status:
  220. Element count : 0
  221. Data locked : NO
  222. Attempting lock : NO
  223. LLA : init_queue:132
  224. LUA : init_queue:142
  225. WOC : NO
  226. Next activation : never
  227. 110319 22:10:42 [Note] /usr/sbin/mysqld: Normal shutdown
  228.  
  229. 110319 22:10:42 [Note] Event Scheduler: Purging the queue. 0 events
  230. 110319 22:10:44 InnoDB: Starting shutdown...
  231. 110319 22:10:45 InnoDB: Shutdown completed; log sequence number 830664
  232. 110319 22:10:45 [Note] /usr/sbin/mysqld: Shutdown complete
  233.  
  234. 110319 22:10:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  235. 110319 22:10:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  236. 110319 22:10:46 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
  237. 110319 22:10:46 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
  238. 110319 22:10:46 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
  239. 110319 22:10:46 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
  240. 110319 22:10:46 [Note] Flashcache bypass: disabled
  241. 110319 22:10:46 [Note] Flashcache setup error is : ioctl failed
  242.  
  243. 110319 22:10:47 [Note] Plugin 'FEDERATED' is disabled.
  244. InnoDB: The InnoDB memory heap is disabled
  245. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  246. InnoDB: Compressed tables use zlib 1.2.3.3
  247. 110319 22:10:48 InnoDB: Initializing buffer pool, size = 1.0G
  248. InnoDB: mmap(1102086144 bytes) failed; errno 12
  249. 110319 22:10:48InnoDB: Fatal error: cannot allocate the memory for the buffer pool
  250. 110319 22:10:48 [ERROR] Plugin 'InnoDB' init function returned error.
  251. 110319 22:10:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  252. 110319 22:10:49 [Warning] 'user' entry 'root@mc-188-165-58-140.ovh.net' ignored in --skip-name-resolve mode.
  253. 110319 22:10:49 [Note] Event Scheduler: Loaded 0 events
  254. 110319 22:10:49 [Note] /usr/sbin/mysqld: ready for connections.
  255. Version: '5.1.55-rel12.6-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Percona Server (GPL), 12.6 , Revision 200)
  256. 110319 22:43:45 [Note] /usr/sbin/mysqld: Normal shutdown
  257.  
  258. 110319 22:43:45 [Note] Event Scheduler: Purging the queue. 0 events
  259. 110319 22:43:45 [Note] /usr/sbin/mysqld: Shutdown complete
  260.  
  261. 110319 22:43:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  262. 110319 22:43:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  263. 110319 22:43:46 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
  264. 110319 22:43:46 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
  265. 110319 22:43:46 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
  266. 110319 22:43:46 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
  267. 110319 22:43:46 [Note] Flashcache bypass: disabled
  268. 110319 22:43:46 [Note] Flashcache setup error is : ioctl failed
  269.  
  270. 110319 22:43:47 [Note] Plugin 'FEDERATED' is disabled.
  271. InnoDB: The InnoDB memory heap is disabled
  272. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  273. InnoDB: Compressed tables use zlib 1.2.3.3
  274. 110319 22:43:48 InnoDB: Initializing buffer pool, size = 1.0G
  275. InnoDB: mmap(1102086144 bytes) failed; errno 12
  276. 110319 22:43:48InnoDB: Fatal error: cannot allocate the memory for the buffer pool
  277. 110319 22:43:48 [ERROR] Plugin 'InnoDB' init function returned error.
  278. 110319 22:43:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  279. 110319 22:43:49 [Warning] 'user' entry 'root@mc-188-165-58-140.ovh.net' ignored in --skip-name-resolve mode.
  280. 110319 22:43:49 [Note] Event Scheduler: Loaded 0 events
  281. 110319 22:43:49 [Note] /usr/sbin/mysqld: ready for connections.
  282. Version: '5.1.55-rel12.6-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Percona Server (GPL), 12.6 , Revision 200)
  283. 110319 22:49:52 [Note] /usr/sbin/mysqld: Normal shutdown
  284.  
  285. 110319 22:49:52 [Note] Event Scheduler: Purging the queue. 0 events
  286. 110319 22:49:52 [Note] /usr/sbin/mysqld: Shutdown complete
  287.  
  288. 110319 22:49:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  289. 110319 22:49:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  290. 110319 22:49:53 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
  291. 110319 22:49:53 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
  292. 110319 22:49:53 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
  293. 110319 22:49:53 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
  294. 110319 22:49:53 [Note] Flashcache bypass: disabled
  295. 110319 22:49:53 [Note] Flashcache setup error is : ioctl failed
  296.  
  297. 110319 22:49:54 [Note] Plugin 'FEDERATED' is disabled.
  298. InnoDB: The InnoDB memory heap is disabled
  299. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  300. InnoDB: Compressed tables use zlib 1.2.3.3
  301. 110319 22:49:55 InnoDB: Initializing buffer pool, size = 1.0G
  302. InnoDB: mmap(1102086144 bytes) failed; errno 12
  303. 110319 22:49:55InnoDB: Fatal error: cannot allocate the memory for the buffer pool
  304. 110319 22:49:55 [ERROR] Plugin 'InnoDB' init function returned error.
  305. 110319 22:49:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  306. 110319 22:49:55 [Warning] 'user' entry 'root@mc-188-165-58-140.ovh.net' ignored in --skip-name-resolve mode.
  307. 110319 22:49:55 [Note] Event Scheduler: Loaded 0 events
  308. 110319 22:49:55 [Note] /usr/sbin/mysqld: ready for connections.
  309. Version: '5.1.55-rel12.6-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Percona Server (GPL), 12.6 , Revision 200)
  310. 110319 22:50:54 [Note] /usr/sbin/mysqld: Normal shutdown
  311.  
  312. 110319 22:50:54 [Note] Event Scheduler: Purging the queue. 0 events
  313. 110319 22:50:56 [Note] /usr/sbin/mysqld: Shutdown complete
  314.  
  315. 110319 22:50:56 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  316. 110319 22:50:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  317. 110319 22:50:57 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
  318. 110319 22:50:57 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.
  319. 110319 22:50:57 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
  320. 110319 22:50:57 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
  321. 110319 22:50:57 [Note] Flashcache bypass: disabled
  322. 110319 22:50:57 [Note] Flashcache setup error is : ioctl failed
  323.  
  324. 110319 22:50:58 [Note] Plugin 'FEDERATED' is disabled.
  325. InnoDB: The InnoDB memory heap is disabled
  326. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  327. InnoDB: Compressed tables use zlib 1.2.3.3
  328. 110319 22:50:58 InnoDB: Initializing buffer pool, size = 1.0G
  329. InnoDB: mmap(1102086144 bytes) failed; errno 12
  330. 110319 22:50:58InnoDB: Fatal error: cannot allocate the memory for the buffer pool
  331. 110319 22:50:58 [ERROR] Plugin 'InnoDB' init function returned error.
  332. 110319 22:50:58 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  333. 110319 22:50:59 [Warning] 'user' entry 'root@mc-188-165-58-140.ovh.net' ignored in --skip-name-resolve mode.
  334. 110319 22:50:59 [Note] Event Scheduler: Loaded 0 events
  335. 110319 22:50:59 [Note] /usr/sbin/mysqld: ready for connections.
  336. Version: '5.1.55-rel12.6-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Percona Server (GPL), 12.6 , Revision 200)
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!