Hi everyone,

I upgraded from Asterisk 13.5.0 to 13.7.0 and I am having database connection problems. I am doing Asterisk realtime with PJSIP 2.4.5 and it works perfectly in 13.5.0. But now I am losing my database connection (running on a virtual box) and I am stuck!

I spent all day yesterday looking through information from people that had similar problems. So far as I can tell, this pops up from time to time, but I never saw any resolution. I’ve tried to increase connection_timeout and monkey around with bind-address but no joy.

Has anyone had any experience with this?

Below is a snippet from my CLI that shows the problem:

[Jan 26 09:58:27] WARNING[23947]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]…

[Jan 26 09:58:27] WARNING[23947]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect…

Error in my_thread_global_end(): 1 threads didn’t exit

[Jan 26 09:58:32] NOTICE[23947]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk

[Jan 26 09:58:32] NOTICE[23947]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]

[Jan 26 09:58:32] WARNING[23947]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.5.46-0+deb8u1]Duplicate entry ‘103^3B@b2ddb71120ca050b70435cd8679200ba’ for key ‘id’ (118)

[Jan 26 09:58:32] WARNING[23947]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]…

[Jan 26 09:58:32] WARNING[23947]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect…

Error in my_thread_global_end(): 1 threads didn’t exit

Thanks,

–Matt