Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
Recovery with maria_read_log from the RQG varchar scenario failed as follows:
The transaction log starts from lsn (1,0x2007)
TRACE of the last maria_read_log
/home/buildbot/rqg-buildbot-slave/rqg-weekend/build/mysql-test//../storage/maria/maria_read_log: Maria engine: starting recovery
recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80%maria_read_log: ma_key_recover.c:982: _ma_apply_redo_index: Assertion `page_offset - length <= page_length' failed.
RQG command line:
- 2010-09-09T04:30:05 # /home/buildbot/randgen/runall.pl \
- 2010-09-09T04:30:05 # --queries=1M \
- 2010-09-09T04:30:05 # --engine=Maria \
- 2010-09-09T04:30:05 # -
mysqld=-log-output=file \ - 2010-09-09T04:30:05 # -
mysqld=-maria_log_purge_type=at_flush \ - 2010-09-09T04:30:05 # --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
- 2010-09-09T04:30:05 # --duration=240 \
- 2010-09-09T04:30:05 # --threads=10 \
- 2010-09-09T04:30:05 # --rows=10 \
- 2010-09-09T04:30:05 # --mask-level=0 \
- 2010-09-09T04:30:05 # -
mysqld=-loose-maria-group-commit=hard \ - 2010-09-09T04:30:05 # -
mysqld=-loose-maria_group_commit_interval=100 \ - 2010-09-09T04:30:05 # -
mysqld=-maria-checkpoint-interval=0 \ - 2010-09-09T04:30:05 # -
mysqld=-maria-block-size=16K \ - 2010-09-09T04:30:05 # --grammar=conf/engines/varchar.yy \
- 2010-09-09T04:30:05 # --gendata=conf/engines/varchar.zz \
- 2010-09-09T04:30:05 # --mask=2697 \
- 2010-09-09T04:30:05 # --queries=100000000 \
- 2010-09-09T04:30:05 # --mask=2697 \
- 2010-09-09T04:30:05 # --basedir=. \
- 2010-09-09T04:30:05 # --seed=time \
- 2010-09-09T04:30:05 # --vardir=/home/buildbot/rqg-buildbot-slave/rqg-weekend/vardir-maria_recovery_weekend/current
bzr version-info:
revision-id: <email address hidden>
date: 2010-09-07 19:58:39 +0300
build-date: 2010-09-09 10:35:46 +0300
revno: 2924
branch-nick: 5.1
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: ma_key_recover.c:982: _ma_apply_redo_index: Assertion `page_offset - length <= page_length' failed on maria_read_log aria recovery
Re: ma_key_recover.c:982: _ma_apply_redo_index: Assertion `page_offset - length <= page_length' failed on maria_read_log aria recovery
Tested with the uploaded datadir and maria_read_log now works.
Will run the test script as follows for some hours to ensure the bug is really fixed.
while runall.pl -basedir=/my/maria-5.1 --vardir=/my/vardir --mysqld=sync-sys=0 --mysqld=safe-mode --mysqld=default-storage-engine=Maria --mysqld=loose-debug-assert-if-crashed-table --queries=1M --engine=Maria --mysqld=log-output=file --mysqld=maria_log_purge_type=at_flush --reporters=ErrorLog,Backtrace,Recovery,Shutdown --duration=240 --threads=10 --rows=10 --mask-level=0 --mysqld=loose-maria-group-commit=hard --mysqld=loose-maria_group_commit_interval=100 --mysqld=maria-checkpoint-interval=0 --mysqld=-maria-block-size=16K --grammar=conf/engines/varchar.yy --gendata=conf/engines/varchar.zz --mask=2697 --queries=100000000 --mask=2697 --basedir=. --seed=time ; do echo "retrying" ; done ;
Re: ma_key_recover.c:982: _ma_apply_redo_index: Assertion `page_offset - length <= page_length' failed on maria_read_log aria recovery
Have now run test for 6 hours and no problems, so I have to assume this bug is fixed too.
Launchpad bug id: 633866
datadir, logs, etc.
LPexportBug633866_var-bug633866.zip