Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

communication errors

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
...................

0 votes



One answer

Permanent link
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

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jan 15 '09, 11:16 a.m.

Question was seen: 11,252 times

Last updated: Jan 15 '09, 11:16 a.m.

Confirmation Cancel Confirm