[SR-Users] Reconnection to db

Daniel-Constantin Mierla miconda at gmail.com
Thu Jan 13 13:56:39 CET 2011


Can you send the log messages (debug=3) for that moment (restart of pg 
server and making a new call/registration)?

Daniel

On 1/13/11 12:00 PM, Javier Gallart wrote:
> 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 
> <mailto: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
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
Kamailio (OpenSER) Advanced Training
Jan 24-26, 2011, Irvine, CA, USA
http://www.asipto.com

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


More information about the sr-users mailing list