[OpenSIPS-Devel] [OpenSIPS/opensips] 73fe19: [db_oracle] Do not change asynch mode when connect...

[Gang Zhuo]

  Branch: refs/heads/3.1
  Home:   https://github.com/OpenSIPS/opensips
  Commit: 73fe193d9c92c12d92413d2e0c4a8dbfb04b535b
      https://github.com/OpenSIPS/opensips/commit/73fe193d9c92c12d92413d2e0c4a8dbfb04b535b
  Author: Gang Zhuo <gang.zhuo at gmail.com>
  Date:   2022-11-16 (Wed, 16 Nov 2022)

  Changed paths:
    M modules/db_oracle/asynch.c
    M modules/db_oracle/dbase.c
    M modules/db_oracle/ora_con.h

  Log Message:
  -----------
  [db_oracle] Do not change asynch mode when connection lost.

The sessions may be ended due to a network error,
and change OCI_ATTR_NONBLOCKING_MODE attribute with no session
will cause "ORA-03126: network driver does not support non-blocking
operations" error.

In the case, the function done_timelimit will failed with ORA-03126 error.
The error is not considered as a connection loss,
and subsequent operations will always throw this error,
and the lost connection never reconnect.

(cherry picked from commit a5657831f9b216168d2dc974b96e4474e15ff15a)