DB handles and Discarding duplicate request messages
Hi dear list. I have this message on my freeradius log: Error: rlm_sql (sql): There are no DB handles to use! skipped 0 so I increased the num_sql_socks to 50 in the sql.conf file. It fixed the issue!!! But after that has appeared this new message: Error: Discarding duplicate request from client todos port ZZZZ - ID: 5 due to unfinished request XXXX a lot of times. What does it mean? Do I have to improve the sql configuration? Regards -- *C. Andrés Gómez R.*
On Sep 28, 2017, at 9:16 AM, Andrés Gómez <andres.gomez.ruiz@gmail.com> wrote:
I have this message on my freeradius log:
Error: rlm_sql (sql): There are no DB handles to use! skipped 0
so I increased the num_sql_socks to 50 in the sql.conf file.
It fixed the issue!!!
No, it made that message go away. It didn't fix the issue,
But after that has appeared this new message:
Error: Discarding duplicate request from client todos port ZZZZ - ID: 5 due to unfinished request XXXX
a lot of times.
What does it mean? Do I have to improve the sql configuration?
It means your SQL database is slow. Fix the database so that it takes less than 5 seconds to respond to a query from FreeRADIUS. No amount of poking FreeRADIUS will make the database faster. Be sure that the database has indexes, and doesn't have millions of rows. Alan DeKok.
Hi Alan, you are right!! I created indexes in the database and everything is working fine. I only have a few quantity of these message: Thu Sep 28 13:39:41 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 230 due to unfinished request 1066195 Thu Sep 28 13:39:41 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 190 due to unfinished request 1066221 Thu Sep 28 13:39:41 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 190 due to unfinished request 1066221 Thu Sep 28 13:39:43 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 171 due to unfinished request 1066307 Its a very sporadic message!! What could be the reason? Regards!! 2017-09-28 10:33 GMT-05:00 Alan DeKok <aland@deployingradius.com>:
On Sep 28, 2017, at 9:16 AM, Andrés Gómez <andres.gomez.ruiz@gmail.com> wrote:
I have this message on my freeradius log:
Error: rlm_sql (sql): There are no DB handles to use! skipped 0
so I increased the num_sql_socks to 50 in the sql.conf file.
It fixed the issue!!!
No, it made that message go away. It didn't fix the issue,
But after that has appeared this new message:
Error: Discarding duplicate request from client todos port ZZZZ - ID: 5 due to unfinished request XXXX
a lot of times.
What does it mean? Do I have to improve the sql configuration?
It means your SQL database is slow. Fix the database so that it takes less than 5 seconds to respond to a query from FreeRADIUS.
No amount of poking FreeRADIUS will make the database faster.
Be sure that the database has indexes, and doesn't have millions of rows.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
-- *C. Andrés Gómez R.*
On Sep 28, 2017, at 2:49 PM, Andrés Gómez <andres.gomez.ruiz@gmail.com> wrote:
I created indexes in the database and everything is working fine.
That's good. But the default schema *should* create those indexes. I'm not sure how they would be missed.
I only have a few quantity of these message:
Thu Sep 28 13:39:41 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 230 due to unfinished request 1066195 Thu Sep 28 13:39:41 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 190 due to unfinished request 1066221 Thu Sep 28 13:39:41 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 190 due to unfinished request 1066221 Thu Sep 28 13:39:43 2017 : Error: Discarding duplicate request from client todos port 22988 - ID: 171 due to unfinished request 1066307
Its a very sporadic message!!
What could be the reason?
The same reason. The DB, or something else, is blocking the server. Alan DeKk.
participants (2)
-
Alan DeKok -
Andrés Gómez