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

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.39, 10.0.13, 10.1.0
        • Fix Version/s: 10.0.16
        • Component/s: Admin statements
        • Labels:

          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.

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                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.

                Show
                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.

                  People

                  • Assignee:
                    serg Sergei Golubchik
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 1 hour, 40 minutes
                      1h 40m