[MDEV-2726] LP:814231 - Aria post-recovery error "Bitmap at page 0 has pages reserved outside of data file length" Created: 2011-07-21  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 LPexportBug814231.xml    

 Description   

After killing aria_read_log with kill -9 and rerunning it, aria_chk reports:

Checking Aria file: smf2/smf_log_group_requests.MAI
Data records: 270 Deleted blocks: 0

  • check file-size
  • check key delete-chain
  • check index reference
  • check data record references index: 1
  • check data record references index: 2
  • check records and index references
    aria_chk: error: Bitmap at page 0 has pages reserved outside of data file length
    State updated
    Aria table 'smf2/smf_log_group_requests.MAI' is corrupted
    Fix it using switch "-r" or "-o"

RQG command line:

runall.pl -queries=100000000 --queries=1M --engine=Aria --mysqld=default-storage-engine=Aria --mysqld=safe-mode --mysqld=loose-debug-assert-if-crashed-table --mysqld=sync-sys=0 --mysqld=log-output=file --mysqld=aria_log_purge_type=at_flush --reporters=ErrorLog,Backtrace,AriaDoubleRecovery,Shutdown --duration=120 --threads=10 --rows=10000 --mask-level=0 --mysqld=aria-repair-threads=2 --mysqld=loose-aria-group-commit=hard --mysqld=loose-aria_group_commit_interval=0 --mysqld=aria-checkpoint-interval=0 --mysqld=aria-block-size=1K --mysqld=table_cache=32K --mysqld=aria-pagecache-division-limit=75 --mysqld=aria_pagecache_age_threshold=10 --mysqld=-init-file=/home/philips/bzr/randgen-aria-recovery/conf/smf/smf2.sql --grammar=conf/smf/smf2.yy --mtr-build-thread=300 --mask=5921 --basedir1=/home/philips/bzr/maria-5.2 --seed=1311265840



 Comments   
Comment by Philip Stoev (Inactive) [ 2011-07-21 ]

Re: Aria post-recovery error "Bitmap at page 0 has pages reserved outside of data file length"
The datadir is 417MB, available if needed.

Comment by Michael Widenius [ 2011-08-12 ]

Re: Aria post-recovery error "Bitmap at page 0 has pages reserved outside of data file length"
This was a bug in aria_chk; The file was correct.
I will push the fix to 5.1

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

Launchpad bug id: 814231

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