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

InnoDB: Failing assertion: lsn == log_sys->lsn || srv_force_recovery == SRV_FORCE_NO_LOG_REDO

Details

    Description

      Scenario is a part of the undo upgrade tests (MDEV-13269).

      • start an old server with --innodb-change-buffering=none, otherwise defaults;
      • create an InnoDB table, run some DML;
      • SIGKILL server;
      • restart the old server with --innodb-change-buffering=none --innodb-force-recovery=3;
      • shut down the server properly;
      • start the new server on the same datadir with --innodb-read-only;
      • shut down the server
        => observe the failure on shutdown

      Reproducible on bb-10.3-monty 6baa5e56f1, with current 10.2 4bca34d8a4d6 and with 10.3.0 as old servers; I didn't try other versions.

      The data directory from the old server (10.2 4bca34d8a4), pre-created as described, is attached. To reproduce, start the new server with --innodb-read-only on it.

      bb-10.3-monty 6baa5e56f1

      		 
      2017-08-09  1:06:42 0 [Note] InnoDB: Starting shutdown...
      		 
      2017-08-09 01:06:42 0x7f2bc00a4700  InnoDB: Assertion failure in file /data/src/bb-10.3-monty/storage/innobase/log/log0lo
      		 
      g.cc line 2114
      		 
      InnoDB: Failing assertion: lsn == log_sys->lsn || srv_force_recovery == SRV_FORCE_NO_LOG_REDO
      		 
       
      		 
      #6  0x00005594799e8ca1 in ut_dbg_assertion_failed (expr=0x559479eb6618 "lsn == log_sys->lsn || srv_force_recovery == SRV_FORCE_NO_LOG_REDO", file=0x559479eb5878 "/data/src/bb-10.3-monty/storage/innobase/log/log0log.cc", line=2114) at /data/src/bb-10.3-monty/storage/innobase/ut/ut0dbg.cc:60
      		 
      #7  0x00005594798639a1 in logs_empty_and_mark_files_at_shutdown () at /data/src/bb-10.3-monty/storage/innobase/log/log0log.cc:2113
      		 
      #8  0x000055947998ed98 in innodb_shutdown () at /data/src/bb-10.3-monty/storage/innobase/srv/srv0start.cc:2786
      		 
      #9  0x00005594797c836c in innobase_end () at /data/src/bb-10.3-monty/storage/innobase/handler/ha_innodb.cc:4347
      		 
      #10 0x00005594794b8fd1 in ha_finalize_handlerton (plugin=0x55947b764768) at /data/src/bb-10.3-monty/sql/handler.cc:452
      		 
      #11 0x00005594792227ac in plugin_deinitialize (plugin=0x55947b764768, ref_check=true) at /data/src/bb-10.3-monty/sql/sql_plugin.cc:1242
      		 
      #12 0x0000559479222c32 in reap_plugins () at /data/src/bb-10.3-monty/sql/sql_plugin.cc:1319
      		 
      #13 0x0000559479224ce0 in plugin_shutdown () at /data/src/bb-10.3-monty/sql/sql_plugin.cc:1986
      		 
      #14 0x000055947911dbed in clean_up (print_message=true) at /data/src/bb-10.3-monty/sql/mysqld.cc:2206
      		 
      #15 0x000055947911d7be in unireg_end () at /data/src/bb-10.3-monty/sql/mysqld.cc:2081
      		 
      #16 0x000055947911d6bb in kill_server (sig_ptr=0x0) at /data/src/bb-10.3-monty/sql/mysqld.cc:2008
      		 
      #17 0x000055947911d6fd in kill_server_thread (arg=0x7f2bc0181e50) at /data/src/bb-10.3-monty/sql/mysqld.cc:2031
      		 
      #18 0x00007f2bd781c494 in start_thread (arg=0x7f2bc00a4700) at pthread_create.c:333
      		 
      #19 0x00007f2bd599493f in clone () from /lib/x86_64-linux-gnu/libc.so.6

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13476 TRX_UNDO_PAGE_TYPE mismatch when writing undo log after upgrade

          • Major - Major loss of function.
          • Closed
          is caused by

          Task - A task that needs to be done. MDEV-12288 Reset DB_TRX_ID when the history is removed, to speed up MVCC

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13430 InnoDB upgrade from previous versions to 10.3 is not possible

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-13269 Upgrade tests for InnoDB undo log

          • Major - Major loss of function.
          • Closed

          Activity

            marko Marko Mäkelä added a comment -

            This regression was caused by MDEV-13430, which skips some redo log processing at startup when the redo log file format differs (and the redo log has been determined to be logically empty).

            marko Marko Mäkelä added a comment - This regression was caused by MDEV-13430 , which skips some redo log processing at startup when the redo log file format differs (and the redo log has been determined to be logically empty).

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.