What is the purpose of the default accounting-on/off queries?
aland at deployingradius.com
Sun Oct 10 13:16:05 CEST 2021
On Oct 9, 2021, at 10:28 PM, Nathan Ward <lists+freeradius at 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.
More information about the Freeradius-Users