Re: EOFException in Connector/j
Posted by: Kris Younger
Date: January 05, 2005 03:16PM

OKAY more data:

I isolated the log files after restarting mysqld with query logging on. In the two snips
below, I was careful to match the lines in the two log files to the same app action.

I selected on of my "Accounts" to edit (a specific app notion) on one page and it came up in a record editor on another page. (pretty simple).

from my app server's "server.log":

[snip]
[#|2005-01-05T16:08:03.164-0500|INFO|sun-appserver-pe8.0.0_01|javax.enterprise.s
ystem.container.web|_ThreadID=13;|WebModule[/samson]Accounts.java - selected acc
ount number 5 rowIndex: 0|#]

[#|2005-01-05T16:08:03.188-0500|INFO|sun-appserver-pe8.0.0_01|javax.enterprise.s
ystem.container.web|_ThreadID=13;|WebModule[/samson]AccountsEdit.java - selectin
g account number 5|#]

[#|2005-01-05T16:08:03.195-0500|WARNING|sun-appserver-pe8.0.0_01|javax.enterpris
e.system.stream.err|_ThreadID=13;|
JdbcRowSetXImpl (setTransactionIsolation): Communication link failure: java.io.E
OFException, underlying cause: null

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1388)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1532)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1923)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1218)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2233)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2193)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2174)
at com.mysql.jdbc.Connection.setTransactionIsolation(Connection.java:901
)
at com.sun.gjc.spi.ConnectionHolder.setTransactionIsolation(ConnectionHo
lder.java:551)
at com.sun.sql.rowset.JdbcRowSetXImpl.connect(JdbcRowSetXImpl.java:427)
at com.sun.sql.rowset.JdbcRowSetXImpl.prepare(JdbcRowSetXImpl.java:532)
at com.sun.sql.rowset.JdbcRowSetXImpl.execute(JdbcRowSetXImpl.java:349)
at samson.AccountsEdit.<init>(AccountsEdit.java:359)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at java.beans.Beans.instantiate(Beans.java:204)
at java.beans.Beans.instantiate(Beans.java:48)
at com.sun.faces.config.ManagedBeanFactory.newInstance(ManagedBeanFactor
y.java:203)
at com.sun.faces.application.ApplicationAssociate.createAndMaybeStoreMan
agedBeans(ApplicationAssociate.java:256)
at com.sun.faces.el.VariableResolverImpl.resolveVariable(VariableResolve
rImpl.java:78)
at com.sun.faces.el.impl.NamedValue.evaluate(NamedValue.java:125)
at com.sun.faces.el.impl.ComplexValue.evaluate(ComplexValue.java:146)
at com.sun.faces.el.impl.ExpressionEvaluatorImpl.evaluate(ExpressionEval
uatorImpl.java:243)
at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:173)
at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:154)
at com.sun.faces.application.ApplicationImpl.createComponent(Application
Impl.java:386)
at javax.faces.webapp.UIComponentTag.createComponent(UIComponentTag.java
:999)
at javax.faces.webapp.UIComponentTag.createChild(UIComponentTag.java:102
6)
at javax.faces.webapp.UIComponentTag.findComponent(UIComponentTag.java:7
39)
at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:429)
at com.sun.faces.taglib.html_basic.FormTag.doStartTag(FormTag.java:345)
at org.apache.jsp.AccountsEdit_jsp._jspx_meth_h_form_0(AccountsEdit_jsp.
java:159)
at org.apache.jsp.AccountsEdit_jsp._jspx_meth_f_view_0(AccountsEdit_jsp.
java:133)
at org.apache.jsp.AccountsEdit_jsp._jspService(AccountsEdit_jsp.java:91)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:102)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:861)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
63)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:210)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:861)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:246
)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:2
68)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.
java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:236)
at org.apache.catalina.core.ApplicationFilterChain.access$000(Applicatio
nFilterChain.java:55)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilt
erChain.java:145)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:141)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:718)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
tionDispatcher.java:478)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:413)
at org.apache.catalina.core.ApplicationDispatcher.access$000(Application
Dispatcher.java:77)
at org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(
ApplicationDispatcher.java:92)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:319)
at com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImp
l.java:322)
at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.
java:130)
at com.sun.jsfcl.app.ViewHandlerImpl.renderView(ViewHandlerImpl.java:169
)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePha
se.java:87)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:246
)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:2
68)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.
java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:236)
at org.apache.catalina.core.ApplicationFilterChain.access$000(Applicatio
nFilterChain.java:55)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilt
erChain.java:145)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:141)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:220)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:109)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:522)
at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
ContextValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:168)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:109)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:522)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:144)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:109)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:133)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
539)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:107)
at com.sun.enterprise.webservice.EjbWebServiceValve.invoke(EjbWebService
Valve.java:134)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext|#]

[#|2005-01-05T16:08:03.195-0500|WARNING|sun-appserver-pe8.0.0_01|javax.enterpris
e.system.stream.err|_ThreadID=13;|.java:107)
at com.sun.enterprise.security.web.SingleSignOn.invoke(SingleSignOn.java
:254)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:107)
at com.sun.enterprise.web.VirtualServerValve.invoke(VirtualServerValve.j
ava:209)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:107)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:522)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:114)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:109)
at com.sun.enterprise.web.VirtualServerMappingValve.invoke(VirtualServer
MappingValve.java:166)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:107)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:522)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:936)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16
5)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:683)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:604)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:542)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:647)
at java.lang.Thread.run(Thread.java:534)


** END NESTED EXCEPTION **

|#]

[end snip]

And from mysqld's log file:

[snip]
050105 16:08:03 7 Connect root@localhost.localdomain on samson2
7 Init DB samson2
7 Query SHOW VARIABLES LIKE 'tx_isolation'
7 Query SET character_set_results = NULL
7 Query select round('inf'), round('-inf'), round('nan')
7 Query SHOW VARIABLES
7 Query SHOW COLLATION
7 Query SET autocommit=1
7 Query SET autocommit=0
7 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
7 Query USE `samson2`
7 Query SET autocommit=0
7 Query SELECT * FROM Accounts
7 Query SELECT * FROM Accounts
8 Connect root@localhost.localdomain on samson2
8 Init DB samson2
8 Query SHOW VARIABLES LIKE 'tx_isolation'
8 Query SET character_set_results = NULL
8 Query select round('inf'), round('-inf'), round('nan')
8 Query SHOW VARIABLES
8 Query SHOW COLLATION
8 Query SET autocommit=1
8 Query SET autocommit=0
8 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
8 Query USE `samson2`
8 Query SET autocommit=0
8 Query SELECT ALL Accounts.acId, Accounts.acDel, Accounts.acName, Accounts.acEmail, Accounts.acPw, Accounts.acCreate, Accounts.acLastEventId, Accounts.acCheckContact, Accounts.acCheckAddress, Accounts.acCheckCity, Accounts.acCheckState, Accounts.acCheckZip FROM Accounts WHERE Accounts.acId=5
8 Query SHOW KEYS FROM `Accounts` FROM `samson2`
8 Query SHOW VARIABLES LIKE 'tx_isolation'
7 Query SHOW VARIABLES LIKE 'tx_isolation'

[end snip]

Interesting, but I'm ignorant as to what it should be.....

Options: ReplyQuote


Subject
Written By
Posted
January 03, 2005 01:31PM
Re: EOFException in Connector/j
January 05, 2005 03:16PM


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.