[sr-dev] [kamailio/kamailio] db_unixodbc: detect DB disconnection with generic HY000 status (#691)

[Giovanni]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20160701/bef64484/attachment.html>