[OpenSER-Users] avp_db_query() timeout

Bogdan-Andrei Iancu bogdan at voice-system.ro
Tue Jan 15 18:03:18 CET 2008


Hi Henning,

The problem is actually in the libmysqlclient library, which deals with 
the TCP connection. I never got into its API, but maybe it pays the 
effort to take a look and see if the TCP timeout is configurable.

Regards,
bogdan

Henning Westerholt wrote:
> On Monday 14 January 2008, Douglas Garstang wrote:
>   
>> Inaki,
>>
>> I am doing updates with avp_db_query, so there is no avp I can check the
>> value of . As
>> I said in a subsequent post, I wrote a simple server that listened on
>> port 3306, like mysql does, and pointed OpenSER at it. The avp_db_query
>> commands() basically blocked forever and openser seemed to completely
>> lose all ability to process new calls. That's really bad.
>>     
>
> Hi Douglas,
>
> thats a know problems with the mysql driver, and the reason we wrote some time 
> ago the mysql-mt module (on the tracker). This code is currently not 
> maintained and also don't work that well with a current openser because of 
> multi-threading issues. 
>
> The openser blocks on db connection problems for the TCP timeout.
>
> Cheers,
>
> Henning
>
> _______________________________________________
> Users mailing list
> Users at lists.openser.org
> http://lists.openser.org/cgi-bin/mailman/listinfo/users
>
>   





More information about the Users mailing list