Details

    Description

      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;
      

      Attachments

        Issue Links

          Activity

            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.

            wlad Vladislav Vaintroub added a comment - 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.

            andi1306, could you please try to re-configure as wlad suggests above and see if the problem goes away? I don't think you planned for the buffer pool size to take 2.9G.

            elenst Elena Stepanova added a comment - andi1306 , could you please try to re-configure as wlad suggests above and see if the problem goes away? I don't think you planned for the buffer pool size to take 2.9G.
            andi1306 Andreas added a comment -

            Good morning!
            I've changed the innodb_buffer_pool_instances as requested. However, that fixed not the problem I've attached some screenshots.
            Remarkable: If I run a joint select the db gives back the results after 1.3 sec. but that is not object oriented and I have to redesign several procedures.

            Any idea?
            Thanks in advance
            Andreas

            andi1306 Andreas added a comment - Good morning! I've changed the innodb_buffer_pool_instances as requested. However, that fixed not the problem I've attached some screenshots. Remarkable: If I run a joint select the db gives back the results after 1.3 sec. but that is not object oriented and I have to redesign several procedures. Any idea? Thanks in advance Andreas
            alice Alice Sherepa added a comment -

            Hi Andreas,
            I reproduced the problem on 10.2.6, both Ubuntu and Windows, can not reproduce on versions >=10.2.7
            It looks like it was fixed after fixing MDEV-12992
            Is it possible for you to move to higher versions and see if it works for you?

            alice Alice Sherepa added a comment - Hi Andreas, I reproduced the problem on 10.2.6, both Ubuntu and Windows, can not reproduce on versions >=10.2.7 It looks like it was fixed after fixing MDEV-12992 Is it possible for you to move to higher versions and see if it works for you?

            andi1306, have you had a chance to upgrade and see if the problem has gone away?

            elenst Elena Stepanova added a comment - andi1306 , have you had a chance to upgrade and see if the problem has gone away?

            For now we'll consider it fixed in the scope of MDEV-12992.

            elenst Elena Stepanova added a comment - For now we'll consider it fixed in the scope of MDEV-12992 .

            People

              Unassigned Unassigned
              andi1306 Andreas
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.