[MDEV-3543] LP:727860 - Second instance of Assertion `bitmap->flush_all_requested == 1' with Aria Created: 2011-03-02  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Philip Stoev (Inactive) Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug727860.xml     Zip Archive LPexportBug727860_var-bug727860.zip    

 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



 Comments   
Comment by Philip Stoev (Inactive) [ 2011-03-02 ]

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

Comment by Philip Stoev (Inactive) [ 2011-03-02 ]

core + binary + datadir
LPexportBug727860_var-bug727860.zip

Comment by Michael Widenius [ 2011-06-28 ]

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?

Comment by Rasmus Johansson (Inactive) [ 2011-12-01 ]

Launchpad bug id: 727860

Generated at Thu Feb 08 06:49:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.