[Spce-user] Mediator failed - Failed query: insert into cdr_tag_data

[Hohl Matthias]

Von: Hohl Matthias <matthias.hohl at telematica.at> 
Gesendet: Montag, 19. August 2019 13:54
An: spce-user at lists.sipwise.com
Betreff: Mediator failed - Failed query: 'insert into cdr_tag_data

 

Hello,

 

since one hour, the mediator service failed several times:

it is always near the same message
 just another cdr entry.

 

How can I fix that?

 

 

cat /var/log/ngcp/cdr.log

 

Aug 19 13:33:14 spce (crit) mediator[31685]: medmysql.c:1249 [<unknown>]:
Error executing query: Truncated incorrect DOUBLE value: 'a'
Aug 19 13:33:14 spce (crit) mediator[31685]: medmysql.c:1251 [<unknown>]:
Failed query: 'insert into cdr_tag_data (cdr_id, provider_id, direction_id,
tag_id, val, cdr_start_time) values (9110403, 3, 1, 3, 'a'or'3=3--',
1566214383.417525),(9110404, 3, 1, 3, '433124xxxxx',
1566214386.475861),(9110405, 3, 1, 3, '4317xxxxxx', 1566214383.197207)'
Aug 19 13:33:14 spce (info) mediator[31685]: mediator.c:441 [main]: Shutting
down.
Aug 19 13:33:14 spce (warning) mediator[31685]: medmysql.c:397 [<unknown>]:
Closing DB handle with still 1 statements in queue
Aug 19 13:33:14 spce (info) mediator[31685]: mediator.c:449 [main]:
Successfully shut down.

 

Mit freundlichen Grüßen,
Matthias Hohl



 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20190819/8cdad4dc/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5585 bytes
Desc: not available
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20190819/8cdad4dc/attachment-0001.p7s>