CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',DATABASE'',USER'',PASSWORD'');
|
SET GLOBAL wait_timeout=+1;
|
INSTALL PLUGIN Spider SONAME 'ha_spider.so';
|
CREATE TABLE t (c INT KEY,c1 BLOB,c2 TEXT) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv"';
|
XA START 'a';
|
INSERT INTO t VALUES (0,0,0,0);
|
SELECT SLEEP (4);
|
INSERT INTO t VALUES (1,2,3),(4,5,6),(7,8,9);
|
SELECT * FROM information_schema.key_column_usage;
|
Leads to:
11.0.2 5ba3bafb834dbc56e6105809ded9a7ccef70ee54 (Optimized)
|
Core was generated by `/test/MD060623-mariadb-11.0.2-linux-x86_64-opt/bin/mariadbd --no-defaults --cor'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 0x000055e2abdce487 in server_mysql_send_query (mysql=mysql@entry=0x0,
|
query=0x14e250201918 "set @old_lock_wait_timeout=@@session.lock_wait_timeout;set session lock_wait_timeout=1;", length=87)
|
at /test/11.0_opt/sql-common/client.c:3541
|
[Current thread is 1 (Thread 0x14e28c08f700 (LWP 64380))]
|
(gdb) bt
|
#0 0x000055e2abdce487 in server_mysql_send_query (mysql=mysql@entry=0x0, query=0x14e250201918 "set @old_lock_wait_timeout=@@session.lock_wait_timeout;set session lock_wait_timeout=1;", length=87) at /test/11.0_opt/sql-common/client.c:3541
|
#1 0x000055e2abdce516 in server_mysql_real_query (mysql=0x0, query=<optimized out>, length=<optimized out>) at /test/11.0_opt/sql-common/client.c:3558
|
#2 0x000014e278173738 in spider_db_mbase::exec_query (this=0x14e2500654e0, query=0x14e250201918 "set @old_lock_wait_timeout=@@session.lock_wait_timeout;set session lock_wait_timeout=1;", length=87, quick_mode=<optimized out>) at /test/11.0_opt/storage/spider/spd_db_mysql.cc:2083
|
#3 0x000014e278181c11 in spider_db_mbase::set_lock_wait_timeout (this=0x14e2500654e0, timeout=<optimized out>) at /test/11.0_opt/sql/sql_string.h:741
|
#4 0x000014e278182116 in spider_mbase_handler::show_table_status (this=0x14e250069390, link_idx=<optimized out>, sts_mode=1, flag=<optimized out>) at /test/11.0_opt/storage/spider/spd_db_mysql.cc:13595
|
#5 0x000014e278135411 in spider_get_sts (share=0x14e250061f38, link_idx=0, tmp_time=tmp_time@entry=1686553891, spider=spider@entry=0x14e2500247b0, sts_interval=sts_interval@entry=0, sts_mode=sts_mode@entry=1, sts_sync=sts_sync@entry=0, sts_sync_level=1, flag=86) at /test/11.0_opt/storage/spider/spd_table.cc:6822
|
#6 0x000014e278163b68 in ha_spider::info (this=0x14e2500247b0, flag=22) at /test/11.0_opt/storage/spider/ha_spider.cc:6690
|
#7 0x000055e2abc38b82 in get_schema_key_column_usage_record (res=false, table_name=0x14e250082008, db_name=0x14e250014670, table=0x14e250083d10, tables=<optimized out>, thd=0x14e250000c58) at /test/11.0_opt/sql/sql_show.cc:7448
|
#8 get_schema_key_column_usage_record (thd=0x14e250000c58, tables=<optimized out>, table=0x14e250083d10, res=<optimized out>, db_name=0x14e250014670, table_name=0x14e250082008) at /test/11.0_opt/sql/sql_show.cc:7426
|
#9 0x000055e2abc28218 in fill_schema_table_by_open (thd=0x14e250000c58, mem_root=<optimized out>, is_show_fields_or_keys=<optimized out>, table=0x14e250083d10, schema_table=0x55e2acc87ce0 <schema_tables+1280>, orig_db_name=0x14e250014670, orig_table_name=0x14e250082008, open_tables_state_backup=0x14e28c08bdf0, can_deadlock=true) at /test/11.0_opt/sql/sql_show.cc:4749
|
#10 0x000055e2abc3f7ea in get_all_tables (thd=0x14e250000c58, tables=0x14e250010ec8, cond=<optimized out>) at /test/11.0_opt/sql/sql_show.cc:5385
|
#11 0x000055e2abc40f2e in get_schema_tables_result (join=join@entry=0x14e250012560, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /test/11.0_opt/sql/sql_show.cc:9060
|
#12 0x000055e2abc23e97 in JOIN::exec_inner (this=0x14e250012560) at /test/11.0_opt/sql/sql_select.cc:4859
|
#13 0x000055e2abc247ae in JOIN::exec (this=this@entry=0x14e250012560) at /test/11.0_opt/sql/sql_select.cc:4680
|
#14 0x000055e2abc228ec in mysql_select (thd=0x14e250000c58, tables=0x14e250010ec8, fields=<optimized out>, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x14e250012538, unit=0x14e250004ce0, select_lex=0x14e250010830) at /test/11.0_opt/sql/sql_select.cc:5161
|
#15 0x000055e2abc23037 in handle_select (thd=thd@entry=0x14e250000c58, lex=lex@entry=0x14e250004c08, result=result@entry=0x14e250012538, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/11.0_opt/sql/sql_select.cc:619
|
#16 0x000055e2abba01fe in execute_sqlcom_select (thd=0x14e250000c58, all_tables=0x14e250010ec8) at /test/11.0_opt/sql/sql_parse.cc:6279
|
#17 0x000055e2abbae0d4 in mysql_execute_command (thd=0x14e250000c58, is_called_from_prepared_stmt=<optimized out>) at /test/11.0_opt/sql/sql_parse.cc:3949
|
#18 0x000055e2abb9ae55 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x14e250000c58) at /test/11.0_opt/sql/sql_parse.cc:8014
|
#19 mysql_parse (thd=0x14e250000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/11.0_opt/sql/sql_parse.cc:7936
|
#20 0x000055e2abba7142 in dispatch_command (command=COM_QUERY, thd=0x14e250000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/11.0_opt/sql/sql_class.h:1370
|
#21 0x000055e2abba8f5e in do_command (thd=0x14e250000c58, blocking=blocking@entry=true) at /test/11.0_opt/sql/sql_parse.cc:1407
|
#22 0x000055e2abcc850f in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55e2adfbbaf8, put_in_cache=put_in_cache@entry=true) at /test/11.0_opt/sql/sql_connect.cc:1416
|
#23 0x000055e2abcc87fd in handle_one_connection (arg=0x55e2adfbbaf8) at /test/11.0_opt/sql/sql_connect.cc:1318
|
#24 0x000014e2a453a609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#25 0x000014e2a4126133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 11.0.2 (dbg), 11.0.2 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.30 (dbg), 10.4.30 (opt), 10.5.21 (dbg), 10.5.21 (opt), 10.6.14 (dbg), 10.6.14 (opt), 10.9.7 (dbg), 10.9.7 (opt), 10.10.5 (dbg), 10.10.5 (opt), 10.11.4 (dbg), 10.11.4 (opt), 11.1.0 (dbg), 11.1.0 (opt)
{"report":{"fcp":781.5,"ttfb":202.79999995231628,"pageVisibility":"visible","entityId":122675,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"8698f0a5-cebe-4a92-9749-f0cf2c34666d","navigationType":0,"readyForUser":863.5,"redirectCount":0,"resourceLoadedEnd":510.89999985694885,"resourceLoadedStart":211.39999985694885,"resourceTiming":[{"duration":14.799999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":211.39999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":211.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":226.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":14.700000047683716,"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":211.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":211.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":226.29999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":185.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":211.69999980926514,"connectEnd":211.69999980926514,"connectStart":211.69999980926514,"domainLookupEnd":211.69999980926514,"domainLookupStart":211.69999980926514,"fetchStart":211.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":232.69999980926514,"responseEnd":397.5,"responseStart":259,"secureConnectionStart":211.69999980926514},{"duration":299,"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":211.89999985694885,"connectEnd":211.89999985694885,"connectStart":211.89999985694885,"domainLookupEnd":211.89999985694885,"domainLookupStart":211.89999985694885,"fetchStart":211.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":232.79999995231628,"responseEnd":510.89999985694885,"responseStart":291.7999999523163,"secureConnectionStart":211.89999985694885},{"duration":50.69999980926514,"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":212,"connectEnd":212,"connectStart":212,"domainLookupEnd":212,"domainLookupStart":212,"fetchStart":212,"redirectEnd":0,"redirectStart":0,"requestStart":232.89999985694885,"responseEnd":262.69999980926514,"responseStart":260.39999985694885,"secureConnectionStart":212},{"duration":61.799999952316284,"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":212.09999990463257,"connectEnd":212.09999990463257,"connectStart":212.09999990463257,"domainLookupEnd":212.09999990463257,"domainLookupStart":212.09999990463257,"fetchStart":212.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":233.29999995231628,"responseEnd":273.89999985694885,"responseStart":270.5,"secureConnectionStart":212.09999990463257},{"duration":19.299999952316284,"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":212.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":212.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":231.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":61.89999985694885,"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":212.29999995231628,"connectEnd":212.29999995231628,"connectStart":212.29999995231628,"domainLookupEnd":212.29999995231628,"domainLookupStart":212.29999995231628,"fetchStart":212.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":233.69999980926514,"responseEnd":274.19999980926514,"responseStart":271.89999985694885,"secureConnectionStart":212.29999995231628},{"duration":99.10000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":212.39999985694885,"connectEnd":212.39999985694885,"connectStart":212.39999985694885,"domainLookupEnd":212.39999985694885,"domainLookupStart":212.39999985694885,"fetchStart":212.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":234.79999995231628,"responseEnd":311.5,"responseStart":309.7999999523163,"secureConnectionStart":212.39999985694885},{"duration":19.799999952316284,"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":212.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":212.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":232.29999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":61.700000047683716,"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":212.69999980926514,"connectEnd":212.69999980926514,"connectStart":212.69999980926514,"domainLookupEnd":212.69999980926514,"domainLookupStart":212.69999980926514,"fetchStart":212.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":235.19999980926514,"responseEnd":274.39999985694885,"responseStart":272.5,"secureConnectionStart":212.69999980926514},{"duration":264.89999985694885,"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":215.5,"connectEnd":215.5,"connectStart":215.5,"domainLookupEnd":215.5,"domainLookupStart":215.5,"fetchStart":215.5,"redirectEnd":0,"redirectStart":0,"requestStart":258.09999990463257,"responseEnd":480.39999985694885,"responseStart":477,"secureConnectionStart":215.5},{"duration":264.09999990463257,"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":220.29999995231628,"connectEnd":220.29999995231628,"connectStart":220.29999995231628,"domainLookupEnd":220.29999995231628,"domainLookupStart":220.29999995231628,"fetchStart":220.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":262.89999985694885,"responseEnd":484.39999985694885,"responseStart":481.19999980926514,"secureConnectionStart":220.29999995231628},{"duration":117.89999985694885,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":544.2999999523163,"connectEnd":544.2999999523163,"connectStart":544.2999999523163,"domainLookupEnd":544.2999999523163,"domainLookupStart":544.2999999523163,"fetchStart":544.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":631.6999998092651,"responseEnd":662.1999998092651,"responseStart":661.3999998569489,"secureConnectionStart":544.2999999523163},{"duration":120.19999980926514,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":774,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":774,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":894.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":146.29999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":780.2999999523163,"connectEnd":780.2999999523163,"connectStart":780.2999999523163,"domainLookupEnd":780.2999999523163,"domainLookupStart":780.2999999523163,"fetchStart":780.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":896.0999999046326,"responseEnd":926.5999999046326,"responseStart":923.8999998569489,"secureConnectionStart":780.2999999523163}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":38,"responseStart":203,"responseEnd":220,"domLoading":206,"domInteractive":965,"domContentLoadedEventStart":965,"domContentLoadedEventEnd":1012,"domComplete":1371,"loadEventStart":1371,"loadEventEnd":1372,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":939.8999998569489},{"name":"bigPipe.sidebar-id.end","time":940.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":940.8999998569489},{"name":"bigPipe.activity-panel-pipe-id.end","time":942.5},{"name":"activityTabFullyLoaded","time":1031.2999999523163}],"measures":[],"correlationId":"e946fde10457ea","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":77,"dbReadsTimeInMs":13,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Raising the prio because this is a new failure caused by a recent change