[opencms-dev] java.io.EOFException in OpenCms 8.0.4

[Mathias Lin]

I migrated an OpenCms site from v7.0.5 to v8.0.4, using the same mysql
server (5.1), and db settings are similar. (Both on Mac OS X, and on
Debian Linux server).

On v8, I occassionally get an error in the workplace (in the content
pane), but really just occassionally, and after hitting the 'refresh'
button in the workplace toolbar once or twice, everything works fine
again.

Below is the error log, and I also found two similar threads in the
mailing list, but no resolution to it. This error does not occur in
v7, which uses the same mysql server.

References to similar threads:
http://old.nabble.com/Critical-error-during-OpenCms-initialization%3A-td33133475.html#a33133972
http://old.nabble.com/Re-initialization-error-to33145593.html#a33145593


Error
	
Error An SQL error occurred when executing the following query:
com.mysql.jdbc.PreparedStatement at 3884b2bb: statement has been closed,
no further internal information available.
Reason: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException
MESSAGE: Can not read response from server. Expected to read 4 bytes,
read 0 bytes before connection was unexpectedly lost.

STACKTRACE:

java.io.EOFException: Can not read response from server. Expected to
read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:2147)
at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:7310)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:6922)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:4685)
at org.opencms.file.CmsObject.readResource(CmsObject.java:2949)
at org.opencms.file.CmsObject.readResource(CmsObject.java:2916)
at org.opencms.file.CmsObject.readDefaultFile(CmsObject.java:2244)
at org.opencms.main.OpenCmsCore.initResource(OpenCmsCore.java:1396)
at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1595)
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:213)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.sysvision.opencms.spring.RewriteFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:383)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:166)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:288)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:680)


** END NESTED EXCEPTION **



Last packet sent to the server was 52 ms ago.