DB handles and Discarding duplicate request messages

[Andrés Gómez]

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 at deployingradius.com>:

> On Sep 28, 2017, at 9:16 AM, Andrés Gómez <andres.gomez.ruiz at 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.*