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

insert ... select from joins hangs or result in 1206: The total number of locks exceeds the lock table size

    XMLWordPrintable

Details

    Description

      Splitted from MDEV-28804.

      Run the following test with --innodb_buffer_pool_size=5m, in a build of CMAKE_BUILD_TYPE=RelWithDebInfo and WITH_DBUG_TRACE:BOOL=OFF.

      10.5 a7ee3bc58bc23ad7ac5ced54dc745d0e65bee524

      		 
      --source include/have_innodb.inc
      		 
      CREATE TABLE t1 (d DOUBLE) engine=innodb;
      		 
      INSERT INTO t1 VALUES (0x0061),(0x0041),(0x00E0),(0x00C0),(0x1EA3),(0x1EA2),(0x00E3),(0x00C3),(0x00E1),(0x00C1),(0x1EA1),(0x1EA0);
      		 
      INSERT INTO t1 SELECT t1.* FROM t1,t1 t2,t1 t3,t1 t4,t1 t5,t1 t6;
      		 
       
      		 
      drop table t1;

      It either hangs or results in 1206: The total number of locks exceeds the lock table size.

      See marko's comment for some initial analysis and hint:
      https://jira.mariadb.org/browse/MDEV-28804?focusedCommentId=278885&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-278885

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28804 Increased lock objects in 10.6+ leading to significant slowdown when using a limited InnoDB buffer pool, including in release builds

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28803 ERROR 1206 (HY000): The total number of locks exceeds the lock table size

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28805 SET GLOBAL innodb_buffer_pool_size=12*1024*1024 has different outcomes depending on version

          • Major - Major loss of function.
          • Confirmed

          Activity

            People

              ycp Yuchen Pei
              ycp Yuchen Pei
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.