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