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 _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
