It's all about the answers!

Ask a question

communication errors


Yanzhuang Li (31134126) | asked Jan 15 '09, 11:16 a.m.
RTC 101 Jazz.log files show a number of the following errors. Any comment on how to resolve the issue? Thanks.

02:07:52,258 WARN sqlExceptionLogger - SQL: select UUID, MIME_TYPE,

FILE_SIZE, length(CONTENT_BYTES), DELTA_PARENT, OWNER_ITEM_UUID, COMPRESSION_METHOD, MODIFIED, LINE_DELIMITER, CONTENT_HASH_CODE,

CONTENT_BYTES, CHARACTER_ENCODING from REPOSITORY.CONTENT_STORAGE where UUID in (?)
Parameter 0: 1
Parameter 1: _XcSXEuHoEd2YaYwAoOxH-w
SQL

Exception #1
SQL Message: A communication error has been detected. Communication protocol being used:

TCP/IP.
Communication API being used: SOCKETS. Location where the error was detected: T4Agent.sendRequest().
Communication function detecting the error: OutputStream.flush(). Protocol specific error codes Connection reset by peer: socket write

error, *, 0. Message: Connection reset by peer: socket write error
SQL State: null
Error Code: -4499

com.ibm.db2.jcc.c.DisconnectException: A communication error has been detected. Communication protocol

being used: TCP/IP.
Communication API being used: SOCKETS. Location where the error was detected: T4Agent.sendRequest().
Communication function detecting the error: OutputStream.flush(). Protocol specific error codes Connection reset by peer: socket write

error, *, 0. Message: Connection reset by peer: socket write error
at com.ibm.db2.jcc.b.a.a(a.java:358)
at com.ibm.db2.jcc.b.a.z(a.java:327)
at com.ibm.db2.jcc.b.a.m(a.java:285)
at com.ibm.db2.jcc.c.p.c(p.java:275)
at com.ibm.db2.jcc.c.lh.gb(lh.java:2040)
at com.ibm.db2.jcc.c.lh.setObject(lh.java:1212)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.setObject

(PreparedStatementStatWrapper.java:155)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.setObject

(PreparedStatementErrLogWrapper.java:284)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.setObject

(PreparedStatementLeakWrapper.java:150)
at com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocks.prepareNextBlock(JDBC3QueryByBlocks.java:252)
at com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocks.prepareFirstBlock(JDBC3QueryByBlocks.java:197)
at com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocks.<init>(JDBC3QueryByBlocks.java:144)
at com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocksFactory.exec(JDBC3QueryByBlocks.java:940)
at com.ibm.team.repository.service.internal.dataaccess.QueryByBlocksFactory.exec(QueryByBlocksFactory.java:38)
at com.ibm.team.repository.service.internal.db.filestorage.ContentStorage.visitContentById(ContentStorage.java:400)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.fetchContent(RdbRepositoryDataMediator.java:1060)
at com.ibm.team.repository.service.internal.ContentService$7.run(ContentService.java:1450)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInReadUncommittedTransaction(RepositoryDatabase.java:252)
at com.ibm.team.repository.service.internal.TransactionService.runReadUncommittedTransaction(TransactionService.java:79)
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke

(ExportProxyServiceRecord.java:55)
at $Proxy34.runReadUncommittedTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.ContentService.getWithReceiver(ContentService.java:1461)
at sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke

(ExportProxyServiceRecord.java:55)
at $Proxy40.getWithReceiver(Unknown Source)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doGet(AbstractTeamServerServlet.java:383)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1436)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:115)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:810)
Caused by:
java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:105)
at java.net.SocketOutputStream.write(SocketOutputStream.java:149)
at com.ibm.db2.jcc.b.gb.b(gb.java:1529)
at com.ibm.db2.jcc.b.gb.a(gb.java:1478)
at com.ibm.db2.jcc.b.a.z(a.java:321)
... 60 more



02:07:52,298 ERROR ory.service.internal.dataaccess.JDBC3QueryByBlocks - CRJAZ0399I QueryByBlocks

first sql statement: select UUID, MIME_TYPE, FILE_SIZE, length(CONTENT_BYTES), DELTA_PARENT, OWNER_ITEM_UUID, COMPRESSION_METHOD,

MODIFIED, LINE_DELIMITER, CONTENT_HASH_CODE, CONTENT_BYTES, CHARACTER_ENCODING from REPOSITORY.CONTENT_STORAGE where UUID in (?)

A communication error has been detected. Communication protocol being used: TCP/IP.
Communication API being used: SOCKETS. Location where the error was detected: T4Agent.sendRequest().
Communication function detecting the error: OutputStream.flush(). Protocol specific error codes Connection reset by peer: socket write

error, *, 0. Message: Connection reset by peer: socket write error
com.ibm.db2.jcc.c.DisconnectException: A communication error has been detected. Communication protocol

being used: TCP/IP.
Communication API being used: SOCKETS. Location where the error was detected: T4Agent.sendRequest().
Communication function detecting the error: OutputStream.flush(). Protocol specific error codes Connection reset by peer: socket write

error, *, 0. Message: Connection reset by peer: socket write error
at com.ibm.db2.jcc.b.a.a(a.java:358)
at com.ibm.db2.jcc.b.a.z(a.java:327)
at com.ibm.db2.jcc.b.a.m(a.java:285)
..................




02:07:52,318 ERROR ository.service.internal.RdbRepositoryDataMediator - CRJAZ1033I Failed to fetch

content _XcSXEuHoEd2YaYwAoOxH-w.
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0399I QueryByBlocks first sql statement: select UUID, MIME_TYPE,

FILE_SIZE, length(CONTENT_BYTES), DELTA_PARENT, OWNER_ITEM_UUID, COMPRESSION_METHOD, MODIFIED, LINE_DELIMITER, CONTENT_HASH_CODE,

CONTENT_BYTES, CHARACTER_ENCODING from REPOSITORY.CONTENT_STORAGE where UUID in (?) A communication

error has been detected. Communication protocol being used: TCP/IP.
Communication API being used: SOCKETS. Location where the error was detected: T4Agent.sendRequest().
Communication function detecting the error: OutputStream.flush(). Protocol specific error codes Connection reset by peer: socket write

error, *, 0. Message: Connection reset by peer: socket write error
at com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocks.prepareFirstBlock(JDBC3QueryByBlocks.java:204)
at com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocks.<init>(JDBC3QueryByBlocks.java:144)
at com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocksFactory.exec(JDBC3QueryByBlocks.java:940)
at com.ibm.team.repository.service.internal.dataaccess.QueryByBlocksFactory.exec(QueryByBlocksFactory.java:38)
at com.ibm.team.repository.service.internal.db.filestorage.ContentStorage.visitContentById(ContentStorage.java:400)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.fetchContent(RdbRepositoryDataMediator.java:1060)
...................


02:07:52,338 WARN sqlExceptionLogger - Connection does not exist
SQL

Exception #1
SQL Message: Invalid operation: Connection is closed.
SQL State: 08003
Error Code: -99999

com.ibm.db2.jcc.c.SqlException: Invalid operation: Connection is closed.
at com.ibm.db2.jcc.c.bb.Ob(bb.java:3415)
at com.ibm.db2.jcc.c.bb.getAutoCommit(bb.java:686)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.ConnectionStatWrapper.getAutoCommit

(ConnectionStatWrapper.java:167)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.ConnectionErrLogWrapper.getAutoCommit

(ConnectionErrLogWrapper.java:135)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.ConnectionLeakWrapper.getAutoCommit
...................

One answer



permanent link
Matt Lavin (2.7k2) | answered Jan 15 '09, 11:48 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
That error makes it seem like you have a bad network connection between
your DB server and your jazz server. If the servers are on the same
machine, then I would imagine seeing something like this if the DB is
crashing.

-
Matt Lavin
Jazz Server Team


On Thu, 2009-01-15 at 16:17 +0000, yanli wrote:
RTC 101 Jazz.log files show a number of the following errors. Any
comment on how to resolve the issue? Thanks.

