interaction between Virtual server & Authorize section

[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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20131021/3beae491/attachment.html>