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

LP:602604 - RQG: ma_blockrec.c:6187: _ma_apply_redo_insert_row_head_or_tail: Assertion `0' failed on Maria engine recovery

    XMLWordPrintable

Details

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

    Description

      Mysql bug #43014 is still repeatable with Maria 5.2. On recovery of a table containing a lot of indexes on big fields, the following assertion occurs:

      mysqld: ma_blockrec.c:6187: _ma_apply_redo_insert_row_head_or_tail: Assertion `0' failed.

      #8 0x00897de8 in __assert_fail () from /lib/libc.so.6
      #9 0x0855b590 in _ma_apply_redo_insert_row_head_or_tail (info=0xa02c818, lsn=4296390922, page_type=1, new_page=0 '\000', header=0xa003ee2 "\003",
      data=0xa003ee8 "", data_length=1968) at ma_blockrec.c:6187
      #10 0x085a453e in exec_REDO_LOGREC_REDO_INSERT_ROW_HEAD (rec=0xbfabfa60) at ma_recovery.c:1373
      #11 0x085a26db in display_and_apply_record (log_desc=0x9261528, rec=0xbfabfa60) at ma_recovery.c:528
      #12 0x085a6fe3 in run_redo_phase (lsn=4294975495, apply=MARIA_LOG_APPLY) at ma_recovery.c:2518
      #13 0x085a2047 in maria_apply_log (from_lsn=4294975495, apply=MARIA_LOG_APPLY, trace_file=0x9fbf7a0, should_run_undo_phase=1 '\001', skip_DDLs_arg=1 '\001',
      take_checkpoints=1 '\001', warnings_count=0xbfac25e4) at ma_recovery.c:317
      #14 0x085a1d28 in maria_recovery_from_log () at ma_recovery.c:218
      #15 0x08527735 in ha_maria_init (p=0x9fb13a0) at ha_maria.cc:3251
      #16 0x0839ed0d in ha_initialize_handlerton (plugin=0x9fa3090) at handler.cc:430
      #17 0x0845b23b in plugin_initialize (plugin=0x9fa3090) at sql_plugin.cc:1239
      #18 0x0845bab1 in plugin_init (argc=0x8a4a6d8, argv=0x9f71590, flags=0) at sql_plugin.cc:1467
      #19 0x0826eb4b in init_server_components () at mysqld.cc:4126
      #20 0x0826f611 in main (argc=16, argv=0xbfac2be4) at mysqld.cc:4600

      Datadir from before recovery:

      http://bugs.mysql.com/file.php?id=11479

      RQG command line:

      1. 2010-07-07T02:01:39 # runall.pl \
      2. 2010-07-07T02:01:39 # --basedir=/home/philips/bzr/5.2/ \
      3. 2010-07-07T02:01:39 # --grammar=conf/engines/many_indexes.yy \
      4. 2010-07-07T02:01:39 # --gendata=conf/engines/many_indexes.zz \
      5. 2010-07-07T02:01:39 # --reporter=Recovery \
      6. 2010-07-07T02:01:39 # --duration=30 \
      7. 2010-07-07T02:01:39 # --queries=1M \
      8. 2010-07-07T02:01:39 # --engine=Maria \
      9. 2010-07-07T02:01:39 # --rows=1000 \
      10. 2010-07-07T02:01:39 # -mysqld=-maria-checkpoint-interval=0 \
      11. 2010-07-07T02:01:39 # -mysqld=-log-output=file \
      12. 2010-07-07T02:01:39 # --vardir=/home/philips/tmp/z2 \
      13. 2010-07-07T02:01:39 # -mysqld=-loose-skip-innnodb \
      14. 2010-07-07T02:01:39 # --seed=time

      Attachments

        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.