[SR-Users] Reconnection to db

[Javier Gallart]

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?

Thanks in advance

Regards

Javi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110104/4e5998e1/attachment.htm>