Bug #74979 Server query cache vs protocol issue
| Submitted: | 24 Nov 2014 12:19 | Modified: | 7 Jul 2017 9:08 |
|---|---|---|---|
| Reporter: | Filipe Silva | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Server: Query Cache | Severity: | S2 (Serious) |
| Version: | 5.7.4, 5.6.21, 5.5.40, 5.1.73 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[24 Nov 2014 12:19]
Filipe Silva
[19 Dec 2014 22:18]
Sveta Smirnova
Thank you for the report. Please provide Java code, demonstrating the problem.
[20 Dec 2014 3:08]
Yves Gillet
test cursor
Attachment: MysqlJdbcTest.java (application/octet-stream, text), 2.62 KiB.
[20 Dec 2014 3:08]
Yves Gillet
Hi you can use the test I provided for bug #74739. To use it, ensure the query cache is enabled on server then run the test, the thread will be stuck. Regards Yves Gillet.
[15 Jan 2015 20:23]
Sveta Smirnova
Thank you for the feedback. Verified as described in last comment: since I enabled query cache all threads stack.
[7 Jul 2017 9:08]
Erlend Dahl
MySQL will no longer invest in the query cache, see: http://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.