ma_blockrec.c:1747: get_head_or_tail_page: Assertion `(uint) (res->buff[7] & 7) == page_type' failed.

[Philip Stoev]

When executing the varchar RQG scenario, the server asserted as follows:

ma_blockrec.c:1747: get_head_or_tail_page: Assertion `(uint) (res->buff[7] & 7) == page_type' failed.

The original assert is

    DBUG_ASSERT((uint) (res->buff[PAGE_TYPE_OFFSET] & PAGE_TYPE_MASK) == page_type);

Backtrace:

#6 0x000000307b62b945 in __assert_fail (assertion=0xd5df18 "(uint) (res->buff[7] & 7) == page_type", file=<value optimized out>, line=1747,
    function=<value optimized out>) at assert.c:81
#7 0x0000000000986651 in get_head_or_tail_page (info=0x7f1ed0165978, block=0x7f1ed00a2730, buff=0x7f1ed0166030 "", length=209, page_type=1,
    lock=PAGECACHE_LOCK_WRITE, res=0x7f1f38084040) at ma_blockrec.c:1746
#8 0x000000000098b22e in allocate_and_write_block_record (info=0x7f1ed0165978, record=0x7f1ed00c3ad0 <incomplete sequence \375>, row=0x7f1ed01659d8,
    undo_lsn=1) at ma_blockrec.c:3488
#9 0x000000000098b4ab in _ma_write_init_block_record (info=0x7f1ed0165978, record=0x7f1ed00c3ad0 <incomplete sequence \375>) at ma_blockrec.c:3547
#10 0x000000000099c09f in maria_write (info=0x7f1ed0165978, record=0x7f1ed00c3ad0 <incomplete sequence \375>) at ma_write.c:148
#11 0x0000000000953a24 in ha_maria::write_row (this=0x7f1ed00c3870, buf=0x7f1ed00c3ad0 <incomplete sequence \375>) at ha_maria.cc:1040
#12 0x00000000007c241e in handler::ha_write_row (this=0x7f1ed00c3870, buf=0x7f1ed00c3ad0 <incomplete sequence \375>) at handler.cc:4655
#13 0x00000000007cb329 in ha_partition::write_row (this=0x7f1ed00c3220, buf=0x7f1ed00c3ad0 <incomplete sequence \375>) at ha_partition.cc:3093
#14 0x00000000007c241e in handler::ha_write_row (this=0x7f1ed00c3220, buf=0x7f1ed00c3ad0 <incomplete sequence \375>) at handler.cc:4655
#15 0x00000000007233be in write_record (thd=0x80044a00, table=0x16, info=0x3ee3638) at sql_insert.cc:1632
#16 0x000000000072124d in mysql_insert (thd=0x3ee3638, table_list=0x7f1ecc014d68, fields=..., values_list=..., update_fields=..., update_values=...,
    duplic=DUP_ERROR, ignore=false) at sql_insert.cc:860
#17 0x0000000000683d9e in mysql_execute_command (thd=0x3ee3638) at sql_parse.cc:3288
#18 0x000000000068c719 in mysql_parse (thd=0x3ee3638,
    rawbuf=0x7f1ecc014910 "INSERT INTO `table10_maria_key_pk_parts_2_varchar_1024_not_null` ( `col_varchar_1024_latin1` , `col_varchar_1024_latin1_not_null` ) VALUES ( 'bgrgypkmsehyvleoigscubzpvrtwletotwfomhfjvxeghshyfxbnqpnhnq"..., length=344, found_semicolon=0x7f1f38085c70) at sql_parse.cc:6092
#19 0x000000000067e920 in dispatch_command (command=COM_QUERY, thd=0x3ee3638,
    packet=0x3ee6239 "INSERT INTO `table10_maria_key_pk_parts_2_varchar_1024_not_null` ( `col_varchar_1024_latin1` , `col_varchar_1024_latin1_not_null` ) VALUES ( 'bgrgypkmsehyvleoigscubzpvrtwletotwfomhfjvxeghshyfxbnqpnhnq"..., packet_length=344) at sql_parse.cc:1269
#20 0x000000000067d92b in do_command (thd=0x3ee3638) at sql_parse.cc:895
#21 0x000000000067a949 in handle_one_connection (arg=0x3ee3638) at sql_connect.cc:1138
#22 0x000000307ba07761 in start_thread (arg=0x7f1f38086710) at pthread_create.c:301
#23 0x000000307b6e150d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115

bzr version-info:

revision-id: <email address hidden>
date: 2010-09-10 23:27:26 +0300
build-date: 2010-09-11 10:13:42 +0300
revno: 2929
branch-nick: 5.1

RQG command line:

 /home/buildbot/randgen/runall.pl \
 --queries=1M \
 --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=30 \
 --threads=5 \
 --rows=10 \
 --mask-level=2 \
 --mysqld=--loose-maria-group-commit=soft \
 --mysqld=--loose-maria_group_commit_interval=10 \
 --mysqld=--maria-checkpoint-interval=0 \
 --mysqld=--maria-block-size=16K \
 --mask=60283 \
 --queries=100000000 \
 --mask=60283 \
 --seed=1284187595 \
 --vardir=/home/buildbot/rqg-buildbot-slave/rqg-weekend/vardir-maria_recovery_weekend/current \
 --basedir=. \
 --grammar=conf/engines/varchar.yy \
 --gendata=conf/engines/varchar.zz

[Michael Widenius (monty)]

Have tested this for 24 hours on 5.2 without any problems, so assume this issue is now solved.