Right, I'm baffled.<div><br></div><div>I have:</div><div><div>exten => s,1,MYSQL(Connect DB1 127.0.0.1 geraint xxx amis2)</div><div>exten => s,n,MYSQL(Query NORESULT ${DB1} INSERT\ INTO\ recordings\ (caller_number\,called_number\,date_created\,date_started\,in_use\,server_id)\ VALUES\ (\'${CALLERID(number)}\'\,\'${ARG1}\'\,NOW()\,NOW()\,\'Yes\'\,12))</div>
<div>exten => s,n,MYSQL(Query RESULT1 ${DB1} SELECT\ LAST_INSERT_ID())</div><div>exten => s,n,MYSQL(Fetch FOUND1 ${RESULT1} VALUE1)</div><div>exten => s,n,MYSQL(Clear ${RESULT1})</div><div>exten => s,n,MYSQL(Disconnect ${DB1})</div>
<div>exten => s,n,MixMonitor(${VALUE1}.wav)</div><div>exten => s,n,Set(CALLERID(all)=xxx)</div><div>exten => s,n,Dial(SIP/prov1/${ARG1})</div></div><div><br></div><div>in a macro to dial numbers...</div><div><br>
</div><div>Every few hours or so every call hangs on the s,1 MYSQL(Connect) and won't work until i restart asterisk.</div><div><br></div><div>The mysql server has a maximum connections of 2048 (of which around 90 are in use) so it's not a mysql connection limit problem from what i can tell since while asterisk is "stuck" i can still log in to mysql just fine, as can the web server.</div>
<div><br></div><div>Does anyone have any suggestions what could be causing asterisk to get stuck here? i don't see anything in cli and core show channels just shows everyone stuck in state ring on the connect string with no errors.</div>
<div><br></div><div>Cheers</div><div><br></div><div>Geraint</div>