10.2 1ca8637ae3506
|
mysqld: /data/src/10.2/sql/filesort.cc:1018: virtual void Type_handler_string_result::make_sort_key(uchar*, Item*, const SORT_FIELD_ATTR*, Sort_param*) const: Assertion `0' failed.
|
170326 1:31:30 [ERROR] mysqld got signal 6 ;
|
#7 0x00007f60eb47b312 in __GI___assert_fail (assertion=0x7f60ee87ae03 "0", file=0x7f60ee87aac8 "/data/src/10.2/sql/filesort.cc", line=1018, function=0x7f60ee87b6c0 <Type_handler_string_result::make_sort_key(unsigned char*, Item*, SORT_FIELD_ATTR const*, Sort_param*) const::__PRETTY_FUNCTION__> "virtual void Type_handler_string_result::make_sort_key(uchar*, Item*, const SORT_FIELD_ATTR*, Sort_param*) const") at assert.c:101
|
#8 0x00007f60edfbdf6f in Type_handler_string_result::make_sort_key (this=0x7f60ef2bbce8 <type_handler_varchar>, to=0x7f60d25aa500 '\245' <repeats 200 times>..., item=0x7f60d2464280, sort_field=0x7f60d24673f8, param=0x7f60eeed9560) at /data/src/10.2/sql/filesort.cc:1018
|
#9 0x00007f60edc960eb in Item::make_sort_key (this=0x7f60d2464280, to=0x7f60d25aa500 '\245' <repeats 200 times>..., item=0x7f60d2464280, sort_field=0x7f60d24673f8, param=0x7f60eeed9560) at /data/src/10.2/sql/item.h:880
|
#10 0x00007f60edfbe65d in make_sortkey (param=0x7f60eeed9560, to=0x7f60d25aa500 '\245' <repeats 200 times>..., ref_pos=0x7f60d241c298 "") at /data/src/10.2/sql/filesort.cc:1186
|
#11 0x00007f60edfbd8c4 in find_all_keys (thd=0x7f60d2416070, param=0x7f60eeed9560, select=0x7f60d24669d0, fs_info=0x7f60d269e200, buffpek_pointers=0x7f60eeed9770, tempfile=0x7f60eeed95f0, pq=0x0, found_rows=0x7f60d269e3f0) at /data/src/10.2/sql/filesort.cc:866
|
#12 0x00007f60edfbbb62 in filesort (thd=0x7f60d2416070, table=0x7f60d24d7870, filesort=0x7f60d2466bb0, tracker=0x7f60d2467388, join=0x7f60d2465028, first_table_bit=1) at /data/src/10.2/sql/filesort.cc:284
|
#13 0x00007f60eddce83a in create_sort_index (thd=0x7f60d2416070, join=0x7f60d2465028, tab=0x7f60d2466070, fsort=0x7f60d2466bb0) at /data/src/10.2/sql/sql_select.cc:21540
|
#14 0x00007f60eddc92c7 in st_join_table::sort_table (this=0x7f60d2466070) at /data/src/10.2/sql/sql_select.cc:19375
|
#15 0x00007f60eddc8fb6 in join_init_read_record (tab=0x7f60d2466070) at /data/src/10.2/sql/sql_select.cc:19322
|
#16 0x00007f60eddc6fa9 in sub_select (join=0x7f60d2465028, join_tab=0x7f60d2466070, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18414
|
#17 0x00007f60eddc65a3 in do_select (join=0x7f60d2465028, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:17961
|
#18 0x00007f60edda15b7 in JOIN::exec_inner (this=0x7f60d2465028) at /data/src/10.2/sql/sql_select.cc:3463
|
#19 0x00007f60edda0abc in JOIN::exec (this=0x7f60d2465028) at /data/src/10.2/sql/sql_select.cc:3266
|
#20 0x00007f60edda1c2f in mysql_select (thd=0x7f60d2416070, tables=0x7f60d2464840, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7f60d2464ef8, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f60d2465008, unit=0x7f60d2419b50, select_lex=0x7f60d241a280) at /data/src/10.2/sql/sql_select.cc:3658
|
#21 0x00007f60edd96710 in handle_select (thd=0x7f60d2416070, lex=0x7f60d2419a88, result=0x7f60d2465008, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373
|
#22 0x00007f60edd62b59 in execute_sqlcom_select (thd=0x7f60d2416070, all_tables=0x7f60d2464840) at /data/src/10.2/sql/sql_parse.cc:6415
|
#23 0x00007f60edd58b86 in mysql_execute_command (thd=0x7f60d2416070) at /data/src/10.2/sql/sql_parse.cc:3448
|
#24 0x00007f60edd6652c in mysql_parse (thd=0x7f60d2416070, rawbuf=0x7f60d2464088 "SELECT JSON_KEYS(f) FROM t1 ORDER BY 1", length=38, parser_state=0x7f60eeedadd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7858
|
#25 0x00007f60edd545f2 in dispatch_command (command=COM_QUERY, thd=0x7f60d2416070, packet=0x7f60d2458071 "", packet_length=38, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1812
|
#26 0x00007f60edd52f62 in do_command (thd=0x7f60d2416070) at /data/src/10.2/sql/sql_parse.cc:1362
|
#27 0x00007f60ede9bf3f in do_handle_one_connection (connect=0x7f60eac656b0) at /data/src/10.2/sql/sql_connect.cc:1358
|
#28 0x00007f60ede9bccc in handle_one_connection (arg=0x7f60eac656b0) at /data/src/10.2/sql/sql_connect.cc:1264
|
#29 0x00007f60ee2b4658 in pfs_spawn_thread (arg=0x7f60e23ce870) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#30 0x00007f60ed37d064 in start_thread (arg=0x7f60eeedc300) at pthread_create.c:309
|
#31 0x00007f60eb53562d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
--source include/have_innodb.inc
|
|
SET sql_mode='';
|
CREATE TABLE t1 (f INT NOT NULL) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (0);
|
SELECT JSON_KEYS(f) FROM t1 ORDER BY 1;
|
- relates to
-
MDEV-16174
Assertion `0' failed in Type_handler_string_result::make_sort_key(uchar*, Item*, const SORT_FIELD_ATTR*, Sort_param*)
-
-
Closed
{"report":{"fcp":3012.5,"ttfb":917,"pageVisibility":"visible","entityId":60718,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"45ea136d-9cf1-4488-ad41-caeebdeba26b","navigationType":0,"readyForUser":3125.2000002861023,"redirectCount":0,"resourceLoadedEnd":3197.4000000953674,"resourceLoadedStart":1303.3000001907349,"resourceTiming":[{"duration":470.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":1303.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1303.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1773.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":470.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":1303.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1303.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1774.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":535.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":1303.8000001907349,"connectEnd":1303.8000001907349,"connectStart":1303.8000001907349,"domainLookupEnd":1303.8000001907349,"domainLookupStart":1303.8000001907349,"fetchStart":1303.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1303.8000001907349,"responseEnd":1839.3000001907349,"responseStart":1839.3000001907349,"secureConnectionStart":1303.8000001907349},{"duration":710.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":1304,"connectEnd":1304,"connectStart":1304,"domainLookupEnd":1304,"domainLookupStart":1304,"fetchStart":1304,"redirectEnd":0,"redirectStart":0,"requestStart":1304,"responseEnd":2014.2000002861023,"responseStart":2014.0999999046326,"secureConnectionStart":1304},{"duration":828.2999997138977,"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":1304.2000002861023,"connectEnd":1304.2000002861023,"connectStart":1304.2000002861023,"domainLookupEnd":1304.2000002861023,"domainLookupStart":1304.2000002861023,"fetchStart":1304.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1304.2000002861023,"responseEnd":2132.5,"responseStart":2132.5,"secureConnectionStart":1304.2000002861023},{"duration":931,"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":1304.4000000953674,"connectEnd":1304.4000000953674,"connectStart":1304.4000000953674,"domainLookupEnd":1304.4000000953674,"domainLookupStart":1304.4000000953674,"fetchStart":1304.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1304.4000000953674,"responseEnd":2235.4000000953674,"responseStart":2235.4000000953674,"secureConnectionStart":1304.4000000953674},{"duration":1004.8000001907349,"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":1304.5999999046326,"connectEnd":1304.5999999046326,"connectStart":1304.5999999046326,"domainLookupEnd":1304.5999999046326,"domainLookupStart":1304.5999999046326,"fetchStart":1304.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1304.5999999046326,"responseEnd":2309.4000000953674,"responseStart":2309.4000000953674,"secureConnectionStart":1304.5999999046326},{"duration":1204.5,"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":1304.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1304.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2509.300000190735,"responseStart":0,"secureConnectionStart":0},{"duration":1079.6999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":1304.9000000953674,"connectEnd":1304.9000000953674,"connectStart":1304.9000000953674,"domainLookupEnd":1304.9000000953674,"domainLookupStart":1304.9000000953674,"fetchStart":1304.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1304.9000000953674,"responseEnd":2384.5999999046326,"responseStart":2384.5999999046326,"secureConnectionStart":1304.9000000953674},{"duration":1204.4000000953674,"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":1305.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1305.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2509.5,"responseStart":0,"secureConnectionStart":0},{"duration":1079.9000000953674,"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":1305.3000001907349,"connectEnd":1305.3000001907349,"connectStart":1305.3000001907349,"domainLookupEnd":1305.3000001907349,"domainLookupStart":1305.3000001907349,"fetchStart":1305.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1305.3000001907349,"responseEnd":2385.2000002861023,"responseStart":2385.2000002861023,"secureConnectionStart":1305.3000001907349},{"duration":1430.0999999046326,"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":1307.3000001907349,"connectEnd":1307.3000001907349,"connectStart":1307.3000001907349,"domainLookupEnd":1307.3000001907349,"domainLookupStart":1307.3000001907349,"fetchStart":1307.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1307.3000001907349,"responseEnd":2737.4000000953674,"responseStart":2737.4000000953674,"secureConnectionStart":1307.3000001907349},{"duration":1502.5999999046326,"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":1307.3000001907349,"connectEnd":1307.3000001907349,"connectStart":1307.3000001907349,"domainLookupEnd":1307.3000001907349,"domainLookupStart":1307.3000001907349,"fetchStart":1307.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1307.3000001907349,"responseEnd":2809.9000000953674,"responseStart":2809.9000000953674,"secureConnectionStart":1307.3000001907349},{"duration":263.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":2181.5999999046326,"connectEnd":2181.5999999046326,"connectStart":2181.5999999046326,"domainLookupEnd":2181.5999999046326,"domainLookupStart":2181.5999999046326,"fetchStart":2181.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":2181.5999999046326,"responseEnd":2445.0999999046326,"responseStart":2445.0999999046326,"secureConnectionStart":2181.5999999046326},{"duration":243,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":2629.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":2629.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2872.5,"responseStart":0,"secureConnectionStart":0},{"duration":338.30000019073486,"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&whisper-enabled=true","startTime":2858.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":2858.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":3196.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":337.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":2859.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":2859.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":3197.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":325.40000009536743,"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&whisper-enabled=true","startTime":2860.5999999046326,"connectEnd":2860.5999999046326,"connectStart":2860.5999999046326,"domainLookupEnd":2860.5999999046326,"domainLookupStart":2860.5999999046326,"fetchStart":2860.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":2860.5999999046326,"responseEnd":3186,"responseStart":3186,"secureConnectionStart":2860.5999999046326},{"duration":411.09999990463257,"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&whisper-enabled=true","startTime":2861.2000002861023,"connectEnd":2861.2000002861023,"connectStart":2861.2000002861023,"domainLookupEnd":2861.2000002861023,"domainLookupStart":2861.2000002861023,"fetchStart":2861.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":2861.2000002861023,"responseEnd":3272.300000190735,"responseStart":3272.300000190735,"secureConnectionStart":2861.2000002861023}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":757,"responseStart":917,"responseEnd":975,"domLoading":1054,"domInteractive":3207,"domContentLoadedEventStart":3207,"domContentLoadedEventEnd":3283,"domComplete":6623,"loadEventStart":6623,"loadEventEnd":6626,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":3182.2000002861023},{"name":"bigPipe.sidebar-id.end","time":3183},{"name":"bigPipe.activity-panel-pipe-id.start","time":3183.300000190735},{"name":"bigPipe.activity-panel-pipe-id.end","time":3187.800000190735},{"name":"activityTabFullyLoaded","time":3287.300000190735}],"measures":[],"correlationId":"15a3d40191de7d","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":95,"dbReadsTimeInMs":14,"dbConnsTimeInMs":24,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}