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