Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.37
Description
----------
|
SEMAPHORES
|
----------
|
OS WAIT ARRAY INFO: reservation count 7623526, signal count 6607379
|
--Thread 140384207705856 has waited at buf0buf.ic line 376 for 935.00 seconds the semaphore:
|
Mutex at 0x7f7fe7fd3e30 '(null)', lock var 1
|
waiters flag 0
|
wait has ended
|
--Thread 140384462853888 has waited at row0row.c line 716 for 935.00 seconds the semaphore:
|
S-lock on RW-latch at 0x7f82d8aa5490 '&block->lock'
|
a writer (thread id 140384208004864) 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 2965
|
Last time write locked in file /home/skysql/bzr/maria/5.5.37/storage/xtradb/row/row0ins.c line 2039
|
--Thread 140384207705856 has waited at row0row.c line 716 for 935.00 seconds the semaphore:
|
S-lock on RW-latch at 0x7f82d8aa5490 '&block->lock'
|
a writer (thread id 140384208004864) has reserved it in mode exclusive
|
InnoDB: signal 12 (User defined signal 2), address is 0x1f200002ed5 from 0xa9590c
|
number of readers 0, waiters flag 1, lock_word: 0
|
Last time read locked in file row0sel.c line 2965
|
Last time write locked in file /home/skysql/bzr/maria/5.5.37/storage/xtradb/row/row0ins.c line 2039
|
--Thread 140184846841600 has waited at buf0flu.c line 1357 for 882.00 seconds the semaphore:
|
S-lock on RW-latch at 0x7f82d8aa5490 '&block->lock'
|
a writer (thread id 140384208004864) 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 2965
|
Last time write locked in file /home/skysql/bzr/maria/5.5.37/storage/xtradb/row/row0ins.c line 2039
|
--Thread 140384208303872 has waited at row0ins.c line 2039 for 814.00 seconds the semaphore:
|
X-lock on RW-latch at 0x7f82d8aa5490 '&block->lock'
|
a writer (thread id 140384208004864) 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 2965
|
Last time write locked in file /home/skysql/bzr/maria/5.5.37/storage/xtradb/row/row0ins.c line 2039
|
--Thread 140384483469056 has waited at btr0cur.c line 570 for 730.00 seconds the semaphore:
|
X-lock (wait_ex) on RW-latch at 0x7f7f82baed88 '&new_index->lock'
|
a writer (thread id 140384483469056) has reserved it in mode wait exclusive
|
number of readers 3, waiters flag 0, lock_word: fffffffffffffffd
|
Last time read locked in file btr0cur.c line 577
|
Last time write locked in file /home/skysql/bzr/maria/5.5.37/storage/xtradb/btr/btr0cur.c line 570
|
Mutex spin waits 26927131, rounds 204282872, OS waits 5770813
|
RW-shared spins 3517512, rounds 50116295, OS waits 1240021
|
RW-excl spins 2246818, rounds 28331225, OS waits 534830
|
Spin rounds per wait: 7.59 mutex, 14.25 RW-shared, 12.61 RW-excl
|
Stack trace:
InnoDB: Stacktrace for Thread 140384208004864
|
InnoDB: [bt]: (1) /usr/sbin/mysqld(my_pthread_fastmutex_lock+0x6c) [0xa9590c]
|
InnoDB: [bt]: (2) /usr/sbin/mysqld(my_pthread_fastmutex_lock+0x6c) [0xa9590c]
|
InnoDB: [bt]: (3) /usr/sbin/mysqld() [0x9c804d]
|
InnoDB: [bt]: (4) /usr/sbin/mysqld() [0x8ffdff]
|
InnoDB: [bt]: (5) /usr/sbin/mysqld() [0x90132b]
|
InnoDB: [bt]: (6) /usr/sbin/mysqld() [0x94e68e]
|
InnoDB: [bt]: (7) /usr/sbin/mysqld() [0x9529fa]
|
InnoDB: [bt]: (8) /usr/sbin/mysqld() [0x9530d4]
|
InnoDB: [bt]: (9) /usr/sbin/mysqld() [0x9411be]
|
InnoDB: [bt]: (10) /usr/sbin/mysqld() [0x93d5ff]
|
InnoDB: [bt]: (11) /usr/sbin/mysqld() [0x93d88d]
|
InnoDB: [bt]: (12) /usr/sbin/mysqld() [0x931f03]
|
InnoDB: [bt]: (13) /usr/sbin/mysqld() [0x9e4e7d]
|
InnoDB: [bt]: (14) /usr/sbin/mysqld() [0x9e6f8f]
|
InnoDB: [bt]: (15) /usr/sbin/mysqld() [0x8dd3e6]
|
InnoDB: [bt]: (16) /usr/sbin/mysqld() [0x8c582e]
|
InnoDB: [bt]: (17) /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPh+0xb4) [0x6da2a4]
|
InnoDB: [bt]: (18) /usr/sbin/mysqld() [0xa6bdd1]
|
InnoDB: [bt]: (19) /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPh+0xb4) [0x6da2a4]
|
InnoDB: [bt]: (20) /usr/sbin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0x61) [0x5715e1]
|
InnoDB: [bt]: (21) /usr/sbin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x967) [0x5794c7]
|
InnoDB: [bt]: (22) /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3509) [0x58e609]
|
InnoDB: [bt]: (23) /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x299) [0x590f49]
|
InnoDB: [bt]: (24) /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x14cc) [0x5924dc]
|
InnoDB: [bt]: (25) /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x3ef) [0x64e1ff]
|
InnoDB: [bt]: (26) /usr/sbin/mysqld(handle_one_connection+0x4c) [0x64e29c]
|
InnoDB: [bt]: (27) /lib64/libpthread.so.0() [0x3d460079d1]
|
InnoDB: [bt]: (28) /lib64/libc.so.6(clone+0x6d) [0x3d458e8b5d]
|
InnoDB: signal 12 (User defined signal 2), address is 0x1f200002ed5 from 0xa9590c
|
InnoDB: Stacktrace for Thread 140384462853888
|
InnoDB: [bt]: (1) /lib64/libpthread.so.0(pthread_cond_wait+0xca) [0x3d4600b5ba]
|
InnoDB: [bt]: (2) /lib64/libpthread.so.0(pthread_cond_wait+0xca) [0x3d4600b5ba]
|
InnoDB: [bt]: (3) /usr/sbin/mysqld() [0x9c8281]
|
InnoDB: [bt]: (4) /usr/sbin/mysqld() [0x9000ef]
|
InnoDB: [bt]: (5) /usr/sbin/mysqld() [0x900398]
|
InnoDB: [bt]: (6) /usr/sbin/mysqld() [0x946eb2]
|
InnoDB: [bt]: (7) /usr/sbin/mysqld() [0x9340ce]
|
InnoDB: [bt]: (8) /usr/sbin/mysqld() [0x8e5ba0]
|
InnoDB: [bt]: (9) /usr/sbin/mysqld() [0x8f4515]
|
InnoDB: [bt]: (10) /usr/sbin/mysqld() [0x9a84f4]
|
InnoDB: [bt]: (11) /usr/sbin/mysqld() [0x9a9f92]
|
InnoDB: [bt]: (12) /usr/sbin/mysqld() [0x8e6667]
|
InnoDB: [bt]: (13) /usr/sbin/mysqld() [0x8e9bdc]
|
InnoDB: [bt]: (14) /usr/sbin/mysqld() [0x8c0fcc]
|
InnoDB: [bt]: (15) /usr/sbin/mysqld(_ZN7handler16read_range_firstEPK12st_key_rangeS2_bb+0xfd) [0x6d953d]
|
InnoDB: [bt]: (16) /usr/sbin/mysqld() [0xa658e1]
|
InnoDB: [bt]: (17) /usr/sbin/mysqld(_ZN7handler21multi_range_read_nextEPPv+0x85) [0x67ac25]
|
InnoDB: [bt]: (18) /usr/sbin/mysqld(_ZN18QUICK_RANGE_SELECT8get_nextEv+0x52) [0x7b5052]
|
InnoDB: [bt]: (19) /usr/sbin/mysqld() [0x7d7408]
|
InnoDB: [bt]: (20) /usr/sbin/mysqld(_Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_ordery15enum_duplicatesbPySB_+0x8fd) [0x617bbd]
|
InnoDB: [bt]: (21) /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x36b5) [0x58e7b5]
|
InnoDB: [bt]: (22) /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x299) [0x590f49]
|
InnoDB: [bt]: (23) /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x14cc) [0x5924dc]
|
InnoDB: [bt]: (24) /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x3ef) [0x64e1ff]
|
InnoDB: [bt]: (25) /usr/sbin/mysqld(handle_one_connection+0x4c) [0x64e29c]
|
InnoDB: [bt]: (26) /lib64/libpthread.so.0() [0x3d460079d1]
|
InnoDB: [bt]: (27) /lib64/libc.so.6(clone+0x6d) [0x3d458e8b5d]
|
InnoDB: Stacktrace for Thread 140384208303872
|
InnoDB: [bt]: (1) /lib64/libpthread.so.0(pthread_cond_wait+0xca) [0x3d4600b5ba]
|
InnoDB: [bt]: (2) /lib64/libpthread.so.0(pthread_cond_wait+0xca) [0x3d4600b5ba]
|
InnoDB: [bt]: (3) /usr/sbin/mysqld() [0x9c8281]
|
InnoDB: [bt]: (4) /usr/sbin/mysqld() [0x9000ef]
|
InnoDB: [bt]: (5) /usr/sbin/mysqld() [0x900c19]
|
InnoDB: [bt]: (6) /usr/sbin/mysqld() [0x9477dd]
|
InnoDB: [bt]: (7) /usr/sbin/mysqld() [0x9340ce]
|
InnoDB: [bt]: (8) /usr/sbin/mysqld() [0x9e4b85]
|
InnoDB: [bt]: (9) /usr/sbin/mysqld() [0x9e6f8f]
|
InnoDB: [bt]: (10) /usr/sbin/mysqld() [0x8dd3e6]
|
InnoDB: [bt]: (11) /usr/sbin/mysqld() [0x8c582e]
|
InnoDB: [bt]: (12) /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPh+0xb4) [0x6da2a4]
|
InnoDB: [bt]: (13) /usr/sbin/mysqld() [0xa6bdd1]
|
InnoDB: [bt]: (14) /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPh+0xb4) [0x6da2a4]
|
InnoDB: [bt]: (15) /usr/sbin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0x61) [0x5715e1]
|
InnoDB: [bt]: (16) /usr/sbin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x967) [0x5794c7]
|
InnoDB: [bt]: (17) /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3509) [0x58e609]
|
InnoDB: [bt]: (18) /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x299) [0x590f49]
|
InnoDB: [bt]: (19) /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x14cc) [0x5924dc]
|
InnoDB: [bt]: (20) /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x3ef) [0x64e1ff]
|
InnoDB: [bt]: (21) /usr/sbin/mysqld(handle_one_connection+0x4c) [0x64e29c]
|
InnoDB: [bt]: (22) /lib64/libpthread.so.0() [0x3d460079d1]
|
InnoDB: [bt]: (23) /lib64/libc.so.6(clone+0x6d) [0x3d458e8b5d]
|
InnoDB: Stacktrace for Thread 140384483469056
|
InnoDB: [bt]: (1) /lib64/libpthread.so.0(pthread_cond_wait+0xca) [0x3d4600b5ba]
|
InnoDB: [bt]: (2) /lib64/libpthread.so.0(pthread_cond_wait+0xca) [0x3d4600b5ba]
|
InnoDB: [bt]: (3) /usr/sbin/mysqld() [0x9c8281]
|
InnoDB: [bt]: (4) /usr/sbin/mysqld() [0x9000ef]
|
InnoDB: [bt]: (5) /usr/sbin/mysqld() [0x900b15]
|
InnoDB: [bt]: (6) /usr/sbin/mysqld() [0x934bc9]
|
InnoDB: [bt]: (7) /usr/sbin/mysqld() [0x9e4b85]
|
InnoDB: [bt]: (8) /usr/sbin/mysqld() [0x9e7009]
|
InnoDB: [bt]: (9) /usr/sbin/mysqld() [0x8dd3e6]
|
InnoDB: [bt]: (10) /usr/sbin/mysqld() [0x8c582e]
|
InnoDB: [bt]: (11) /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPh+0xb4) [0x6da2a4]
|
InnoDB: [bt]: (12) /usr/sbin/mysqld() [0xa6bdd1]
|
InnoDB: [bt]: (13) /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPh+0xb4) [0x6da2a4]
|
InnoDB: [bt]: (14) /usr/sbin/mysqld(_ZN14Rows_log_event9write_rowEPK14Relay_log_infob+0x118) [0x79ae28]
|
InnoDB: [bt]: (15) /usr/sbin/mysqld(_ZN20Write_rows_log_event11do_exec_rowEPK14Relay_log_info+0x22) [0x79b202]
|
InnoDB: [bt]: (16) /usr/sbin/mysqld(_ZN14Rows_log_event14do_apply_eventEPK14Relay_log_info+0x277) [0x7a7407]
|
InnoDB: [bt]: (17) /usr/sbin/mysqld(_Z26apply_event_and_update_posP9Log_eventP3THDP14Relay_log_info+0x155) [0x51d7e5]
|
InnoDB: [bt]: (18) /usr/sbin/mysqld() [0x5247f6]
|
InnoDB: [bt]: (19) /usr/sbin/mysqld(handle_slave_sql+0x8eb) [0x525c9b]
|
InnoDB: [bt]: (20) /lib64/libpthread.so.0() [0x3d460079d1]
|
InnoDB: [bt]: (21) /lib64/libc.so.6(clone+0x6d) [0x3d458e8b5d]
|
InnoDB: Stacktrace for Thread 140384208004864
|
InnoDB: [bt]: (1) /usr/sbin/mysqld(my_pthread_fastmutex_lock+0x6c) [0xa9590c]
|
InnoDB: [bt]: (2) /usr/sbin/mysqld(my_pthread_fastmutex_lock+0x6c) [0xa9590c]
|
InnoDB: [bt]: (3) /usr/sbin/mysqld() [0x9c804d]
|
InnoDB: [bt]: (4) /usr/sbin/mysqld() [0x8ffdff]
|
InnoDB: [bt]: (5) /usr/sbin/mysqld() [0x90132b]
|
InnoDB: [bt]: (6) /usr/sbin/mysqld() [0x94e68e]
|
InnoDB: [bt]: (7) /usr/sbin/mysqld() [0x9529fa]
|
InnoDB: [bt]: (8) /usr/sbin/mysqld() [0x9530d4]
|
InnoDB: [bt]: (9) /usr/sbin/mysqld() [0x9411be]
|
InnoDB: [bt]: (10) /usr/sbin/mysqld() [0x93d5ff]
|
InnoDB: [bt]: (11) /usr/sbin/mysqld() [0x93d88d]
|
InnoDB: [bt]: (12) /usr/sbin/mysqld() [0x931f03]
|
InnoDB: [bt]: (13) /usr/sbin/mysqld() [0x9e4e7d]
|
InnoDB: [bt]: (14) /usr/sbin/mysqld() [0x9e6f8f]
|
InnoDB: [bt]: (15) /usr/sbin/mysqld() [0x8dd3e6]
|
InnoDB: [bt]: (16) /usr/sbin/mysqld() [0x8c582e]
|
InnoDB: [bt]: (17) /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPh+0xb4) [0x6da2a4]
|
InnoDB: [bt]: (18) /usr/sbin/mysqld() [0xa6bdd1]
|
InnoDB: [bt]: (19) /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPh+0xb4) [0x6da2a4]
|
InnoDB: [bt]: (20) /usr/sbin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0x61) [0x5715e1]
|
InnoDB: [bt]: (21) /usr/sbin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x967) [0x5794c7]
|
InnoDB: [bt]: (22) /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3509) [0x58e609]
|
InnoDB: [bt]: (23) /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x299) [0x590f49]
|
InnoDB: [bt]: (24) /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x14cc) [0x5924dc]
|
InnoDB: [bt]: (25) /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x3ef) [0x64e1ff]
|
InnoDB: [bt]: (26) /usr/sbin/mysqld(handle_one_connection+0x4c) [0x64e29c]
|
InnoDB: [bt]: (27) /lib64/libpthread.so.0() [0x3d460079d1]
|
InnoDB: [bt]: (28) /lib64/libc.so.6(clone+0x6d) [0x3d458e8b5d]
|
InnoDB: Stacktrace for Thread 140384207705856
|
InnoDB: [bt]: (1) /lib64/libpthread.so.0(pthread_cond_wait+0xca) [0x3d4600b5ba]
|
InnoDB: [bt]: (2) /lib64/libpthread.so.0(pthread_cond_wait+0xca) [0x3d4600b5ba]
|
InnoDB: [bt]: (3) /usr/sbin/mysqld() [0x9c8281]
|
InnoDB: [bt]: (4) /usr/sbin/mysqld() [0x9000ef]
|
InnoDB: [bt]: (5) /usr/sbin/mysqld() [0x900398]
|
InnoDB: [bt]: (6) /usr/sbin/mysqld() [0x946eb2]
|
InnoDB: [bt]: (7) /usr/sbin/mysqld() [0x9340ce]
|
InnoDB: [bt]: (8) /usr/sbin/mysqld() [0x8e5ba0]
|
InnoDB: [bt]: (9) /usr/sbin/mysqld() [0x8f4515]
|
InnoDB: [bt]: (10) /usr/sbin/mysqld() [0x9a84f4]
|
InnoDB: [bt]: (11) /usr/sbin/mysqld() [0x9a9f92]
|
InnoDB: [bt]: (12) /usr/sbin/mysqld() [0x8e6667]
|
InnoDB: [bt]: (13) /usr/sbin/mysqld() [0x8e9bdc]
|
InnoDB: [bt]: (14) /usr/sbin/mysqld() [0x8c0fcc]
|
InnoDB: [bt]: (15) /usr/sbin/mysqld(_ZN7handler16read_range_firstEPK12st_key_rangeS2_bb+0xfd) [0x6d953d]
|
InnoDB: [bt]: (16) /usr/sbin/mysqld() [0xa658e1]
|
InnoDB: [bt]: (17) /usr/sbin/mysqld(_ZN7handler21multi_range_read_nextEPPv+0x85) [0x67ac25]
|
InnoDB: [bt]: (18) /usr/sbin/mysqld(_ZN18QUICK_RANGE_SELECT8get_nextEv+0x52) [0x7b5052]
|
InnoDB: [bt]: (19) /usr/sbin/mysqld() [0x7d7408]
|
InnoDB: [bt]: (20) /usr/sbin/mysqld(_Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_ordery15enum_duplicatesbPySB_+0x8fd) [0x617bbd]
|
InnoDB: [bt]: (21) /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x36b5) [0x58e7b5]
|
InnoDB: [bt]: (22) /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x299) [0x590f49]
|
InnoDB: [bt]: (23) /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x14cc) [0x5924dc]
|
InnoDB: [bt]: (24) /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x3ef) [0x64e1ff]
|
InnoDB: [bt]: (25) /usr/sbin/mysqld(handle_one_connection+0x4c) [0x64e29c]
|
InnoDB: [bt]: (26) /lib64/libpthread.so.0() [0x3d460079d1]
|
InnoDB: [bt]: (27) /lib64/libc.so.6(clone+0x6d) [0x3d458e8b5d]
|
InnoDB: Stacktrace for Thread 140184846841600
|
InnoDB: [bt]: (1) /lib64/libpthread.so.0(pthread_cond_wait+0xca) [0x3d4600b5ba]
|
InnoDB: [bt]: (2) /lib64/libpthread.so.0(pthread_cond_wait+0xca) [0x3d4600b5ba]
|
InnoDB: [bt]: (3) /usr/sbin/mysqld() [0x9c8281]
|
InnoDB: [bt]: (4) /usr/sbin/mysqld() [0x9000ef]
|
InnoDB: [bt]: (5) /usr/sbin/mysqld() [0x900398]
|
InnoDB: [bt]: (6) /usr/sbin/mysqld() [0x949eae]
|
InnoDB: [bt]: (7) /usr/sbin/mysqld() [0x94d223]
|
InnoDB: [bt]: (8) /usr/sbin/mysqld() [0x94daa2]
|
InnoDB: [bt]: (9) /usr/sbin/mysqld() [0x94dd20]
|
InnoDB: [bt]: (10) /usr/sbin/mysqld() [0x8f78f8]
|
InnoDB: [bt]: (11) /lib64/libpthread.so.0() [0x3d460079d1]
|
InnoDB: [bt]: (12) /lib64/libc.so.6(clone+0x6d) [0x3d458e8b5d]
|
Transactions:
------------
|
TRANSACTIONS
|
------------
|
Trx id counter 5FF1906
|
Purge done for trx's n:o < 5FF17E5 undo n:o < 0
|
History list length 38
|
LIST OF TRANSACTIONS FOR EACH SESSION:
|
---TRANSACTION 5FF18C2, not started
|
MySQL thread id 8093, OS thread handle 0x7f821f924700, query id 152140508 172.25.20.23 argus
|
---TRANSACTION 5FF169E, not started
|
MySQL thread id 8088, OS thread handle 0x7f821f892700, query id 152140419 172.25.20.23 argus
|
---TRANSACTION 5FF1905, not started
|
MySQL thread id 8087, OS thread handle 0x7fadbed08700, query id 152140723 172.25.20.23 argus
|
---TRANSACTION 5FF18A6, not started
|
MySQL thread id 8086, OS thread handle 0x7fadce137700, query id 152140437 172.25.20.23 argus
|
---TRANSACTION 5FF18B9, not started
|
MySQL thread id 8081, OS thread handle 0x7fadce05c700, query id 152140599 172.25.20.24 argus
|
---TRANSACTION 5FF154D, not started
|
MySQL thread id 8059, OS thread handle 0x7f821f9ff700, query id 152140422 172.25.20.23 argus
|
---TRANSACTION 5FF169F, not started
|
MySQL thread id 8051, OS thread handle 0x7fadbecbf700, query id 152140420 172.25.20.23 argus
|
---TRANSACTION 5FF18B8, not started
|
MySQL thread id 8014, OS thread handle 0x7fadbec76700, query id 152140598 172.25.20.24 argus
|
---TRANSACTION 5FF18F0, not started
|
MySQL thread id 8015, OS thread handle 0x7f821f849700, query id 152140692 172.25.20.24 argus
|
---TRANSACTION 5FF18A4, not started
|
MySQL thread id 7932, OS thread handle 0x7f802efac700, query id 152140435 172.25.20.23 argus
|
---TRANSACTION 5FF18ED, not started
|
MySQL thread id 7861, OS thread handle 0x7fadce0ee700, query id 152140687 172.25.20.24 argus
|
---TRANSACTION 5FF1904, not started
|
MySQL thread id 7736, OS thread handle 0x7f821f9b6700, query id 152140722 172.25.20.23 argus
|
---TRANSACTION 5FF1698, not started
|
MySQL thread id 7535, OS thread handle 0x7fadbeebe700, query id 152140421 172.25.20.23 argus
|
---TRANSACTION 5FF1900, not started
|
MySQL thread id 7533, OS thread handle 0x7f821f96d700, query id 152140718 172.25.20.24 argus
|
---TRANSACTION 5FF1902, ACTIVE 1 sec
|
MySQL thread id 8091, OS thread handle 0x7fadcd95f700, query id 152140720 172.25.20.24 argus
|
---TRANSACTION 5FF151E, ACTIVE 730 sec inserting
|
mysql tables in use 23, locked 23
|
2 lock struct(s), heap size 376, 7 row lock(s), undo log entries 14
|
MySQL thread id 2, OS thread handle 0x7fadcf44e700, query id 152137840
|
TABLE LOCK table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF151E lock mode IX
|
RECORD LOCKS space id 1744 page no 2612831 n bits 168 index `PRIMARY` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF151E lock_mode X locks rec but not gap
|
---TRANSACTION 5FF13C5, ACTIVE 936 sec starting index read, thread declared inside InnoDB 500
|
mysql tables in use 23, locked 23
|
36 lock struct(s), heap size 6960, 87 row lock(s), undo log entries 83
|
MySQL thread id 145, OS thread handle 0x7fadce0a5700, query id 152106074 172.25.1.15 argus Updating
|
UPDATE stats_data SET value1=value1+5 WHERE stat_id=2 AND starttime=1407398400 AND endtime=1407402000 AND customer_id=526 AND key2='drop' AND key6='eth4.305' AND key1='010.017.000.002' AND key3='udp' AND key4='138' AND key5='010.011.005.034'
|
TABLE LOCK table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C5 lock mode IX
|
RECORD LOCKS space id 1744 page no 2796452 n bits 400 index `stats_data_idx5` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C5 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2612834 n bits 160 index `PRIMARY` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C5 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806319 n bits 232 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C5 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2807047 n bits 224 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C5 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806329 n bits 240 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C5 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2525093 n bits 104 index `stats_data_idx5` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C5 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2577922 n bits 128 index `PRIMARY` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C5 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806605 n bits 160 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C5 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2577950 n bits 136 index `PRIMARY` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C5 lock_mode X locks rec but not gap
|
TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS
|
---TRANSACTION 5FF13C4, ACTIVE 936 sec inserting, thread declared inside InnoDB 500
|
mysql tables in use 23, locked 23
|
9 lock struct(s), heap size 1248, 33 row lock(s), undo log entries 33
|
MySQL thread id 147, OS thread handle 0x7fadbed9a700, query id 152106070 172.25.1.15 argus update
|
INSERT /*+ APPEND */ INTO stats_data (stat_id,starttime,endtime,customer_id,key2,key5,key6,key1,key3,key4,value1) VALUES(3,1407398400,1407402000,83,'accept','080.239.148.201','eth14.107','172.027.117.011','tcp','80',0)
|
TABLE LOCK table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C4 lock mode IX
|
RECORD LOCKS space id 1744 page no 2807062 n bits 216 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C4 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2612835 n bits 104 index `PRIMARY` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C4 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806313 n bits 240 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C4 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806615 n bits 216 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C4 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806334 n bits 248 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C4 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 1331767 n bits 400 index `stats_data_idx5` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C4 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2612823 n bits 168 index `PRIMARY` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C4 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806602 n bits 216 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C4 lock_mode X locks rec but not gap
|
---TRANSACTION 5FF13C0, ACTIVE 936 sec starting index read, thread declared inside InnoDB 500
|
mysql tables in use 23, locked 23
|
206 lock struct(s), heap size 31160, 612 row lock(s), undo log entries 563
|
MySQL thread id 148, OS thread handle 0x7fadbed51700, query id 152106073 172.25.1.15 argus Updating
|
UPDATE stats_data SET value1=value1+1 WHERE stat_id=2 AND starttime=1407398400 AND endtime=1407402000 AND customer_id=526 AND key2='drop' AND key6='eth1.861' AND key1='010.017.000.022' AND key3='udp' AND key4='32183' AND key5='172.016.111.152'
|
TABLE LOCK table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C0 lock mode IX
|
RECORD LOCKS space id 1744 page no 2805826 n bits 184 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C0 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2612829 n bits 72 index `PRIMARY` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C0 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2807089 n bits 224 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C0 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806603 n bits 224 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C0 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2805849 n bits 216 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C0 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806607 n bits 200 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C0 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2807083 n bits 192 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C0 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806619 n bits 176 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C0 lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2807057 n bits 176 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13C0 lock_mode X locks rec but not gap
|
TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS
|
---TRANSACTION 5FF13BC, ACTIVE 938 sec inserting, thread declared inside InnoDB 500
|
mysql tables in use 23, locked 23
|
99 lock struct(s), heap size 14776, 292 row lock(s), undo log entries 267
|
MySQL thread id 146, OS thread handle 0x7fadbede3700, query id 152128979 172.25.1.15 argus update
|
INSERT /*+ APPEND */ INTO stats_data (stat_id,starttime,endtime,customer_id,key2,key5,key6,key1,key3,key4,value1) VALUES(3,1407398400,1407402000,83,'drop','195.000.192.066','eth5','172.027.117.011','udp','28515',0)
|
TABLE LOCK table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13BC lock mode IX
|
RECORD LOCKS space id 1744 page no 2603577 n bits 392 index `stats_data_idx5` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13BC lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2612821 n bits 80 index `PRIMARY` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13BC lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806285 n bits 208 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13BC lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 340009 n bits 400 index `stats_data_idx5` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13BC lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2806602 n bits 208 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13BC lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2805841 n bits 200 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13BC lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2807087 n bits 176 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13BC lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2805843 n bits 192 index `stat_id` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13BC lock_mode X locks rec but not gap
|
RECORD LOCKS space id 1744 page no 2506721 n bits 272 index `stats_data_idx5` of table `argus`.`stats_data` /* Partition `p201408` */ trx id 5FF13BC lock_mode X locks rec but not gap
|
TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS
|
----------------------------
|