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

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