[SR-Users] Reconnection to db

Javier Gallart jgallartm at gmail.com
Thu Jan 13 12:00:35 CET 2011


Hi Daniel

I have just tested it and I'm getting the same results. This is the kamailio
version I'm testing:
root at kam-test:/usr/local/kamailio/sbin# ./kamailio -V
version: kamailio 3.2.0-dev2 (x86_64/linux) 35568f

Thanks!

Javi


On Tue, Jan 4, 2011 at 3:46 PM, Javier Gallart <jgallartm at gmail.com> 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?
>
> Thanks in advance
>
> Regards
>
> Javi
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110113/311582f1/attachment.htm>


More information about the sr-users mailing list