Re: radiusd crashes. ASSERT FAILED src/main/threads.c[794]
Sergei Kodentsev <[email protected]>
| Newsgroups | gmane.comp.freeradius.user |
|---|---|
| Message-ID | <[email protected]> |
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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html