===================================== 120208 5:49:29 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 3484601 1_second, 3481056 sleeps, 337794 10_second, 142441 background, 142396 flush srv_master_thread log flush and writes: 3508242 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 7332237, signal count 73355641 --Thread 1277815104 has waited at btr/btr0cur.c line 1765 for 933.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2be10398 created in file btr/btr0sea.c line 170 a writer (thread id 1277815104) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 856 Last time write locked in file btr/btr0sea.c line 609 --Thread 1210669376 has waited at buf/buf0flu.c line 1105 for 933.00 seconds the semaphore: S-lock on RW-latch at 0x2aaad50bdf68 created in file buf/buf0buf.c line 682 a writer (thread id 1277815104) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1314556224 has waited at btr/btr0sea.c line 1257 for 929.00 seconds the semaphore: S-lock on RW-latch at 0x2be10398 created in file btr/btr0sea.c line 170 a writer (thread id 1277815104) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 856 Last time write locked in file btr/btr0sea.c line 609 --Thread 1248794944 has waited at btr/btr0cur.c line 1765 for 929.00 seconds the semaphore: X-lock on RW-latch at 0x2be10398 created in file btr/btr0sea.c line 170 a writer (thread id 1277815104) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 856 Last time write locked in file btr/btr0sea.c line 609 --Thread 1328400704 has waited at btr/btr0cur.c line 1765 for 928.00 seconds the semaphore: X-lock on RW-latch at 0x2be10398 created in file btr/btr0sea.c line 170 a writer (thread id 1277815104) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 856 Last time write locked in file btr/btr0sea.c line 609 --Thread 1288997184 has waited at row/row0sel.c line 3681 for 927.00 seconds the semaphore: S-lock on RW-latch at 0x2aaacfd624f8 created in file buf/buf0buf.c line 682 a writer (thread id 1328400704) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0sel.c line 3681 Last time write locked in file row/row0upd.c line 1860 --Thread 1262639424 has waited at row/row0sel.c line 3681 for 924.00 seconds the semaphore: S-lock on RW-latch at 0x2aaad50bdf68 created in file buf/buf0buf.c line 682 a writer (thread id 1277815104) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1310296384 has waited at row/row0sel.c line 3681 for 918.00 seconds the semaphore: S-lock on RW-latch at 0x2aaae2d72d90 created in file buf/buf0buf.c line 682 a writer (thread id 1248794944) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0sel.c line 3681 Last time write locked in file row/row0upd.c line 1860 --Thread 1330796864 has waited at btr/btr0cur.c line 1765 for 913.00 seconds the semaphore: X-lock on RW-latch at 0x2be10398 created in file btr/btr0sea.c line 170 a writer (thread id 1277815104) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 856 Last time write locked in file btr/btr0sea.c line 609 --Thread 1297516864 has waited at btr/btr0cur.c line 1765 for 910.00 seconds the semaphore: X-lock on RW-latch at 0x2be10398 created in file btr/btr0sea.c line 170 a writer (thread id 1277815104) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 856 Last time write locked in file btr/btr0sea.c line 609 --Thread 1314822464 has waited at btr/btr0cur.c line 1765 for 904.00 seconds the semaphore: X-lock on RW-latch at 0x2be10398 created in file btr/btr0sea.c line 170 a writer (thread id 1277815104) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 856 Last time write locked in file btr/btr0sea.c line 609 --Thread 1287399744 has waited at row/row0sel.c line 3681 for 900.00 seconds the semaphore: S-lock on RW-latch at 0x2aaacfd624f8 created in file buf/buf0buf.c line 682 a writer (thread id 1328400704) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0sel.c line 3681 Last time write locked in file row/row0upd.c line 1860 --Thread 1337719104 has waited at row/row0sel.c line 3681 for 896.00 seconds the semaphore: S-lock on RW-latch at 0x2aaadb3b23a8 created in file buf/buf0buf.c line 682 a writer (thread id 1297516864) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0sel.c line 3681 Last time write locked in file row/row0upd.c line 1860 --Thread 1321212224 has waited at row/row0sel.c line 3681 for 886.00 seconds the semaphore: S-lock on RW-latch at 0x2aaacfd624f8 created in file buf/buf0buf.c line 682 a writer (thread id 1328400704) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0sel.c line 3681 Last time write locked in file row/row0upd.c line 1860 --Thread 1254119744 has waited at btr/btr0cur.c line 1765 for 883.00 seconds the semaphore: X-lock on RW-latch at 0x2be10398 created in file btr/btr0sea.c line 170 a writer (thread id 1277815104) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 856 Last time write locked in file btr/btr0sea.c line 609 --Thread 1283672384 has waited at ./include/btr0btr.ic line 53 for 871.00 seconds the semaphore: S-lock on RW-latch at 0x2aaae5cc3a10 created in file buf/buf0buf.c line 682 a writer (thread id 1314822464) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0sel.c line 3681 Last time write locked in file row/row0upd.c line 1860 Mutex spin waits 341483186, rounds 642270985, OS waits 4523425 RW-shared spins 20966398, OS waits 1845887; RW-excl spins 8790045, OS waits 704859 Spin rounds per wait: 1.88 mutex, 4.51 RW-shared, 13.53 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ ... ------------ TRANSACTIONS ------------ Trx id counter 18297355 Purge done for trx's n:o < 18297198 undo n:o < 0 History list length 31 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started, process no 24384, OS thread id 1288198464 MySQL thread id 13799711, query id 1167764230 prod-cs4-web-07 172.21.203.37 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1286334784 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799706, query id 1167764192 prod-cs4-web-07 172.21.203.37 clearview updating delete from tickets where user_id = '56188' ---TRANSACTION 0, not started, process no 24384, OS thread id 1244002624 MySQL thread id 13799650, query id 1167764003 prod-cs4-web-03 172.21.203.33 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1347037504 MySQL thread id 13799630, query id 1167763950 prod-cs4-web-02 172.21.203.32 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1251989824 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799618, query id 1167763880 prod-cs4-web-08 172.21.203.38 clearview Updating UPDATE tickets SET ts = '1328697926' WHERE ( ticket_hash = '4183cc1527dbbcb20097f3271781f3ea' ) ---TRANSACTION 0, not started, process no 24384, OS thread id 1252788544 MySQL thread id 13799596, query id 1167763812 prod-cs4-web-08 172.21.203.38 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1303107904 MySQL thread id 13799576, query id 1167763759 prod-cs4-web-06 172.21.203.36 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1284737344 MySQL thread id 13799556, query id 1167763702 prod-cs4-web-07 172.21.203.37 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1247197504 MySQL thread id 13799531, query id 1167763617 prod-cs4-web-06 172.21.203.36 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1260775744 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799528, query id 1167763602 prod-cs4-web-05 172.21.203.35 clearview Updating UPDATE tickets SET ts = '1328697841' WHERE ( ticket_hash = '4183cc1527dbbcb20097f3271781f3ea' ) ---TRANSACTION 0, not started, process no 24384, OS thread id 1319082304 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799525, query id 1167763585 prod-cs4-web-06 172.21.203.36 clearview updating delete from tickets where user_id = '56188' ---TRANSACTION 0, not started, process no 24384, OS thread id 1323874624 MySQL thread id 13799411, query id 1167763240 prod-cs4-web-11 172.21.203.41 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1277548864 MySQL thread id 13799390, query id 1167763179 prod-cs4-web-07 172.21.203.37 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1252256064 MySQL thread id 13799370, query id 1167763127 prod-cs4-web-05 172.21.203.35 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1297783104 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799358, query id 1167763060 prod-cs4-web-06 172.21.203.36 clearview Updating UPDATE tickets SET ts = '1328697720' WHERE ( ticket_hash = '4183cc1527dbbcb20097f3271781f3ea' ) ---TRANSACTION 0, not started, process no 24384, OS thread id 1253853504 MySQL thread id 13799338, query id 1167763005 prod-cs4-web-06 172.21.203.36 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1267697984 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799333, query id 1167762981 prod-cs4-web-03 172.21.203.33 clearview Updating UPDATE tickets SET ts = '1328697708' WHERE ( ticket_hash = '4183cc1527dbbcb20097f3271781f3ea' ) ---TRANSACTION 0, not started, process no 24384, OS thread id 1258113344 MySQL thread id 13799312, query id 1167762920 prod-cs4-web-09 172.21.203.39 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1337985344 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799306, query id 1167762886 prod-cs4-web-09 172.21.203.39 clearview Updating UPDATE tickets SET ts = '1328697667' WHERE ( ticket_hash = '4183cc1527dbbcb20097f3271781f3ea' ) ---TRANSACTION 0, not started, process no 24384, OS thread id 1279146304 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799302, query id 1167762864 prod-cs4-web-06 172.21.203.36 clearview updating delete from tickets where user_id = '56188' ---TRANSACTION 0, not started, process no 24384, OS thread id 1251457344 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799259, query id 1167762694 prod-cs4-web-09 172.21.203.39 clearview Updating UPDATE tickets SET ts = '1328697559' WHERE ( ticket_hash = '4183cc1527dbbcb20097f3271781f3ea' ) ---TRANSACTION 0, not started, process no 24384, OS thread id 1340913984 MySQL thread id 13799164, query id 1167762372 prod-cs4-web-05 172.21.203.35 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1275685184 MySQL thread id 13799139, query id 1167762305 prod-cs4-web-09 172.21.203.39 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1307633984 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799132, query id 1167762272 prod-cs4-web-09 172.21.203.39 clearview updating delete from tickets where user_id = '56188' ---TRANSACTION 0, not started, process no 24384, OS thread id 1246665024 MySQL thread id 13799070, query id 1167762050 prod-cs4-web-05 172.21.203.35 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1250126144 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 13799066, query id 1167762030 prod-cs4-web-04 172.21.203.34 clearview updating delete from tickets where user_id = '56188' ---TRANSACTION 0, not started, process no 24384, OS thread id 1280743744 MySQL thread id 13798971, query id 1167759850 prod-cs4-web-10 172.21.203.40 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1315887424 MySQL thread id 13798970, query id 1167759840 prod-cs4-web-10 172.21.203.40 clearview ---TRANSACTION 18297263, not started, process no 24384, OS thread id 1248528704 MySQL thread id 13798965, query id 1167759873 prod-cs4-web-10 172.21.203.40 clearview ---TRANSACTION 182971FF, not started, process no 24384, OS thread id 1298315584 MySQL thread id 13798963, query id 1167759871 prod-cs4-web-10 172.21.203.40 clearview ---TRANSACTION 0, not started, process no 24384, OS thread id 1250658624 MySQL thread id 13798958, query id 1167761681 prod-cs4-web-08 172.21.203.38 clearview ---TRANSACTION 18297249, not started, process no 24384, OS thread id 1291127104 MySQL thread id 13798955, query id 1167761682 prod-cs4-web-08 172.21.203.38 clearview ---TRANSACTION 1828F12F, not started, process no 24384, OS thread id 1279678784 MySQL thread id 13793599, query id 1167533045 prod-cs4-app-04 172.21.203.28 clearview ---TRANSACTION 1828C93D, not started, process no 24384, OS thread id 1242937664 MySQL thread id 13791445, query id 1167452820 prod-cs4-app-01 172.21.203.25 clearview ---TRANSACTION 1827563E, not started, process no 24384, OS thread id 1304439104 MySQL thread id 13783863, query id 1166996986 prod-cs4-app-02 172.21.203.26 clearview ---TRANSACTION 1828D62B, not started, process no 24384, OS thread id 1318017344 MySQL thread id 13773214, query id 1167479925 prod-cs4-app-04 172.21.203.28 clearview ---TRANSACTION 18252ACC, not started, process no 24384, OS thread id 1338251584 MySQL thread id 13772225, query id 1166483855 prod-cs4-app-01 172.21.203.25 clearview ---TRANSACTION 18223CD8, not started, process no 24384, OS thread id 1263438144 MySQL thread id 13766763, query id 1166059102 prod-cs4-app-03 172.21.203.27 clearview ---TRANSACTION 1829384C, not started, process no 24384, OS thread id 1257314624 MySQL thread id 13594910, query id 1167764362 prod-cs4-app-04 172.21.203.28 clearview ---TRANSACTION 18293D70, not started, process no 24384, OS thread id 1286867264 MySQL thread id 13594909, query id 1167764361 prod-cs4-app-04 172.21.203.28 clearview ---TRANSACTION 18293840, not started, process no 24384, OS thread id 1316419904 MySQL thread id 13594007, query id 1167764368 prod-cs4-app-03 172.21.203.27 clearview ---TRANSACTION 18293D6F, not started, process no 24384, OS thread id 1320679744 MySQL thread id 13594006, query id 1167764358 prod-cs4-app-03 172.21.203.27 clearview ---TRANSACTION 1829710B, not started, process no 24384, OS thread id 1293789504 MySQL thread id 13592548, query id 1167764359 prod-cs4-app-02 172.21.203.26 clearview ---TRANSACTION 18296D12, not started, process no 24384, OS thread id 1286068544 MySQL thread id 13592547, query id 1167764367 prod-cs4-app-02 172.21.203.26 clearview ---TRANSACTION 18293E13, not started, process no 24384, OS thread id 1270626624 MySQL thread id 13591472, query id 1167764360 prod-cs4-app-01 172.21.203.25 clearview ---TRANSACTION 18294754, not started, process no 24384, OS thread id 1284471104 MySQL thread id 13591471, query id 1167764366 prod-cs4-app-01 172.21.203.25 clearview ---TRANSACTION 18277060, not started, process no 24384, OS thread id 1243736384 MySQL thread id 236, query id 1167053377 Has read all relay log; waiting for the slave I/O thread to update it ---TRANSACTION 18297354, ACTIVE 12 sec, process no 24384, OS thread id 1277282624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799742, query id 1167764365 prod-cs4-web-11 172.21.203.41 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 18297353, ACTIVE 50 sec, process no 24384, OS thread id 1245067584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799736, query id 1167764314 prod-cs4-web-11 172.21.203.41 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '38816122d6f89a0c6b7b731d67f60b4b' ) ---TRANSACTION 18297352, ACTIVE 51 sec, process no 24384, OS thread id 1268230464 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799735, query id 1167764311 prod-cs4-web-08 172.21.203.38 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '303ef62bc291961f4757493833f6e535' ) ---TRANSACTION 18297351, ACTIVE 51 sec, process no 24384, OS thread id 1312958784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799734, query id 1167764308 prod-cs4-web-10 172.21.203.40 clearview statistics select * from projects where uri_name='_forgot' Trx read view will not see trx with id >= 18297352, sees < 18297264 ---TRANSACTION 18297350, ACTIVE 81 sec, process no 24384, OS thread id 1316952384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799731, query id 1167764285 prod-cs4-web-08 172.21.203.38 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '38816122d6f89a0c6b7b731d67f60b4b' ) ---TRANSACTION 1829734F, ACTIVE 100 sec, process no 24384, OS thread id 1278880064 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799730, query id 1167764280 prod-cs4-web-07 172.21.203.37 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='117' Trx read view will not see trx with id >= 18297350, sees < 18297264 ---TRANSACTION 1829734E, ACTIVE 167 sec, process no 24384, OS thread id 1329465664 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799673, query id 1167764075 prod-cs4-web-05 172.21.203.35 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '38816122d6f89a0c6b7b731d67f60b4b' ) ---TRANSACTION 1829734D, ACTIVE 173 sec, process no 24384, OS thread id 1253054784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799672, query id 1167764071 prod-cs4-web-04 172.21.203.34 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '303ef62bc291961f4757493833f6e535' ) ---TRANSACTION 1829734C, ACTIVE 188 sec, process no 24384, OS thread id 1326537024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799669, query id 1167764053 prod-cs4-web-03 172.21.203.33 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='107' Trx read view will not see trx with id >= 1829734D, sees < 18297264 ---TRANSACTION 1829734B, ACTIVE 193 sec, process no 24384, OS thread id 1288730944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799649, query id 1167764000 prod-cs4-web-02 172.21.203.32 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='107' Trx read view will not see trx with id >= 1829734C, sees < 18297264 ---TRANSACTION 1829734A, ACTIVE 217 sec, process no 24384, OS thread id 1299913024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799624, query id 1167763905 prod-cs4-web-11 172.21.203.41 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'd20120df32a093ae7989443ff61e60cf' ) ---TRANSACTION 18297349, ACTIVE 220 sec, process no 24384, OS thread id 1279945024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799623, query id 1167763902 prod-cs4-web-11 172.21.203.41 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'd20120df32a093ae7989443ff61e60cf' ) ---TRANSACTION 18297348, ACTIVE 228 sec, process no 24384, OS thread id 1270094144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799622, query id 1167763893 prod-cs4-web-03 172.21.203.33 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '293cd7668ed168ba0397f8c6f69e1ca1' ) ---TRANSACTION 18297347, ACTIVE 235 sec, process no 24384, OS thread id 1244801344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799621, query id 1167763890 prod-cs4-web-10 172.21.203.40 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '5f03a4cc6ced00fff205daffb4342db9' ) ---TRANSACTION 18297346, ACTIVE 241 sec, process no 24384, OS thread id 1275152704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799620, query id 1167763887 prod-cs4-web-02 172.21.203.32 clearview statistics select * from projects where uri_name='_forgot' Trx read view will not see trx with id >= 18297347, sees < 18297264 ---TRANSACTION 18297345, ACTIVE 242 sec, process no 24384, OS thread id 1267165504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799619, query id 1167763884 prod-cs4-web-09 172.21.203.39 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '7812f546954073425b4ae9276339879a' ) ---TRANSACTION 18297344, ACTIVE 252 sec, process no 24384, OS thread id 1302309184 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799615, query id 1167763862 prod-cs4-web-08 172.21.203.38 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='3' Trx read view will not see trx with id >= 18297345, sees < 18297264 ---TRANSACTION 18297343, ACTIVE 253 sec, process no 24384, OS thread id 1262373184 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799595, query id 1167763809 prod-cs4-web-06 172.21.203.36 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='107' Trx read view will not see trx with id >= 18297344, sees < 18297264 ---TRANSACTION 18297342, ACTIVE 273 sec, process no 24384, OS thread id 1290328384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799575, query id 1167763752 prod-cs4-web-07 172.21.203.37 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='87' Trx read view will not see trx with id >= 18297343, sees < 18297264 ---TRANSACTION 18297341, ACTIVE 287 sec, process no 24384, OS thread id 1274087744 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799555, query id 1167763693 prod-cs4-web-05 172.21.203.35 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'ba0e48e9424ee17b75815744c60eff4e' ) ---TRANSACTION 18297340, ACTIVE 292 sec, process no 24384, OS thread id 1249061184 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799554, query id 1167763690 prod-cs4-web-03 172.21.203.33 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '6e91a62b398c30f878791f539cfaf5f3' ) ---TRANSACTION 1829733F, ACTIVE 303 sec, process no 24384, OS thread id 1345173824 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799550, query id 1167763667 prod-cs4-web-06 172.21.203.36 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='156' Trx read view will not see trx with id >= 18297340, sees < 18297264 ---TRANSACTION 1829733E, ACTIVE 310 sec, process no 24384, OS thread id 1246132544 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799530, query id 1167763610 prod-cs4-web-02 172.21.203.32 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '5950566421a177ebd8372a1ea531b180' ) ---TRANSACTION 1829733D, ACTIVE 312 sec, process no 24384, OS thread id 1335056704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799529, query id 1167763607 prod-cs4-web-01 172.21.203.31 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 1829733C, ACTIVE 332 sec, process no 24384, OS thread id 1274620224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799527, query id 1167763597 prod-cs4-web-10 172.21.203.40 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '303ef62bc291961f4757493833f6e535' ) ---TRANSACTION 1829733B, ACTIVE 334 sec, process no 24384, OS thread id 1330530624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799526, query id 1167763593 prod-cs4-web-09 172.21.203.39 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 1829733A, ACTIVE 342 sec, process no 24384, OS thread id 1248262464 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799496, query id 1167763493 prod-cs4-web-01 172.21.203.31 clearview Sending data select SQL_CALC_FOUND_ROWS users.* from users where (name='sta085@maersk.com') limit 0, 1000000000000 Trx read view will not see trx with id >= 1829733B, sees < 18297264 ---TRANSACTION 18297339, ACTIVE 349 sec, process no 24384, OS thread id 1268762944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799440, query id 1167763339 prod-cs4-web-01 172.21.203.31 clearview statistics SELECT a_session FROM sessions WHERE id = '1d0109089684390b7f87b4c44016481f' Trx read view will not see trx with id >= 1829733A, sees < 18297264 ---TRANSACTION 18297338, ACTIVE 349 sec, process no 24384, OS thread id 1289263424 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799439, query id 1167763336 prod-cs4-web-10 172.21.203.40 clearview statistics SELECT a_session FROM sessions WHERE id = '1d0109089684390b7f87b4c44016481f' Trx read view will not see trx with id >= 18297339, sees < 18297264 ---TRANSACTION 18297337, ACTIVE 351 sec, process no 24384, OS thread id 1324673344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799438, query id 1167763333 prod-cs4-web-09 172.21.203.39 clearview statistics SELECT a_session FROM sessions WHERE id = '1d0109089684390b7f87b4c44016481f' Trx read view will not see trx with id >= 18297338, sees < 18297264 ---TRANSACTION 18297336, ACTIVE 382 sec, process no 24384, OS thread id 1333991744 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799432, query id 1167763296 prod-cs4-web-08 172.21.203.38 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '6e91a62b398c30f878791f539cfaf5f3' ) ---TRANSACTION 18297335, ACTIVE 387 sec, process no 24384, OS thread id 1344108864 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799431, query id 1167763293 prod-cs4-web-07 172.21.203.37 clearview statistics SELECT a_session FROM sessions WHERE id = 'ebc94a837f0c4c20b4768621bd2dce18' Trx read view will not see trx with id >= 18297336, sees < 18297264 ---TRANSACTION 18297334, ACTIVE 388 sec, process no 24384, OS thread id 1345972544 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799430, query id 1167763290 prod-cs4-web-11 172.21.203.41 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='18' Trx read view will not see trx with id >= 18297335, sees < 18297264 ---TRANSACTION 18297333, ACTIVE 394 sec, process no 24384, OS thread id 1264236864 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799410, query id 1167763237 prod-cs4-web-09 172.21.203.39 clearview statistics SELECT a_session FROM sessions WHERE id = '1d0109089684390b7f87b4c44016481f' Trx read view will not see trx with id >= 18297334, sees < 18297264 ---TRANSACTION 18297332, ACTIVE 404 sec, process no 24384, OS thread id 1293257024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799409, query id 1167763229 prod-cs4-web-07 172.21.203.37 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='156' Trx read view will not see trx with id >= 18297333, sees < 18297264 ---TRANSACTION 18297331, ACTIVE 405 sec, process no 24384, OS thread id 1320147264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799389, query id 1167763177 prod-cs4-web-05 172.21.203.35 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='107' Trx read view will not see trx with id >= 18297332, sees < 18297264 ---TRANSACTION 18297330, ACTIVE 411 sec, process no 24384, OS thread id 1297250624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799369, query id 1167763123 prod-cs4-web-04 172.21.203.34 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 1829732F, ACTIVE 420 sec, process no 24384, OS thread id 1286601024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799368, query id 1167763119 prod-cs4-web-01 172.21.203.31 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '38816122d6f89a0c6b7b731d67f60b4b' ) ---TRANSACTION 1829732E, ACTIVE 423 sec, process no 24384, OS thread id 1280211264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799367, query id 1167763116 prod-cs4-web-11 172.21.203.41 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '303ef62bc291961f4757493833f6e535' ) ---TRANSACTION 1829732D, ACTIVE 425 sec, process no 24384, OS thread id 1340381504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799362, query id 1167763082 prod-cs4-web-10 172.21.203.40 clearview statistics SELECT a_session FROM sessions WHERE id = '1d0109089684390b7f87b4c44016481f' Trx read view will not see trx with id >= 1829732E, sees < 18297264 ---TRANSACTION 1829732C, ACTIVE 429 sec, process no 24384, OS thread id 1347569984 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799360, query id 1167763070 prod-cs4-web-06 172.21.203.36 clearview statistics select * from projects where uri_name='_forgot' Trx read view will not see trx with id >= 1829732D, sees < 18297264 ---TRANSACTION 1829732B, ACTIVE 447 sec, process no 24384, OS thread id 1319614784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799359, query id 1167763064 prod-cs4-web-08 172.21.203.38 clearview statistics SELECT a_session FROM sessions WHERE id = '1d0109089684390b7f87b4c44016481f' Trx read view will not see trx with id >= 1829732C, sees < 18297264 ---TRANSACTION 1829732A, ACTIVE 450 sec, process no 24384, OS thread id 1321744704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799357, query id 1167763055 prod-cs4-web-06 172.21.203.36 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='156' Trx read view will not see trx with id >= 1829732B, sees < 18297264 ---TRANSACTION 18297329, ACTIVE 454 sec, process no 24384, OS thread id 1247996224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799337, query id 1167763003 prod-cs4-web-01 172.21.203.31 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '95414efaf431f422dd0be61d402029e0' ) ---TRANSACTION 18297328, ACTIVE 459 sec, process no 24384, OS thread id 1328666944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799335, query id 1167762991 prod-cs4-web-06 172.21.203.36 clearview statistics SELECT a_session FROM sessions WHERE id = '68130bf0b3fd441aa27b306ff2a8b1f7' Trx read view will not see trx with id >= 18297329, sees < 18297264 ---TRANSACTION 18297327, ACTIVE 470 sec, process no 24384, OS thread id 1340647744 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799332, query id 1167762974 prod-cs4-web-11 172.21.203.41 clearview statistics SELECT a_session FROM sessions WHERE id = 'a0d60dc7705ac369f68fe32223c47717' Trx read view will not see trx with id >= 18297328, sees < 18297264 ---TRANSACTION 18297326, ACTIVE 480 sec, process no 24384, OS thread id 1246398784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799331, query id 1167762970 prod-cs4-web-09 172.21.203.39 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='105' Trx read view will not see trx with id >= 18297327, sees < 18297264 ---TRANSACTION 18297325, ACTIVE 487 sec, process no 24384, OS thread id 1334524224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799310, query id 1167762913 prod-cs4-web-02 172.21.203.32 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '5950566421a177ebd8372a1ea531b180' ) ---TRANSACTION 18297324, ACTIVE 503 sec, process no 24384, OS thread id 1281276224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799305, query id 1167762881 prod-cs4-web-06 172.21.203.36 clearview statistics SELECT a_session FROM sessions WHERE id = '68130bf0b3fd441aa27b306ff2a8b1f7' Trx read view will not see trx with id >= 18297325, sees < 18297264 ---TRANSACTION 18297323, ACTIVE 516 sec, process no 24384, OS thread id 1265035584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799304, query id 1167762875 prod-cs4-web-10 172.21.203.40 clearview statistics SELECT a_session FROM sessions WHERE id = '60cf9c4e2040d0287305c37e1fdfaa24' Trx read view will not see trx with id >= 18297324, sees < 18297264 ---TRANSACTION 18297322, ACTIVE 526 sec, process no 24384, OS thread id 1309763904 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799303, query id 1167762868 prod-cs4-web-10 172.21.203.40 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '9a458016ab65d0692fbcbbacd1751e57' ) ---TRANSACTION 18297321, ACTIVE 536 sec, process no 24384, OS thread id 1251723584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799272, query id 1167762766 prod-cs4-web-04 172.21.203.34 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '5f03a4cc6ced00fff205daffb4342db9' ) ---TRANSACTION 18297320, ACTIVE 548 sec, process no 24384, OS thread id 1343310144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799271, query id 1167762758 prod-cs4-web-08 172.21.203.38 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 1829731F, ACTIVE 554 sec, process no 24384, OS thread id 1343043904 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799270, query id 1167762754 prod-cs4-web-02 172.21.203.32 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '6e91a62b398c30f878791f539cfaf5f3' ) ---TRANSACTION 1829731E, ACTIVE 559 sec, process no 24384, OS thread id 1263970624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799267, query id 1167762738 prod-cs4-web-11 172.21.203.41 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '5950566421a177ebd8372a1ea531b180' ) ---TRANSACTION 1829731D, ACTIVE 592 sec, process no 24384, OS thread id 1315354944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799263, query id 1167762713 prod-cs4-web-03 172.21.203.33 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'bfdb8c43f713903c1cf0b04e3eb03f98' ) ---TRANSACTION 1829731C, ACTIVE 596 sec, process no 24384, OS thread id 1343842624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799262, query id 1167762710 prod-cs4-web-02 172.21.203.32 clearview statistics SELECT a_session FROM sessions WHERE id = '0a84ce74ea7906d94cd860d5a4b9681d' Trx read view will not see trx with id >= 1829731D, sees < 18297264 ---TRANSACTION 1829731B, ACTIVE 609 sec, process no 24384, OS thread id 1303374144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799261, query id 1167762701 prod-cs4-web-05 172.21.203.35 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '38816122d6f89a0c6b7b731d67f60b4b' ) ---TRANSACTION 1829731A, ACTIVE 610 sec, process no 24384, OS thread id 1254652224 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799260, query id 1167762697 prod-cs4-web-04 172.21.203.34 clearview statistics SELECT a_session FROM sessions WHERE id = '0a84ce74ea7906d94cd860d5a4b9681d' Trx read view will not see trx with id >= 1829731B, sees < 18297264 ---TRANSACTION 18297319, ACTIVE 615 sec, process no 24384, OS thread id 1336121664 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799258, query id 1167762689 prod-cs4-web-03 172.21.203.33 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 18297318, ACTIVE 625 sec, process no 24384, OS thread id 1332128064 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799252, query id 1167762649 prod-cs4-web-11 172.21.203.41 clearview statistics select * from projects where uri_name='_forgot' Trx read view will not see trx with id >= 18297319, sees < 18297264 ---TRANSACTION 18297317, ACTIVE 626 sec, process no 24384, OS thread id 1293523264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799251, query id 1167762646 prod-cs4-web-03 172.21.203.33 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '95414efaf431f422dd0be61d402029e0' ) ---TRANSACTION 18297316, ACTIVE 627 sec, process no 24384, OS thread id 1321478464 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799250, query id 1167762643 prod-cs4-web-08 172.21.203.38 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '95414efaf431f422dd0be61d402029e0' ) ---TRANSACTION 18297315, ACTIVE 640 sec, process no 24384, OS thread id 1327069504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799249, query id 1167762633 prod-cs4-web-06 172.21.203.36 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'bfdb8c43f713903c1cf0b04e3eb03f98' ) ---TRANSACTION 18297314, ACTIVE 646 sec, process no 24384, OS thread id 1265568064 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799248, query id 1167762630 prod-cs4-web-07 172.21.203.37 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '95414efaf431f422dd0be61d402029e0' ) ---TRANSACTION 18297313, ACTIVE 652 sec, process no 24384, OS thread id 1290594624 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799246, query id 1167762620 prod-cs4-web-11 172.21.203.41 clearview statistics SELECT a_session FROM sessions WHERE id = '707ac8466ba4ef7d4fb0046d7a72994c' Trx read view will not see trx with id >= 18297314, sees < 18297264 ---TRANSACTION 18297312, ACTIVE 653 sec, process no 24384, OS thread id 1332394304 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799244, query id 1167762612 prod-cs4-web-09 172.21.203.39 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'bfdb8c43f713903c1cf0b04e3eb03f98' ) ---TRANSACTION 18297311, ACTIVE 664 sec, process no 24384, OS thread id 1325738304 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799243, query id 1167762604 prod-cs4-web-10 172.21.203.40 clearview Sending data select SQL_CALC_FOUND_ROWS users.* from users where (name='sta085@maersk.com') limit 0, 1000000000000 Trx read view will not see trx with id >= 18297312, sees < 18297264 ---TRANSACTION 18297310, ACTIVE 694 sec, process no 24384, OS thread id 1254385984 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799184, query id 1167762428 prod-cs4-web-01 172.21.203.31 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'fa8c5d863ceb04b979feeba8fa4fcb07' ) ---TRANSACTION 1829730F, ACTIVE 696 sec, process no 24384, OS thread id 1327601984 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799183, query id 1167762423 prod-cs4-web-05 172.21.203.35 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='18' Trx read view will not see trx with id >= 18297310, sees < 18297264 ---TRANSACTION 1829730E, ACTIVE 699 sec, process no 24384, OS thread id 1306302784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799163, query id 1167762370 prod-cs4-web-01 172.21.203.31 clearview statistics select * from projects where uri_name='_forgot' Trx read view will not see trx with id >= 1829730F, sees < 18297264 ---TRANSACTION 1829730D, ACTIVE 701 sec, process no 24384, OS thread id 1349699904 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799162, query id 1167762367 prod-cs4-web-02 172.21.203.32 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '5950566421a177ebd8372a1ea531b180' ) ---TRANSACTION 1829730C, ACTIVE 705 sec, process no 24384, OS thread id 1329998144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799161, query id 1167762364 prod-cs4-web-11 172.21.203.41 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'fa8c5d863ceb04b979feeba8fa4fcb07' ) ---TRANSACTION 1829730B, ACTIVE 706 sec, process no 24384, OS thread id 1324140864 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799160, query id 1167762361 prod-cs4-web-10 172.21.203.40 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'a6fc25720b25cf70e35266d0f7cffc0c' ) ---TRANSACTION 1829730A, ACTIVE 709 sec, process no 24384, OS thread id 1272224064 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799159, query id 1167762358 prod-cs4-web-05 172.21.203.35 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '38816122d6f89a0c6b7b731d67f60b4b' ) ---TRANSACTION 18297309, ACTIVE 709 sec, process no 24384, OS thread id 1246931264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799158, query id 1167762355 prod-cs4-web-09 172.21.203.39 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='18' Trx read view will not see trx with id >= 1829730A, sees < 18297264 ---TRANSACTION 18297308, ACTIVE 713 sec, process no 24384, OS thread id 1272490304 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799138, query id 1167762303 prod-cs4-web-01 172.21.203.31 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'a6fc25720b25cf70e35266d0f7cffc0c' ) ---TRANSACTION 18297307, ACTIVE 715 sec, process no 24384, OS thread id 1269827904 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799137, query id 1167762299 prod-cs4-web-04 172.21.203.34 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 18297306, ACTIVE 722 sec, process no 24384, OS thread id 1282341184 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799136, query id 1167762293 prod-cs4-web-07 172.21.203.37 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '303ef62bc291961f4757493833f6e535' ) ---TRANSACTION 18297305, ACTIVE 722 sec, process no 24384, OS thread id 1319881024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799135, query id 1167762290 prod-cs4-web-01 172.21.203.31 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '303ef62bc291961f4757493833f6e535' ) ---TRANSACTION 18297304, ACTIVE 726 sec, process no 24384, OS thread id 1343576384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799134, query id 1167762283 prod-cs4-web-08 172.21.203.38 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '6e91a62b398c30f878791f539cfaf5f3' ) ---TRANSACTION 18297303, ACTIVE 743 sec, process no 24384, OS thread id 1319348544 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799104, query id 1167762187 prod-cs4-web-07 172.21.203.37 clearview statistics SELECT a_session FROM sessions WHERE id = '707ac8466ba4ef7d4fb0046d7a72994c' Trx read view will not see trx with id >= 18297304, sees < 18297264 ---TRANSACTION 18297302, ACTIVE 753 sec, process no 24384, OS thread id 1336654144 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799099, query id 1167762161 prod-cs4-web-06 172.21.203.36 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'bfdb8c43f713903c1cf0b04e3eb03f98' ) ---TRANSACTION 18297301, ACTIVE 760 sec, process no 24384, OS thread id 1307367744 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799098, query id 1167762156 prod-cs4-web-02 172.21.203.32 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'bfdb8c43f713903c1cf0b04e3eb03f98' ) ---TRANSACTION 18297300, ACTIVE 786 sec, process no 24384, OS thread id 1323075904 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799095, query id 1167762132 prod-cs4-web-06 172.21.203.36 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '95414efaf431f422dd0be61d402029e0' ) ---TRANSACTION 182972FF, ACTIVE 798 sec, process no 24384, OS thread id 1243203904 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799094, query id 1167762129 prod-cs4-web-10 172.21.203.40 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '6e91a62b398c30f878791f539cfaf5f3' ) ---TRANSACTION 182972FE, ACTIVE 799 sec, process no 24384, OS thread id 1261840704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799093, query id 1167762126 prod-cs4-web-02 172.21.203.32 clearview statistics select * from projects where uri_name='_forgot' Trx read view will not see trx with id >= 182972FF, sees < 18297264 ---TRANSACTION 182972FD, ACTIVE 800 sec, process no 24384, OS thread id 1333193024 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799091, query id 1167762107 prod-cs4-web-05 172.21.203.35 clearview Sending data select project from projects where package_name='Buyer_Enablement' and customer_host='18' Trx read view will not see trx with id >= 182972FE, sees < 18297264 ---TRANSACTION 182972FC, ACTIVE 803 sec, process no 24384, OS thread id 1295120704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799068, query id 1167762039 prod-cs4-web-09 172.21.203.39 clearview statistics SELECT a_session FROM sessions WHERE id = '707ac8466ba4ef7d4fb0046d7a72994c' Trx read view will not see trx with id >= 182972FD, sees < 18297264 ---TRANSACTION 182972FB, ACTIVE 807 sec, process no 24384, OS thread id 1280477504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799038, query id 1167761945 prod-cs4-web-01 172.21.203.31 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'a6fc25720b25cf70e35266d0f7cffc0c' ) ---TRANSACTION 182972FA, ACTIVE 814 sec, process no 24384, OS thread id 1344641344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799037, query id 1167761939 prod-cs4-web-05 172.21.203.35 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '38816122d6f89a0c6b7b731d67f60b4b' ) ---TRANSACTION 182972F9, ACTIVE 823 sec, process no 24384, OS thread id 1305237824 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799036, query id 1167761934 prod-cs4-web-04 172.21.203.34 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 182972F8, ACTIVE 823 sec, process no 24384, OS thread id 1300977984 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799035, query id 1167761931 prod-cs4-web-05 172.21.203.35 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 182972F7, ACTIVE 823 sec, process no 24384, OS thread id 1245600064 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799034, query id 1167761928 prod-cs4-web-02 172.21.203.32 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 182972F6, ACTIVE 825 sec, process no 24384, OS thread id 1324939584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799033, query id 1167761925 prod-cs4-web-10 172.21.203.40 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'a8086d37966d27a724386d33c36beed6' ) ---TRANSACTION 182972F5, ACTIVE 837 sec, process no 24384, OS thread id 1331329344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799032, query id 1167761919 prod-cs4-web-09 172.21.203.39 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '5f03a4cc6ced00fff205daffb4342db9' ) ---TRANSACTION 182972F4, ACTIVE 850 sec, process no 24384, OS thread id 1299114304 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799029, query id 1167761900 prod-cs4-web-01 172.21.203.31 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'bfdb8c43f713903c1cf0b04e3eb03f98' ) ---TRANSACTION 182972F3, ACTIVE 860 sec, process no 24384, OS thread id 1311361344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799028, query id 1167761897 prod-cs4-web-08 172.21.203.38 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'bfdb8c43f713903c1cf0b04e3eb03f98' ) ---TRANSACTION 182972F2, ACTIVE 863 sec, process no 24384, OS thread id 1344907584 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 13799027, query id 1167761891 prod-cs4-web-07 172.21.203.37 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '6e91a62b398c30f878791f539cfaf5f3' ) ---TRANSACTION 182972F1, ACTIVE 871 sec, process no 24384, OS thread id 1283672384 fetching rows, thread declared inside InnoDB 491 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1248, 513 row lock(s) MySQL thread id 13799026, query id 1167761885 prod-cs4-web-06 172.21.203.36 clearview updating delete from tickets where user_id = '56188' ---TRANSACTION 182972ED, ACTIVE 883 sec, process no 24384, OS thread id 1254119744 updating or deleting, thread declared inside InnoDB 499 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 13798995, query id 1167761780 prod-cs4-web-11 172.21.203.41 clearview Updating UPDATE tickets SET ts = '1328697286' WHERE ( ticket_hash = 'fa8c5d863ceb04b979feeba8fa4fcb07' ) ---TRANSACTION 182972EB, ACTIVE 886 sec, process no 24384, OS thread id 1321212224 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 13798994, query id 1167761775 prod-cs4-web-10 172.21.203.40 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '95414efaf431f422dd0be61d402029e0' ) ---TRANSACTION 182972EA, ACTIVE 896 sec, process no 24384, OS thread id 1337719104 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 13798993, query id 1167761768 prod-cs4-web-09 172.21.203.39 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 182972E9, ACTIVE 900 sec, process no 24384, OS thread id 1287399744 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 13798992, query id 1167761764 prod-cs4-web-07 172.21.203.37 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '95414efaf431f422dd0be61d402029e0' ) ---TRANSACTION 182972E8, ACTIVE 904 sec, process no 24384, OS thread id 1314822464 updating or deleting, thread declared inside InnoDB 499 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 13798991, query id 1167761760 prod-cs4-web-06 172.21.203.36 clearview Updating UPDATE tickets SET ts = '1328697265' WHERE ( ticket_hash = '38816122d6f89a0c6b7b731d67f60b4b' ) ---TRANSACTION 182972E6, ACTIVE 910 sec, process no 24384, OS thread id 1297516864 updating or deleting, thread declared inside InnoDB 499 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 13798990, query id 1167761753 prod-cs4-web-05 172.21.203.35 clearview Updating UPDATE tickets SET ts = '1328697259' WHERE ( ticket_hash = 'c3330134dbf67fb784613b9d67f3aa31' ) ---TRANSACTION 182972E4, ACTIVE 913 sec, process no 24384, OS thread id 1330796864 updating or deleting, thread declared inside InnoDB 499 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 13798989, query id 1167761748 prod-cs4-web-05 172.21.203.35 clearview Updating UPDATE tickets SET ts = '1328697256' WHERE ( ticket_hash = 'aa7b32640b070878ff431437f62f835f' ) ---TRANSACTION 182972E2, ACTIVE 918 sec, process no 24384, OS thread id 1310296384 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 13798988, query id 1167761743 prod-cs4-web-04 172.21.203.34 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '5f03a4cc6ced00fff205daffb4342db9' ) ---TRANSACTION 182972E1, ACTIVE 924 sec, process no 24384, OS thread id 1262639424 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 MySQL thread id 13798987, query id 1167761736 prod-cs4-web-04 172.21.203.34 clearview Updating UPDATE tickets SET ts = '1328697245' WHERE ( ticket_hash = '4183cc1527dbbcb20097f3271781f3ea' ) ---TRANSACTION 182972E0, ACTIVE 927 sec, process no 24384, OS thread id 1288997184 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 13798984, query id 1167761718 prod-cs4-web-03 172.21.203.33 clearview statistics SELECT ticket_hash, ts FROM tickets WHERE ( ticket_hash = '95414efaf431f422dd0be61d402029e0' ) ---TRANSACTION 182972DD, ACTIVE 928 sec, process no 24384, OS thread id 1328400704 updating or deleting, thread declared inside InnoDB 499 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 13798982, query id 1167761712 prod-cs4-web-03 172.21.203.33 clearview Updating UPDATE tickets SET ts = '1328697241' WHERE ( ticket_hash = '95414efaf431f422dd0be61d402029e0' ) ---TRANSACTION 182972DB, ACTIVE 929 sec, process no 24384, OS thread id 1248794944 updating or deleting, thread declared inside InnoDB 499 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 13798979, query id 1167761691 prod-cs4-web-02 172.21.203.32 clearview Updating UPDATE tickets SET ts = '1328697240' WHERE ( ticket_hash = '5950566421a177ebd8372a1ea531b180' ) ---TRANSACTION 182972D9, ACTIVE 929 sec, process no 24384, OS thread id 1314556224 fetching rows, thread declared inside InnoDB 499 mysql tables in use 2, locked 0 MySQL thread id 13798976, query id 1167761686 prod-cs4-web-08 172.21.203.38 clearview Sending data select event_state from event_timelines left join event_timeline_suppliers using (event_timeline) where start_date <= now() and end_date > now() and event_timelines.suspended = 0 and (event_timelines.restricted_by_supplier = 0 or event_timeline_suppliers.supplier = 10) Trx read view will not see trx with id >= 182972DA, sees < 18297264 ---TRANSACTION 182972D7, ACTIVE 933 sec, process no 24384, OS thread id 1277815104 updating or deleting, thread declared inside InnoDB 499 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 13798977, query id 1167761648 prod-cs4-web-11 172.21.203.41 clearview Updating UPDATE tickets SET ts = '1328697236' WHERE ( ticket_hash = '4183cc1527dbbcb20097f3271781f3ea' ) ---TRANSACTION 18297264, ACTIVE 935 sec, process no 24384, OS thread id 1255717184, thread declared inside InnoDB 36 mysql tables in use 4, locked 0 , holds adaptive hash latch MySQL thread id 13798964, query id 1167759874 prod-cs4-web-10 172.21.203.40 clearview Copying to tmp table on disk SELECT SQL_CALC_FOUND_ROWS bids.bid as column_0_0, items.item as column_1_0, suppliers.name as column_2_0, items.name as column_15_0, items.quantity as column_16_0, items.average_historic_price as column_17_0, 'EUR' as column_17_1, items.attribute35_value as column_18_0, packages.name as column_61_0, packages.package as column_61_1, packages.supplier as column_61_2, ((((bids.price) * 1.00)) * 1.00) as column_62_0, bids.bid_round as column_63_0, bids.approval as column_64_0, bids.bid as column_65_0, if(((items.average_historic_price) * 1.00) is not null and (((((( Trx read view will not see trx with id >= 18297265, sees < 18297265 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 265287417 OS file reads, 97782401 OS file writes, 89690391 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 213, seg size 215, 378702 inserts, 378702 merged recs, 35852 merges Hash table size 50999503, node heap has 26033 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 1244237893032 Log flushed up to 1244237890465 Last checkpoint at 1244237741842 0 pending log writes, 0 pending chkp writes 81210090 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26361200640; in additional pool allocated 0 Dictionary memory allocated 3503533144 Buffer pool size 1572863 Free buffers 1 Database pages 1546829 Old database pages 570977 Modified db pages 56 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 349774895, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 339270665, created 15802811, written 28667232 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 LRU len: 1546829, unzip_LRU len: 0 I/O sum[18446744073709551600]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 16 queries inside InnoDB, 110 queries in queue 42 read views open inside InnoDB Main thread process no. 24384, id 1210669376, state: flushing buffer pool pages Number of rows inserted 1236321682, updated 59952485, deleted 53454901, read 185186503474 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 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. 120208 5:49:49 InnoDB: Assertion failure in thread 1231649088 in file srv/srv0srv.c line 2293 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.1/en/forcing-recovery.html InnoDB: about forcing recovery. 120208 5:49:49 - 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=67108864 read_buffer_size=8388608 max_used_connections=402 max_threads=1024 threads_connected=163 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 25241904 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 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 = (nil) thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x850fce] /usr/sbin/mysqld(handle_segfault+0x322)[0x5c2622] /lib64/libpthread.so.0[0x3a5520e7c0] /lib64/libc.so.6(gsignal+0x35)[0x3a54a30265] /lib64/libc.so.6(abort+0x110)[0x3a54a31d10] /usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaac2db7235] /lib64/libpthread.so.0[0x3a552064a7] /lib64/libc.so.6(clone+0x6d)[0x3a54ad3c2d] 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. 120208 05:50:02 mysqld_safe Number of processes running now: 0 120208 05:50:02 mysqld_safe mysqld restarted 120208 5:50:02 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Compressed tables use zlib 1.2.3 120208 5:50:04 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 1244237741842 120208 5:50:04 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... 120208 5:50:04 InnoDB: Warning: allocated tablespace 2122120, old maximum was 0 InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 1244237890465 InnoDB: 3 transaction(s) which must be rolled back or cleaned up InnoDB: in total 3 row operations to undo InnoDB: Trx id counter is 18297400 120208 6:14:58 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 835006373, file name /mysqllogs/binary/prod-asap-db1-bin.000176 InnoDB: Starting in background the rollback of uncommitted transactions 120208 6:15:34 InnoDB: Rolling back trx with id 182972DD, 1 rows to undo 120208 6:15:34 InnoDB Plugin 1.0.9 started; log sequence number 1244237890465 120208 6:15:34 [Note] Recovering after a crash using /mysqllogs/binary/prod-asap-db1-bin InnoDB: Rolling back of trx id 182972DD completed 120208 6:15:34 InnoDB: Rolling back trx with id 182972DB, 1 rows to undo InnoDB: Rolling back of trx id 182972DB completed 120208 6:15:34 InnoDB: Rolling back trx with id 182972D7, 1 rows to undo InnoDB: Rolling back of trx id 182972D7 completed 120208 6:15:34 InnoDB: Rollback of non-prepared transactions completed 120208 6:15:40 [Note] Starting crash recovery... 120208 6:15:40 [Note] Crash recovery finished. 120208 6:15:42 [Note] Slave SQL thread initialized, starting replication in log 'prod-asap-db2-bin.000175' at position 217673793, relay log '/mysqllogs/relay/prod-cs3-db2-relay-bin.000181' position: 699009 120208 6:15:42 [Note] Event Scheduler: Loaded 0 events 120208 6:15:42 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.48-community-log' socket: '/tmp/mysql.sock' port: 3036 MySQL Community Server (GPL) 120208 6:15:42 [Note] Slave I/O thread: connected to master 'repl@prod-asap-db2-priv:3036',replication started in log 'prod-asap-db2-bin.000175' at position 275496759 resumption of normal operations no other significant information.