InnoDB: Warning: a long semaphore wait: --Thread 139861880297216 has waited at btr0cur.cc line 545 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7f3418009d18 created in file dict0dict.cc line 2652 a writer (thread id 139861977528064) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.cc line 545 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/btr/btr0cur.cc line 536 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 2017-06-03 07:28:36 7f3428bd1700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 35 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 149894 srv_active, 0 srv_shutdown, 105 srv_idle srv_master_thread log flush and writes: 149999 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 168404 --Thread 139861880297216 has waited at btr0cur.cc line 545 for 253.00 seconds the semaphore: S-lock on RW-latch at 0x7f3418009d18 created in file dict0dict.cc line 2652 a writer (thread id 139861977528064) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.cc line 545 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/btr/btr0cur.cc line 536 --Thread 139861988017920 has waited at srv0srv.cc line 2006 for 238.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861935568640 has waited at buf0flu.cc line 1062 for 251.00 seconds the semaphore: S-lock on RW-latch at 0x7f42e7c7a1c0 created in file buf0buf.cc line 1069 a writer (thread id 139861977528064) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1056 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/fsp/fsp0fsp.cc line 200 --Thread 139861207713536 has waited at row0undo.cc line 298 for 237.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861226350336 has waited at row0undo.cc line 298 for 237.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861889881856 has waited at row0undo.cc line 298 for 237.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861891213056 has waited at row0undo.cc line 298 for 236.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861242058496 has waited at row0undo.cc line 298 for 236.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861246584576 has waited at row0undo.cc line 298 for 235.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861225551616 has waited at row0undo.cc line 298 for 235.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861914588928 has waited at dict0stats.cc line 2388 for 233.00 seconds the semaphore: X-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861885622016 has waited at row0undo.cc line 298 for 231.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861854738176 has waited at row0undo.cc line 298 for 230.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861240727296 has waited at row0undo.cc line 298 for 227.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861227415296 has waited at row0undo.cc line 298 for 227.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861246318336 has waited at row0undo.cc line 298 for 227.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861858998016 has waited at row0undo.cc line 298 for 226.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861881628416 has waited at row0undo.cc line 298 for 223.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861206648576 has waited at row0undo.cc line 298 for 223.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861221025536 has waited at row0undo.cc line 298 for 220.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861219694336 has waited at row0undo.cc line 298 for 220.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861234071296 has waited at row0undo.cc line 298 for 219.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861852342016 has waited at row0undo.cc line 298 for 219.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861218895616 has waited at row0undo.cc line 298 for 218.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861234870016 has waited at row0undo.cc line 298 for 216.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861860595456 has waited at row0undo.cc line 298 for 216.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861219428096 has waited at row0undo.cc line 298 for 216.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861230876416 has waited at row0undo.cc line 298 for 214.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861239662336 has waited at row0undo.cc line 298 for 211.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861228746496 has waited at row0undo.cc line 298 for 211.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861233272576 has waited at row0undo.cc line 298 for 211.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861219960576 has waited at row0undo.cc line 298 for 211.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861236999936 has waited at row0undo.cc line 298 for 210.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861884024576 has waited at row0undo.cc line 298 for 210.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861207447296 has waited at row0undo.cc line 298 for 209.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861244454656 has waited at row0undo.cc line 298 for 208.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861211440896 has waited at row0undo.cc line 298 for 208.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861243123456 has waited at row0undo.cc line 298 for 207.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861883758336 has waited at row0undo.cc line 298 for 206.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861244188416 has waited at row0undo.cc line 298 for 205.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861228214016 has waited at row0undo.cc line 298 for 204.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861857666816 has waited at row0undo.cc line 298 for 203.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861229545216 has waited at row0undo.cc line 298 for 203.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861225817856 has waited at row0undo.cc line 298 for 202.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861213304576 has waited at row0undo.cc line 298 for 202.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861235136256 has waited at row0undo.cc line 298 for 202.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861892011776 has waited at row0undo.cc line 298 for 202.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861238331136 has waited at row0undo.cc line 298 for 202.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861227681536 has waited at row0undo.cc line 298 for 201.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861892278016 has waited at row0undo.cc line 298 for 201.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861245519616 has waited at row0undo.cc line 298 for 200.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861213570816 has waited at row0undo.cc line 298 for 196.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861210642176 has waited at row0undo.cc line 298 for 195.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861227947776 has waited at row0undo.cc line 298 for 195.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861212772096 has waited at row0undo.cc line 298 for 195.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861247915776 has waited at row0undo.cc line 298 for 195.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861215434496 has waited at row0undo.cc line 298 for 189.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861231142656 has waited at row0undo.cc line 298 for 187.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861211174656 has waited at row0undo.cc line 298 for 187.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861233006336 has waited at row0undo.cc line 298 for 187.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861232473856 has waited at row0undo.cc line 298 for 187.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861217031936 has waited at row0undo.cc line 298 for 180.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861223421696 has waited at row0undo.cc line 298 for 179.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861224752896 has waited at row0undo.cc line 298 for 174.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861215966976 has waited at row0undo.cc line 298 for 174.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861236201216 has waited at row0undo.cc line 298 for 170.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861229811456 has waited at row0undo.cc line 298 for 170.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861239129856 has waited at row0undo.cc line 298 for 170.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861218096896 has waited at row0undo.cc line 298 for 170.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861228480256 has waited at row0undo.cc line 298 for 169.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861218363136 has waited at row0undo.cc line 298 for 166.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861221558016 has waited at row0undo.cc line 298 for 166.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861240194816 has waited at row0undo.cc line 298 for 166.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861209843456 has waited at row0undo.cc line 298 for 166.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861226084096 has waited at row0undo.cc line 298 for 166.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861220493056 has waited at row0undo.cc line 298 for 165.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861220759296 has waited at row0undo.cc line 298 for 164.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861210109696 has waited at row0undo.cc line 298 for 163.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861857134336 has waited at row0undo.cc line 298 for 158.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861219161856 has waited at row0undo.cc line 298 for 157.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861215168256 has waited at row0undo.cc line 298 for 151.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861243655936 has waited at row0undo.cc line 298 for 149.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861883492096 has waited at row0undo.cc line 298 for 144.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861208778496 has waited at row0undo.cc line 298 for 144.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861890414336 has waited at row0undo.cc line 298 for 144.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861886420736 has waited at row0undo.cc line 298 for 143.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861861660416 has waited at row0undo.cc line 298 for 143.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861860861696 has waited at row0undo.cc line 298 for 142.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861858199296 has waited at row0undo.cc line 298 for 138.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861230343936 has waited at row0undo.cc line 298 for 138.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861882959616 has waited at row0undo.cc line 298 for 137.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861857933056 has waited at row0undo.cc line 298 for 134.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861231675136 has waited at row0undo.cc line 298 for 134.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861890680576 has waited at row0undo.cc line 298 for 134.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861853939456 has waited at row0undo.cc line 298 for 133.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861242590976 has waited at row0undo.cc line 298 for 128.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861878167296 has waited at row0undo.cc line 298 for 128.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861239928576 has waited at row0undo.cc line 298 for 126.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861876037376 has waited at row0undo.cc line 298 for 123.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861239396096 has waited at row0undo.cc line 298 for 123.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861208246016 has waited at row0undo.cc line 298 for 123.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861856335616 has waited at row0undo.cc line 298 for 123.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861208512256 has waited at row0undo.cc line 298 for 122.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861887219456 has waited at row0undo.cc line 298 for 121.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861222090496 has waited at row0undo.cc line 298 for 118.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861886686976 has waited at row0undo.cc line 298 for 117.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861236733696 has waited at row0undo.cc line 298 for 116.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861889083136 has waited at row0undo.cc line 298 for 115.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861884557056 has waited at row0undo.cc line 298 for 114.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861222889216 has waited at row0undo.cc line 298 for 112.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861867517696 has waited at row0undo.cc line 298 for 111.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861243389696 has waited at row0undo.cc line 298 for 111.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861217830656 has waited at row0undo.cc line 298 for 108.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861241259776 has waited at row0undo.cc line 298 for 107.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861885888256 has waited at row0undo.cc line 298 for 106.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861854471936 has waited at row0undo.cc line 298 for 105.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861216233216 has waited at row0undo.cc line 298 for 102.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861238863616 has waited at row0undo.cc line 298 for 102.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861858731776 has waited at row0undo.cc line 298 for 102.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861247383296 has waited at row0undo.cc line 298 for 102.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861222622976 has waited at row0undo.cc line 298 for 102.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861857400576 has waited at row0undo.cc line 298 for 96.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861231941376 has waited at row0undo.cc line 298 for 96.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861225285376 has waited at row0undo.cc line 298 for 95.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861858465536 has waited at row0undo.cc line 298 for 93.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861890148096 has waited at row0undo.cc line 298 for 93.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861237532416 has waited at row0undo.cc line 298 for 92.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861241526016 has waited at row0undo.cc line 298 for 91.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861214635776 has waited at row0undo.cc line 298 for 91.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861246850816 has waited at row0undo.cc line 298 for 88.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861213837056 has waited at row0undo.cc line 298 for 85.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861889349376 has waited at row0undo.cc line 298 for 84.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861210908416 has waited at row0undo.cc line 298 for 84.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861244987136 has waited at row0undo.cc line 298 for 84.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861856601856 has waited at row0undo.cc line 298 for 83.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861220226816 has waited at row0undo.cc line 298 for 83.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861230610176 has waited at row0undo.cc line 298 for 82.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861245785856 has waited at row0undo.cc line 298 for 81.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861211707136 has waited at row0undo.cc line 298 for 81.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861207181056 has waited at row0undo.cc line 298 for 81.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861886154496 has waited at row0undo.cc line 298 for 81.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861247117056 has waited at row0undo.cc line 298 for 80.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861215700736 has waited at row0undo.cc line 298 for 79.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861217298176 has waited at row0undo.cc line 298 for 77.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861887751936 has waited at row0undo.cc line 298 for 75.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861238597376 has waited at row0undo.cc line 298 for 74.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861891479296 has waited at row0undo.cc line 298 for 74.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861247649536 has waited at row0undo.cc line 298 for 73.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861233538816 has waited at row0undo.cc line 298 for 73.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861863257856 has waited at row0undo.cc line 298 for 73.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861881894656 has waited at row0undo.cc line 298 for 73.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861860329216 has waited at row0undo.cc line 298 for 64.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861854205696 has waited at row0undo.cc line 298 for 64.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861876836096 has waited at row0undo.cc line 298 for 62.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861206914816 has waited at row0undo.cc line 298 for 53.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861209044736 has waited at row0undo.cc line 298 for 53.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861861926656 has waited at row0undo.cc line 298 for 50.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861240461056 has waited at row0undo.cc line 298 for 49.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861242857216 has waited at row0undo.cc line 298 for 49.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861231408896 has waited at row0undo.cc line 298 for 44.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861232207616 has waited at row0undo.cc line 298 for 44.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861223954176 has waited at row0undo.cc line 298 for 44.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861223155456 has waited at row0undo.cc line 298 for 43.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861234337536 has waited at row0undo.cc line 298 for 43.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861225019136 has waited at row0undo.cc line 298 for 42.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861243922176 has waited at row0undo.cc line 298 for 40.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861882160896 has waited at row0undo.cc line 298 for 39.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861882693376 has waited at row0undo.cc line 298 for 39.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861887485696 has waited at row0undo.cc line 298 for 39.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861229278976 has waited at row0undo.cc line 298 for 37.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861859264256 has waited at row0undo.cc line 298 for 36.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861882427136 has waited at row0undo.cc line 298 for 36.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861862459136 has waited at row0undo.cc line 298 for 36.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861852874496 has waited at row0undo.cc line 298 for 35.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861212505856 has waited at row0undo.cc line 298 for 33.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861242324736 has waited at row0undo.cc line 298 for 32.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861230077696 has waited at row0undo.cc line 298 for 32.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861852608256 has waited at row0undo.cc line 298 for 32.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861234603776 has waited at row0undo.cc line 298 for 31.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861876569856 has waited at row0undo.cc line 298 for 27.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861214902016 has waited at row0undo.cc line 298 for 27.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861241792256 has waited at row0undo.cc line 298 for 27.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861209310976 has waited at row0undo.cc line 298 for 27.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861245253376 has waited at row0undo.cc line 298 for 17.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861244720896 has waited at row0undo.cc line 298 for 17.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861888284416 has waited at row0undo.cc line 298 for 16.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861240993536 has waited at row0undo.cc line 298 for 16.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861853140736 has waited at row0undo.cc line 298 for 13.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861224486656 has waited at row0undo.cc line 298 for 13.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861218629376 has waited at row0undo.cc line 298 for 12.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861226882816 has waited at row0undo.cc line 298 for 12.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861892544256 has waited at row0undo.cc line 298 for 10.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861206382336 has waited at row0undo.cc line 298 for 10.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861879764736 has waited at row0undo.cc line 298 for 7.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861238064896 has waited at row0undo.cc line 298 for 7.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861855004416 has waited at row0undo.cc line 298 for 5.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861207979776 has waited at row0undo.cc line 298 for 1.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861216765696 has waited at row0undo.cc line 298 for 1.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861865387776 has waited at row0undo.cc line 298 for 1.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 --Thread 139861853406976 has waited at row0undo.cc line 298 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066 a writer (thread id 139861988017920) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0undo.cc line 298 Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388 OS WAIT ARRAY INFO: signal count 187058 Mutex spin waits 23093663, rounds 27034878, OS waits 74159 RW-shared spins 208262, rounds 3395058, OS waits 66359 RW-excl spins 185131, rounds 2383394, OS waits 21497 Spin rounds per wait: 1.17 mutex, 16.30 RW-shared, 12.87 RW-excl ------------ TRANSACTIONS ------------ This contains a lot of customer information -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) I/O thread 14 state: waiting for completed aio requests (write thread) I/O thread 15 state: waiting for completed aio requests (write thread) I/O thread 16 state: waiting for completed aio requests (write thread) I/O thread 17 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2713809 OS file reads, 4224052 OS file writes, 3319485 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 6.60 writes/s, 6.70 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 7343, seg size 7345, 152677 merges merged operations: insert 347254, delete mark 27806, delete 15568 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 151384511, node heap has 0 buffer(s) 0.00 hash searches/s, 11.45 non-hash searches/s --- LOG --- Log sequence number 1213488148819 Log flushed up to 1213488148801 Pages flushed up to 1213469413673 Last checkpoint at 1213469413673 0 pending log writes, 0 pending chkp writes 2827191 log i/o's done, 6.60 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 70330089472; in additional pool allocated 0 Dictionary memory allocated 1957905 Buffer pool size 4194296 Free buffers 1445317 Database pages 2748978 Old database pages 1014914 Modified db pages 11758 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 8280, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 2712532, created 36446, written 1245556 0.00 reads/s, 0.10 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2748978, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 524287 Free buffers 177876 Database pages 346411 Old database pages 127894 Modified db pages 2827 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 1043, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 340395, created 6016, written 207182 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 346411, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 524287 Free buffers 179743 Database pages 344544 Old database pages 127204 Modified db pages 1280 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1001, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 340489, created 4055, written 129326 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 344544, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 524287 Free buffers 178794 Database pages 345493 Old database pages 127555 Modified db pages 1161 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 980, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 341150, created 4343, written 131675 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 345493, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 524287 Free buffers 183100 Database pages 341186 Old database pages 125965 Modified db pages 1534 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1094, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 336746, created 4440, written 177429 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 341186, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 524287 Free buffers 180292 Database pages 343995 Old database pages 127002 Modified db pages 1190 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 972, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 339613, created 4382, written 173583 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 343995, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 524287 Free buffers 186216 Database pages 338071 Old database pages 124815 Modified db pages 1232 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 962, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 333882, created 4189, written 123772 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 338071, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 524287 Free buffers 177820 Database pages 346467 Old database pages 127914 Modified db pages 1359 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1105, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 342113, created 4354, written 142248 0.00 reads/s, 0.10 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 346467, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 524287 Free buffers 181476 Database pages 342811 Old database pages 126565 Modified db pages 1175 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1123, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 338144, created 4667, written 160341 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 342811, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 11 read views open inside InnoDB Main thread process no. 25403, id 139861988017920, state: enforcing dict cache limit Number of rows inserted 2874216, updated 2220456, deleted 95214, read 135178811996 4.00 inserts/s, 2.00 updates/s, 0.00 deletes/s, 1878.47 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Error: semaphore wait has lasted > 600 seconds InnoDB: We intentionally crash the server, because it appears to be hung. 2017-06-03 07:40:17 7f34295d2700 InnoDB: Assertion failure in thread 139862008997632 in file srv0srv.cc line 1756 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 23:40:17 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.