[SR-Users] Reconnection to db

[Daniel-Constantin Mierla]

Hello,

just committed a patch on master branch that should attempt to reconnect 
to postgres server if the connection was lost. There are three attempts 
to execute the query before giving up.

I have no meanings at this time to test it, if you can do it and report 
whether it works or not, will be appreciated. Somehow this is in between 
a bug and feature, since the parameter existed in the module (nameed 
retries), but was implemented only for DB API v2, so it can be 
backported to be also available for DB API v1 (which is the one used by 
kamailio modules right now).

Thanks,
Daniel

On 1/4/11 5:54 PM, Alex Balashov wrote:
> 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.
>

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