Re: interaction between Virtual server & Authorize section
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
Okis Chuang wrote:
Now I know there exists mutual influence among virtual servers.
They all run in the same process space, and they all use the same modules.
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?
Yes. 99.9% of the time, these messages mean that your database is broken. Alan DeKok.
participants (2)
-
Alan DeKok -
Okis Chuang