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

LP:602169 - RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery

    Details

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

      Description

      When recovering from a kill -9 crash that happened during a DML workload, maria 5.3 crashed as follows:

      #8 0x00897de8 in __assert_fail () from /lib/libc.so.6
      #9 0x08557165 in _ma_apply_redo_index (info=0x9c94d60, lsn=4297618642, header=0x9c75816 "\346\017\271*\267\273", head_length=18) at ma_key_recover.c:987
      #10 0x085bda51 in exec_REDO_LOGREC_REDO_INDEX (rec=0xbfe2a8b0) at ma_recovery.c:1571
      #11 0x085bb5db in display_and_apply_record (log_desc=0x9265440, rec=0xbfe2a8b0) at ma_recovery.c:517
      #12 0x085bfee3 in run_redo_phase (lsn=4294975495, apply=MARIA_LOG_APPLY) at ma_recovery.c:2507
      #13 0x085baf94 in maria_apply_log (from_lsn=4294975495, apply=MARIA_LOG_APPLY, trace_file=0x9c251a0, should_run_undo_phase=1 '\001', skip_DDLs_arg=1 '\001',
      take_checkpoints=1 '\001', warnings_count=0xbfe2d434) at ma_recovery.c:316
      #14 0x085bac7c in maria_recovery_from_log () at ma_recovery.c:218
      #15 0x085404f3 in ha_maria_init (p=0x9c16dd0) at ha_maria.cc:3265
      #16 0x083b9d09 in ha_initialize_handlerton (plugin=0x9c08f08) at handler.cc:429
      #17 0x08473e5f in plugin_initialize (plugin=0x9c08f08) at sql_plugin.cc:1038
      #18 0x084746d5 in plugin_init (argc=0x8a4e318, argv=0x9bdba40, flags=0) at sql_plugin.cc:1267
      #19 0x0827a0ec in init_server_components () at mysqld.cc:4113
      #20 0x0827abb2 in main (argc=14, argv=0xbfe2da24) at mysqld.cc:4587

      The tablespaces before and after recovery will be uploaded shortly.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            philipstoev Philip Stoev added a comment -

            Re: RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery
            Please ignore last attachment, it was for a different bug. Please use the first , original attachment when debugging this bug.

            Show
            philipstoev Philip Stoev added a comment - Re: RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery Please ignore last attachment, it was for a different bug. Please use the first , original attachment when debugging this bug.
            Hide
            philipstoev Philip Stoev added a comment -

            Re: RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery
            RQG command line:

            1. 2010-08-25T02:11:48 # /home/buildbot/randgen/runall.pl \
            2. 2010-08-25T02:11:48 # --basedir=. \
            3. 2010-08-25T02:11:48 # --vardir=../../vardir-maria_varchar \
            4. 2010-08-25T02:11:48 # --grammar=/home/buildbot/randgen/conf/engines/varchar.yy \
            5. 2010-08-25T02:11:48 # --gendata=/home/buildbot/randgen/conf/engines/varchar.zz \
            6. 2010-08-25T02:11:48 # --reporter=Backtrace,ErrorLog,Recovery,Shutdown \
            7. 2010-08-25T02:11:48 # --duration=240 \
            8. 2010-08-25T02:11:48 # --queries=1M \
            9. 2010-08-25T02:11:48 # --engine=Maria \
            10. 2010-08-25T02:11:48 # -mysqld=-maria-checkpoint-interval=0 \
            11. 2010-08-25T02:11:48 # -mysqld=-log-output=file \
            12. 2010-08-25T02:11:48 # --seed=time \
            13. 2010-08-25T02:11:48 # -mysqld=-loose-skip-innodb \
            14. 2010-08-25T02:11:48 # -mysqld=-loose-pbxt=OFF

            This bug is readily repeatable in buildbot on the varchar.yy test.

            Show
            philipstoev Philip Stoev added a comment - Re: RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery RQG command line: 2010-08-25T02:11:48 # /home/buildbot/randgen/runall.pl \ 2010-08-25T02:11:48 # --basedir=. \ 2010-08-25T02:11:48 # --vardir=../../vardir-maria_varchar \ 2010-08-25T02:11:48 # --grammar=/home/buildbot/randgen/conf/engines/varchar.yy \ 2010-08-25T02:11:48 # --gendata=/home/buildbot/randgen/conf/engines/varchar.zz \ 2010-08-25T02:11:48 # --reporter=Backtrace,ErrorLog,Recovery,Shutdown \ 2010-08-25T02:11:48 # --duration=240 \ 2010-08-25T02:11:48 # --queries=1M \ 2010-08-25T02:11:48 # --engine=Maria \ 2010-08-25T02:11:48 # - mysqld= -maria-checkpoint-interval=0 \ 2010-08-25T02:11:48 # - mysqld= -log-output=file \ 2010-08-25T02:11:48 # --seed=time \ 2010-08-25T02:11:48 # - mysqld= -loose-skip-innodb \ 2010-08-25T02:11:48 # - mysqld= -loose-pbxt=OFF This bug is readily repeatable in buildbot on the varchar.yy test.
            Hide
            philipstoev Philip Stoev added a comment -

            datadir with latest maria debuging code
            LPexportBug602169_var-bug602169-2.zip

            Show
            philipstoev Philip Stoev added a comment - datadir with latest maria debuging code LPexportBug602169_var-bug602169-2.zip
            Hide
            philipstoev Philip Stoev added a comment -

            Re: RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery

            Show
            philipstoev Philip Stoev added a comment - Re: RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 602169

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

              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: