Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-3551

LP #1621046: KILL QUERY not behaving consistently and will hang in some cases

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 08-09-2016 12:44:43

      On 5.6 trunk:

      main.show_check w4 [ fail ]
      Test ended at 2016-08-26 19:30:43

      CURRENT_TEST: main.show_check
      mysqltest: At line 1223: query 'SHOW CREATE TABLE non_existent' failed with wrong errno 1146: 'Table 'test.non_existent' doesn't exist', instead of 1317...

      This could be caused by the server still cleaning up the previous executed statement by the time KILL QUERY for that thread arrives, resetting kill flag before SHOW CREATE TABLE starts executing.

      Backporting the fix for https://bugs.mysql.com/bug.php?id=45679 would address this and also improve KILL QUERY behavior in general.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist