Can not stop a query

[dpordomingo]

Trying to stop a query either run from mysql client, srcd sql client, or srcd sql command does not work as expected because it keeps running on background as it can be seen if querying the PROCESSLIST.

It works if quering and cancelling from gitbase-web.

using:

• docker version: 1.39
• srcd cli version: v0.11.0
• srcd daemon version: v0.11.0
• srcd/gitbase: v0.19.0
• srcd/gitbase-web: v0.6.2

[carlosms]

How are you cancelling the query exactly? kill, kill connection, kill query?

[dpordomingo]

I think that Ctrl+C should be also captured by srcd sql and kill the query being processed.

[smacker]

that is not how mysql clients work. Exit only breaks the connection and we do it right now. Imo it's better to keep engine behavior consistent with the user's prior knowledge.

[carlosms]

can we close this one @dpordomingo?

[dpordomingo]

I still could not kill some queries, even with kill command from another mysql client from another shell tab... but could not describe the problem good enough to be fully reproducible...
So... we could close... and I'll reopen once I have more data to describe the problem.

[carlosms]

Closing, since Engine sql client works as expected. If you have any problem using kill it is most probably not related to Engine.
Also, take a look at this one, in case you hit a related problem: src-d/go-mysql-server#635