--source include/have_partition.inc
|
|
INSTALL PLUGIN Spider SONAME 'ha_spider.so';
|
CREATE TABLE t (a INT) ENGINE=Spider PARTITION BY LIST (a) PARTITIONS 2 (PARTITION p1 VALUES IN (0,1),PARTITION p2 VALUES IN (2,3));
|
DELETE FROM t PARTITION (p2);
|
Leads to:
10.5.25 7d36919f4b73a2507555ed101ccd02cb266dcc52 (Optimized)
|
Core was generated by `/test/MD200324-mariadb-10.5.25-linux-x86_64-opt/bin/mariadbd --no-defaults --ma'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 0x0000150314141452 in ha_spider::need_info_for_auto_inc (
|
this=0x1502943217d0) at /test/server_opt/storage/spider/ha_spider.cc:9433
|
9433 DBUG_RETURN((
|
[Current thread is 1 (Thread 0x150328078700 (LWP 3742349))]
|
(gdb) bt
|
#0 0x0000150314141452 in ha_spider::need_info_for_auto_inc (this=0x1502943217d0) at /test/server_opt/storage/spider/ha_spider.cc:9433
|
#1 0x00005633cb323766 in ha_partition::need_info_for_auto_inc (this=0x1502942c8810) at /test/server_opt/sql/ha_partition.cc:10761
|
#2 ha_partition::external_lock (this=0x1502942c8810, thd=<optimized out>, lock_type=1) at /test/server_opt/sql/ha_partition.cc:4189
|
#3 0x00005633cb0b13c4 in handler::ha_external_lock (this=0x1502942c8810, thd=thd@entry=0x150294000c58, lock_type=lock_type@entry=1) at /test/server_opt/sql/handler.cc:6792
|
#4 0x00005633cb1bfc60 in lock_external (count=<optimized out>, tables=0x150294010ec8, thd=0x150294000c58) at /test/server_opt/sql/lock.cc:396
|
#5 mysql_lock_tables (thd=thd@entry=0x150294000c58, sql_lock=sql_lock@entry=0x150294010e88, flags=flags@entry=0) at /test/server_opt/sql/lock.cc:341
|
#6 0x00005633cb1c09d7 in mysql_lock_tables (thd=thd@entry=0x150294000c58, tables=0x150294010e80, count=count@entry=1, flags=flags@entry=0) at /test/server_opt/sql/lock.cc:304
|
#7 0x00005633cae0ee7f in lock_tables (thd=thd@entry=0x150294000c58, tables=0x1502940105c0, count=<optimized out>, flags=flags@entry=0) at /test/server_opt/sql/sql_base.cc:5497
|
#8 0x00005633cae10bb2 in open_and_lock_tables (thd=thd@entry=0x150294000c58, options=<optimized out>, tables=<optimized out>, tables@entry=0x1502940105c0, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x150328076580) at /test/server_opt/sql/sql_base.cc:5257
|
#9 0x00005633cb2217ec in open_and_lock_tables (flags=0, derived=true, tables=0x1502940105c0, thd=0x150294000c58) at /test/server_opt/sql/sql_base.h:508
|
#10 mysql_delete (thd=thd@entry=0x150294000c58, table_list=0x1502940105c0, conds=<optimized out>, order_list=order_list@entry=0x150294005738, limit=18446744073709551615, options=0, result=0x0) at /test/server_opt/sql/sql_delete.cc:343
|
#11 0x00005633cae809ff in mysql_execute_command (thd=0x150294000c58) at /test/server_opt/sql/sql_limit.h:78
|
#12 0x00005633cae6e3d6 in mysql_parse (thd=0x150294000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/server_opt/sql/sql_parse.cc:8196
|
#13 0x00005633cae7b605 in dispatch_command (command=COM_QUERY, thd=0x150294000c58, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/server_opt/sql/sql_class.h:1329
|
#14 0x00005633cae7dd73 in do_command (thd=0x150294000c58) at /test/server_opt/sql/sql_parse.cc:1375
|
#15 0x00005633caf8b711 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5633cdcea0f8, put_in_cache=put_in_cache@entry=true) at /test/server_opt/sql/sql_connect.cc:1415
|
#16 0x00005633caf8bb9d in handle_one_connection (arg=arg@entry=0x5633cdcea0f8) at /test/server_opt/sql/sql_connect.cc:1317
|
#17 0x00005633cb338fe0 in pfs_spawn_thread (arg=0x5633cdbf6328) at /test/server_opt/storage/perfschema/pfs.cc:2201
|
#18 0x0000150329c45609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#19 0x0000150329831133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.5.25 (dbg), 10.5.25 (opt), 10.6.18 (dbg), 10.6.18 (opt), 10.11.8 (dbg), 10.11.8 (opt), 11.0.6 (dbg), 11.0.6 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.33 (dbg), 10.4.33 (opt), 10.4.34 (opt), 11.1.4 (dbg), 11.1.4 (opt), 11.2.4 (dbg), 11.2.4 (opt), 11.3.2 (dbg), 11.3.2 (opt), 11.4.2 (dbg), 11.4.2 (opt), 11.5.0 (dbg), 11.5.0 (opt)
- relates to
-
MDEV-32839
LONG UNIQUE gives error when used with REPLACE
-
-
Closed
{"report":{"fcp":898.2000000029802,"ttfb":266,"pageVisibility":"visible","entityId":128445,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"b222d152-1f02-4feb-9dbe-4987f332030e","navigationType":0,"readyForUser":979.1000000014901,"redirectCount":0,"resourceLoadedEnd":1110.2000000029802,"resourceLoadedStart":271.8999999985099,"resourceTiming":[{"duration":43.400000005960464,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":271.8999999985099,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":271.8999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":315.30000000447035,"responseStart":0,"secureConnectionStart":0},{"duration":43.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":272.1000000014901,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":272.1000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":315.6000000014901,"responseStart":0,"secureConnectionStart":0},{"duration":109,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":272.30000000447035,"connectEnd":272.30000000447035,"connectStart":272.30000000447035,"domainLookupEnd":272.30000000447035,"domainLookupStart":272.30000000447035,"fetchStart":272.30000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":272.30000000447035,"responseEnd":381.30000000447035,"responseStart":381.30000000447035,"secureConnectionStart":272.30000000447035},{"duration":211.10000000149012,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":272.5,"connectEnd":272.5,"connectStart":272.5,"domainLookupEnd":272.5,"domainLookupStart":272.5,"fetchStart":272.5,"redirectEnd":0,"redirectStart":0,"requestStart":272.5,"responseEnd":483.6000000014901,"responseStart":483.6000000014901,"secureConnectionStart":272.5},{"duration":214.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":272.80000000447035,"connectEnd":272.80000000447035,"connectStart":272.80000000447035,"domainLookupEnd":272.80000000447035,"domainLookupStart":272.80000000447035,"fetchStart":272.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":272.80000000447035,"responseEnd":487.30000000447035,"responseStart":487.30000000447035,"secureConnectionStart":272.80000000447035},{"duration":215.20000000298023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":272.8999999985099,"connectEnd":272.8999999985099,"connectStart":272.8999999985099,"domainLookupEnd":272.8999999985099,"domainLookupStart":272.8999999985099,"fetchStart":272.8999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":272.8999999985099,"responseEnd":488.1000000014901,"responseStart":488.1000000014901,"secureConnectionStart":272.8999999985099},{"duration":215.70000000298023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":273.1000000014901,"connectEnd":273.1000000014901,"connectStart":273.1000000014901,"domainLookupEnd":273.1000000014901,"domainLookupStart":273.1000000014901,"fetchStart":273.1000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":273.1000000014901,"responseEnd":488.80000000447035,"responseStart":488.80000000447035,"secureConnectionStart":273.1000000014901},{"duration":253.39999999850988,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":273.20000000298023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":273.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":526.6000000014901,"responseStart":0,"secureConnectionStart":0},{"duration":216,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":273.3999999985099,"connectEnd":273.3999999985099,"connectStart":273.3999999985099,"domainLookupEnd":273.3999999985099,"domainLookupStart":273.3999999985099,"fetchStart":273.3999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":273.3999999985099,"responseEnd":489.3999999985099,"responseStart":489.3999999985099,"secureConnectionStart":273.3999999985099},{"duration":253.10000000149012,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":273.6000000014901,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":273.6000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":526.7000000029802,"responseStart":0,"secureConnectionStart":0},{"duration":216.39999999850988,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":273.80000000447035,"connectEnd":273.80000000447035,"connectStart":273.80000000447035,"domainLookupEnd":273.80000000447035,"domainLookupStart":273.80000000447035,"fetchStart":273.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":273.80000000447035,"responseEnd":490.20000000298023,"responseStart":490.1000000014901,"secureConnectionStart":273.80000000447035},{"duration":445,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":274.70000000298023,"connectEnd":274.70000000298023,"connectStart":274.70000000298023,"domainLookupEnd":274.70000000298023,"domainLookupStart":274.70000000298023,"fetchStart":274.70000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":274.70000000298023,"responseEnd":719.7000000029802,"responseStart":719.7000000029802,"secureConnectionStart":274.70000000298023},{"duration":821.3999999985099,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":274.80000000447035,"connectEnd":274.80000000447035,"connectStart":274.80000000447035,"domainLookupEnd":274.80000000447035,"domainLookupStart":274.80000000447035,"fetchStart":274.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":274.80000000447035,"responseEnd":1096.2000000029802,"responseStart":1096.2000000029802,"secureConnectionStart":274.80000000447035},{"duration":182.39999999850988,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":538.1000000014901,"connectEnd":538.1000000014901,"connectStart":538.1000000014901,"domainLookupEnd":538.1000000014901,"domainLookupStart":538.1000000014901,"fetchStart":538.1000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":538.1000000014901,"responseEnd":720.5,"responseStart":720.5,"secureConnectionStart":538.1000000014901},{"duration":309.70000000298023,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":800.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":800.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1110.2000000029802,"responseStart":0,"secureConnectionStart":0},{"duration":347.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":801.3999999985099,"connectEnd":801.3999999985099,"connectStart":801.3999999985099,"domainLookupEnd":801.3999999985099,"domainLookupStart":801.3999999985099,"fetchStart":801.3999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":801.3999999985099,"responseEnd":1148.8999999985099,"responseStart":1148.8999999985099,"secureConnectionStart":801.3999999985099},{"duration":352.8999999985099,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":801.8000000044703,"connectEnd":801.8000000044703,"connectStart":801.8000000044703,"domainLookupEnd":801.8000000044703,"domainLookupStart":801.8000000044703,"fetchStart":801.8000000044703,"redirectEnd":0,"redirectStart":0,"requestStart":801.8000000044703,"responseEnd":1154.7000000029802,"responseStart":1154.7000000029802,"secureConnectionStart":801.8000000044703}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":105,"responseStart":266,"responseEnd":267,"domLoading":269,"domInteractive":1119,"domContentLoadedEventStart":1119,"domContentLoadedEventEnd":1160,"domComplete":1654,"loadEventStart":1654,"loadEventEnd":1656,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1098.3000000044703},{"name":"bigPipe.sidebar-id.end","time":1099.3000000044703},{"name":"bigPipe.activity-panel-pipe-id.start","time":1099.3999999985099},{"name":"bigPipe.activity-panel-pipe-id.end","time":1101.8999999985099},{"name":"activityTabFullyLoaded","time":1167.8999999985099}],"measures":[],"correlationId":"f819e6391d8988","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":97,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}