After kill query, mysql_stmt_close() hangs for prepared stmt
Posted by: Sebastien FLAESCH
Date: June 23, 2022 06:20AM

Since MySQL 5.7 SQL interruption is broken in our application.

Did you ever CTRL-C a long running query with mysql command line tool? It works, because uses mysql_real_query(), but when using mysql_stmt_prepare() / mysql_bind_param() / mysql_stmt_execute() as our application there is a problem.

Just installed 8.0.29 and the problem gets worse: First it was limited to long running SELECT statements, now (since 8.0.x) UPDATE waiting for a lock is also broken...

Just giving a heads up here because I don't get much help on the reported bug ticket.

All details with sample program here:


Options: ReplyQuote

Written By
After kill query, mysql_stmt_close() hangs for prepared stmt
June 23, 2022 06:20AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.