Article - CS188911
MethodServer.log reads "java.sql.SQLRecoverableException: Connection reset" in Windchill
Modified: 24-Mar-2017
Applies To
- Windchill PDMLink 10.0 to 11.0
Description
- MethodServer.log reads:
wt.queue.ProcessingQueue.<Queue> Administrator - Unexpected error
java.sql.SQLRecoverableException: Connexion interrompue
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3921)
at wt.log4j.jmx.ConnectionWrapper.rollback(ConnectionWrapper.java:91)
at wt.queue.WtQueueThread$AttainQueueLockRunner.run(WtQueueThread.java:575)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Followed by:
ERROR [wt.log4j.jmx.AsyncJDBCAppender.worker] wt.log4j.jmx.AsyncJDBCAppender - RawMethodContextStats: failed to insert log data
java.sql.BatchUpdateException: Erreur d'E/S: Socket read timed out
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
at wt.log4j.jmx.AsyncJDBCAppender.executeBatch(AsyncJDBCAppender.java:1205)
at wt.log4j.jmx.AsyncJDBCAppender.flushSynchronously(AsyncJDBCAppender.java:1182)
at wt.log4j.jmx.AsyncJDBCAppender.addToBatch(AsyncJDBCAppender.java:1732)
at wt.log4j.jmx.AsyncJDBCAppender$LogTask.run(AsyncJDBCAppender.java:838)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
java.sql.SQLRecoverableException: Connexion interrompue
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3921)
at wt.log4j.jmx.ConnectionWrapper.rollback(ConnectionWrapper.java:91)
at wt.queue.WtQueueThread$AttainQueueLockRunner.run(WtQueueThread.java:575)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Followed by:
ERROR [wt.log4j.jmx.AsyncJDBCAppender.worker] wt.log4j.jmx.AsyncJDBCAppender - RawMethodContextStats: failed to insert log data
java.sql.BatchUpdateException: Erreur d'E/S: Socket read timed out
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
at wt.log4j.jmx.AsyncJDBCAppender.executeBatch(AsyncJDBCAppender.java:1205)
at wt.log4j.jmx.AsyncJDBCAppender.flushSynchronously(AsyncJDBCAppender.java:1182)
at wt.log4j.jmx.AsyncJDBCAppender.addToBatch(AsyncJDBCAppender.java:1732)
at wt.log4j.jmx.AsyncJDBCAppender$LogTask.run(AsyncJDBCAppender.java:838)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
- Oracle server hosted on virtual machine
- Issue does always occur at the very same moment of night
This is a printer-friendly version of Article 188911 and may be out of date. For the latest version click CS188911