Upd: For instructions on reproducing, see comments
|
10.5 ff66d38cf26a096854836f
|
2020-04-09 12:50:57 0x7f44f217d300 InnoDB: Assertion failure in file /10.5/storage/innobase/trx/trx0i_s.cc line 852
|
InnoDB: Failing assertion: heap_no == ULINT_UNDEFINED
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mysqld startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
|
InnoDB: about forcing recovery.
|
200409 12:50:57 [ERROR] mysqld got signal 6 ;
|
Server version: 10.5.3-MariaDB-debug-log
|
|
linux/raise.c:51(__GI_raise)[0x7f451d046535]
|
ut/ut0dbg.cc:60(_GLOBAL__sub_D_00099_0_ut0dbg.cc)[0x55c9261fec6a]
|
trx/trx0i_s.cc:854(fold_lock(ib_lock_t const*, unsigned long))[0x55c9261fee99]
|
trx/trx0i_s.cc:924(search_innodb_locks(trx_i_s_cache_t*, ib_lock_t const*, unsigned short))[0x55c9261ff6c9]
|
trx/trx0i_s.cc:1086(add_trx_relevant_locks_to_cache(trx_i_s_cache_t*, trx_t const*, i_s_locks_row_t**))[0x55c926200205]
|
trx/trx0i_s.cc:1198(fetch_data_into_cache_low(trx_i_s_cache_t*, trx_t const*))[0x55c926200592]
|
trx/trx0i_s.cc:1233(fetch_data_into_cache(trx_i_s_cache_t*))[0x55c92620072f]
|
trx/trx0i_s.cc:1260(trx_i_s_possibly_fetch_data_into_cache(trx_i_s_cache_t*))[0x55c925e3de28]
|
handler/i_s.cc:990(trx_i_s_common_fill_table(THD*, TABLE_LIST*, Item*))[0x55c924c90b46]
|
sql/sql_show.cc:8647(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x55c924b69d45]
|
sql/sql_select.cc:4419(JOIN::exec_inner())[0x55c924b67c30]
|
sql/sql_select.cc:4245(JOIN::exec())[0x55c924b6bb45]
|
sql/sql_select.cc:4670(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55c924b3de88]
|
sql/sql_select.cc:417(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55c924ab01d5]
|
sql/sql_parse.cc:6168(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55c924a9e5f7]
|
sql/sql_parse.cc:3901(mysql_execute_command(THD*))[0x55c924abb223]
|
sql/sql_parse.cc:7953(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c924a91011]
|
sql/sql_parse.cc:1842(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c924a8da46]
|
sql/sql_parse.cc:1358(do_command(THD*))[0x55c924eaccc7]
|
sql/sql_connect.cc:1422(do_handle_one_connection(CONNECT*, bool))[0x55c924eac562]
|
sql/sql_connect.cc:1321(handle_one_connection)[0x55c925b4b378]
|
nptl/pthread_create.c:487(start_thread)[0x7f451daecfa3]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f451d11d4cf]
|
|
- is caused by
-
MDEV-19940
Clean up INFORMATION_SCHEMA.INNODB_ tables
-
-
Closed
{"report":{"fcp":990,"ttfb":175.5,"pageVisibility":"visible","entityId":85304,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"bee5364c-c2eb-42a2-ba79-38e16cc9bcc3","navigationType":0,"readyForUser":1070.8999999761581,"redirectCount":0,"resourceLoadedEnd":719.8999999761581,"resourceLoadedStart":186.20000004768372,"resourceTiming":[{"duration":13.699999928474426,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":186.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":186.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":199.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":13.600000023841858,"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":186.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":186.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":200,"responseStart":0,"secureConnectionStart":0},{"duration":411.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":186.70000004768372,"connectEnd":186.70000004768372,"connectStart":186.70000004768372,"domainLookupEnd":186.70000004768372,"domainLookupStart":186.70000004768372,"fetchStart":186.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":205.20000004768372,"responseEnd":598.1000000238419,"responseStart":327,"secureConnectionStart":186.70000004768372},{"duration":532.6999999284744,"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":187.20000004768372,"connectEnd":187.20000004768372,"connectStart":187.20000004768372,"domainLookupEnd":187.20000004768372,"domainLookupStart":187.20000004768372,"fetchStart":187.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":205.39999997615814,"responseEnd":719.8999999761581,"responseStart":389.3000000715256,"secureConnectionStart":187.20000004768372},{"duration":145.5,"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":187.30000007152557,"connectEnd":187.30000007152557,"connectStart":187.30000007152557,"domainLookupEnd":187.30000007152557,"domainLookupStart":187.30000007152557,"fetchStart":187.30000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":206.20000004768372,"responseEnd":332.8000000715256,"responseStart":330.7000000476837,"secureConnectionStart":187.30000007152557},{"duration":154.60000002384186,"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":187.39999997615814,"connectEnd":187.39999997615814,"connectStart":187.39999997615814,"domainLookupEnd":187.39999997615814,"domainLookupStart":187.39999997615814,"fetchStart":187.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":207,"responseEnd":342,"responseStart":339.3000000715256,"secureConnectionStart":187.39999997615814},{"duration":148.30000007152557,"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":187.5,"connectEnd":187.5,"connectStart":187.5,"domainLookupEnd":187.5,"domainLookupStart":187.5,"fetchStart":187.5,"redirectEnd":0,"redirectStart":0,"requestStart":207.80000007152557,"responseEnd":335.8000000715256,"responseStart":333.10000002384186,"secureConnectionStart":187.5},{"duration":18.100000023841858,"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":187.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":205.70000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":151.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":187.60000002384186,"connectEnd":187.60000002384186,"connectStart":187.60000002384186,"domainLookupEnd":187.60000002384186,"domainLookupStart":187.60000002384186,"fetchStart":187.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":209.80000007152557,"responseEnd":338.8000000715256,"responseStart":334.39999997615814,"secureConnectionStart":187.60000002384186},{"duration":19.100000023841858,"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":187.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":206.80000007152557,"responseStart":0,"secureConnectionStart":0},{"duration":156.20000004768372,"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":187.89999997615814,"connectEnd":187.89999997615814,"connectStart":187.89999997615814,"domainLookupEnd":187.89999997615814,"domainLookupStart":187.89999997615814,"fetchStart":187.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":211,"responseEnd":344.10000002384186,"responseStart":340.5,"secureConnectionStart":187.89999997615814},{"duration":472.8000000715256,"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":194,"connectEnd":194,"connectStart":194,"domainLookupEnd":194,"domainLookupStart":194,"fetchStart":194,"redirectEnd":0,"redirectStart":0,"requestStart":228.5,"responseEnd":666.8000000715256,"responseStart":656.1000000238419,"secureConnectionStart":194},{"duration":472.3000000715256,"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":195,"connectEnd":195,"connectStart":195,"domainLookupEnd":195,"domainLookupStart":195,"fetchStart":195,"redirectEnd":0,"redirectStart":0,"requestStart":242.39999997615814,"responseEnd":667.3000000715256,"responseStart":658.8999999761581,"secureConnectionStart":195},{"duration":177.20000004768372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":746,"connectEnd":746,"connectStart":746,"domainLookupEnd":746,"domainLookupStart":746,"fetchStart":746,"redirectEnd":0,"redirectStart":0,"requestStart":889.7000000476837,"responseEnd":923.2000000476837,"responseStart":922.3000000715256,"secureConnectionStart":746},{"duration":130.19999992847443,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":980.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":980.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1110.8999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":170.60000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":987.6000000238419,"connectEnd":987.6000000238419,"connectStart":987.6000000238419,"domainLookupEnd":987.6000000238419,"domainLookupStart":987.6000000238419,"fetchStart":987.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":1124.1000000238419,"responseEnd":1158.2000000476837,"responseStart":1157.2000000476837,"secureConnectionStart":987.6000000238419}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":31,"responseStart":175,"responseEnd":194,"domLoading":179,"domInteractive":1180,"domContentLoadedEventStart":1180,"domContentLoadedEventEnd":1228,"domComplete":1604,"loadEventStart":1604,"loadEventEnd":1605,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1149.8000000715256},{"name":"bigPipe.sidebar-id.end","time":1150.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1150.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1152.7000000476837},{"name":"activityTabFullyLoaded","time":1247.3999999761581}],"measures":[],"correlationId":"c79af4b7d1d107","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":74,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
To reproduce:
git clone https://github.com/MariaDB/randgen --branch mdev22206 rqg-mdev22206cd rqg-mdev22206perl ./runall-new.pl --basedir=<basedir> --duration=300 --threads=2 --seed=1 --mysqld=--lock-wait-timeout=10 --mysqld=--innodb-lock-wait-timeout=5 --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/xa.yy --grammar=conf/runtime/information_schema.yy --vardir=/dev/shm/var_mdev2220610.5 12277e30
2020-05-20 15:50:25 0x7f1d9487e700 InnoDB: Assertion failure in file /data/src/10.5/storage/innobase/trx/trx0i_s.cc line 850InnoDB: Failing assertion: heap_no == ULINT_UNDEFINED#5 0x00007f1d97dba42a in __GI_abort () at abort.c:89#6 0x0000563bfdcd8bb6 in ut_dbg_assertion_failed (expr=0x563bfe400cdd "heap_no == ULINT_UNDEFINED", file=0x563bfe4009a8 "/data/src/10.5/storage/innobase/trx/trx0i_s.cc", line=850) at /data/src/10.5/storage/innobase/ut/ut0dbg.cc:60#7 0x0000563bfdc9436a in fold_lock (lock=0x7f1d951aee88, heap_no=0) at /data/src/10.5/storage/innobase/trx/trx0i_s.cc:850#8 0x0000563bfdc9468a in search_innodb_locks (cache=0x563bfec383c0 <trx_i_s_cache_static>, lock=0x7f1d951aee88, heap_no=0) at /data/src/10.5/storage/innobase/trx/trx0i_s.cc:922#9 0x0000563bfdc947c4 in add_lock_to_cache (cache=0x563bfec383c0 <trx_i_s_cache_static>, lock=0x7f1d951aee88, heap_no=0) at /data/src/10.5/storage/innobase/trx/trx0i_s.cc:971#10 0x0000563bfdc94c55 in add_trx_relevant_locks_to_cache (cache=0x563bfec383c0 <trx_i_s_cache_static>, trx=0x7f1d951ae290, requested_lock_row=0x7f1d9487c190) at /data/src/10.5/storage/innobase/trx/trx0i_s.cc:1084#11 0x0000563bfdc9515f in fetch_data_into_cache_low (cache=0x563bfec383c0 <trx_i_s_cache_static>, trx=0x7f1d951ae290) at /data/src/10.5/storage/innobase/trx/trx0i_s.cc:1196#12 0x0000563bfdc95307 in fetch_data_into_cache (cache=0x563bfec383c0 <trx_i_s_cache_static>) at /data/src/10.5/storage/innobase/trx/trx0i_s.cc:1230#13 0x0000563bfdc953af in trx_i_s_possibly_fetch_data_into_cache (cache=0x563bfec383c0 <trx_i_s_cache_static>) at /data/src/10.5/storage/innobase/trx/trx0i_s.cc:1257#14 0x0000563bfdab26e7 in trx_i_s_common_fill_table (thd=0x7f1d38000b18, tables=0x7f1d38012d20) at /data/src/10.5/storage/innobase/handler/i_s.cc:989#15 0x0000563bfd35141b in get_schema_tables_result (join=0x7f1d38015b40, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.5/sql/sql_show.cc:8653#16 0x0000563bfd2e18e6 in JOIN::exec_inner (this=0x7f1d38015b40) at /data/src/10.5/sql/sql_select.cc:4421#17 0x0000563bfd2e0cf1 in JOIN::exec (this=0x7f1d38015b40) at /data/src/10.5/sql/sql_select.cc:4245#18 0x0000563bfd2e2422 in mysql_select (thd=0x7f1d38000b18, tables=0x7f1d38012d20, fields=..., conds=0x7f1d38014608, og_num=3, order=0x7f1d380150c8, group=0x0, having=0x0, proc_param=0x0, select_options=2685668096, result=0x7f1d38015b18, unit=0x7f1d38004b28, select_lex=0x7f1d380126d0) at /data/src/10.5/sql/sql_select.cc:4669#19 0x0000563bfd2d1f38 in handle_select (thd=0x7f1d38000b18, lex=0x7f1d38004a60, result=0x7f1d38015b18, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:429#20 0x0000563bfd29756e in execute_sqlcom_select (thd=0x7f1d38000b18, all_tables=0x7f1d38012d20) at /data/src/10.5/sql/sql_parse.cc:6172#21 0x0000563bfd28e8b4 in mysql_execute_command (thd=0x7f1d38000b18) at /data/src/10.5/sql/sql_parse.cc:3901#22 0x0000563bfd29c41c in mysql_parse (thd=0x7f1d38000b18, rawbuf=0x7f1d38012480 "SELECT /* QNO 2572 CON_ID 9 */ * FROM INFORMATION_SCHEMA.`INNODB_LOCKS` AS table1 WHERE NOT (NOT table1.`lock_id` >= table1.`lock_id` OR table1.`lock_id` >= table1.`lock_rec`) ORDER BY table1.`lock_in"..., length=244, parser_state=0x7f1d9487d520, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7957#23 0x0000563bfd288724 in dispatch_command (command=COM_QUERY, thd=0x7f1d38000b18, packet=0x7f1d38008829 "SELECT /* QNO 2572 CON_ID 9 */ * FROM INFORMATION_SCHEMA.`INNODB_LOCKS` AS table1 WHERE NOT (NOT table1.`lock_id` >= table1.`lock_id` OR table1.`lock_id` >= table1.`lock_rec`) ORDER BY table1.`lock_in"..., packet_length=244, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1840#24 0x0000563bfd286eb6 in do_command (thd=0x7f1d38000b18) at /data/src/10.5/sql/sql_parse.cc:1359#25 0x0000563bfd42a4d3 in do_handle_one_connection (connect=0x563c016607a8, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1411#26 0x0000563bfd42a23b in handle_one_connection (arg=0x563c016607a8) at /data/src/10.5/sql/sql_connect.cc:1313#27 0x0000563bfd960306 in pfs_spawn_thread (arg=0x563c01781248) at /data/src/10.5/storage/perfschema/pfs.cc:2201#28 0x00007f1d99d3a4a4 in start_thread (arg=0x7f1d9487e700) at pthread_create.c:456#29 0x00007f1d97e6ed0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97