Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37149

ERROR 1221 (HY000): innodb_buffer_pool_size change aborted

    XMLWordPrintable

Details

    Description

      The issue is similar to MDEV-36646.
      PS: It is reproduced only through mariadb cli

      CREATE TEMPORARY TABLE t1 (a INT) ENGINE=INNODB;
      CREATE TABLE t1 (a INT) ENGINE=INNODB;
      CREATE TABLE t2 (a TEXT,FULLTEXT INDEX (a)) ENGINE=INNODB;
      SET max_session_mem_used=8192;
      CREATE TABLE t3 (a INT,KEY(a)) ENGINE=INNODB PARTITION BY HASH (a) PARTITIONS 3;
      SET GLOBAL innodb_buffer_pool_size=+1;
      

      Leads to:

      CS 12.1.0 d4d0dd00b761b3e94454dff9aa93e2e17232339e (Optimized) Build 30/06/2025

      12.1.0-opt>SET GLOBAL innodb_buffer_pool_size=+1;
      ERROR 1221 (HY000): innodb_buffer_pool_size change aborted
      12.1.0-opt>
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed                             
      CS  10.6   dbg  300625  56fbc0cdd79bbbcb84ef0d3a20ffaf72267186a2  No bug found                                
      CS  10.6   opt  300625  56fbc0cdd79bbbcb84ef0d3a20ffaf72267186a2  No bug found                  
      CS  10.11  dbg  270625  7ab205b0097140cdbb4778b05d6f6a0522c05a78  No bug found                  
      CS  10.11  opt  270625  7ab205b0097140cdbb4778b05d6f6a0522c05a78  No bug found                  
      CS  11.4   dbg  300625  c742cc94baee27074100aa90eff96468bdd9943e  MARIADBD_ERROR|mariadbd: innodb_buffer_pool_size change aborted
      CS  11.4   opt  300625  c742cc94baee27074100aa90eff96468bdd9943e  MARIADBD_ERROR|mariadbd: innodb_buffer_pool_size change aborted
      CS  11.8   dbg  300625  311b4445c59caa36ed031f5499eae79d07b68c0c  MARIADBD_ERROR|mariadbd: innodb_buffer_pool_size change aborted
      CS  11.8   opt  300625  a65f7dc71dcd9d6ca1399221f669641910130624  MARIADBD_ERROR|mariadbd: innodb_buffer_pool_size change aborted
      CS  12.0   dbg  130525  00a9afb5818433c26537ccaf6b2c59ad493dd473  MARIADBD_ERROR|mariadbd: innodb_buffer_pool_size change aborted
      CS  12.0   opt  070525  51c0afcd248ad57095fdcf56efec2865ea49bd83  MARIADBD_ERROR|mariadbd: innodb_buffer_pool_size change aborted
      CS  12.1   dbg  190625  2ee2e2d0f3d3dbfafebdb75ee7bc2914b97e9065  MARIADBD_ERROR|mariadbd: innodb_buffer_pool_size change aborted
      CS  12.1   opt  190625  2ee2e2d0f3d3dbfafebdb75ee7bc2914b97e9065  MARIADBD_ERROR|mariadbd: innodb_buffer_pool_size change aborted
      ES  10.5   dbg  050525  0d368ec0042a81d9549fc939fb742f82350b20ab  No bug found                  
      ES  10.5   opt  050525  0d368ec0042a81d9549fc939fb742f82350b20ab  No bug found                  
      ES  10.6   dbg  050525  6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62  No bug found                  
      ES  10.6   opt  050525  6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62  No bug found                  
      ES  11.4   dbg  050525  9cd12544ebfd0d52d2158af66b5aced58121cf1f  No bug found                  
      ES  11.4   opt  050525  9cd12544ebfd0d52d2158af66b5aced58121cf1f  No bug found                  
      

      Attachments

        Issue Links

          Activity

            People

              ramesh Ramesh Sivaraman
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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