SLEEP is a request waiting for CLIENT to end. Wait step check program in what position.
Posted by Beck at February 13, 2016 - 5:46 AM
Sleeping
Waiting for the client to send a new request.
Waiting for the client to send a new request.
Posted by Yolanda at February 25, 2016 - 6:17 AM
If the InnoDB table
Show InnoDB status can see the deadlock recent record
Show InnoDB status can see the deadlock recent record
Posted by Yolanda at March 08, 2016 - 6:47 AM
This is amazing, all in the read
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:105)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:148)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:176)
- locked <0x00000000e66e3a68> (a com.mysql.jdbc.util.ReadAheadInputStream)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1899)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:481)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1410)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1133)
- locked <0x00000000e66e3d48> (a java.lang.Object)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:670)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
- locked <0x00000000e66e3d48> (a java.lang.Object)
- locked <0x00000000e66e3df8> (a com.mysql.jdbc.ServerPreparedStatement)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:105)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:148)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:176)
- locked <0x00000000e66e3a68> (a com.mysql.jdbc.util.ReadAheadInputStream)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1899)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:481)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1410)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1133)
- locked <0x00000000e66e3d48> (a java.lang.Object)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:670)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
- locked <0x00000000e66e3d48> (a java.lang.Object)
- locked <0x00000000e66e3df8> (a com.mysql.jdbc.ServerPreparedStatement)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
Posted by Merle at March 13, 2016 - 7:35 AM
Let I be analysis, a hundred years
Posted by Merle at March 28, 2016 - 7:54 AM
Look at the MySQL show InnoDB status; whether MySQL deadlock.
Sleep client request is not processed reason.
Sleep client request is not processed reason.
Posted by natascha at March 31, 2016 - 8:27 AM
Run out of the connection is not released.. Connection leak
Posted by Guy at November 27, 2016 - 12:50 AM
But the request is in the read state, in addition to not return, I do not know what is
Posted by Merle at December 07, 2016 - 1:48 AM
If a deadlock, the background will be reported to the wrong. You then have a look inside the procedure in the catch rollback does not.
You put the program to end, or sleep state
You put the program to end, or sleep state
Posted by Guy at December 22, 2016 - 2:20 AM
I didn't use a transaction, the sleep connection kill off, the client side immediately report broken pipe, thread releases, establish lever to see a movie!
Posted by Merle at December 31, 2016 - 3:19 AM
The reason has been read database.?
Posted by Guy at January 01, 2017 - 4:15 AM
What has been read database
Posted by Merle at January 12, 2017 - 3:58 AM
Started by Merle at February 06, 2016 - 5:04 AM