10 Oct
2021
10 Oct
'21
7:16 a.m.
On Oct 9, 2021, at 10:28 PM, Nathan Ward <lists+freeradius@daork.net> wrote:
As well as the VRF issue, you can experience this in global context if the database connection is configured with a query timeout and the bulk session update does not complete in time.
It seems very odd to me that you would have an Accounting-On/Off query taking anywhere near what a DB query timeout is. That doesn’t sound like an MX issue - that sounds like some index tuning is required, or perhaps the query is doing a large amount of work that could be handled another way?
If it's a big GGSN, then updating 100K rows can take time. Doing that update in an asynchronous transaction would be better, perhaps. Alan DeKok.