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

Database service (MySQL) stops after show table status command

    XMLWordPrintable

Details

    Description

      Database service (MySQL) stops after "show table status" command issued after specific view was created in user database. When service restored, new session reproduces the crash: "show table status" ends with:

      show table status;
      /* SQL Error (2013): Lost connection to MySQL server during query */

      If I remove the view, everything is fine again, no crash. When I recreate the view (without any error), crash also returns.
      I tried to simplify the query of problematic view. Here are two versions attached: "good" - simplified enough to give no crash, "bad" - giving the crash.
      The difference is that in "bad" query there are two inline views in WITH construction; in "good" query there is only one.

      Attachments

        Issue Links

          Activity

            People

              igor Igor Babaev
              balta Tadas Balaišis
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.