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.