[EXTERNAL] Re: radiusd crashes. ASSERT FAILED src/main/threads.c[794]

[Winfield, Alister (Senior Solutions Architect)]

Last attempt, assuming the connection pool is full and thus no connection delays causing issues.

Take your ‘average response time in seconds’ and max_pool_size

               (max_pool_size / Average_response_time of DB) = Max RADIUS rate possible per second.

This is the absolute maximum rate of RADIUS replies per second.. (assumes zero other delays).

Increase the number of DB connections and/or reduce average response time until this is greater than the expected RADIUS peek rate. Remembering that more connections will likely increase the response time.

Alister

From: Freeradius-Users <freeradius-users-bounces+alister.winfield=sky.uk at lists.freeradius.org> on behalf of Sergei Kodentsev <sergk at ic.vrn.ru>
Date: Tuesday, 27 May 2025 at 11:30
To: freeradius-users at lists.freeradius.org <freeradius-users at lists.freeradius.org>
Subject: Re: [EXTERNAL] Re: radiusd crashes. ASSERT FAILED src/main/threads.c[794]
Hi,

This is the request that radius performs.
TLS is not used.
The connection is taken from the pool to locality
Authentication delays are not a database problem.

<Start of Query>
THIS IS THE NUMBER YOU HAVE
<End of Query>

Alan says that this is where the problem is.
Redards,
Sergey Kodentsev.

On 27.05.2025 12:52, Winfield, Alister (Senior Solutions Architect) via
Freeradius-Users wrote:
> That’s not the query that FreeRADIUS is performing, so you are seeing stats that don’t help. Query time is the time from query receipt to query result NOT the overall time which includes connection delays, TLS delays and authentication delays.
>
> You are missing.
>
> <FR needs to do a query>
> <Highly likely pool is exhausted so.>
> Time to resolve hostname of DB
> Time to connect to DB socket
> Time for TLS exchange (Assuming encrypted comms).
> Time to authenticate to DB
>
> <Start of Query>
> THIS IS THE NUMBER YOU HAVE
> <End of Query>
>
> Time for result set to get to the RADIUS server
> <here FINALLY FR gets to do something with that result>
>
> You need the WHOLE time taken
>

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<http://www.freeradius.org/list/users.html>
Information in this email including any attachments may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone. Please note we reserve the right to monitor all e-mail communication through our internal and external networks. SKY and the SKY marks are trademarks of Sky Limited and Sky International AG and are used under licence.

Sky UK Limited (Registration No. 2906991), Sky-In-Home Service Limited (Registration No. 2067075), Sky Subscribers Services Limited (Registration No. 2340150) and Sky CP Limited (Registration No. 9513259) are direct or indirect subsidiaries of Sky Limited (Registration No. 2247735). All of the companies mentioned in this paragraph are incorporated in England and Wales and share the same registered office at Grant Way, Isleworth, Middlesex TW7 5QD