With Oracle DB, if the DB is restarted, db_unixodbc doesn't detect the problem as the error returned by
db_unixodbc_extract_error() is:

Jul 1 06:07:15 newvm1 /usr/sbin/kamailio[2770]: ERROR: db_unixodbc [connection.c:220]: db_unixodbc_extract_error(): unixodbc:SQLExecDirect=HY000:1:3114:[Oracle][ODBC][Ora]ORA-03114: not connected to ORACLE#012

Before, only status 08003 and 08S01 where checked to reconnect to the DB. Now, SQLSTATE HY000 (General error) is checked to trigger a reconnection.

You can view, comment on, or merge this pull request online at:

  https://github.com/kamailio/kamailio/pull/691

Commit Summary

• db_unixodbc: detect DB disconnection with generic HY000 status

File Changes

• M modules/db_unixodbc/dbase.c (3)

Patch Links:

• https://github.com/kamailio/kamailio/pull/691.patch
• https://github.com/kamailio/kamailio/pull/691.diff

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub, or mute the thread.