mysqld: ma_bitmap.c:1019: allocate_tail: Assertion `size <= ((bitmap->block_size) *3 / 4)' failed

[Philip Stoev]

When executing the SMF RQG scenario, Aria asserted as follows:

mysqld: ma_bitmap.c:1019: allocate_tail: Assertion `size <= ((bitmap->block_size) *3 / 4)' failed.

Recovery was then successfull.

bzr version-info:

revision-id: <email address hidden>
date: 2010-10-13 18:15:43 +0300
build-date: 2010-10-13 21:18:31 +0300
revno: 2951
branch-nick: 5.1
------------------------------------------------------------
revno: 2951
committer: Michael Widenius <email address hidden>
branch nick: maria-5.1
timestamp: Wed 2010-10-13 18:15:43 +0300
message:
  Fixes for bugs found by running test case for LP#608369 "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED"
  Fixed overflow when using long --debug=xxxxxx line.
  Fixed that "mysqld --disable-debug --debug" works.
  Ensure that MariaDB doesn't start if the Aria engine didn't start and we are using Aria for temporary tables.
  More DBUG_ASSERT() and more info in debug log.

RQG command line:

/home/buildbot/randgen/runall.pl \
--basedir=. \
--mysqld=--init-file=/home/buildbot/randgen/conf/smf/smf2.sql \
--grammar=conf/smf/smf2.yy \
--queries=1M \
--engine=Maria \
--mysqld=--default-storage-engine=Maria \
--mysqld=--safe-mode \
--mysqld=--sync-sys=0 \
--mysqld=--log-output=file \
--mysqld=--maria_log_purge_type=at_flush \
--reporters=ErrorLog,Backtrace,Recovery,Shutdown \
--duration=120 \
--threads=1 \
--rows=1 \
--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=0 \
--mysqld=--maria-block-size=16K \
--mask=4314 \
--queries=100000000 \
--seed=1287014908

backtrace:

#6 0x000000307b62b945 in __assert_fail (assertion=0xd61f08 "size <= ((bitmap->block_size) *3 / 4)", file=<value optimized out>, line=1019,
    function=<value optimized out>) at assert.c:81
#7 0x0000000000997f44 in allocate_tail (bitmap=0x7ff73483ea50, size=12290, block=0x7ff73489db90) at ma_bitmap.c:1019
#8 0x0000000000998c1f in find_tail (info=0x7ff7348260b8, length=12286, position=5) at ma_bitmap.c:1333
#9 0x0000000000998f12 in find_blob (info=0x7ff7348260b8, length=61402) at ma_bitmap.c:1445
#10 0x0000000000998ff2 in allocate_blobs (info=0x7ff7348260b8, row=0x7ff734826118) at ma_bitmap.c:1481
#11 0x00000000009995f0 in _ma_bitmap_find_place (info=0x7ff7348260b8, row=0x7ff734826118, blocks=0x7ff734826118) at ma_bitmap.c:1710
#12 0x000000000098b99e in allocate_and_write_block_record (info=0x7ff7348260b8, record=0x7ff7347ea920 "", row=0x7ff734826118, undo_lsn=1)
    at ma_blockrec.c:3478
#13 0x000000000098bc87 in _ma_write_init_block_record (info=0x7ff7348260b8, record=0x7ff7347ea920 "") at ma_blockrec.c:3547
#14 0x000000000099c887 in maria_write (info=0x7ff7348260b8, record=0x7ff7347ea920 "") at ma_write.c:148
#15 0x0000000000953f70 in ha_maria::write_row (this=0x7ff7347ea530, buf=0x7ff7347ea920 "") at ha_maria.cc:1040
#16 0x00000000007c268a in handler::ha_write_row (this=0x7ff7347ea530, buf=0x7ff7347ea920 "") at handler.cc:4655
#17 0x0000000000723616 in write_record (thd=0x7ff7347ea530, table=0x7ff7347ea920, info=0x953f70) at sql_insert.cc:1632
#18 0x00000000007214a5 in mysql_insert (thd=0x4088298, table_list=0x7ff734014a88, fields=..., values_list=..., update_fields=..., update_values=...,
    duplic=DUP_ERROR, ignore=false) at sql_insert.cc:860
#19 0x0000000000683b5f in mysql_execute_command (thd=0x4088298) at sql_parse.cc:3255
#20 0x000000000068c89b in mysql_parse (thd=0x4088298,
    rawbuf=0x7ff734014910 "INSERT INTO smf_themes (`id_theme`,`variable`,`value`) VALUES (2,'will',REPEAT ( 'm' , 61402 ))", length=95,
    found_semicolon=0x7ff7b4075c70) at sql_parse.cc:6115
#21 0x000000000067e9db in dispatch_command (command=COM_QUERY, thd=0x4088298,
    packet=0x415fd99 "INSERT INTO smf_themes (`id_theme`,`variable`,`value`) VALUES (2,'will',REPEAT ( 'm' , 61402 ))", packet_length=95)
    at sql_parse.cc:1272
#22 0x000000000067d9fb in do_command (thd=0x4088298) at sql_parse.cc:898
#23 0x000000000067aa19 in handle_one_connection (arg=0x4088298) at sql_connect.cc:1138
#24 0x000000307ba07761 in start_thread (arg=0x7ff7b4076710) at pthread_create.c:301
#25 0x000000307b6e150d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115

[Michael Widenius (monty)]

This was fixed 2010-11-02 as part of another bug fix.