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

Mehak22 — Thu, 21 Apr 2022 13:31:23 GMT

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 .

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

techin — Wed, 20 Apr 2022 15:33:35 GMT

@Mehak22 ,

Can you specify which HPE product you are referring to?

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

jjsim — Thu, 21 Apr 2022 17:30:33 GMT

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

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

jjsim — Thu, 21 Apr 2022 17:41:29 GMT

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.

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

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

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

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

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