[OpenSIPS-Devel] Location table structure - account_contact_idx

[Liviu Chircu]

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,

[1]: 
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_wait_timeout

Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com

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?