RE: [Bayonne-devel] Problem with sql command

[Julien Chavanton]

Hi David,

As you know I have found problem with MySql when there is a hangup in
the middle of an sql query bayonne crash.

I have some question, when hangup is interrupting a script it verify if
TGI is doing something, is it doing the same thing with MySql?

Thread->stop is doing what stopping the thread even if it is doing
something?

Is there something here that should be implemented to protect MySql from
being interrupted?




case TRUNK_ENTER_STATE:
                enterState("hangup");
                stopChannel(EV_ASYNC);
                status[id] = 'h';
                synctimer = exittimer = 0;
                TimerPort::endTimer();
                // Is this right, normally we go the other way.
                if(join)
                        Part();
                if(tgi.pid)
                        ::kill(tgi.pid, SIGHUP);
                if(thread)
                        reset = thread->stop();
                else
                        reset = 0;
                Trunk::flags.dsp = DSP_MODE_INACTIVE;

                if(!hangupCall())
                {
                        handler = &DialogicTrunk::idleHandler;
                        return true;
                }

                Trunk::detach();
                if(group->getHangup() > reset)
                        TimerPort::setTimer(group->getHangup());
                else
                        TimerPort::setTimer(reset);
                return true;



-----Original Message-----
From: address@hidden
[mailto:address@hidden
g] On Behalf Of Julien Chavanton
Sent: January 8, 2005 1:30 PM
To: address@hidden
Subject: FW: [Bayonne-devel] Problem with sql command



-----Original Message-----
From: Julien Chavanton 
Sent: January 8, 2005 1:29 PM
To: 'David Sugar'
Subject: RE: [Bayonne-devel] Problem with sql command

I think the log where reflecting the problem.

I did remove the Mysql query from the script and
The problem did not take place again yet.

As I noticed in the log when the hangup interrupt the sql->load->reset
process bayonne stop responding.

I guess it is not something hard to fix but this is preventing me from
using native bayonne sql command before hangup since the script may be
interrupted in the middle of an sql operation.

What is this load->reset stuff, I think this is related to libxml
because I remember when I test voicexml I saw the same thing in the log.

Anyone as anything to say on this?

Does anyone use sql query in the middle of a script?

This server receives 30 calls/minutes with short duration.
But soon he will receive far more calls.

Julien



-----Original Message-----
From: David Sugar [mailto:address@hidden 
Sent: January 7, 2005 9:34 AM
To: Julien Chavanton
Cc: address@hidden
Subject: Re: [Bayonne-devel] Problem with sql command

Bayonne would presumably be in the thread state handler of the dialogic 
driver during the SQL call when the hangup event was received.  Normally

what should happen there is that the thread state handler cancels the 
active (sql) thread through a delete thread.  Is it possible the sql 
query thread gets stuck in a uncancallable state?

Julien Chavanton wrote:
> This time the call disconnected during the SQL command and bayonne did

> not respond from this point the script did not receive the hang up
event.
> 
> I have to kill Bayonne in order to restart.
> 
>  
> 
>  
> 
> Jan  7 06:48:39 localhost bayonne: dx(112): step 3
sql(=query,%querySelect)
> 
> Jan  7 06:48:48 localhost bayonne: dx(112): GCEV_DISCONNECTED HDL:231
> 
> 
>
------------------------------------------------------------------------
> 
> _______________________________________________
> Bayonne-devel mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/bayonne-devel


_______________________________________________
Bayonne-devel mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/bayonne-devel