Bug #84470 mysql_stmt_close hangs when the statement is canceled with KILL QUERY
Submitted: 11 Jan 2017 11:20 Modified: 24 Sep 2022 6:26
Reporter: Sebastien FLAESCH Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: C API (client library) Severity:S1 (Critical)
Version:8.0.19 OS:Debian (11)
Assigned to: CPU Architecture:Any
Tags: KILL QUERY mysql_stmt_prepare mysql_stmt_close hangs

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[11 Jan 2017 11:21] Sebastien FLAESCH
C sample to reproduce the problem

Attachment: kill_prepared_query.c (text/x-csrc), 3.47 KiB.

[11 Jan 2017 11:22] Sebastien FLAESCH
Second C sample, using mysql_query() instead of prepared statements (works)

Attachment: kill_query.c (text/x-csrc), 2.71 KiB.