Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19813 Aria crash recovery failures
  3. MDEV-20132

Assertion `info->new_row.checksum == (*share->calc_checksum)(info, current_record)' failed in _ma_apply_undo_row_update upon recovery

    XMLWordPrintable

Details

    Description

      10.4 819c40d6

      2019-07-23 19:20:39 0 [Note] mysqld: Aria engine: starting recovery
      recovered pages: 0% 10% 9% 19% 29% 39% 49% 59% 58% 68% 78% 88% 98% 100% (15.5 seconds); transactions to roll back: 2mysqld: /data/src/10.4/storage/maria/ma_blockrec.c:7444: _ma_apply_undo_row_update: Assertion `info->new_row.checksum == (*share->calc_checksum)(info, current_record)' failed.
      190723 19:20:55 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fe83a706f12 in __GI___assert_fail (assertion=0x55ccd3e424c0 "info->new_row.checksum == (*share->calc_checksum)(info, current_record)", file=0x55ccd3e409a0 "/data/src/10.4/storage/maria/ma_blockrec.c", line=7444, function=0x55ccd3e42b60 <__PRETTY_FUNCTION__.17281> "_ma_apply_undo_row_update") at assert.c:101
      #8  0x000055ccd388f4dd in _ma_apply_undo_row_update (info=0x55ccd63fea60, undo_lsn=4373857193, header=0x55ccd62b3162 "", header_length=25) at /data/src/10.4/storage/maria/ma_blockrec.c:7443
      #9  0x000055ccd3854d8b in exec_UNDO_LOGREC_UNDO_ROW_UPDATE (rec=0x7ffe5ef16780, trn=0x55ccd62b7f90) at /data/src/10.4/storage/maria/ma_recovery.c:2391
      #10 0x000055ccd3856643 in run_undo_phase (uncommitted=1) at /data/src/10.4/storage/maria/ma_recovery.c:2968
      #11 0x000055ccd3850384 in maria_apply_log (from_lsn=4351678081, end_lsn=0, apply=MARIA_LOG_APPLY, trace_file=0x0, should_run_undo_phase=1 '\001', skip_DDLs_arg=1 '\001', take_checkpoints=1 '\001', warnings_count=0x7ffe5ef16c90) at /data/src/10.4/storage/maria/ma_recovery.c:422
      #12 0x000055ccd384fe58 in maria_recovery_from_log () at /data/src/10.4/storage/maria/ma_recovery.c:240
      #13 0x000055ccd3821f45 in ha_maria_init (p=0x55ccd6296cc0) at /data/src/10.4/storage/maria/ha_maria.cc:3606
      #14 0x000055ccd3221762 in ha_initialize_handlerton (plugin=0x55ccd6287588) at /data/src/10.4/sql/handler.cc:557
      #15 0x000055ccd2efedff in plugin_initialize (tmp_root=0x7ffe5ef170c0, plugin=0x55ccd6287588, argc=0x55ccd47591d8 <remaining_argc>, argv=0x55ccd6225a48, options_only=false) at /data/src/10.4/sql/sql_plugin.cc:1438
      #16 0x000055ccd2effaa7 in plugin_init (argc=0x55ccd47591d8 <remaining_argc>, argv=0x55ccd6225a48, flags=0) at /data/src/10.4/sql/sql_plugin.cc:1720
      #17 0x000055ccd2db5ce3 in init_server_components () at /data/src/10.4/sql/mysqld.cc:5203
      #18 0x000055ccd2db6eae in mysqld_main (argc=14, argv=0x55ccd6225a48) at /data/src/10.4/sql/mysqld.cc:5726
      #19 0x000055ccd2dab740 in main (argc=14, argv=0x7ffe5ef17b08) at /data/src/10.4/sql/main.cc:25
      

      To reproduce:

      • download the datadir from ftp://perro.askmonty.org/public/jira/mdev20132_data.tar.gz, unpack;
      • start 10.4 server on the datadir with

        --aria-encrypt-tables=1 --plugin-load-add=file_key_management --file-key-management-filename=`pwd`/mysql-test/std_data/keys.txt
        

        (modify the path to keys.txt if necessary, to point at <basedir>/mysql-test/std_data/keys.txt)

      The datadir was created on 10.4 server, so it requires 10.4 to reproduce. I have no information whether previous versions are affected.
      The general log of the session when the datadir was created is attached.

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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