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

LP:607284 - Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED

    Details

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

      Description

      When executing CHECK TABLE EXTENDED after a kill -9 + recovery , the server reports:

      Record-count is not ok; found 342 Should be: 438

      The tablespace before and after recovery will be uploaded shortly

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            philipstoev Philip Stoev added a comment -

            This issue has been observed 3 times so far, each time with --maria-block-size=1K
            Datadir for bug 607284
            LPexportBug607284_var-bug607284.zip

            Show
            philipstoev Philip Stoev added a comment - This issue has been observed 3 times so far, each time with --maria-block-size=1K Datadir for bug 607284 LPexportBug607284_var-bug607284.zip
            Hide
            philipstoev Philip Stoev added a comment -

            Re: Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED
            This issue has been observed 3 times so far, each time with --maria-block-size=1K

            Show
            philipstoev Philip Stoev added a comment - Re: Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED This issue has been observed 3 times so far, each time with --maria-block-size=1K
            Hide
            philipstoev Philip Stoev added a comment -

            Re: Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED
            RQG command line:

            perl runall.pl \
            --grammar=conf/engines/engine_stress.yy \
            --gendata=conf/engines/engine_stress.zz \
            --queries=1M \
            --engine=Maria \
            -mysqld=-log-output=file \
            -mysqld=-log-bin \
            --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
            --duration=360 \
            --threads=1 \
            --rows=10 \
            --mask-level=1 \
            -mysqld=-maria-repair-threads=2 \
            -mysqld=-loose-maria-group-commit=soft \
            -mysqld=-loose-maria_group_commit_interval=1000000 \
            -mysqld=-maria-checkpoint-interval=1 \
            -mysqld=-maria-block-size=1K \
            --mask=24165 \
            --queries=100000000 \
            --basedir=. \
            --seed=1282735012

            Show
            philipstoev Philip Stoev added a comment - Re: Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED RQG command line: perl runall.pl \ --grammar=conf/engines/engine_stress.yy \ --gendata=conf/engines/engine_stress.zz \ --queries=1M \ --engine=Maria \ - mysqld= -log-output=file \ - mysqld= -log-bin \ --reporters=ErrorLog,Backtrace,Recovery,Shutdown \ --duration=360 \ --threads=1 \ --rows=10 \ --mask-level=1 \ - mysqld= -maria-repair-threads=2 \ - mysqld= -loose-maria-group-commit=soft \ - mysqld= -loose-maria_group_commit_interval=1000000 \ - mysqld= -maria-checkpoint-interval=1 \ - mysqld= -maria-block-size=1K \ --mask=24165 \ --queries=100000000 \ --basedir=. \ --seed=1282735012
            Hide
            monty Michael Widenius added a comment -

            Re: Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED
            Have now run the test case for 2 hours on MariaDB 5.3 without any problems, so I have to assume that his bug has already been fixed.
            (I am quite sure that other similar bugs has been fixed since this bug was reported).

            Show
            monty Michael Widenius added a comment - Re: Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED Have now run the test case for 2 hours on MariaDB 5.3 without any problems, so I have to assume that his bug has already been fixed. (I am quite sure that other similar bugs has been fixed since this bug was reported).
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 607284

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

              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: