Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.1.12 , 10.2.1 , 5.5(EOL) , 10.0(EOL) , 10.1(EOL)
Environment:
Win x64 and Linux x64
MariaDB doesn't seem to be able to run a concurrent SELECT workload on randomly created tables having virtual columns.
Invalid read of size 8
at : val_temporal_packed (item.h:1252)
by: get_datetime_value(THD*, Item***, Item**, enum_field_types, bool*) (item_cmpfunc.cc:742)
by: Arg_comparator::compare_temporal(enum_field_types) (item_cmpfunc.cc:793)
by: compare (item_cmpfunc.h:88)
by: Item_func_le::val_int() (item_cmpfunc.cc:1781)
by: Item::save_in_field(Field*, bool) (item.cc:5931)
by: update_virtual_fields(THD*, TABLE*, enum_vcol_update_mode) (table.cc:6897)
by: rr_sequential(READ_RECORD*) (records.cc:483)
by: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18312)
by: do_select(JOIN*, List<Item>*, TABLE*, Procedure*) (sql_select.cc:17948)
by: JOIN::exec_inner() (sql_select.cc:3228)
by: exec (sql_select.cc:2518)
by: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:3451)
by: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:384)
by: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5936)
by: mysql_execute_command(THD*) (sql_parse.cc:2962)
by: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:7336)
by: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1488)
by: do_command(THD*) (sql_parse.cc:1109)
by: do_handle_one_connection(THD*) (sql_connect.cc:1349)
by: handle_one_connection (sql_connect.cc:1261)
by: start_thread (pthread_create.c:308)
by: clone (clone.S:113)
Address 0x2f207463656c6763 is not stack'd, malloc'd or (recently) free'd
On Windows, typical crash is:
Version: '10.1.12-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
mysqld.exe!get_datetime_value()[item_cmpfunc.cc:746]
mysqld.exe!Arg_comparator::compare_temporal()[item_cmpfunc.cc:794]
mysqld.exe!Item_func_ne::val_int()[item_cmpfunc.cc:1759]
mysqld.exe!Item::val_bool()[item.cc:84]
mysqld.exe!Item_cond_and::val_int()[item_cmpfunc.cc:4911]
mysqld.exe!Item::save_in_field()[item.cc:5931]
mysqld.exe!update_virtual_fields()[table.cc:6888]
mysqld.exe!rr_sequential()[records.cc:484]
mysqld.exe!sub_select()[sql_select.cc:18290]
mysqld.exe!do_select()[sql_select.cc:17948]
mysqld.exe!JOIN::exec_inner()[sql_select.cc:3228]
mysqld.exe!JOIN::exec()[sql_select.cc:2519]
mysqld.exe!mysql_select()[sql_select.cc:3453]
mysqld.exe!handle_select()[sql_select.cc:384]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5936]
mysqld.exe!mysql_execute_command()[sql_parse.cc:2962]
mysqld.exe!mysql_parse()[sql_parse.cc:7341]
mysqld.exe!dispatch_command()[sql_parse.cc:1491]
mysqld.exe!do_command()[sql_parse.cc:1109]
How to repeat
SELECT * FROM <table>;
in multiple connections and pick any table randomly.
{"report":{"fcp":1353,"ttfb":739.7999992370605,"pageVisibility":"visible","entityId":56082,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"53ee959b-e1cc-4f9e-84d9-245a37a24ba9","navigationType":0,"readyForUser":1443,"redirectCount":0,"resourceLoadedEnd":1459.7999992370605,"resourceLoadedStart":745,"resourceTiming":[{"duration":54.29999923706055,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":745,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":745,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":799.2999992370605,"responseStart":0,"secureConnectionStart":0},{"duration":54.30000019073486,"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":745.2999992370605,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":745.2999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":799.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":115.79999923706055,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":745.5,"connectEnd":745.5,"connectStart":745.5,"domainLookupEnd":745.5,"domainLookupStart":745.5,"fetchStart":745.5,"redirectEnd":0,"redirectStart":0,"requestStart":745.5,"responseEnd":861.2999992370605,"responseStart":861.2999992370605,"secureConnectionStart":745.5},{"duration":201.60000038146973,"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":745.5999994277954,"connectEnd":745.5999994277954,"connectStart":745.5999994277954,"domainLookupEnd":745.5999994277954,"domainLookupStart":745.5999994277954,"fetchStart":745.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":745.5999994277954,"responseEnd":947.1999998092651,"responseStart":947.1999998092651,"secureConnectionStart":745.5999994277954},{"duration":205.20000076293945,"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":745.7999992370605,"connectEnd":745.7999992370605,"connectStart":745.7999992370605,"domainLookupEnd":745.7999992370605,"domainLookupStart":745.7999992370605,"fetchStart":745.7999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":745.7999992370605,"responseEnd":951,"responseStart":951,"secureConnectionStart":745.7999992370605},{"duration":205.5,"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":746,"connectEnd":746,"connectStart":746,"domainLookupEnd":746,"domainLookupStart":746,"fetchStart":746,"redirectEnd":0,"redirectStart":0,"requestStart":746,"responseEnd":951.5,"responseStart":951.5,"secureConnectionStart":746},{"duration":205.5999994277954,"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":746.1999998092651,"connectEnd":746.1999998092651,"connectStart":746.1999998092651,"domainLookupEnd":746.1999998092651,"domainLookupStart":746.1999998092651,"fetchStart":746.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":746.1999998092651,"responseEnd":951.7999992370605,"responseStart":951.7999992370605,"secureConnectionStart":746.1999998092651},{"duration":253.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":746.2999992370605,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":746.2999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":999.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":205.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":746.5,"connectEnd":746.5,"connectStart":746.5,"domainLookupEnd":746.5,"domainLookupStart":746.5,"fetchStart":746.5,"redirectEnd":0,"redirectStart":0,"requestStart":746.5,"responseEnd":952.1999998092651,"responseStart":952.1999998092651,"secureConnectionStart":746.5},{"duration":252.89999961853027,"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":746.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":746.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":999.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":206,"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":746.7999992370605,"connectEnd":746.7999992370605,"connectStart":746.7999992370605,"domainLookupEnd":746.7999992370605,"domainLookupStart":746.7999992370605,"fetchStart":746.7999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":746.7999992370605,"responseEnd":952.7999992370605,"responseStart":952.7999992370605,"secureConnectionStart":746.7999992370605},{"duration":420.8999996185303,"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":752.5,"connectEnd":752.5,"connectStart":752.5,"domainLookupEnd":752.5,"domainLookupStart":752.5,"fetchStart":752.5,"redirectEnd":0,"redirectStart":0,"requestStart":752.5,"responseEnd":1173.3999996185303,"responseStart":1173.3999996185303,"secureConnectionStart":752.5},{"duration":546.8000001907349,"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":757.0999994277954,"connectEnd":757.0999994277954,"connectStart":757.0999994277954,"domainLookupEnd":757.0999994277954,"domainLookupStart":757.0999994277954,"fetchStart":757.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":757.0999994277954,"responseEnd":1303.8999996185303,"responseStart":1303.8999996185303,"secureConnectionStart":757.0999994277954},{"duration":163.29999923706055,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1010.5,"connectEnd":1010.5,"connectStart":1010.5,"domainLookupEnd":1010.5,"domainLookupStart":1010.5,"fetchStart":1010.5,"redirectEnd":0,"redirectStart":0,"requestStart":1010.5,"responseEnd":1173.7999992370605,"responseStart":1173.7999992370605,"secureConnectionStart":1010.5},{"duration":51.5,"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":1260.2999992370605,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1260.2999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1311.7999992370605,"responseStart":0,"secureConnectionStart":0},{"duration":170.4000005722046,"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":1261.0999994277954,"connectEnd":1261.0999994277954,"connectStart":1261.0999994277954,"domainLookupEnd":1261.0999994277954,"domainLookupStart":1261.0999994277954,"fetchStart":1261.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":1261.0999994277954,"responseEnd":1431.5,"responseStart":1431.5,"secureConnectionStart":1261.0999994277954},{"duration":198.29999923706055,"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":1261.5,"connectEnd":1261.5,"connectStart":1261.5,"domainLookupEnd":1261.5,"domainLookupStart":1261.5,"fetchStart":1261.5,"redirectEnd":0,"redirectStart":0,"requestStart":1261.5,"responseEnd":1459.7999992370605,"responseStart":1459.7999992370605,"secureConnectionStart":1261.5},{"duration":214.80000019073486,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1346.7999992370605,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1346.7999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1561.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":163.79999923706055,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1367,"connectEnd":1367,"connectStart":1367,"domainLookupEnd":1367,"domainLookupStart":1367,"fetchStart":1367,"redirectEnd":0,"redirectStart":0,"requestStart":1367,"responseEnd":1530.7999992370605,"responseStart":1530.7999992370605,"secureConnectionStart":1367}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":232,"responseStart":740,"responseEnd":757,"domLoading":743,"domInteractive":1510,"domContentLoadedEventStart":1510,"domContentLoadedEventEnd":1556,"domComplete":2202,"loadEventStart":2202,"loadEventEnd":2204,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1483.7999992370605},{"name":"bigPipe.sidebar-id.end","time":1484.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.start","time":1484.5999994277954},{"name":"bigPipe.activity-panel-pipe-id.end","time":1486.7999992370605},{"name":"activityTabFullyLoaded","time":1568.3999996185303}],"measures":[],"correlationId":"edcb4f5dff253e","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":102,"dbReadsTimeInMs":14,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
MDEV-11839 move value caching from get_datetime_value to fix_fields time
