I am not re-opening MDEV-24739 because the patch for it was included into 10.5.9 release.
SELECT * FROM mysql.help_relation WHERE (help_topic_id < '2' OR help_topic_id != 8 OR help_topic_id < 1) AND help_keyword_id = help_topic_id;
|
10.5 aa4f76be
|
mariadbd: /data/src/10.5/sql/opt_range.cc:11056: SEL_ARG* SEL_ARG::tree_delete(SEL_ARG*): Assertion `root->weight >= (1 + (key->next_key_part ? key->next_key_part->weight : 0))' failed.
|
210306 1:44:58 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f0ad5187f36 in __GI___assert_fail (assertion=0x564cb23ee378 "root->weight >= (1 + (key->next_key_part ? key->next_key_part->weight : 0))", file=0x564cb23ec2f8 "/data/src/10.5/sql/opt_range.cc", line=11056, function=0x564cb23ee3c8 "SEL_ARG* SEL_ARG::tree_delete(SEL_ARG*)") at assert.c:101
|
#8 0x0000564cb191b128 in SEL_ARG::tree_delete (this=0x7f0ab412c360, key=0x7f0ab412c360) at /data/src/10.5/sql/opt_range.cc:11056
|
#9 0x0000564cb19198e7 in key_or (param=0x7f0ad03429b0, key1=0x7f0ab412c360, key2=0x7f0ab412c4b0) at /data/src/10.5/sql/opt_range.cc:10318
|
#10 0x0000564cb191937c in key_or_with_limit (param=0x7f0ad03429b0, keyno=0, key1=0x7f0ab412bfb0, key2=0x7f0ab4208e70) at /data/src/10.5/sql/opt_range.cc:10067
|
#11 0x0000564cb1900b9a in SEL_IMERGE::or_sel_tree_with_checks (this=0x7f0ab412c170, param=0x7f0ad03429b0, n_trees=2, tree=0x7f0ab412bde8, is_first_check_pass=false, is_last_check_pass=0x7f0ad03424c3) at /data/src/10.5/sql/opt_range.cc:721
|
#12 0x0000564cb19014d8 in imerge_list_or_tree (param=0x7f0ad03429b0, merges=0x7f0ad03425f0, tree=0x7f0ab4208ee0) at /data/src/10.5/sql/opt_range.cc:1096
|
#13 0x0000564cb19187ef in tree_or (param=0x7f0ad03429b0, tree1=0x7f0ab4208970, tree2=0x7f0ab4208c68) at /data/src/10.5/sql/opt_range.cc:9771
|
#14 0x0000564cb191434a in Item_cond::get_mm_tree (this=0x7f0ab4016af0, param=0x7f0ad03429b0, cond_ptr=0x7f0ab4017658) at /data/src/10.5/sql/opt_range.cc:8356
|
#15 0x0000564cb19140c5 in Item_cond_and::get_mm_tree (this=0x7f0ab4017530, param=0x7f0ad03429b0, cond_ptr=0x7f0ab401a5a8) at /data/src/10.5/sql/opt_range.cc:8312
|
#16 0x0000564cb1905e2d in SQL_SELECT::test_quick_select (this=0x7f0ab401a5a0, thd=0x7f0ab4000db8, keys_to_use=..., prev_tables=0, limit=18446744073709551615, force_quick_range=false, ordered_output=false, remove_false_parts_of_where=true, only_single_index_range_scan=false) at /data/src/10.5/sql/opt_range.cc:2880
|
#17 0x0000564cb145107d in get_quick_record_count (thd=0x7f0ab4000db8, select=0x7f0ab401a5a0, table=0x7f0ab4156c18, keys=0x7f0ab4019130, limit=18446744073709551615) at /data/src/10.5/sql/sql_select.cc:4764
|
#18 0x0000564cb1453a10 in make_join_statistics (join=0x7f0ab4017f90, tables_list=..., keyuse_array=0x7f0ab4018280) at /data/src/10.5/sql/sql_select.cc:5495
|
#19 0x0000564cb1447e5c in JOIN::optimize_inner (this=0x7f0ab4017f90) at /data/src/10.5/sql/sql_select.cc:2256
|
#20 0x0000564cb1445949 in JOIN::optimize (this=0x7f0ab4017f90) at /data/src/10.5/sql/sql_select.cc:1628
|
#21 0x0000564cb1450d5c in mysql_select (thd=0x7f0ab4000db8, tables=0x7f0ab4015bb0, fields=..., conds=0x7f0ab4017530, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f0ab4017f68, unit=0x7f0ab4004f60, select_lex=0x7f0ab40155a8) at /data/src/10.5/sql/sql_select.cc:4706
|
#22 0x0000564cb1440873 in handle_select (thd=0x7f0ab4000db8, lex=0x7f0ab4004e98, result=0x7f0ab4017f68, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:417
|
#23 0x0000564cb1403237 in execute_sqlcom_select (thd=0x7f0ab4000db8, all_tables=0x7f0ab4015bb0) at /data/src/10.5/sql/sql_parse.cc:6282
|
#24 0x0000564cb13fa2c1 in mysql_execute_command (thd=0x7f0ab4000db8) at /data/src/10.5/sql/sql_parse.cc:3978
|
#25 0x0000564cb14080de in mysql_parse (thd=0x7f0ab4000db8, rawbuf=0x7f0ab4015430 "SELECT * FROM mysql.help_relation WHERE (help_topic_id < '2' OR help_topic_id != 8 OR help_topic_id < 1) AND help_keyword_id = help_topic_id", length=140, parser_state=0x7f0ad0344510, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8063
|
#26 0x0000564cb13f4043 in dispatch_command (command=COM_QUERY, thd=0x7f0ab4000db8, packet=0x7f0ab400b589 "SELECT * FROM mysql.help_relation WHERE (help_topic_id < '2' OR help_topic_id != 8 OR help_topic_id < 1) AND help_keyword_id = help_topic_id", packet_length=140, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1889
|
#27 0x0000564cb13f2837 in do_command (thd=0x7f0ab4000db8) at /data/src/10.5/sql/sql_parse.cc:1370
|
#28 0x0000564cb15a0a4d in do_handle_one_connection (connect=0x564cb4ee5c58, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1410
|
#29 0x0000564cb15a07b0 in handle_one_connection (arg=0x564cb4def678) at /data/src/10.5/sql/sql_connect.cc:1312
|
#30 0x0000564cb1b014e5 in pfs_spawn_thread (arg=0x564cb4ee5888) at /data/src/10.5/storage/perfschema/pfs.cc:2201
|
#31 0x00007f0ad569f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#32 0x00007f0ad5273293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
No obvious immediate problem on a non-debug build.
Not reproducible on 10.4.
The failure appeared in 10.5 after this commit:
commit c36720388d598ca3aa1c4d2dab2266656c528b50 (HEAD)
|
Author: Sergei Petrunia
|
Date: Thu Jan 28 21:43:55 2021 +0300
|
|
MDEV-9750: Quick memory exhaustion with 'extended_keys=on' ...
|
- relates to
-
MDEV-24739
Assertion `root->weight >= (1 + (key->next_key_part ? key->next_key_part->weight : 0))' failed in SEL_ARG::tree_delete
-
-
Closed
{"report":{"fcp":818.6000003814697,"ttfb":237.30000019073486,"pageVisibility":"visible","entityId":97644,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"4846434d-136f-4d7f-b6e4-6c13dc017f5d","navigationType":0,"readyForUser":940.4000005722046,"redirectCount":0,"resourceLoadedEnd":548.9000005722046,"resourceLoadedStart":245.19999980926514,"resourceTiming":[{"duration":35.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":245.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":245.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":281,"responseStart":0,"secureConnectionStart":0},{"duration":35.80000019073486,"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":245.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":245.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":281.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":174.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":245.60000038146973,"connectEnd":245.60000038146973,"connectStart":245.60000038146973,"domainLookupEnd":245.60000038146973,"domainLookupStart":245.60000038146973,"fetchStart":245.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":285.6000003814697,"responseEnd":420.1000003814697,"responseStart":297.19999980926514,"secureConnectionStart":245.60000038146973},{"duration":59.39999961853027,"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":245.80000019073486,"connectEnd":245.80000019073486,"connectStart":245.80000019073486,"domainLookupEnd":245.80000019073486,"domainLookupStart":245.80000019073486,"fetchStart":245.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":288.69999980926514,"responseEnd":305.19999980926514,"responseStart":301.4000005722046,"secureConnectionStart":245.80000019073486},{"duration":303.1000003814697,"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":245.80000019073486,"connectEnd":245.80000019073486,"connectStart":245.80000019073486,"domainLookupEnd":245.80000019073486,"domainLookupStart":245.80000019073486,"fetchStart":245.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":287.30000019073486,"responseEnd":548.9000005722046,"responseStart":305.69999980926514,"secureConnectionStart":245.80000019073486},{"duration":64.29999923706055,"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":245.9000005722046,"connectEnd":245.9000005722046,"connectStart":245.9000005722046,"domainLookupEnd":245.9000005722046,"domainLookupStart":245.9000005722046,"fetchStart":245.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":289.69999980926514,"responseEnd":310.19999980926514,"responseStart":308.19999980926514,"secureConnectionStart":245.9000005722046},{"duration":43.40000057220459,"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":246,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":246,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":289.4000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":66.80000019073486,"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":246,"connectEnd":246,"connectStart":246,"domainLookupEnd":246,"domainLookupStart":246,"fetchStart":246,"redirectEnd":0,"redirectStart":0,"requestStart":291.30000019073486,"responseEnd":312.80000019073486,"responseStart":310.69999980926514,"secureConnectionStart":246},{"duration":77,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":246.19999980926514,"connectEnd":246.19999980926514,"connectStart":246.19999980926514,"domainLookupEnd":246.19999980926514,"domainLookupStart":246.19999980926514,"fetchStart":246.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":296.69999980926514,"responseEnd":323.19999980926514,"responseStart":319,"secureConnectionStart":246.19999980926514},{"duration":45.5,"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":246.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":246.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":291.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":77.29999923706055,"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":246.4000005722046,"connectEnd":246.4000005722046,"connectStart":246.4000005722046,"domainLookupEnd":246.4000005722046,"domainLookupStart":246.4000005722046,"fetchStart":246.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":297.19999980926514,"responseEnd":323.69999980926514,"responseStart":320.1000003814697,"secureConnectionStart":246.4000005722046},{"duration":278.9000005722046,"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":251.19999980926514,"connectEnd":251.19999980926514,"connectStart":251.19999980926514,"domainLookupEnd":251.19999980926514,"domainLookupStart":251.19999980926514,"fetchStart":251.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":356.9000005722046,"responseEnd":530.1000003814697,"responseStart":526.1000003814697,"secureConnectionStart":251.19999980926514},{"duration":283.30000019073486,"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":251.19999980926514,"connectEnd":251.19999980926514,"connectStart":251.19999980926514,"domainLookupEnd":251.19999980926514,"domainLookupStart":251.19999980926514,"fetchStart":251.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":446.69999980926514,"responseEnd":534.5,"responseStart":530.6000003814697,"secureConnectionStart":251.19999980926514},{"duration":76.30000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":572.8000001907349,"connectEnd":572.8000001907349,"connectStart":572.8000001907349,"domainLookupEnd":572.8000001907349,"domainLookupStart":572.8000001907349,"fetchStart":572.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":620.3000001907349,"responseEnd":649.1000003814697,"responseStart":647.6999998092651,"secureConnectionStart":572.8000001907349},{"duration":126.09999942779541,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":810.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":810.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":937,"responseStart":0,"secureConnectionStart":0},{"duration":151.19999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":817.9000005722046,"connectEnd":817.9000005722046,"connectStart":817.9000005722046,"domainLookupEnd":817.9000005722046,"domainLookupStart":817.9000005722046,"fetchStart":817.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":941.1000003814697,"responseEnd":969.1000003814697,"responseStart":968.1000003814697,"secureConnectionStart":817.9000005722046}],"fetchStart":0,"domainLookupStart":77,"domainLookupEnd":84,"connectStart":84,"connectEnd":103,"secureConnectionStart":93,"requestStart":104,"responseStart":237,"responseEnd":250,"domLoading":241,"domInteractive":1002,"domContentLoadedEventStart":1002,"domContentLoadedEventEnd":1045,"domComplete":1228,"loadEventStart":1228,"loadEventEnd":1229,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":985.4000005722046},{"name":"bigPipe.sidebar-id.end","time":986.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":986.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":987.1999998092651},{"name":"activityTabFullyLoaded","time":1058.9000005722046}],"measures":[],"correlationId":"d9ce88bd462abf","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":73,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
https://github.com/MariaDB/server/tree/bb-10.5-mdev25069