Skip to main content
avillanueva
23-Emerald I
23-Emerald I
August 22, 2023
Solved

Running WContentVerify and getting Socket read interrupted

  • August 22, 2023
  • 1 reply
  • 1357 views

I was able to run WContentVerify on a smaller vault but my large vault keeps throwing a java.sql.SQLRecoverableException. See below. I tried using a -batchSize=2000 but that did not help. Since the tool does not output anything until the end, how best can I complete the verification?  It appears to still run but these messages will occasionally display in the console and MS logs. Any suggestions for breaking this job up if its too large to complete?

 

(wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
Nested exception is: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
Nested exception is: wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
Nested exception is: java.sql.SQLRecoverableException: IO Error: Socket read interrupted
 at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1092)
 at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3456)
 at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:742)
 at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:698)
 at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:412)
 at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:209)
 at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82)
 at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:880)
 at wt.pom.PagingHelper.query(PagingHelper.java:173)
 at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1111)
 at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1005)
 at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1955)
 at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1465)
 at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1351)
 at wt.fv.tools.WCV_Util._server_executePagingQuery(WCV_Util.java:292)
 at wt.fv.tools.WCV_Util._server_executePagingQuery(WCV_Util.java:273)
 at wt.fv.tools.WCV_BasicMasterFolderCheck._server_getPerFolderStatsForFvItemsOnMasterServer(WCV_BasicMasterFolderCheck.java:526)
 at wt.fv.tools.WCV_BasicMasterFolderCheck._server_getPerFolderStats(WCV_BasicMasterFolderCheck.java:500)
 at jdk.internal.reflect.GeneratedMethodAccessor2696.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at wt.method.MethodResultWriter.writeExternal(MethodResultWriter.java:165)
 at wt.method.MethodResult.writeExternal(MethodResult.java:226)
 at java.base/java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1447)
 at java.base/java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1421)
 at java.base/java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1169)
 at java.base/java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:345)
 at java.rmi/sun.rmi.server.UnicastRef.marshalValue(UnicastRef.java:293)
 at java.rmi/sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:369)
 at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:200)
 at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:197)
 at java.base/java.security.AccessController.doPrivileged(Native Method)
 at java.rmi/sun.rmi.transport.Transport.serviceCall(Transport.java:196)
 at java.rmi/sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:562)
 at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:796)
 at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:677)
 at java.base/java.security.AccessController.doPrivileged(Native Method)
 at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:676)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.io.InterruptedIOException: Socket read interrupted
 at oracle.net.nt.TimeoutSocketChannel.handleInterrupt(TimeoutSocketChannel.java:258)
 at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:180)
 at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:555)
 at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:258)
 at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:190)
 at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:132)
 at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:105)
 at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:91)
 at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:784)
 at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:449)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:410)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
 at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1079)

 

Best answer by avillanueva

I was able to run a single folder of my large vault. This folder had 595712 files in it. 19 files missing from 19 years  and 4 upgrades ago. Not bad. Hopefully, I can repeat this successfully for the remainder of the folders.

1 reply

avillanueva
23-Emerald I
avillanueva23-Emerald IAuthorAnswer
23-Emerald I
August 22, 2023

I was able to run a single folder of my large vault. This folder had 595712 files in it. 19 files missing from 19 years  and 4 upgrades ago. Not bad. Hopefully, I can repeat this successfully for the remainder of the folders.