[MDEV-3151] LP:634966 - maria_read_log: ma_blockrec.c:6214: _ma_apply_redo_insert_row_head_or_tail: Assertion `rownr == 0 && new_page' failed on Aria recovery Created: 2010-09-10  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 LPexportBug634966.xml     Zip Archive LPexportBug634966_var-bug634966.zip    

 Description   

When using maria_read_log to recover from scratch from the varchar RQG scenario, the tool reported the following:

/home/buildbot/rqg-buildbot-slave/rqg-weekend/build/mysql-test//../storage/maria/maria_read_log: Maria engine: starting recovery
recovered pages: 0%maria_read_log: ma_blockrec.c:6214: _ma_apply_redo_insert_row_head_or_tail: Assertion `rownr == 0 && new_page' failed.

bzr version-info:

revision-id: <email address hidden>
date: 2010-09-07 19:58:39 +0300
build-date: 2010-09-09 18:39:03 +0300
revno: 2924
branch-nick: 5.1

rqg command-line:

perl /home/buildbot/randgen/runall.pl -queries=1M --engine=Maria --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=loose-maria-group-commit=hard --mysqld=loose-maria_group_commit_interval=0 --mysqld=maria-checkpoint-interval=0 --mysqld=-maria-block-size=16K --mask=62531 --queries=100000000 --mask=62531 --seed=time --basedir=. --vardir=/home/buildbot/rqg-buildbot-slave/rqg-weekend/vardir-maria_recovery_weekend/current --grammar=conf/engines/varchar.yy --gendata=conf/engines/varchar.zz

 Comments   
Comment by Philip Stoev (Inactive) [ 2010-09-10 ]

Re: maria_read_log: ma_blockrec.c:6214: _ma_apply_redo_insert_row_head_or_tail: Assertion `rownr == 0 && new_page' failed on Aria recovery

Comment by Philip Stoev (Inactive) [ 2010-09-10 ]

datadir, logs, etc.
LPexportBug634966_var-bug634966.zip

Comment by Michael Widenius [ 2010-09-14 ]

Re: maria_read_log: ma_blockrec.c:6214: _ma_apply_redo_insert_row_head_or_tail: Assertion `rownr == 0 && new_page' failed on Aria recovery
I can't repeat the problem either with RQG command line or with the given data files.

One can't reliably run maria_read_log on an empty dir as mysqld wasn't started with the --safe-mode option.
However, even while doing that, I don't get the given error.

Note also that my last fix in 5.1 tree regarding "When reopening table during recovery, don't set file length from file sizes as file is not flushed" fixed a symptom identical to this bug.

Comment by Rasmus Johansson (Inactive) [ 2010-12-17 ]

Launchpad bug id: 634966

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