API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 2nd, 2019
637
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.94 KB | None | 0 0
raw download clone embed print report
  1. InnoDB: Warning: a long semaphore wait:
  2. --Thread 47206812096256 has waited at row0ins.cc line 2338 for 1148.00 seconds the semaphore:
  3. X-lock (wait_ex) on RW-latch at 0x2aef07155340 created in file buf0buf.cc line 1069
  4. a writer (thread id 47206812096256) has reserved it in mode exclusive
  5. number of readers 0, waiters flag 1, lock_word: 0
  6. Last time read locked in file buf0flu.cc line 1056
  7. Last time write locked in file /local/p4clients/pkgbuild-w9GTi/workspace/src/RDSMySQL/storage/innobase/btr/btr0sea.cc line 931
  8. InnoDB: Warning: a long semaphore wait:
  9. --Thread 47206835459840 has waited at row0ins.cc line 2338 for 1123.00 seconds the semaphore:
  10. X-lock on RW-latch at 0x2aef07155340 created in file buf0buf.cc line 1069
  11. a writer (thread id 47206812096256) has reserved it in mode exclusive
  12. number of readers 0, waiters flag 1, lock_word: 0
  13. Last time read locked in file buf0flu.cc line 1056
  14. Last time write locked in file /local/p4clients/pkgbuild-w9GTi/workspace/src/RDSMySQL/storage/innobase/btr/btr0sea.cc line 931
  15. InnoDB: Warning: a long semaphore wait:
  16. --Thread 47206826522368 has waited at log0log.cc line 1685 for 1104.00 seconds the semaphore:
  17. Mutex at 0x2aef0493c3b8 created file log0log.cc line 844, lock var 0
  18. waiters flag 0
  19. InnoDB: Warning: a long semaphore wait:
  20. --Thread 47206791427840 has waited at row0ins.cc line 2338 for 1093.00 seconds the semaphore:
  21. X-lock on RW-latch at 0x2aef07155340 created in file buf0buf.cc line 1069
  22. a writer (thread id 47206812096256) has reserved it in mode exclusive
  23. number of readers 0, waiters flag 1, lock_word: 0
  24. Last time read locked in file buf0flu.cc line 1056
  25. Last time write locked in file /local/p4clients/pkgbuild-w9GTi/workspace/src/RDSMySQL/storage/innobase/btr/btr0sea.cc line 931
  26. InnoDB: Warning: a long semaphore wait:
  27. --Thread 47206086784768 has waited at row0ins.cc line 2338 for 1090.00 seconds the semaphore:
  28. X-lock on RW-latch at 0x2aef07155340 created in file buf0buf.cc line 1069
  29. a writer (thread id 47206812096256) has reserved it in mode exclusive
  30. number of readers 0, waiters flag 1, lock_word: 0
  31. Last time read locked in file buf0flu.cc line 1056
  32. Last time write locked in file /local/p4clients/pkgbuild-w9GTi/workspace/src/RDSMySQL/storage/innobase/btr/btr0sea.cc line 931
  33. InnoDB: Warning: a long semaphore wait:
  34. --Thread 47206087051008 has waited at trx0sys.ic line 103 for 1025.00 seconds the semaphore:
  35. X-lock (wait_ex) on RW-latch at 0x2aef06400b40 created in file buf0buf.cc line 1069
  36. a writer (thread id 47206087051008) has reserved it in mode exclusive
  37. number of readers 0, waiters flag 0, lock_word: 0
  38. Last time read locked in file buf0flu.cc line 1056
  39. Last time write locked in file /local/p4clients/pkgbuild-w9GTi/workspace/src/RDSMySQL/storage/innobase/include/trx0sys.ic line 103
  40. InnoDB: Warning: a long semaphore wait:
  41. --Thread 47206812894976 has waited at trx0trx.cc line 193 for 1024.00 seconds the semaphore:
  42. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  43. waiters flag 1
  44. InnoDB: Warning: a long semaphore wait:
  45. --Thread 47206087317248 has waited at trx0trx.cc line 193 for 1017.00 seconds the semaphore:
  46. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  47. waiters flag 1
  48. InnoDB: Warning: a long semaphore wait:
  49. --Thread 47206835992320 has waited at trx0trx.cc line 193 for 1016.00 seconds the semaphore:
  50. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  51. waiters flag 1
  52. InnoDB: Warning: a long semaphore wait:
  53. --Thread 47206027118336 has waited at trx0trx.cc line 193 for 1011.00 seconds the semaphore:
  54. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  55. waiters flag 1
  56. InnoDB: Warning: a long semaphore wait:
  57. --Thread 47206087583488 has waited at trx0trx.cc line 193 for 1007.00 seconds the semaphore:
  58. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  59. waiters flag 1
  60. InnoDB: Warning: a long semaphore wait:
  61. --Thread 47206812362496 has waited at trx0trx.cc line 193 for 1004.00 seconds the semaphore:
  62. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  63. waiters flag 1
  64. InnoDB: Warning: a long semaphore wait:
  65. --Thread 47206813427456 has waited at trx0trx.cc line 193 for 1000.00 seconds the semaphore:
  66. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  67. waiters flag 1
  68. InnoDB: Warning: a long semaphore wait:
  69. --Thread 47206792226560 has waited at trx0trx.cc line 193 for 1000.00 seconds the semaphore:
  70. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  71. waiters flag 1
  72. InnoDB: Warning: a long semaphore wait:
  73. --Thread 47206791694080 has waited at trx0trx.cc line 1195 for 990.00 seconds the semaphore:
  74. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  75. waiters flag 1
  76. InnoDB: Warning: a long semaphore wait:
  77. --Thread 47206812628736 has waited at trx0trx.cc line 193 for 981.00 seconds the semaphore:
  78. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  79. waiters flag 1
  80. InnoDB: Warning: a long semaphore wait:
  81. --Thread 47206813161216 has waited at trx0trx.cc line 193 for 966.00 seconds the semaphore:
  82. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  83. waiters flag 1
  84. InnoDB: Warning: a long semaphore wait:
  85. --Thread 47206087849728 has waited at trx0trx.cc line 193 for 947.00 seconds the semaphore:
  86. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  87. waiters flag 1
  88. InnoDB: Warning: a long semaphore wait:
  89. --Thread 47206836258560 has waited at trx0trx.cc line 193 for 932.00 seconds the semaphore:
  90. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  91. waiters flag 1
  92. InnoDB: Warning: a long semaphore wait:
  93. --Thread 47206088115968 has waited at trx0trx.cc line 193 for 913.00 seconds the semaphore:
  94. Mutex at 0x2aef2d3f9068 created file trx0sys.cc line 597, lock var 1
  95. waiters flag 1
  96. InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
  97. InnoDB: Pending preads 0, pwrites 0
  98.  
  99. =====================================
  100. 2019-10-02 10:18:29 2aef32002700 INNODB MONITOR OUTPUT
  101. =====================================
  102. Per second averages calculated from the last 935 seconds
  103. -----------------
  104. BACKGROUND THREAD
  105. -----------------
  106. srv_master_thread loops: 50963 srv_active, 0 srv_shutdown, 119908 srv_idle
  107. srv_master_thread log flush and writes: 170869
  108. ----------
  109. SEMAPHORES
  110. ----------
  111. OS WAIT ARRAY INFO: reservation count 35078
  112. --Thread 47206826522368 has waited at srv0srv.cc line 2007 for 15.00 seconds the semaphore:
  113. X-lock on RW-latch at 0x154a120 created in file dict0dict.cc line 1067
  114. a writer (thread id 47206832826112) 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.cc line 770
  117. Last time write locked in file /local/p4clients/pkgbuild-w9GTi/workspace/src/RDSMySQL/storage/innobase/dict/dict0stats.cc line 2398
  118. OS WAIT ARRAY INFO: signal count 34482
  119. Mutex spin waits 2752, rounds 119536, OS waits 3579
  120. RW-shared spins 31461, rounds 944266, OS waits 30928
  121. RW-excl spins 126, rounds 15900, OS waits 459
  122. Spin rounds per wait: 43.44 mutex, 30.01 RW-shared, 126.19 RW-excl
  123. ------------
  124. TRANSACTIONS
  125. ------------
  126. Trx id counter 1444260891
  127. Purge done for trx's n:o < 1444260890 undo n:o < 0 state: running
  128. History list length 678
  129. LIST OF TRANSACTIONS FOR EACH SESSION:
  130. ---TRANSACTION 1444260877, not started
  131. MySQL thread id 109023, OS thread handle 0x2aef34673700, query id 2229053 10.0.0.6 root
  132. ---TRANSACTION 1444260878, not started
  133. MySQL thread id 109022, OS thread handle 0x2aef32bce700, query id 2229052 10.0.0.6 root
  134. ---TRANSACTION 1444260880, not started
  135. MySQL thread id 109021, OS thread handle 0x2aef32b8d700, query id 2229051 10.0.0.6 root
  136. ---TRANSACTION 1444260866, not started
  137. MySQL thread id 109019, OS thread handle 0x2aef0604a700, query id 2229049 10.0.0.6 root
  138. ---TRANSACTION 1444260874, not started
  139. MySQL thread id 109018, OS thread handle 0x2aef02722700, query id 2229048 10.0.0.6 root
  140. ---TRANSACTION 1444260886, not started
  141. MySQL thread id 109017, OS thread handle 0x2aef061d0700, query id 2229047 10.0.0.6 root
  142. ---TRANSACTION 1444260872, not started
  143. MySQL thread id 109016, OS thread handle 0x2aef32b4c700, query id 2229046 10.0.0.6 root
  144. ---TRANSACTION 1444260875, not started
  145. MySQL thread id 109015, OS thread handle 0x2aef0618f700, query id 2229045 10.0.0.6 root
  146. ---TRANSACTION 1444260873, not started
  147. MySQL thread id 109014, OS thread handle 0x2aef31545700, query id 2229044 10.0.0.6 root
  148. ---TRANSACTION 1444260885, not started
  149. MySQL thread id 109011, OS thread handle 0x2aef3014e700, query id 2229041 10.0.0.6 root
  150. ---TRANSACTION 1444260881, not started
  151. MySQL thread id 109010, OS thread handle 0x2aef31586700, query id 2229040 10.0.0.6 root
  152. ---TRANSACTION 0, not started
  153. MySQL thread id 109009, OS thread handle 0x2aef31482700, query id 2229039 10.0.0.7 root
  154. ---TRANSACTION 1444260884, not started
  155. MySQL thread id 109008, OS thread handle 0x2aef0614e700, query id 2229037 10.0.0.6 root
  156. ---TRANSACTION 0, not started
  157. MySQL thread id 109005, OS thread handle 0x2aef0610d700, query id 2229034 10.0.0.7 root
  158. ---TRANSACTION 0, not started
  159. MySQL thread id 109004, OS thread handle 0x2aef31504700, query id 2229032 10.0.0.7 root
  160. ---TRANSACTION 1444260864, not started
  161. MySQL thread id 109003, OS thread handle 0x2aef060cc700, query id 2229030 10.0.0.7 lwdforum
  162. ---TRANSACTION 1444260870, not started
  163. MySQL thread id 109002, OS thread handle 0x2aef32aca700, query id 2229002 10.0.0.7 root
  164. ---TRANSACTION 1444260857, not started
  165. MySQL thread id 109001, OS thread handle 0x2aef300cc700, query id 2228999 10.0.0.7 lwdforum
  166. ---TRANSACTION 1444260868, not started
  167. MySQL thread id 109000, OS thread handle 0x2aef3018f700, query id 2228982 10.0.0.7 root
  168. ---TRANSACTION 1444260871, not started
  169. MySQL thread id 108996, OS thread handle 0x2aef02763700, query id 2228907 10.0.0.7 root
  170. ---TRANSACTION 1444260869, not started
  171. MySQL thread id 108995, OS thread handle 0x2aef301d0700, query id 2228904 10.0.0.7 root
  172. ---TRANSACTION 1444260812, not started
  173. MySQL thread id 108992, OS thread handle 0x2aef0608b700, query id 2228832 10.0.0.6 root
  174. ---TRANSACTION 1444260811, not started
  175. MySQL thread id 108991, OS thread handle 0x2aef3008b700, query id 2228831 10.0.0.6 root
  176. ---TRANSACTION 1444260800, not started
  177. MySQL thread id 108989, OS thread handle 0x2aef32a48700, query id 2228793 10.0.0.7 lwdforum
  178. ---TRANSACTION 1444260867, not started
  179. MySQL thread id 108986, OS thread handle 0x2aef03fd8700, query id 2228661 10.0.0.7 root
  180. ---TRANSACTION 1444260766, not started
  181. MySQL thread id 108985, OS thread handle 0x2aef32a89700, query id 2228670 10.0.0.6 root
  182. ---TRANSACTION 1444260762, not started
  183. MySQL thread id 108956, OS thread handle 0x2aef31441700, query id 2228656 10.0.0.6 root
  184. ---TRANSACTION 1444260832, not started
  185. MySQL thread id 1, OS thread handle 0x2aef026e1700, query id 2229055 localhost 127.0.0.1 rdsadmin executing
  186. SHOW GLOBAL VARIABLES LIKE 'mysql_cipher_stats_flush_period_in_seconds'
  187. ---TRANSACTION 1444260889, ACTIVE 19 sec
  188. 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1
  189. ---TRANSACTION 1444260883, ACTIVE 25 sec starting index read
  190. mysql tables in use 1, locked 1
  191. 2 lock struct(s), heap size 360, 1 row lock(s)
  192. MySQL thread id 109006, OS thread handle 0x2aef32b0b700, query id 2229035 10.0.0.6 root updating
  193. update `store_counts` set `user_count` = 156
  194. ---TRANSACTION 1444260882, ACTIVE 25 sec starting index read
  195. mysql tables in use 1, locked 1
  196. LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
  197. MySQL thread id 109020, OS thread handle 0x2aef315c7700, query id 2229050 10.0.0.6 root updating
  198. update `store_counts` set `user_count` = 153
  199. ------- TRX HAS BEEN WAITING 25 SEC FOR THIS LOCK TO BE GRANTED:
  200. RECORD LOCKS space id 533 page no 3 n bits 72 index `PRIMARY` of table `rph_chat`.`store_counts` trx id 1444260882 lock_mode X waiting
  201. Record lock, heap no 2 PHYSICAL RECORD: n_fields 10; compact format; info bits 0
  202. 0: len 4; hex 80000001; asc ;;
  203. 1: len 6; hex 00005615ac09; asc V ;;
  204. 2: len 7; hex 310000801c1d19; asc 1 ;;
  205. 3: len 3; hex 00224b; asc "K;;
  206. 4: len 4; hex 8000009b; asc ;;
  207. 5: len 3; hex 80007c; asc |;;
  208. 6: len 4; hex 80000000; asc ;;
  209. 7: len 4; hex 80000663; asc c;;
  210. 8: len 3; hex 800000; asc ;;
  211. 9: len 3; hex 800000; asc ;;
  212.  
  213. ------------------
  214. ---TRANSACTION 1444260879, ACTIVE 27 sec starting index read
  215. mysql tables in use 1, locked 1
  216. LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
  217. MySQL thread id 109007, OS thread handle 0x2aef027a4700, query id 2229036 10.0.0.6 root updating
  218. update `store_counts` set `user_count` = 155
  219. ------- TRX HAS BEEN WAITING 28 SEC FOR THIS LOCK TO BE GRANTED:
  220. RECORD LOCKS space id 533 page no 3 n bits 72 index `PRIMARY` of table `rph_chat`.`store_counts` trx id 1444260879 lock_mode X waiting
  221. Record lock, heap no 2 PHYSICAL RECORD: n_fields 10; compact format; info bits 0
  222. 0: len 4; hex 80000001; asc ;;
  223. 1: len 6; hex 00005615ac09; asc V ;;
  224. 2: len 7; hex 310000801c1d19; asc 1 ;;
  225. 3: len 3; hex 00224b; asc "K;;
  226. 4: len 4; hex 8000009b; asc ;;
  227. 5: len 3; hex 80007c; asc |;;
  228. 6: len 4; hex 80000000; asc ;;
  229. 7: len 4; hex 80000663; asc c;;
  230. 8: len 3; hex 800000; asc ;;
  231. 9: len 3; hex 800000; asc ;;
  232.  
  233. ------------------
  234. ---TRANSACTION 1444260876, ACTIVE 29 sec starting index read
  235. mysql tables in use 1, locked 1
  236. LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
  237. MySQL thread id 109013, OS thread handle 0x2aef314c3700, query id 2229043 10.0.0.6 root updating
  238. update `store_counts` set `user_count` = 154
  239. ------- TRX HAS BEEN WAITING 29 SEC FOR THIS LOCK TO BE GRANTED:
  240. RECORD LOCKS space id 533 page no 3 n bits 72 index `PRIMARY` of table `rph_chat`.`store_counts` trx id 1444260876 lock_mode X waiting
  241. Record lock, heap no 2 PHYSICAL RECORD: n_fields 10; compact format; info bits 0
  242. 0: len 4; hex 80000001; asc ;;
  243. 1: len 6; hex 00005615ac09; asc V ;;
  244. 2: len 7; hex 310000801c1d19; asc 1 ;;
  245. 3: len 3; hex 00224b; asc "K;;
  246. 4: len 4; hex 8000009b; asc ;;
  247. 5: len 3; hex 80007c; asc |;;
  248. 6: len 4; hex 80000000; asc ;;
  249. 7: len 4; hex 80000663; asc c;;
  250. 8: len 3; hex 800000; asc ;;
  251. 9: len 3; hex 800000; asc ;;
  252.  
  253. ------------------
  254. --------
  255. FILE I/O
  256. --------
  257. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  258. I/O thread 1 state: waiting for completed aio requests (log thread)
  259. I/O thread 2 state: waiting for completed aio requests (read thread)
  260. I/O thread 3 state: waiting for completed aio requests (read thread)
  261. I/O thread 4 state: waiting for completed aio requests (read thread)
  262. I/O thread 5 state: waiting for completed aio requests (read thread)
  263. I/O thread 6 state: waiting for completed aio requests (write thread)
  264. I/O thread 7 state: waiting for completed aio requests (write thread)
  265. I/O thread 8 state: waiting for completed aio requests (write thread)
  266. I/O thread 9 state: waiting for completed aio requests (write thread)
  267. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  268. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  269. Pending flushes (fsync) log: 0; buffer pool: 0
  270. 43029 OS file reads, 346850 OS file writes, 199033 OS fsyncs
  271. 0.00 reads/s, 16384 avg bytes/read, 0.08 writes/s, 0.03 fsyncs/s
  272. -------------------------------------
  273. INSERT BUFFER AND ADAPTIVE HASH INDEX
  274. -------------------------------------
  275. Ibuf: size 1, free list len 9348, seg size 9350, 406 merges
  276. merged operations:
  277. insert 323, delete mark 111, delete 28
  278. discarded operations:
  279. insert 0, delete mark 0, delete 0
  280. Hash table size 1236953, node heap has 1004 buffer(s)
  281. 0.03 hash searches/s, 0.05 non-hash searches/s
  282. ---
  283. LOG
  284. ---
  285. InnoDB: ###### Diagnostic info printed to the standard error stream
  286. Log sequence number 109458067830
  287. Log flushed up to 109458067830
  288. Pages flushed up to 109458067830
  289. Last checkpoint at 109458056129
  290. 0 pending log writes, 0 pending chkp writes
  291. 108408 log i/o's done, 0.01 log i/o's/second
  292. ----------------------
  293. BUFFER POOL AND MEMORY
  294. ----------------------
  295. Total memory allocated 639598592; in additional pool allocated 0
  296. Dictionary memory allocated 932100
  297. Buffer pool size 38144
  298. Free buffers 1024
  299. Database pages 36116
  300. Old database pages 13311
  301. Modified db pages 0
  302. Pending reads 0
  303. Pending writes: LRU 0, flush list 0, single page 0
  304. Pages made young 15700590, not young 433604
  305. 0.01 youngs/s, 0.00 non-youngs/s
  306. Pages read 42580, created 763, written 212492
  307. 0.00 reads/s, 0.00 creates/s, 0.07 writes/s
  308. Buffer pool hit rate 994 / 1000, young-making rate 45 / 1000 not 6 / 1000
  309. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  310. LRU len: 36116, unzip_LRU len: 0
  311. I/O sum[0]:cur[49], unzip sum[0]:cur[0]
  312. --------------
  313. ROW OPERATIONS
  314. --------------
  315. 0 queries inside InnoDB, 0 queries in queue
  316. 0 read views open inside InnoDB
  317. Main thread process no. 4070, id 47206826522368, state: enforcing dict cache limit
  318. Number of rows inserted 26674, updated 16658, deleted 686, read 698279025
  319. 0.01 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.02 reads/s
  320. ----------------------------
  321. END OF INNODB MONITOR OUTPUT
  322. ============================
  323. 2019-10-02 10:19:12 4070 [Note] /rdsdbbin/mysql/bin/mysqld: Normal shutdown
  324.  
  325. 2019-10-02 10:19:12 4070 [Note] Giving 35 client threads a chance to die gracefully
  326. 2019-10-02 10:19:12 4070 [Note] Event Scheduler: Purging the queue. 0 events
  327. 2019-10-02 10:19:12 4070 [Note] Shutting down slave threads
  328. 2019-10-02 10:20:33 4307 [Note] Plugin 'FEDERATED' is disabled.
  329. 2019-10-02 10:20:33 4307 [Note] InnoDB: Using atomics to ref count buffer pool pages
  330. 2019-10-02 10:20:33 4307 [Note] InnoDB: The InnoDB memory heap is disabled
  331. 2019-10-02 10:20:33 4307 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  332. 2019-10-02 10:20:33 4307 [Note] InnoDB: Memory barrier is not used
  333. 2019-10-02 10:20:33 4307 [Note] InnoDB: Compressed tables use zlib 1.2.11
  334. 2019-10-02 10:20:33 4307 [Note] InnoDB: Using Linux native AIO
  335. 2019-10-02 10:20:33 4307 [Note] InnoDB: Using CPU crc32 instructions
  336. 2019-10-02 10:20:33 4307 [Note] InnoDB: Initializing buffer pool, size = 596.0M
  337. 2019-10-02 10:20:33 4307 [Note] InnoDB: Completed initialization of buffer pool
  338. 2019-10-02 10:20:33 4307 [Note] InnoDB: Highest supported file format is Barracuda.
  339. 2019-10-02 10:20:33 4307 [Note] InnoDB: The log sequence numbers 109321469782 and 109321469782 in ibdata files do not match the log sequence number 109458081566 in the ib_logfiles!
  340. 2019-10-02 10:20:33 4307 [Note] InnoDB: Database was not shutdown normally!
  341. 2019-10-02 10:20:33 4307 [Note] InnoDB: Starting crash recovery.
  342. 2019-10-02 10:20:33 4307 [Note] InnoDB: Reading tablespace information from the .ibd files...
  343. 2019-10-02 10:20:33 4307 [Note] InnoDB: Restoring possible half-written data pages
  344. 2019-10-02 10:20:33 4307 [Note] InnoDB: from the doublewrite buffer...
  345. InnoDB: Last MySQL binlog file position 0 412, file name mysql-bin-changelog.445091
  346. 2019-10-02 10:20:34 4307 [Note] InnoDB: 128 rollback segment(s) are active.
  347. 2019-10-02 10:20:34 4307 [Note] InnoDB: Waiting for purge to start
  348. 2019-10-02 10:20:34 4307 [Note] InnoDB: 5.6.41 started; log sequence number 109458081566
  349. 2019-10-02 10:20:34 4307 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog
  350. 2019-10-02 10:20:34 4307 [Note] Starting crash recovery...
  351. 2019-10-02 10:20:34 4307 [Note] Crash recovery finished.
  352. 2019-10-02 10:20:34 4307 [Note] RSA private key file not found: /rdsdbdata/db//private_key.pem. Some authentication plugins will not work.
  353. 2019-10-02 10:20:34 4307 [Note] RSA public key file not found: /rdsdbdata/db//public_key.pem. Some authentication plugins will not work.
  354. 2019-10-02 10:20:34 4307 [Note] Server hostname (bind-address): '*'; port: 3306
  355. 2019-10-02 10:20:34 4307 [Note] IPv6 is available.
  356. 2019-10-02 10:20:34 4307 [Note] - '::' resolves to '::';
  357. 2019-10-02 10:20:34 4307 [Note] Server socket created on IP: '::'.
  358. 2019-10-02 10:20:34 4307 [Note] Event Scheduler: Loaded 0 events
  359. 2019-10-02 10:20:34 4307 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections.
  360. Version: '5.6.41-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
  361. 2019-10-02 10:20:35 4307 [Warning] IP address '10.0.0.13' could not be resolved: Name or service not known
  362. ----------------------- END OF LOG ----------------------
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!