02:07:52,258 WARN
sqlExceptionLogger - SQL: select
UUID, MIME_TYPE,

FILE_SIZE, length(CONTENT_BYTES), DELTA_PARENT, OWNER_ITEM_UUID,
COMPRESSION_METHOD, MODIFIED, LINE_DELIMITER, CONTENT_HASH_CODE,

CONTENT_BYTES, CHARACTER_ENCODING from REPOSITORY.CONTENT_STORAGE
where UUID in (?)
Parameter 0: 1
Parameter 1: _XcSXEuHoEd2YaYwAoOxH-w
SQL

Exception #1
SQL Message: A communication error
has been detected. Communication protocol being used:

TCP/IP.
Communication API being used: SOCKETS. Location where the error was
detected: T4Agent.sendRequest().
Communication function detecting the error: OutputStream.flush().
Protocol specific error codes Connection reset by peer: socket write


error, *, 0. Message: Connection reset by peer: socket write error
SQL State: null
Error Code: -4499

com.ibm.db2.jcc.c.DisconnectException:
A communication error has been
detected. Communication protocol

being used: TCP/IP.
Communication API being used: SOCKETS. Location where the error was
detected: T4Agent.sendRequest().
Communication function detecting the error: OutputStream.flush().
Protocol specific error codes Connection reset by peer: socket write


error, *, 0. Message: Connection reset by peer: socket write error
at com.ibm.db2.jcc.b.a.a(a.java:358)
at com.ibm.db2.jcc.b.a.z(a.java:327)
at com.ibm.db2.jcc.b.a.m(a.java:285)
at com.ibm.db2.jcc.c.p.c(p.java:275)
at com.ibm.db2.jcc.c.lh.gb(lh.java:2040)
at com.ibm.db2.jcc.c.lh.setObject(lh.java:1212)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.setObject

(PreparedStatementStatWrapper.java:155)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.setObject

(PreparedStatementErrLogWrapper.java:284)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.setObject

(PreparedStatementLeakWrapper.java:150)
at
com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocks.prepareNextBlock(JDBC3QueryByBlocks.java:252)
at
com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocks.prepareFirstBlock(JDBC3QueryByBlocks.java:197)
at
com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocks.<init>(JDBC3QueryByBlocks.java:144)
at
com.ibm.team.repository.service.internal.dataaccess.JDBC3QueryByBlocksFactory.exec(JDBC3QueryByBlocks.java:940)
at
com.ibm.team.repository.service.internal.dataaccess.QueryByBlocksFactory.exec(QueryByBlocksFactory.java:38)
at
com.ibm.team.repository.service.internal.db.filestorage.ContentStorage.visitContentById(ContentStorage.java:400)
at
com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.fetchContent(RdbRepositoryDataMediator.java:1060)
at
com.ibm.team.repository.service.internal.ContentService$7.run(ContentService.java:1450)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInReadUncommittedTransaction(RepositoryDatabase.java:252)
at
com.ibm.team.repository.service.internal.TransactionService.runReadUncommittedTransaction(TransactionService.java:79)
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke

(ExportProxyServiceRecord.java:55)
at $Proxy34.runReadUncommittedTransaction(Unknown Source)
at
com.ibm.team.repository.service.internal.ContentService.getWithReceiver(ContentService.java:1461)
at sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke

(ExportProxyServiceRecord.java:55)
at $Proxy40.getWithReceiver(Unknown Source)
at
com.ibm.team.repository.servlet.AbstractTeamServerServlet.doGet(AbstractTeamServerServlet.java:383)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at
com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1436)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at
org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:115)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:810)
Caused by:
java.net.SocketException: Connection reset by peer: socket write
error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:105)
at java.net.SocketOutputStream.write(SocketOutputStream.java:149)
at com.ibm.db2.jcc.b.gb.b(gb.java:1529)
at com.ibm.db2.jcc.b.gb.a(gb.java:1478)
at com.ibm.db2.jcc.b.a.z(a.java:321)
... 60 more

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.