I do not know is it right? Mysql "deadlock"

See the program stack found, is returned in the mysql, but found the connection status is sleep MySQL show processlist, what is this phenomenon, solution or the next step analysis method

Started by Merle at February 06, 2016 - 5:04 AM

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.

Posted by Yolanda at February 25, 2016 - 6:17 AM

If the InnoDB table

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)

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.

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

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