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