[asterisk-users] Asterisk 13.7.0 losing database connection

[Matthew Murphy]

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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20160127/7a25786c/attachment.html>