Reproduce
When console client is run interactively:
Result
Thread 34 "mysqld" received signal SIGSEGV, Segmentation fault.
|
[Switching to Thread 0x7ffff47cb700 (LWP 10773)]
|
0x00000000014e585b in my_strcasecmp_utf8 (cs=0x1e47cf0 [my_charset_utf8_general_ci], s=0x1543906 "ALL_PLUGINS", t=0x0) at /home/midenok/src/mariadb/trunk2/src/strings/ctype-utf8.c:5109
|
5109 while (s[0] && t[0])
|
h1.0 0x00000000014e585b in my_strcasecmp_utf8 (cs=0x1e47cf0 [my_charset_utf8_general_ci], s=0x1543906 "ALL_PLUGINS", t=0x0) at /home/midenok/src/mariadb/trunk2/src/strings/ctype-utf8.c:5109
|
h1.1 0x00000000008a4810 in find_schema_table (thd=0x7fff84000cf8, table_name=0x7ffff47c9fa0, in_plugin=0x7ffff47c934f) at /home/midenok/src/mariadb/trunk2/src/sql/sql_show.cc:8058
|
h1.2 0x0000000000732e41 in find_schema_table (thd=0x7fff84000cf8, table_name=0x7ffff47c9fa0) at /home/midenok/src/mariadb/trunk2/src/sql/sql_show.h:127
|
h1.3 0x00000000007252c3 in open_and_process_table (thd=0x7fff84000cf8, lex=0x7fff84004b58, tables=0x7ffff47c9f68, counter=0x7ffff47c9834, flags=1024, prelocking_strategy=0x7ffff47c9838, has_prelocking_list=false, ot_ctx=0x7ffff47c96e8) at /home/midenok/src/mariadb/trunk2/src/sql/sql_base.cc:3598
|
h1.4 0x00000000007245ed in open_tables (thd=0x7fff84000cf8, options=..., start=0x7ffff47c9848, counter=0x7ffff47c9834, flags=1024, prelocking_strategy=0x7ffff47c9838) at /home/midenok/src/mariadb/trunk2/src/sql/sql_base.cc:4290
|
h1.5 0x00000000007292e5 in open_tables (thd=0x7fff84000cf8, tables=0x7ffff47c9848, counter=0x7ffff47c9834, flags=1024, prelocking_strategy=0x7ffff47c9838) at /home/midenok/src/mariadb/trunk2/src/sql/sql_base.h:256
|
h1.6 0x00000000007290a8 in open_normal_and_derived_tables (thd=0x7fff84000cf8, tables=0x7ffff47c9f68, flags=1024, dt_phases=35) at /home/midenok/src/mariadb/trunk2/src/sql/sql_base.cc:5237
|
h1.7 0x0000000000893bce in mysqld_list_fields (thd=0x7fff84000cf8, table_list=0x7ffff47c9f68, wild=0x7fff840130f0 "") at /home/midenok/src/mariadb/trunk2/src/sql/sql_show.cc:1570
|
h1.8 0x00000000007d2571 in dispatch_command (command=COM_FIELD_LIST, thd=0x7fff84000cf8, packet=0x7fff84009cf5 "", packet_length=12, is_com_multi=false, is_next_command=false) at /home/midenok/src/mariadb/trunk2/src/sql/sql_parse.cc:2040
|
frame 3 (cause)
(gdb) p tables->schema_table_name
|
$3 = {
|
str = 0x0,
|
length = 0
|
}
|
Fix
--- a/sql/sql_parse.cc
|
+++ b/sql/sql_parse.cc
|
@@ -2015,7 +2015,10 @@ bool dispatch_command(enum enum_server_command command, THD *thd,
|
{
|
ST_SCHEMA_TABLE *schema_table= find_schema_table(thd, &table_list.alias);
|
if (schema_table)
|
+ {
|
table_list.schema_table= schema_table;
|
+ table_list.schema_table_name= table_list.table_name;
|
+ }
|
}
|
|
uint query_length= (uint) (packet_end - packet); // Don't count end \0
|
There are no comments yet on this issue.
{"report":{"fcp":781.3999999761581,"ttfb":238.60000002384186,"pageVisibility":"visible","entityId":76087,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"49a91544-3024-4c9c-a16f-f777f29311ad","navigationType":0,"readyForUser":850.1000000238419,"redirectCount":0,"resourceLoadedEnd":387.39999997615814,"resourceLoadedStart":243.70000004768372,"resourceTiming":[{"duration":25.399999976158142,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":243.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":243.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":269.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":25.299999952316284,"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":244,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":244,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":269.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":114.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":244.20000004768372,"connectEnd":271.39999997615814,"connectStart":271.39999997615814,"domainLookupEnd":271.39999997615814,"domainLookupStart":271.39999997615814,"fetchStart":244.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":271.7000000476837,"responseEnd":359,"responseStart":285.7000000476837,"secureConnectionStart":271.39999997615814},{"duration":143.10000002384186,"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":244.29999995231628,"connectEnd":244.29999995231628,"connectStart":244.29999995231628,"domainLookupEnd":244.29999995231628,"domainLookupStart":244.29999995231628,"fetchStart":244.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":273,"responseEnd":387.39999997615814,"responseStart":293.2999999523163,"secureConnectionStart":244.29999995231628},{"duration":53.39999997615814,"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":244.5,"connectEnd":244.5,"connectStart":244.5,"domainLookupEnd":244.5,"domainLookupStart":244.5,"fetchStart":244.5,"redirectEnd":0,"redirectStart":0,"requestStart":273.5,"responseEnd":297.89999997615814,"responseStart":297,"secureConnectionStart":244.5},{"duration":52.09999990463257,"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":244.70000004768372,"connectEnd":244.70000004768372,"connectStart":244.70000004768372,"domainLookupEnd":244.70000004768372,"domainLookupStart":244.70000004768372,"fetchStart":244.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":274.5,"responseEnd":296.7999999523163,"responseStart":295.7999999523163,"secureConnectionStart":244.70000004768372},{"duration":54.60000002384186,"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":244.89999997615814,"connectEnd":244.89999997615814,"connectStart":244.89999997615814,"domainLookupEnd":244.89999997615814,"domainLookupStart":244.89999997615814,"fetchStart":244.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":275.2999999523163,"responseEnd":299.5,"responseStart":298.10000002384186,"secureConnectionStart":244.89999997615814},{"duration":29.899999976158142,"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":245.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":245.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":275,"responseStart":0,"secureConnectionStart":0},{"duration":54.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":245.20000004768372,"connectEnd":245.20000004768372,"connectStart":245.20000004768372,"domainLookupEnd":245.20000004768372,"domainLookupStart":245.20000004768372,"fetchStart":245.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":277.5,"responseEnd":300.10000002384186,"responseStart":298.7999999523163,"secureConnectionStart":245.20000004768372},{"duration":30.90000009536743,"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":245.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":245.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":276.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":59.799999952316284,"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":245.5,"connectEnd":245.5,"connectStart":245.5,"domainLookupEnd":245.5,"domainLookupStart":245.5,"fetchStart":245.5,"redirectEnd":0,"redirectStart":0,"requestStart":278.39999997615814,"responseEnd":305.2999999523163,"responseStart":303.2999999523163,"secureConnectionStart":245.5},{"duration":116.10000002384186,"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":258.5,"connectEnd":258.5,"connectStart":258.5,"domainLookupEnd":258.5,"domainLookupStart":258.5,"fetchStart":258.5,"redirectEnd":0,"redirectStart":0,"requestStart":311.10000002384186,"responseEnd":374.60000002384186,"responseStart":372.2999999523163,"secureConnectionStart":258.5},{"duration":116.5,"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":258.60000002384186,"connectEnd":258.60000002384186,"connectStart":258.60000002384186,"domainLookupEnd":258.60000002384186,"domainLookupStart":258.60000002384186,"fetchStart":258.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":345.60000002384186,"responseEnd":375.10000002384186,"responseStart":373.7999999523163,"secureConnectionStart":258.60000002384186},{"duration":179.60000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":559.7999999523163,"connectEnd":559.7999999523163,"connectStart":559.7999999523163,"domainLookupEnd":559.7999999523163,"domainLookupStart":559.7999999523163,"fetchStart":559.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":702.7000000476837,"responseEnd":739.3999999761581,"responseStart":738.6000000238419,"secureConnectionStart":559.7999999523163}],"fetchStart":0,"domainLookupStart":21,"domainLookupEnd":31,"connectStart":31,"connectEnd":52,"secureConnectionStart":40,"requestStart":52,"responseStart":239,"responseEnd":258,"domLoading":242,"domInteractive":897,"domContentLoadedEventStart":897,"domContentLoadedEventEnd":927,"domComplete":1356,"loadEventStart":1356,"loadEventEnd":1357,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":884.6000000238419},{"name":"bigPipe.sidebar-id.end","time":885.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":885.3999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":885.7999999523163},{"name":"activityTabFullyLoaded","time":937.1000000238419}],"measures":[],"correlationId":"d4ae7e624c01c7","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":115,"dbReadsTimeInMs":15,"dbConnsTimeInMs":25,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}