[MDEV-3559] LP:633866 - ma_key_recover.c:982: _ma_apply_redo_index: Assertion `page_offset - length <= page_length' failed on maria_read_log aria recovery Created: 2010-09-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 LPexportBug633866.xml     Zip Archive LPexportBug633866_var-bug633866.zip    

 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:

  1. 2010-09-09T04:30:05 # /home/buildbot/randgen/runall.pl \
  2. 2010-09-09T04:30:05 # --queries=1M \
  3. 2010-09-09T04:30:05 # --engine=Maria \
  4. 2010-09-09T04:30:05 # -mysqld=-log-output=file \
  5. 2010-09-09T04:30:05 # -mysqld=-maria_log_purge_type=at_flush \
  6. 2010-09-09T04:30:05 # --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
  7. 2010-09-09T04:30:05 # --duration=240 \
  8. 2010-09-09T04:30:05 # --threads=10 \
  9. 2010-09-09T04:30:05 # --rows=10 \
  10. 2010-09-09T04:30:05 # --mask-level=0 \
  11. 2010-09-09T04:30:05 # -mysqld=-loose-maria-group-commit=hard \
  12. 2010-09-09T04:30:05 # -mysqld=-loose-maria_group_commit_interval=100 \
  13. 2010-09-09T04:30:05 # -mysqld=-maria-checkpoint-interval=0 \
  14. 2010-09-09T04:30:05 # -mysqld=-maria-block-size=16K \
  15. 2010-09-09T04:30:05 # --grammar=conf/engines/varchar.yy \
  16. 2010-09-09T04:30:05 # --gendata=conf/engines/varchar.zz \
  17. 2010-09-09T04:30:05 # --mask=2697 \
  18. 2010-09-09T04:30:05 # --queries=100000000 \
  19. 2010-09-09T04:30:05 # --mask=2697 \
  20. 2010-09-09T04:30:05 # --basedir=. \
  21. 2010-09-09T04:30:05 # --seed=time \
  22. 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

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

Re: ma_key_recover.c:982: _ma_apply_redo_index: Assertion `page_offset - length <= page_length' failed on maria_read_log aria recovery

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

datadir, logs, etc.
LPexportBug633866_var-bug633866.zip

Comment by Michael Widenius [ 2011-02-03 ]

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 ;

Comment by Michael Widenius [ 2011-02-03 ]

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.

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

Launchpad bug id: 633866

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