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

Query crashes CREATE TABLE XX AS SELECT * FROM YY

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.1.22
    • Fix Version/s: N/A
    • Component/s: Galera, Server
    • Labels:
    • Environment:
      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

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              Berta Anton
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration