API tools faq
paste
Advertisement
Guest User

Long semaphore

a guest
Sep 24th, 2018
131
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 61.26 KB | None | 0 0
raw download clone embed print report
  1. 2018-09-25 1:06:34 4688 [Warning] InnoDB: A long semaphore wait:
  2. --Thread 6248 has waited at buf0buf.cc line 4133 for 241.00 seconds the semaphore:
  3. S-lock on RW-latch at 00000264312D7C58 created in file buf0buf.cc line 1468
  4. a writer (thread id 0) has reserved it in mode exclusive
  5. number of readers 0, waiters flag 1, lock_word: 0
  6. Last time read locked in file not yet reserved line 0
  7. Last time write locked in file buf0buf.cc line 5337
  8. 2018-09-25 1:06:34 4688 [Warning] InnoDB: A long semaphore wait:
  9. --Thread 6228 has waited at ibuf0ibuf.cc line 2532 for 241.00 seconds the semaphore:
  10. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  11. a writer (thread id 6248) has reserved it in mode exclusive
  12. number of readers 0, waiters flag 1, lock_word: 0
  13. Last time read locked in file ibuf0ibuf.cc line 4578
  14. Last time write locked in file mtr0mtr.ic line 147
  15. 2018-09-25 1:06:34 4688 [Warning] InnoDB: A long semaphore wait:
  16. --Thread 2192 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore:
  17. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  18.  
  19. 2018-09-25 1:06:34 4688 [Warning] InnoDB: A long semaphore wait:
  20. --Thread 6408 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore:
  21. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  22.  
  23. 2018-09-25 1:06:34 4688 [Warning] InnoDB: A long semaphore wait:
  24. --Thread 5668 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore:
  25. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  26.  
  27. 2018-09-25 1:06:34 4688 [Warning] InnoDB: A long semaphore wait:
  28. --Thread 2228 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore:
  29. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  30. a writer (thread id 6248) has reserved it in mode exclusive
  31. number of readers 0, waiters flag 1, lock_word: 0
  32. Last time read locked in file ibuf0ibuf.cc line 4578
  33. Last time write locked in file mtr0mtr.ic line 147
  34. 2018-09-25 1:06:34 4688 [Note] InnoDB: A semaphore wait:
  35. --Thread 6248 has waited at buf0buf.cc line 4133 for 241.00 seconds the semaphore:
  36. S-lock on RW-latch at 00000264312D7C58 created in file buf0buf.cc line 1468
  37. a writer (thread id 0) has reserved it in mode exclusive
  38. number of readers 0, waiters flag 1, lock_word: 0
  39. Last time read locked in file not yet reserved line 0
  40. Last time write locked in file buf0buf.cc line 5337
  41. 2018-09-25 1:06:34 4688 [Note] InnoDB: A semaphore wait:
  42. --Thread 6228 has waited at ibuf0ibuf.cc line 2532 for 241.00 seconds the semaphore:
  43. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  44. a writer (thread id 6248) has reserved it in mode exclusive
  45. number of readers 0, waiters flag 1, lock_word: 0
  46. Last time read locked in file ibuf0ibuf.cc line 4578
  47. Last time write locked in file mtr0mtr.ic line 147
  48. 2018-09-25 1:06:34 4688 [Note] InnoDB: A semaphore wait:
  49. --Thread 2192 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore:
  50. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  51.  
  52. 2018-09-25 1:06:34 4688 [Note] InnoDB: A semaphore wait:
  53. --Thread 6408 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore:
  54. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  55.  
  56. 2018-09-25 1:06:34 4688 [Note] InnoDB: A semaphore wait:
  57. --Thread 5668 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore:
  58. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  59.  
  60. 2018-09-25 1:06:34 4688 [Note] InnoDB: A semaphore wait:
  61. --Thread 2228 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore:
  62. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  63. a writer (thread id 6248) has reserved it in mode exclusive
  64. number of readers 0, waiters flag 1, lock_word: 0
  65. Last time read locked in file ibuf0ibuf.cc line 4578
  66. Last time write locked in file mtr0mtr.ic line 147
  67. 2018-09-25 1:06:34 4688 [Note] InnoDB: A semaphore wait:
  68. --Thread 5816 has waited at buf0flu.cc line 1246 for 240.00 seconds the semaphore:
  69. SX-lock on RW-latch at 000002646A128F88 created in file buf0buf.cc line 1468
  70. a writer (thread id 6248) has reserved it in mode SX
  71. number of readers 2, waiters flag 1, lock_word: ffffffe
  72. Last time read locked in file ibuf0ibuf.cc line 3460
  73. Last time write locked in file mtr0mtr.ic line 111
  74. 2018-09-25 1:06:34 4688 [Note] InnoDB: A semaphore wait:
  75. --Thread 6576 has waited at buf0buf.cc line 4133 for 99.00 seconds the semaphore:
  76. S-lock on RW-latch at 00000264521870C8 created in file buf0buf.cc line 1468
  77. a writer (thread id 0) has reserved it in mode exclusive
  78. number of readers 0, waiters flag 1, lock_word: 0
  79. Last time read locked in file not yet reserved line 0
  80. Last time write locked in file buf0buf.cc line 5337
  81. 2018-09-25 1:06:34 4688 [Note] InnoDB: A semaphore wait:
  82. --Thread 6748 has waited at buf0buf.cc line 4133 for 123.00 seconds the semaphore:
  83. S-lock on RW-latch at 0000026452175468 created in file buf0buf.cc line 1468
  84. a writer (thread id 0) has reserved it in mode exclusive
  85. number of readers 0, waiters flag 1, lock_word: 0
  86. Last time read locked in file not yet reserved line 0
  87. Last time write locked in file buf0buf.cc line 5337
  88. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  89. InnoDB: Pending reads 0, writes 0
  90.  
  91. 2018-09-25 1:06:49 6968 [Warning] Aborted connection 269 to db: 'syf' user: 'sYf' host: 'localhost' (Got an error reading communication packets)
  92.  
  93. =====================================
  94. 2018-09-25 01:06:52 0x21c INNODB MONITOR OUTPUT
  95. =====================================
  96. Per second averages calculated from the last 77 seconds
  97. -----------------
  98. BACKGROUND THREAD
  99. -----------------
  100. srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 0 srv_idle
  101. srv_master_thread log flush and writes: 0
  102. ----------
  103. SEMAPHORES
  104. ----------
  105. OS WAIT ARRAY INFO: reservation count 468
  106. --Thread 6248 has waited at buf0buf.cc line 4133 for 259.00 seconds the semaphore:
  107. S-lock on RW-latch at 00000264312D7C58 created in file buf0buf.cc line 1468
  108. a writer (thread id 0) has reserved it in mode exclusive
  109. number of readers 0, waiters flag 1, lock_word: 0
  110. Last time read locked in file not yet reserved line 0
  111. Last time write locked in file buf0buf.cc line 5337
  112. --Thread 6228 has waited at ibuf0ibuf.cc line 2532 for 259.00 seconds the semaphore:
  113. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  114. a writer (thread id 6248) has reserved it in mode exclusive
  115. number of readers 0, waiters flag 1, lock_word: 0
  116. Last time read locked in file ibuf0ibuf.cc line 4578
  117. Last time write locked in file mtr0mtr.ic line 147
  118. --Thread 2192 has waited at ibuf0ibuf.cc line 4394 for 259.00 seconds the semaphore:
  119. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  120.  
  121. --Thread 6408 has waited at ibuf0ibuf.cc line 4394 for 259.00 seconds the semaphore:
  122. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  123.  
  124. --Thread 5668 has waited at ibuf0ibuf.cc line 4394 for 259.00 seconds the semaphore:
  125. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  126.  
  127. --Thread 2228 has waited at ibuf0ibuf.cc line 4578 for 259.00 seconds the semaphore:
  128. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  129. a writer (thread id 6248) has reserved it in mode exclusive
  130. number of readers 0, waiters flag 1, lock_word: 0
  131. Last time read locked in file ibuf0ibuf.cc line 4578
  132. Last time write locked in file mtr0mtr.ic line 147
  133. --Thread 5816 has waited at buf0flu.cc line 1246 for 258.00 seconds the semaphore:
  134. SX-lock on RW-latch at 000002646A128F88 created in file buf0buf.cc line 1468
  135. a writer (thread id 6248) has reserved it in mode SX
  136. number of readers 2, waiters flag 1, lock_word: ffffffe
  137. Last time read locked in file ibuf0ibuf.cc line 3460
  138. Last time write locked in file mtr0mtr.ic line 111
  139. --Thread 6576 has waited at buf0buf.cc line 4133 for 117.00 seconds the semaphore:
  140. S-lock on RW-latch at 00000264521870C8 created in file buf0buf.cc line 1468
  141. a writer (thread id 0) has reserved it in mode exclusive
  142. number of readers 0, waiters flag 1, lock_word: 0
  143. Last time read locked in file not yet reserved line 0
  144. Last time write locked in file buf0buf.cc line 5337
  145. --Thread 6748 has waited at buf0buf.cc line 4133 for 141.00 seconds the semaphore:
  146. S-lock on RW-latch at 0000026452175468 created in file buf0buf.cc line 1468
  147. a writer (thread id 0) has reserved it in mode exclusive
  148. number of readers 0, waiters flag 1, lock_word: 0
  149. Last time read locked in file not yet reserved line 0
  150. Last time write locked in file buf0buf.cc line 5337
  151. OS WAIT ARRAY INFO: signal count 393
  152. RW-shared spins 0, rounds 620, OS waits 307
  153. RW-excl spins 0, rounds 131, OS waits 8
  154. RW-sx spins 1, rounds 2, OS waits 0
  155. Spin rounds per wait: 620.00 RW-shared, 131.00 RW-excl, 2.00 RW-sx
  156. ------------
  157. TRANSACTIONS
  158. ------------
  159. Trx id counter 21424390672
  160. Purge done for trx's n:o < 21424390660 undo n:o < 0 state: running but idle
  161. History list length 5
  162. LIST OF TRANSACTIONS FOR EACH SESSION:
  163. ---TRANSACTION 284105271410120, not started
  164. 0 lock struct(s), heap size 1136, 0 row lock(s)
  165. ---TRANSACTION 284105271409256, not started
  166. 0 lock struct(s), heap size 1136, 0 row lock(s)
  167. ---TRANSACTION 21424341714, ACTIVE 276 sec recovered trx
  168. ROLLING BACK 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1011483
  169. --------
  170. FILE I/O
  171. --------
  172. I/O thread 0 state: complete io for buf page (insert buffer thread)
  173. I/O thread 1 state: complete io for buf page (log thread)
  174. I/O thread 2 state: complete io for buf page (read thread)
  175. I/O thread 3 state: complete io for buf page (read thread)
  176. I/O thread 4 state: native aio handle (read thread)
  177. I/O thread 5 state: native aio handle (read thread)
  178. I/O thread 6 state: native aio handle (write thread)
  179. I/O thread 7 state: native aio handle (write thread)
  180. I/O thread 8 state: native aio handle (write thread)
  181. I/O thread 9 state: native aio handle (write thread)
  182. Pending normal aio reads: [1, 1, 64, 65] , aio writes: [0, 0, 0, 0] ,
  183. ibuf aio reads:, log i/o's:, sync i/o's:
  184. Pending flushes (fsync) log: 0; buffer pool: 0
  185. 59009 OS file reads, 11 OS file writes, 11 OS fsyncs
  186. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  187. -------------------------------------
  188. INSERT BUFFER AND ADAPTIVE HASH INDEX
  189. -------------------------------------
  190. 2018-09-25 1:06:54 6968 [Warning] Aborted connection 275 to db: 'syf' user: 'sYf' host: 'localhost' (Got an error reading communication packets)
  191. InnoDB: ###### Diagnostic info printed to the standard error stream
  192.  
  193. 2018-09-25 1:07:05 4688 [Warning] InnoDB: A long semaphore wait:
  194. --Thread 6248 has waited at buf0buf.cc line 4133 for 272.00 seconds the semaphore:
  195. S-lock on RW-latch at 00000264312D7C58 created in file buf0buf.cc line 1468
  196. a writer (thread id 0) has reserved it in mode exclusive
  197. number of readers 0, waiters flag 1, lock_word: 0
  198. Last time read locked in file not yet reserved line 0
  199. Last time write locked in file buf0buf.cc line 5337
  200. 2018-09-25 1:07:05 4688 [Warning] InnoDB: A long semaphore wait:
  201. --Thread 6228 has waited at ibuf0ibuf.cc line 2532 for 272.00 seconds the semaphore:
  202. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  203. a writer (thread id 6248) has reserved it in mode exclusive
  204. number of readers 0, waiters flag 1, lock_word: 0
  205. Last time read locked in file ibuf0ibuf.cc line 4578
  206. Last time write locked in file mtr0mtr.ic line 147
  207. 2018-09-25 1:07:05 4688 [Warning] InnoDB: A long semaphore wait:
  208. --Thread 2192 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore:
  209. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  210.  
  211. 2018-09-25 1:07:05 4688 [Warning] InnoDB: A long semaphore wait:
  212. --Thread 6408 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore:
  213. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  214.  
  215. 2018-09-25 1:07:05 4688 [Warning] InnoDB: A long semaphore wait:
  216. --Thread 5668 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore:
  217. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  218.  
  219. 2018-09-25 1:07:05 4688 [Warning] InnoDB: A long semaphore wait:
  220. --Thread 2228 has waited at ibuf0ibuf.cc line 4578 for 272.00 seconds the semaphore:
  221. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  222. a writer (thread id 6248) has reserved it in mode exclusive
  223. number of readers 0, waiters flag 1, lock_word: 0
  224. Last time read locked in file ibuf0ibuf.cc line 4578
  225. Last time write locked in file mtr0mtr.ic line 147
  226. 2018-09-25 1:07:05 4688 [Warning] InnoDB: A long semaphore wait:
  227. --Thread 5816 has waited at buf0flu.cc line 1246 for 271.00 seconds the semaphore:
  228. SX-lock on RW-latch at 000002646A128F88 created in file buf0buf.cc line 1468
  229. a writer (thread id 6248) has reserved it in mode SX
  230. number of readers 2, waiters flag 1, lock_word: ffffffe
  231. Last time read locked in file ibuf0ibuf.cc line 3460
  232. Last time write locked in file mtr0mtr.ic line 111
  233. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  234. --Thread 6248 has waited at buf0buf.cc line 4133 for 272.00 seconds the semaphore:
  235. S-lock on RW-latch at 00000264312D7C58 created in file buf0buf.cc line 1468
  236. a writer (thread id 0) has reserved it in mode exclusive
  237. number of readers 0, waiters flag 1, lock_word: 0
  238. Last time read locked in file not yet reserved line 0
  239. Last time write locked in file buf0buf.cc line 5337
  240. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  241. --Thread 6228 has waited at ibuf0ibuf.cc line 2532 for 272.00 seconds the semaphore:
  242. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  243. a writer (thread id 6248) has reserved it in mode exclusive
  244. number of readers 0, waiters flag 1, lock_word: 0
  245. Last time read locked in file ibuf0ibuf.cc line 4578
  246. Last time write locked in file mtr0mtr.ic line 147
  247. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  248. --Thread 2192 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore:
  249. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  250.  
  251. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  252. --Thread 6408 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore:
  253. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  254.  
  255. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  256. --Thread 5668 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore:
  257. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  258.  
  259. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  260. --Thread 2228 has waited at ibuf0ibuf.cc line 4578 for 272.00 seconds the semaphore:
  261. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  262. a writer (thread id 6248) has reserved it in mode exclusive
  263. number of readers 0, waiters flag 1, lock_word: 0
  264. Last time read locked in file ibuf0ibuf.cc line 4578
  265. Last time write locked in file mtr0mtr.ic line 147
  266. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  267. --Thread 5816 has waited at buf0flu.cc line 1246 for 271.00 seconds the semaphore:
  268. SX-lock on RW-latch at 000002646A128F88 created in file buf0buf.cc line 1468
  269. a writer (thread id 6248) has reserved it in mode SX
  270. number of readers 2, waiters flag 1, lock_word: ffffffe
  271. Last time read locked in file ibuf0ibuf.cc line 3460
  272. Last time write locked in file mtr0mtr.ic line 111
  273. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  274. --Thread 6576 has waited at buf0buf.cc line 4133 for 130.00 seconds the semaphore:
  275. S-lock on RW-latch at 00000264521870C8 created in file buf0buf.cc line 1468
  276. a writer (thread id 0) has reserved it in mode exclusive
  277. number of readers 0, waiters flag 1, lock_word: 0
  278. Last time read locked in file not yet reserved line 0
  279. Last time write locked in file buf0buf.cc line 5337
  280. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  281. --Thread 6748 has waited at buf0buf.cc line 4133 for 154.00 seconds the semaphore:
  282. S-lock on RW-latch at 0000026452175468 created in file buf0buf.cc line 1468
  283. a writer (thread id 0) has reserved it in mode exclusive
  284. number of readers 0, waiters flag 1, lock_word: 0
  285. Last time read locked in file not yet reserved line 0
  286. Last time write locked in file buf0buf.cc line 5337
  287. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  288. --Thread 540 has waited at ibuf0ibuf.cc line 4921 for 13.00 seconds the semaphore:
  289. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  290.  
  291. 2018-09-25 1:07:05 4688 [Note] InnoDB: A semaphore wait:
  292. --Thread 6968 has waited at buf0buf.cc line 4133 for 3.00 seconds the semaphore:
  293. S-lock on RW-latch at 0000026495EA2678 created in file buf0buf.cc line 1468
  294. a writer (thread id 0) has reserved it in mode exclusive
  295. number of readers 0, waiters flag 1, lock_word: 0
  296. Last time read locked in file not yet reserved line 0
  297. Last time write locked in file buf0buf.cc line 5337
  298.  
  299. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  300. InnoDB: Pending reads 0, writes 0
  301. InnoDB: ###### Diagnostic info printed to the standard error stream
  302.  
  303. 2018-09-25 1:07:36 4688 [Warning] InnoDB: A long semaphore wait:
  304. --Thread 6248 has waited at buf0buf.cc line 4133 for 303.00 seconds the semaphore:
  305. S-lock on RW-latch at 00000264312D7C58 created in file buf0buf.cc line 1468
  306. a writer (thread id 0) has reserved it in mode exclusive
  307. number of readers 0, waiters flag 1, lock_word: 0
  308. Last time read locked in file not yet reserved line 0
  309. Last time write locked in file buf0buf.cc line 5337
  310. 2018-09-25 1:07:36 4688 [Warning] InnoDB: A long semaphore wait:
  311. --Thread 6228 has waited at ibuf0ibuf.cc line 2532 for 303.00 seconds the semaphore:
  312. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  313. a writer (thread id 6248) has reserved it in mode exclusive
  314. number of readers 0, waiters flag 1, lock_word: 0
  315. Last time read locked in file ibuf0ibuf.cc line 4578
  316. Last time write locked in file mtr0mtr.ic line 147
  317. 2018-09-25 1:07:36 4688 [Warning] InnoDB: A long semaphore wait:
  318. --Thread 2192 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore:
  319. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  320.  
  321. 2018-09-25 1:07:36 4688 [Warning] InnoDB: A long semaphore wait:
  322. --Thread 6408 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore:
  323. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  324.  
  325. 2018-09-25 1:07:36 4688 [Warning] InnoDB: A long semaphore wait:
  326. --Thread 5668 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore:
  327. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  328.  
  329. 2018-09-25 1:07:36 4688 [Warning] InnoDB: A long semaphore wait:
  330. --Thread 2228 has waited at ibuf0ibuf.cc line 4578 for 303.00 seconds the semaphore:
  331. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  332. a writer (thread id 6248) has reserved it in mode exclusive
  333. number of readers 0, waiters flag 1, lock_word: 0
  334. Last time read locked in file ibuf0ibuf.cc line 4578
  335. Last time write locked in file mtr0mtr.ic line 147
  336. 2018-09-25 1:07:36 4688 [Warning] InnoDB: A long semaphore wait:
  337. --Thread 5816 has waited at buf0flu.cc line 1246 for 302.00 seconds the semaphore:
  338. SX-lock on RW-latch at 000002646A128F88 created in file buf0buf.cc line 1468
  339. a writer (thread id 6248) has reserved it in mode SX
  340. number of readers 2, waiters flag 1, lock_word: ffffffe
  341. Last time read locked in file ibuf0ibuf.cc line 3460
  342. Last time write locked in file mtr0mtr.ic line 111
  343. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  344. --Thread 6248 has waited at buf0buf.cc line 4133 for 303.00 seconds the semaphore:
  345. S-lock on RW-latch at 00000264312D7C58 created in file buf0buf.cc line 1468
  346. a writer (thread id 0) has reserved it in mode exclusive
  347. number of readers 0, waiters flag 1, lock_word: 0
  348. Last time read locked in file not yet reserved line 0
  349. Last time write locked in file buf0buf.cc line 5337
  350. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  351. --Thread 6228 has waited at ibuf0ibuf.cc line 2532 for 303.00 seconds the semaphore:
  352. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  353. a writer (thread id 6248) has reserved it in mode exclusive
  354. number of readers 0, waiters flag 1, lock_word: 0
  355. Last time read locked in file ibuf0ibuf.cc line 4578
  356. Last time write locked in file mtr0mtr.ic line 147
  357. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  358. --Thread 2192 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore:
  359. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  360.  
  361. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  362. --Thread 6408 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore:
  363. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  364.  
  365. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  366. --Thread 5668 has waited at ibuf0ibuf.cc line 4394 for 303.00 seconds the semaphore:
  367. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  368.  
  369. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  370. --Thread 2228 has waited at ibuf0ibuf.cc line 4578 for 303.00 seconds the semaphore:
  371. S-lock on RW-latch at 00000264B7A6AF48 created in file buf0buf.cc line 1468
  372. a writer (thread id 6248) has reserved it in mode exclusive
  373. number of readers 0, waiters flag 1, lock_word: 0
  374. Last time read locked in file ibuf0ibuf.cc line 4578
  375. Last time write locked in file mtr0mtr.ic line 147
  376. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  377. --Thread 5816 has waited at buf0flu.cc line 1246 for 302.00 seconds the semaphore:
  378. SX-lock on RW-latch at 000002646A128F88 created in file buf0buf.cc line 1468
  379. a writer (thread id 6248) has reserved it in mode SX
  380. number of readers 2, waiters flag 1, lock_word: ffffffe
  381. Last time read locked in file ibuf0ibuf.cc line 3460
  382. Last time write locked in file mtr0mtr.ic line 111
  383. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  384. --Thread 6576 has waited at buf0buf.cc line 4133 for 161.00 seconds the semaphore:
  385. S-lock on RW-latch at 00000264521870C8 created in file buf0buf.cc line 1468
  386. a writer (thread id 0) has reserved it in mode exclusive
  387. number of readers 0, waiters flag 1, lock_word: 0
  388. Last time read locked in file not yet reserved line 0
  389. Last time write locked in file buf0buf.cc line 5337
  390. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  391. --Thread 6748 has waited at buf0buf.cc line 4133 for 185.00 seconds the semaphore:
  392. S-lock on RW-latch at 0000026452175468 created in file buf0buf.cc line 1468
  393. a writer (thread id 0) has reserved it in mode exclusive
  394. number of readers 0, waiters flag 1, lock_word: 0
  395. Last time read locked in file not yet reserved line 0
  396. Last time write locked in file buf0buf.cc line 5337
  397. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  398. --Thread 540 has waited at ibuf0ibuf.cc line 4921 for 44.00 seconds the semaphore:
  399. Mutex at 00007FF76C9A6468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  400.  
  401. 2018-09-25 1:07:36 4688 [Note] InnoDB: A semaphore wait:
  402. --Thread 6968 has waited at buf0buf.cc line 4133 for 34.00 seconds the semaphore:
  403. S-lock on RW-latch at 0000026495EA2678 created in file buf0buf.cc line 1468
  404. a writer (thread id 0) has reserved it in mode exclusive
  405. number of readers 0, waiters flag 1, lock_word: 0
  406. Last time read locked in file not yet reserved line 0
  407. Last time write locked in file buf0buf.cc line 5337
  408. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  409. InnoDB: Pending reads 0, writes 0
  410. 2018-09-25 1:07:37 6432 [Warning] Access denied for user 'vnix'@'localhost' (using password: YES)
  411. 2018-09-25 1:07:38 6432 [Warning] Aborted connection 256 to db: 'reonyx_syfleet' user: 'sYfLeEtShInYaNg' host: 'localhost' (Got an error reading communication packets)
  412. 2018-09-25 1:07:48 6532 [Note] C:\Program Files\MariaDB 10.2\bin\mysqld.exe (unknown): Normal shutdown
  413.  
  414. 2018-09-25 1:07:48 6532 [Note] Event Scheduler: Purging the queue. 0 events
  415. 2018-09-25 1:07:48 6336 [Note] InnoDB: FTS optimize thread exiting.
  416. 2018-09-25 1:09:54 2812 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  417. 2018-09-25 1:09:54 2812 [Note] InnoDB: Uses event mutexes
  418. 2018-09-25 1:09:54 2812 [Note] InnoDB: Compressed tables use zlib 1.2.3
  419. 2018-09-25 1:09:54 2812 [Note] InnoDB: Number of pools: 1
  420. 2018-09-25 1:09:54 2812 [Note] InnoDB: Using generic crc32 instructions
  421. 2018-09-25 1:09:54 2812 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
  422. 2018-09-25 1:09:54 2812 [Note] InnoDB: Completed initialization of buffer pool
  423. 2018-09-25 1:09:54 2812 [Note] InnoDB: Highest supported file format is Barracuda.
  424. 2018-09-25 1:09:54 2812 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2669563327912
  425. 2018-09-25 1:10:05 2812 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 1011577 row operations to undo
  426. 2018-09-25 1:10:05 2812 [Note] InnoDB: Trx id counter is 21424391168
  427. 2018-09-25 1:10:05 2812 [Note] InnoDB: Starting final batch to recover 23078 pages from redo log.
  428. 2018-09-25 1:10:09 4144 [Note] InnoDB: To recover: 11357 pages from log
  429. 2018-09-25 1:10:18 6892 [Note] InnoDB: Starting in background the rollback of recovered transactions
  430. 2018-09-25 1:10:18 2812 [Note] InnoDB: 128 out of 128 rollback segments are active.
  431. 2018-09-25 1:10:18 6892 [Note] InnoDB: Rolling back trx with id 21424341714, 1011577 rows to undo
  432.  
  433. InnoDB: Progress in percents: 12018-09-25 1:10:18 2812 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  434. 2018-09-25 1:10:18 2812 [Note] InnoDB: Creating shared tablespace for temporary tables
  435. 2018-09-25 1:10:18 2812 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  436. 2018-09-25 1:10:18 2812 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  437. 2018-09-25 1:10:18 2812 [Note] InnoDB: 5.7.20 started; log sequence number 2669567791590
  438. 2018-09-25 1:10:18 6932 [Note] InnoDB: Loading buffer pool(s) from C:\Program Files\MariaDB 10.2\data\ib_buffer_pool
  439. 2018-09-25 1:10:18 2812 [Note] Plugin 'FEEDBACK' is disabled.
  440. 2018-09-25 1:10:18 2812 [Note] Server socket created on IP: '::'.
  441. 2018-09-25 1:10:18 2812 [Note] Reading of all Master_info entries succeded
  442. 2018-09-25 1:10:18 2812 [Note] Added new Master_info '' to hash table
  443. 2018-09-25 1:10:18 2812 [Note] C:\Program Files\MariaDB 10.2\bin\mysqld.exe: ready for connections.
  444. Version: '10.2.10-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
  445. 2018-09-25 1:10:31 6932 [Note] InnoDB: Buffer pool(s) load completed at 180925 1:10:31
  446.  
  447. 2018-09-25 1:11:59 6940 [Note] C:\Program Files\MariaDB 10.2\bin\mysqld.exe (unknown): Normal shutdown
  448.  
  449. 2018-09-25 1:11:59 6940 [Note] Event Scheduler: Purging the queue. 0 events
  450. 2018-09-25 1:11:59 6884 [Note] InnoDB: FTS optimize thread exiting.
  451. 2018-09-25 1:11:59 6940 [Note] InnoDB: Starting shutdown...
  452. 2018-09-25 1:11:59 6932 [Note] InnoDB: Dumping buffer pool(s) to C:\Program Files\MariaDB 10.2\data\ib_buffer_pool
  453. 2018-09-25 1:11:59 6932 [Note] InnoDB: Buffer pool(s) dump completed at 180925 1:11:59
  454. 2018-09-25 1:13:00 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  455. 2018-09-25 1:14:01 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  456. 2018-09-25 1:15:01 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  457. 2018-09-25 1:16:02 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  458. 2018-09-25 1:17:03 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  459. 2018-09-25 1:18:03 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  460. 2018-09-25 1:19:04 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  461. 2018-09-25 1:20:05 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  462. 2018-09-25 1:11:59 6940 [Note] Event Scheduler: Purging the queue. 0 events
  463. 2018-09-25 1:11:59 6884 [Note] InnoDB: FTS optimize thread exiting.
  464. 2018-09-25 1:11:59 6940 [Note] InnoDB: Starting shutdown...
  465. 2018-09-25 1:11:59 6932 [Note] InnoDB: Dumping buffer pool(s) to C:\Program Files\MariaDB 10.2\data\ib_buffer_pool
  466. 2018-09-25 1:11:59 6932 [Note] InnoDB: Buffer pool(s) dump completed at 180925 1:11:59
  467. 2018-09-25 1:13:00 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  468. 2018-09-25 1:14:01 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  469. 2018-09-25 1:15:01 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  470. 2018-09-25 1:16:02 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  471. 2018-09-25 1:17:03 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  472. 2018-09-25 1:18:03 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  473. 2018-09-25 1:19:04 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  474. 2018-09-25 1:20:05 6940 [Note] InnoDB: Waiting for 1 active transactions to finish
  475.  
  476. 2018-09-25 1:31:53 2736 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  477. 2018-09-25 1:31:53 2736 [Note] InnoDB: Uses event mutexes
  478. 2018-09-25 1:31:53 2736 [Note] InnoDB: Compressed tables use zlib 1.2.3
  479. 2018-09-25 1:31:53 2736 [Note] InnoDB: Number of pools: 1
  480. 2018-09-25 1:31:53 2736 [Note] InnoDB: Using generic crc32 instructions
  481. 2018-09-25 1:31:53 2736 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  482. 2018-09-25 1:31:53 2736 [Note] InnoDB: Completed initialization of buffer pool
  483. 2018-09-25 1:31:53 2736 [Note] InnoDB: Highest supported file format is Barracuda.
  484. 2018-09-25 1:31:53 2736 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2669504893709
  485. 2018-09-25 1:31:59 2736 [Note] InnoDB: Starting a batch to recover 22207 pages from redo log.
  486. 2018-09-25 1:32:08 2736 [Note] InnoDB: Read redo log up to LSN=2669556732416
  487. 2018-09-25 1:32:16 2736 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 1011577 row operations to undo
  488. 2018-09-25 1:32:16 2736 [Note] InnoDB: Trx id counter is 21424391168
  489. 2018-09-25 1:32:16 2736 [Note] InnoDB: Starting final batch to recover 3390 pages from redo log.
  490. 2018-09-25 1:32:20 2736 [Note] InnoDB: 128 out of 128 rollback segments are active.
  491. 2018-09-25 1:32:20 4084 [Note] InnoDB: Starting in background the rollback of recovered transactions
  492. 2018-09-25 1:32:20 4084 [Note] InnoDB: Rolling back trx with id 21424341714, 1011577 rows to undo
  493. 2018-09-25 1:32:20 2736 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  494.  
  495. InnoDB: Progress in percents: 12018-09-25 1:32:20 2736 [Note] InnoDB: Creating shared tablespace for temporary tables
  496. 2018-09-25 1:32:20 2736 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  497. 2018-09-25 1:32:20 2736 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  498. 2018-09-25 1:32:20 2736 [Note] InnoDB: Waiting for purge to start
  499. 2018-09-25 1:32:20 2736 [Note] InnoDB: 5.7.20 started; log sequence number 2669567791590
  500. 2018-09-25 1:32:20 3792 [Note] InnoDB: Loading buffer pool(s) from C:\Program Files\MariaDB 10.2\data\ib_buffer_pool
  501. 2018-09-25 1:32:21 2736 [Note] Plugin 'FEEDBACK' is disabled.
  502. 2018-09-25 1:32:21 2736 [Note] Server socket created on IP: '::'.
  503. 2018-09-25 1:32:21 2736 [Note] Reading of all Master_info entries succeded
  504. 2018-09-25 1:32:21 2736 [Note] Added new Master_info '' to hash table
  505. 2018-09-25 1:32:21 2736 [Note] C:\Program Files\MariaDB 10.2\bin\mysqld.exe: ready for connections.
  506. Version: '10.2.10-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
  507. 2018-09-25 1:33:26 6292 [ERROR] mysqld.exe: Table '.\reonyx_syfleet\user' is marked as crashed and should be repaired
  508. 2018-09-25 1:33:26 6292 [ERROR] mysqld.exe: Table 'user' is marked as crashed and should be repaired
  509. 2018-09-25 1:33:26 6292 [Warning] Checking table: '.\reonyx_syfleet\user'
  510. 2018-09-25 1:34:02 6768 [Note] C:\Program Files\MariaDB 10.2\bin\mysqld.exe (unknown): Normal shutdown
  511.  
  512. 2018-09-25 1:34:02 6768 [Note] Event Scheduler: Purging the queue. 0 events
  513. 2018-09-25 1:34:02 6644 [Note] InnoDB: FTS optimize thread exiting.
  514. 2018-09-25 1:34:02 6768 [Note] InnoDB: Starting shutdown...
  515. 2018-09-25 1:35:03 6768 [Note] InnoDB: Waiting for 1 active transactions to finish
  516. 2018-09-25 1:36:04 6768 [Note] InnoDB: Waiting for 1 active transactions to finish
  517. 2018-09-25 1:37:28 2688 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  518. 2018-09-25 1:37:28 2688 [Note] InnoDB: Uses event mutexes
  519. 2018-09-25 1:37:28 2688 [Note] InnoDB: Compressed tables use zlib 1.2.3
  520. 2018-09-25 1:37:28 2688 [Note] InnoDB: Number of pools: 1
  521. 2018-09-25 1:37:28 2688 [Note] InnoDB: Using generic crc32 instructions
  522. 2018-09-25 1:37:28 2688 [Note] InnoDB: Initializing buffer pool, total size = 30G, instances = 8, chunk size = 128M
  523. 2018-09-25 1:37:29 2688 [Note] InnoDB: Completed initialization of buffer pool
  524. 2018-09-25 1:37:29 2688 [Note] InnoDB: Highest supported file format is Barracuda.
  525. 2018-09-25 1:37:29 2688 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2669504893709
  526. 2018-09-25 1:37:42 2688 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 1011371 row operations to undo
  527. 2018-09-25 1:37:42 2688 [Note] InnoDB: Trx id counter is 21424391936
  528. 2018-09-25 1:37:42 2688 [Note] InnoDB: Starting final batch to recover 23545 pages from redo log.
  529. 2018-09-25 1:37:44 3504 [Note] InnoDB: To recover: 17288 pages from log
  530. 2018-09-25 1:37:55 5552 [Note] InnoDB: Starting in background the rollback of recovered transactions
  531. 2018-09-25 1:37:55 2688 [Note] InnoDB: 128 out of 128 rollback segments are active.
  532. 2018-09-25 1:37:55 5552 [Note] InnoDB: Rolling back trx with id 21424341714, 1011371 rows to undo
  533.  
  534. InnoDB: Progress in percents: 12018-09-25 1:37:55 2688 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  535. 2018-09-25 1:37:55 2688 [Note] InnoDB: Creating shared tablespace for temporary tables
  536. 2018-09-25 1:37:55 2688 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  537. 2018-09-25 1:37:55 2688 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
  538. 2018-09-25 1:37:55 2688 [Note] InnoDB: Waiting for purge to start
  539. 2018-09-25 1:37:55 2688 [Note] InnoDB: 5.7.20 started; log sequence number 2669570149587
  540. 2018-09-25 1:37:55 5596 [Note] InnoDB: Loading buffer pool(s) from C:\Program Files\MariaDB 10.2\data\ib_buffer_pool
  541. 2018-09-25 1:37:55 2688 [Note] Plugin 'FEEDBACK' is disabled.
  542. 2018-09-25 1:37:55 2688 [Note] Server socket created on IP: '::'.
  543. 2018-09-25 1:37:55 2688 [Note] Reading of all Master_info entries succeded
  544. 2018-09-25 1:37:55 2688 [Note] Added new Master_info '' to hash table
  545. 2018-09-25 1:37:55 2688 [Note] C:\Program Files\MariaDB 10.2\bin\mysqld.exe: ready for connections.
  546. Version: '10.2.10-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
  547.  
  548. 2018-09-25 1:41:57 5560 [Warning] InnoDB: A long semaphore wait:
  549. --Thread 4092 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore:
  550. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  551.  
  552. 2018-09-25 1:41:57 5560 [Warning] InnoDB: A long semaphore wait:
  553. --Thread 4084 has waited at buf0buf.cc line 4133 for 241.00 seconds the semaphore:
  554. S-lock on RW-latch at 000002147A225D18 created in file buf0buf.cc line 1468
  555. a writer (thread id 0) has reserved it in mode exclusive
  556. number of readers 0, waiters flag 1, lock_word: 0
  557. Last time read locked in file not yet reserved line 0
  558. Last time write locked in file buf0buf.cc line 5337
  559. 2018-09-25 1:41:57 5560 [Warning] InnoDB: A long semaphore wait:
  560. --Thread 3504 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore:
  561. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  562.  
  563. 2018-09-25 1:41:57 5560 [Warning] InnoDB: A long semaphore wait:
  564. --Thread 5552 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore:
  565. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  566. a writer (thread id 4084) has reserved it in mode exclusive
  567. number of readers 0, waiters flag 1, lock_word: 0
  568. Last time read locked in file ibuf0ibuf.cc line 4578
  569. Last time write locked in file mtr0mtr.ic line 147
  570. 2018-09-25 1:41:57 5560 [Warning] InnoDB: A long semaphore wait:
  571. --Thread 5568 has waited at ibuf0ibuf.cc line 2532 for 241.00 seconds the semaphore:
  572. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  573. a writer (thread id 4084) has reserved it in mode exclusive
  574. number of readers 0, waiters flag 1, lock_word: 0
  575. Last time read locked in file ibuf0ibuf.cc line 4578
  576. Last time write locked in file mtr0mtr.ic line 147
  577. 2018-09-25 1:41:57 5560 [Warning] InnoDB: A long semaphore wait:
  578. --Thread 4088 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore:
  579. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  580. a writer (thread id 4084) has reserved it in mode exclusive
  581. number of readers 0, waiters flag 1, lock_word: 0
  582. Last time read locked in file ibuf0ibuf.cc line 4578
  583. Last time write locked in file mtr0mtr.ic line 147
  584. 2018-09-25 1:41:57 5560 [Note] InnoDB: A semaphore wait:
  585. --Thread 4092 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore:
  586. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  587.  
  588. 2018-09-25 1:41:57 5560 [Note] InnoDB: A semaphore wait:
  589. --Thread 4084 has waited at buf0buf.cc line 4133 for 241.00 seconds the semaphore:
  590. S-lock on RW-latch at 000002147A225D18 created in file buf0buf.cc line 1468
  591. a writer (thread id 0) has reserved it in mode exclusive
  592. number of readers 0, waiters flag 1, lock_word: 0
  593. Last time read locked in file not yet reserved line 0
  594. Last time write locked in file buf0buf.cc line 5337
  595. 2018-09-25 1:41:57 5560 [Note] InnoDB: A semaphore wait:
  596. --Thread 3504 has waited at ibuf0ibuf.cc line 4394 for 241.00 seconds the semaphore:
  597. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  598.  
  599. 2018-09-25 1:41:57 5560 [Note] InnoDB: A semaphore wait:
  600. --Thread 5552 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore:
  601. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  602. a writer (thread id 4084) has reserved it in mode exclusive
  603. number of readers 0, waiters flag 1, lock_word: 0
  604. Last time read locked in file ibuf0ibuf.cc line 4578
  605. Last time write locked in file mtr0mtr.ic line 147
  606. 2018-09-25 1:41:57 5560 [Note] InnoDB: A semaphore wait:
  607. --Thread 5568 has waited at ibuf0ibuf.cc line 2532 for 241.00 seconds the semaphore:
  608. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  609. a writer (thread id 4084) has reserved it in mode exclusive
  610. number of readers 0, waiters flag 1, lock_word: 0
  611. Last time read locked in file ibuf0ibuf.cc line 4578
  612. Last time write locked in file mtr0mtr.ic line 147
  613. 2018-09-25 1:41:57 5560 [Note] InnoDB: A semaphore wait:
  614. --Thread 4088 has waited at ibuf0ibuf.cc line 4578 for 241.00 seconds the semaphore:
  615. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  616. a writer (thread id 4084) has reserved it in mode exclusive
  617. number of readers 0, waiters flag 1, lock_word: 0
  618. Last time read locked in file ibuf0ibuf.cc line 4578
  619. Last time write locked in file mtr0mtr.ic line 147
  620. 2018-09-25 1:41:57 5560 [Note] InnoDB: A semaphore wait:
  621. --Thread 1436 has waited at buf0flu.cc line 1246 for 240.00 seconds the semaphore:
  622. SX-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  623. a writer (thread id 4084) has reserved it in mode exclusive
  624. number of readers 0, waiters flag 1, lock_word: 0
  625. Last time read locked in file ibuf0ibuf.cc line 4578
  626. Last time write locked in file mtr0mtr.ic line 147
  627. 2018-09-25 1:41:57 5560 [Note] InnoDB: A semaphore wait:
  628. --Thread 5596 has waited at ibuf0ibuf.cc line 4578 for 229.00 seconds the semaphore:
  629. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  630. a writer (thread id 4084) has reserved it in mode exclusive
  631. number of readers 0, waiters flag 1, lock_word: 0
  632. Last time read locked in file ibuf0ibuf.cc line 4578
  633. Last time write locked in file mtr0mtr.ic line 147
  634. 2018-09-25 1:41:57 5560 [Note] InnoDB: A semaphore wait:
  635. --Thread 5384 has waited at buf0buf.cc line 4133 for 72.00 seconds the semaphore:
  636. S-lock on RW-latch at 000002147A42A208 created in file buf0buf.cc line 1468
  637. a writer (thread id 0) has reserved it in mode exclusive
  638. number of readers 0, waiters flag 1, lock_word: 0
  639. Last time read locked in file not yet reserved line 0
  640. Last time write locked in file buf0buf.cc line 5337
  641. 2018-09-25 1:41:57 5560 [Note] InnoDB: A semaphore wait:
  642. --Thread 5616 has waited at ibuf0ibuf.cc line 3460 for 35.00 seconds the semaphore:
  643. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  644. a writer (thread id 4084) has reserved it in mode exclusive
  645. number of readers 0, waiters flag 1, lock_word: 0
  646. Last time read locked in file ibuf0ibuf.cc line 4578
  647. Last time write locked in file mtr0mtr.ic line 147
  648. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  649. InnoDB: Pending reads 0, writes 0
  650.  
  651. =====================================
  652. 2018-09-25 01:42:15 0x15bc INNODB MONITOR OUTPUT
  653. =====================================
  654. Per second averages calculated from the last 77 seconds
  655. -----------------
  656. BACKGROUND THREAD
  657. -----------------
  658. srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 0 srv_idle
  659. srv_master_thread log flush and writes: 0
  660. ----------
  661. SEMAPHORES
  662. ----------
  663. OS WAIT ARRAY INFO: reservation count 580
  664. --Thread 4092 has waited at ibuf0ibuf.cc line 4394 for 259.00 seconds the semaphore:
  665. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  666.  
  667. --Thread 4084 has waited at buf0buf.cc line 4133 for 259.00 seconds the semaphore:
  668. S-lock on RW-latch at 000002147A225D18 created in file buf0buf.cc line 1468
  669. a writer (thread id 0) has reserved it in mode exclusive
  670. number of readers 0, waiters flag 1, lock_word: 0
  671. Last time read locked in file not yet reserved line 0
  672. Last time write locked in file buf0buf.cc line 5337
  673. --Thread 3504 has waited at ibuf0ibuf.cc line 4394 for 259.00 seconds the semaphore:
  674. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  675.  
  676. --Thread 5552 has waited at ibuf0ibuf.cc line 4578 for 259.00 seconds the semaphore:
  677. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  678. a writer (thread id 4084) has reserved it in mode exclusive
  679. number of readers 0, waiters flag 1, lock_word: 0
  680. Last time read locked in file ibuf0ibuf.cc line 4578
  681. Last time write locked in file mtr0mtr.ic line 147
  682. --Thread 5568 has waited at ibuf0ibuf.cc line 2532 for 259.00 seconds the semaphore:
  683. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  684. a writer (thread id 4084) has reserved it in mode exclusive
  685. number of readers 0, waiters flag 1, lock_word: 0
  686. Last time read locked in file ibuf0ibuf.cc line 4578
  687. Last time write locked in file mtr0mtr.ic line 147
  688. --Thread 4088 has waited at ibuf0ibuf.cc line 4578 for 259.00 seconds the semaphore:
  689. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  690. a writer (thread id 4084) has reserved it in mode exclusive
  691. number of readers 0, waiters flag 1, lock_word: 0
  692. Last time read locked in file ibuf0ibuf.cc line 4578
  693. Last time write locked in file mtr0mtr.ic line 147
  694. --Thread 1436 has waited at buf0flu.cc line 1246 for 258.00 seconds the semaphore:
  695. SX-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  696. a writer (thread id 4084) has reserved it in mode exclusive
  697. number of readers 0, waiters flag 1, lock_word: 0
  698. Last time read locked in file ibuf0ibuf.cc line 4578
  699. Last time write locked in file mtr0mtr.ic line 147
  700. --Thread 5596 has waited at ibuf0ibuf.cc line 4578 for 247.00 seconds the semaphore:
  701. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  702. a writer (thread id 4084) has reserved it in mode exclusive
  703. number of readers 0, waiters flag 1, lock_word: 0
  704. Last time read locked in file ibuf0ibuf.cc line 4578
  705. Last time write locked in file mtr0mtr.ic line 147
  706. --Thread 5384 has waited at buf0buf.cc line 4133 for 90.00 seconds the semaphore:
  707. S-lock on RW-latch at 000002147A42A208 created in file buf0buf.cc line 1468
  708. a writer (thread id 0) has reserved it in mode exclusive
  709. number of readers 0, waiters flag 1, lock_word: 0
  710. Last time read locked in file not yet reserved line 0
  711. Last time write locked in file buf0buf.cc line 5337
  712. --Thread 5616 has waited at ibuf0ibuf.cc line 3460 for 53.00 seconds the semaphore:
  713. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  714. a writer (thread id 4084) has reserved it in mode exclusive
  715. number of readers 0, waiters flag 1, lock_word: 0
  716. Last time read locked in file ibuf0ibuf.cc line 4578
  717. Last time write locked in file mtr0mtr.ic line 147
  718. OS WAIT ARRAY INFO: signal count 517
  719. RW-shared spins 0, rounds 623, OS waits 309
  720. RW-excl spins 0, rounds 506, OS waits 8
  721. RW-sx spins 9, rounds 28, OS waits 0
  722. Spin rounds per wait: 623.00 RW-shared, 506.00 RW-excl, 3.11 RW-sx
  723. ------------
  724. TRANSACTIONS
  725. ------------
  726. Trx id counter 21424392455
  727. Purge done for trx's n:o < 21424392452 undo n:o < 0 state: running but idle
  728. History list length 1
  729. LIST OF TRANSACTIONS FOR EACH SESSION:
  730. ---TRANSACTION 283750179314280, not started
  731. 0 lock struct(s), heap size 1136, 0 row lock(s)
  732. ---TRANSACTION 21424392454, ACTIVE 53 sec updating or deleting
  733. mysql tables in use 1, locked 1
  734. 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1
  735. MySQL thread id 916, OS thread handle 5616, query id 741 localhost 127.0.0.1 sYfLeEtShInYaNg updating
  736. UPDATE vehicle SET ipAddress = '::ffff:183.171.95.13' WHERE id = 1918
  737. ---TRANSACTION 21424341714, ACTIVE 280 sec recovered trx
  738. ROLLING BACK 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1011046
  739. --------
  740. FILE I/O
  741. --------
  742. I/O thread 0 state: complete io for buf page (insert buffer thread)
  743. I/O thread 1 state: complete io for buf page (log thread)
  744. I/O thread 2 state: complete io for buf page (read thread)
  745. I/O thread 3 state: complete io for buf page (read thread)
  746. I/O thread 4 state: native aio handle (read thread)
  747. I/O thread 5 state: native aio handle (read thread)
  748. I/O thread 6 state: native aio handle (write thread)
  749. I/O thread 7 state: native aio handle (write thread)
  750. I/O thread 8 state: native aio handle (write thread)
  751. I/O thread 9 state: native aio handle (write thread)
  752. Pending normal aio reads: [0, 1, 64, 0] , aio writes: [0, 0, 0, 0] ,
  753. ibuf aio reads:, log i/o's:, sync i/o's:
  754. Pending flushes (fsync) log: 0; buffer pool: 0
  755. 55384 OS file reads, 2 OS file writes, 2 OS fsyncs
  756. 4.12 reads/s, 16384 avg bytes/read, 0.01 writes/s, 0.01 fsyncs/s
  757. -------------------------------------
  758. INSERT BUFFER AND ADAPTIVE HASH INDEX
  759. -------------------------------------
  760. InnoDB: ###### Diagnostic info printed to the standard error stream
  761. 2018-09-25 1:42:28 5560 [Warning] InnoDB: A long semaphore wait:
  762. --Thread 4092 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore:
  763. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  764.  
  765. 2018-09-25 1:42:28 5560 [Warning] InnoDB: A long semaphore wait:
  766. --Thread 4084 has waited at buf0buf.cc line 4133 for 272.00 seconds the semaphore:
  767. S-lock on RW-latch at 000002147A225D18 created in file buf0buf.cc line 1468
  768. a writer (thread id 0) has reserved it in mode exclusive
  769. number of readers 0, waiters flag 1, lock_word: 0
  770. Last time read locked in file not yet reserved line 0
  771. Last time write locked in file buf0buf.cc line 5337
  772. 2018-09-25 1:42:28 5560 [Warning] InnoDB: A long semaphore wait:
  773. --Thread 3504 has waited at ibuf0ibuf.cc line 4394 for 272.00 seconds the semaphore:
  774. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  775.  
  776. 2018-09-25 1:42:28 5560 [Warning] InnoDB: A long semaphore wait:
  777. --Thread 5552 has waited at ibuf0ibuf.cc line 4578 for 272.00 seconds the semaphore:
  778. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  779. a writer (thread id 4084) has reserved it in mode exclusive
  780. number of readers 0, waiters flag 1, lock_word: 0
  781. Last time read locked in file ibuf0ibuf.cc line 4578
  782. Last time write locked in file mtr0mtr.ic line 147
  783. 2018-09-25 1:42:28 5560 [Warning] InnoDB: A long semaphore wait:
  784. --Thread 5568 has waited at ibuf0ibuf.cc line 2532 for 272.00 seconds the semaphore:
  785. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  786. a writer (thread id 4084) has reserved it in mode exclusive
  787. number of readers 0, waiters flag 1, lock_word: 0
  788. Last time read locked in file ibuf0ibuf.cc line 4578
  789. Last time write locked in file mtr0mtr.ic line 147
  790. 2018-09-25 1:42:28 5560 [Warning] InnoDB: A long semaphore wait:
  791. --Thread 4088 has waited at ibuf0ibuf.cc line 4578 for 272.00 seconds the semaphore:
  792. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  793. a writer (thread id 4084) has reserved it in mode exclusive
  794. number of readers 0, waiters flag 1, lock_word: 0
  795. Last time read locked in file ibuf0ibuf.cc line 4578
  796. Last time write locked in file mtr0mtr.ic line 147
  797. 2018-09-25 1:42:28 5560 [Warning] InnoDB: A long semaphore wait:
  798. --Thread 1436 has waited at buf0flu.cc line 1246 for 271.00 seconds the semaphore:
  799. SX-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  800. a writer (thread id 4084) has reserved it in mode exclusive
  801. number of readers 0, waiters flag 1, lock_word: 0
  802. Last time read locked in file ibuf0ibuf.cc line 4578
  803. Last time write locked in file mtr0mtr.ic line 147
  804. 2018-09-25 1:42:28 5560 [Warning] InnoDB: A long semaphore wait:
  805. --Thread 5596 has waited at ibuf0ibuf.cc line 4578 for 260.00 seconds the semaphore:
  806. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  807. a writer (thread id 4084) has reserved it in mode exclusive
  808. number of readers 0, waiters flag 1, lock_word: 0
  809. Last time read locked in file ibuf0ibuf.cc line 4578
  810. Last time write locked in file mtr0mtr.ic line 147
  811. 2018-09-25 1:42:28 5560 [Note] InnoDB: A semaphore wait:
  812. --Thread 4092 has waited at ibuf0ibuf.cc line 4394 for 273.00 seconds the semaphore:
  813. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  814.  
  815. 2018-09-25 1:42:29 5560 [Note] InnoDB: A semaphore wait:
  816. --Thread 4084 has waited at buf0buf.cc line 4133 for 273.00 seconds the semaphore:
  817. S-lock on RW-latch at 000002147A225D18 created in file buf0buf.cc line 1468
  818. a writer (thread id 0) has reserved it in mode exclusive
  819. number of readers 0, waiters flag 1, lock_word: 0
  820. Last time read locked in file not yet reserved line 0
  821. Last time write locked in file buf0buf.cc line 5337
  822. 2018-09-25 1:42:29 5560 [Note] InnoDB: A semaphore wait:
  823. --Thread 3504 has waited at ibuf0ibuf.cc line 4394 for 273.00 seconds the semaphore:
  824. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  825.  
  826. 2018-09-25 1:42:29 5560 [Note] InnoDB: A semaphore wait:
  827. --Thread 5552 has waited at ibuf0ibuf.cc line 4578 for 273.00 seconds the semaphore:
  828. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  829. a writer (thread id 4084) has reserved it in mode exclusive
  830. number of readers 0, waiters flag 1, lock_word: 0
  831. Last time read locked in file ibuf0ibuf.cc line 4578
  832. Last time write locked in file mtr0mtr.ic line 147
  833. 2018-09-25 1:42:29 5560 [Note] InnoDB: A semaphore wait:
  834. --Thread 5568 has waited at ibuf0ibuf.cc line 2532 for 273.00 seconds the semaphore:
  835. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  836. a writer (thread id 4084) has reserved it in mode exclusive
  837. number of readers 0, waiters flag 1, lock_word: 0
  838. Last time read locked in file ibuf0ibuf.cc line 4578
  839. Last time write locked in file mtr0mtr.ic line 147
  840. 2018-09-25 1:42:29 5560 [Note] InnoDB: A semaphore wait:
  841. --Thread 4088 has waited at ibuf0ibuf.cc line 4578 for 273.00 seconds the semaphore:
  842. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  843. a writer (thread id 4084) has reserved it in mode exclusive
  844. number of readers 0, waiters flag 1, lock_word: 0
  845. Last time read locked in file ibuf0ibuf.cc line 4578
  846. Last time write locked in file mtr0mtr.ic line 147
  847. 2018-09-25 1:42:29 5560 [Note] InnoDB: A semaphore wait:
  848. --Thread 1436 has waited at buf0flu.cc line 1246 for 272.00 seconds the semaphore:
  849. SX-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  850. a writer (thread id 4084) has reserved it in mode exclusive
  851. number of readers 0, waiters flag 1, lock_word: 0
  852. Last time read locked in file ibuf0ibuf.cc line 4578
  853. Last time write locked in file mtr0mtr.ic line 147
  854. 2018-09-25 1:42:29 5560 [Note] InnoDB: A semaphore wait:
  855. --Thread 5596 has waited at ibuf0ibuf.cc line 4578 for 261.00 seconds the semaphore:
  856. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  857. a writer (thread id 4084) has reserved it in mode exclusive
  858. number of readers 0, waiters flag 1, lock_word: 0
  859. Last time read locked in file ibuf0ibuf.cc line 4578
  860. Last time write locked in file mtr0mtr.ic line 147
  861. 2018-09-25 1:42:29 5560 [Note] InnoDB: A semaphore wait:
  862. --Thread 5384 has waited at buf0buf.cc line 4133 for 104.00 seconds the semaphore:
  863. S-lock on RW-latch at 000002147A42A208 created in file buf0buf.cc line 1468
  864. a writer (thread id 0) has reserved it in mode exclusive
  865. number of readers 0, waiters flag 1, lock_word: 0
  866. Last time read locked in file not yet reserved line 0
  867. Last time write locked in file buf0buf.cc line 5337
  868. 2018-09-25 1:42:29 5560 [Note] InnoDB: A semaphore wait:
  869. --Thread 5616 has waited at ibuf0ibuf.cc line 3460 for 67.00 seconds the semaphore:
  870. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  871. a writer (thread id 4084) has reserved it in mode exclusive
  872. number of readers 0, waiters flag 1, lock_word: 0
  873. Last time read locked in file ibuf0ibuf.cc line 4578
  874. Last time write locked in file mtr0mtr.ic line 147
  875. 2018-09-25 1:42:29 5560 [Note] InnoDB: A semaphore wait:
  876. --Thread 5564 has waited at ibuf0ibuf.cc line 4921 for 14.00 seconds the semaphore:
  877. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  878.  
  879. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  880. InnoDB: Pending reads 0, writes 0
  881. InnoDB: ###### Diagnostic info printed to the standard error stream
  882. 2018-09-25 1:43:00 5560 [Warning] InnoDB: A long semaphore wait:
  883. --Thread 4092 has waited at ibuf0ibuf.cc line 4394 for 304.00 seconds the semaphore:
  884. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  885.  
  886. 2018-09-25 1:43:00 5560 [Warning] InnoDB: A long semaphore wait:
  887. --Thread 4084 has waited at buf0buf.cc line 4133 for 304.00 seconds the semaphore:
  888. S-lock on RW-latch at 000002147A225D18 created in file buf0buf.cc line 1468
  889. a writer (thread id 0) has reserved it in mode exclusive
  890. number of readers 0, waiters flag 1, lock_word: 0
  891. Last time read locked in file not yet reserved line 0
  892. Last time write locked in file buf0buf.cc line 5337
  893. 2018-09-25 1:43:00 5560 [Warning] InnoDB: A long semaphore wait:
  894. --Thread 3504 has waited at ibuf0ibuf.cc line 4394 for 304.00 seconds the semaphore:
  895. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  896.  
  897. 2018-09-25 1:43:00 5560 [Warning] InnoDB: A long semaphore wait:
  898. --Thread 5552 has waited at ibuf0ibuf.cc line 4578 for 304.00 seconds the semaphore:
  899. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  900. a writer (thread id 4084) has reserved it in mode exclusive
  901. number of readers 0, waiters flag 1, lock_word: 0
  902. Last time read locked in file ibuf0ibuf.cc line 4578
  903. Last time write locked in file mtr0mtr.ic line 147
  904. 2018-09-25 1:43:00 5560 [Warning] InnoDB: A long semaphore wait:
  905. --Thread 5568 has waited at ibuf0ibuf.cc line 2532 for 304.00 seconds the semaphore:
  906. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  907. a writer (thread id 4084) has reserved it in mode exclusive
  908. number of readers 0, waiters flag 1, lock_word: 0
  909. Last time read locked in file ibuf0ibuf.cc line 4578
  910. Last time write locked in file mtr0mtr.ic line 147
  911. 2018-09-25 1:43:00 5560 [Warning] InnoDB: A long semaphore wait:
  912. --Thread 4088 has waited at ibuf0ibuf.cc line 4578 for 304.00 seconds the semaphore:
  913. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  914. a writer (thread id 4084) has reserved it in mode exclusive
  915. number of readers 0, waiters flag 1, lock_word: 0
  916. Last time read locked in file ibuf0ibuf.cc line 4578
  917. Last time write locked in file mtr0mtr.ic line 147
  918. 2018-09-25 1:43:00 5560 [Warning] InnoDB: A long semaphore wait:
  919. --Thread 1436 has waited at buf0flu.cc line 1246 for 303.00 seconds the semaphore:
  920. SX-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  921. a writer (thread id 4084) has reserved it in mode exclusive
  922. number of readers 0, waiters flag 1, lock_word: 0
  923. Last time read locked in file ibuf0ibuf.cc line 4578
  924. Last time write locked in file mtr0mtr.ic line 147
  925. 2018-09-25 1:43:00 5560 [Warning] InnoDB: A long semaphore wait:
  926. --Thread 5596 has waited at ibuf0ibuf.cc line 4578 for 292.00 seconds the semaphore:
  927. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  928. a writer (thread id 4084) has reserved it in mode exclusive
  929. number of readers 0, waiters flag 1, lock_word: 0
  930. Last time read locked in file ibuf0ibuf.cc line 4578
  931. Last time write locked in file mtr0mtr.ic line 147
  932. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  933. --Thread 4092 has waited at ibuf0ibuf.cc line 4394 for 304.00 seconds the semaphore:
  934. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  935.  
  936. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  937. --Thread 4084 has waited at buf0buf.cc line 4133 for 304.00 seconds the semaphore:
  938. S-lock on RW-latch at 000002147A225D18 created in file buf0buf.cc line 1468
  939. a writer (thread id 0) has reserved it in mode exclusive
  940. number of readers 0, waiters flag 1, lock_word: 0
  941. Last time read locked in file not yet reserved line 0
  942. Last time write locked in file buf0buf.cc line 5337
  943. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  944. --Thread 3504 has waited at ibuf0ibuf.cc line 4394 for 304.00 seconds the semaphore:
  945. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  946.  
  947. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  948. --Thread 5552 has waited at ibuf0ibuf.cc line 4578 for 304.00 seconds the semaphore:
  949. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  950. a writer (thread id 4084) has reserved it in mode exclusive
  951. number of readers 0, waiters flag 1, lock_word: 0
  952. Last time read locked in file ibuf0ibuf.cc line 4578
  953. Last time write locked in file mtr0mtr.ic line 147
  954. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  955. --Thread 5568 has waited at ibuf0ibuf.cc line 2532 for 304.00 seconds the semaphore:
  956. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  957. a writer (thread id 4084) has reserved it in mode exclusive
  958. number of readers 0, waiters flag 1, lock_word: 0
  959. Last time read locked in file ibuf0ibuf.cc line 4578
  960. Last time write locked in file mtr0mtr.ic line 147
  961. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  962. --Thread 4088 has waited at ibuf0ibuf.cc line 4578 for 304.00 seconds the semaphore:
  963. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  964. a writer (thread id 4084) has reserved it in mode exclusive
  965. number of readers 0, waiters flag 1, lock_word: 0
  966. Last time read locked in file ibuf0ibuf.cc line 4578
  967. Last time write locked in file mtr0mtr.ic line 147
  968. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  969. --Thread 1436 has waited at buf0flu.cc line 1246 for 303.00 seconds the semaphore:
  970. SX-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  971. a writer (thread id 4084) has reserved it in mode exclusive
  972. number of readers 0, waiters flag 1, lock_word: 0
  973. Last time read locked in file ibuf0ibuf.cc line 4578
  974. Last time write locked in file mtr0mtr.ic line 147
  975. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  976. --Thread 5596 has waited at ibuf0ibuf.cc line 4578 for 292.00 seconds the semaphore:
  977. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  978. a writer (thread id 4084) has reserved it in mode exclusive
  979. number of readers 0, waiters flag 1, lock_word: 0
  980. Last time read locked in file ibuf0ibuf.cc line 4578
  981. Last time write locked in file mtr0mtr.ic line 147
  982. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  983. --Thread 5384 has waited at buf0buf.cc line 4133 for 135.00 seconds the semaphore:
  984. S-lock on RW-latch at 000002147A42A208 created in file buf0buf.cc line 1468
  985. a writer (thread id 0) has reserved it in mode exclusive
  986. number of readers 0, waiters flag 1, lock_word: 0
  987. Last time read locked in file not yet reserved line 0
  988. Last time write locked in file buf0buf.cc line 5337
  989. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  990. --Thread 5616 has waited at ibuf0ibuf.cc line 3460 for 98.00 seconds the semaphore:
  991. S-lock on RW-latch at 00000211BCEDA398 created in file buf0buf.cc line 1468
  992. a writer (thread id 4084) has reserved it in mode exclusive
  993. number of readers 0, waiters flag 1, lock_word: 0
  994. Last time read locked in file ibuf0ibuf.cc line 4578
  995. Last time write locked in file mtr0mtr.ic line 147
  996. 2018-09-25 1:43:00 5560 [Note] InnoDB: A semaphore wait:
  997. --Thread 5564 has waited at ibuf0ibuf.cc line 4921 for 45.00 seconds the semaphore:
  998. Mutex at 00007FF791656468, Mutex IBUF created ibuf0ibuf.cc:516, lock var 2
  999.  
  1000. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  1001. InnoDB: Pending reads 0, writes 0
  1002. InnoDB: ###### Diagnostic info printed to the standard error stream
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!