[SR-Users] Reconnection to db

[Alex Balashov]

On 01/04/2011 09:46 AM, Javier Gallart wrote:
> Hi list
>
> we have been testing the mtree module. We do periodical reloads of the
> mtree table with the "mi mt_reload" command through xmlrpc. It works
> fine except when the db is restarted. If we manually restart the db and
> then try the mt_reload commands we get this error:
> Jan  4 09:13:17 server /usr/local/kamailio-3.1.1/sbin/kamailio[28534]:
> ERROR: db_postgres [km_dbase.c:152]: 0xa6a490 PQsendQuery Error: server
> closed the connection unexpectedly#012#011This probably means the server
> terminated abnormally#012#011before or while processing the request.#012
> Query: select partition,prefix,route from trees  order by partition
> Jan  4 09:13:17 server /usr/local/kamailio-3.1.1/sbin/kamailio[28534]:
> ERROR: <core> [db_query.c:101]: error while submitting query
> Jan  4 09:13:17 server /usr/local/kamailio-3.1.1/sbin/kamailio[28534]:
> ERROR: mtree [mtree_mod.c:622]: Error while querying db
> Jan  4 09:13:17 server /usr/local/kamailio-3.1.1/sbin/kamailio[28534]:
> ERROR: mtree [mtree_mod.c:738]: cannot re-load info from database
>
> Is there a way to reconnect to the db before sending that command?

Failure to automatically reconnect to Postgres is one of the 
distinguishing features of db_postgres in contrast to db_mysql for the 
moment.

-- 
Alex Balashov - Principal
Evariste Systems LLC
260 Peachtree Street NW
Suite 2200
Atlanta, GA 30303
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/