Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11 , 11.0(EOL)
INSTALL SONAME 'ha_connect' ;
CREATE TABLE t1 (c INT NOT NULL , KEY idx(c)) ENGINE= CONNECT ;
INSERT INTO t1 VALUES (1), (2);
SET alter_algorithm=COPY;
DROP INDEX idx ON t1;
# Cleanup
DROP TABLE t1;
UNINSTALL SONAME 'ha_connect' ;
10.8 e4b83f0f
#3 <signal handler called>
#4 0x00007f7a83562717 in ha_connect::create (this=0x61d00023beb8, name=0x7f7a83ee8a7f "./test/#sql-alter-27789b-4", table_arg=0x7f7a83ee54a0, create_info=0x7f7a83ee92d0) at /data/src/10.8/storage/connect/ha_connect.cc:6955
#5 0x0000561d3a2030d3 in handler::ha_create (this=0x61d00023beb8, name=0x7f7a83ee8a7f "./test/#sql-alter-27789b-4", form=0x7f7a83ee54a0, info_arg=0x7f7a83ee92d0) at /data/src/10.8/sql/handler.cc:5496
#6 0x0000561d3a207822 in ha_create_table (thd=0x62b00007e218, path=0x7f7a83ee8a7f "./test/#sql-alter-27789b-4", db=0x6290000e6a88 "test", table_name=0x6290000e62f8 "t1", create_info=0x7f7a83ee92d0, frm=0x7f7a83ee6190, skip_frm_file=false) at /data/src/10.8/sql/handler.cc:5964
#7 0x0000561d39c1d3d7 in mysql_alter_table (thd=0x62b00007e218, new_db=0x6290000e6390, new_name=0x6290000e63a0, create_info=0x7f7a83ee92d0, table_list=0x6290000e6378, recreate_info=0x7f7a83ee9080, alter_info=0x7f7a83ee91a0, order_num=0, order=0x0, ignore=false, if_exists=false) at /data/src/10.8/sql/sql_table.cc:10868
#8 0x0000561d3992d6dd in mysql_execute_command (thd=0x62b00007e218, is_called_from_prepared_stmt=false) at /data/src/10.8/sql/sql_parse.cc:4213
#9 0x0000561d399484af in mysql_parse (thd=0x62b00007e218, rawbuf=0x6290000e6238 "DROP INDEX idx ON t1", length=20, parser_state=0x7f7a83ee9a30) at /data/src/10.8/sql/sql_parse.cc:8019
#10 0x0000561d3991e64a in dispatch_command (command=COM_QUERY, thd=0x62b00007e218, packet=0x629000262219 "DROP INDEX idx ON t1", packet_length=20, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1894
#11 0x0000561d3991b3a3 in do_command (thd=0x62b00007e218, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1407
#12 0x0000561d39dbc7b2 in do_handle_one_connection (connect=0x608000002e38, put_in_cache=true) at /data/src/10.8/sql/sql_connect.cc:1416
#13 0x0000561d39dbc173 in handle_one_connection (arg=0x608000002db8) at /data/src/10.8/sql/sql_connect.cc:1318
#14 0x0000561d3a99b276 in pfs_spawn_thread (arg=0x617000005b98) at /data/src/10.8/storage/perfschema/pfs.cc:2201
#15 0x00007f7a8b6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#16 0x00007f7a8b72866c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
The failure started happening after this commit in 10.8:
commit 4c6e8fc572e5a1dbe100f20d471be65aecbb5225
Author: Sergei Golubchik
Date: Mon Jan 24 18:38:12 2022 +0100
MDEV-27591 Connect tables (FIX/DOS) don't work with DESC keys - wrong results
is caused by
MDEV-27591
Connect tables (FIX/DOS) don't work with DESC keys - wrong results
Closed
There are no comments yet on this issue.
{"report":{"fcp":1641.5,"ttfb":510,"pageVisibility":"visible","entityId":120468,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"547dab33-f21c-4b7d-b8f5-62b45ec15f15","navigationType":0,"readyForUser":1832.3999999994412,"redirectCount":0,"resourceLoadedEnd":1601,"resourceLoadedStart":523.0999999996275,"resourceTiming":[{"duration":187.70000000018626,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":523.0999999996275,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":523.0999999996275,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":710.7999999998137,"responseStart":0,"secureConnectionStart":0},{"duration":186,"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":525.1999999992549,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":525.1999999992549,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":711.1999999992549,"responseStart":0,"secureConnectionStart":0},{"duration":395,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":525.2999999998137,"connectEnd":711.1999999992549,"connectStart":711.1999999992549,"domainLookupEnd":711.1999999992549,"domainLookupStart":711.1999999992549,"fetchStart":525.2999999998137,"redirectEnd":0,"redirectStart":0,"requestStart":714.0999999996275,"responseEnd":920.2999999998137,"responseStart":728.5,"secureConnectionStart":711.1999999992549},{"duration":242.29999999981374,"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":525.5,"connectEnd":525.5,"connectStart":525.5,"domainLookupEnd":525.5,"domainLookupStart":525.5,"fetchStart":525.5,"redirectEnd":0,"redirectStart":0,"requestStart":714.5999999996275,"responseEnd":767.7999999998137,"responseStart":746,"secureConnectionStart":525.5},{"duration":663.2999999998137,"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":525.5,"connectEnd":525.5,"connectStart":525.5,"domainLookupEnd":525.5,"domainLookupStart":525.5,"fetchStart":525.5,"redirectEnd":0,"redirectStart":0,"requestStart":714.5,"responseEnd":1188.7999999998137,"responseStart":736.5,"secureConnectionStart":525.5},{"duration":225.59999999962747,"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":525.7999999998137,"connectEnd":525.7999999998137,"connectStart":525.7999999998137,"domainLookupEnd":525.7999999998137,"domainLookupStart":525.7999999998137,"fetchStart":525.7999999998137,"redirectEnd":0,"redirectStart":0,"requestStart":714.7999999998137,"responseEnd":751.3999999994412,"responseStart":738.5,"secureConnectionStart":525.7999999998137},{"duration":242.80000000074506,"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":526.1999999992549,"connectEnd":526.1999999992549,"connectStart":526.1999999992549,"domainLookupEnd":526.1999999992549,"domainLookupStart":526.1999999992549,"fetchStart":526.1999999992549,"redirectEnd":0,"redirectStart":0,"requestStart":715,"responseEnd":769,"responseStart":752.8999999994412,"secureConnectionStart":526.1999999992549},{"duration":187.69999999925494,"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":526.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":526.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":714.1999999992549,"responseStart":0,"secureConnectionStart":0},{"duration":239.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":526.5999999996275,"connectEnd":526.5999999996275,"connectStart":526.5999999996275,"domainLookupEnd":526.5999999996275,"domainLookupStart":526.5999999996275,"fetchStart":526.5999999996275,"redirectEnd":0,"redirectStart":0,"requestStart":715.0999999996275,"responseEnd":766.0999999996275,"responseStart":740.2999999998137,"secureConnectionStart":526.5999999996275},{"duration":185,"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":529.1999999992549,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":529.1999999992549,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":714.1999999992549,"responseStart":0,"secureConnectionStart":0},{"duration":261.3999999994412,"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":529.2999999998137,"connectEnd":529.2999999998137,"connectStart":529.2999999998137,"domainLookupEnd":529.2999999998137,"domainLookupStart":529.2999999998137,"fetchStart":529.2999999998137,"redirectEnd":0,"redirectStart":0,"requestStart":768.6999999992549,"responseEnd":790.6999999992549,"responseStart":789,"secureConnectionStart":529.2999999998137},{"duration":1065.9000000003725,"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":535.0999999996275,"connectEnd":535.0999999996275,"connectStart":535.0999999996275,"domainLookupEnd":535.0999999996275,"domainLookupStart":535.0999999996275,"fetchStart":535.0999999996275,"redirectEnd":0,"redirectStart":0,"requestStart":1583.5999999996275,"responseEnd":1601,"responseStart":1599.7999999998137,"secureConnectionStart":535.0999999996275},{"duration":1065.7999999998137,"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":535.0999999996275,"connectEnd":535.0999999996275,"connectStart":535.0999999996275,"domainLookupEnd":535.0999999996275,"domainLookupStart":535.0999999996275,"fetchStart":535.0999999996275,"redirectEnd":0,"redirectStart":0,"requestStart":1583.0999999996275,"responseEnd":1600.8999999994412,"responseStart":1599.3999999994412,"secureConnectionStart":535.0999999996275},{"duration":573.2999999998137,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1060.5999999996275,"connectEnd":1060.5999999996275,"connectStart":1060.5999999996275,"domainLookupEnd":1060.5999999996275,"domainLookupStart":1060.5999999996275,"fetchStart":1060.5999999996275,"redirectEnd":0,"redirectStart":0,"requestStart":1583.7999999998137,"responseEnd":1633.8999999994412,"responseStart":1619.199999999255,"secureConnectionStart":1060.5999999996275},{"duration":559.0999999996275,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1625,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1625,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2184.0999999996275,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":381,"responseStart":510,"responseEnd":521,"domLoading":514,"domInteractive":2106,"domContentLoadedEventStart":2106,"domContentLoadedEventEnd":2183,"domComplete":3733,"loadEventStart":3733,"loadEventEnd":3733,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1986},{"name":"bigPipe.sidebar-id.end","time":1986.7999999998137},{"name":"bigPipe.activity-panel-pipe-id.start","time":1987},{"name":"bigPipe.activity-panel-pipe-id.end","time":1987.3999999994412},{"name":"activityTabFullyLoaded","time":2199.699999999255}],"measures":[],"correlationId":"40a16ec1d17502","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":65,"dbReadsTimeInMs":11,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}