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

LP:634966 - maria_read_log: ma_blockrec.c:6214: _ma_apply_redo_insert_row_head_or_tail: Assertion `rownr == 0 && new_page' failed on Aria recovery

    Details

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

      Description

      When using maria_read_log to recover from scratch from the varchar RQG scenario, the tool reported the following:

      /home/buildbot/rqg-buildbot-slave/rqg-weekend/build/mysql-test//../storage/maria/maria_read_log: Maria engine: starting recovery
      recovered pages: 0%maria_read_log: ma_blockrec.c:6214: _ma_apply_redo_insert_row_head_or_tail: Assertion `rownr == 0 && new_page' failed.

      bzr version-info:

      revision-id: <email address hidden>
      date: 2010-09-07 19:58:39 +0300
      build-date: 2010-09-09 18:39:03 +0300
      revno: 2924
      branch-nick: 5.1

      rqg command-line:

      perl /home/buildbot/randgen/runall.pl -queries=1M --engine=Maria --mysqld=log-output=file --mysqld=maria_log_purge_type=at_flush --reporters=ErrorLog,Backtrace,Recovery,Shutdown --duration=120 --threads=1 --rows=1 --mask-level=2 --mysqld=loose-maria-group-commit=hard --mysqld=loose-maria_group_commit_interval=0 --mysqld=maria-checkpoint-interval=0 --mysqld=-maria-block-size=16K --mask=62531 --queries=100000000 --mask=62531 --seed=time --basedir=. --vardir=/home/buildbot/rqg-buildbot-slave/rqg-weekend/vardir-maria_recovery_weekend/current --grammar=conf/engines/varchar.yy --gendata=conf/engines/varchar.zz

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            philipstoev Philip Stoev added a comment -

            datadir, logs, etc.
            LPexportBug634966_var-bug634966.zip

            Show
            philipstoev Philip Stoev added a comment - datadir, logs, etc. LPexportBug634966_var-bug634966.zip
            Hide
            philipstoev Philip Stoev added a comment -

            Re: maria_read_log: ma_blockrec.c:6214: _ma_apply_redo_insert_row_head_or_tail: Assertion `rownr == 0 && new_page' failed on Aria recovery

            Show
            philipstoev Philip Stoev added a comment - Re: maria_read_log: ma_blockrec.c:6214: _ma_apply_redo_insert_row_head_or_tail: Assertion `rownr == 0 && new_page' failed on Aria recovery
            Hide
            monty Michael Widenius added a comment -

            Re: maria_read_log: ma_blockrec.c:6214: _ma_apply_redo_insert_row_head_or_tail: Assertion `rownr == 0 && new_page' failed on Aria recovery
            I can't repeat the problem either with RQG command line or with the given data files.

            One can't reliably run maria_read_log on an empty dir as mysqld wasn't started with the --safe-mode option.
            However, even while doing that, I don't get the given error.

            Note also that my last fix in 5.1 tree regarding "When reopening table during recovery, don't set file length from file sizes as file is not flushed" fixed a symptom identical to this bug.

            Show
            monty Michael Widenius added a comment - Re: maria_read_log: ma_blockrec.c:6214: _ma_apply_redo_insert_row_head_or_tail: Assertion `rownr == 0 && new_page' failed on Aria recovery I can't repeat the problem either with RQG command line or with the given data files. One can't reliably run maria_read_log on an empty dir as mysqld wasn't started with the --safe-mode option. However, even while doing that, I don't get the given error. Note also that my last fix in 5.1 tree regarding "When reopening table during recovery, don't set file length from file sizes as file is not flushed" fixed a symptom identical to this bug.
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 634966

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

              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: