[SR-Users] sr-users Digest, Vol 68, Issue 7

[Javier Gallart]

Thanks Alex,

it looks like we'll have to move to mysql in that case (we are much more
experienced in postgres). Is this feature expected to be added for
db_postgres?

Regards

Javi

>
> Message: 6
> Date: Tue, 04 Jan 2011 11:54:20 -0500
> From: Alex Balashov <abalashov at evaristesys.com>
> Subject: Re: [SR-Users] Reconnection to db
> To: sr-users at lists.sip-router.org
> Message-ID: <4D2350BC.8080207 at evaristesys.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> 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/
>
>
>
> ------------------------------
>
> _______________________________________________
> sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> End of sr-users Digest, Vol 68, Issue 7
> ***************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110104/cd0cea29/attachment.htm>