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 mysql.cc 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:

https://bugs.mysql.com/bug.php?id=84470

BR
Seb

Options: ReplyQuote


Subject
Views
Written By
Posted
After kill query, mysql_stmt_close() hangs for prepared stmt
95
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.