Dash DB throws connection opening error: SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP".

[Kommineni Devaraj]

Hi All,

We are running node js application with ibm_db. We have background process which queries/inserts/deletes/updates data very frequently. 

The node cron job runs every minute and try to process 500 records of data every time. We make sure that cron job don't run parallel by having flag.

We get following error after the the background job runs successfully for about 30 minutes. Some times the system is auto recovered and at time the application crashes. 

[IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".  

Location where the error was detected: "169.55.227.101".  Communication function detecting the error: "send".  Protocol specific error code(s): "32", "*", "0".  SQLSTATE=08001

[IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".  

Location where the error was detected: "169.55.227.101".  Communication function detecting the error: "selectForConnectTimeout".  Protocol specific error code(s): "115", "*", "*".  SQLSTATE=08001

Sometimes we get the following error and the application crashes.

Assertion failed: (ret != SQL_INVALID_HANDLE), function GetColumnValue, file ../src/odbc.cpp, line 620.

Abort trap: 6

Regards

Devaraj

[bimaljha]

Please use ibm_db.Pool() to fix this issue. Please replace following line in your code

var dashDB = require("ibm_db")

with

var ibmdb = require("ibm_db");
var dashDB = new ibmdb.Pool();

Thanks and Regards,
Bimal Jha