cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Running WContentVerify and getting Socket read interrupted

avillanueva
22-Sapphire I

Running WContentVerify and getting Socket read interrupted

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)

 

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

1 REPLY 1

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.

Top Tags