Ich habe mehrere MariaDB Instanzen. Auf der 10.1.11 läuft folgende Funktion durch, auf der Version 10.2.6 nicht. Fehlermeldung: SQL Fehler (5) nicht genügend Speicher.
Ich rufe eine Prozedur auf, in der folgendes SELECT enthalten ist - eingebettet in einem INPUT Statement, welches ich hier weglasse. Das SELECT alleine läuft bereits nicht durch:
SELECT
|
tbl_tmp_import_deals_etl1.counterparty_id,
|
tbl_tmp_import_deals_etl1.deal_id_kits AS `deal_id`,
|
GET_SUB_PORTFOLIO_DEAL_GERMANY(tbl_tmp_import_deals_etl1.deal_id_scpm) AS `sub_portfolio`
|
FROM
|
tbl_tmp_import_deals_etl1;
|
Die aufgerufene Funktion ist wie folgt spezifiziert:
DROP FUNCTION IF EXISTS test_database.GET_SUB_PORTFOLIO_DEAL_GERMANY;
|
CREATE FUNCTION test_database.`GET_SUB_PORTFOLIO_DEAL_GERMANY`(v_deal_id BIGINT(20)) RETURNS varchar(50) CHARSET utf8 COLLATE utf8_unicode_ci
|
READS SQL DATA
|
DETERMINISTIC
|
BEGIN
|
|
DECLARE r_rueck VARCHAR(50);
|
|
SELECT IFNULL(value,'no subportfolio') FROM tbl_tmp_import_deal_type_detail
|
WHERE deal_id_scpm = v_deal_id AND upper(description) = 'GESELLSCHAFT'
|
INTO r_rueck;
|
|
RETURN r_rueck;
|
END;
|
{"report":{"fcp":1289,"ttfb":240.4000000357628,"pageVisibility":"visible","entityId":61933,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"bdf15689-9f6f-4986-a33a-db59e3c96476","navigationType":0,"readyForUser":1386.6000000238419,"redirectCount":0,"resourceLoadedEnd":1207.5,"resourceLoadedStart":245.5,"resourceTiming":[{"duration":331,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":245.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":245.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":576.5,"responseStart":0,"secureConnectionStart":0},{"duration":331,"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":245.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":245.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":576.8000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":554.4000000357628,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":246,"connectEnd":246,"connectStart":246,"domainLookupEnd":246,"domainLookupStart":246,"fetchStart":246,"redirectEnd":0,"redirectStart":0,"requestStart":246,"responseEnd":800.4000000357628,"responseStart":800.4000000357628,"secureConnectionStart":246},{"duration":539.4000000357628,"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":246.19999998807907,"connectEnd":246.19999998807907,"connectStart":246.19999998807907,"domainLookupEnd":246.19999998807907,"domainLookupStart":246.19999998807907,"fetchStart":246.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":246.19999998807907,"responseEnd":785.6000000238419,"responseStart":785.6000000238419,"secureConnectionStart":246.19999998807907},{"duration":336.89999997615814,"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":246.4000000357628,"connectEnd":246.4000000357628,"connectStart":246.4000000357628,"domainLookupEnd":246.4000000357628,"domainLookupStart":246.4000000357628,"fetchStart":246.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":246.4000000357628,"responseEnd":583.3000000119209,"responseStart":583.3000000119209,"secureConnectionStart":246.4000000357628},{"duration":337.19999998807907,"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":246.60000002384186,"connectEnd":246.60000002384186,"connectStart":246.60000002384186,"domainLookupEnd":246.60000002384186,"domainLookupStart":246.60000002384186,"fetchStart":246.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":246.60000002384186,"responseEnd":583.8000000119209,"responseStart":583.8000000119209,"secureConnectionStart":246.60000002384186},{"duration":337.5,"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":246.69999998807907,"connectEnd":246.69999998807907,"connectStart":246.69999998807907,"domainLookupEnd":246.69999998807907,"domainLookupStart":246.69999998807907,"fetchStart":246.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":246.69999998807907,"responseEnd":584.1999999880791,"responseStart":584.1999999880791,"secureConnectionStart":246.69999998807907},{"duration":336.2999999523163,"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":246.9000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":246.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":583.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":543.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":247,"connectEnd":247,"connectStart":247,"domainLookupEnd":247,"domainLookupStart":247,"fetchStart":247,"redirectEnd":0,"redirectStart":0,"requestStart":247,"responseEnd":790.5,"responseStart":790.5,"secureConnectionStart":247},{"duration":544.7000000476837,"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":247.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":247.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":791.9000000357628,"responseStart":0,"secureConnectionStart":0},{"duration":555.0999999642372,"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":247.4000000357628,"connectEnd":247.4000000357628,"connectStart":247.4000000357628,"domainLookupEnd":247.4000000357628,"domainLookupStart":247.4000000357628,"fetchStart":247.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":247.4000000357628,"responseEnd":802.5,"responseStart":802.5,"secureConnectionStart":247.4000000357628},{"duration":948.3000000119209,"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":258.69999998807907,"connectEnd":258.69999998807907,"connectStart":258.69999998807907,"domainLookupEnd":258.69999998807907,"domainLookupStart":258.69999998807907,"fetchStart":258.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":258.69999998807907,"responseEnd":1207,"responseStart":1207,"secureConnectionStart":258.69999998807907},{"duration":945,"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":262.5,"connectEnd":262.5,"connectStart":262.5,"domainLookupEnd":262.5,"domainLookupStart":262.5,"fetchStart":262.5,"redirectEnd":0,"redirectStart":0,"requestStart":262.5,"responseEnd":1207.5,"responseStart":1207.5,"secureConnectionStart":262.5},{"duration":160.19999998807907,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1023.5,"connectEnd":1023.5,"connectStart":1023.5,"domainLookupEnd":1023.5,"domainLookupStart":1023.5,"fetchStart":1023.5,"redirectEnd":0,"redirectStart":0,"requestStart":1023.5,"responseEnd":1183.699999988079,"responseStart":1183.699999988079,"secureConnectionStart":1023.5}],"fetchStart":0,"domainLookupStart":9,"domainLookupEnd":17,"connectStart":17,"connectEnd":45,"secureConnectionStart":26,"requestStart":45,"responseStart":240,"responseEnd":262,"domLoading":244,"domInteractive":1458,"domContentLoadedEventStart":1458,"domContentLoadedEventEnd":1503,"domComplete":2032,"loadEventStart":2032,"loadEventEnd":2033,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1430.199999988079},{"name":"bigPipe.sidebar-id.end","time":1430.9000000357628},{"name":"bigPipe.activity-panel-pipe-id.start","time":1431.1000000238419},{"name":"bigPipe.activity-panel-pipe-id.end","time":1433.1000000238419},{"name":"activityTabFullyLoaded","time":1525.4000000357628}],"measures":[],"correlationId":"3b7be0ef2eeb50","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":123,"dbReadsTimeInMs":18,"dbConnsTimeInMs":27,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
andi1306, I'd recommend to switch to innodb_buffer_pool_instances=1 for 32bit, due to some weird rounding behavior described in
MDEV-12097, buffer pool can grow almost to twice its original size, which for 32bit process mysqld maybe zu viel.