NonStop Servers
1752568 Members
5368 Online
108788 Solutions
New Discussion юеВ

For SQL/MX and SQL/MP databases ,getting socket related error in multithreaded environment

 
Mehak22
Occasional Visitor

For SQL/MX and SQL/MP databases ,getting socket related error in multithreaded environment

For SQL/MX and SQL/MP databases ,getting socket related error in multithreaded environment.

com.tandem.t4jdbc.SQLMXException: error while writing to socket
at com.tandem.t4jdbc.SQLMXMessages.createSQLException(SQLMXMessages.java:330) ~[t4sqlmx-2018.03.20.jar:?]
at com.tandem.t4jdbc.SQLMXMessages.createSQLException(SQLMXMessages.java:271) ~[t4sqlmx-2018.03.20.jar:?]
at com.tandem.t4jdbc.InputOutput.send_nblk(InputOutput.java:626) ~[t4sqlmx-2018.03.20.jar:?]
at com.tandem.t4jdbc.InputOutput.TCPIPDoWrite(InputOutput.java:564) ~[t4sqlmx-2018.03.20.jar:?]
at com.tandem.t4jdbc.InputOutput.doIO(InputOutput.java:379) ~[t4sqlmx-2018.03.20.jar:?]
at com.tandem.t4jdbc.T4Connection.getReadBuffer(T4Connection.java:165) ~[t4sqlmx-2018.03.20.jar:?]
at com.tandem.t4jdbc.T4ResultSet.getReadBuffer(T4ResultSet.java:178) ~[t4sqlmx-2018.03.20.jar:?]
at com.tandem.t4jdbc.T4ResultSet.Fetch(T4ResultSet.java:82) ~[t4sqlmx-2018.03.20.jar:?]
at com.tandem.t4jdbc.InterfaceResultSet.fetch(InterfaceResultSet.java:1172) ~[t4sqlmx-2018.03.20.jar:?]
at com.tandem.t4jdbc.SQLMXResultSet.next(SQLMXResultSet.java:3467) ~[t4sqlmx-2018.03.20.jar:?]
at com.dataguise.discoverAgent.TableScanThread.deepSearch(TableScanThread.java:1157) ~[classes/:?]
at com.dataguise.discoverAgent.TableScanThread.doDiscoveryInTable(TableScanThread.java:498) [classes/:?]
at com.dataguise.discoverAgent.TableScanThread.doWork(TableScanThread.java:208) [classes/:?]
at com.dataguise.util.threads.allocator.AbstractThread.run(AbstractThread.java:18) [common-1.4.0.jar:?]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]
Caused by: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method) ~[?:1.8.0_202]
at java.net.SocketOutputStream.socketWrite(Unknown Source) ~[?:1.8.0_202]
at java.net.SocketOutputStream.write(Unknown Source) ~[?:1.8.0_202]
at com.tandem.t4jdbc.InputOutput.send_nblk(InputOutput.java:623) ~[t4sqlmx-2018.03.20.jar:?]
... 12 more

If 'connectionTimeout' property of driver is increased ,then it works fine .Any help or suggestions for this error is appreciated .

 

3 REPLIES 3
techin
Super Advisor

Re: For SQL/MX and SQL/MP databases ,getting socket related error in multithreaded environ

@Mehak22 ,

Can you specify which HPE product you are referring to?

jjsim
HPE Pro

Re: For SQL/MX and SQL/MP databases ,getting socket related error in multithreaded environ

SQL/MX and MP are the NonStop relational databases.  I believe the person experiencing the errors should contact the GNSC for support.

jjsim
HPE Pro

Re: For SQL/MX and SQL/MP databases ,getting socket related error in multithreaded environ

I believe you should contact the GNSC for support on this.  The USA number is (800) 255-5010  They will probably need you to supply some information and perhaps the explain plan.