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

LP:636872 - "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery

    Details

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

      Description

      After recovering using mysqld from the SMF RQG scenario, the server reported the following:

      1. 2010-09-13T09:13:39 100913 9:13:39 [Warning] Checking table: './smf2/smf_boards'
      2. 2010-09-13T09:13:39 100913 9:13:39 [Warning] Recovering table: './smf2/smf_boards'
      3. 2010-09-13T09:13:39 100913 9:13:39 [Note] Found 296 of 287 rows when repairing './smf2/smf_boards'

      CHECK TABLE EXTENDED reported the following:
      Record at pos: 66248 is not remove-marked
      record delete-link-chain corrupted

      bzr version-info:

      revision-id: <email address hidden>
      date: 2010-09-12 21:25:57 -0700
      build-date: 2010-09-13 08:44:46 +0300
      revno: 2931
      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=20 \
      --rows=10 \
      --mask-level=2 \
      -mysqld=-maria-repair-threads=2 \
      -mysqld=-loose-maria-group-commit=hard \
      -mysqld=-loose-maria_group_commit_interval=0 \
      -mysqld=-maria-checkpoint-interval=0 \
      -mysqld=-maria-block-size=4K \
      --mask=35049 \
      --queries=100000000 \
      --mask=35049 \
      --seed=time \
      --basedir=. \
      -mysqld=-init-file=/home/buildbot/randgen/conf/smf/smf2.sql \
      --grammar=conf/smf/smf2.yy

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            philipstoev Philip Stoev added a comment -

            datadir , logs , etc.
            LPexportBug636872_var-bug636872.zip

            Show
            philipstoev Philip Stoev added a comment - datadir , logs , etc. LPexportBug636872_var-bug636872.zip
            Hide
            philipstoev Philip Stoev added a comment -

            Re: "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery

            Show
            philipstoev Philip Stoev added a comment - Re: "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery
            Hide
            philipstoev Philip Stoev added a comment -

            Re: "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery
            .yy and .sql files are at hasky.askmonty.org://home/pstoev/bug636872

            Show
            philipstoev Philip Stoev added a comment - Re: "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery .yy and .sql files are at hasky.askmonty.org://home/pstoev/bug636872
            Hide
            philipstoev Philip Stoev added a comment -

            Re: "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery
            It turns out that the problematic tables were MyISAM, so their recovery is not guaranteed.

            Show
            philipstoev Philip Stoev added a comment - Re: "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery It turns out that the problematic tables were MyISAM, so their recovery is not guaranteed.
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 636872

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

              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: