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

LP:700964 - ma_pagecache.c:4189: free_block: Assertion `block->pins == 0' failed during Aria workload

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      When executing the SMF scenario, Aria asserted as follows:

      mysqld: ma_pagecache.c:4189: free_block: Assertion `block->pins == 0' failed.

      backtrace:

      #6 0x0000003e0582b935 in __assert_fail (
      assertion=0xd80bd8 "block->pins == 0", file=<value optimized out>,
      line=4189, function=<value optimized out>) at assert.c:81
      #7 0x00000000009d09c7 in free_block (pagecache=0x1a29160,
      block=0x7f4086136958) at ma_pagecache.c:4189
      #8 0x00000000009d1d2e in flush_pagecache_blocks_int (pagecache=0x1a29160,
      file=0x7f40080f93c0, type=FLUSH_RELEASE, filter=0, filter_arg=0x0)
      at ma_pagecache.c:4675
      #9 0x00000000009d1f36 in flush_pagecache_blocks_with_filter (
      pagecache=0x1a29160, file=0x7f40080f93c0, type=FLUSH_RELEASE, filter=0,
      filter_arg=0x0) at ma_pagecache.c:4736
      #10 0x0000000000947f8d in _ma_once_end_block_record (share=0x7f40080f8ad8)
      at ma_blockrec.c:433
      #11 0x0000000000990029 in maria_close (info=0x7f3ff405f428) at ma_close.c:79
      --Type <return> to continue, or q <return> to quit--
      #12 0x00000000009376f4 in ha_maria::close (this=0x7f3ff40d0ee0)
      at ha_maria.cc:1018
      #13 0x00000000006eb42b in closefrm (table=0x7f3ff4085ac8, free_share=true)
      at table.cc:2010
      #14 0x00000000006d1623 in intern_close_table (table=0x7f3ff4085ac8)
      at sql_base.cc:786
      #15 0x00000000006d16bb in free_cache_entry (table=0x7f3ff4085ac8)
      at sql_base.cc:808
      #16 0x0000000000b98096 in my_hash_delete (hash=0x120e400,
      record=0x7f3ff4085ac8 "\200\343L\b@\177") at hash.c:562
      #17 0x00000000006d2397 in close_open_tables (thd=0x3081c08) at sql_base.cc:1208
      #18 0x00000000006d274e in close_thread_tables (thd=0x3081c08)
      at sql_base.cc:1361
      #19 0x00000000006862a4 in dispatch_command (command=COM_QUERY, thd=0x3081c08,
      packet=0x3084f99 "UPDATE smf_boards SET unapproved_topics = unapproved_topics + 2794496 WHERE id_board = 6", packet_length=88) at sql_parse.cc:1708
      #20 0x0000000000683fb3 in do_command (thd=0x3081c08) at sql_parse.cc:899
      #21 0x0000000000680fd1 in handle_one_connection (arg=0x3081c08)
      at sql_connect.cc:1138
      #22 0x0000003e05c07761 in start_thread (arg=0x7f4058569710)
      at pthread_create.c:301
      #23 0x0000003e058e14fd in clone ()

      RQG command line:

      runall.pl \
      --queries=1M \
      --engine=Maria \
      -mysqld=-default-storage-engine=Maria \
      -mysqld=-safe-mode \
      -mysqld=-loose-debug-assert-if-crashed-table \
      -mysqld=-sync-sys=0 \
      -mysqld=-log-output=file \
      -mysqld=-maria_log_purge_type=at_flush \
      --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
      --duration=240 \
      --threads=10 \
      --rows=1000 \
      --mask-level=2 \
      -mysqld=-maria-repair-threads=2 \
      -mysqld=-loose-maria-group-commit=hard \
      -mysqld=-loose-maria_group_commit_interval=0 \
      -mysqld=-maria-checkpoint-interval=1 \
      -mysqld=-maria-block-size=16K \
      --queries=100000000 \
      --mask=44560 \
      --seed=1294595358 \
      -mysqld=-init-file=/home/buildbot/randgen/conf/smf/smf2.sql \
      --grammar=conf/smf/smf2.yy \
      --basedir=.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            philipstoev Philip Stoev added a comment -

            core + binary + datadir
            var-bug700964.zip
            LPexportBug700964_var-bug700964.zip

            Show
            philipstoev Philip Stoev added a comment - core + binary + datadir var-bug700964.zip LPexportBug700964_var-bug700964.zip
            Hide
            philipstoev Philip Stoev added a comment -

            Re: ma_pagecache.c:4189: free_block: Assertion `block->pins == 0' failed during Aria workload
            core + binary + datadir

            Show
            philipstoev Philip Stoev added a comment - Re: ma_pagecache.c:4189: free_block: Assertion `block->pins == 0' failed during Aria workload core + binary + datadir
            Hide
            philipstoev Philip Stoev added a comment -

            Re: ma_pagecache.c:4189: free_block: Assertion `block->pins == 0' failed during Aria workload
            No longer seen.

            Show
            philipstoev Philip Stoev added a comment - Re: ma_pagecache.c:4189: free_block: Assertion `block->pins == 0' failed during Aria workload No longer seen.
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 700964

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 700964

              People

              • Assignee:
                Unassigned
                Reporter:
                philipstoev Philip Stoev
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: