We are facing issue with one of the application server where for every 20 minutes the connections are getting disconnected and reconnecting and we are seeing below dumps for every 20 minute only from one app server rest other application servers are working fine.
Dumps:
DBIF_RSQL_SQL_ERROR and DBIF_RTAB_SQL_ERROR
Workprocess log
B Tue Nov 26 06:23:18 2024
B dblink[db_reconnect]: { new_reconnect_message=1
C DbSlPing(con=0) -> c1=0, orc=1403, 0=DBSL_ERR_OK
B dbcon[db_con_reconnect]: { reco_trials=3, reco_sleep_time=5
B 00: name=R/3, con_id=000000000, state=INACTIVE , tx=NO , bc=NO , hc=NO , perm=YES, reco=NO , refused_cnt =000000000, isol=DEF,
B info=NO , timeout=000, con_max=255, con_opt=255, occ=NO , prog=
B dbcon[db_con_reconnect]: } rc=0
B ***LOG BV4=> reconnect state is set for the work process [dblink 1999]
B ***LOG BYY=> work process left reconnect status [dblink 2000]
B dblink[db_reconnect]: } rc=0
M ThHdlReconnect: reconnect o.k.
B
B Tue Nov 26 06:41:18 2024
B dblink[db_reconnect]: { new_reconnect_message=1
C DbSlPing(con=0) -> c1=0, orc=1403, 0=DBSL_ERR_OK
B dbcon[db_con_reconnect]: { reco_trials=3, reco_sleep_time=5
B 00: name=R/3, con_id=000000000, state=INACTIVE , tx=NO , bc=NO , hc=NO , perm=YES, reco=NO , refused_cnt =000000000, isol=DEF,
B info=NO , timeout=000, con_max=255, con_opt=255, occ=NO , prog=
B dbcon[db_con_reconnect]: } rc=0
B ***LOG BV4=> reconnect state is set for the work process [dblink 1999]
B ***LOG BYY=> work process left reconnect status [dblink 2000]
B dblink[db_reconnect]: } rc=0
M ThHdlReconnect: reconnect o.k.
There is no firewall configured between APP to DB and ping test is fine and ran niping as well it looks fine
But for every 20 minutes exact the connection are getting reset
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.