[MDEV-3527] LP:869846 - Assertion `share->now_transactional' failed in flush_log_for_bitmap in Aria checkpointing Created: 2011-10-07  Updated: 2012-10-04  Resolved: 2012-10-04

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

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

Attachments: XML File LPexportBug869846.xml     Zip Archive LPexportBug869846_var-bug869846.zip    

 Description   

When executing a SELECT-only RQG workload, Aria asserted as follows:

mysqld: ma_bitmap.c:2907: flush_log_for_bitmap: Assertion `share->now_transactional' failed.

  1. 2011-10-07T01:44:46 #6 0x00000033b58296e6 in __assert_fail () from /lib64/libc.so.6
  2. 2011-10-07T01:44:46 #7 0x00000000009e19ca in flush_log_for_bitmap (page=0x2aaaaacc8038 "",
  3. 2011-10-07T01:44:46 page_no=0, data_ptr=0x43e4ab8 "\376\376\t\003\f") at ma_bitmap.c:2907
  4. 2011-10-07T01:44:46 #8 0x0000000000a3c8d5 in pagecache_fwrite (pagecache=0x1ac57c0,
  5. 2011-10-07T01:44:46 filedesc=0x2aaab290ba00, buffer=0x2aaaaacc8038 "", pageno=0,
  6. 2011-10-07T01:44:46 type=PAGECACHE_PLAIN_PAGE, flags=36) at ma_pagecache.c:658
  7. 2011-10-07T01:44:46 #9 0x0000000000a46f85 in flush_cached_blocks (pagecache=0x1ac57c0,
  8. 2011-10-07T01:44:46 file=0x43e5530, cache=0x414bbd90, end=0x414bbd98, type=FLUSH_KEEP,
  9. 2011-10-07T01:44:46 first_errno=0x414bbd6c) at ma_pagecache.c:4489
  10. 2011-10-07T01:44:46 #10 0x0000000000a477f6 in flush_pagecache_blocks_int (pagecache=0x1ac57c0,
  11. 2011-10-07T01:44:46 file=0x43e5530, type=FLUSH_KEEP,
  12. 2011-10-07T01:44:46 filter=0x9dcf7a <filter_flush_bitmap_pages>, filter_arg=0x43e5660)
  13. 2011-10-07T01:44:46 at ma_pagecache.c:4782
  14. 2011-10-07T01:44:46 #11 0x0000000000a47b73 in flush_pagecache_blocks_with_filter (
  15. 2011-10-07T01:44:46 pagecache=0x1ac57c0, file=0x43e5530, type=FLUSH_KEEP,
  16. 2011-10-07T01:44:46 filter=0x9dcf7a <filter_flush_bitmap_pages>, filter_arg=0x43e5660)
  17. 2011-10-07T01:44:46 at ma_pagecache.c:4905
  18. 2011-10-07T01:44:46 #12 0x00000000009dd196 in _ma_bitmap_flush_all (share=0x43e4ab8)
  19. 2011-10-07T01:44:46 at ma_bitmap.c:535
  20. 2011-10-07T01:44:46 #13 0x00000000009fa9ef in collect_tables (str=0x414c0000,
  21. 2011-10-07T01:44:46 checkpoint_start_log_horizon=4299922172) at ma_checkpoint.c:1081
  22. 2011-10-07T01:44:46 #14 0x00000000009f91f0 in really_execute_checkpoint () at ma_checkpoint.c:198
  23. 2011-10-07T01:44:46 #15 0x00000000009f8fee in ma_checkpoint_execute (level=CHECKPOINT_MEDIUM,
  24. 2011-10-07T01:44:46 no_wait=1 '\001') at ma_checkpoint.c:132
  25. 2011-10-07T01:44:46 #16 0x00000000009f9bde in ma_checkpoint_background (arg=0x1e)
  26. 2011-10-07T01:44:46 at ma_checkpoint.c:621
  27. 2011-10-07T01:44:46 #17 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0
  28. 2011-10-07T01:44:46 #18 0x00000033b58d40cd in clone () from /lib64/libc.so.6

RQG command line:

perl runall.pl -queries=100000000 --debug --seed=time --mysqld1=debug-assert-if-crashed-table --mysqld1=innodb_stats_sample_pages=256 --mysqld1=max_join_size=1000000 --queries=100M --duration=900 --threads=6 --seed=time --mysqld1=log-output=file --no-mask --views --reporter=QueryTimeout,Backtrace,ErrorLog,Deadlock --mysqld1=optimizer_switch=derived_merge=ON,derived_with_keys=ON,semijoin=ON,materialization=ON,firstmatch=ON,loosescan=ON --validator=Transformer --seed=1317941025 --transformers=DisableChosenPlan,ConvertLiteralsToSubqueries,ExecuteAsInsertSelect,ExecuteAsSelectItem,ExecuteAsUpdateDelete,ExecuteAsWhereSubquery,InlineSubqueries --notnull --engine=Aria --grammar=conf/dbt3/dbt3-joins.yy --skip-gendata --mysqld1=-init-file=/home/philips/bzr/randgen-release-testing/conf/dbt3/dbt3-s0.0001.dump --basedir1=/home/philips/bzr/maria-5.3

revision-id: <email address hidden>
date: 2011-10-06 01:21:15 +0400
build-date: 2011-10-07 12:19:32 +0300
revno: 3213
branch-nick: maria-5.3



 Comments   
Comment by Philip Stoev (Inactive) [ 2011-10-07 ]

Re: Assertion `share->now_transactional' failed in flush_log_for_bitmap in Aria checkpointing

Comment by Philip Stoev (Inactive) [ 2011-10-07 ]

core + binary + vardir
LPexportBug869846_var-bug869846.zip

Comment by Michael Widenius [ 2012-02-28 ]

Re: Assertion `share->now_transactional' failed in flush_log_for_bitmap in Aria checkpointing
I have run this test case for hours without being able to repeat this issue.
The test case did however find an wrong mutex usage bug when flush_log_for_bitmap() was called when table is not yet marked for change.
This fix will be pushed into 5.3

Comment by Rasmus Johansson (Inactive) [ 2012-03-05 ]

Launchpad bug id: 869846

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