MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Posted by: Dmitry Nezhevenko
Date: February 11, 2008 01:45PM

Hi Mark and thanks for your response. We are using commons dbcp DataSource. When I got these strange backtraces, I've tried to enable connection checking to datasource, using "mysql ping" (SELECT 1). And currently there are no such backtraces in logs. And also no performance improvements...

I've tried to do "kill -3 `pidof java`". There are a lot of threads that's waiting for socket' incomming data:

at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
- locked <0x4a0fd808> (a com.mysql.jdbc.util.ReadAheadInputStream)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2329)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2774)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2763)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3299)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
- locked <0x4a0fe708> (a java.lang.Object)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1888)
- locked <0x4a0fe708> (a java.lang.Object)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
....

Thera re no such queires in mysqladmin processlist output. Query is not time expensive (it takes less than second in standard mysql client). There are also no messages in mysql error log.

Behaviour is too strange. After restarting application it became working for some time (~1-2 hours). I think that application closes all connections since "mysqladmin processlist" shows same number of processes.

Average server load: ~ 80.878 queries per second.

I will try to add --log-warnings to server startup script tomorrow.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Sam Atkinson
October 30, 2007 07:36AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Richard
October 30, 2007 03:43PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
mupparaju srinivas
January 03, 2008 05:38AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
alex teodorescu
January 30, 2009 07:05AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Mark Matthews
October 30, 2007 04:05PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Somebody .
February 08, 2008 04:35AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Andrew Jackson
February 09, 2008 04:26PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Somebody .
February 10, 2008 11:33AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Mark Matthews
February 10, 2008 02:07PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Dmitry Nezhevenko
February 11, 2008 07:33AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Mark Matthews
February 11, 2008 08:22AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Andrew Jackson
February 11, 2008 10:19AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Mark Matthews
February 11, 2008 02:54PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
zattarz za
February 13, 2008 03:47AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Somebody .
February 13, 2008 06:17AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
zattarz za
February 14, 2008 12:37PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
adam birr
December 18, 2008 05:23AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Dmitry Nezhevenko
February 11, 2008 01:45PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Gang Lau
February 11, 2008 11:41PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
JO Ganter
February 19, 2008 10:49AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Mark Matthews
February 19, 2008 10:51AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
JO Ganter
February 19, 2008 11:23AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Mark Matthews
February 19, 2008 11:25AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
JO Ganter
February 19, 2008 12:03PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
david s
February 20, 2008 06:05PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Jean-Nicolas Duval
June 02, 2008 07:29PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
ram babu
September 24, 2008 02:55AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Jonathan Baxter
October 31, 2008 07:56AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Ermicioi Andrei
November 27, 2008 01:56AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Ermicioi Andrei
November 30, 2008 03:15AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Simon Prinzleve
February 03, 2009 03:00PM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Kris Reid
April 08, 2009 12:46AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Josh Jacobs
July 06, 2009 10:45AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Dean Jiang
July 09, 2009 02:59AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Pankaj Tandon
August 24, 2009 10:30AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Kris Reid
August 24, 2009 11:33AM
Re: Connector/J "Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost."
Pankaj Tandon
August 24, 2009 12:43PM


Sorry, you can't reply to this topic. It has been closed.

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.