[Asterisk-Dev] Re: [Asterisk-biz] cdr_addon_mysql.c and 1.0.7==DEADLOCK

Matthew Boehm mboehm at cytelcom.com
Sun Mar 27 22:44:07 MST 2005


asterisk*CLI> show version
Asterisk CVS-Nv1-0-7-03/26/05-01:10:37 built by root at asterisk on a i686
running Linux
asterisk*CLI> cdr mysql status
Connected to asterisk at 64.72.107.5, port 3306 with username asterisk for 11
hours, 28 minutes, 29 seconds.
  Wrote 17 records since last restart and 7 records since last reconnect.
asterisk*CLI> 

Not here..

-Matthew


> From: Brian West <brian.west at mac.com>
> Reply-To: Asterisk Developers Mailing List <asterisk-dev at lists.digium.com>
> Date: Sat, 26 Mar 2005 14:02:03 -0600
> To: Asterisk Developers Mailing List <asterisk-dev at lists.digium.com>
> Subject: Re: [Asterisk-Dev] Re: [Asterisk-biz] cdr_addon_mysql.c and
> 1.0.7==DEADLOCK
> 
> Just make a call... you'll deadlock/block the moment it tries to insert
> a record.
> 
> /b
> 
> On Mar 26, 2005, at 9:05 AM, Greg Boehnlein wrote:
> 
>> On Sat, 26 Mar 2005, Tony Mountifield wrote:
>> 
>> [deleted]
>> 
>>> That's very strange, because cdr_addon_mysql.c hasn't changed in
>>> Stable
>>> since v1.0:
>>> 
>>> [root at softins asterisk-addons]# cvs log cdr_addon_mysql.c
>>> 
>>> RCS file: /usr/cvsroot/asterisk-addons/cdr_addon_mysql.c,v
>>> Working file: cdr_addon_mysql.c
>>> head: 1.7
>>> branch:
>>> locks: strict
>>> access list:
>>> symbolic names:
>>>         v1-0-7: 1.5
>>>         v1-0-6: 1.5
>>>         v1-0-4: 1.5
>>>         v1-0: 1.5.0.2
>>>         v1-0-1: 1.5
>>> keyword substitution: kv
>>> total revisions: 7;     selected revisions: 7
>>> ...
>>> 
>>> I'll try it here, too. Any information on whether the deadlock happens
>>> every time, or only sometimes, etc?
>> 
>> Just because it hasn't changed doesn't mean that a new deadlock
>> situation
>> can't be discovered! ;)
>> 
>> Forging on, what is the nature of the deadlock situation? How can it be
>> reproduced?
>> 
>> -- 
>>     Vice President of N2Net, a New Age Consulting Service, Inc. Company
>>          http://www.n2net.net Where everything clicks into place!
>>                              KP-216-121-ST
>> 
>> 
>> 
>> _______________________________________________
>> Asterisk-Dev mailing list
>> Asterisk-Dev at lists.digium.com
>> http://lists.digium.com/mailman/listinfo/asterisk-dev
>> To UNSUBSCRIBE or update options visit:
>>    http://lists.digium.com/mailman/listinfo/asterisk-dev
> 
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev





More information about the asterisk-dev mailing list