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

              Assignee:
              igor Igor Babaev
              Reporter:
              balta Tadas Balaišis
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: