Freeradius 3.0.17 seems to have deadlocked on me.

Matthew Schumacher matt.s at aptalaska.net
Sun Jul 21 20:40:56 CEST 2019


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/a0c4581d5ba3878637e2d48964b88845cbabb144

Thanks,
schu


More information about the Freeradius-Users mailing list