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
|
- relates to
-
MDEV-12288
Reset DB_TRX_ID when the history is removed, to speed up MVCC
-
-
Closed
{"report":{"fcp":807,"ttfb":175.20000004768372,"pageVisibility":"visible","entityId":93594,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"74703cec-8328-426d-9d09-413169ed358d","navigationType":0,"readyForUser":879,"redirectCount":0,"resourceLoadedEnd":1065.2000000476837,"resourceLoadedStart":180.79999995231628,"resourceTiming":[{"duration":149.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":180.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":180.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":330.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":149.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":181.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":330.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":215.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":181.20000004768372,"connectEnd":181.20000004768372,"connectStart":181.20000004768372,"domainLookupEnd":181.20000004768372,"domainLookupStart":181.20000004768372,"fetchStart":181.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":181.20000004768372,"responseEnd":396.60000014305115,"responseStart":396.60000014305115,"secureConnectionStart":181.20000004768372},{"duration":287.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":181.29999995231628,"connectEnd":181.29999995231628,"connectStart":181.29999995231628,"domainLookupEnd":181.29999995231628,"domainLookupStart":181.29999995231628,"fetchStart":181.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":181.29999995231628,"responseEnd":468.60000014305115,"responseStart":468.60000014305115,"secureConnectionStart":181.29999995231628},{"duration":291.39999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":181.40000009536743,"connectEnd":181.40000009536743,"connectStart":181.40000009536743,"domainLookupEnd":181.40000009536743,"domainLookupStart":181.40000009536743,"fetchStart":181.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":181.40000009536743,"responseEnd":472.7999999523163,"responseStart":472.7999999523163,"secureConnectionStart":181.40000009536743},{"duration":291.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":181.5,"connectEnd":181.5,"connectStart":181.5,"domainLookupEnd":181.5,"domainLookupStart":181.5,"fetchStart":181.5,"redirectEnd":0,"redirectStart":0,"requestStart":181.5,"responseEnd":473.2000000476837,"responseStart":473.2000000476837,"secureConnectionStart":181.5},{"duration":292,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":181.60000014305115,"connectEnd":181.60000014305115,"connectStart":181.60000014305115,"domainLookupEnd":181.60000014305115,"domainLookupStart":181.60000014305115,"fetchStart":181.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":181.60000014305115,"responseEnd":473.60000014305115,"responseStart":473.60000014305115,"secureConnectionStart":181.60000014305115},{"duration":292.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":181.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":474.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":292.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":181.79999995231628,"connectEnd":181.79999995231628,"connectStart":181.79999995231628,"domainLookupEnd":181.79999995231628,"domainLookupStart":181.79999995231628,"fetchStart":181.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":181.79999995231628,"responseEnd":474.10000014305115,"responseStart":474,"secureConnectionStart":181.79999995231628},{"duration":292.7000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":181.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":474.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":292.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":182.10000014305115,"connectEnd":182.10000014305115,"connectStart":182.10000014305115,"domainLookupEnd":182.10000014305115,"domainLookupStart":182.10000014305115,"fetchStart":182.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":182.10000014305115,"responseEnd":474.60000014305115,"responseStart":474.60000014305115,"secureConnectionStart":182.10000014305115},{"duration":881.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":182.90000009536743,"connectEnd":182.90000009536743,"connectStart":182.90000009536743,"domainLookupEnd":182.90000009536743,"domainLookupStart":182.90000009536743,"fetchStart":182.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":182.90000009536743,"responseEnd":1064.1000001430511,"responseStart":1064.1000001430511,"secureConnectionStart":182.90000009536743},{"duration":877.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":187.40000009536743,"connectEnd":187.40000009536743,"connectStart":187.40000009536743,"domainLookupEnd":187.40000009536743,"domainLookupStart":187.40000009536743,"fetchStart":187.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":187.40000009536743,"responseEnd":1065.2000000476837,"responseStart":1065.2000000476837,"secureConnectionStart":187.40000009536743},{"duration":450,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":612.2000000476837,"connectEnd":612.2000000476837,"connectStart":612.2000000476837,"domainLookupEnd":612.2000000476837,"domainLookupStart":612.2000000476837,"fetchStart":612.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":612.2000000476837,"responseEnd":1062.2000000476837,"responseStart":1062.2000000476837,"secureConnectionStart":612.2000000476837},{"duration":281.39999985694885,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":786.6000001430511,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":786.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1068,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":11,"responseStart":175,"responseEnd":179,"domLoading":178,"domInteractive":1139,"domContentLoadedEventStart":1139,"domContentLoadedEventEnd":1177,"domComplete":1649,"loadEventStart":1649,"loadEventEnd":1651,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1086.5},{"name":"bigPipe.sidebar-id.end","time":1087.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1087.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":1089.7999999523163},{"name":"activityTabFullyLoaded","time":1183.7999999523163}],"measures":[],"correlationId":"9c1d706049d530","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":104,"dbReadsTimeInMs":44,"dbConnsTimeInMs":52,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}