Thanks Alex,<br><br>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?<br><br>Regards<br><br>Javi<br><div class="gmail_quote">
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
Message: 6<br>
Date: Tue, 04 Jan 2011 11:54:20 -0500<br>
From: Alex Balashov <<a href="mailto:abalashov@evaristesys.com">abalashov@evaristesys.com</a>><br>
Subject: Re: [SR-Users] Reconnection to db<br>
To: <a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
Message-ID: <<a href="mailto:4D2350BC.8080207@evaristesys.com">4D2350BC.8080207@evaristesys.com</a>><br>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br>
<br>
On 01/04/2011 09:46 AM, Javier Gallart wrote:<br>
> Hi list<br>
><br>
> we have been testing the mtree module. We do periodical reloads of the<br>
> mtree table with the "mi mt_reload" command through xmlrpc. It works<br>
> fine except when the db is restarted. If we manually restart the db and<br>
> then try the mt_reload commands we get this error:<br>
> Jan 4 09:13:17 server /usr/local/kamailio-3.1.1/sbin/kamailio[28534]:<br>
> ERROR: db_postgres [km_dbase.c:152]: 0xa6a490 PQsendQuery Error: server<br>
> closed the connection unexpectedly#012#011This probably means the server<br>
> terminated abnormally#012#011before or while processing the request.#012<br>
> Query: select partition,prefix,route from trees order by partition<br>
> Jan 4 09:13:17 server /usr/local/kamailio-3.1.1/sbin/kamailio[28534]:<br>
> ERROR: <core> [db_query.c:101]: error while submitting query<br>
> Jan 4 09:13:17 server /usr/local/kamailio-3.1.1/sbin/kamailio[28534]:<br>
> ERROR: mtree [mtree_mod.c:622]: Error while querying db<br>
> Jan 4 09:13:17 server /usr/local/kamailio-3.1.1/sbin/kamailio[28534]:<br>
> ERROR: mtree [mtree_mod.c:738]: cannot re-load info from database<br>
><br>
> Is there a way to reconnect to the db before sending that command?<br>
<br>
Failure to automatically reconnect to Postgres is one of the<br>
distinguishing features of db_postgres in contrast to db_mysql for the<br>
moment.<br>
<br>
--<br>
Alex Balashov - Principal<br>
Evariste Systems LLC<br>
260 Peachtree Street NW<br>
Suite 2200<br>
Atlanta, GA 30303<br>
Tel: +1-678-954-0670<br>
Fax: +1-404-961-1892<br>
Web: <a href="http://www.evaristesys.com/" target="_blank">http://www.evaristesys.com/</a><br>
<br>
<br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br>
<br>
End of sr-users Digest, Vol 68, Issue 7<br>
***************************************<br>
</blockquote></div><br>