Bug #77483 locked <5cc8768e> (a com.mysql.jdbc.util.ReadAheadInputStream)

• Submitted: 25 Jun 2015 12:19
• Modified: 25 Jun 2015 13:08
• Reporter: Jaideep Gunda
• Status: Not a Bug
• Category: Connector / J
• Severity: S3 (Non-critical)
• Version: 5.1.28
• OS: Red Hat
• CPU Architecture: Any
• Tags: - locked <5cc8768e> (a com.mysql.jdbc.util.ReadAheadInputStream)

[25 Jun 2015 12:19] Jaideep Gunda

Description:
Environment:-
MySQL 5.5.x with JDBC 5.1.28
Jboss  6.1.x 
JDK 1.7.51 
Redhat Linux 6.x 

Problem:
I have two deployment of this same application on two different server environments and in first environment it works fine and the timing less than 3 seconds, but in the second environment it is performing slow and it is between 14 to 20 seconds. 

The log file show some locked exceptions as given below 
- locked <5cc8768e> (a com.mysql.jdbc.util.ReadAheadInputStream)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3163)
...
- locked <6cdf9438> (a com.mysql.jdbc.JDBC4Connection)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313)
..
- locked <6cdf9438> (a com.mysql.jdbc.JDBC4Connection)
 

 Please let me know if you need more information. 

 Thanks in advance for you suggestions and solutions

Exception details:-
"http-xxxxxxxxxxx:8080-12" - Thread t@360
   java.lang.Thread.State: RUNNABLE
                at java.net.SocketInputStream.socketRead0(Native Method)
                at java.net.SocketInputStream.read(SocketInputStream.java:152)
                at java.net.SocketInputStream.read(SocketInputStream.java:122)
                at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)
                at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)
                at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)

                - locked <5cc8768e> (a com.mysql.jdbc.util.ReadAheadInputStream)

                at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3163)
                at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3620)
                at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3609)
                at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4160)
                at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
                at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
                at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)

                - locked <6cdf9438> (a com.mysql.jdbc.JDBC4Connection)

                at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)

                - locked <6cdf9438> (a com.mysql.jdbc.JDBC4Connection)

                at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313)

                - locked <6cdf9438> (a com.mysql.jdbc.JDBC4Connection)

                at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
                at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                at java.lang.reflect.Method.invoke(Method.java:606)
                at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
                at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
                at com.sun.proxy.$Proxy406.executeQuery(Unknown Source)
                at org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
                at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
                at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
                at org.hibernate.loader.Loader.doQuery(Loader.java:899)
                at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
                at org.hibernate.loader.Loader.doList(Loader.java:2516)
                at org.hibernate.loader.Loader.doList(Loader.java:2502)
                at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2332)
                at org.hibernate.loader.Loader.list(Loader.java:2327)
                at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338)
                at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1783)
                at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:231)
                at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:157)
                at com.repository.impl.InventionDisclosureRepositoryImpl.findDocketListByExaminerAndDocketCategories(InventionDisclosureRepositoryImpl.java:1050)
                at com.repository.impl.InventionDisclosureRepositoryImpl.findDocketListByExaminerAndDocketCategories(InventionDisclosureRepositoryImpl.java:1017)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                at java.lang.reflect.Method.invoke(Method.java:606)
                at 

How to repeat:
Environment:-
MySQL 5.5.x with JDBC 5.1.28
Jboss  6.1.x 
JDK 1.7.51 
Redhat Linux 6.x 

This is a REST based web application.

[25 Jun 2015 13:08] MySQL Verification Team

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.