ShenFeng312 commented on issue #37404: URL: https://github.com/apache/shardingsphere/issues/37404#issuecomment-3677885042
First, you need to understand that the ID used by the driver when calling cancel comes from the handshake protocol packet of the proxy. We need to understand that the essence of mysqlkill or kill query is to terminate the query or close the connection associated with the corresponding ID. It's just that the ID returned by show processlist in native MySQL is always the same as the handshake ID. If each node uses the JVM incremented ID, the ID will be duplicated, leading to ambiguity in the kill command. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
