[Spce-user] Mediator crashes

[Andreas Granig]

Hello,

Please ALWAYS reply to list or have the list on CC.

On 10/11/2011 08:54 PM, Klaus Peter v. Friedeburg wrote:
> do have an SQL-Script ore something other to delete the records with negative duration from the table? Or an other workaround to temp. fix my problem?

No, there is no prepared solution to this. You need to construct a query
which joins start and stop records with the same call-id and checks for
the timestamp. Something like that should be a good start:

select * from acc a, acc b where a.method = 'INVITE' and b.method =
'BYE' and a.callid = b.callid and a.time < b.time;

Completely untested, tweak it as needed.

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/20111011/21e11e66/attachment-0001.asc>