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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • None
    • None

    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.

      Attachments

        1. LPexportBug608369.xml
          11 kB
          Rasmus Johansson

        Activity

          People

            monty Michael Widenius
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.