Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6573

Long semaphore wait at row0row.c line 716 for 935.00 seconds the semaphore: S-lock on RW-latch at 0x7f82d8aa5490 '&block->lock'

    XMLWordPrintable

    Details

      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
      ----------------------------

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            jplindst Jan Lindström
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: