FW: [Bayonne-devel] Problem with sql command

[Julien Chavanton]

-----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