[Spce-user] CDRs not loggin

[Brian Pelletier]

It does write the first few calls after a fresh installation or resetting the database before it starts to fail.  I provided the version information below, any help would be greatly appreciated.

mr6.0.1
System installed. NGCP version mr6.0.1 on 2018-02-16 00:49:19



Brian Pelletier



---- On Mon, 19 Feb 2018 04:24:53 -0500 Alex Lutay <alutay at sipwise.com> wrote ---- 

Hi,

What is the version of your system?
The mediator is failing because it cannot insert the record in DB:

On 02/16/2018 07:38 PM, Brian Pelletier wrote:
...
> Feb 16 02:10:25 spce (debug) mediator[2696]: Parsing JSON:
> '{"mos":{"avg_score":4.2999999999999998,"avg_packetloss":0,"avg_jitter":18,"avg_rtt":40737}}'
> Feb 16 02:10:25 spce (crit) mediator[2696]: Error executing query: Out
> of range value for column 'mos_average_roundtrip' at row 1
> Feb 16 02:10:25 spce (crit) mediator[2696]: Failed query: 'insert into
> cdr_mos_data (cdr_id, mos_average, mos_average_packetloss,
> mos_average_jitter, mos_average_roundtrip, cdr_start_time) values (4,
> 4.3, 0$
> Feb 16 02:10:25 spce (info) mediator[2696]: Shutting down....

I would like to reproduce it locally to confirm the issue,
so far I need to know the version of the system, please share:
> cat /etc/ngcp_version
> cat /etc/sipwise_ngcp_version

Tnx!

-- 
Alex Lutay
_______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com
https://lists.sipwise.com/listinfo/spce-user





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20180219/1a9e1afe/attachment-0001.html>