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

SIGSEGV on SELECT query

Details

    Description

      Running crashes the server 11.5.2-MariaDB-ubu2404 from official docker images.

      SELECT
      		 
        *
      		 
      FROM
      		 
      (
      		 
        SELECT
      		 
      	'a' AS status
      		 
        FROM
      		 
          information_schema.tables
      		 
       
      		 
        UNION
      		 
       
      		 
        SELECT
      		 
      	CASE
      		 
      	  'a' WHEN 'b' THEN 'c'
      		 
      	END
      		 
        FROM
      		 
      	information_schema.tables
      		 
      ) AS t
      		 
      WHERE
      		 
        status = '10'

      The result:

      SQL Error [08000]: Could not connect to localhost:3311 : unexpected end of stream, read 0 bytes from 4 (socket was closed by server)
      		 
        Could not connect to localhost:3311 : unexpected end of stream, read 0 bytes from 4 (socket was closed by server)
      		 
        Could not connect to localhost:3311 : unexpected end of stream, read 0 bytes from 4 (socket was closed by server)
      		 
          unexpected end of stream, read 0 bytes from 4 (socket was closed by server)
      		 
          unexpected end of stream, read 0 bytes from 4 (socket was closed by server)

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          grzegorz.dabrowski Grzegorz Dąbrowski added a comment -

          Are you sure this is a duplicate of MDEV-34683?
          The problem still exists in 11.5.2-MariaDB-ubu2404 and 11.6.1-MariaDB-ubu2404.

          grzegorz.dabrowski Grzegorz Dąbrowski added a comment - Are you sure this is a duplicate of MDEV-34683 ? The problem still exists in 11.5.2-MariaDB-ubu2404 and 11.6.1-MariaDB-ubu2404.
          Szymkowiak Tomasz Szymkowiak added a comment -

          Same results on mariadb-11.5.2-linux-systemd-x86_64

          Result of a query run in the console:

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

          Result of a query run from an external tool (DBeaver):

          SQL Error [08000]: (conn=4) Socket error

          Szymkowiak Tomasz Szymkowiak added a comment - Same results on mariadb-11.5.2-linux-systemd-x86_64 Result of a query run in the console: ERROR 2013 (HY000): Lost connection to server during query Result of a query run from an external tool (DBeaver): SQL Error [08000]: (conn=4) Socket error
          grzegorz.dabrowski Grzegorz Dąbrowski added a comment -

          It seems to be fixed in 11.6.2. Thanks.

          grzegorz.dabrowski Grzegorz Dąbrowski added a comment - It seems to be fixed in 11.6.2. Thanks.

          People

            oleg.smirnov Oleg Smirnov
            grzegorz.dabrowski Grzegorz Dąbrowski
            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.