[MDEV-2568] LP:700623 - Aria recovery: ma_blockrec.c:3930: _ma_update_at_original_place: Assertion `block->org_bitmap_value == _ma_bitmap_get_page_bits(info, &info->s->bitmap, page)' failed Created: 2011-01-09  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 LPexportBug700623.xml     Zip Archive LPexportBug700623_var-bug700623.zip    

 Description   

When recovering from the SMF scenario with maria_read_log, the recovery asserted as follows:

transactions to roll back: 2maria_read_log: ma_blockrec.c:3930: _ma_update_at_original_place: Assertion `block->org_bitmap_value == _ma_bitmap_get_page_bits(info, &info->s->bitmap, page)' failed.

bzr version-info:

revno: 3006
committer: Michael Widenius <email address hidden>
branch nick: maria-5.1
timestamp: Fri 2011-01-07 17:58:12 +0200
message:
Don't do DBUG_ASSERT for checksum errors when using REPAIR
mysql_convert_table_format ignored --engine option.
Fix that zerofill() doesn't write out wrong data to client if run with auto repair.
Ensure that pagecache is properly flushed, even in case of errors.
Handle checksum errors in BLOCK_RECORD format.

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=240 \
--threads=10 \
--rows=10 \
--mask-level=2 \
-mysqld=-maria-repair-threads=2 \
-mysqld=-loose-maria-group-commit=hard \
-mysqld=-loose-maria_group_commit_interval=10 \
-mysqld=-maria-checkpoint-interval=120 \
-mysqld=-maria-block-size=16K \
--queries=100000000 \
--mask=735 \
--seed=1294540351\
-mysqld=-init-file=/home/buildbot/randgen/conf/smf/smf2.sql \
--grammar=conf/smf/smf2.yy \
--basedir=.



 Comments   
Comment by Philip Stoev (Inactive) [ 2011-01-09 ]

Re: Aria recovery: ma_blockrec.c:3930: _ma_update_at_original_place: Assertion `block->org_bitmap_value == _ma_bitmap_get_page_bits(info, &info->s->bitmap, page)' failed
vardir before recovery, log, etc.

Comment by Philip Stoev (Inactive) [ 2011-01-09 ]

vardir before recovery, log, etc.
var-bug700623.zip
LPexportBug700623_var-bug700623.zip

Comment by Michael Widenius [ 2011-01-23 ]

Re: Aria recovery: ma_blockrec.c:3930: _ma_update_at_original_place: Assertion `block->org_bitmap_value == _ma_bitmap_get_page_bits(info, &info->s->bitmap, page)' failed
Found and fixed. Will push tomorrow (just want to run the test for 12+ hours before committing).

Comment by Michael Widenius [ 2011-01-31 ]

Re: Aria recovery: ma_blockrec.c:3930: _ma_update_at_original_place: Assertion `block->org_bitmap_value == _ma_bitmap_get_page_bits(info, &info->s->bitmap, page)' failed
Found another case where we got the same assert. Fixed last night and pushed.

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

Launchpad bug id: 700623

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