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

mysqld got signal 11 after SELECT DISTINCT

Details

    Description

      Attached is the Log after the Query is fired to the Server:

      SELECT DISTINCT t1.`ID` FROM JAX_FORM_RESOURCES t1 WHERE (t1.`ID` LIKE 'resources/SYSTEM/SCHEDULER_JOBS_FORM/V%')

      Same Database Downgraded to 10.6.19 everything Works.

      Every Table in DB is per SPIDER Connected to a MariaDB 10.6.20 Database:

      wrapper "mysql", srv "link_1011_local", table "JAX_FORM_RESOURCES"

      Everything works directly connected to a MariaDB Server 10.6.20 without SPIDER Engine in between.

      MariaDB with SPIDER Engine Connects to a HAProxy and also directly to another MariaDB 10.6.20 Server and via HAProxy to another MariaDB 10.6.20 Galera Cluster.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26345 SELECT MIN on Spider table returns more rows than expected

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35868 MariaDB 11.4.4 Crashes when querying a Spider table on a remote system with a distinct selection that is not a primary key.

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35623 UBSAN: function-type-mismatch in spider_param_conn_recycle[_mode/_strict], spider_param_internal_xa_snapshot, and spider_param_block_size

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Ground0 René Linder created issue -
            Ground0 René Linder made changes -
            Field Original Value New Value
            Description Attached is the Log after the Query is fired to the Server:

            {noformat}
            SELECT DISTINCT t1.`ID` FROM JAX_FORM_RESOURCES t1 WHERE (t1.`ID` LIKE 'resources/SYSTEM/SCHEDULER_JOBS_FORM/V%')
            {noformat}

            Same Database Downgraded to 10.6.19 everything Works.

            Every Table in DB is per SPIDER Connected to a MariaDB 10.6.20 Database:

            {noformat}
            wrapper "mysql", srv "link_1011_local", table "JAX_FORM_RESOURCES"
            {noformat}

            Also works everything directly connected to a MariaDB without SPIDER Engine in between.

            MariaDB with SPIDER Engine Connects to a HAProxy and also directly to another MariaDB 10.6.20 Server and via HAProxy to another MariaDB 10.6.20 Galera Cluster.
            		Attached is the Log after the Query is fired to the Server:

            {noformat}
            SELECT DISTINCT t1.`ID` FROM JAX_FORM_RESOURCES t1 WHERE (t1.`ID` LIKE 'resources/SYSTEM/SCHEDULER_JOBS_FORM/V%')
            {noformat}

            Same Database Downgraded to 10.6.19 everything Works.

            Every Table in DB is per SPIDER Connected to a MariaDB 10.6.20 Database:

            {noformat}
            wrapper "mysql", srv "link_1011_local", table "JAX_FORM_RESOURCES"
            {noformat}

            Everything works directly connected to a MariaDB Server 10.6.20 without SPIDER Engine in between.

            MariaDB with SPIDER Engine Connects to a HAProxy and also directly to another MariaDB 10.6.20 Server and via HAProxy to another MariaDB 10.6.20 Galera Cluster.
            serg Sergei Golubchik made changes -
            Summary  mysqld got signal 11 after SELECT DISTINCT mysqld got signal 11 after SELECT DISTINCT
            serg Sergei Golubchik made changes -
            Fix Version/s 10.6 [ 24028 ]
            ycp Yuchen Pei made changes -
            Labels crash crash regression-10.6
            ycp Yuchen Pei made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            Fix Version/s 10.5 [ 23123 ]
            ycp Yuchen Pei made changes -
            Priority Critical [ 2 ] Blocker [ 1 ]
            ycp Yuchen Pei made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            ycp Yuchen Pei made changes -
            Assignee Yuchen Pei [ JIRAUSER52627 ] Alexey Botchkov [ holyfoot ]
            Status Confirmed [ 10101 ] In Review [ 10002 ]
            ycp Yuchen Pei made changes -
            Labels crash regression-10.6 crash
            ycp Yuchen Pei made changes -
            Affects Version/s 10.5 [ 23123 ]
            elenst Elena Stepanova made changes -
            Labels crash crash regression
            ralf.gebhardt Ralf Gebhardt made changes -
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Yuchen Pei [ JIRAUSER52627 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            ycp Yuchen Pei made changes -
            Fix Version/s 10.5.28 [ 29952 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            JIraAutomate JiraAutomate made changes -
            Fix Version/s 10.6.21 [ 29953 ]
            Fix Version/s 10.11.11 [ 29954 ]
            Fix Version/s 11.4.5 [ 29956 ]
            Fix Version/s 11.7.2 [ 29914 ]
            ycp Yuchen Pei made changes -
            Roel Roel Van de Paar made changes -
            Roel Roel Van de Paar made changes -
            ycp Yuchen Pei made changes -

            People

              ycp Yuchen Pei
              Ground0 René Linder
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.