Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL)
SET NAMES 'utf8mb3' COLLATE 'uca1400_swedish_nopad_ai_ci' ;
CREATE TABLE t (a CHAR (8));
INSERT INTO t VALUES ( 'foo' );
--error ER_TRUNCATED_WRONG_VALUE
ALTER TABLE t MODIFY a INT ;
CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO BEGIN END ;
# Cleanup
DROP EVENT ev;
DROP TABLE t;
10.10 bb76dcbe
query 'CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO BEGIN END' failed: ER_EVENT_STORE_FAILED (1538): Failed to store event body. Error code 2 "No such file or directory" from storage engine
I tried a few uca1400_xxxx_nopad_xx_xx collations, it was reproducible with each of them. Couldn't reproduce with non-nopad, non-uca1400, and non-language-specific (without xxxx) which I tried.
Reproducible on 10.10/10.11.
The test case isn't applicable to earlier versions due to the use of UCA1400 collations.
On some reason the failing ALTER TABLE is important here, although I can't figure why.
No workflow transitions have been executed yet.
{"report":{"fcp":646,"ttfb":178.5,"pageVisibility":"visible","entityId":115434,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"d36a3082-41ef-4984-a6e5-6f744c385c70","navigationType":0,"readyForUser":720,"redirectCount":0,"resourceLoadedEnd":809.8999996185303,"resourceLoadedStart":184.30000019073486,"resourceTiming":[{"duration":12.399999618530273,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":184.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":184.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":196.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":12.199999809265137,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":184.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":184.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":196.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":67.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/c54b129276d75dc2a3460e1d78f37913-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":184.69999980926514,"connectEnd":184.69999980926514,"connectStart":184.69999980926514,"domainLookupEnd":184.69999980926514,"domainLookupStart":184.69999980926514,"fetchStart":184.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":184.69999980926514,"responseEnd":251.89999961853027,"responseStart":251.89999961853027,"secureConnectionStart":184.69999980926514},{"duration":150.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/f867843cd2fdb209d4d1d4f760f86346-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":184.80000019073486,"connectEnd":184.80000019073486,"connectStart":184.80000019073486,"domainLookupEnd":184.80000019073486,"domainLookupStart":184.80000019073486,"fetchStart":184.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":184.80000019073486,"responseEnd":335.6000003814697,"responseStart":335.6000003814697,"secureConnectionStart":184.80000019073486},{"duration":154.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/ffdb17665775c5b4d6f097f3974ee359-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":184.89999961853027,"connectEnd":184.89999961853027,"connectStart":184.89999961853027,"domainLookupEnd":184.89999961853027,"domainLookupStart":184.89999961853027,"fetchStart":184.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":184.89999961853027,"responseEnd":339.30000019073486,"responseStart":339.30000019073486,"secureConnectionStart":184.89999961853027},{"duration":154.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":185,"connectEnd":185,"connectStart":185,"domainLookupEnd":185,"domainLookupStart":185,"fetchStart":185,"redirectEnd":0,"redirectStart":0,"requestStart":185,"responseEnd":339.69999980926514,"responseStart":339.69999980926514,"secureConnectionStart":185},{"duration":156,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":185,"connectEnd":185,"connectStart":185,"domainLookupEnd":185,"domainLookupStart":185,"fetchStart":185,"redirectEnd":0,"redirectStart":0,"requestStart":185,"responseEnd":341,"responseStart":341,"secureConnectionStart":185},{"duration":156.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":185.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":185.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":342,"responseStart":0,"secureConnectionStart":0},{"duration":157.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/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":185.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":185.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":343.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":156.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":185.30000019073486,"connectEnd":185.30000019073486,"connectStart":185.30000019073486,"domainLookupEnd":185.30000019073486,"domainLookupStart":185.30000019073486,"fetchStart":185.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":185.30000019073486,"responseEnd":342,"responseStart":342,"secureConnectionStart":185.30000019073486},{"duration":157.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/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":185.60000038146973,"connectEnd":185.60000038146973,"connectStart":185.60000038146973,"domainLookupEnd":185.60000038146973,"domainLookupStart":185.60000038146973,"fetchStart":185.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":185.60000038146973,"responseEnd":343.30000019073486,"responseStart":343.30000019073486,"secureConnectionStart":185.60000038146973},{"duration":528,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":186.39999961853027,"connectEnd":186.39999961853027,"connectStart":186.39999961853027,"domainLookupEnd":186.39999961853027,"domainLookupStart":186.39999961853027,"fetchStart":186.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":186.39999961853027,"responseEnd":714.3999996185303,"responseStart":714.3999996185303,"secureConnectionStart":186.39999961853027},{"duration":531.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":186.5,"connectEnd":186.5,"connectStart":186.5,"domainLookupEnd":186.5,"domainLookupStart":186.5,"fetchStart":186.5,"redirectEnd":0,"redirectStart":0,"requestStart":186.5,"responseEnd":717.8999996185303,"responseStart":717.8999996185303,"secureConnectionStart":186.5},{"duration":310.1000003814697,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":405.19999980926514,"connectEnd":405.19999980926514,"connectStart":405.19999980926514,"domainLookupEnd":405.19999980926514,"domainLookupStart":405.19999980926514,"fetchStart":405.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":405.19999980926514,"responseEnd":715.3000001907349,"responseStart":715.3000001907349,"secureConnectionStart":405.19999980926514},{"duration":93.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":638.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":638.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":732,"responseStart":0,"secureConnectionStart":0},{"duration":53.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/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":756.3999996185303,"connectEnd":756.3999996185303,"connectStart":756.3999996185303,"domainLookupEnd":756.3999996185303,"domainLookupStart":756.3999996185303,"fetchStart":756.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":756.3999996185303,"responseEnd":809.8999996185303,"responseStart":809.8999996185303,"secureConnectionStart":756.3999996185303}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":45,"responseStart":179,"responseEnd":181,"domLoading":182,"domInteractive":828,"domContentLoadedEventStart":828,"domContentLoadedEventEnd":870,"domComplete":1061,"loadEventStart":1061,"loadEventEnd":1061,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":808.1000003814697},{"name":"bigPipe.sidebar-id.end","time":809},{"name":"bigPipe.activity-panel-pipe-id.start","time":809.1000003814697},{"name":"bigPipe.activity-panel-pipe-id.end","time":809.6000003814697},{"name":"activityTabFullyLoaded","time":879.6999998092651}],"measures":[],"correlationId":"fb114d4841e6b6","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":78,"dbReadsTimeInMs":15,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}