Freeradius-Users Digest, Vol 102, Issue 65

[Okis Chuang]

Thanks Fajar for quick response!

Now I know there exists mutual influence among virtual servers. 
Oddly, instead of seeing the error message " There are no DB handles to use
", there are bulk of "Discarding duplicate request from NMS - ID xx due to
unfinished request xxxx", then after about short period of time, it showed
msg "WARNING: Unresponsive child for request xxxx, in component authorized
module", can I still say that is due to problematic DB? 




> > That is, even virtual server ?A? only has few operation to check,
> > while ?B? has much more things need to check and unfortunately maybe
> > it could have low performance DB backend, does B might occupy resource
> > in whole Authorize section so that A also become more and more busier?
> >
> > **
> >
> 
> Yes
> 
> 
> >  **
> >
> > In fact, I got many times of Error msg ?child is hung for request in
> > component authorize module? in radius.log. I would not think the
> > loading in our server was really much high enough for causing late
> > response to simulated request from our NMS per **minute**. Our wifi
> > auth request per day is among 2000~3000 in average.
> >
> 
> only 2k per day? That's tiny. Something if seriously wrong with your db if
it
> can't handle that much requests.
> 
> IIRC one way to isolate problematic db is to use small num_sql_socks in
> sql.conf (default is 5). If the db is slow, it should bomb out quickly
with "There
> are no DB handles to use" errors, but there should be only a small count
of FR
> threads interacting with that db so that processes not using it (e.g.
other
> virtual server) should still work just fine.
> 
> --
> Fajar