[Spce-user] No ActiveCall on Grafana

[Luciano Moreira]

Mark and Devs

Service witnessd is writing sip_stats on different format after upgrade
to CE mr7.5.1

I've got active calls data using this query on Grafana:
q:"SELECT "dialog_active_dialogs" FROM "autogen"."kamailio" WHERE
("node_active" = '1') AND time >= now() - 24h"

Active data are written on different tag than Grafana is looking for.
Maybe we get a hotfix sometime in future.

Atenciosamente,

Luciano Moreira
_____________________
Logic Telecom


Em ter, 8 de out de 2019 às 11:54, Mark van Herpen <mark at cambrium.nl>
escreveu:

> Hello,
>
> I'm debugging a bit more. I have one active call, and a query on
> influxdb gives me this result:
>
>  > select host, kam_dialog_active from kamailio where "node_active" =
> '1' and time > now() - 20s group by host;
> name: kamailio
> tags: host=tran-out01
> time                host       kam_dialog_active
> ----                ----       -----------------
> 1570546033000000000 tran-out01 0
> 1570546043000000000 tran-out01 0
>
> The kam_dialog_active is 0
>
> On another host this is '1'. What sets the kam_dialog_active value?
>
> Grtz,
>
> Mark
>
> Op 01-10-19 om 12:13 schreef Mark van Herpen:
> > Hello,
> >
> > Same issue here on CE mr7.5.1, applied al fixes with 'apt-get upgrade'
> > and ngcpcfg apply and a reboot.
> >
> > I have one active call, also ngcp-status shows 1 active call.
> >
> > The grafana sip-statistics dashboard shows 0 active calls.
> > The 'active calls'-panel (one row lower), shows 'No data points.
> >
> >  From the json-export of the active panel I saw the influx query used:
> >
> > root at tran-out01:/etc/ngcp-config# influx
> > Connected to /run/influxdb/influxdb.sock version 1.6.4
> > InfluxDB shell version: 1.6.4
> >  > use ngcp
> > Using database ngcp
> >  > SELECT SUM(mean) from (SELECT mean(kam_dialog_active) from kamailio
> > where "node_active" = '1' AND time > now() - 20s  group by host)
> > name: kamailio
> > time sum
> > ---- ---
> > 0    0
> >
> > Also a 'select * from kam_dialog_active' gives no result.
> >
> > Can I do something more for debugging?
> >
> > Grtz,
> >
> > Mark
> >
> >
> >
> > Op 23-09-19 om 15:06 schreef Luciano Moreira:
> >> Hi Folks,
> >>
> >> I installed SIPWISE CE 7.4.1. Everything was perfect.
> >> Then I upgraded to mr7.5.1. After that, I lost Grafana's Active Calls
> >> panel.
> >> Applied all hotfixes, but Active calls panel stills empty.
> >> I have no clue how to debug this issue. Anyone could help me? Where
> >> should I start look in for?
> >>
> >> +---------------------------------------------- 2019-09-23 09:56:55 -+
> >> | NGCP: CE mr7.5.1           nodes setup                        [  ] |
> >> | NGCP: subscribers:21 locations:6 calls:2                           |
> >> |   OS: buster (10.1) 4.19.0-6-amd64 SMP (ext4)                      |
> >> |  CPU: 2 = 1 x Virtual CPU 82d9ed4018dd (HT)                        |
> >> |   HW: Standard PC (i440FX + PIIX, 1996) by QEMU                    |
> >> | BIOS: rel-1.12.0-0-ga698c8... (04/01/2014) by SeaBIOS              |
> >> |  RAM: 3.9Gi (used 78%/cache 6%) mysqld[39.7%] kamailio[12.7%]      |
> >> |   LA: system load OK: 0.25 0.48 0.51                               |
> >> | DISK: /dev/sr0 [CDROM] /dev/vda [HDD]                              |
> >> | DISK: space used /[26%]                                            |
> >> | DISK: inodes in use /[3%]                                          |
> >> | SWAP: used 685824 kB: mysqld[59%] perl-fcgi-pm [N[59%]
> >> perl-fcgi[47%]  |
> >> | MODs: License OFF, DUMMY ON,                                       |
> >> +-----  ---------------------------------------7.5.1.1+0~mr7.5.1.1---+
> >>
> >> Luciano Moreira
> >> Logic
> >>
> >
>
> --
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20191008/a43b4562/attachment-0002.html>