--source include/have_log_bin.inc
|
|
CREATE TABLE t1 (f TEXT) ENGINE=MyISAM;
|
INSERT INTO t1 VALUES ('');
|
SET @str = 'qux', @path = '$.foobar';
|
UPDATE t1 SET f = JSON_SEARCH( '{"foo":"bar"}', 'all' , @str , '%' , @path );
|
10.2 1ca8637ae3506
|
#3 <signal handler called>
|
#4 0x00007f2872aa58d7 in sf_malloc_usable_size (ptr=0x8, is_thread_specific=0x7f2873212ca7 "") at /data/src/10.2/mysys/safemalloc.c:215
|
#5 0x00007f2872a9334a in my_free (ptr=0x8) at /data/src/10.2/mysys/my_malloc.c:215
|
#6 0x00007f2871ff5e7d in String::free (this=0x7f2866c65a48) at /data/src/10.2/sql/sql_string.h:351
|
#7 0x00007f287217d4ab in String::real_alloc (this=0x7f2866c65a48, length=8) at /data/src/10.2/sql/sql_string.cc:44
|
#8 0x00007f28720022b3 in String::alloc (this=0x7f2866c65a48, arg_length=8) at /data/src/10.2/sql/sql_string.h:361
|
#9 0x00007f287217d992 in String::copy (this=0x7f2866c65a48, str=0x7f2866daffd0 "$.foobar", arg_length=8, cs=0x7f28734eabc0 <my_charset_latin1>) at /data/src/10.2/sql/sql_string.cc:185
|
#10 0x00007f28723b740c in user_var_entry::val_str (this=0x7f2866de0330, null_value=0x7f2866c64d22, str=0x7f2866c65a48, decimals=39) at /data/src/10.2/sql/item_func.cc:4962
|
#11 0x00007f28723b89c8 in Item_func_get_user_var::val_str (this=0x7f2866c64cb0, str=0x7f2866c65a48) at /data/src/10.2/sql/item_func.cc:5392
|
#12 0x00007f2872516288 in Item_func_json_search::val_str (this=0x7f2866c64dc0, str=0x7f2866c64df0) at /data/src/10.2/sql/item_jsonfunc.cc:2901
|
#13 0x00007f2872355259 in Item::save_in_field (this=0x7f2866c64dc0, field=0x7f2866c27ab8, no_conversions=false) at /data/src/10.2/sql/item.cc:6376
|
#14 0x00007f2872062efa in fill_record (thd=0x7f2866c16070, table_arg=0x7f2866cd7870, fields=..., values=..., ignore_errors=false, update=true) at /data/src/10.2/sql/sql_base.cc:7908
|
#15 0x00007f2872063495 in fill_record_n_invoke_before_triggers (thd=0x7f2866c16070, table=0x7f2866cd7870, fields=..., values=..., ignore_errors=false, event=TRG_EVENT_UPDATE) at /data/src/10.2/sql/sql_base.cc:8050
|
#16 0x00007f28721af090 in mysql_update (thd=0x7f2866c16070, table_list=0x7f2866c641d0, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f2873214450, updated_return=0x7f2873214500) at /data/src/10.2/sql/sql_update.cc:746
|
#17 0x00007f28720c8e91 in mysql_execute_command (thd=0x7f2866c16070) at /data/src/10.2/sql/sql_parse.cc:4241
|
#18 0x00007f28720d452c in mysql_parse (thd=0x7f2866c16070, rawbuf=0x7f2866c64088 "UPDATE t1 SET f = JSON_SEARCH( '{\"foo\":\"bar\"}', 'all' , @str , '%' , @path )", length=76, parser_state=0x7f2873214dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7858
|
#19 0x00007f28720c25f2 in dispatch_command (command=COM_QUERY, thd=0x7f2866c16070, packet=0x7f2866c58071 "UPDATE t1 SET f = JSON_SEARCH( '{\"foo\":\"bar\"}', 'all' , @str , '%' , @path )", packet_length=76, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1812
|
#20 0x00007f28720c0f62 in do_command (thd=0x7f2866c16070) at /data/src/10.2/sql/sql_parse.cc:1362
|
#21 0x00007f2872209f3f in do_handle_one_connection (connect=0x7f286ec654f0) at /data/src/10.2/sql/sql_connect.cc:1358
|
#22 0x00007f2872209ccc in handle_one_connection (arg=0x7f286ec654f0) at /data/src/10.2/sql/sql_connect.cc:1264
|
#23 0x00007f2872622658 in pfs_spawn_thread (arg=0x7f286ec4d5f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#24 0x00007f28716eb064 in start_thread (arg=0x7f2873216300) at pthread_create.c:309
|
#25 0x00007f286f8a362d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Probably related to MDEV-12364.
- relates to
-
MDEV-12364
Server crashes in __memcpy_sse2_unaligned / String::copy on JSON_SEARCH with variables
-
-
Closed
{"report":{"fcp":1086.5999999046326,"ttfb":428.19999980926514,"pageVisibility":"visible","entityId":60720,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"947cfe12-d79b-4794-8ea3-970209fa7dd0","navigationType":0,"readyForUser":1149.5999999046326,"redirectCount":0,"resourceLoadedEnd":1510.2999999523163,"resourceLoadedStart":433.69999980926514,"resourceTiming":[{"duration":173.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":433.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":433.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":607.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":173.40000009536743,"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":433.89999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":433.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":607.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":233.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":434,"connectEnd":434,"connectStart":434,"domainLookupEnd":434,"domainLookupStart":434,"fetchStart":434,"redirectEnd":0,"redirectStart":0,"requestStart":434,"responseEnd":667.0999999046326,"responseStart":667.0999999046326,"secureConnectionStart":434},{"duration":272.40000009536743,"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":434.19999980926514,"connectEnd":434.19999980926514,"connectStart":434.19999980926514,"domainLookupEnd":434.19999980926514,"domainLookupStart":434.19999980926514,"fetchStart":434.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":434.19999980926514,"responseEnd":706.5999999046326,"responseStart":706.5999999046326,"secureConnectionStart":434.19999980926514},{"duration":275.59999990463257,"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":434.2999999523163,"connectEnd":434.2999999523163,"connectStart":434.2999999523163,"domainLookupEnd":434.2999999523163,"domainLookupStart":434.2999999523163,"fetchStart":434.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":434.2999999523163,"responseEnd":709.8999998569489,"responseStart":709.8999998569489,"secureConnectionStart":434.2999999523163},{"duration":276.2000000476837,"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":434.39999985694885,"connectEnd":434.39999985694885,"connectStart":434.39999985694885,"domainLookupEnd":434.39999985694885,"domainLookupStart":434.39999985694885,"fetchStart":434.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":434.39999985694885,"responseEnd":710.5999999046326,"responseStart":710.5999999046326,"secureConnectionStart":434.39999985694885},{"duration":281.2999999523163,"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":434.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":434.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":715.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":276.5,"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":434.5,"connectEnd":434.5,"connectStart":434.5,"domainLookupEnd":434.5,"domainLookupStart":434.5,"fetchStart":434.5,"redirectEnd":0,"redirectStart":0,"requestStart":434.5,"responseEnd":711,"responseStart":711,"secureConnectionStart":434.5},{"duration":277,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":434.69999980926514,"connectEnd":434.69999980926514,"connectStart":434.69999980926514,"domainLookupEnd":434.69999980926514,"domainLookupStart":434.69999980926514,"fetchStart":434.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":434.69999980926514,"responseEnd":711.6999998092651,"responseStart":711.6999998092651,"secureConnectionStart":434.69999980926514},{"duration":281.09999990463257,"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":434.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":434.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":715.8999998569489,"responseStart":0,"secureConnectionStart":0},{"duration":277.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":434.89999985694885,"connectEnd":434.89999985694885,"connectStart":434.89999985694885,"domainLookupEnd":434.89999985694885,"domainLookupStart":434.89999985694885,"fetchStart":434.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":434.89999985694885,"responseEnd":712.3999998569489,"responseStart":712.3999998569489,"secureConnectionStart":434.89999985694885},{"duration":916.1000001430511,"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":439.89999985694885,"connectEnd":439.89999985694885,"connectStart":439.89999985694885,"domainLookupEnd":439.89999985694885,"domainLookupStart":439.89999985694885,"fetchStart":439.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":439.89999985694885,"responseEnd":1356,"responseStart":1356,"secureConnectionStart":439.89999985694885},{"duration":1070.2999999523163,"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":440,"connectEnd":440,"connectStart":440,"domainLookupEnd":440,"domainLookupStart":440,"fetchStart":440,"redirectEnd":0,"redirectStart":0,"requestStart":440,"responseEnd":1510.2999999523163,"responseStart":1510.2999999523163,"secureConnectionStart":440},{"duration":623.2000000476837,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":886.5999999046326,"connectEnd":886.5999999046326,"connectStart":886.5999999046326,"domainLookupEnd":886.5999999046326,"domainLookupStart":886.5999999046326,"fetchStart":886.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":886.5999999046326,"responseEnd":1509.7999999523163,"responseStart":1509.7999999523163,"secureConnectionStart":886.5999999046326},{"duration":446,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1065,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1065,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1511,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":291,"responseStart":428,"responseEnd":433,"domLoading":431,"domInteractive":1534,"domContentLoadedEventStart":1534,"domContentLoadedEventEnd":1570,"domComplete":2052,"loadEventStart":2052,"loadEventEnd":2053,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1518.8999998569489},{"name":"bigPipe.sidebar-id.end","time":1519.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1519.8999998569489},{"name":"bigPipe.activity-panel-pipe-id.end","time":1522.2999999523163},{"name":"activityTabFullyLoaded","time":1576.6999998092651}],"measures":[],"correlationId":"cba53cceb4f99f","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":82,"dbReadsTimeInMs":18,"dbConnsTimeInMs":27,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}