Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.2.35
-
None
Description
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:
|
<http://www.gnu.org/software/gdb/bugs/>.
|
Find the GDB manual and other documentation resources online at:
|
<http://www.gnu.org/software/gdb/documentation/>.
|
|
|
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
|
Attachments
Issue Links
- relates to
-
MDEV-12288 Reset DB_TRX_ID when the history is removed, to speed up MVCC
-
- Closed
-
Activity
The undo log format was changed in MDEV-12288. Yes, that is how it would look like after a downgrade.
This could be a valid bug: we could try to improve the handling in this case.
Also, we fail to check the type codes of the individual undo log records. We could and should add some downgrade-prevention there.
Were the ib_logfile* deleted by the user before downgrading? Normally we should detect and prevent a downgrade based on that.
The user only performed upgrades to 10.3.25 (list of upgrades in the 1st comment link). It was me that tried to run it unmodified (no ib_logfile* deletion) on a 10.2.latest. I wasn't looking at the innodb data so I can't say much more than than that.
We never claimed to support downgrades between major versions. MariaDB Server 10.2 reached end of life some years ago.
https://jira.mariadb.org/browse/MDEV-24122?focusedCommentId=171130&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-171130
This is a 10.3.25 data directory. Maybe this isn't a valid bug.