<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Can you send the log messages (debug=3) for that moment (restart of
pg server and making a new call/registration)?<br>
<br>
Daniel<br>
<br>
On 1/13/11 12:00 PM, Javier Gallart wrote:
<blockquote
cite="mid:AANLkTikFou+XiMgXwCHEs8pYrq_=14H2siZSxV=SMc3F@mail.gmail.com"
type="cite">Hi Daniel<br>
<br>
I have just tested it and I'm getting the same results. This is
the kamailio version I'm testing:<br>
root@kam-test:/usr/local/kamailio/sbin# ./kamailio -V<br>
version: kamailio 3.2.0-dev2 (x86_64/linux) 35568f<br>
<br>
Thanks!<br>
<br>
Javi<br>
<br>
<br>
<div class="gmail_quote">On Tue, Jan 4, 2011 at 3:46 PM, Javier
Gallart <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:jgallartm@gmail.com">jgallartm@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
Hi list
<div><br>
</div>
<div>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:</div>
<div>
<div>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</div>
<div>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</div>
<div>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</div>
<div>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</div>
</div>
<div><br>
</div>
<div>Is there a way to reconnect to the db before sending that
command?</div>
<div><br>
</div>
<div>Thanks in advance</div>
<div><br>
</div>
<div>Regards</div>
<div><br>
</div>
<div>Javi</div>
<div><br>
</div>
</blockquote>
</div>
<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
Kamailio (OpenSER) Advanced Training
Jan 24-26, 2011, Irvine, CA, USA
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>