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

[Winfield, Alister (Senior Solutions Architect)]

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

A.

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 10:44
To: freeradius-users at lists.freeradius.org <freeradius-users at lists.freeradius.org>
Subject: [EXTERNAL] Re: radiusd crashes. ASSERT FAILED src/main/threads.c[794]
Hi,
> The SQL databases which these modules are querying is taking 5-30 seconds to respond. No amount of poking FreeRADIUS will make the SQL database faster.
>
> Fix the SQL database so that it replies within a second, ideally much less. FreeRADIUS will then be able to operate normally.
>
> Alan DeKok.
MariaDB 10.6.21 database server.

database load here -
https://drive.google.com/file/d/1eN-WN-DNikfmCDQV0KdgbYOAUO2lJQ6B/view?usp=sharing<https://drive.google.com/file/d/1eN-WN-DNikfmCDQV0KdgbYOAUO2lJQ6B/view?usp=sharing>
Every 0.5 sec execution from 2025-05-23 14:30:47.349429 to 2025-05-23
14:35:50.900787
SELECT info,time_ms FROM information_schema.processlist pr WHERE command
!= 'Sleep' AND db='raddbdhcp'
Result here -
https://drive.google.com/file/d/1nkMYXL-BefEcmtTlZk2XL6Pd2KYZwsnQ/view?usp=sharing<https://drive.google.com/file/d/1nkMYXL-BefEcmtTlZk2XL6Pd2KYZwsnQ/view?usp=sharing>
Maximum query execution time 230.654 milliseconds.
During this time, 47 warnings become unblocked in freeradius logs  -
https://drive.google.com/file/d/1bbQ8_zLdreW-_pXXccc3SJ8bzZr2IJqR/view?usp=sharing<https://drive.google.com/file/d/1bbQ8_zLdreW-_pXXccc3SJ8bzZr2IJqR/view?usp=sharing>
Why?

redards,

Sergey Kodentsev


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<http://www.freeradius.org/list/users.html>
--------------------------------------------------------------------
This email is from an external source. Please do not open attachments or click links from an unknown or suspicious origin. Phishing attempts can be reported by using the report message button in Outlook or sending them as an attachment to phishing at sky.uk. Thank you
--------------------------------------------------------------------

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