Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
None
Component/s:
None
#3 <signal handler called>
#4 0x00007fa0aababc9c in spider_mysql_handler::append_match_against (this=0x7fa09c06d890, str=0x7fa09c06d8d0, ft_info=0x7fa09c0765d8, alias=0x0, alias_length=0) at 10.0/storage/spider/spd_db_mysql.cc:6595
#5 0x00007fa0aabac2fe in spider_mysql_handler::append_match_select (this=0x7fa09c06d890, str=0x7fa09c06d8d0, alias=0x0, alias_length=0) at 10.0/storage/spider/spd_db_mysql.cc:6693
#6 0x00007fa0aabac225 in spider_mysql_handler::append_match_select_part (this=0x7fa09c06d890, sql_type=1, alias=0x0, alias_length=0) at 10.0/storage/spider/spd_db_mysql.cc:6676
#7 0x00007fa0aab8f720 in ha_spider::append_match_select_sql_part (this=0x7fa09c068c00, sql_type=1, alias=0x0, alias_length=0) at 10.0/storage/spider/ha_spider.cc:12532
#8 0x00007fa0aab06a41 in spider_db_append_select_columns (spider=0x7fa09c068c00) at 10.0/storage/spider/spd_db_conn.cc:1334
#9 0x00007fa0aab80206 in ha_spider::rnd_next_internal (this=0x7fa09c068c00, buf=0x7fa09c0f8b10 "\377") at 10.0/storage/spider/ha_spider.cc:6833
#10 0x00007fa0aab8128a in ha_spider::rnd_next (this=0x7fa09c068c00, buf=0x7fa09c0f8b10 "\377") at 10.0/storage/spider/ha_spider.cc:7104
#11 0x000000000080859f in handler::ha_rnd_next (this=0x7fa09c068c00, buf=0x7fa09c0f8b10 "\377") at 10.0/sql/handler.cc:2441
#12 0x0000000000935b35 in rr_sequential (info=0x7fa09c075bd0) at 10.0/sql/records.cc:458
#13 0x0000000000683b16 in join_init_read_record (tab=0x7fa09c075b20) at 10.0/sql/sql_select.cc:17661
#14 0x0000000000681b7e in sub_select (join=0x7fa09c0743d0, join_tab=0x7fa09c075b20, end_of_records=false) at 10.0/sql/sql_select.cc:16773
#15 0x0000000000681499 in do_select (join=0x7fa09c0743d0, fields=0x240a5c0, table=0x0, procedure=0x0) at 10.0/sql/sql_select.cc:16446
#16 0x00000000006601f4 in JOIN::exec_inner (this=0x7fa09c0743d0) at 10.0/sql/sql_select.cc:2993
#17 0x000000000065d4a1 in JOIN::exec (this=0x7fa09c0743d0) at 10.0/sql/sql_select.cc:2291
#18 0x0000000000660a98 in mysql_select (thd=0x24063a8, rref_pointer_array=0x240a758, tables=0x7fa09c06eda0, wild_num=1, fields=..., conds=0x7fa09c06f4d0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fa09c04f390, unit=0x2409db0, select_lex=0x240a4a8) at 10.0/sql/sql_select.cc:3221
#19 0x00000000006571fb in handle_select (thd=0x24063a8, lex=0x2409cf8, result=0x7fa09c04f390, setup_tables_done_option=0) at 10.0/sql/sql_select.cc:371
#20 0x000000000062adc1 in execute_sqlcom_select (thd=0x24063a8, all_tables=0x7fa09c06eda0) at 10.0/sql/sql_parse.cc:5043
#21 0x0000000000623381 in mysql_execute_command (thd=0x24063a8) at 10.0/sql/sql_parse.cc:2483
#22 0x000000000062d680 in mysql_parse (thd=0x24063a8, rawbuf=0x7fa09c027cc0 "SELECT * FROM t1 WHERE MATCH(v2) AGAINST ('abc' IN BOOLEAN MODE)", length=64, parser_state=0x7fa0b80ec500) at 10.0/sql/sql_parse.cc:6176
#23 0x0000000000620556 in dispatch_command (command=COM_QUERY, thd=0x24063a8, packet=0x240b5a9 "", packet_length=64) at 10.0/sql/sql_parse.cc:1274
#24 0x000000000061f9cc in do_command (thd=0x24063a8) at 10.0/sql/sql_parse.cc:983
#25 0x000000000073d820 in do_handle_one_connection (thd_arg=0x24063a8) at 10.0/sql/sql_connect.cc:1267
#26 0x000000000073d573 in handle_one_connection (arg=0x24063a8) at 10.0/sql/sql_connect.cc:1181
#27 0x00000000009d32b4 in pfs_spawn_thread (arg=0x227aeb8) at 10.0/storage/perfschema/pfs.cc:1800
#28 0x00007fa0bd220e9a in start_thread (arg=0x7fa0b80ed700) at pthread_create.c:308
#29 0x00007fa0bc2fecbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
bzr version-info
revision-id: svoj@mariadb.org-20130627111848-b8kc0z60ywwpqavz
revno: 3762
branch-nick: 10.0
Test case:
CREATE TABLE mysql.spider_tables(
db_name char (64) not null default '' ,
table_name char (64) not null default '' ,
link_id int not null default 0,
priority bigint not null default 0,
server char (64) default null ,
scheme char (64) default null ,
host char (64) default null ,
port char (5) default null ,
socket text default null ,
username char (64) default null ,
password char (64) default null ,
ssl_ca text default null ,
ssl_capath text default null ,
ssl_cert text default null ,
ssl_cipher char (64) default null ,
ssl_key text default null ,
ssl_verify_server_cert tinyint not null default 0,
default_file text default null ,
default_group char (64) default null ,
tgt_db_name char (64) default null ,
tgt_table_name char (64) default null ,
link_status tinyint not null default 1,
PRIMARY KEY (db_name, table_name, link_id),
KEY idx1 (priority)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE =utf8_bin;
install soname 'ha_spider.so' ;
create database remote;
CREATE TABLE remote.t1 (
v2 TEXT
) ENGINE=MyISAM;
eval CREATE TABLE t1 (
v2 TEXT
) ENGINE=SPIDER CONNECTION = 'host "localhost", socket "$MASTER_MYSOCK", user "root", password "", prt "2000000"' COMMENT= 'database "remote", table "t1"' ;
INSERT INTO t1 VALUES ( 'foo' ),( 'bar' );
SELECT * FROM t1 WHERE MATCH(v2) AGAINST ( 'abc' IN BOOLEAN MODE);
relates to
MDEV-4438
Spider storage engine
Closed
{"report":{"fcp":1172.3000001907349,"ttfb":425.69999980926514,"pageVisibility":"visible","entityId":24482,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"2abe587a-e3cb-4ecc-97b7-bbcf260708f4","navigationType":0,"readyForUser":1259.8999996185303,"redirectCount":0,"resourceLoadedEnd":855.6999998092651,"resourceLoadedStart":434.30000019073486,"resourceTiming":[{"duration":36.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":434.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":434.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":470.5,"responseStart":0,"secureConnectionStart":0},{"duration":36.10000038146973,"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":434.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":434.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":470.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":271.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":434.8999996185303,"connectEnd":434.8999996185303,"connectStart":434.8999996185303,"domainLookupEnd":434.8999996185303,"domainLookupStart":434.8999996185303,"fetchStart":434.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":474.69999980926514,"responseEnd":706.3999996185303,"responseStart":495.80000019073486,"secureConnectionStart":434.8999996185303},{"duration":419.30000019073486,"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":436.3999996185303,"connectEnd":436.3999996185303,"connectStart":436.3999996185303,"domainLookupEnd":436.3999996185303,"domainLookupStart":436.3999996185303,"fetchStart":436.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":475.3999996185303,"responseEnd":855.6999998092651,"responseStart":511.30000019073486,"secureConnectionStart":436.3999996185303},{"duration":55.70000076293945,"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":436.5999994277954,"connectEnd":436.5999994277954,"connectStart":436.5999994277954,"domainLookupEnd":436.5999994277954,"domainLookupStart":436.5999994277954,"fetchStart":436.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":476,"responseEnd":492.30000019073486,"responseStart":490.0999994277954,"secureConnectionStart":436.5999994277954},{"duration":64.69999980926514,"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":436.80000019073486,"connectEnd":436.80000019073486,"connectStart":436.80000019073486,"domainLookupEnd":436.80000019073486,"domainLookupStart":436.80000019073486,"fetchStart":436.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":479.5999994277954,"responseEnd":501.5,"responseStart":499.19999980926514,"secureConnectionStart":436.80000019073486},{"duration":67.80000019073486,"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":436.8999996185303,"connectEnd":436.8999996185303,"connectStart":436.8999996185303,"domainLookupEnd":436.8999996185303,"domainLookupStart":436.8999996185303,"fetchStart":436.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":481.8999996185303,"responseEnd":504.69999980926514,"responseStart":501.8999996185303,"secureConnectionStart":436.8999996185303},{"duration":41.10000038146973,"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":437.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":437.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":478.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":67.59999942779541,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":437.30000019073486,"connectEnd":437.30000019073486,"connectStart":437.30000019073486,"domainLookupEnd":437.30000019073486,"domainLookupStart":437.30000019073486,"fetchStart":437.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":482.30000019073486,"responseEnd":504.8999996185303,"responseStart":502.80000019073486,"secureConnectionStart":437.30000019073486},{"duration":41.39999961853027,"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":437.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":437.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":478.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":71.60000038146973,"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":437.5999994277954,"connectEnd":437.5999994277954,"connectStart":437.5999994277954,"domainLookupEnd":437.5999994277954,"domainLookupStart":437.5999994277954,"fetchStart":437.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":483.5999994277954,"responseEnd":509.19999980926514,"responseStart":505.5999994277954,"secureConnectionStart":437.5999994277954},{"duration":395.5999994277954,"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":438.5,"connectEnd":438.5,"connectStart":438.5,"domainLookupEnd":438.5,"domainLookupStart":438.5,"fetchStart":438.5,"redirectEnd":0,"redirectStart":0,"requestStart":579.8999996185303,"responseEnd":834.0999994277954,"responseStart":828.8999996185303,"secureConnectionStart":438.5},{"duration":402.20000076293945,"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":438.5999994277954,"connectEnd":438.5999994277954,"connectStart":438.5999994277954,"domainLookupEnd":438.5999994277954,"domainLookupStart":438.5999994277954,"fetchStart":438.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":665,"responseEnd":840.8000001907349,"responseStart":835.1999998092651,"secureConnectionStart":438.5999994277954},{"duration":147.79999923706055,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":843.3000001907349,"connectEnd":843.3000001907349,"connectStart":843.3000001907349,"domainLookupEnd":843.3000001907349,"domainLookupStart":843.3000001907349,"fetchStart":843.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":956.1999998092651,"responseEnd":991.0999994277954,"responseStart":990.5999994277954,"secureConnectionStart":843.3000001907349}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":224,"responseStart":425,"responseEnd":432,"domLoading":429,"domInteractive":1375,"domContentLoadedEventStart":1375,"domContentLoadedEventEnd":1433,"domComplete":2368,"loadEventStart":2368,"loadEventEnd":2368,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1314.6999998092651},{"name":"bigPipe.sidebar-id.end","time":1315.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.start","time":1315.5999994277954},{"name":"bigPipe.activity-panel-pipe-id.end","time":1316.3999996185303},{"name":"activityTabFullyLoaded","time":1449.5999994277954}],"measures":[],"correlationId":"1765410634f494","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":116,"dbReadsTimeInMs":10,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Fixed in 10.0.5, revision-id: svoj@mariadb.org-20130923122231-78nh409e4s8j45k2