FreeTDS errors after running perfectly fine for 30-60minutes.

[Alan DeKok]

On Dec 14, 2023, at 4:56 AM, Olaf <siegson at gmail.com> wrote:
> After running for 30-60 minutes this happens on all servers (3) (Debian
> 12-latetst)
> 
> Thu Dec 14 06:49:32 2023 : Error: rlm_sql_freetds: unable to send command
> (ct_send())
> Thu Dec 14 06:49:32 2023 : ERROR: (571)     ERROR: rlm_sql_freetds: Server
> msg from "mydbserver": severity(5701), number(0), origin(1), layer(1),
> procedure "none": Changed database context to 'mydb'.
> Thu Dec 14 06:49:32 2023 : ERROR: (571)     ERROR: SQL query failed: server
> error

  It sounds like a freetds error to me.  Either the library, or the DB.

  All of the other DBs work fine with FreeRADIUS, so we know it's not that,

> And start repeating like this forever. Most successful, some not.
> Restarting freeradius solves it directly.

  Which also reloads the freetds library, and resets its internal contexts.

> Not sure what to do here to use latest from Freetds (1.4.1)
> Any suggestions?

  Maybe don't use freetds :(

  Alan DeKok.