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

LP:727860 - Second instance of Assertion `bitmap->flush_all_requested == 1' with Aria

    Details

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

      Description

      The following RQG workload caused the following assertion after about 1 min 30 sec:

      mysqld: ma_bitmap.c:455: _ma_bitmap_flush_all: Assertion `bitmap->flush_all_requested == 1' failed.

      1. 2011-03-01T14:24:29 #6 0x00000035a6e2b8b5 in __assert_fail () from /lib64/libc.so.6
      2. 2011-03-01T14:24:29 #7 0x00000000009c85be in _ma_bitmap_flush_all (share=0x7fe4f00a2bf8) at ma_bitmap.c:455
      3. 2011-03-01T14:24:29 #8 0x0000000000980bad in collect_tables (str=0x7fe573edad40, checkpoint_start_log_horizon=4426363314) at ma_checkpoint.c:1092
      4. 2011-03-01T14:24:29 #9 0x000000000097eefe in really_execute_checkpoint () at ma_checkpoint.c:198
      5. 2011-03-01T14:24:29 #10 0x000000000097eca7 in ma_checkpoint_execute (level=CHECKPOINT_MEDIUM, no_wait=1 '\001') at ma_checkpoint.c:132
      6. 2011-03-01T14:24:29 #11 0x000000000097faef in ma_checkpoint_background (arg=0x1) at ma_checkpoint.c:623
      7. 2011-03-01T14:24:29 #12 0x00000035a7207761 in start_thread () from /lib64/libpthread.so.0

      RQG command line:

      perl 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=480 \
      --threads=5 \
      --rows=1000 \
      --mask-level=2 \
      --queries=100000000 \
      --mask=11829 \
      --seed=1298982172 \
      -mysqld=-maria-repair-threads=2 \
      -mysqld=-loose-maria-group-commit=soft \
      -mysqld=-loose-maria_group_commit_interval=10 \
      -mysqld=-maria-checkpoint-interval=1 \
      -mysqld=-table_cache=32K \
      -mysqld=-maria-block-size=4K \
      -mysqld=-maria-pagecache-buffer-size=128K \
      -mysqld=-maria-pagecache-division-limit=75 \
      -mysqld=-maria_pagecache_age_threshold=3000 \
      -mysqld=-init-file=/home/philips/bzr/randgen/conf/smf/smf2.sql \
      --grammar=conf/smf/smf2.yy \
      --basedir=/home/philips/bzr/maria-5.1-merge/

      bzr version-info:

      [philips@fedora13 maria-5.1-merge]$ bzr version-info
      revision-id: <email address hidden>
      date: 2011-02-25 17:45:53 +0200
      build-date: 2011-03-02 18:02:09 +0200
      revno: 3043
      branch-nick: maria-5.1-merge

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            philipstoev Philip Stoev added a comment -

            core + binary + datadir
            LPexportBug727860_var-bug727860.zip

            Show
            philipstoev Philip Stoev added a comment - core + binary + datadir LPexportBug727860_var-bug727860.zip
            Hide
            philipstoev Philip Stoev added a comment -

            Re: Second instance of Assertion `bitmap->flush_all_requested == 1' with Aria

            Show
            philipstoev Philip Stoev added a comment - Re: Second instance of Assertion `bitmap->flush_all_requested == 1' with Aria
            Hide
            monty Michael Widenius added a comment -

            Re: Second instance of Assertion `bitmap->flush_all_requested == 1' with Aria
            I did run this on MariaDB 5.2 for 10 hours and no problems.
            It may be that my last fixes to Aria in 5.2 fixed this. Can you please check this?

            Show
            monty Michael Widenius added a comment - Re: Second instance of Assertion `bitmap->flush_all_requested == 1' with Aria I did run this on MariaDB 5.2 for 10 hours and no problems. It may be that my last fixes to Aria in 5.2 fixed this. Can you please check this?
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 727860

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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: