[OpenSIPS-Devel] Location table structure - account_contact_idx

Liviu Chircu liviu at opensips.org
Wed Oct 9 04:25:09 EDT 2019

Hi Donat!

I can't think of an OpenSIPS setting that would prevent idling 
connections from dropping.

On the MySQL side, I suggest you look at "wait_timeout" [1], although it 
seems to have a
solid default value of 8 hours.  The longer you keep each connection 
alive, the less reconnects
you will see in the OpenSIPS logs.

Some info on the errors:  each time it gets triggered, the usrloc timer 
job gets dispatched to
a random OpenSIPS listener process, which will handle it. Depending on 
whether this worker has
reused its MySQL connection within the last 8 hours, the worker will 
reconnect or not.

Finally: given that usrloc timer jobs are being run asynchronously, the 
fact that some workers
reconnect sporadically is harmless.  And long-term, the more MySQL ops 
you will make them do,
as the platform diversifies, the less reconnects they will have to make.

Best regards,


Liviu Chircu
OpenSIPS Developer

On 09.10.2019 11:07, Donat Zenichev wrote:
> My question is, if I'd better look at OpenSIPS side, or should I 
> better manage with MySQL server side?

More information about the Devel mailing list