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

innodb assertion - trx_undo_t *trx_undo_mem_create_at_db_start(trx_rseg_t *, ulint, ulint, mtr_t *): Assertion `type == 2' faile




      Crash in debug builds, not in release builds.

      Datadir in attachment in MDEV-24122:

      cat ~/Downloads/affected_datadir.tar.xz.parta{a,b} > /tmp/affected_datadir.tar.xz
      tar -axf /tmp/affected_datadir.tar.xz

      $ gdb --args sql/mysqld --no-defaults --skip-networking --datadir=/tmp/affected_datadir/
      GNU gdb (GDB) Fedora 9.1-6.fc32
      Copyright (C) 2020 Free Software Foundation, Inc.
      License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
      This is free software: you are free to change and redistribute it.
      There is NO WARRANTY, to the extent permitted by law.
      Type "show copying" and "show warranty" for details.
      This GDB was configured as "x86_64-redhat-linux-gnu".
      Type "show configuration" for configuration details.
      For bug reporting instructions, please see:
      Find the GDB manual and other documentation resources online at:
      For help, type "help".
      Type "apropos word" to search for commands related to "word"...
      Reading symbols from sql/mysqld...
      (gdb) bt
      No stack.
      (gdb) r
      Starting program: /home/dan/repos/build-mariadb-server-10.2-debug/sql/mysqld --no-defaults --skip-networking --datadir=/tmp/affected_datadir/
      [Thread debugging using libthread_db enabled]
      Using host libthread_db library "/lib64/libthread_db.so.1".
      2020-11-06 11:59:29 140737341138880 [Note] /home/dan/repos/build-mariadb-server-10.2-debug/sql/mysqld (mysqld 10.2.35-MariaDB-debug) starting as process 138885 ...
      [New Thread 0x7ffff721f700 (LWP 138889)]
      2020-11-06 11:59:29 140737341138880 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
      2020-11-06 11:59:29 140737341138880 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2020-11-06 11:59:29 140737341138880 [Note] InnoDB: Uses event mutexes
      2020-11-06 11:59:29 140737341138880 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2020-11-06 11:59:29 140737341138880 [Note] InnoDB: Using Linux native AIO
      2020-11-06 11:59:29 140737341138880 [Note] InnoDB: Number of pools: 1
      2020-11-06 11:59:29 140737341138880 [Note] InnoDB: Using SSE2 crc32 instructions
      2020-11-06 11:59:29 140737341138880 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
      2020-11-06 11:59:29 140737341138880 [Note] InnoDB: Completed initialization of buffer pool
      [New Thread 0x7fffdf177700 (LWP 138890)]
      [New Thread 0x7fffde976700 (LWP 138891)]
      [New Thread 0x7fffde175700 (LWP 138892)]
      [New Thread 0x7fffdd974700 (LWP 138893)]
      [New Thread 0x7fffdd173700 (LWP 138894)]
      [New Thread 0x7fffdc972700 (LWP 138895)]
      [New Thread 0x7fffdc171700 (LWP 138896)]
      [New Thread 0x7fffdb970700 (LWP 138897)]
      [New Thread 0x7fffdb16f700 (LWP 138898)]
      [New Thread 0x7fffda96e700 (LWP 138899)]
      [New Thread 0x7fffda16d700 (LWP 138900)]
      2020-11-06 11:59:29 140736852317952 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2020-11-06 11:59:29 140737341138880 [Note] InnoDB: Highest supported file format is Barracuda.
      mysqld: /home/dan/repos/mariadb-server-10.2/storage/innobase/trx/trx0undo.cc:1220: trx_undo_t *trx_undo_mem_create_at_db_start(trx_rseg_t *, ulint, ulint, mtr_t *): Assertion `type == 2' failed.
      Thread 1 "mysqld" received signal SIGABRT, Aborted.
      __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      50	  return ret;
      Missing separate debuginfos, use: dnf debuginfo-install libgcc-10.2.1-6.fc32.x86_64 libstdc++-10.2.1-6.fc32.x86_64 openssl-libs-1.1.1g-1.fc32.x86_64
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x00007ffff7516895 in __GI_abort () at abort.c:79
      #2  0x00007ffff7516769 in __assert_fail_base (fmt=0x7ffff76840b8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", 
          assertion=0x148fe17 "type == 2", file=0x148fa70 "/home/dan/repos/mariadb-server-10.2/storage/innobase/trx/trx0undo.cc", 
          line=1220, function=<optimized out>) at assert.c:92
      #3  0x00007ffff7525e76 in __GI___assert_fail (assertion=0x148fe17 "type == 2", 
          file=0x148fa70 "/home/dan/repos/mariadb-server-10.2/storage/innobase/trx/trx0undo.cc", line=1220, 
          function=0x14902d7 "trx_undo_t *trx_undo_mem_create_at_db_start(trx_rseg_t *, ulint, ulint, mtr_t *)") at assert.c:101
      #4  0x0000000000ed7bed in trx_undo_mem_create_at_db_start (rseg=0x2ce6bb0, id=0, page_no=269, mtr=0x7fffffff22a0)
          at /home/dan/repos/mariadb-server-10.2/storage/innobase/trx/trx0undo.cc:1220
      #5  0x0000000000ed730a in trx_undo_lists_init (rseg=0x2ce6bb0)
          at /home/dan/repos/mariadb-server-10.2/storage/innobase/trx/trx0undo.cc:1269
      #6  0x0000000000ebb909 in trx_rseg_mem_restore (rseg=0x2ce6bb0, mtr=0x7fffffff28a0)
          at /home/dan/repos/mariadb-server-10.2/storage/innobase/trx/trx0rseg.cc:193
      #7  0x0000000000ebb4f1 in trx_rseg_array_init () at /home/dan/repos/mariadb-server-10.2/storage/innobase/trx/trx0rseg.cc:253
      #8  0x0000000000ec4a8d in trx_lists_init_at_db_start () at /home/dan/repos/mariadb-server-10.2/storage/innobase/trx/trx0trx.cc:981
      #9  0x0000000000ebf04a in trx_sys_init_at_db_start () at /home/dan/repos/mariadb-server-10.2/storage/innobase/trx/trx0sys.cc:500
      #10 0x0000000000e6d3dc in innobase_start_or_create_for_mysql ()
          at /home/dan/repos/mariadb-server-10.2/storage/innobase/srv/srv0start.cc:2223
      #11 0x0000000000c7a882 in innobase_init (p=0x2466470)
          at /home/dan/repos/mariadb-server-10.2/storage/innobase/handler/ha_innodb.cc:4303
      #12 0x00000000009fae86 in ha_initialize_handlerton (plugin=0x243a018) at /home/dan/repos/mariadb-server-10.2/sql/handler.cc:555
      #13 0x0000000000730b0d in plugin_initialize (tmp_root=0x7fffffffd080, plugin=0x243a018, argc=0x1b479d0 <remaining_argc>, 
          argv=0x23f67e8, options_only=false) at /home/dan/repos/mariadb-server-10.2/sql/sql_plugin.cc:1417
      #14 0x000000000073047a in plugin_init (argc=0x1b479d0 <remaining_argc>, argv=0x23f67e8, flags=0)
          at /home/dan/repos/mariadb-server-10.2/sql/sql_plugin.cc:1698
      #15 0x00000000005eb44b in init_server_components () at /home/dan/repos/mariadb-server-10.2/sql/mysqld.cc:5392
      #16 0x00000000005e7653 in mysqld_main (argc=4, argv=0x23f67e8) at /home/dan/repos/mariadb-server-10.2/sql/mysqld.cc:5990
      #17 0x00000000005e3362 in main (argc=4, argv=0x7fffffffdab8) at /home/dan/repos/mariadb-server-10.2/sql/main.cc:25


          Issue Links



              marko Marko Mäkelä
              danblack Daniel Black
              0 Vote for this issue
              4 Start watching this issue



                  Git Integration

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