RE: [Bayonne-devel] Problem with sql command

[Julien Chavanton]

My goal is to use a MySql DB for associating service with calledid.

I did test MySql to Store CDR and there was no problem I was able to
store more then a million calls without a problem.

But it seem to be a problem in some case when the script is interrupted
in the middle of an sql query.

I need to stop using Sql module just to be sure this is realy the cause
of the problem I am facing.

I guess my best alternative to do this right now will be to use TGI and
perl to query the DB.

But this will greatly affect performance right?

Anything other suggestion?

Is there a file module in bayonne?

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