Re: mysql_stmt_close() hangs after query interruption
Posted by: Sebastien FLAESCH
Date: March 26, 2020 03:42AM

One of my ideas was to skip the call to mysql_stmt_close(stmt) in statement interruption error (mysql_errno(conn) == 1317) is detected...
Even if the statement handle (and maybe cursor resources on server side) are not released, it is not critical, since statement interruption should not occur very often...

But unfortunately the next call to mysql_stmt_init(conn) gives error 2014 (CR_COMMANDS_OUT_OF_SYNC) !!! Maybe some internal flag is de-synchronized after statement interruption?

Also tried different combinations of mysql_stmt_free_result(stmt) and mysql_stmt_reset(stmt) ... no way...

Seb

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysql_stmt_close() hangs after query interruption
442
March 26, 2020 03:42AM


Sorry, you can't reply to this topic. It has been closed.

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.