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

LP:634943 - "marked as crashed", "zerofilling" and "wrong data in bitmap" when recovering Aria tables

    Details

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

      Description

      After running the engine_stress RQG scenario and recovery, mysqld reported the following:

      1. 2010-09-10T13:26:31 100910 13:26:31 [ERROR] mysqld: Table './test/table100_maria_key_pk_parts_2_int_autoinc#P#p0' is marked as crashed and should be repaired
      2. 2010-09-10T13:26:31 100910 13:26:31 [Note] Zerofilling table: './test/table100_maria_key_pk_parts_2_int_autoinc'
      3. 2010-09-10T13:26:31 100910 13:26:31 [Note] Zerofilling table: './test/table100_maria_key_pk_parts_2_int_autoinc'

      then CHECK TABLE `test`.`table100_maria_key_pk_parts_2_int_autoinc` EXTENDED reported:

      'Page 1: Wrong data in bitmap. Page_type: 1 full: 1 empty_space: 6418 Bitmap-bits: 3'

      This happened on a mysqld-based recovery using existing tables. Recovery using maria_read_log and empty datadir worked as expected.

      bzr version-info:

      date: 2010-09-10 02:42:12 +0300
      build-date: 2010-09-10 16:52:51 +0300
      revno: 2928
      branch-nick: 5.1

      RQG command line:

      /home/buildbot/randgen/runall.pl \
      --queries=1M \
      --engine=Maria \
      -mysqld=-safe-mode \
      -mysqld=-sync-sys=0 \
      -mysqld=-log-output=file \
      -mysqld=-maria_log_purge_type=at_flush \
      --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
      --duration=120 \
      --threads=5 \
      --rows=100 \
      --mask-level=0 \
      -mysqld=-maria-repair-threads=2 \
      -mysqld=-loose-maria-group-commit=soft \
      -mysqld=-loose-maria_group_commit_interval=100 \
      -mysqld=-maria-checkpoint-interval=1 \
      -mysqld=-maria-block-size=16K \
      --mask=59718 \
      --queries=100000000 \
      --mask=59718 \
      --seed=time \
      --basedir=. \
      --vardir=/home/buildbot/rqg-buildbot-slave/rqg-weekend/vardir-maria_recovery_weekend/current \
      --grammar=conf/engines/engine_stress.yy \
      --gendata=conf/engines/engine_stress.zz

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            philipstoev Philip Stoev added a comment -

            log , datadir, etc.
            LPexportBug634943_var-bug634943.zip

            Show
            philipstoev Philip Stoev added a comment - log , datadir, etc. LPexportBug634943_var-bug634943.zip
            Hide
            philipstoev Philip Stoev added a comment -

            Re: "marked as crashed", "zerofilling" and "wrong data in bitmap" when recovering Aria tables

            Show
            philipstoev Philip Stoev added a comment - Re: "marked as crashed", "zerofilling" and "wrong data in bitmap" when recovering Aria tables
            Hide
            monty Michael Widenius added a comment -

            Re: "marked as crashed", "zerofilling" and "wrong data in bitmap" when recovering Aria tables
            Found bug, fixed, tested and pushed in 5.1

            • Tables marked as opened was not properly unmarked on recovery if there was not changes since checkpoint
            • zerofill of tables put wrong data in bitmap if directory for page was full
            • Tables was thought as 'moved' during recovery if they had a create_lsn bigger than the lsn in the control file.
            Show
            monty Michael Widenius added a comment - Re: "marked as crashed", "zerofilling" and "wrong data in bitmap" when recovering Aria tables Found bug, fixed, tested and pushed in 5.1 Tables marked as opened was not properly unmarked on recovery if there was not changes since checkpoint zerofill of tables put wrong data in bitmap if directory for page was full Tables was thought as 'moved' during recovery if they had a create_lsn bigger than the lsn in the control file.
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 634943

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

              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: