[asterisk-users] slow ODBC reconnect

[Klaus Darilion]

Klaus Darilion schrieb:
> Hi!
> 
> I use unixodbc to connect to mysql. When the connection to the DB is 
> lost (e.g. restarting the Mysql server) the reconnect takes 5 seconds:
> 
> [Jan  9 13:22:15] WARNING[13899]: res_odbc.c:113 
> ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
> reconnect...
> [Jan  9 13:22:20] NOTICE[13899]: res_odbc.c:541 odbc_obj_connect: 
> Connecting asterisk
> 
> 
> Does somebody know where the 5 seconds delay come from and how I can 
> tune it? Is is also possible to configure asterisk to automatically 
> reconnect instead of waiting for the first query to reconnect?

Follow up: looks like the delay happens either in SQLFreeHandle or 
SQLDisconnect.

I have now added "idlecheck => 60" - this does not trigger the automatic 
reconnect as stated, but at least the 5 seconds delay is mostly gone.

regards
klaus