#7 0x00007f0dabfbef36 in __GI___assert_fail (assertion=0x5591aab2f5f0 "table->no_keyread || !table->covering_keys.is_set(tab->index) || table->file->keyread == tab->index", file=0x5591aab2cab8 "/10.2/src/sql/sql_select.cc", line=19851, function=0x5591aab2f5d0 "int join_read_first(JOIN_TAB*)") at assert.c:101
#8 0x00005591aa0f3e2e in join_read_first (tab=0x7f0d501756b8) at /10.2/src/sql/sql_select.cc:19851
#9 0x00005591aa0f18e2 in sub_select (join=0x7f0d50016e80, join_tab=0x7f0d501756b8, end_of_records=false) at /10.2/src/sql/sql_select.cc:18871
#10 0x00005591aa0f0ea6 in do_select (join=0x7f0d50016e80, procedure=0x0) at /10.2/src/sql/sql_select.cc:18418
#11 0x00005591aa0caa87 in JOIN::exec_inner (this=0x7f0d50016e80) at /10.2/src/sql/sql_select.cc:3651
#12 0x00005591aa0c9f2e in JOIN::exec (this=0x7f0d50016e80) at /10.2/src/sql/sql_select.cc:3446
#13 0x00005591aa17115d in st_select_lex_unit::exec (this=0x7f0d50013490) at /10.2/src/sql/sql_union.cc:1073
#14 0x00005591aa3d943b in subselect_union_engine::exec (this=0x7f0d50015da0) at /10.2/src/sql/item_subselect.cc:4030
#15 0x00005591aa3cdca1 in Item_subselect::exec (this=0x7f0d50015c20) at /10.2/src/sql/item_subselect.cc:770
#16 0x00005591aa3cfadd in Item_singlerow_subselect::val_int (this=0x7f0d50015c20) at /10.2/src/sql/item_subselect.cc:1391
#17 0x00005591a9fa569d in Item::val_int_result (this=0x7f0d50015c20) at /10.2/src/sql/item.h:1274
#18 0x00005591aa33491b in Item_cache_int::cache_value (this=0x7f0d501761c8) at /10.2/src/sql/item.cc:9701
#19 0x00005591aa33f3c6 in Item_cache_wrapper::cache (this=0x7f0d5009db50) at /10.2/src/sql/item.cc:8362
#20 0x00005591aa330829 in Item_cache_wrapper::val_int (this=0x7f0d5009db50) at /10.2/src/sql/item.cc:8416
#21 0x00005591aa345abf in Arg_comparator::compare_int_signed (this=0x7f0d50015e98) at /10.2/src/sql/item_cmpfunc.cc:970
#22 0x00005591aa359cc4 in Arg_comparator::compare (this=0x7f0d50015e98) at /10.2/src/sql/item_cmpfunc.h:87
#23 0x00005591aa348117 in Item_func_eq::val_int (this=0x7f0d50015dd8) at /10.2/src/sql/item_cmpfunc.cc:1803
#24 0x00005591aa0f1d22 in evaluate_join_record (join=0x7f0d50016038, join_tab=0x7f0d5009a298, error=0) at /10.2/src/sql/sql_select.cc:18969
#25 0x00005591aa0f1af8 in sub_select (join=0x7f0d50016038, join_tab=0x7f0d5009a298, end_of_records=false) at /10.2/src/sql/sql_select.cc:18913
#26 0x00005591aa0f0ea6 in do_select (join=0x7f0d50016038, procedure=0x0) at /10.2/src/sql/sql_select.cc:18418
#27 0x00005591aa0caa87 in JOIN::exec_inner (this=0x7f0d50016038) at /10.2/src/sql/sql_select.cc:3651
#28 0x00005591aa0c9f2e in JOIN::exec (this=0x7f0d50016038) at /10.2/src/sql/sql_select.cc:3446
#29 0x00005591aa0cb108 in mysql_select (thd=0x7f0d50000d90, tables=0x7f0d50012958, wild_num=0, fields=..., conds=0x7f0d50015dd8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f0d50016018, unit=0x7f0d50004988, select_lex=0x7f0d500050c8) at /10.2/src/sql/sql_select.cc:3849
#30 0x00005591aa0bf25c in handle_select (thd=0x7f0d50000d90, lex=0x7f0d500048c8, result=0x7f0d50016018, setup_tables_done_option=0) at /10.2/src/sql/sql_select.cc:361
#31 0x00005591aa089771 in execute_sqlcom_select (thd=0x7f0d50000d90, all_tables=0x7f0d50012958) at /10.2/src/sql/sql_parse.cc:6274
#32 0x00005591aa0802e5 in mysql_execute_command (thd=0x7f0d50000d90) at /10.2/src/sql/sql_parse.cc:3585
#33 0x00005591aa08d52c in mysql_parse (thd=0x7f0d50000d90, rawbuf=0x7f0d500126f8 "SELECT 1 FROM t1 \nWHERE t1.i1 =( SELECT t1.i1 FROM t2 UNION \nSELECT dt1.i1 FROM (t1 AS dt1 ) window w1 as (partition by t1.i1) limit 1)", length=136, parser_state=0x7f0da62cb570, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:7796
#34 0x00005591aa07b756 in dispatch_command (command=COM_QUERY, thd=0x7f0d50000d90, packet=0x7f0d50008b51 "", packet_length=136, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:1827
#35 0x00005591aa07a251 in do_command (thd=0x7f0d50000d90) at /10.2/src/sql/sql_parse.cc:1381
#36 0x00005591aa1d588e in do_handle_one_connection (connect=0x5591ad5d2a40) at /10.2/src/sql/sql_connect.cc:1336
#37 0x00005591aa1d55f3 in handle_one_connection (arg=0x5591ad5d2a40) at /10.2/src/sql/sql_connect.cc:1241
#38 0x00005591aaa011a8 in pfs_spawn_thread (arg=0x5591ad5b5e40) at /10.2/src/storage/perfschema/pfs.cc:1869
#39 0x00007f0dac4d0609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#40 0x00007f0dac0aa293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
no visible effect on a non-debug build.
Attachments
Issue Links
is duplicated by
MDEV-25632Bug report: abortion in sql/sql_plugin.cc:1204
Closed
is part of
MDEV-30052Crash with a query containing nested WINDOW clauses
Some pointers may be invalid and cause the dump to abort.
Query (0x7f83a80a5720): SELECT i1 FROM t1
WHERE t1.i3 =
(SELECT ref_4.i2 FROM t1 AS ref_4
WHERE t1.i2 > (SELECT i3 FROM t1 ORDER BY i3 LIMIT 1 OFFSET 4)
UNION
SELECT ref_6.i2
FROM (t1 AS ref_5 JOIN t1 AS ref_6 ON (ref_6.i1 > ref_6.i2))
WHERE (t1.i2 >= t1.i2))
Alice Sherepa
added a comment - test case from MDEV-25634 :
CREATE TABLE t1 (i3 int NOT NULL , i1 int , i2 int , i4 int , PRIMARY key (i2));
INSERT INTO t1 VALUES (6,72,98,98),(46,1,6952,0);
SELECT i1 FROM t1
WHERE t1.i3 =
( SELECT ref_4.i2 FROM t1 AS ref_4
WHERE t1.i2 > ( SELECT i3 FROM t1 ORDER BY i3 LIMIT 1 OFFSET 4)
UNION
SELECT ref_6.i2
FROM (t1 AS ref_5 JOIN t1 AS ref_6 ON (ref_6.i1 > ref_6.i2))
WHERE (t1.i2 >= t1.i2));
It fails on 5.5-10.5,
on 5.5-10.1 - sql_select.cc:18372: enum_nested_loop_state sub_select_cache(JOIN*, JOIN_TAB*, bool): Assertion `cache != __null' failed.
on 10.2-10.5 - Assertion `table->no_keyread || !table->covering_keys.is_set(tab->index) || table->file->keyread == tab->index'
on non-debug build:
Version: '10.5.10-MariaDB'
210510 14:36:53 [ERROR] mysqld got signal 11 ;
Server version: 10.5.10-MariaDB
Thread pointer: 0x7f83a8007938
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f84f016cdd8 thread_stack 0x49000
mysys/stacktrace.c:213(my_print_stacktrace)[0x55bcfec6ddce]
sql/signal_handler.cc:224(handle_fatal_signal)[0x55bcfe730705]
??:0(__restore_rt)[0x7f84f3032730]
sql/sql_join_cache.h:679(sub_select_cache(JOIN*, st_join_table*, bool))[0x55bcfe57de5a]
sql/sql_select.cc:21045(evaluate_join_record(JOIN*, st_join_table*, int))[0x55bcfe5703c8]
sql/sql_select.cc:20829(sub_select(JOIN*, st_join_table*, bool))[0x55bcfe57da17]
sql/sql_select.cc:20355(do_select)[0x55bcfe5a209f]
sql/sql_select.cc:4284(JOIN::exec())[0x55bcfe5a2390]
sql/sql_union.cc:2236(st_select_lex_unit::exec())[0x55bcfe5e9ad4]
sql/item_subselect.cc:4104(subselect_union_engine::exec())[0x55bcfe7d3a2e]
sql/item_subselect.cc:834(Item_subselect::exec())[0x55bcfe7d44cd]
sql/item_subselect.cc:1441(Item_singlerow_subselect::val_int())[0x55bcfe7d3d6e]
sql/item.cc:9917(Item_cache_int::cache_value())[0x55bcfe742e98]
sql/item.cc:8704(Item_cache_wrapper::cache())[0x55bcfe75d0d3]
sql/item.cc:8758(Item_cache_wrapper::val_int())[0x55bcfe756888]
sql/item_cmpfunc.cc:943(Arg_comparator::compare_int_signed())[0x55bcfe75f868]
sql/item_cmpfunc.cc:1777(Item_func_eq::val_int())[0x55bcfe75fe9b]
sql/sql_select.cc:20922(evaluate_join_record(JOIN*, st_join_table*, int))[0x55bcfe570181]
sql/sql_select.cc:20860(sub_select(JOIN*, st_join_table*, bool))[0x55bcfe57da8d]
sql/sql_select.cc:20355(do_select)[0x55bcfe5a209f]
sql/sql_select.cc:4284(JOIN::exec())[0x55bcfe5a2390]
sql/sql_select.cc:4761(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*))[0x55bcfe5a0698]
sql/sql_select.cc:443(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55bcfe5a0ffe]
sql/sql_parse.cc:6313(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55bcfe541b39]
sql/sql_parse.cc:6055(mysql_execute_command(THD*))[0x55bcfe54b2ce]
sql/sql_parse.cc:8116(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55bcfe53d1be]
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55bcfe5487ea]
sql/sql_parse.cc:1370(do_command(THD*))[0x55bcfe549724]
sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x55bcfe6321a0]
sql/sql_connect.cc:1312(handle_one_connection)[0x55bcfe63257d]
perfschema/pfs.cc:2204(pfs_spawn_thread)[0x55bcfe9632eb]
nptl/pthread_create.c:487(start_thread)[0x7f84f3027fa3]
x86_64/clone.S:97(clone)[0x7f84f2c324cf]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7f83a80a5720): SELECT i1 FROM t1
WHERE t1.i3 =
(SELECT ref_4.i2 FROM t1 AS ref_4
WHERE t1.i2 > (SELECT i3 FROM t1 ORDER BY i3 LIMIT 1 OFFSET 4)
UNION
SELECT ref_6.i2
FROM (t1 AS ref_5 JOIN t1 AS ref_6 ON (ref_6.i1 > ref_6.i2))
WHERE (t1.i2 >= t1.i2))
People
Sergei Petrunia
Alice Sherepa
Votes:
0Vote for this issue
Watchers:
4Start 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.
{"report":{"fcp":1196.2000000476837,"ttfb":409.89999997615814,"pageVisibility":"visible","entityId":99525,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"9d600d1f-67fb-4225-bee1-6863eab1c6fc","navigationType":0,"readyForUser":1335,"redirectCount":0,"resourceLoadedEnd":1372.7999999523163,"resourceLoadedStart":414.7999999523163,"resourceTiming":[{"duration":215.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":414.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":414.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":630.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":215.39999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":415.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":415.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":630.5,"responseStart":0,"secureConnectionStart":0},{"duration":236.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":415.2999999523163,"connectEnd":415.2999999523163,"connectStart":415.2999999523163,"domainLookupEnd":415.2999999523163,"domainLookupStart":415.2999999523163,"fetchStart":415.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":415.2999999523163,"responseEnd":651.5,"responseStart":651.5,"secureConnectionStart":415.2999999523163},{"duration":296.8000000715256,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":415.39999997615814,"connectEnd":415.39999997615814,"connectStart":415.39999997615814,"domainLookupEnd":415.39999997615814,"domainLookupStart":415.39999997615814,"fetchStart":415.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":415.39999997615814,"responseEnd":712.2000000476837,"responseStart":712.2000000476837,"secureConnectionStart":415.39999997615814},{"duration":300,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":415.60000002384186,"connectEnd":415.60000002384186,"connectStart":415.60000002384186,"domainLookupEnd":415.60000002384186,"domainLookupStart":415.60000002384186,"fetchStart":415.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":415.60000002384186,"responseEnd":715.6000000238419,"responseStart":715.6000000238419,"secureConnectionStart":415.60000002384186},{"duration":300.3000000715256,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":415.7999999523163,"connectEnd":415.7999999523163,"connectStart":415.7999999523163,"domainLookupEnd":415.7999999523163,"domainLookupStart":415.7999999523163,"fetchStart":415.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":415.7999999523163,"responseEnd":716.1000000238419,"responseStart":716.1000000238419,"secureConnectionStart":415.7999999523163},{"duration":300.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":415.89999997615814,"connectEnd":415.89999997615814,"connectStart":415.89999997615814,"domainLookupEnd":415.89999997615814,"domainLookupStart":415.89999997615814,"fetchStart":415.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":415.89999997615814,"responseEnd":716.3999999761581,"responseStart":716.3999999761581,"secureConnectionStart":415.89999997615814},{"duration":385.6999999284744,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":416.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":416.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":801.8999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":300.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":416.2999999523163,"connectEnd":416.2999999523163,"connectStart":416.2999999523163,"domainLookupEnd":416.2999999523163,"domainLookupStart":416.2999999523163,"fetchStart":416.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":416.2999999523163,"responseEnd":716.8999999761581,"responseStart":716.8999999761581,"secureConnectionStart":416.2999999523163},{"duration":385.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":416.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":416.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":802,"responseStart":0,"secureConnectionStart":0},{"duration":301.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":416.60000002384186,"connectEnd":416.60000002384186,"connectStart":416.60000002384186,"domainLookupEnd":416.60000002384186,"domainLookupStart":416.60000002384186,"fetchStart":416.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":416.60000002384186,"responseEnd":718.2000000476837,"responseStart":718.2000000476837,"secureConnectionStart":416.60000002384186},{"duration":471.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":423.2000000476837,"connectEnd":423.2000000476837,"connectStart":423.2000000476837,"domainLookupEnd":423.2000000476837,"domainLookupStart":423.2000000476837,"fetchStart":423.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":423.2000000476837,"responseEnd":895,"responseStart":895,"secureConnectionStart":423.2000000476837},{"duration":610.1000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":423.60000002384186,"connectEnd":423.60000002384186,"connectStart":423.60000002384186,"domainLookupEnd":423.60000002384186,"domainLookupStart":423.60000002384186,"fetchStart":423.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":423.60000002384186,"responseEnd":1033.7000000476837,"responseStart":1033.7000000476837,"secureConnectionStart":423.60000002384186},{"duration":80.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":825.2999999523163,"connectEnd":825.2999999523163,"connectStart":825.2999999523163,"domainLookupEnd":825.2999999523163,"domainLookupStart":825.2999999523163,"fetchStart":825.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":825.2999999523163,"responseEnd":905.7000000476837,"responseStart":905.7000000476837,"secureConnectionStart":825.2999999523163},{"duration":235.19999992847443,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1137.6000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1137.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1372.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":209.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1138.6000000238419,"connectEnd":1138.6000000238419,"connectStart":1138.6000000238419,"domainLookupEnd":1138.6000000238419,"domainLookupStart":1138.6000000238419,"fetchStart":1138.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":1138.6000000238419,"responseEnd":1348.2000000476837,"responseStart":1348.2000000476837,"secureConnectionStart":1138.6000000238419},{"duration":225.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1139,"connectEnd":1139,"connectStart":1139,"domainLookupEnd":1139,"domainLookupStart":1139,"fetchStart":1139,"redirectEnd":0,"redirectStart":0,"requestStart":1139,"responseEnd":1364.7000000476837,"responseStart":1364.7000000476837,"secureConnectionStart":1139}],"fetchStart":1,"domainLookupStart":50,"domainLookupEnd":185,"connectStart":185,"connectEnd":209,"secureConnectionStart":193,"requestStart":209,"responseStart":410,"responseEnd":423,"domLoading":414,"domInteractive":1427,"domContentLoadedEventStart":1427,"domContentLoadedEventEnd":1491,"domComplete":1792,"loadEventStart":1792,"loadEventEnd":1793,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1384.7999999523163},{"name":"bigPipe.sidebar-id.end","time":1385.6000000238419},{"name":"bigPipe.activity-panel-pipe-id.start","time":1385.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":1388.5},{"name":"activityTabFullyLoaded","time":1508.6000000238419}],"measures":[],"correlationId":"fce16c90db5120","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":117,"dbReadsTimeInMs":18,"dbConnsTimeInMs":28,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
test case from
MDEV-25634:It fails on 5.5-10.5,
on 5.5-10.1 - sql_select.cc:18372: enum_nested_loop_state sub_select_cache(JOIN*, JOIN_TAB*, bool): Assertion `cache != __null' failed.
on 10.2-10.5 - Assertion `table->no_keyread || !table->covering_keys.is_set(tab->index) || table->file->keyread == tab->index'
on non-debug build:
Version: '10.5.10-MariaDB'
210510 14:36:53 [ERROR] mysqld got signal 11 ;
Server version: 10.5.10-MariaDB
Thread pointer: 0x7f83a8007938
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f84f016cdd8 thread_stack 0x49000
mysys/stacktrace.c:213(my_print_stacktrace)[0x55bcfec6ddce]
sql/signal_handler.cc:224(handle_fatal_signal)[0x55bcfe730705]
??:0(__restore_rt)[0x7f84f3032730]
sql/sql_join_cache.h:679(sub_select_cache(JOIN*, st_join_table*, bool))[0x55bcfe57de5a]
sql/sql_select.cc:21045(evaluate_join_record(JOIN*, st_join_table*, int))[0x55bcfe5703c8]
sql/sql_select.cc:20829(sub_select(JOIN*, st_join_table*, bool))[0x55bcfe57da17]
sql/sql_select.cc:20355(do_select)[0x55bcfe5a209f]
sql/sql_select.cc:4284(JOIN::exec())[0x55bcfe5a2390]
sql/sql_union.cc:2236(st_select_lex_unit::exec())[0x55bcfe5e9ad4]
sql/item_subselect.cc:4104(subselect_union_engine::exec())[0x55bcfe7d3a2e]
sql/item_subselect.cc:834(Item_subselect::exec())[0x55bcfe7d44cd]
sql/item_subselect.cc:1441(Item_singlerow_subselect::val_int())[0x55bcfe7d3d6e]
sql/item.cc:9917(Item_cache_int::cache_value())[0x55bcfe742e98]
sql/item.cc:8704(Item_cache_wrapper::cache())[0x55bcfe75d0d3]
sql/item.cc:8758(Item_cache_wrapper::val_int())[0x55bcfe756888]
sql/item_cmpfunc.cc:943(Arg_comparator::compare_int_signed())[0x55bcfe75f868]
sql/item_cmpfunc.cc:1777(Item_func_eq::val_int())[0x55bcfe75fe9b]
sql/sql_select.cc:20922(evaluate_join_record(JOIN*, st_join_table*, int))[0x55bcfe570181]
sql/sql_select.cc:20860(sub_select(JOIN*, st_join_table*, bool))[0x55bcfe57da8d]
sql/sql_select.cc:20355(do_select)[0x55bcfe5a209f]
sql/sql_select.cc:4284(JOIN::exec())[0x55bcfe5a2390]
sql/sql_select.cc:4761(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*))[0x55bcfe5a0698]
sql/sql_select.cc:443(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55bcfe5a0ffe]
sql/sql_parse.cc:6313(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55bcfe541b39]
sql/sql_parse.cc:6055(mysql_execute_command(THD*))[0x55bcfe54b2ce]
sql/sql_parse.cc:8116(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55bcfe53d1be]
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55bcfe5487ea]
sql/sql_parse.cc:1370(do_command(THD*))[0x55bcfe549724]
sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x55bcfe6321a0]
sql/sql_connect.cc:1312(handle_one_connection)[0x55bcfe63257d]
perfschema/pfs.cc:2204(pfs_spawn_thread)[0x55bcfe9632eb]
nptl/pthread_create.c:487(start_thread)[0x7f84f3027fa3]
x86_64/clone.S:97(clone)[0x7f84f2c324cf]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7f83a80a5720): SELECT i1 FROM t1
WHERE t1.i3 =
(SELECT ref_4.i2 FROM t1 AS ref_4
WHERE t1.i2 > (SELECT i3 FROM t1 ORDER BY i3 LIMIT 1 OFFSET 4)
UNION
SELECT ref_6.i2
FROM (t1 AS ref_5 JOIN t1 AS ref_6 ON (ref_6.i1 > ref_6.i2))
WHERE (t1.i2 >= t1.i2))