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

KILL QUERY executed on an idle connection can interrupt the next query

Details

    Description

      --connect (con1,localhost,root,,)
      		 
       
      		 
      --let $con_id = `SELECT CONNECTION_ID()`
      		 
       
      		 
      --connection default
      		 
       
      		 
      eval KILL QUERY $con_id;
      		 
       
      		 
      --connection con1
      		 
       
      		 
      --error ER_QUERY_INTERRUPTED
      		 
      SELECT * FROM mysql.user;
      		 
       
      		 
      --disconnect con1

      Result:

      SELECT * FROM mysql.user;
      		 
      ERROR 70100: Query execution was interrupted

      Also reproducible on MySQL 5.1-5.6, but seems to have been fixed in 5.7, so there is no point at filing the bug report upstream.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Fix Version/s 10.0 [ 16000 ]
          Fix Version/s 10.1 [ 16100 ]
          elenst Elena Stepanova made changes -
          Labels upstream upstream-fixed
          elenst Elena Stepanova added a comment -

          Moving to upstream-fixed because it's not reproducible on 5.7, hence no upstream bug report, hence no reason to wait for an upstream fix.

          elenst Elena Stepanova added a comment - Moving to upstream-fixed because it's not reproducible on 5.7, hence no upstream bug report, hence no reason to wait for an upstream fix.
          serg Sergei Golubchik made changes -
          Priority Minor [ 4 ] Major [ 3 ]
          serg Sergei Golubchik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.16 [ 17900 ]
          Fix Version/s 10.0 [ 16000 ]
          serg Sergei Golubchik made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Component/s Admin statements [ 11400 ]
          Component/s OTHER [ 10125 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 53824 ] MariaDB v3 [ 65086 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 65086 ] MariaDB v4 [ 148215 ]

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.