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

LP:670356 - Aria table "is marked as crashed and should be repaired"

    Details

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

      Description

      When executing recovery from the SMF scenario, the server reports the following:

      1. 2010-11-03T00:15:01 101103 0:15:01 [ERROR] mysqld: Table './smf2/smf_calendar_holidays' is marked as crashed and should be repaired
      2. 2010-11-03T00:15:01 101103 0:15:01 [Warning] Checking table: './smf2/smf_calendar_holidays'

      The tables are positively Aria tables, created with --default-storage-engine=Aria. maria_read_log does not report any issues. There are no other error messages about corruption or zerofilling.

      RQG command line:

      /home/buildbot/randgen/runall.pl \
      --queries=1M \
      --engine=Maria \
      -mysqld=-default-storage-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=240 \
      --threads=20 \
      --rows=10 \
      --mask-level=1 \
      --queries=100000000 \
      --mask=50154 \
      --seed=1288735776 \
      -mysqld=-maria-repair-threads=2 \
      -mysqld=-loose-maria-group-commit=hard \
      -mysqld=-loose-maria_group_commit_interval=10 \
      -mysqld=-maria-checkpoint-interval=0 \
      -mysqld=-maria-block-size=4K \
      -mysqld=-init-file=/home/buildbot/randgen/conf/smf/smf2.sql \
      --grammar=conf/smf/smf2.yy \
      --basedir=.

      bzr version-info:

      revision-id: <email address hidden>
      date: 2010-11-02 21:01:25 +0200
      build-date: 2010-11-02 22:29:06 +0200
      revno: 2965
      branch-nick: 5.1
      ------------------------------------------------------------
      revno: 2965
      committer: <email address hidden>
      branch nick: work-maria-5.1-define
      timestamp: Tue 2010-11-02 21:01:25 +0200
      message:
      #endif fixed.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            philipstoev Philip Stoev added a comment -

            Re: Aria table "is marked as crashed and should be repaired"
            Still repeatable as before with

            revision-id: monty@askmonty.org-20110130144457-v4an23g54l71zglq
            date: 2011-01-30 16:44:57 +0200
            build-date: 2011-02-01 22:49:52 +0200
            revno: 3027
            branch-nick: 5.1
            ------------------------------------------------------------
            revno: 3027
            committer: Michael Widenius <monty@askmonty.org>
            branch nick: maria-5.1
            timestamp: Sun 2011-01-30 16:44:57 +0200
            message:
            Ignore some linked files

            Show
            philipstoev Philip Stoev added a comment - Re: Aria table "is marked as crashed and should be repaired" Still repeatable as before with revision-id: monty@askmonty.org-20110130144457-v4an23g54l71zglq date: 2011-01-30 16:44:57 +0200 build-date: 2011-02-01 22:49:52 +0200 revno: 3027 branch-nick: 5.1 ------------------------------------------------------------ revno: 3027 committer: Michael Widenius <monty@askmonty.org> branch nick: maria-5.1 timestamp: Sun 2011-01-30 16:44:57 +0200 message: Ignore some linked files
            Hide
            monty Michael Widenius added a comment -

            Re: Aria table "is marked as crashed and should be repaired"
            Have run test case for some hours with latest 5.1 tree without problems.
            I observed and fixed a similar error when working on the test case for the previous recovery bug, so I assume this is now also fixed.

            Show
            monty Michael Widenius added a comment - Re: Aria table "is marked as crashed and should be repaired" Have run test case for some hours with latest 5.1 tree without problems. I observed and fixed a similar error when working on the test case for the previous recovery bug, so I assume this is now also fixed.
            Hide
            philipstoev Philip Stoev added a comment -

            Re: Aria table "is marked as crashed and should be repaired"
            Unforuntately this is still repeatable with the following revision:

            revision-id: monty@askmonty.org-20110203140354-mjn83xnhc3yhkqhs
            date: 2011-02-03 16:03:54 +0200
            build-date: 2011-02-03 19:43:39 +0200
            revno: 3031
            branch-nick: 5.1
            ------------------------------------------------------------
            revno: 3031
            committer: Michael Widenius <monty@askmonty.org>
            branch nick: maria-5.1
            timestamp: Thu 2011-02-03 16:03:54 +0200
            message:
            Added missing header file strings_def.h to dist

            RQG command lines:

            /home/buildbot/randgen/runall.pl \
            --queries=1M \
            --engine=Maria \
            -mysqld=-default-storage-engine=Maria \
            -mysqld=-safe-mode \
            -mysqld=-loose-debug-assert-if-crashed-table \
            -mysqld=-sync-sys=0 \
            -mysqld=-log-output=file \
            -mysqld=-maria_log_purge_type=at_flush \
            --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
            --duration=30 \
            --threads=10 \
            --rows=100 \
            --mask-level=0 \
            -mysqld=-loose-maria-group-commit=hard \
            -mysqld=-loose-maria_group_commit_interval=0 \
            -mysqld=-maria-checkpoint-interval=1 \
            -mysqld=-maria-block-size=16K \
            --queries=100000000 \
            --mask=5570 \
            --seed=1296764661 \
            --basedir=. \
            -mysqld=-init-file=/home/buildbot/randgen/conf/smf/smf2.sql \
            --grammar=conf/smf/smf2.yy

            and

            runall.pl \
            --queries=1M \
            --engine=Maria \
            -mysqld=-default-storage-engine=Maria \
            -mysqld=-safe-mode \
            -mysqld=-loose-debug-assert-if-crashed-table \
            -mysqld=-sync-sys=0 \
            -mysqld=-log-output=file \
            -mysqld=-maria_log_purge_type=at_flush \
            --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
            --duration=120 \
            --threads=20 \
            --rows=10000 \
            --mask-level=0 \
            -mysqld=-loose-maria-group-commit=hard \
            -mysqld=-loose-maria_group_commit_interval=0 \
            -mysqld=-maria-checkpoint-interval=1 \
            -mysqld=-maria-block-size=4K \
            --queries=100000000 \
            --mask=42425 \
            --seed=1296796973 \
            --basedir=. \
            -mysqld=-init-file=/home/buildbot/randgen/conf/smf/smf2.sql \
            --grammar=conf/smf/smf2.yy

            Show
            philipstoev Philip Stoev added a comment - Re: Aria table "is marked as crashed and should be repaired" Unforuntately this is still repeatable with the following revision: revision-id: monty@askmonty.org-20110203140354-mjn83xnhc3yhkqhs date: 2011-02-03 16:03:54 +0200 build-date: 2011-02-03 19:43:39 +0200 revno: 3031 branch-nick: 5.1 ------------------------------------------------------------ revno: 3031 committer: Michael Widenius <monty@askmonty.org> branch nick: maria-5.1 timestamp: Thu 2011-02-03 16:03:54 +0200 message: Added missing header file strings_def.h to dist RQG command lines: /home/buildbot/randgen/runall.pl \ --queries=1M \ --engine=Maria \ - mysqld= -default-storage-engine=Maria \ - mysqld= -safe-mode \ - mysqld= -loose-debug-assert-if-crashed-table \ - mysqld= -sync-sys=0 \ - mysqld= -log-output=file \ - mysqld= -maria_log_purge_type=at_flush \ --reporters=ErrorLog,Backtrace,Recovery,Shutdown \ --duration=30 \ --threads=10 \ --rows=100 \ --mask-level=0 \ - mysqld= -loose-maria-group-commit=hard \ - mysqld= -loose-maria_group_commit_interval=0 \ - mysqld= -maria-checkpoint-interval=1 \ - mysqld= -maria-block-size=16K \ --queries=100000000 \ --mask=5570 \ --seed=1296764661 \ --basedir=. \ - mysqld= -init-file=/home/buildbot/randgen/conf/smf/smf2.sql \ --grammar=conf/smf/smf2.yy and runall.pl \ --queries=1M \ --engine=Maria \ - mysqld= -default-storage-engine=Maria \ - mysqld= -safe-mode \ - mysqld= -loose-debug-assert-if-crashed-table \ - mysqld= -sync-sys=0 \ - mysqld= -log-output=file \ - mysqld= -maria_log_purge_type=at_flush \ --reporters=ErrorLog,Backtrace,Recovery,Shutdown \ --duration=120 \ --threads=20 \ --rows=10000 \ --mask-level=0 \ - mysqld= -loose-maria-group-commit=hard \ - mysqld= -loose-maria_group_commit_interval=0 \ - mysqld= -maria-checkpoint-interval=1 \ - mysqld= -maria-block-size=4K \ --queries=100000000 \ --mask=42425 \ --seed=1296796973 \ --basedir=. \ - mysqld= -init-file=/home/buildbot/randgen/conf/smf/smf2.sql \ --grammar=conf/smf/smf2.yy
            Hide
            monty Michael Widenius added a comment -

            Re: Aria table "is marked as crashed and should be repaired"
            I have recently fixed several similar cases in Aria in 5.2
            I did run the last test for some time s to verify this and as I got no errors I will close this bug report.

            Show
            monty Michael Widenius added a comment - Re: Aria table "is marked as crashed and should be repaired" I have recently fixed several similar cases in Aria in 5.2 I did run the last test for some time s to verify this and as I got no errors I will close this bug report.
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 670356

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

              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: