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":1150.300000011921,"ttfb":490.30000001192093,"pageVisibility":"visible","entityId":56082,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"f9b3a52d-a639-4e14-9eea-874ca8ff60b7","navigationType":0,"readyForUser":1248,"redirectCount":0,"resourceLoadedEnd":1381.699999988079,"resourceLoadedStart":496.10000002384186,"resourceTiming":[{"duration":185.0999999642372,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":496.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":496.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":681.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":185.19999998807907,"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":496.4000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":496.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":681.6000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":194.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":496.5,"connectEnd":496.5,"connectStart":496.5,"domainLookupEnd":496.5,"domainLookupStart":496.5,"fetchStart":496.5,"redirectEnd":0,"redirectStart":0,"requestStart":496.5,"responseEnd":690.6999999880791,"responseStart":690.6999999880791,"secureConnectionStart":496.5},{"duration":242.9000000357628,"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":496.69999998807907,"connectEnd":496.69999998807907,"connectStart":496.69999998807907,"domainLookupEnd":496.69999998807907,"domainLookupStart":496.69999998807907,"fetchStart":496.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":496.69999998807907,"responseEnd":739.6000000238419,"responseStart":739.6000000238419,"secureConnectionStart":496.69999998807907},{"duration":246.5,"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":496.9000000357628,"connectEnd":496.9000000357628,"connectStart":496.9000000357628,"domainLookupEnd":496.9000000357628,"domainLookupStart":496.9000000357628,"fetchStart":496.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":496.9000000357628,"responseEnd":743.4000000357628,"responseStart":743.4000000357628,"secureConnectionStart":496.9000000357628},{"duration":247,"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":497.10000002384186,"connectEnd":497.10000002384186,"connectStart":497.10000002384186,"domainLookupEnd":497.10000002384186,"domainLookupStart":497.10000002384186,"fetchStart":497.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":497.10000002384186,"responseEnd":744.1000000238419,"responseStart":744.1000000238419,"secureConnectionStart":497.10000002384186},{"duration":247.19999998807907,"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":497.30000001192093,"connectEnd":497.30000001192093,"connectStart":497.30000001192093,"domainLookupEnd":497.30000001192093,"domainLookupStart":497.30000001192093,"fetchStart":497.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":497.30000001192093,"responseEnd":744.5,"responseStart":744.5,"secureConnectionStart":497.30000001192093},{"duration":337.69999998807907,"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":497.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":497.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":835.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":247.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":497.69999998807907,"connectEnd":497.69999998807907,"connectStart":497.69999998807907,"domainLookupEnd":497.69999998807907,"domainLookupStart":497.69999998807907,"fetchStart":497.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":497.69999998807907,"responseEnd":745.4000000357628,"responseStart":745.4000000357628,"secureConnectionStart":497.69999998807907},{"duration":337.69999998807907,"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":497.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":497.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":835.5,"responseStart":0,"secureConnectionStart":0},{"duration":248.30000001192093,"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":498,"connectEnd":498,"connectStart":498,"domainLookupEnd":498,"domainLookupStart":498,"fetchStart":498,"redirectEnd":0,"redirectStart":0,"requestStart":498,"responseEnd":746.3000000119209,"responseStart":746.3000000119209,"secureConnectionStart":498},{"duration":624.3000000119209,"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":503.69999998807907,"connectEnd":503.69999998807907,"connectStart":503.69999998807907,"domainLookupEnd":503.69999998807907,"domainLookupStart":503.69999998807907,"fetchStart":503.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":503.69999998807907,"responseEnd":1128,"responseStart":1128,"secureConnectionStart":503.69999998807907},{"duration":877.6999999880791,"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":504,"connectEnd":504,"connectStart":504,"domainLookupEnd":504,"domainLookupStart":504,"fetchStart":504,"redirectEnd":0,"redirectStart":0,"requestStart":504,"responseEnd":1381.699999988079,"responseStart":1381.699999988079,"secureConnectionStart":504},{"duration":282.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":847,"connectEnd":847,"connectStart":847,"domainLookupEnd":847,"domainLookupStart":847,"fetchStart":847,"redirectEnd":0,"redirectStart":0,"requestStart":847,"responseEnd":1129.5,"responseStart":1129.5,"secureConnectionStart":847}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":306,"responseStart":490,"responseEnd":503,"domLoading":494,"domInteractive":1406,"domContentLoadedEventStart":1406,"domContentLoadedEventEnd":1448,"domComplete":2030,"loadEventStart":2030,"loadEventEnd":2031,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1383.800000011921},{"name":"bigPipe.sidebar-id.end","time":1384.6000000238419},{"name":"bigPipe.activity-panel-pipe-id.start","time":1384.800000011921},{"name":"bigPipe.activity-panel-pipe-id.end","time":1385.9000000357628},{"name":"activityTabFullyLoaded","time":1462.300000011921}],"measures":[],"correlationId":"c394ee3c7c0bb9","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":116,"dbReadsTimeInMs":24,"dbConnsTimeInMs":34,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
MDEV-11839 move value caching from get_datetime_value to fix_fields time
