https://bugs.launchpad.net/maria/+bug/1008516
Reproducible on maria-5.5 with XtraDB.
Could not reproduce on maria-5.3, percona-server, mysql-5.5, and on maria-5.5 with InnoDB plugin, but possibly only because in all these cases a different plan is chosen (5.5 with XtraDB says 'Using index condition', others don't).
Comments in http://bugs.mysql.com/bug.php?id=58015 say that the assertion is bogus, so it's just a debug nuisance.
Shane Bester wrote:
Reminds me of an old bug:
http://bugs.mysql.com/bug.php?id=58015
(Assert in row_sel_field_store_in_mysql_format when running innodb_mrr_icp test)
How to repeat:
-----------------
might have to use debug build
repeatable with 5.5.24-MariaDB-valgrind-max-debug on linux x64
drop table if exists `t1`;
create table `t1` (`a` int,`b` char(5),primary key (`a`), key (`b`(1))) engine=innodb ;
insert into `t1` values ('a','b');
select 1 from `t1` where `a` and `b` >= 'aa';
InnoDB: Assertion failure in thread X in file row0sel.c line 2681
InnoDB: Failing assertion: templ->mysql_col_len == len
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7ffff42d3700 (LWP 30861)]
in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig);
(gdb) bt
#0 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#1 in abort () at abort.c:92
#2 in row_sel_field_store_in_mysql_format at ./maria-5.5/storage/xtradb/row/row0sel.c:2681
#3 in row_sel_store_mysql_field at ./maria-5.5/storage/xtradb/row/row0sel.c:2810
#4 in row_search_idx_cond_check at ./maria-5.5/storage/xtradb/row/row0sel.c:3436
#5 in row_search_for_mysql at ./maria-5.5/storage/xtradb/row/row0sel.c:4619
#6 in ha_innobase::index_read at ./maria-5.5/storage/xtradb/handler/ha_innodb.cc:6562
#7 in handler::index_read_map at ./maria-5.5/sql/handler.h:2105
#8 in handler::ha_index_read_map at ./maria-5.5/sql/sql_class.h:4146
#9 in handler::read_range_first at ./maria-5.5/sql/handler.cc:4544
#10 in handler::multi_range_read_next at ./maria-5.5/sql/multi_range_read.cc:296
#11 in Mrr_simple_index_reader::get_next at ./maria-5.5/sql/multi_range_read.cc:328
#12 in DsMrr_impl::dsmrr_next at ./maria-5.5/sql/multi_range_read.cc:1391
#13 in ha_innobase::multi_range_read_next at ./maria-5.5/storage/xtradb/handler/ha_innodb.cc:13084
#14 in QUICK_RANGE_SELECT::get_next at ./maria-5.5/sql/opt_range.cc:10966
#15 in rr_quick at ./maria-5.5/sql/records.cc:339
#16 in join_init_read_record at ./maria-5.5/sql/sql_select.cc:16854
#17 in sub_select at ./maria-5.5/sql/sql_select.cc:16000
#18 in do_select at ./maria-5.5/sql/sql_select.cc:15673
#19 in JOIN::exec at ./maria-5.5/sql/sql_select.cc:2794
#20 in mysql_select at ./maria-5.5/sql/sql_select.cc:3014
#21 in handle_select at ./maria-5.5/sql/sql_select.cc:311
#22 in execute_sqlcom_select at ./maria-5.5/sql/sql_parse.cc:4616
#23 in mysql_execute_command (thd=0x30749f0) at ./maria-5.5/sql/sql_parse.cc:2184
#24 in mysql_parse at ./maria-5.5/sql/sql_parse.cc:5731
#25 in dispatch_command at ./maria-5.5/sql/sql_parse.cc:1055
#26 in do_command at ./maria-5.5/sql/sql_parse.cc:794
#27 in do_handle_one_connection at ./maria-5.5/sql/sql_connect.cc:1253
#28 in handle_one_connection at ./maria-5.5/sql/sql_connect.cc:1168
#29 in start_thread at pthread_create.c:301
#30 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115
duplicates
MDEV-709
LP:1008516 - Failing assertion: templ->mysql_col_len == len
Closed
Sergei Golubchik
made changes -
2012-06-04 19:31
Field
Original Value
New Value
Status
Open
[ 1
]
In Progress
[ 3
]
Sergei Golubchik
made changes -
2012-06-04 23:51
Status
In Progress
[ 3
]
Open
[ 1
]
Sergei Golubchik
made changes -
2012-06-05 16:56
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2012-06-05 16:56
Resolution
Fixed
[ 1
]
Status
Closed
[ 6
]
Reopened
[ 4
]
Sergei Golubchik
made changes -
2012-06-05 16:56
Fix Version/s
5.3.8
[ 10900
]
Affects Version/s
5.3.7
[ 10700
]
Sergei Golubchik
made changes -
2012-06-05 16:56
Resolution
Fixed
[ 1
]
Status
Reopened
[ 4
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2014-06-13 15:06
Workflow
defaullt
[ 12122
]
MariaDB v2
[ 44672
]
Sergei Golubchik
made changes -
2021-12-06 21:37
Workflow
MariaDB v3
[ 64037
]
MariaDB v4
[ 144820
]
{"report":{"fcp":1163,"ttfb":413.9000005722046,"pageVisibility":"visible","entityId":12021,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"1de5ecb5-37dd-420f-9da9-a76bd3f8723c","navigationType":0,"readyForUser":1248,"redirectCount":0,"resourceLoadedEnd":1257.8000001907349,"resourceLoadedStart":420.70000076293945,"resourceTiming":[{"duration":123.79999923706055,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":420.70000076293945,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":420.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":544.5,"responseStart":0,"secureConnectionStart":0},{"duration":123.89999961853027,"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":420.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":420.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":544.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":177.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":421.20000076293945,"connectEnd":421.20000076293945,"connectStart":421.20000076293945,"domainLookupEnd":421.20000076293945,"domainLookupStart":421.20000076293945,"fetchStart":421.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":421.20000076293945,"responseEnd":599.1000003814697,"responseStart":599.1000003814697,"secureConnectionStart":421.20000076293945},{"duration":272.1000003814697,"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":421.30000019073486,"connectEnd":421.30000019073486,"connectStart":421.30000019073486,"domainLookupEnd":421.30000019073486,"domainLookupStart":421.30000019073486,"fetchStart":421.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":421.30000019073486,"responseEnd":693.4000005722046,"responseStart":693.4000005722046,"secureConnectionStart":421.30000019073486},{"duration":275.69999980926514,"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":421.6000003814697,"connectEnd":421.6000003814697,"connectStart":421.6000003814697,"domainLookupEnd":421.6000003814697,"domainLookupStart":421.6000003814697,"fetchStart":421.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":421.6000003814697,"responseEnd":697.3000001907349,"responseStart":697.3000001907349,"secureConnectionStart":421.6000003814697},{"duration":275.9000005722046,"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":421.80000019073486,"connectEnd":421.80000019073486,"connectStart":421.80000019073486,"domainLookupEnd":421.80000019073486,"domainLookupStart":421.80000019073486,"fetchStart":421.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":421.80000019073486,"responseEnd":697.7000007629395,"responseStart":697.7000007629395,"secureConnectionStart":421.80000019073486},{"duration":276.19999980926514,"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":421.9000005722046,"connectEnd":421.9000005722046,"connectStart":421.9000005722046,"domainLookupEnd":421.9000005722046,"domainLookupStart":421.9000005722046,"fetchStart":421.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":421.9000005722046,"responseEnd":698.1000003814697,"responseStart":698.1000003814697,"secureConnectionStart":421.9000005722046},{"duration":322.3999996185303,"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":422.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":422.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":744.5,"responseStart":0,"secureConnectionStart":0},{"duration":276.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":422.20000076293945,"connectEnd":422.20000076293945,"connectStart":422.20000076293945,"domainLookupEnd":422.20000076293945,"domainLookupStart":422.20000076293945,"fetchStart":422.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":422.20000076293945,"responseEnd":698.6000003814697,"responseStart":698.6000003814697,"secureConnectionStart":422.20000076293945},{"duration":322.19999980926514,"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":422.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":422.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":744.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":276.80000019073486,"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":422.5,"connectEnd":422.5,"connectStart":422.5,"domainLookupEnd":422.5,"domainLookupStart":422.5,"fetchStart":422.5,"redirectEnd":0,"redirectStart":0,"requestStart":422.5,"responseEnd":699.3000001907349,"responseStart":699.2000007629395,"secureConnectionStart":422.5},{"duration":422.20000076293945,"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":423.5,"connectEnd":423.5,"connectStart":423.5,"domainLookupEnd":423.5,"domainLookupStart":423.5,"fetchStart":423.5,"redirectEnd":0,"redirectStart":0,"requestStart":423.5,"responseEnd":845.7000007629395,"responseStart":845.7000007629395,"secureConnectionStart":423.5},{"duration":724.5,"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":423.6000003814697,"connectEnd":423.6000003814697,"connectStart":423.6000003814697,"domainLookupEnd":423.6000003814697,"domainLookupStart":423.6000003814697,"fetchStart":423.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":423.6000003814697,"responseEnd":1148.1000003814697,"responseStart":1148.1000003814697,"secureConnectionStart":423.6000003814697},{"duration":89.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":756.6000003814697,"connectEnd":756.6000003814697,"connectStart":756.6000003814697,"domainLookupEnd":756.6000003814697,"domainLookupStart":756.6000003814697,"fetchStart":756.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":756.6000003814697,"responseEnd":846.1000003814697,"responseStart":846.1000003814697,"secureConnectionStart":756.6000003814697},{"duration":93.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/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":1066.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1066.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1159.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":183.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/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":1067.7000007629395,"connectEnd":1067.7000007629395,"connectStart":1067.7000007629395,"domainLookupEnd":1067.7000007629395,"domainLookupStart":1067.7000007629395,"fetchStart":1067.7000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":1067.7000007629395,"responseEnd":1251.4000005722046,"responseStart":1251.4000005722046,"secureConnectionStart":1067.7000007629395},{"duration":189.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/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":1068.1000003814697,"connectEnd":1068.1000003814697,"connectStart":1068.1000003814697,"domainLookupEnd":1068.1000003814697,"domainLookupStart":1068.1000003814697,"fetchStart":1068.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1068.1000003814697,"responseEnd":1257.8000001907349,"responseStart":1257.8000001907349,"secureConnectionStart":1068.1000003814697},{"duration":228.30000019073486,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1156.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1156.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1384.4000005722046,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":210,"responseStart":414,"responseEnd":418,"domLoading":418,"domInteractive":1332,"domContentLoadedEventStart":1332,"domContentLoadedEventEnd":1381,"domComplete":1557,"loadEventStart":1558,"loadEventEnd":1558,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1291.2000007629395},{"name":"bigPipe.sidebar-id.end","time":1292.1000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":1292.2000007629395},{"name":"bigPipe.activity-panel-pipe-id.end","time":1295.1000003814697},{"name":"activityTabFullyLoaded","time":1400.4000005722046}],"measures":[],"correlationId":"6b0481e820b878","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":142,"dbReadsTimeInMs":29,"dbConnsTimeInMs":39,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}