===================================== 120814 22:22:42 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1728889 1_second, 1728877 sleeps, 172862 10_second, 272 background, 272 flush srv_master_thread log flush and writes: 1751067 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 152677917, signal count 149168852 --Thread 140132563724032 has waited at btr0sea.c line 1939 for 926.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x10954328 'btr_search_latch_part[i]' a writer (thread id 140132563724032) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0cur.c line 855 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122787579648 has waited at btr0cur.c line 253 for 926.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122786776832 has waited at btr0sea.ic line 138 for 926.00 seconds the semaphore: S-lock on RW-latch at 0x10954328 'btr_search_latch_part[i]' a writer (thread id 140132563724032) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0cur.c line 855 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122788382464 has waited at btr0cur.c line 253 for 926.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122788181760 has waited at row0sel.c line 3698 for 926.00 seconds the semaphore: S-lock on RW-latch at 0x10954328 'btr_search_latch_part[i]' a writer (thread id 140132563724032) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0cur.c line 855 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122785371904 has waited at btr0cur.c line 253 for 926.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122779551488 has waited at row0sel.c line 3698 for 926.00 seconds the semaphore: S-lock on RW-latch at 0x10954328 'btr_search_latch_part[i]' a writer (thread id 140132563724032) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0cur.c line 855 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122784970496 has waited at btr0cur.c line 2019 for 926.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x10955678 'btr_search_latch_part[i]' a writer (thread id 140122784970496) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.c line 918 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122782963456 has waited at btr0sea.c line 1772 for 926.00 seconds the semaphore: X-lock on RW-latch at 0x10955678 'btr_search_latch_part[i]' a writer (thread id 140122784970496) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.c line 918 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140132563924736 has waited at dict0dict.c line 742 for 926.00 seconds the semaphore: Mutex at 0x1098a848 '&dict_sys->mutex', lock var 1 waiters flag 1 --Thread 140122783164160 has waited at btr0sea.c line 1772 for 926.00 seconds the semaphore: X-lock on RW-latch at 0x10954328 'btr_search_latch_part[i]' a writer (thread id 140132563724032) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0cur.c line 855 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/b --Thread 140122784569088 has waited at btr0cur.c line 253 for 926.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122783364864 has waited at btr0cur.c line 253 for 926.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdeec78 '&block->lock' a writer (thread id 140122784970496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0sea.c line 942 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/row/ro --Thread 140122786977536 has waited at btr0cur.c line 253 for 926.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122780555008 has waited at row0sel.c line 3698 for 926.00 seconds the semaphore: S-lock on RW-latch at 0x10955678 'btr_search_latch_part[i]' a writer (thread id 140122784970496) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.c line 918 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140132563523328 has waited at btr0cur.c line 253 for 926.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdeec78 '&block->lock' a writer (thread id 140122784970496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0sea.c line 942 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/row/ro --Thread 140122781959936 has waited at row0sel.c line 3698 for 926.00 seconds the semaphore: S-lock on RW-latch at 0x10954328 'btr_search_latch_part[i]' a writer (thread id 140132563724032) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0cur.c line 855 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122801284864 has waited at row0purge.c line 680 for 926.00 seconds the semaphore: S-lock on RW-latch at 0x108d660 '&dict_operation_lock' a writer (thread id 140122786776832) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0purge.c line 680 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/row/ro --Thread 140122780956416 has waited at btr0cur.c line 253 for 925.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122781357824 has waited at btr0cur.c line 253 for 925.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122783565568 has waited at btr0cur.c line 253 for 924.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122786576128 has waited at row0sel.c line 3698 for 924.00 seconds the semaphore: S-lock on RW-latch at 0x10954328 'btr_search_latch_part[i]' a writer (thread id 140132563724032) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0cur.c line 855 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122784769792 has waited at btr0cur.c line 253 for 924.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140132563121920 has waited at btr0sea.c line 1508 for 924.00 seconds the semaphore: S-lock on RW-latch at 0x10954328 'btr_search_latch_part[i]' a writer (thread id 140132563724032) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0cur.c line 855 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122787981056 has waited at btr0cur.c line 253 for 923.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122780153600 has waited at btr0cur.c line 253 for 923.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdeec78 '&block->lock' a writer (thread id 140122784970496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0sea.c line 942 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/row/ro --Thread 140122785974016 has waited at btr0sea.c line 669 for 923.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x10952fd8 'btr_search_latch_part[i]' a writer (thread id 140122785974016) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr0sea.c line 918 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140132564526848 has waited at btr0cur.c line 253 for 923.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122782160640 has waited at btr0cur.c line 253 for 922.00 seconds the semaphore: X-lock on RW-latch at 0x7f711bdef378 '&block->lock' a writer (thread id 140132563724032) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0sel.c line 3097 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/btr/bt --Thread 140122809677568 has waited at buf0flu.c line 1335 for 917.00 seconds the semaphore: S-lock on RW-latch at 0x7f711bdeec78 '&block->lock' a writer (thread id 140122784970496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0sea.c line 942 Last time write locked in file /home/jenkins/workspace/percona-server-5.5-debs/label_exp/debian6-64/target/Percona-Server-5.5.21-rel25.0/storage/innobase/row/ro --Thread 140122779350784 has waited at dict0dict.c line 340 for 875.00 seconds the semaphore: Mutex at 0x1098a848 '&dict_sys->mutex', lock var 1 waiters flag 1 Mutex spin waits 176841126, rounds 4900879334, OS waits 151184170 RW-shared spins 380165, rounds 10779338, OS waits 347809 RW-excl spins 109427, rounds 6091382, OS waits 175260 Spin rounds per wait: 27.71 mutex, 28.35 RW-shared, 55.67 RW-excl -------- 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 (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 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 430468 OS file reads, 69924754 OS file writes, 2045552 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 1598, seg size 1600, 36795 merges merged operations: insert 60118, delete mark 221073, delete 13410 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 17700827, node heap has 631 buffer(s) Hash table size 17700827, node heap has 13682 buffer(s) Hash table size 17700827, node heap has 1238 buffer(s) Hash table size 17700827, node heap has 1672 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 406478033094 Log flushed up to 406478033094 Last checkpoint at 406458206973 Max checkpoint age 1738750649 Checkpoint age target 1684414692 Modified age 17739861 Checkpoint age 19826121 0 pending log writes, 0 pending chkp writes 40481582 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 8824815616; in additional pool allocated 0 Internal hash tables (constant factor + variable factor) Adaptive hash index 607796544 (566426464 + 41370080) Page hash 8851208 (buffer pool 0 only) Dictionary cache 36163144 (35403184 + 759960) File system 137672 (82672 + 55000) Lock system 21279632 (21250568 + 29064) Recovery system 0 (0 + 0) Dictionary memory allocated 759960 Buffer pool size 524287 Buffer pool size, bytes 8589918208 Free buffers 0 Database pages 507064 Old database pages 187157 Modified db pages 1782 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 126601, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 424068, created 560414, written 28765591 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 507064, 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 8 read views open inside InnoDB ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 53A23593 Read view up limit trx id 53A23591 Read view low limit trx id 53A23593 Read view individually stored trx ids: Read view trx id 53A23592 Read view trx id 53A23591 ----------------- Main thread process no. 24174, id 140122809677568, state: flushing buffer pool pages Number of rows inserted 43905054, updated 27584984, deleted 1282643, read 12580238529 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ------------------------ LATEST DETECTED DEADLOCK ------------------------ 120814 17:33:16 *** (1) TRANSACTION: TRANSACTION 5390E491, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1248, 2 row lock(s) MySQL thread id 65647, OS thread handle 0x7f70e0fd9700, query id 307453567 event_scheduler Updating UPDATE ChatroomOnlineUser SET PendingCleanup = 1 WHERE LastPingedDateTime < DATE_ADD(NOW(), INTERVAL -20 SECOND) *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 5390E491 lock_mode X locks rec but not gap waitin *** (2) TRANSACTION: TRANSACTION 5390E48F, ACTIVE 1 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1 MySQL thread id 64156, OS thread handle 0x7f70e0ba3700, query id 307453557 10.0.113.14 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',172875) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 5390E48F lock_mode X locks rec but not gap *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 92418 page no 5 n bits 1000 index `LastPingedDateTime` of table `dating`.`ChatroomOnlineUser` trx id 5390E48F lock_mode X locks rec but no *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 53A235E2 Purge done for trx's n:o < 53A2357D undo n:o < 0 History list length 4086 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 53A2358F, not started MySQL thread id 66193, OS thread handle 0x7f70e0ee4700, query id 0 event_scheduler Clearing ---TRANSACTION 538947B9, not started MySQL thread id 64441, OS thread handle 0x7f70e09ea700, query id 311598394 02dbeb95.bb.sky.com 2.219.235.149 fppuser ---TRANSACTION 53A23577, not started mysql tables in use 3, locked 0 MySQL thread id 64321, OS thread handle 0x7f7327b1b700, query id 311598159 10.0.113.14 fppuser SELECT pt.PrivateChatThreadId, pt.InitiatedApplicationUserId, pt.ContactApplicationUserId, pt.InitiatedDateTime, pt.InitiatorLastPingedDateTime, pt.ContactLastPingedDateTime, pt.InitiatorClosedDateTime, pt.ContactClosedDateTime, aus.ApplicationUsername AS ContactedUsername, aur.ApplicationUsername AS InitiatedUsername FROM PrivateChatThread pt INNER JOIN ApplicationUser aus ON pt.ContactApplicationUserId = aus.ApplicationUserId INNER JOIN ApplicationUser aur ON pt.InitiatedApplicationUserId = aur.ApplicationUserId WHERE PrivateChatThreadId IN (127,4222,589 ---TRANSACTION 0, not started MySQL thread id 64266, OS thread handle 0x7f70e0c05700, query id 311598394 02dbeb95.bb.sky.com 2.219.235.149 fppuser ---TRANSACTION 53A23597, not started MySQL thread id 64277, OS thread handle 0x7f70e07cf700, query id 311598391 10.0.113.13 fppuser ---TRANSACTION 53A235E0, not started MySQL thread id 64154, OS thread handle 0x7f70e0988700, query id 311598392 10.0.113.13 fppuser ---TRANSACTION 53A235E1, not started MySQL thread id 19803, OS thread handle 0x7f7327a88700, query id 311598393 10.0.113.13 fppuser ---TRANSACTION 53A235DC, ACTIVE 922 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 63996, OS thread handle 0x7f70e0a7d700, query id 311598372 10.0.113.14 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',171277) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A235DC lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A235DC lock_mode X locks rec but not gap ---TRANSACTION 53A235D7, ACTIVE 923 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64275, OS thread handle 0x7f7327bae700, query id 311598356 10.0.113.13 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',138682) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A235D7 lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A235D7 lock_mode X locks rec but not gap ---TRANSACTION 53A235D3, ACTIVE 923 sec starting index read mysql tables in use 5, locked 0 MySQL thread id 63930, OS thread handle 0x7f70e0e20700, query id 311598343 10.0.113.13 fppuser Copying to tmp table SELECT SQL_NO_CACHE msgs.*, ApplicationUserName AS Username, IF (Sex = 'M', 'Male', 'Female') AS Sex, COALESCE(MinSavedFileName,MedSavedFileName, MaxSavedFileName, ChatroomUserDefaultImage(t2.Sex)) AS Image, COALESCE(Font, '') AS Font, COALESCE(FontColour, '') AS FontColour, COALESCE(Avatar, '') AS Avatar, COALESCE(FontSize, '') AS FontSize, ChatroomMessageTypeName FROM ChatroomMessage msgs INNER JOIN ChatroomMessageType cmt ON msgs.ChatroomMessageTypeId = cmt.ChatroomMessageTypeId INNER JOIN ApplicationUser t2 ON msgs.CreatedUserId = t2.ApplicationUserI Trx read view will not see trx with id >= 53A235D4, sees < 53A23591 ---TRANSACTION 53A235D2, ACTIVE 923 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64340, OS thread handle 0x7f70e100a700, query id 311598340 10.0.113.14 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',96263) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A235D2 lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A235D2 lock_mode X locks rec but not gap ---TRANSACTION 53A235D1, ACTIVE 923 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s) MySQL thread id 64424, OS thread handle 0x7f70e0893700, query id 311598336 10.0.113.14 fppuser update INSERT INTO ApplicationUserSession ( ApplicationUserId, LoggedInDateTime, LastRequestDateTime ) VALUES ( NAME_CONST('IPUserId',173176), NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:17' COLLATE 'latin1_swedish_ci'), NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:17' COLLATE 'latin1_swedish_ci') ) ON DUPLICATE KEY UPDATE LastRequestDateTime = NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:17' COLLATE 'latin1_swedish_ci') TABLE LOCK table `dating`.`ApplicationUserSession` trx id 53A235D1 lock mode IX ---TRANSACTION 53A235CB, ACTIVE 924 sec fetching rows mysql tables in use 1, locked 1 46 lock struct(s), heap size 6960, 295 row lock(s) MySQL thread id 43458, OS thread handle 0x7f7327a57700, query id 311598313 10.0.113.14 fppuser init UPDATE ApplicationEmail ae SET ProcessId = NAME_CONST('tempKey',_binaryVLT^Qx+\rq{' COLLATE 'binary') WHERE COALESCE(ae.LastErrorMessage, '') NOT LIKE '%Invalid email address syntax%' AND ae.IsSuccess = 0 AND ae.DeletionPending = 0 AND ae.SendAttempts < NAME_CONST('IPMaxSendAttempts',5) AND ProcessId IS NULL AND IsLocked = 0 ORDER BY CASE WHEN Account = 'fpptransactional' THEN 1 ELSE 0 END DESC, ApplicationEmailId DESC, SendAttempts ASC LIMIT 200 TABLE LOCK table `dating`.`ApplicationEmail` trx id 53A235CB lock mode IX RECORD LOCKS space id 98335 page no 4 n bits 800 index `IDX_BATCH_EMAIL` of table `dating`.`ApplicationEmail` trx id 53A235CB lock_mode X RECORD LOCKS space id 98335 page no 47404 n bits 80 index `PRIMARY` of table `dating`.`ApplicationEmail` trx id 53A235CB lock_mode X locks rec but not gap RECORD LOCKS space id 98335 page no 47405 n bits 72 index `PRIMARY` of table `dating`.`ApplicationEmail` trx id 53A235CB lock_mode X locks rec but not gap RECORD LOCKS space id 98335 page no 47395 n bits 72 index `PRIMARY` of table `dating`.`ApplicationEmail` trx id 53A235CB lock_mode X locks rec but not gap RECORD LOCKS space id 98335 page no 95467 n bits 72 index `PRIMARY` of table `dating`.`ApplicationEmail` trx id 53A235CB lock_mode X locks rec but not gap RECORD LOCKS space id 98335 page no 95468 n bits 72 index `PRIMARY` of table `dating`.`ApplicationEmail` trx id 53A235CB lock_mode X locks rec but not gap RECORD LOCKS space id 98335 page no 95469 n bits 72 index `PRIMARY` of table `dating`.`ApplicationEmail` trx id 53A235CB lock_mode X locks rec but not gap RECORD LOCKS space id 98335 page no 95471 n bits 72 index `PRIMARY` of table `dating`.`ApplicationEmail` trx id 53A235CB lock_mode X locks rec but not gap RECORD LOCKS space id 98335 page no 95472 n bits 72 index `PRIMARY` of table `dating`.`ApplicationEmail` trx id 53A235CB lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION 53A235C9, ACTIVE 924 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64338, OS thread handle 0x7f70e0cfa700, query id 311598303 10.0.113.13 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',164906) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A235C9 lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A235C9 lock_mode X locks rec but not gap ---TRANSACTION 53A235C3, ACTIVE 924 sec starting index read mysql tables in use 3, locked 0 MySQL thread id 64273, OS thread handle 0x7f70e0eb3700, query id 311598284 10.0.113.13 fppuser Sending data SELECT pt.PrivateChatThreadId, pt.InitiatedApplicationUserId, pt.ContactApplicationUserId, pt.InitiatedDateTime, pt.InitiatorLastPingedDateTime, pt.ContactLastPingedDateTime, pt.InitiatorClosedDateTime, pt.ContactClosedDateTime, aus.ApplicationUsername AS ContactedUsername, aur.ApplicationUsername AS InitiatedUsername FROM PrivateChatThread pt INNER JOIN ApplicationUser aus ON pt.ContactApplicationUserId = aus.ApplicationUserId INNER JOIN ApplicationUser aur ON pt.InitiatedApplicationUserId = aur.ApplicationUserId WHERE PrivateChatThreadId IN (127,4222,589 Trx read view will not see trx with id >= 53A235C4, sees < 53A23591 ---TRANSACTION 53A235C2, ACTIVE 924 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64131, OS thread handle 0x7f70e0bd4700, query id 311598278 10.0.113.14 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',142160) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A235C2 lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A235C2 lock_mode X locks rec but not gap ---TRANSACTION 53A235BC, ACTIVE 925 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64896, OS thread handle 0x7f70e09b9700, query id 311598259 10.0.113.13 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',27645) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A235BC lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A235BC lock_mode X locks rec but not gap ---TRANSACTION 53A235B6, ACTIVE 925 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64000, OS thread handle 0x7f70e0957700, query id 311598240 10.0.113.14 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',6843) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A235B6 lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A235B6 lock_mode X locks rec but not gap ---TRANSACTION 53A235B0, ACTIVE 926 sec starting index read mysql tables in use 2, locked 0 MySQL thread id 63931, OS thread handle 0x7f70e0a4c700, query id 311598221 10.0.113.13 fppuser statistics SELECT us.* FROM ApplicationUser au INNER JOIN SavedSearch us ON au.DefaultSavedSearchId = us.SavedSearchId WHERE au.ApplicationUserId = NAME_CONST('IPUserId',67589) Trx read view will not see trx with id >= 53A235B1, sees < 53A23591 ---TRANSACTION 53A235AE, ACTIVE 926 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s) MySQL thread id 63958, OS thread handle 0x7f7327ab9700, query id 311598215 10.0.113.13 fppuser update INSERT INTO ApplicationUserSession ( ApplicationUserId, LoggedInDateTime, LastRequestDateTime ) VALUES ( NAME_CONST('IPUserId',67589), NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:11' COLLATE 'latin1_swedish_ci'), NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:11' COLLATE 'latin1_swedish_ci') ) ON DUPLICATE KEY UPDATE LastRequestDateTime = NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:11' COLLATE 'latin1_swedish_ci') TABLE LOCK table `dating`.`ApplicationUserSession` trx id 53A235AE lock mode IX ---TRANSACTION 53A235A9, ACTIVE 926 sec starting index read mysql tables in use 5, locked 0 MySQL thread id 64130, OS thread handle 0x7f70e08f5700, query id 311598196 10.0.113.14 fppuser Copying to tmp table SELECT SQL_NO_CACHE t1.ApplicationUserName, t1.ApplicationUserId, Font, FontColour, FontSize, IsScroll, IsSound, t2.ResetLockedOutDateTime, DateOfBirth, Sex, COALESCE(t3.MinSavedFileName,t3.MedSavedFileName, t3.MaxSavedFileName, ChatroomUserDefaultImage(t1.Sex)) AS Avatar, CAST(COALESCE(IsBlocked, 0) AS UNSIGNED) AS IsBlocked, CAST(COALESCE(t2.IsVisible, 1) AS UNSIGNED) AS IsVisible, CAST(IF(t4.RoleName = 'Administrator', 1, 0) AS UNSIGNED) AS IsAdministrator, t5.ChatroomId, t5.EnteredRoomDateTime, t5.LastPingedDateTi Trx read view will not see trx with id >= 53A235AA, sees < 53A23591 ---TRANSACTION 53A235A5, ACTIVE 926 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64155, OS thread handle 0x7f70e0f15700, query id 311598183 10.0.113.14 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',150654) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A235A5 lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A235A5 lock_mode X locks rec but not gap ---TRANSACTION 53A235A4, ACTIVE 926 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s) MySQL thread id 64156, OS thread handle 0x7f70e0ba3700, query id 311598179 10.0.113.14 fppuser update INSERT INTO ApplicationUserSession ( ApplicationUserId, LoggedInDateTime, LastRequestDateTime ) VALUES ( NAME_CONST('IPUserId',119341), NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:14' COLLATE 'latin1_swedish_ci'), NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:14' COLLATE 'latin1_swedish_ci') ) ON DUPLICATE KEY UPDATE LastRequestDateTime = NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:14' COLLATE 'latin1_swedish_ci') TABLE LOCK table `dating`.`ApplicationUserSession` trx id 53A235A4 lock mode IX ---TRANSACTION 53A235A1, ACTIVE 926 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 63997, OS thread handle 0x7f70e0cc9700, query id 311598165 10.0.113.14 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',117420) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A235A1 lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A235A1 lock_mode X locks rec but not gap ---TRANSACTION 53A235A0, ACTIVE 926 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64041, OS thread handle 0x7f70e0b72700, query id 311598161 02dbeb95.bb.sky.com 2.219.235.149 fppuser Updating UPDATE ApplicationEmail SET LastSendAttemptDateTime = NAME_CONST('IPLastSendAttemptDateTime',_latin1'2012-08-14 22:07:16' COLLATE 'latin1_swedish_ci'), IsSuccess = NAME_CONST('IPIsSuccess',1), LastReturnCode = NAME_CONST('IPLastReturnCode',NULL), LastErrorMessage = NAME_CONST('IPLastErrorMessage',_latin1'' COLLATE 'latin1_swedish_ci'), SendAttempts = SendAttempts + 1, IsLocked = 0, ProcessId = NULL WHERE ApplicationEmailId = NAME_CONST('IPEmailId',3481697) TABLE LOCK table `dating`.`ApplicationEmail` trx id 53A235A0 lock mode IX RECORD LOCKS space id 98335 page no 69784 n bits 72 index `PRIMARY` of table `dating`.`ApplicationEmail` trx id 53A235A0 lock_mode X locks rec but not gap ---TRANSACTION 53A2359F, ACTIVE 926 sec updating or deleting mysql tables in use 2, locked 2 36 lock struct(s), heap size 6960, 129 row lock(s), undo log entries 1 MySQL thread id 63995, OS thread handle 0x7f70e0b41700, query id 311598152 10.0.113.14 fppuser Sending data UPDATE Message m INNER JOIN Contact c ON m.ContactId = c.ContactId SET LastViewedDateTime = NOW() WHERE c.RecipientUserId = NAME_CONST('IPUserId',170572) AND m.ConversationId = NAME_CONST('IPThreadId',2087899) AND LastViewedDateTime IS NULL TABLE LOCK table `dating`.`Message` trx id 53A2359F lock mode IX RECORD LOCKS space id 0 page no 110343 n bits 1192 index `IDX_CONVERSATION_ID` of table `dating`.`Message` trx id 53A2359F lock_mode X RECORD LOCKS space id 0 page no 221894 n bits 216 index `PRIMARY` of table `dating`.`Message` trx id 53A2359F lock_mode X locks rec but not gap RECORD LOCKS space id 0 page no 410521 n bits 184 index `PRIMARY` of table `dating`.`Message` trx id 53A2359F lock_mode X locks rec but not gap RECORD LOCKS space id 0 page no 410522 n bits 176 index `PRIMARY` of table `dating`.`Message` trx id 53A2359F lock_mode X locks rec but not gap RECORD LOCKS space id 0 page no 410523 n bits 176 index `PRIMARY` of table `dating`.`Message` trx id 53A2359F lock_mode X locks rec but not gap RECORD LOCKS space id 0 page no 222090 n bits 184 index `PRIMARY` of table `dating`.`Message` trx id 53A2359F lock_mode X locks rec but not gap RECORD LOCKS space id 0 page no 222091 n bits 184 index `PRIMARY` of table `dating`.`Message` trx id 53A2359F lock_mode X locks rec but not gap RECORD LOCKS space id 0 page no 450816 n bits 192 index `PRIMARY` of table `dating`.`Message` trx id 53A2359F lock_mode X locks rec but not gap RECORD LOCKS space id 0 page no 222122 n bits 128 index `PRIMARY` of table `dating`.`Message` trx id 53A2359F lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION 53A2359E, ACTIVE 926 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64423, OS thread handle 0x7f70e0d2b700, query id 311598147 10.0.113.14 fppuser update INSERT INTO ApplicationUserSession ( ApplicationUserId, LoggedInDateTime, LastRequestDateTime ) VALUES ( NAME_CONST('IPUserId',170572), NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:14' COLLATE 'latin1_swedish_ci'), NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:14' COLLATE 'latin1_swedish_ci') ) ON DUPLICATE KEY UPDATE LastRequestDateTime = NAME_CONST('IPUpdatedDateTime',_latin1'2012-08-14 22:07:14' COLLATE 'latin1_swedish_ci') TABLE LOCK table `dating`.`ApplicationUserSession` trx id 53A2359E lock mode IX RECORD LOCKS space id 199112 page no 3 n bits 600 index `PRIMARY` of table `dating`.`ApplicationUserSession` trx id 53A2359E lock_mode X locks rec but not gap ---TRANSACTION 53A2359B, ACTIVE 926 sec starting index read mysql tables in use 5, locked 0 MySQL thread id 64051, OS thread handle 0x7f70e0800700, query id 311598133 10.0.113.13 fppuser Sending data SELECT SQL_NO_CACHE msgs.*, ApplicationUserName AS Username, IF (Sex = 'M', 'Male', 'Female') AS Sex, COALESCE(MinSavedFileName,MedSavedFileName, MaxSavedFileName, ChatroomUserDefaultImage(t2.Sex)) AS Image, COALESCE(Font, '') AS Font, COALESCE(FontColour, '') AS FontColour, COALESCE(Avatar, '') AS Avatar, COALESCE(FontSize, '') AS FontSize, ChatroomMessageTypeName FROM ChatroomMessage msgs INNER JOIN ChatroomMessageType cmt ON msgs.ChatroomMessageTypeId = cmt.ChatroomMessageTypeId INNER JOIN ApplicationUser t2 ON msgs.CreatedUserId = t2.ApplicationUserI Trx read view will not see trx with id >= 53A2359C, sees < 53A23591 ---TRANSACTION 53A2359A, ACTIVE 926 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64339, OS thread handle 0x7f70e0d8d700, query id 311598130 10.0.113.14 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',169355) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A2359A lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A2359A lock_mode X locks rec but not gap ---TRANSACTION 53A23599, ACTIVE 926 sec starting index read mysql tables in use 5, locked 0 MySQL thread id 63945, OS thread handle 0x7f70e103b700, query id 311598126 10.0.113.13 fppuser Sending data SELECT SQL_NO_CACHE msgs.*, ApplicationUserName AS Username, IF (Sex = 'M', 'Male', 'Female') AS Sex, COALESCE(MinSavedFileName,MedSavedFileName, MaxSavedFileName, ChatroomUserDefaultImage(t2.Sex)) AS Image, COALESCE(Font, '') AS Font, COALESCE(FontColour, '') AS FontColour, COALESCE(Avatar, '') AS Avatar, COALESCE(FontSize, '') AS FontSize, ChatroomMessageTypeName FROM ChatroomMessage msgs INNER JOIN ChatroomMessageType cmt ON msgs.ChatroomMessageTypeId = cmt.ChatroomMessageTypeId INNER JOIN ApplicationUser t2 ON msgs.CreatedUserId = t2.ApplicationUserI Trx read view will not see trx with id >= 53A2359A, sees < 53A23591 ---TRANSACTION 53A23598, ACTIVE 926 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64341, OS thread handle 0x7f70e106c700, query id 311598123 10.0.113.14 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',76991) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A23598 lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A23598 lock_mode X locks rec but not gap ---TRANSACTION 53A23595, ACTIVE 926 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64276, OS thread handle 0x7f70e0fa8700, query id 311598113 10.0.113.13 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',84849) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A23595 lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A23595 lock_mode X locks rec but not gap ---TRANSACTION 53A23594, ACTIVE 926 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 64283, OS thread handle 0x7f7327aea700, query id 311598109 10.0.113.13 fppuser Updating UPDATE ChatroomOnlineUser SET LastPingedDateTime = NOW() WHERE ChatroomId = NAME_CONST('IPChatroomId',1) AND ApplicationUserId = NAME_CONST('IPUserId',163172) TABLE LOCK table `dating`.`ChatroomOnlineUser` trx id 53A23594 lock mode IX RECORD LOCKS space id 92418 page no 3 n bits 112 index `PRIMARY` of table `dating`.`ChatroomOnlineUser` trx id 53A23594 lock_mode X locks rec but not gap ---TRANSACTION 53A23592, ACTIVE 926 sec mysql tables in use 5, locked 0 , holds adaptive hash latch MySQL thread id 63999, OS thread handle 0x7f70e0a1b700, query id 311598102 10.0.113.14 fppuser Copying to tmp table SELECT SQL_NO_CACHE t1.ApplicationUserName, t1.ApplicationUserId, Font, FontColour, FontSize, IsScroll, IsSound, t2.ResetLockedOutDateTime, DateOfBirth, Sex, COALESCE(t3.MinSavedFileName,t3.MedSavedFileName, t3.MaxSavedFileName, ChatroomUserDefaultImage(t1.Sex)) AS Avatar, CAST(COALESCE(IsBlocked, 0) AS UNSIGNED) AS IsBlocked, CAST(COALESCE(t2.IsVisible, 1) AS UNSIGNED) AS IsVisible, CAST(IF(t4.RoleName = 'Administrator', 1, 0) AS UNSIGNED) AS IsAdministrator, t5.ChatroomId, t5.EnteredRoomDateTime, t5.LastPingedDateTi Trx read view will not see trx with id >= 53A23593, sees < 53A23591 ---TRANSACTION 53A23591, ACTIVE 926 sec dropping table 17 lock struct(s), heap size 3112, 15 row lock(s), undo log entries 5 MySQL thread id 66193, OS thread handle 0x7f70e0ee4700, query id 0 event_scheduler Clearing TABLE LOCK table `SYS_TABLES` trx id 53A23591 lock mode IS RECORD LOCKS space id 0 page no 8 n bits 264 index `CLUST_IND` of table `SYS_TABLES` trx id 53A23591 lock mode S TABLE LOCK table `SYS_FOREIGN` trx id 53A23591 lock mode IS RECORD LOCKS space id 0 page no 47 n bits 72 index `FOR_IND` of table `SYS_FOREIGN` trx id 53A23591 lock mode S TABLE LOCK table `SYS_INDEXES` trx id 53A23591 lock mode IS RECORD LOCKS space id 0 page no 327712 n bits 232 index `CLUST_IND` of table `SYS_INDEXES` trx id 53A23591 lock mode S TABLE LOCK table `SYS_STATS` trx id 53A23591 lock mode IX RECORD LOCKS space id 0 page no 45 n bits 72 index `CLUST_IND` of table `SYS_STATS` trx id 53A23591 lock_mode X TABLE LOCK table `SYS_FIELDS` trx id 53A23591 lock mode IX RECORD LOCKS space id 0 page no 12 n bits 360 index `CLUST_IND` of table `SYS_FIELDS` trx id 53A23591 lock_mode X TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---------------------------- 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. 120814 22:22:47 InnoDB: Assertion failure in thread 140122834855680 in file srv0srv.c line 2839 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.5/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 21:22:47 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. key_buffer_size=16777216 read_buffer_size=131072 max_used_connections=54 max_threads=255 thread_count=37 connection_count=34 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 574387 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x7c1805] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x6912a4] /lib/libpthread.so.0(+0xeff0)[0x7f73277f2ff0] /lib/libc.so.6(gsignal+0x35)[0x7f73269ee1b5] /lib/libc.so.6(abort+0x180)[0x7f73269f0fc0] /usr/sbin/mysqld[0x8661be] /lib/libpthread.so.0(+0x68ca)[0x7f73277ea8ca] /lib/libc.so.6(clone+0x6d)[0x7f7326a8b92d] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 120814 22:22:48 mysqld_safe Number of processes running now: 0 120814 22:22:48 mysqld_safe mysqld restarted 120814 22:22:48 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log 120814 22:22:48 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/ 120814 22:22:48 [ERROR] Use --lc-messages-dir without language specific part instead. 120814 22:22:48 [Note] Flashcache bypass: disabled 120814 22:22:48 [Note] Flashcache setup error is : ioctl failed 120814 22:22:48 [Note] Plugin 'FEDERATED' is disabled. 120814 22:22:48 InnoDB: The InnoDB memory heap is disabled 120814 22:22:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120814 22:22:48 InnoDB: Compressed tables use zlib 1.2.3 120814 22:22:48 InnoDB: Using Linux native AIO 120814 22:22:48 InnoDB: Initializing buffer pool, size = 8.0G 120814 22:22:49 InnoDB: Completed initialization of buffer pool 120814 22:22:49 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 406458206973 120814 22:22:49 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 406463449600 InnoDB: Doing recovery: scanned up to log sequence number 406468692480 InnoDB: Doing recovery: scanned up to log sequence number 406473935360 InnoDB: Doing recovery: scanned up to log sequence number 406478033094 InnoDB: 17 transaction(s) which must be rolled back or cleaned up InnoDB: in total 21 row operations to undo InnoDB: Trx id counter is 53A23700 120814 22:22:53 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 34999598, file name /var/log/mysql/mysql-bin.003265 120814 22:23:00 InnoDB: Rolling back trx with id 53A23591, 5 rows to undo InnoDB: Dropping table with id 390382 in recovery if it exists InnoDB: Error: trying to load index PRIMARY for table tmp/#sql5e6e_10291_0 InnoDB: but the index tree has been freed! InnoDB: Rolling back of trx id 53A23591 completed InnoDB: Error: trying to load index PRIMARY for table tmp/#sql188_1eff9_0 InnoDB: but the index tree has been freed! InnoDB: We removed now the InnoDB internal data dictionary entry InnoDB: of table 120814 22:23:00 [Warning] Invalid (old?) table or database name '#sql5e6e_f9fc_0' "tmp".. InnoDB: We removed now the InnoDB internal data dictionary entry InnoDB: of table 120814 22:23:00 [Warning] Invalid (old?) table or database name '#sql5e6e_fa00_0' "tmp".. InnoDB: We removed now the InnoDB internal data dictionary entry InnoDB: of table 120814 22:23:00 [Warning] Invalid (old?) table or database name '#sql5e6e_fa82_0' "tmp".. InnoDB: We removed now the InnoDB internal data dictionary entry InnoDB: of table 120814 22:23:00 [Warning] Invalid (old?) table or database name '#sql5e6e_fa9c_0' "tmp".. InnoDB: We removed now the InnoDB internal data dictionary entry InnoDB: of table 120814 22:23:00 [Warning] Invalid (old?) table or database name '#sql5e6e_fb15_0' "tmp".. InnoDB: We removed now the InnoDB internal data dictionary entry InnoDB: of table 120814 22:23:00 [Warning] Invalid (old?) table or database name '#sql5e6e_fb53_0' "tmp".. InnoDB: Error: trying to load index PRIMARY for table tmp/#sql620d_1c05_0 InnoDB: but the index tree has been freed! InnoDB: Error: trying to load index GEN_CLUST_INDEX for table tmp/#sql68ee_380e_0 InnoDB: but the index tree has been freed! InnoDB: Starting in background the rollback of uncommitted transactions 120814 22:23:00 InnoDB: Rolling back trx with id 53A235DC, 1 rows to undo 120814 22:23:00 InnoDB: Waiting for the background threads to start InnoDB: Rolling back of trx id 53A235DC completed 120814 22:23:00 InnoDB: Rolling back trx with id 53A235D7, 1 rows to undo InnoDB: Rolling back of trx id 53A23594 completed 120814 22:23:00 InnoDB: Rollback of non-prepared transactions completed 120814 22:23:01 Percona XtraDB (http://www.percona.com) 1.1.8-rel25.0 started; log sequence number 406478033094 120814 22:23:01 [Note] Recovering after a crash using /var/log/mysql/mysql-bin 120814 22:23:01 [Note] Starting crash recovery... 120814 22:23:01 [Note] Crash recovery finished. 120814 22:23:01 InnoDB: Error: table 120814 22:23:01 [Warning] Invalid (old?) table or database name '#sql5e6e_fb53_0' `tmp`. does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html 120814 22:23:01 InnoDB: Error: table 120814 22:23:01 [Warning] Invalid (old?) table or database name '#sql5e6e_fa00_0' `tmp`. does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html 120814 22:23:01 InnoDB: Error: table 120814 22:23:01 [Warning] Invalid (old?) table or database name '#sql5e6e_fa82_0' `tmp`. does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html 120814 22:23:01 InnoDB: Error: table 120814 22:23:01 [Warning] Invalid (old?) table or database name '#sql5e6e_fb15_0' `tmp`. does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html 120814 22:23:01 InnoDB: Error: table 120814 22:23:01 [Warning] Invalid (old?) table or database name '#sql5e6e_f9fc_0' `tmp`. does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html 120814 22:23:01 InnoDB: Error: table 120814 22:23:01 [Warning] Invalid (old?) table or database name '#sql5e6e_fa9c_0' `tmp`. does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html 120814 22:23:01 [ERROR] /usr/sbin/mysqld: Table './mysql/event' is marked as crashed and should be repaired 120814 22:23:01 [Warning] Checking table: './mysql/event' 120814 22:23:01 [ERROR] 1 client is using or hasn't closed the table properly 120814 22:23:01 [Note] Event Scheduler: Loaded 6 events 120814 22:23:01 [Note] Event Scheduler: scheduler thread started with id 1 120814 22:23:01 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.21-55-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 25.0