Bug #21115 hang in executequery
Submitted: 18 Jul 2006 14:39 Modified: 31 Mar 2014 11:49
Reporter: Glenn Kirsten Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / J Severity:S1 (Critical)
Version:4.1.20 OS:Linux (Linux)
Assigned to: Alexander Soklakov CPU Architecture:Any

[18 Jul 2006 14:39] Glenn Kirsten
Description:
my database is 4.1.20
jdbc driver is 3.1.12

I try to executequery on a select statement with only a few rows returning. I get no response from jdbc driver when running on Linux. It hangs :-(

I do NOT get the problem when running the same from windows environment

        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:129)
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedS)
        - locked <0xab3df5a0> (a java.lang.Object)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepare)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java)
        - locked <0xab3df5a0> (a java.lang.Object)
        - locked <0xab49b198> (a com.mysql.jdbc.ServerPreparedStatement)

How to repeat:
It always happens in the same sql, which returns a minor number of rows.
[18 Jul 2006 16:12] Glenn Kirsten
may i add....i use myisam tables
[18 Jul 2006 17:55] Glenn Kirsten
The problem does not apply for the 4.1.9 server which doesnt have this bug
[19 Jul 2006 7:32] Sveta Smirnova
Thank you for the report.

Could you please provide query which causes error and structure of all tables (output of SHOW CREATE TABLE) using in the query?
[19 Aug 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[31 Mar 2014 11:49] Alexander Soklakov
I close this report as "Can't repeat" because there is no feedback for a long time and codebase is too old. Please, feel free to reopen it if the problem still exists in current driver.