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

Query crashes CREATE TABLE XX AS SELECT * FROM YY

    XMLWordPrintable

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. my.cnf
          0.5 kB
        2. galera.cnf
          0.5 kB
        3. error-log.mariadb.galera.log
          4 kB

        Issue Links

          Activity

            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.