MilanTyagi2004 commented on issue #37404: URL: https://github.com/apache/shardingsphere/issues/37404#issuecomment-3675112790
@ShenFeng312 MySQL's Issue Uses thread ID from the handshake packet for KILL QUERY In cluster mode, ShardingSphere returns a JVM-level auto-incremented ID instead of the actual MySQL thread ID This causes Statement.cancel() to fail but in PostgreSQL's Mechanism it Uses a different approach: Sends cancel over a separate connection Uses backend process ID (PID) and secret key from the connection object PID/secret come from the actual connection, not a handshake packet so PostgreSQL likely does not have same issue. according to me -- 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]
