<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p></p>
<p style="margin-bottom: 0in; line-height: 100%">Hi everyone,</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">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!</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">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. <br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Has anyone had any experience with this?<br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Below is a snippet from my CLI that shows the problem:<br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">[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]...</p>
<p style="margin-bottom: 0in; line-height: 100%">[Jan 26 09:58:27] WARNING[23947]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...</p>
<p style="margin-bottom: 0in; line-height: 100%">Error in my_thread_global_end(): 1 threads didn't exit</p>
<p style="margin-bottom: 0in; line-height: 100%">[Jan 26 09:58:32] NOTICE[23947]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk</p>
<p style="margin-bottom: 0in; line-height: 100%">[Jan 26 09:58:32] NOTICE[23947]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]</p>
<p style="margin-bottom: 0in; line-height: 100%">[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)</p>
<p style="margin-bottom: 0in; line-height: 100%">[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]...</p>
<p style="margin-bottom: 0in; line-height: 100%">[Jan 26 09:58:32] WARNING[23947]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...</p>
<p style="margin-bottom: 0in; line-height: 100%">Error in my_thread_global_end(): 1 threads didn't exit</p>
<p></p>
<p><br>
</p>
<p>Thanks,</p>
<p><br>
</p>
<p>--Matt<br>
</p>
</div>
</body>
</html>