Matthew Murphy
2016-Jan-27 14:45 UTC
[asterisk-users] Asterisk 13.7.0 losing database connection
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>