[SR-Users] Accounting to mysql resulted in segfault

[Daniel Tryba]

On Wednesday 04 December 2013 21:02:20 Daniel-Constantin Mierla wrote:
> Would be good to get the core and backtrace, otherwise is hard to track 
> what went wrong. db_mysql discards the query if it is not successful 
> after three retries. The segfault seem to refer to usrloc, not acc. The 
> issue could be combined with libmysqlclient behaviour, iirc kamailio 
> will try to open a new connection if old one is dead.

There are sql lookups per INVITE/REGISTER on usr_preferences and subscriber, 
which fail due to acc hogging all connections. I'll try to reproduce on a test 
server.
 
> You could eventually switch to use insert delayed with acc module or 
> even globally via db_mysql - there are module parameters for it.

Missed this option, thanks for pointing that out. Sounds like what is needed 
in these kind of scenarios.

-- 

POCOS B.V. - Croy 9c - 5653 LC Eindhoven
Telefoon: 040 293 8661 - Fax: 040 293 8658
http://www.pocos.nl/   - http://www.sipo.nl/
K.v.K. Eindhoven 17097024