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

[Alan DeKok]

On May 23, 2025, at 7:17 AM, Sergei Kodentsev <sergk at ic.vrn.ru> wrote:
> 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?

  Because the database is slow.

  It doesn't matter what the tests say.  The SQL database is taking 5-30 seconds to reply to FreeRADIUS.

  Your choices are:

a) fix the database and solve the problem

b) don't fix the database, and spend days trying to figure out how to "fix" FreeRADIUS when the problem is actually SQL.

  Pick one.

  Alan DeKok.