radiusd crashes. ASSERT FAILED src/main/threads.c[794]
Sergei Kodentsev
sergk at ic.vrn.ru
Fri May 23 12:17:51 UTC 2025
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
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
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
Why?
redards,
Sergey Kodentsev
More information about the Freeradius-Users
mailing list