Progress database gets halted by some queries - Forum - OpenEdge Development - Progress Community

Progress database gets halted by some queries

 Forum

Progress database gets halted by some queries

This question is not answered

Hi,

Using the following database/driver:


Database Version = 11.7.4
Driver Name = OpenEdge
Driver Version = 5.1.4.000130 (F000322.U000140)

We are able to succesfully make queries to the database via a java component, however, when performing longer queries problems occur. The queries no longer return anything and the connection seems stuck.

Here is the spy log following a single thread:


spy(Worker32-800)(2019/01/30 16:42:03.845)>> sql = <LONG QUERY>
spy(Worker32-800)(2019/01/30 16:42:03.872)>> OK (PreparedStatement[17])

spy(Worker32-800)(2019/01/30 16:42:03.872)>> PreparedStatement[17].executeQuery()
spy(Worker32-800)(2019/01/30 16:42:03.896)>> OK (ResultSet[17])

spy(Worker32-800)(2019/01/30 16:42:03.896)>> ResultSet[17].getMetaData()
spy(Worker32-800)(2019/01/30 16:42:03.896)>> OK (ResultSetMetaData[17])

spy(Worker32-800)(2019/01/30 16:42:03.896)>> ResultSetMetaData[17].getColumnCount()
spy(Worker32-800)(2019/01/30 16:42:03.896)>> OK (35)

spy(Worker32-800)(2019/01/30 16:42:03.896)>> ResultSet[17].next()

....
<MANY SUCCESFUL QUERIES FROM OTHER THREADS>
...


spy(Worker32-800)(2019/01/31 09:15:20.555)>> java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Query aborted on user request (7495) ErrorCode=-30001 SQLState=HY000
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Query aborted on user request (7495)
at com.ddtek.jdbc.openedge.client.dde.ah(Unknown Source)
at com.ddtek.jdbc.openedge.client.dde.ag(Unknown Source)
at com.ddtek.jdbc.openedge.dde.a(Unknown Source)
at com.ddtek.jdbc.openedgebase.ddcq.aa(Unknown Source)
at com.ddtek.jdbc.openedgebase.dddm.next(Unknown Source)
at com.ddtek.jdbcspyopenedge.SpyResultSet.next(Unknown Source)
...
spy(Worker32-800)(2019/01/31 09:15:20.555)>> PreparedStatement[17].close()
spy(Worker32-800)(2019/01/31 09:15:21.160)>> java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Software caused connection abort: recv failed. ErrorCode=0 SQLState=HY000
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Software caused connection abort: recv failed.

Has anyone had this kind of problem? I wonder if it is because of too many queries..?

Thanks,
Artturi

All Replies
  • > On Feb 1, 2019, at 9:48 AM, artturisuominen wrote:

    >

    > JDBC Driver]Software caused connection abort: recv failed. ErrorCode=0 SQLState=HY000

    > java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Software caused connection abort: recv failed.

    this looks like the SQL server process has crashed. look at the database log file.