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

LP:608369 - (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' 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

          After recovery after kill -9 , CHECK TABLE EXTENDED on a (M)Aria table reports the following:

          'Page: 1 Found wrong page type 0'

          the error log says:

          100721 19:13:29 [ERROR] mysqld: Table './test/table100_maria_key_pk_parts_2_int_autoinc#P#p0' is marked as crashed and should be repaired
          19:13:29 [Note] Zerofilling table: './test/table100_maria_key_pk_parts_2_int_autoinc'
          19:13:29 [Note] Zerofilling table: './test/table100_maria_key_pk_parts_2_int_autoinc'

          RQG command line:

          /home/buildbot/randgen/runall.pl \
          --grammar=conf/engines/engine_stress.yy \
          --gendata=conf/engines/engine_stress.zz \
          --queries=1M \
          --engine=Maria \
          -mysqld=-log-output=file \
          -mysqld=-debug \
          --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
          --duration=240 \
          --threads=5 \
          --rows=100 \
          --mask-level=2 \
          -mysqld=-maria-group-commit=hard \
          -mysqld=-maria_group_commit_interval=1 \
          -mysqld=-maria-checkpoint-interval=1 \
          -mysqld=-maria-block-size=16K \
          --mask=32308 \
          --queries=100000000 \
          --basedir=. \
          --seed=time \
          --vardir=/home/buildbot/rqg-buildbot-slave/rqg-weekend/vardir-maria_recovery_weekend/current

          The datadir will be uploaded shortly.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                5 older comments
                Hide
                Permalink
                philipstoev Philip Stoev added a comment -

                Re: (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED
                A Fresh vardir from a recent MariaDB 5.1

                Show
                philipstoev Philip Stoev added a comment - Re: (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED A Fresh vardir from a recent MariaDB 5.1
                Hide
                Permalink
                philipstoev Philip Stoev added a comment -

                recent datadir
                LPexportBug608369_var-bug608369-2.zip

                Show
                philipstoev Philip Stoev added a comment - recent datadir LPexportBug608369_var-bug608369-2.zip
                Hide
                Permalink
                philipstoev Philip Stoev added a comment -

                Re: (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED

                Show
                philipstoev Philip Stoev added a comment - Re: (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED
                Hide
                Permalink
                monty Michael Widenius added a comment -

                Re: (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED
                Found one problem running the test suite that could explain this issue.
                Fix is pushed in 5.1

                Show
                monty Michael Widenius added a comment - Re: (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED Found one problem running the test suite that could explain this issue. Fix is pushed in 5.1
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 608369

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

                  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: