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

Server crash on query

Details

    Description

      I've just upgraded from 10.4 to 10.5 and now some queries results in a server crash.
      The issue can be reproduced by creating this simple table and make a query on it. It doesn't matter if the table is empty or not.

      CREATE TABLE `test` (
      		 
      	`a` BIGINT(20) NOT NULL,
      		 
      	`b` BIGINT(20) NOT NULL,
      		 
      	`c` BIGINT(20) NOT NULL,
      		 
      	PRIMARY KEY (`a`, `b`, `c`) USING BTREE,
      		 
      	INDEX `KEY_2` (`b`) USING BTREE
      		 
      ) ENGINE=InnoDB;

      Then running this query produce the crash:

      SELECT count(*) FROM test
      		 
      WHERE c = 1
      		 
      AND a IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,
      		 
                31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,
      		 
      			 58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90)
      		 
      AND b IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,
      		 
                31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,
      		 
      			 58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90);

      I've found out, that it is important how many values are in the lists. Less number seems to work.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25269 Crash: exception 0xc0000005

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24953 10.5.9 crashes with large IN() list

          • Major - Major loss of function.
          • Closed

          Activity

            People

              psergei Sergei Petrunia
              csiebert Carsten Siebert
              Votes:
              1 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.