[Spce-user] Mediator crashes

Andreas Granig agranig at sipwise.com
Thu Oct 13 08:21:19 EDT 2011


Hello,

On 10/13/2011 02:17 PM, Klaus Peter v. Friedeburg wrote:
> I have correcte the statement and it is running:
> 
> this SQL-Statement list all record-pairs with negative duration:
> select * from acc a, acc b where a.method = 'INVITE' and b.method = 'BYE' and a.callid = b.callid and a.time > b.time
> 
> this statement delete the records:
> delete a from acc AS a, acc b where a.method = 'INVITE' and b.method = 'BYE' and a.callid = b.callid and a.time > b.time

The interesting question now is, how this could happen. What's the call
scenario for these cases?

Andreas

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 900 bytes
Desc: OpenPGP digital signature
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20111013/dba1e4e9/attachment-0001.asc>


More information about the Spce-user mailing list