Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-2726

LP:814231 - Aria post-recovery error "Bitmap at page 0 has pages reserved outside of data file length"

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            philipstoev Philip Stoev added a comment -

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

            Show
            philipstoev Philip Stoev added a comment - Re: Aria post-recovery error "Bitmap at page 0 has pages reserved outside of data file length" The datadir is 417MB, available if needed.
            Hide
            monty Michael Widenius added a comment -

            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

            Show
            monty Michael Widenius added a comment - 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
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 814231

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 814231

              People

              • Assignee:
                monty Michael Widenius
                Reporter:
                philipstoev Philip Stoev
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: