Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-2984

LP #1199213: mysqld crash because of long wait

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by guyue.zql last update 30-05-2016 04:17:41

      version: 5518
      os : Linux 2.6.32-220.23.2
      innodb_adaptive_hash_index_partitions = 8

      backtrace:

      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
      /u01/mysql/bin/mysqld(my_print_stacktrace+0x39)[0x7bf889]
      /u01/mysql/bin/mysqld(handle_segfault+0x43c)[0x50230c]
      /lib64/libpthread.so.0[0x3151c0f4a0]
      /lib64/libc.so.6(gsignal+0x35)[0x3151832885]
      /lib64/libc.so.6(abort+0x175)[0x3151834065]
      /u01/mysql/bin/mysqld[0x847db5]
      /lib64/libpthread.so.0[0x3151c077f1]
      /lib64/libc.so.6(clone+0x6d)[0x31518e570d]
      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.

      =====================================
      130708 23:51:20 INNODB MONITOR OUTPUT
      =====================================

      SEMAPHORES
      ----------
      OS WAIT ARRAY INFO: reservation count 418, signal count 26197
      --Thread 47143910115072 has waited at btr0sea.c line 1208 for 950.00 seconds the semaphore:
      X-lock (wait_ex) on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47154379364096 has waited at btr0sea.c line 1519 for 950.00 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47158942500608 has waited at btr0sea.c line 1110 for 940.00 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47153506948864 has waited at btr0sea.c line 1110 for 937.00 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47154178037504 has waited at btr0sea.c line 1110 for 880.00 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47151761852160 has waited at btr0sea.c line 1519 for 680.00 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47155117295360 has waited at btr0sea.c line 1519 for 680.00 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47149144872704 has waited at row0sel.c line 3691 for 679.00 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47146930280192 has waited at btr0sea.c line 1519 for 380.00 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47148540626688 has waited at btr0sea.c line 1110 for 380.00 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47145118340864 has waited at btr0sea.c line 1519 for 80.000 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      --Thread 47143306401536 has waited at btr0sea.c line 1519 for 80.000 seconds the semaphore:
      S-lock on RW-latch at 0x37750a8 'btr_search_latch_part[i]'
      a writer (thread id 47143910115072) has reserved it in mode wait exclusive
      number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
      Last time read locked in file btr0sea.c line 1110
      Last time write locked in file /home/ads/build23_6u0_x64/workspace/t-mysql-rds-55/label/build23_6u0_x64/t-mysql-rds-55/storage/innobase/btr/btr0sea.c line 672
      Mutex spin waits 606879, rounds 503803, OS waits 0
      RW-shared spins 33599, rounds 335413, OS waits 350
      RW-excl spins 7708, rounds 72096, OS waits 67
      Spin rounds per wait: 0.83 mutex, 9.98 RW-shared, 9.35 RW-excl

      -------------------------------------
      INSERT BUFFER AND ADAPTIVE HASH INDEX
      -------------------------------------
      Ibuf: size 1, free list len 20, seg size 22, 3586 merges
      merged operations:
      insert 3631, delete mark 0, delete 0
      discarded operations:
      insert 0, delete mark 0, delete 0
      Hash table size 249127, node heap has 635 buffer(s)
      Hash table size 249127, node heap has 429 buffer(s)
      Hash table size 249127, node heap has 357 buffer(s)
      Hash table size 249127, node heap has 423 buffer(s)
      Hash table size 249127, node heap has 399 buffer(s)
      Hash table size 249127, node heap has 704 buffer(s)
      Hash table size 249127, node heap has 604 buffer(s)
      Hash table size 249127, node heap has 391 buffer(s)
      0.00 hash searches/s, 0.00 non-hash searches/s

      ----------------------
      BUFFER POOL AND MEMORY
      ----------------------
      Total memory allocated 1034158080; in additional pool allocated 0
      Internal hash tables (constant factor + variable factor)
      Adaptive hash index 99208576 (15944128 + 83264448)
      Page hash 997064 (buffer pool 0 only)
      Dictionary cache 5889299 (3986032 + 1903267)
      File system 209392 (82672 + 126720)
      Lock system 2504304 (2491144 + 13160)
      Recovery system 0 (0 + 0)
      Dictionary memory allocated 1903267
      Buffer pool size 61439
      Buffer pool size, bytes 1006616576
      Free buffers 0
      Database pages 57492
      Old database pages 21202
      Modified db pages 0
      Pending reads 1
      Pending writes: LRU 0, flush list 0, single page 0
      Pages made young 241417, not young 0
      0.00 youngs/s, 0.00 non-youngs/s
      Pages read 144672, created 1426, written 36797
      0.00 reads/s, 0.00 creates/s, 0.00 writes/s
      Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
      Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
      LRU len: 57492, unzip_LRU len: 0
      I/O sum[53]:cur[0], unzip sum[0]:cur[0]

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: