Avoid to use MySQL dialplan application, instead write an AGI script for this purpose
On Tue, Aug 17, 2010 at 4:59 PM, Geraint Lee <gera...@gmail.com> wrote: > Right, I'm baffled. > > I have: > exten => s,1,MYSQL(Connect DB1 127.0.0.1 geraint xxx amis2) > 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)) > exten => s,n,MYSQL(Query RESULT1 ${DB1} SELECT\ LAST_INSERT_ID()) > exten => s,n,MYSQL(Fetch FOUND1 ${RESULT1} VALUE1) > exten => s,n,MYSQL(Clear ${RESULT1}) > exten => s,n,MYSQL(Disconnect ${DB1}) > exten => s,n,MixMonitor(${VALUE1}.wav) > exten => s,n,Set(CALLERID(all)=xxx) > exten => s,n,Dial(SIP/prov1/${ARG1}) > > in a macro to dial numbers... > > Every few hours or so every call hangs on the s,1 MYSQL(Connect) and won't > work until i restart asterisk. > > 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. > > 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. > > Cheers > > Geraint > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > -- Nasir Iqbal ICT Innovations http://www.ictinnovations.com/
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users