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

Query crashes CREATE TABLE XX AS SELECT * FROM YY

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.1.22
    • N/A
    • Galera, Server
    • Redhat 7.3

    Description

      Hi there,

      my mariaDB with Galera enabled is crashing when a tool that is creating some schemas running the following query CREATE TABLE DP_ORDERBY_BACKUP AS SELECT * FROM DP_ORDERBY.

      The problem is whenever the tool is trying to run the query (s. above) the mariadb cluster is crashing without any warning and not just one node, all of them are unavailable.

      The DP_ORDERBY table is empty, I have tried running the same query where the DP_ORDERBY table has one value in it in that case mariadb is running fine. I've looked also into other issues (s. linked issues) but somehow this failure was fixed in older versions but still appearing in my 10.1.22 version.

      Any input helps thanks!

      Attachments

        1. error-log.mariadb.galera.log
          4 kB
        2. galera.cnf
          0.5 kB
        3. my.cnf
          0.5 kB

        Issue Links

          is part of

          Bug - A problem which impairs or prevents the functions of the product. MDEV-6924 Server crashed on CREATE TABLE AS SELECT

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-7935 CREATE TABLE ... AS SELECT ... can cause a Server crash (Assertion `0' in Protocol::end_statement)

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Berta Anton created issue -
            Berta Anton made changes -
            Field Original Value New Value
            Berta Anton made changes -
            Berta Anton made changes -
            Environment Rehat 7.3 Redhat 7.3
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1 [ 16100 ]
            Assignee Jan Lindström [ jplindst ]
            Berta Anton made changes -
            Description Hi there,

            my mariaDB with Galera enabled is crashing when a tool that is creating some schemas running the following query {{CREATE TABLE DP_ORDERBY_BACKUP AS SELECT * FROM DP_ORDERBY}}. I have found

            The problem is whenever the tool is trying to run the query (s. above) the mariadb cluster is crashing with not just one node ... all of them.

            The DP_ORDERBY table is empty, I have tried running the same query where the DP_ORDERBY table has one value in it in that case mariadb is running fine. I've looked also into other issues (s. linked issues) but somehow this failure was fixed in older versions but still appearing in my 10.1.22 version.

            Any input helps thanks!             		Hi there,

            my mariaDB with Galera enabled is crashing when a tool that is creating some schemas running the following query {{CREATE TABLE DP_ORDERBY_BACKUP AS SELECT * FROM DP_ORDERBY}}.

            The problem is whenever the tool is trying to run the query (s. above) the mariadb cluster is crashing without any warning and not just one node, all of them are unavailable.

            The *DP_ORDERBY table is empty*, I have tried running the same query where the DP_ORDERBY table has one value in it in that case mariadb is running fine. I've looked also into other issues (s. linked issues) but somehow this failure was fixed in older versions but still appearing in my 10.1.22 version.

            Any input helps thanks!
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Cannot Reproduce [ 5 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 80149 ] MariaDB v4 [ 151874 ]

            People

              jplindst Jan Lindström (Inactive)
              Berta Anton
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.