On 7/19/19 12:50 PM, Alan DeKok wrote:
Find out why the SQL module is blocking. Even if the SQL back-end takes time to respond, it should *eventually* make progress.
If this is for PostgreSQL, then try using the v3.0.x branch. Terry Burton put some patches in which make it better respect the query_timeout parameter. That may help. Thanks for that. I am using postgresql, and I am doing a bit of math on some of the queries and my dataset is getting bigger, so it's an issue (though I'm working on putting in timescaledb which will partition up my data and make this not suck), but I need it to not deadlock the entire server until I can get that done.
I'm already using query_timeout = 5, so if I put in Terry's patch, it should help. Is this the one you are referring to? https://github.com/FreeRADIUS/freeradius-server/commit/a0c4581d5ba3878637e2d... Thanks, schu