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 or view it on GitHub: https://github.com/kamailio/kamailio/pull/691