アーティクル - CS329590
Windchill PDMLink のメソッド サーバー ログに「java.sql.SQLRecoverableException: IO エラー: ソケット読み取りが中断されました」と表示される
修正日: 31-Oct-2024
適用対象
- Windchill PDMLink 11.0 to 11.1
説明
- チェックイン/チェックアウト/タスクの再割り当てなどのリクエストでエラーが発生する: 「java.io.InterruptedIOException: ソケット読み取りが中断されました」
- バックグラウンドメソッドサーバーログは以下のエラーを報告します
Nested exception is: wt.pom.ConnectionLostException: A database connection failure has occurred and the operation has been aborted. Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "XXXXXX" Nested exception is: java.sql.SQLRecoverableException: IO Error: Socket read interrupted at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:950) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:950) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1099) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3640) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1384) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3687) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:582) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:540) at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282) at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234) at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82) at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:760) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1076) at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1977) at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1929) at java.lang.reflect.Method.invoke(Method.java:498) at wt.queue.QueueEntry.execute(QueueEntry.java:231) at wt.queue.ProcessingQueue.execEntry(ProcessingQueue.java:312) at wt.queue.ProcessingQueue.execEntries(ProcessingQueue.java:898) at wt.queue.PollingQueueThread.run(PollingQueueThread.java:99) Caused by: java.io.InterruptedIOException: Socket read interrupted at oracle.net.nt.TimeoutSocketChannel.handleInterrupt(TimeoutSocketChannel.java:262) at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:184) at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:544) at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:234) at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:174) at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:122) at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:100) at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:86) at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:762) at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:427) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:394) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:610) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:253) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:86) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:928) ... 93 more
- キューが停止された場合は警告が表示されます:
2022-04-06 11:17:15,558 WARN [QueueCheckerThread-37] wt.jmx.notif.queue - Time=2022-04-06 11:17:15.556 -0400, Name=QueueNotifier, SourceObjectName=com.ptc:wt.subsystem=Monitors,wt.monitorType=Queues,Name=WfPropagationQueue, class=class javax.management.Notification, type=wt.queue.QueueWatcherMBean.queueStopped, userData=WfPropagationQueue, message= Queue WfPropagationQueue has been stopped , JVM Name=26503@<hostname>, Queue Info=[AveEntryExecTimeSeconds=0.0,EntryExecutionTimeThresholdSec=70,ExecutionThreadLoggerLevel=,ExecutionThreadLoggerName=,LoggerLevel=,LoggerName=wt.queue.QueueWatcherImpl.WfPropagationQueue,MaxEntryExecTimeSeconds=0.0,MinEntryExecTimeSeconds=0.0,MinMinutesBetweenNotifications=60,Name=WfPropagationQueue,TotalEntries=25,TotalEntriesExecuted=0,TotalExecutionTime=0,TotalThreshold=100,WaitingReadyEntries=0,WaitingReadyThreshold=15]
最新バージョンはこちらを参照ください CS329590