Excellent answer - that I was looking for.
To keep things under control, all I have to do, is to increase Authby
SQL Timeout value (e.g. 6 sec) and add to each DBSource a
mysql_connect_timeout parameter with slightly smaller value (e.g. 4 sec).

As it turned out, tuning generic Timeout in AuthBy SQL to small values,
has some undesired sideeffects. But with assistance from MySQL driver
options, outages can be avoided.

Thank You!


On 20.04.2017 14:34, Tuure Vartiainen wrote:
> I was now able to reproduce the problem which is caused by MySQL DB driver 
> (libmysqlclient18 in Debian) leaving file handles open when a connect 
> operation 
> is interrupted by SIGALRM signal (generic Timeout in AuthBy SQL).
> You can fix it by defining a timeout value for MySQL driver in DBSource, 
> e.g.
> DBSource   dbi:mysql:dbname:;mysql_connect_timeout=<seconds>
> where the value is smaller than Timeout value used in AuthBy SQL.
> Different MySQL driver options can be found from
> https://metacpan.org/pod/DBD::mysql#Class-Methods
radiator mailing list

Reply via email to