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

MariaDB 12.2.2 crashes with SIGFPE on NTILE() partitioned by TEXT value longer than 1024 bytes

    XMLWordPrintable

Details

    • Can result in hang or crash
    • Q3/2026 Server Maintenance

    Description

      Executing the attached read-only SELECT causes the MariaDB server to terminate or stop accepting connections.
      The database was healthy immediately before the query. When the query was executed, the client received:

      ERROR 2013 (HY000): Lost connection to MySQL server during query

      All subsequent connection attempts failed with:

      ERROR 2003 (HY000): Can't connect to MySQL server
      		 
      Connection refused

      A SQL error should not terminate the server. The server should either return a result or report an error while continuing to accept connections.

      How to repeat

      DROP DATABASE IF EXISTS round25;
      		 
      CREATE DATABASE round25;
      		 
      USE round25;
      		 
       
      		 
      CREATE TABLE t (c TEXT);
      		 
      INSERT INTO t VALUES (REPEAT('x',1025)),(REPEAT('x',1025));
      		 
       
      		 
      SELECT NTILE(2) OVER(PARTITION BY c) FROM t;

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39451 Floating point exception: division by zero in Item_sum_ntile::val_int

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39451 Floating point exception: division by zero in Item_sum_ntile::val_int

          • Major - Major loss of function.
          • Closed

          Activity

            People

              ycp Yuchen Pei
              chen7897 cl hl
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.15h
                  0.15h

                  Git Integration

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