API tools faq
paste
Advertisement
Guest User

addinfos

a guest
Jul 6th, 2012
46
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 79.98 KB | None | 0 0
raw download clone embed print report
  1. [mysqld]
  2. back_log=128
  3. port = 3306
  4. socket = /var/lib/mysql/mysql.sock
  5. character-set-server = utf8
  6. skip-name-resolve
  7. sync_binlog=1
  8. symbolic-links=0
  9. skip-external-locking
  10. key_buffer_size = 384M
  11. max_allowed_packet = 1M
  12. read_buffer_size = 512K
  13. max_tmp_tables=64
  14. read_rnd_buffer_size = 512K
  15. myisam_sort_buffer_size = 256M
  16. bulk_insert_buffer_size = 256M
  17. thread_cache_size = 32
  18. thread_concurrency = 8
  19. table_open_cache = 10000
  20. table_definition = 10000
  21. max_heap_table_size = 256M
  22. tmp_table_size = 16M
  23. query_cache_size = 64M
  24. sort_buffer_size = 1M
  25. max_connections=1000
  26. max_connect_errors=100000
  27. myisam-recover=DEFAULT
  28. expire_logs_days = 7
  29. log-bin=mysql-bin
  30. server-id = 1
  31. tmpdir = /var/lib/mysql-tmp
  32. innodb_open_files=8192
  33. innodb_file_format=Barracuda
  34. innodb_thread_concurrency=64
  35. innodb_data_home_dir = /var/lib/mysql/
  36. innodb_buffer_pool_size = 500M
  37. innodb_log_file_size = 256M
  38. innodb_log_buffer_size = 8M
  39. innodb_flush_log_at_trx_commit = 1
  40. innodb_max_dirty_pages_pct=20
  41. innodb_read_io_threads=8
  42. innodb_lock_wait_timeout = 50
  43. innodb_file_per_table
  44. innodb_io_capacity=800
  45.  
  46. [mysqld_safe]
  47. open_files_limit=65000
  48.  
  49. Error log
  50.  
  51. Version: '5.5.25-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
  52. 120706 15:26:12 InnoDB: Error: table `egw_arbora_klett`.`#sql-2821_15d2` does not exist in the InnoDB internal
  53. InnoDB: data dictionary though MySQL is trying to drop it.
  54. InnoDB: Have you copied the .frm file of the table to the
  55. InnoDB: MySQL database directory from another database?
  56. InnoDB: You can look for further help from
  57. InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
  58. 120706 15:29:11 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT into autoincrement field which is not the first part in the composed primary key is unsafe. Statement: optimize table egw_blautoene_eg.phpgw_fud_thread_view
  59. 120706 15:30:49 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT into autoincrement field which is not the first part in the composed primary key is unsafe. Statement: optimize table egw_chiemgauer_e.phpgw_fud_thread_view
  60. InnoDB: Warning: a long semaphore wait:
  61. --Thread 140045169518336 has waited at row0purge.c line 680 for 241.00 seconds the semaphore:
  62. S-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  63. a writer (thread id 140045019617024) has reserved it in mode exclusive
  64. number of readers 0, waiters flag 1, lock_word: 0
  65. Last time read locked in file row0purge.c line 680
  66. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  67. InnoDB: Warning: a long semaphore wait:
  68. --Thread 140045216773888 has waited at ha_innodb.cc line 8064 for 241.00 seconds the semaphore:
  69. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  70. a writer (thread id 140045019617024) has reserved it in mode exclusive
  71. number of readers 0, waiters flag 1, lock_word: 0
  72. Last time read locked in file row0purge.c line 680
  73. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  74. InnoDB: Warning: a long semaphore wait:
  75. --Thread 140046470960896 has waited at ha_innodb.cc line 8492 for 241.00 seconds the semaphore:
  76. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  77. a writer (thread id 140045019617024) has reserved it in mode exclusive
  78. number of readers 0, waiters flag 1, lock_word: 0
  79. Last time read locked in file row0purge.c line 680
  80. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  81. InnoDB: Warning: a long semaphore wait:
  82. --Thread 140046469486336 has waited at buf0lru.c line 1093 for 241.00 seconds the semaphore:
  83. Mutex at 0x2a291e8 '&buf_pool->mutex', lock var 1
  84. waiters flag 1
  85. InnoDB: Warning: a long semaphore wait:
  86. --Thread 140046469781248 has waited at buf0buf.c line 3716 for 241.00 seconds the semaphore:
  87. X-lock (wait_ex) on RW-latch at 0x2a292a8 '&buf_pool->page_hash_latch'
  88. a writer (thread id 140046469781248) has reserved it in mode wait exclusive
  89. number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
  90. Last time read locked in file buf0buf.c line 2529
  91. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/buf/buf0buf.c line 3716
  92. InnoDB: Warning: a long semaphore wait:
  93. --Thread 140045018732288 has waited at row0mysql.c line 3271 for 241.00 seconds the semaphore:
  94. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  95. a writer (thread id 140045019617024) has reserved it in mode exclusive
  96. number of readers 0, waiters flag 1, lock_word: 0
  97. Last time read locked in file row0purge.c line 680
  98. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  99. InnoDB: Warning: a long semaphore wait:
  100. --Thread 140045180008192 has waited at buf0flu.c line 1290 for 241.00 seconds the semaphore:
  101. Mutex at 0x2a291e8 '&buf_pool->mutex', lock var 1
  102. waiters flag 1
  103. InnoDB: Warning: a long semaphore wait:
  104. --Thread 140046469191424 has waited at buf0lru.c line 1093 for 241.00 seconds the semaphore:
  105. Mutex at 0x2a291e8 '&buf_pool->mutex', lock var 1
  106. waiters flag 1
  107. InnoDB: Warning: a long semaphore wait:
  108. --Thread 140045019617024 has waited at buf0lru.c line 395 for 241.00 seconds the semaphore:
  109. Mutex at 0x7f5edba64238 '&block->mutex', lock var 1
  110. waiters flag 1
  111. InnoDB: Warning: a long semaphore wait:
  112. --Thread 140046468896512 has waited at ha_innodb.cc line 8064 for 241.00 seconds the semaphore:
  113. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  114. a writer (thread id 140045019617024) has reserved it in mode exclusive
  115. number of readers 0, waiters flag 1, lock_word: 0
  116. Last time read locked in file row0purge.c line 680
  117. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  118. InnoDB: Warning: a long semaphore wait:
  119. --Thread 140046470665984 has waited at ha_innodb.cc line 8064 for 241.00 seconds the semaphore:
  120. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  121. a writer (thread id 140045019617024) has reserved it in mode exclusive
  122. number of readers 0, waiters flag 1, lock_word: 0
  123. Last time read locked in file row0purge.c line 680
  124. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  125. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  126. InnoDB: Pending preads 0, pwrites 0
  127. InnoDB: ###### Diagnostic info printed to the standard error stream
  128. InnoDB: Warning: a long semaphore wait:
  129. --Thread 140045169518336 has waited at row0purge.c line 680 for 272.00 seconds the semaphore:
  130. S-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  131. a writer (thread id 140045019617024) has reserved it in mode exclusive
  132. number of readers 0, waiters flag 1, lock_word: 0
  133. Last time read locked in file row0purge.c line 680
  134. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  135. InnoDB: Warning: a long semaphore wait:
  136. --Thread 140045216773888 has waited at ha_innodb.cc line 8064 for 272.00 seconds the semaphore:
  137. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  138. a writer (thread id 140045019617024) has reserved it in mode exclusive
  139. number of readers 0, waiters flag 1, lock_word: 0
  140. Last time read locked in file row0purge.c line 680
  141. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  142. InnoDB: Warning: a long semaphore wait:
  143. --Thread 140046470960896 has waited at ha_innodb.cc line 8492 for 272.00 seconds the semaphore:
  144. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  145. a writer (thread id 140045019617024) has reserved it in mode exclusive
  146. number of readers 0, waiters flag 1, lock_word: 0
  147. Last time read locked in file row0purge.c line 680
  148. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  149. InnoDB: Warning: a long semaphore wait:
  150. --Thread 140046469486336 has waited at buf0lru.c line 1093 for 272.00 seconds the semaphore:
  151. Mutex at 0x2a291e8 '&buf_pool->mutex', lock var 1
  152. waiters flag 1
  153. InnoDB: Warning: a long semaphore wait:
  154. --Thread 140046469781248 has waited at buf0buf.c line 3716 for 272.00 seconds the semaphore:
  155. X-lock (wait_ex) on RW-latch at 0x2a292a8 '&buf_pool->page_hash_latch'
  156. a writer (thread id 140046469781248) has reserved it in mode wait exclusive
  157. number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
  158. Last time read locked in file buf0buf.c line 2529
  159. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/buf/buf0buf.c line 3716
  160. InnoDB: Warning: a long semaphore wait:
  161. --Thread 140045018732288 has waited at row0mysql.c line 3271 for 272.00 seconds the semaphore:
  162. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  163. a writer (thread id 140045019617024) has reserved it in mode exclusive
  164. number of readers 0, waiters flag 1, lock_word: 0
  165. Last time read locked in file row0purge.c line 680
  166. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  167. InnoDB: Warning: a long semaphore wait:
  168. --Thread 140045180008192 has waited at buf0flu.c line 1290 for 272.00 seconds the semaphore:
  169. Mutex at 0x2a291e8 '&buf_pool->mutex', lock var 1
  170. waiters flag 1
  171. InnoDB: Warning: a long semaphore wait:
  172. --Thread 140046469191424 has waited at buf0lru.c line 1093 for 272.00 seconds the semaphore:
  173. Mutex at 0x2a291e8 '&buf_pool->mutex', lock var 1
  174. waiters flag 1
  175. InnoDB: Warning: a long semaphore wait:
  176. --Thread 140045019617024 has waited at buf0lru.c line 395 for 272.00 seconds the semaphore:
  177. Mutex at 0x7f5edba64238 '&block->mutex', lock var 1
  178. waiters flag 1
  179. InnoDB: Warning: a long semaphore wait:
  180. --Thread 140046468896512 has waited at ha_innodb.cc line 8064 for 272.00 seconds the semaphore:
  181. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  182. a writer (thread id 140045019617024) has reserved it in mode exclusive
  183. number of readers 0, waiters flag 1, lock_word: 0
  184. Last time read locked in file row0purge.c line 680
  185. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  186. InnoDB: Warning: a long semaphore wait:
  187. --Thread 140046470665984 has waited at ha_innodb.cc line 8064 for 272.00 seconds the semaphore:
  188. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  189. a writer (thread id 140045019617024) has reserved it in mode exclusive
  190. number of readers 0, waiters flag 1, lock_word: 0
  191. Last time read locked in file row0purge.c line 680
  192. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  193. InnoDB: Warning: a long semaphore wait:
  194. --Thread 140046470076160 has waited at dict0dict.c line 342 for 270.00 seconds the semaphore:
  195. Mutex at 0x375fc18 '&dict_sys->mutex', lock var 1
  196. waiters flag 1
  197. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  198. InnoDB: Pending preads 0, pwrites 0
  199. InnoDB: ###### Diagnostic info printed to the standard error stream
  200. InnoDB: Warning: a long semaphore wait:
  201. --Thread 140045169518336 has waited at row0purge.c line 680 for 303.00 seconds the semaphore:
  202. S-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  203. a writer (thread id 140045019617024) has reserved it in mode exclusive
  204. number of readers 0, waiters flag 1, lock_word: 0
  205. Last time read locked in file row0purge.c line 680
  206. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  207. InnoDB: Warning: a long semaphore wait:
  208. --Thread 140045216773888 has waited at ha_innodb.cc line 8064 for 303.00 seconds the semaphore:
  209. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  210. a writer (thread id 140045019617024) has reserved it in mode exclusive
  211. number of readers 0, waiters flag 1, lock_word: 0
  212. Last time read locked in file row0purge.c line 680
  213. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  214. InnoDB: Warning: a long semaphore wait:
  215. --Thread 140046470960896 has waited at ha_innodb.cc line 8492 for 303.00 seconds the semaphore:
  216. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  217. a writer (thread id 140045019617024) has reserved it in mode exclusive
  218. number of readers 0, waiters flag 1, lock_word: 0
  219. Last time read locked in file row0purge.c line 680
  220. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  221. InnoDB: Warning: a long semaphore wait:
  222. --Thread 140046469486336 has waited at buf0lru.c line 1093 for 303.00 seconds the semaphore:
  223. Mutex at 0x2a291e8 '&buf_pool->mutex', lock var 1
  224. waiters flag 1
  225. InnoDB: Warning: a long semaphore wait:
  226. --Thread 140046469781248 has waited at buf0buf.c line 3716 for 303.00 seconds the semaphore:
  227. X-lock (wait_ex) on RW-latch at 0x2a292a8 '&buf_pool->page_hash_latch'
  228. a writer (thread id 140046469781248) has reserved it in mode wait exclusive
  229. number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
  230. Last time read locked in file buf0buf.c line 2529
  231. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/buf/buf0buf.c line 3716
  232. InnoDB: Warning: a long semaphore wait:
  233. --Thread 140045018732288 has waited at row0mysql.c line 3271 for 303.00 seconds the semaphore:
  234. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  235. a writer (thread id 140045019617024) has reserved it in mode exclusive
  236. number of readers 0, waiters flag 1, lock_word: 0
  237. Last time read locked in file row0purge.c line 680
  238. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  239. InnoDB: Warning: a long semaphore wait:
  240. --Thread 140045180008192 has waited at buf0flu.c line 1290 for 303.00 seconds the semaphore:
  241. Mutex at 0x2a291e8 '&buf_pool->mutex', lock var 1
  242. waiters flag 1
  243. InnoDB: Warning: a long semaphore wait:
  244. --Thread 140046469191424 has waited at buf0lru.c line 1093 for 303.00 seconds the semaphore:
  245. Mutex at 0x2a291e8 '&buf_pool->mutex', lock var 1
  246. waiters flag 1
  247. InnoDB: Warning: a long semaphore wait:
  248. --Thread 140045019617024 has waited at buf0lru.c line 395 for 303.00 seconds the semaphore:
  249. Mutex at 0x7f5edba64238 '&block->mutex', lock var 1
  250. waiters flag 1
  251. InnoDB: Warning: a long semaphore wait:
  252. --Thread 140046468896512 has waited at ha_innodb.cc line 8064 for 303.00 seconds the semaphore:
  253. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  254. a writer (thread id 140045019617024) has reserved it in mode exclusive
  255. number of readers 0, waiters flag 1, lock_word: 0
  256. Last time read locked in file row0purge.c line 680
  257. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  258. InnoDB: Warning: a long semaphore wait:
  259. --Thread 140046470665984 has waited at ha_innodb.cc line 8064 for 303.00 seconds the semaphore:
  260. X-lock on RW-latch at 0x19991e0 '&dict_operation_lock'
  261. a writer (thread id 140045019617024) has reserved it in mode exclusive
  262. number of readers 0, waiters flag 1, lock_word: 0
  263. Last time read locked in file row0purge.c line 680
  264. Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.25/storage/xtradb/row/row0mysql.c line 3271
  265. InnoDB: Warning: a long semaphore wait:
  266. --Thread 140046470076160 has waited at dict0dict.c line 342 for 301.00 seconds the semaphore:
  267. Mutex at 0x375fc18 '&dict_sys->mutex', lock var 1
  268. waiters flag 1
  269. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  270. InnoDB: Pending preads 0, pwrites 0
  271.  
  272.  
  273.  
  274.  
  275.  
  276. cat /tmp/quickstack.log
  277.  
  278. Thread 55 (LWP 10275):
  279. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  280. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  281. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  282. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  283. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  284.  
  285. Thread 54 (LWP 10276):
  286. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  287. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  288. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  289. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  290. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  291.  
  292. Thread 53 (LWP 10277):
  293. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  294. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  295. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  296. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  297. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  298.  
  299. Thread 52 (LWP 10278):
  300. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  301. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  302. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  303. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  304. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  305.  
  306. Thread 51 (LWP 10279):
  307. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  308. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  309. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  310. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  311. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  312.  
  313. Thread 50 (LWP 10280):
  314. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  315. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  316. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  317. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  318. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  319.  
  320. Thread 49 (LWP 10281):
  321. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  322. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  323. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  324. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  325. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  326.  
  327. Thread 48 (LWP 10282):
  328. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  329. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  330. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  331. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  332. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  333.  
  334. Thread 47 (LWP 10283):
  335. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  336. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  337. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  338. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  339. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  340.  
  341. Thread 46 (LWP 10284):
  342. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  343. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  344. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  345. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  346. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  347.  
  348. Thread 45 (LWP 10285):
  349. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  350. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  351. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  352. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  353. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  354.  
  355. Thread 44 (LWP 10286):
  356. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  357. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  358. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  359. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  360. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  361.  
  362. Thread 43 (LWP 10287):
  363. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  364. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  365. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  366. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  367. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  368.  
  369. Thread 42 (LWP 10288):
  370. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  371. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  372. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  373. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  374. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  375.  
  376. Thread 41 (LWP 10290):
  377. #01 0x0000003c0480b75b in __pthread_cond_timedwait () from /lib64/libpthread-2.12.so
  378. #02 0x000000000092dfb3 in os_event_wait_time_low () from /usr/sbin/mysqld
  379. #03 0x0000000000862de0 in srv_lock_timeout_thread () from /usr/sbin/mysqld
  380. #04 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  381.  
  382. Thread 40 (LWP 10291):
  383. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  384. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  385. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  386. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  387. #05 0x0000000000862cb1 in srv_error_monitor_thread () from /usr/sbin/mysqld
  388. #06 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  389.  
  390. Thread 39 (LWP 10292):
  391. #01 0x0000003c0480b75b in __pthread_cond_timedwait () from /lib64/libpthread-2.12.so
  392. #02 0x000000000092dfb3 in os_event_wait_time_low () from /usr/sbin/mysqld
  393. #03 0x0000000000865773 in srv_monitor_thread () from /usr/sbin/mysqld
  394. #04 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  395.  
  396. Thread 38 (LWP 10293):
  397. #01 0x0000003c0480b75b in __pthread_cond_timedwait () from /lib64/libpthread-2.12.so
  398. #02 0x000000000092dfb3 in os_event_wait_time_low () from /usr/sbin/mysqld
  399. #03 0x00000000008608d3 in srv_LRU_dump_restore_thread () from /usr/sbin/mysqld
  400. #04 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  401.  
  402. Thread 37 (LWP 10294):
  403. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  404. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  405. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  406. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  407. #05 0x00000000008b89f9 in buf_flush_page_and_try_neighbors () from /usr/sbin/mysqld
  408. #06 0x00000000008b921f in buf_flush_batch () from /usr/sbin/mysqld
  409. #07 0x00000000008b99a0 in buf_flush_list () from /usr/sbin/mysqld
  410. #08 0x0000000000864c0e in srv_master_thread () from /usr/sbin/mysqld
  411. #09 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  412.  
  413. Thread 36 (LWP 10295):
  414. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  415. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  416. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  417. #04 0x000000000086bb50 in rw_lock_s_lock_spin () from /usr/sbin/mysqld
  418. #05 0x0000000000846f75 in row_mysql_freeze_data_dictionary_func () from /usr/sbin/mysqld
  419. #06 0x000000000094dcb5 in row_purge_step () from /usr/sbin/mysqld
  420. #07 0x0000000000942a57 in que_run_threads () from /usr/sbin/mysqld
  421. #08 0x000000000086fca6 in trx_purge () from /usr/sbin/mysqld
  422. #09 0x0000000000865efc in srv_purge_thread () from /usr/sbin/mysqld
  423. #10 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  424.  
  425. Thread 35 (LWP 10298):
  426. #01 0x0000003c0480b75b in __pthread_cond_timedwait () from /lib64/libpthread-2.12.so
  427. #02 0x00000000009a676f in my_service_thread_sleep () from /usr/sbin/mysqld
  428. #03 0x0000000000a6b389 in my_thread_init () from /usr/sbin/mysqld
  429. #04 0x000000000099ec6b in ma_checkpoint_background () from /usr/sbin/mysqld
  430. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  431.  
  432. Thread 34 (LWP 10299):
  433. #01 0x0000003c0480f245 in sigwait () from /lib64/libpthread-2.12.so
  434. #02 0x0000000000a6983f in my_close () from /usr/sbin/mysqld
  435. #03 0x0000003c0480e499 in __write_nocancel () from /lib64/libpthread-2.12.so
  436. #04 0x0000000000a7382e in my_pthread_fastmutex_lock () from /usr/sbin/mysqld
  437. #05 0x0000000000506a73 in signal_hand () from /usr/sbin/mysqld
  438. #06 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  439.  
  440. Thread 33 (LWP 10798):
  441. #01 0x0000003c0480e4ed in __read_nocancel () from /lib64/libpthread-2.12.so
  442. #02 0x0000000000aa06e8 in vio_read () from /usr/sbin/mysqld
  443. #03 0x000000000050b021 in my_real_read () from /usr/sbin/mysqld
  444. #04 0x000000000050b44c in my_net_read () from /usr/sbin/mysqld
  445. #05 0x000000000058cc22 in do_command () from /usr/sbin/mysqld
  446. #06 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  447. #07 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  448. #08 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  449.  
  450. Thread 32 (LWP 10800):
  451. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  452. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  453. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  454. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  455. #05 0x00000000008b9e1e in pfs_mutex_enter_func () from /usr/sbin/mysqld
  456. #06 0x00000000008bb689 in buf_LRU_get_free_only () from /usr/sbin/mysqld
  457. #07 0x00000000008bf714 in buf_LRU_get_free_block () from /usr/sbin/mysqld
  458. #08 0x00000000008b31af in buf_page_init_for_read () from /usr/sbin/mysqld
  459. #09 0x00000000008c0da9 in buf_read_page_low () from /usr/sbin/mysqld
  460. #10 0x00000000008c14ea in buf_read_page () from /usr/sbin/mysqld
  461. #11 0x00000000008b1e93 in buf_page_get_gen () from /usr/sbin/mysqld
  462. #12 0x000000000089cca5 in btr_cur_open_at_index_side_func () from /usr/sbin/mysqld
  463. #13 0x000000000085277f in btr_pcur_open_at_index_side.clone.7 () from /usr/sbin/mysqld
  464. #14 0x00000000008570f8 in row_search_for_mysql () from /usr/sbin/mysqld
  465. #15 0x000000000082e60c in ha_innobase::index_read () from /usr/sbin/mysqld
  466. #16 0x0000000000825e17 in ha_innobase::index_first () from /usr/sbin/mysqld
  467. #17 0x000000000082b95f in ha_innobase::rnd_next () from /usr/sbin/mysqld
  468. #18 0x00000000007c2249 in rr_sequential () from /usr/sbin/mysqld
  469. #19 0x00000000005acc99 in sub_select () from /usr/sbin/mysqld
  470. #20 0x00000000005b40cd in do_select () from /usr/sbin/mysqld
  471. #21 0x00000000005d219c in JOIN::exec () from /usr/sbin/mysqld
  472. #22 0x00000000005d4018 in mysql_select () from /usr/sbin/mysqld
  473. #23 0x00000000005d4bbd in handle_select () from /usr/sbin/mysqld
  474. #24 0x0000000000581fbc in execute_sqlcom_select () from /usr/sbin/mysqld
  475. #25 0x0000000000588ff0 in mysql_execute_command () from /usr/sbin/mysqld
  476. #26 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  477. #27 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  478. #28 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  479. #29 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  480. #30 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  481.  
  482. Thread 31 (LWP 10802):
  483. #01 0x0000003c0480e4ed in __read_nocancel () from /lib64/libpthread-2.12.so
  484. #02 0x0000000000aa06e8 in vio_read () from /usr/sbin/mysqld
  485. #03 0x000000000050b021 in my_real_read () from /usr/sbin/mysqld
  486. #04 0x000000000050b44c in my_net_read () from /usr/sbin/mysqld
  487. #05 0x000000000058cc22 in do_command () from /usr/sbin/mysqld
  488. #06 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  489. #07 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  490. #08 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  491.  
  492. Thread 30 (LWP 10826):
  493. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  494. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  495. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  496. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  497. #05 0x00000000008cabb0 in pfs_mutex_enter_func.clone.1 () from /usr/sbin/mysqld
  498. #06 0x00000000008d4955 in dict_table_get () from /usr/sbin/mysqld
  499. #07 0x0000000000853e68 in row_search_check_if_query_cache_permitted () from /usr/sbin/mysqld
  500. #08 0x00000000008349f6 in innobase_query_caching_of_table_permitted () from /usr/sbin/mysqld
  501. #09 0x000000000054c203 in Query_cache::ask_handler_allowance () from /usr/sbin/mysqld
  502. #10 0x00000000005522e9 in Query_cache::store_query () from /usr/sbin/mysqld
  503. #11 0x0000000000581fac in execute_sqlcom_select () from /usr/sbin/mysqld
  504. #12 0x0000000000588ff0 in mysql_execute_command () from /usr/sbin/mysqld
  505. #13 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  506. #14 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  507. #15 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  508. #16 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  509. #17 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  510.  
  511. Thread 29 (LWP 10827):
  512. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  513. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  514.  
  515. Thread 28 (LWP 10843):
  516. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  517. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  518. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  519. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  520. #05 0x00000000008ab48e in pfs_mutex_enter_func () from /usr/sbin/mysqld
  521. #06 0x00000000008af464 in buf_print_io () from /usr/sbin/mysqld
  522. #07 0x0000000000866f87 in srv_printf_innodb_monitor () from /usr/sbin/mysqld
  523. #08 0x00000000008324f9 in innobase_show_status () from /usr/sbin/mysqld
  524. #09 0x00000000006cb5d8 in ha_show_status () from /usr/sbin/mysqld
  525. #10 0x0000000000588697 in mysql_execute_command () from /usr/sbin/mysqld
  526. #11 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  527. #12 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  528. #13 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  529. #14 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  530. #15 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  531.  
  532. Thread 27 (LWP 11302):
  533. #01 0x0000003c0480dff4 in __lll_lock_wait () from /lib64/libpthread-2.12.so
  534. #02 0x0000003c0480935e in _L_lock_995 () from /lib64/libpthread-2.12.so
  535. #03 0x0000000000a7382e in my_pthread_fastmutex_lock () from /usr/sbin/mysqld
  536. #04 0x0000000000a738ef in my_pthread_fastmutex_lock () from /usr/sbin/mysqld
  537. #05 0x00000000005e407a in fill_status () from /usr/sbin/mysqld
  538. #06 0x00000000005d768d in get_schema_tables_result () from /usr/sbin/mysqld
  539. #07 0x00000000005d1df9 in JOIN::exec () from /usr/sbin/mysqld
  540. #08 0x00000000005d4018 in mysql_select () from /usr/sbin/mysqld
  541. #09 0x00000000005d4bbd in handle_select () from /usr/sbin/mysqld
  542. #10 0x0000000000581fbc in execute_sqlcom_select () from /usr/sbin/mysqld
  543. #11 0x0000000000589779 in mysql_execute_command () from /usr/sbin/mysqld
  544. #12 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  545. #13 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  546. #14 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  547. #15 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  548. #16 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  549.  
  550. Thread 26 (LWP 11303):
  551. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  552. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  553. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  554. #04 0x000000000086c370 in rw_lock_x_lock_func () from /usr/sbin/mysqld
  555. #05 0x000000000084a70b in row_mysql_lock_data_dictionary_func () from /usr/sbin/mysqld
  556. #06 0x000000000082edfa in ha_innobase::create () from /usr/sbin/mysqld
  557. #07 0x00000000006cc013 in ha_create_table () from /usr/sbin/mysqld
  558. #08 0x00000000006298cb in rea_create_table () from /usr/sbin/mysqld
  559. #09 0x00000000005f8540 in mysql_create_table_no_lock () from /usr/sbin/mysqld
  560. #10 0x00000000005fbb01 in mysql_alter_table () from /usr/sbin/mysqld
  561. #11 0x000000000080896f in Alter_table_statement::execute () from /usr/sbin/mysqld
  562. #12 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  563. #13 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  564. #14 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  565. #15 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  566. #16 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  567. #17 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  568.  
  569. Thread 25 (LWP 11304):
  570. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  571. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  572. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  573. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  574. #05 0x00000000008b9e1e in pfs_mutex_enter_func () from /usr/sbin/mysqld
  575. #06 0x00000000008bb689 in buf_LRU_get_free_only () from /usr/sbin/mysqld
  576. #07 0x00000000008bf714 in buf_LRU_get_free_block () from /usr/sbin/mysqld
  577. #08 0x00000000008b31af in buf_page_init_for_read () from /usr/sbin/mysqld
  578. #09 0x00000000008c0da9 in buf_read_page_low () from /usr/sbin/mysqld
  579. #10 0x00000000008c14ea in buf_read_page () from /usr/sbin/mysqld
  580. #11 0x00000000008b1e93 in buf_page_get_gen () from /usr/sbin/mysqld
  581. #12 0x000000000089cca5 in btr_cur_open_at_index_side_func () from /usr/sbin/mysqld
  582. #13 0x000000000085277f in btr_pcur_open_at_index_side.clone.7 () from /usr/sbin/mysqld
  583. #14 0x00000000008570f8 in row_search_for_mysql () from /usr/sbin/mysqld
  584. #15 0x000000000082e60c in ha_innobase::index_read () from /usr/sbin/mysqld
  585. #16 0x0000000000825e17 in ha_innobase::index_first () from /usr/sbin/mysqld
  586. #17 0x000000000082b95f in ha_innobase::rnd_next () from /usr/sbin/mysqld
  587. #18 0x00000000007c2249 in rr_sequential () from /usr/sbin/mysqld
  588. #19 0x00000000005acc99 in sub_select () from /usr/sbin/mysqld
  589. #20 0x00000000005b40cd in do_select () from /usr/sbin/mysqld
  590. #21 0x00000000005d219c in JOIN::exec () from /usr/sbin/mysqld
  591. #22 0x00000000005d4018 in mysql_select () from /usr/sbin/mysqld
  592. #23 0x00000000005d4bbd in handle_select () from /usr/sbin/mysqld
  593. #24 0x0000000000581fbc in execute_sqlcom_select () from /usr/sbin/mysqld
  594. #25 0x0000000000588ff0 in mysql_execute_command () from /usr/sbin/mysqld
  595. #26 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  596. #27 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  597. #28 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  598. #29 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  599. #30 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  600.  
  601. Thread 24 (LWP 11305):
  602. #01 0x0000003c0480e4ed in __read_nocancel () from /lib64/libpthread-2.12.so
  603. #02 0x0000000000aa06e8 in vio_read () from /usr/sbin/mysqld
  604. #03 0x000000000050b021 in my_real_read () from /usr/sbin/mysqld
  605. #04 0x000000000050b44c in my_net_read () from /usr/sbin/mysqld
  606. #05 0x000000000058cc22 in do_command () from /usr/sbin/mysqld
  607. #06 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  608. #07 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  609. #08 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  610.  
  611. Thread 23 (LWP 11307):
  612. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  613. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  614. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  615. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  616. #05 0x00000000008cabb0 in pfs_mutex_enter_func.clone.1 () from /usr/sbin/mysqld
  617. #06 0x00000000008d4955 in dict_table_get () from /usr/sbin/mysqld
  618. #07 0x00000000008304bb in ha_innobase::open () from /usr/sbin/mysqld
  619. #08 0x00000000006c799e in handler::ha_open () from /usr/sbin/mysqld
  620. #09 0x00000000006189fe in open_table_from_share () from /usr/sbin/mysqld
  621. #10 0x000000000054866e in open_table () from /usr/sbin/mysqld
  622. #11 0x0000000000549311 in open_tables () from /usr/sbin/mysqld
  623. #12 0x0000000000549ef4 in open_and_lock_tables () from /usr/sbin/mysqld
  624. #13 0x000000000064e4c3 in mysql_admin_table () from /usr/sbin/mysqld
  625. #14 0x000000000064f819 in Optimize_table_statement::execute () from /usr/sbin/mysqld
  626. #15 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  627. #16 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  628. #17 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  629. #18 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  630. #19 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  631. #20 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  632.  
  633. Thread 22 (LWP 11308):
  634. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  635. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  636.  
  637. Thread 21 (LWP 11309):
  638. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  639. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  640. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  641. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  642. #05 0x00000000008cabb0 in pfs_mutex_enter_func.clone.1 () from /usr/sbin/mysqld
  643. #06 0x00000000008d4955 in dict_table_get () from /usr/sbin/mysqld
  644. #07 0x00000000008304bb in ha_innobase::open () from /usr/sbin/mysqld
  645. #08 0x00000000006c799e in handler::ha_open () from /usr/sbin/mysqld
  646. #09 0x00000000006189fe in open_table_from_share () from /usr/sbin/mysqld
  647. #10 0x0000000000544c0c in open_table_uncached () from /usr/sbin/mysqld
  648. #11 0x00000000005fca10 in mysql_alter_table () from /usr/sbin/mysqld
  649. #12 0x00000000005fde07 in mysql_recreate_table () from /usr/sbin/mysqld
  650. #13 0x000000000064d6bd in admin_recreate_table () from /usr/sbin/mysqld
  651. #14 0x000000000064ec48 in mysql_admin_table () from /usr/sbin/mysqld
  652. #15 0x000000000064f819 in Optimize_table_statement::execute () from /usr/sbin/mysqld
  653. #16 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  654. #17 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  655. #18 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  656. #19 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  657. #20 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  658. #21 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  659.  
  660. Thread 20 (LWP 11312):
  661. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  662. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  663. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  664. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  665. #05 0x0000000000866904 in srv_export_innodb_status () from /usr/sbin/mysqld
  666. #06 0x00000000008263aa in show_innodb_vars () from /usr/sbin/mysqld
  667. #07 0x00000000005dffcc in show_status_array () from /usr/sbin/mysqld
  668. #08 0x00000000005e3ffd in fill_status () from /usr/sbin/mysqld
  669. #09 0x00000000005d768d in get_schema_tables_result () from /usr/sbin/mysqld
  670. #10 0x00000000005d1df9 in JOIN::exec () from /usr/sbin/mysqld
  671. #11 0x00000000005d4018 in mysql_select () from /usr/sbin/mysqld
  672. #12 0x00000000005d4bbd in handle_select () from /usr/sbin/mysqld
  673. #13 0x0000000000581fbc in execute_sqlcom_select () from /usr/sbin/mysqld
  674. #14 0x0000000000589779 in mysql_execute_command () from /usr/sbin/mysqld
  675. #15 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  676. #16 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  677. #17 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  678. #18 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  679. #19 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  680.  
  681. Thread 19 (LWP 11313):
  682. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  683. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  684.  
  685. Thread 18 (LWP 11315):
  686. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  687. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  688. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  689. #04 0x000000000086c370 in rw_lock_x_lock_func () from /usr/sbin/mysqld
  690. #05 0x000000000084a8a4 in row_mysql_lock_data_dictionary_func.clone.3 () from /usr/sbin/mysqld
  691. #06 0x000000000084a9c8 in row_drop_table_for_mysql () from /usr/sbin/mysqld
  692. #07 0x00000000008350c3 in ha_innobase::delete_table () from /usr/sbin/mysqld
  693. #08 0x00000000006cc903 in ha_delete_table () from /usr/sbin/mysqld
  694. #09 0x00000000005fa167 in mysql_rm_table_no_locks () from /usr/sbin/mysqld
  695. #10 0x000000000056412f in mysql_rm_db () from /usr/sbin/mysqld
  696. #11 0x0000000000587e93 in mysql_execute_command () from /usr/sbin/mysqld
  697. #12 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  698. #13 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  699. #14 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  700. #15 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  701. #16 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  702.  
  703. Thread 17 (LWP 11316):
  704. #01 0x0000003c0480e4ed in __read_nocancel () from /lib64/libpthread-2.12.so
  705. #02 0x0000000000aa06e8 in vio_read () from /usr/sbin/mysqld
  706. #03 0x000000000050b021 in my_real_read () from /usr/sbin/mysqld
  707. #04 0x000000000050b44c in my_net_read () from /usr/sbin/mysqld
  708. #05 0x000000000058cc22 in do_command () from /usr/sbin/mysqld
  709. #06 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  710. #07 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  711. #08 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  712.  
  713. Thread 16 (LWP 11317):
  714. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  715. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  716.  
  717. Thread 15 (LWP 11319):
  718. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  719. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  720.  
  721. Thread 14 (LWP 11322):
  722. #01 0x0000003c0480e4ed in __read_nocancel () from /lib64/libpthread-2.12.so
  723. #02 0x0000000000aa06e8 in vio_read () from /usr/sbin/mysqld
  724. #03 0x000000000050b021 in my_real_read () from /usr/sbin/mysqld
  725. #04 0x000000000050b44c in my_net_read () from /usr/sbin/mysqld
  726. #05 0x000000000058cc22 in do_command () from /usr/sbin/mysqld
  727. #06 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  728. #07 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  729. #08 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  730.  
  731. Thread 13 (LWP 11324):
  732. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  733. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  734.  
  735. Thread 12 (LWP 11326):
  736. #01 0x0000003c0480e4ed in __read_nocancel () from /lib64/libpthread-2.12.so
  737. #02 0x0000000000aa06e8 in vio_read () from /usr/sbin/mysqld
  738. #03 0x000000000050b021 in my_real_read () from /usr/sbin/mysqld
  739. #04 0x000000000050b44c in my_net_read () from /usr/sbin/mysqld
  740. #05 0x000000000058cc22 in do_command () from /usr/sbin/mysqld
  741. #06 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  742. #07 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  743. #08 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  744.  
  745. Thread 11 (LWP 11327):
  746. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  747. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  748. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  749. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  750. #05 0x00000000008cabb0 in pfs_mutex_enter_func.clone.1 () from /usr/sbin/mysqld
  751. #06 0x00000000008d4955 in dict_table_get () from /usr/sbin/mysqld
  752. #07 0x00000000008304bb in ha_innobase::open () from /usr/sbin/mysqld
  753. #08 0x00000000006c799e in handler::ha_open () from /usr/sbin/mysqld
  754. #09 0x00000000006189fe in open_table_from_share () from /usr/sbin/mysqld
  755. #10 0x000000000054866e in open_table () from /usr/sbin/mysqld
  756. #11 0x0000000000549311 in open_tables () from /usr/sbin/mysqld
  757. #12 0x0000000000549ef4 in open_and_lock_tables () from /usr/sbin/mysqld
  758. #13 0x000000000064e4c3 in mysql_admin_table () from /usr/sbin/mysqld
  759. #14 0x000000000064f819 in Optimize_table_statement::execute () from /usr/sbin/mysqld
  760. #15 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  761. #16 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  762. #17 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  763. #18 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  764. #19 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  765. #20 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  766.  
  767. Thread 10 (LWP 11332):
  768. #01 0x0000003c0480dff4 in __lll_lock_wait () from /lib64/libpthread-2.12.so
  769. #02 0x0000003c0480935e in _L_lock_995 () from /lib64/libpthread-2.12.so
  770. #03 0x0000000000a7382e in my_pthread_fastmutex_lock () from /usr/sbin/mysqld
  771. #04 0x0000000000a738ef in my_pthread_fastmutex_lock () from /usr/sbin/mysqld
  772. #05 0x00000000005e407a in fill_status () from /usr/sbin/mysqld
  773. #06 0x00000000005d768d in get_schema_tables_result () from /usr/sbin/mysqld
  774. #07 0x00000000005d1df9 in JOIN::exec () from /usr/sbin/mysqld
  775. #08 0x00000000005d4018 in mysql_select () from /usr/sbin/mysqld
  776. #09 0x00000000005d4bbd in handle_select () from /usr/sbin/mysqld
  777. #10 0x0000000000581fbc in execute_sqlcom_select () from /usr/sbin/mysqld
  778. #11 0x0000000000589779 in mysql_execute_command () from /usr/sbin/mysqld
  779. #12 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  780. #13 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  781. #14 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  782. #15 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  783. #16 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  784.  
  785. Thread 9 (LWP 11333):
  786. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  787. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  788. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  789. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  790. #05 0x00000000008b9e1e in pfs_mutex_enter_func () from /usr/sbin/mysqld
  791. #06 0x00000000008c03f1 in buf_LRU_flush_or_remove_pages () from /usr/sbin/mysqld
  792. #07 0x00000000008ef584 in fil_delete_tablespace () from /usr/sbin/mysqld
  793. #08 0x000000000084b28e in row_drop_table_for_mysql () from /usr/sbin/mysqld
  794. #09 0x00000000008350c3 in ha_innobase::delete_table () from /usr/sbin/mysqld
  795. #10 0x00000000006cc903 in ha_delete_table () from /usr/sbin/mysqld
  796. #11 0x00000000005fa9d6 in quick_rm_table () from /usr/sbin/mysqld
  797. #12 0x00000000005fcd71 in mysql_alter_table () from /usr/sbin/mysqld
  798. #13 0x00000000005fde07 in mysql_recreate_table () from /usr/sbin/mysqld
  799. #14 0x000000000064d6bd in admin_recreate_table () from /usr/sbin/mysqld
  800. #15 0x000000000064ec48 in mysql_admin_table () from /usr/sbin/mysqld
  801. #16 0x000000000064f819 in Optimize_table_statement::execute () from /usr/sbin/mysqld
  802. #17 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  803. #18 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  804. #19 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  805. #20 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  806. #21 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  807. #22 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  808.  
  809. Thread 8 (LWP 11334):
  810. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  811. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  812. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  813. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  814. #05 0x00000000008cabb0 in pfs_mutex_enter_func.clone.1 () from /usr/sbin/mysqld
  815. #06 0x00000000008d4955 in dict_table_get () from /usr/sbin/mysqld
  816. #07 0x00000000008304bb in ha_innobase::open () from /usr/sbin/mysqld
  817. #08 0x00000000006c799e in handler::ha_open () from /usr/sbin/mysqld
  818. #09 0x00000000006189fe in open_table_from_share () from /usr/sbin/mysqld
  819. #10 0x000000000054866e in open_table () from /usr/sbin/mysqld
  820. #11 0x0000000000549311 in open_tables () from /usr/sbin/mysqld
  821. #12 0x0000000000549ef4 in open_and_lock_tables () from /usr/sbin/mysqld
  822. #13 0x000000000064e4c3 in mysql_admin_table () from /usr/sbin/mysqld
  823. #14 0x000000000064f819 in Optimize_table_statement::execute () from /usr/sbin/mysqld
  824. #15 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  825. #16 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  826. #17 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  827. #18 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  828. #19 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  829. #20 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  830.  
  831. Thread 7 (LWP 11372):
  832. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  833. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  834.  
  835. Thread 6 (LWP 11374):
  836. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  837. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  838.  
  839. Thread 5 (LWP 11377):
  840. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  841. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  842.  
  843. Thread 4 (LWP 11378):
  844. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  845. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  846. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  847. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  848. #05 0x0000000000832664 in innobase_show_status () from /usr/sbin/mysqld
  849. #06 0x00000000006cb5d8 in ha_show_status () from /usr/sbin/mysqld
  850. #07 0x0000000000588697 in mysql_execute_command () from /usr/sbin/mysqld
  851. #08 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  852. #09 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  853. #10 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  854. #11 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  855. #12 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  856.  
  857. Thread 3 (LWP 11380):
  858. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  859. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  860.  
  861. Thread 2 (LWP 11532):
  862. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  863. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  864.  
  865. Thread 1 (LWP 10273):
  866. #01 0x0000003c044dc613 in __GI___poll () from /lib64/libc-2.12.so
  867. #02 0x000000000050785c in handle_connections_sockets () from /usr/sbin/mysqld
  868. #03 0x0000000000508ece in mysqld_main () from /usr/sbin/mysqld
  869. #04 0x0000003c0441ecdd in __libc_start_main () from /lib64/libc-2.12.so
  870. #05 0x00000000004fe051 in _start () from /usr/sbin/mysql
  871.  
  872.  
  873.  
  874.  
  875.  
  876. 2 tentative
  877.  
  878.  
  879.  
  880.  
  881.  
  882.  
  883. [root@mariadb2 ~]# cat /root/quickstack.log2
  884.  
  885. Thread 39 (LWP 19430):
  886. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  887. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  888. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  889. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  890. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  891.  
  892. Thread 38 (LWP 19431):
  893. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  894. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  895. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  896. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  897. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  898.  
  899. Thread 37 (LWP 19432):
  900. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  901. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  902. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  903. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  904. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  905.  
  906. Thread 36 (LWP 19433):
  907. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  908. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  909. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  910. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  911. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  912.  
  913. Thread 35 (LWP 19434):
  914. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  915. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  916. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  917. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  918. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  919.  
  920. Thread 34 (LWP 19435):
  921. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  922. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  923. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  924. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  925. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  926.  
  927. Thread 33 (LWP 19436):
  928. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  929. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  930. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  931. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  932. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  933.  
  934. Thread 32 (LWP 19437):
  935. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  936. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  937. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  938. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  939. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  940.  
  941. Thread 31 (LWP 19438):
  942. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  943. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  944. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  945. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  946. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  947.  
  948. Thread 30 (LWP 19439):
  949. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  950. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  951. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  952. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  953. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  954.  
  955. Thread 29 (LWP 19440):
  956. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  957. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  958. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  959. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  960. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  961.  
  962. Thread 28 (LWP 19441):
  963. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  964. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  965. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  966. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  967. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  968.  
  969. Thread 27 (LWP 19442):
  970. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  971. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  972. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  973. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  974. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  975.  
  976. Thread 26 (LWP 19443):
  977. #01 0x00000000009579e4 in __io_getevents_0_4 () from /usr/sbin/mysqld
  978. #02 0x000000000092c154 in os_aio_linux_handle () from /usr/sbin/mysqld
  979. #03 0x00000000008e2c53 in fil_aio_wait () from /usr/sbin/mysqld
  980. #04 0x00000000008675f8 in io_handler_thread () from /usr/sbin/mysqld
  981. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  982.  
  983. Thread 25 (LWP 19445):
  984. #01 0x0000003c0480b75b in __pthread_cond_timedwait () from /lib64/libpthread-2.12.so
  985. #02 0x000000000092dfb3 in os_event_wait_time_low () from /usr/sbin/mysqld
  986. #03 0x0000000000862de0 in srv_lock_timeout_thread () from /usr/sbin/mysqld
  987. #04 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  988.  
  989. Thread 24 (LWP 19446):
  990. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  991. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  992. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  993. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  994. #05 0x0000000000862cb1 in srv_error_monitor_thread () from /usr/sbin/mysqld
  995. #06 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  996.  
  997. Thread 23 (LWP 19447):
  998. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  999. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1000. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1001. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  1002. #05 0x00000000008656a4 in srv_printf_innodb_monitor.clone.3 () from /usr/sbin/mysqld
  1003. #06 0x00000000008658b0 in srv_monitor_thread () from /usr/sbin/mysqld
  1004. #07 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1005.  
  1006. Thread 22 (LWP 19448):
  1007. #01 0x0000003c0480b75b in __pthread_cond_timedwait () from /lib64/libpthread-2.12.so
  1008. #02 0x000000000092dfb3 in os_event_wait_time_low () from /usr/sbin/mysqld
  1009. #03 0x00000000008608d3 in srv_LRU_dump_restore_thread () from /usr/sbin/mysqld
  1010. #04 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1011.  
  1012. Thread 21 (LWP 19449):
  1013. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1014. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1015. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1016. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  1017. #05 0x00000000008b89f9 in buf_flush_page_and_try_neighbors () from /usr/sbin/mysqld
  1018. #06 0x00000000008b921f in buf_flush_batch () from /usr/sbin/mysqld
  1019. #07 0x00000000008b99a0 in buf_flush_list () from /usr/sbin/mysqld
  1020. #08 0x0000000000864c0e in srv_master_thread () from /usr/sbin/mysqld
  1021. #09 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1022.  
  1023. Thread 20 (LWP 19450):
  1024. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1025. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1026. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1027. #04 0x000000000086bb50 in rw_lock_s_lock_spin () from /usr/sbin/mysqld
  1028. #05 0x0000000000846f75 in row_mysql_freeze_data_dictionary_func () from /usr/sbin/mysqld
  1029. #06 0x000000000094dcb5 in row_purge_step () from /usr/sbin/mysqld
  1030. #07 0x0000000000942a57 in que_run_threads () from /usr/sbin/mysqld
  1031. #08 0x000000000086fca6 in trx_purge () from /usr/sbin/mysqld
  1032. #09 0x0000000000865efc in srv_purge_thread () from /usr/sbin/mysqld
  1033. #10 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1034.  
  1035. Thread 19 (LWP 19454):
  1036. #01 0x0000003c0480b75b in __pthread_cond_timedwait () from /lib64/libpthread-2.12.so
  1037. #02 0x00000000009a676f in my_service_thread_sleep () from /usr/sbin/mysqld
  1038. #03 0x0000000000a6b389 in my_thread_init () from /usr/sbin/mysqld
  1039. #04 0x000000000099ec6b in ma_checkpoint_background () from /usr/sbin/mysqld
  1040. #05 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1041.  
  1042. Thread 18 (LWP 19457):
  1043. #01 0x0000003c0480f245 in sigwait () from /lib64/libpthread-2.12.so
  1044. #02 0x0000000000a6983f in my_close () from /usr/sbin/mysqld
  1045. #03 0x0000003c0480e499 in __write_nocancel () from /lib64/libpthread-2.12.so
  1046. #04 0x0000000000a7382e in my_pthread_fastmutex_lock () from /usr/sbin/mysqld
  1047. #05 0x0000000000506a73 in signal_hand () from /usr/sbin/mysqld
  1048. #06 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1049.  
  1050. Thread 17 (LWP 19459):
  1051. #01 0x0000003c0480e4ed in __read_nocancel () from /lib64/libpthread-2.12.so
  1052. #02 0x0000000000aa06e8 in vio_read () from /usr/sbin/mysqld
  1053. #03 0x000000000050b021 in my_real_read () from /usr/sbin/mysqld
  1054. #04 0x000000000050b44c in my_net_read () from /usr/sbin/mysqld
  1055. #05 0x000000000058cc22 in do_command () from /usr/sbin/mysqld
  1056. #06 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1057. #07 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1058. #08 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1059.  
  1060. Thread 16 (LWP 19462):
  1061. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1062. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1063. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1064. #04 0x000000000086c370 in rw_lock_x_lock_func () from /usr/sbin/mysqld
  1065. #05 0x000000000084a70b in row_mysql_lock_data_dictionary_func () from /usr/sbin/mysqld
  1066. #06 0x00000000008321bc in ha_innobase::rename_table () from /usr/sbin/mysqld
  1067. #07 0x00000000005f2041 in mysql_rename_table () from /usr/sbin/mysqld
  1068. #08 0x00000000005fcab7 in mysql_alter_table () from /usr/sbin/mysqld
  1069. #09 0x00000000005fde07 in mysql_recreate_table () from /usr/sbin/mysqld
  1070. #10 0x000000000064d6bd in admin_recreate_table () from /usr/sbin/mysqld
  1071. #11 0x000000000064ec48 in mysql_admin_table () from /usr/sbin/mysqld
  1072. #12 0x000000000064f819 in Optimize_table_statement::execute () from /usr/sbin/mysqld
  1073. #13 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  1074. #14 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1075. #15 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1076. #16 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1077. #17 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1078. #18 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1079.  
  1080. Thread 15 (LWP 19466):
  1081. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1082. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1083. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1084. #04 0x000000000086c370 in rw_lock_x_lock_func () from /usr/sbin/mysqld
  1085. #05 0x000000000084a70b in row_mysql_lock_data_dictionary_func () from /usr/sbin/mysqld
  1086. #06 0x000000000082edfa in ha_innobase::create () from /usr/sbin/mysqld
  1087. #07 0x00000000006cc013 in ha_create_table () from /usr/sbin/mysqld
  1088. #08 0x00000000006298cb in rea_create_table () from /usr/sbin/mysqld
  1089. #09 0x00000000005f8540 in mysql_create_table_no_lock () from /usr/sbin/mysqld
  1090. #10 0x00000000005fbb01 in mysql_alter_table () from /usr/sbin/mysqld
  1091. #11 0x000000000080896f in Alter_table_statement::execute () from /usr/sbin/mysqld
  1092. #12 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  1093. #13 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1094. #14 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1095. #15 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1096. #16 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1097. #17 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1098.  
  1099. Thread 14 (LWP 19527):
  1100. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1101. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  1102.  
  1103. Thread 13 (LWP 19541):
  1104. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1105. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1106. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1107. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  1108. #05 0x00000000008cabb0 in pfs_mutex_enter_func.clone.1 () from /usr/sbin/mysqld
  1109. #06 0x00000000008cac31 in dict_table_decrement_handle_count () from /usr/sbin/mysqld
  1110. #07 0x0000000000849c67 in row_prebuilt_free () from /usr/sbin/mysqld
  1111. #08 0x000000000082d69b in ha_innobase::close () from /usr/sbin/mysqld
  1112. #09 0x0000000000618eb9 in closefrm () from /usr/sbin/mysqld
  1113. #10 0x0000000000543ef3 in free_cache_entry () from /usr/sbin/mysqld
  1114. #11 0x000000000054602e in close_thread_table () from /usr/sbin/mysqld
  1115. #12 0x00000000005462f3 in close_thread_tables () from /usr/sbin/mysqld
  1116. #13 0x00000000005858cf in mysql_execute_command () from /usr/sbin/mysqld
  1117. #14 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1118. #15 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1119. #16 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1120. #17 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1121. #18 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1122.  
  1123. Thread 12 (LWP 19560):
  1124. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1125. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1126. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1127. #04 0x000000000086c2d5 in rw_lock_x_lock_func () from /usr/sbin/mysqld
  1128. #05 0x00000000008b552c in buf_page_create () from /usr/sbin/mysqld
  1129. #06 0x00000000008f2cc8 in fsp_page_create () from /usr/sbin/mysqld
  1130. #07 0x00000000008f5fb3 in fseg_alloc_free_page_low () from /usr/sbin/mysqld
  1131. #08 0x00000000008f6965 in fseg_alloc_free_page_general () from /usr/sbin/mysqld
  1132. #09 0x000000000089a934 in btr_store_big_rec_extern_fields () from /usr/sbin/mysqld
  1133. #10 0x000000000094b74f in row_ins_index_entry_low () from /usr/sbin/mysqld
  1134. #11 0x000000000094ca1f in row_ins_step () from /usr/sbin/mysqld
  1135. #12 0x0000000000848556 in row_insert_for_mysql () from /usr/sbin/mysqld
  1136. #13 0x000000000083327e in ha_innobase::write_row () from /usr/sbin/mysqld
  1137. #14 0x00000000006ca64d in handler::ha_write_row () from /usr/sbin/mysqld
  1138. #15 0x00000000005fd5ce in mysql_alter_table () from /usr/sbin/mysqld
  1139. #16 0x00000000005fde07 in mysql_recreate_table () from /usr/sbin/mysqld
  1140. #17 0x000000000064d6bd in admin_recreate_table () from /usr/sbin/mysqld
  1141. #18 0x000000000064ec48 in mysql_admin_table () from /usr/sbin/mysqld
  1142. #19 0x000000000064f819 in Optimize_table_statement::execute () from /usr/sbin/mysqld
  1143. #20 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  1144. #21 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1145. #22 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1146. #23 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1147. #24 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1148. #25 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1149.  
  1150. Thread 11 (LWP 19584):
  1151. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1152. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1153. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1154. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  1155. #05 0x00000000008b9e1e in pfs_mutex_enter_func () from /usr/sbin/mysqld
  1156. #06 0x00000000008bf57c in buf_LRU_try_free_flushed_blocks () from /usr/sbin/mysqld
  1157. #07 0x00000000008bf66a in buf_LRU_try_free_flushed_blocks () from /usr/sbin/mysqld
  1158. #08 0x000000000089e200 in btr_cur_search_to_nth_level () from /usr/sbin/mysqld
  1159. #09 0x000000000094a5af in row_ins_index_entry_low () from /usr/sbin/mysqld
  1160. #10 0x000000000094ca1f in row_ins_step () from /usr/sbin/mysqld
  1161. #11 0x0000000000848556 in row_insert_for_mysql () from /usr/sbin/mysqld
  1162. #12 0x000000000083327e in ha_innobase::write_row () from /usr/sbin/mysqld
  1163. #13 0x00000000006ca64d in handler::ha_write_row () from /usr/sbin/mysqld
  1164. #14 0x00000000005fd5ce in mysql_alter_table () from /usr/sbin/mysqld
  1165. #15 0x000000000080896f in Alter_table_statement::execute () from /usr/sbin/mysqld
  1166. #16 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  1167. #17 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1168. #18 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1169. #19 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1170. #20 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1171. #21 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1172.  
  1173. Thread 10 (LWP 19608):
  1174. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1175. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1176. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1177. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  1178. #05 0x00000000008b9e1e in pfs_mutex_enter_func () from /usr/sbin/mysqld
  1179. #06 0x00000000008bf57c in buf_LRU_try_free_flushed_blocks () from /usr/sbin/mysqld
  1180. #07 0x00000000008bf66a in buf_LRU_try_free_flushed_blocks () from /usr/sbin/mysqld
  1181. #08 0x000000000089e200 in btr_cur_search_to_nth_level () from /usr/sbin/mysqld
  1182. #09 0x000000000094a5af in row_ins_index_entry_low () from /usr/sbin/mysqld
  1183. #10 0x000000000094ca1f in row_ins_step () from /usr/sbin/mysqld
  1184. #11 0x0000000000848556 in row_insert_for_mysql () from /usr/sbin/mysqld
  1185. #12 0x000000000083327e in ha_innobase::write_row () from /usr/sbin/mysqld
  1186. #13 0x00000000006ca64d in handler::ha_write_row () from /usr/sbin/mysqld
  1187. #14 0x00000000005fd5ce in mysql_alter_table () from /usr/sbin/mysqld
  1188. #15 0x00000000005fde07 in mysql_recreate_table () from /usr/sbin/mysqld
  1189. #16 0x000000000064d6bd in admin_recreate_table () from /usr/sbin/mysqld
  1190. #17 0x000000000064ec48 in mysql_admin_table () from /usr/sbin/mysqld
  1191. #18 0x000000000064f819 in Optimize_table_statement::execute () from /usr/sbin/mysqld
  1192. #19 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  1193. #20 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1194. #21 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1195. #22 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1196. #23 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1197. #24 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1198.  
  1199. Thread 9 (LWP 19715):
  1200. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1201. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1202. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1203. #04 0x000000000086c370 in rw_lock_x_lock_func () from /usr/sbin/mysqld
  1204. #05 0x000000000084a70b in row_mysql_lock_data_dictionary_func () from /usr/sbin/mysqld
  1205. #06 0x000000000082edfa in ha_innobase::create () from /usr/sbin/mysqld
  1206. #07 0x00000000006cc013 in ha_create_table () from /usr/sbin/mysqld
  1207. #08 0x00000000006298cb in rea_create_table () from /usr/sbin/mysqld
  1208. #09 0x00000000005f8540 in mysql_create_table_no_lock () from /usr/sbin/mysqld
  1209. #10 0x00000000005fbb01 in mysql_alter_table () from /usr/sbin/mysqld
  1210. #11 0x000000000080896f in Alter_table_statement::execute () from /usr/sbin/mysqld
  1211. #12 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  1212. #13 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1213. #14 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1214. #15 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1215. #16 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1216. #17 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1217.  
  1218. Thread 8 (LWP 19734):
  1219. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1220. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1221. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1222. #04 0x000000000086c370 in rw_lock_x_lock_func () from /usr/sbin/mysqld
  1223. #05 0x000000000084a70b in row_mysql_lock_data_dictionary_func () from /usr/sbin/mysqld
  1224. #06 0x000000000082edfa in ha_innobase::create () from /usr/sbin/mysqld
  1225. #07 0x00000000006cc013 in ha_create_table () from /usr/sbin/mysqld
  1226. #08 0x00000000006298cb in rea_create_table () from /usr/sbin/mysqld
  1227. #09 0x00000000005f8540 in mysql_create_table_no_lock () from /usr/sbin/mysqld
  1228. #10 0x00000000005fbb01 in mysql_alter_table () from /usr/sbin/mysqld
  1229. #11 0x000000000080896f in Alter_table_statement::execute () from /usr/sbin/mysqld
  1230. #12 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  1231. #13 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1232. #14 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1233. #15 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1234. #16 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1235. #17 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1236.  
  1237. Thread 7 (LWP 19746):
  1238. #01 0x0000003c0480dff4 in __lll_lock_wait () from /lib64/libpthread-2.12.so
  1239. #02 0x0000003c0480935e in _L_lock_995 () from /lib64/libpthread-2.12.so
  1240. #03 0x0000000000a738ef in my_pthread_fastmutex_lock () from /usr/sbin/mysqld
  1241. #04 0x0000000000546ef2 in tdc_remove_table () from /usr/sbin/mysqld
  1242. #05 0x0000000000546f72 in wait_while_table_is_used () from /usr/sbin/mysqld
  1243. #06 0x00000000005fb770 in mysql_alter_table () from /usr/sbin/mysqld
  1244. #07 0x000000000080896f in Alter_table_statement::execute () from /usr/sbin/mysqld
  1245. #08 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  1246. #09 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1247. #10 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1248. #11 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1249. #12 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1250. #13 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1251.  
  1252. Thread 6 (LWP 19814):
  1253. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1254. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1255. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1256. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  1257. #05 0x00000000008b9e1e in pfs_mutex_enter_func () from /usr/sbin/mysqld
  1258. #06 0x00000000008c03f1 in buf_LRU_flush_or_remove_pages () from /usr/sbin/mysqld
  1259. #07 0x00000000008ef584 in fil_delete_tablespace () from /usr/sbin/mysqld
  1260. #08 0x000000000084b28e in row_drop_table_for_mysql () from /usr/sbin/mysqld
  1261. #09 0x00000000008350c3 in ha_innobase::delete_table () from /usr/sbin/mysqld
  1262. #10 0x00000000006cc903 in ha_delete_table () from /usr/sbin/mysqld
  1263. #11 0x00000000005fa9d6 in quick_rm_table () from /usr/sbin/mysqld
  1264. #12 0x00000000005fcd71 in mysql_alter_table () from /usr/sbin/mysqld
  1265. #13 0x00000000005fde07 in mysql_recreate_table () from /usr/sbin/mysqld
  1266. #14 0x000000000064d6bd in admin_recreate_table () from /usr/sbin/mysqld
  1267. #15 0x000000000064ec48 in mysql_admin_table () from /usr/sbin/mysqld
  1268. #16 0x000000000064f819 in Optimize_table_statement::execute () from /usr/sbin/mysqld
  1269. #17 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  1270. #18 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1271. #19 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1272. #20 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1273. #21 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1274. #22 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1275.  
  1276. Thread 5 (LWP 19833):
  1277. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1278. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1279. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1280. #04 0x000000000086cadb in mutex_spin_wait () from /usr/sbin/mysqld
  1281. #05 0x00000000008ab48e in pfs_mutex_enter_func () from /usr/sbin/mysqld
  1282. #06 0x00000000008af435 in buf_print_io () from /usr/sbin/mysqld
  1283. #07 0x0000000000866f87 in srv_printf_innodb_monitor () from /usr/sbin/mysqld
  1284. #08 0x00000000008324f9 in innobase_show_status () from /usr/sbin/mysqld
  1285. #09 0x00000000006cb5d8 in ha_show_status () from /usr/sbin/mysqld
  1286. #10 0x0000000000588697 in mysql_execute_command () from /usr/sbin/mysqld
  1287. #11 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1288. #12 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1289. #13 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1290. #14 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1291. #15 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1292.  
  1293. Thread 4 (LWP 26962):
  1294. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1295. #02 0x0000000000509d7f in one_thread_per_connection_end () from /usr/sbin/mysqld
  1296. #03 0x0000000000600006 in Table_triggers_list::prepare_record1_accessors () from /usr/sbin/mysqld
  1297. #04 0x0000000000a00007 in ft_init_stopwords () from /usr/sbin/mysqld
  1298. #05 0x0000000000800000 in Item_nodeset_to_const_comparator::~Item_nodeset_to_const_comparator () from /usr/sbin/mysqld
  1299.  
  1300. Thread 3 (LWP 27245):
  1301. #01 0x0000003c0480e4ed in __read_nocancel () from /lib64/libpthread-2.12.so
  1302. #02 0x0000000000aa06e8 in vio_read () from /usr/sbin/mysqld
  1303. #03 0x000000000050b021 in my_real_read () from /usr/sbin/mysqld
  1304. #04 0x000000000050b44c in my_net_read () from /usr/sbin/mysqld
  1305. #05 0x000000000058cc22 in do_command () from /usr/sbin/mysqld
  1306. #06 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1307. #07 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1308. #08 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1309.  
  1310. Thread 2 (LWP 27479):
  1311. #01 0x0000003c0480b3dc in __pthread_cond_wait () from /lib64/libpthread-2.12.so
  1312. #02 0x000000000092e0f1 in os_event_wait_low () from /usr/sbin/mysqld
  1313. #03 0x000000000086b90f in sync_array_wait_event () from /usr/sbin/mysqld
  1314. #04 0x000000000086c370 in rw_lock_x_lock_func () from /usr/sbin/mysqld
  1315. #05 0x000000000084a8a4 in row_mysql_lock_data_dictionary_func.clone.3 () from /usr/sbin/mysqld
  1316. #06 0x000000000084a9c8 in row_drop_table_for_mysql () from /usr/sbin/mysqld
  1317. #07 0x00000000008350c3 in ha_innobase::delete_table () from /usr/sbin/mysqld
  1318. #08 0x00000000006cc903 in ha_delete_table () from /usr/sbin/mysqld
  1319. #09 0x00000000005fa9d6 in quick_rm_table () from /usr/sbin/mysqld
  1320. #10 0x00000000005fcd71 in mysql_alter_table () from /usr/sbin/mysqld
  1321. #11 0x00000000005fde07 in mysql_recreate_table () from /usr/sbin/mysqld
  1322. #12 0x000000000064d6bd in admin_recreate_table () from /usr/sbin/mysqld
  1323. #13 0x000000000064ec48 in mysql_admin_table () from /usr/sbin/mysqld
  1324. #14 0x000000000064f819 in Optimize_table_statement::execute () from /usr/sbin/mysqld
  1325. #15 0x0000000000585e36 in mysql_execute_command () from /usr/sbin/mysqld
  1326. #16 0x000000000058b389 in mysql_parse () from /usr/sbin/mysqld
  1327. #17 0x000000000058c688 in dispatch_command () from /usr/sbin/mysqld
  1328. #18 0x0000000000640b63 in do_handle_one_connection () from /usr/sbin/mysqld
  1329. #19 0x0000000000640cac in handle_one_connection () from /usr/sbin/mysqld
  1330. #20 0x0000003c048077f1 in start_thread () from /lib64/libpthread-2.12.so
  1331.  
  1332. Thread 1 (LWP 19428):
  1333. #01 0x0000003c044dc613 in __GI___poll () from /lib64/libc-2.12.so
  1334. #02 0x000000000050785c in handle_connections_sockets () from /usr/sbin/mysqld
  1335. #03 0x0000000000508ece in mysqld_main () from /usr/sbin/mysqld
  1336. #04 0x0000003c0441ecdd in __libc_start_main () from /lib64/libc-2.12.so
  1337. #05 0x00000000004fe051 in _start () from /usr/sbin/mysqld
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
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!