[Spce-user] System Statistics stopped working

[Marco Teixeira]

Hello,

Getting back to this old issue... Back to basics.
- I installed a clean 3.8.3. Stats working ok.
- Changed default timezone from Europe/Vienna to GMT. Stats stopped
working...

Followed sugestion of deleting RRD files to allow regeneration...

===
root at spce:/var/lib/collectd/rrd# /etc/init.d/collectd stop
[ ok ] Stopping statistics collection and monitoring daemon: collectd.
root at spce:/var/lib/collectd/rrd# mv spce spce.bak
root at spce:/var/lib/collectd/rrd# ls -lap
total 12
drwxr-xr-x  3 root root 4096 Feb 26 23:10 ./
drwxr-xr-x  3 root root 4096 Feb 26 22:20 ../
drwxr-xr-x 48 root root 4096 Feb 26 22:30 spce.bak/
root at spce:/var/lib/collectd/rrd# /etc/init.d/collectd start
[ ok ] Starting statistics collection and monitoring daemon: collectd.
root at spce:/var/lib/collectd/rrd# ls -lapt
total 16
drwxr-xr-x 41 root root 4096 Feb 26 23:10 spce/
drwxr-xr-x  4 root root 4096 Feb 26 23:10 ./
drwxr-xr-x 48 root root 4096 Feb 26 22:30 spce.bak/
drwxr-xr-x  3 root root 4096 Feb 26 22:20 ../
root at spce:/var/lib/collectd/rrd#
===

​Did not work... Any more hints ?
Please ?​


---
Marco
---


On Fri, Oct 23, 2015 at 1:59 AM, Marco Teixeira <admin at marcoteixeira.com>
wrote:

> Hi there,
>
> As it seems, i didn't catch these on the logs, on first time. Could this
> be it ?
> ntpd is running ... But i guess this only afects graphing ntp process ...
>
> === CUT
> Oct 23 00:27:09 localhost collectd[21512]: rrdtool plugin: Adjusting
> "RandomTimeout" to 0.000 seconds.
> Oct 23 00:27:09 localhost collectd[21512]: mysql plugin: Successfully
> connected to database <none> at server Localhost via UNIX socket (server
> version: 5.5.44-0+deb7u1-log, protocol version: 10)
> Oct 23 00:27:09 localhost collectd[21512]: recv(2) failed: Connection
> refused
> Oct 23 00:27:09 localhost collectd[21512]: ntpd plugin: ntpd_do_query
> (REQ_GET_KERNEL) failed with status -1
> Oct 23 00:27:09 localhost collectd[21512]: read-function of plugin `ntpd'
> failed. Will suspend it for 20 seconds.
>
>
>
>
> ---
> Cumprimentos / Best regards
>
> Marco
> ---
>
>
> On Thu, Oct 22, 2015 at 10:02 PM, Marco Teixeira <admin at marcoteixeira.com>
> wrote:
>
>> Well...
>>
>> One small corretion for future users getting to this, rrd files in
>> mr3.8.3 are on /var/lib/collectd/rrd/ $HOSTNAME
>>
>> Now, back to the problem in hand:
>> - collectd is fine
>> - rrd files have current timestamps
>> - "rrdtool fetch" works ok
>>
>> It seems something with graphics generation or saving... took a look at
>> the code in /usr/share/ngcp-panel/templates/statistics/lists.tt but i'm
>> having dificulties graspping it...
>> - there is a line "var tz_offset = [% tz_offset %];". Where does this
>> variable come from ? The system ?
>> - Are the graphics generated on the fly for display, or are they stored
>> somewhere else ?
>> - Does nginx have some timezone variable in the confs and not  copying
>> from the system ?
>>
>> ​thank you for your time...​
>>
>>
>> ---
>> Cumprimentos / Best regards
>>
>> Marco
>>
>>
>> On Mon, Oct 19, 2015 at 11:16 AM, Alex Lutay <alutay at sipwise.com> wrote:
>>
>>> Hi Marco,
>>>
>>> All system statistics are collected by collectd and are stored in RRD
>>> files located in /var/lib/collectd/rrd/spce/
>>>
>>> "Internally, RRDtool uses "seconds since the epoch" to keep track of
>>> time. This is the number of seconds since January first, 1970,
>>> midnight, UTC. When you are specifying a time in this format, it is UTC
>>> time automatically." (c) http://vandenbogaerdt.nl/rrdtool/timezone.php
>>>
>>> So, you need to check collecd log first to see new values are
>>> inserter properly, also you can manually extract RRD data using RRD
>>> tool fetch (to check content of RRD file).
>>>
>>> Finally you can move RRD files and restart collectd to init new
>>> statistics files. Then you can manually move old data in new RRD files
>>> if necessary.
>>>
>>> P.S. changing the timezone of server on the fly is not a good idea,
>>> AFAIK. As data in MySQL DB (like accounting, CDRs) stored in fields
>>> without timezone specified. Also MySQL works in server timezone by
>>> default.
>>>
>>> On 10/18/2015 10:22 PM, Marco Teixeira wrote:
>>> > Hello list,
>>> >
>>> > A couple weeks ago i lost system statistics... The page opens but
>>> > doesn't get pasted those loading progress circling dots... All of them,
>>> > on any variable i select on the dropdown box.
>>> >
>>> > I searched around on the logs, and found nothing.
>>> > Does anyone have a clue how to fix this ?
>>> >
>>> > # more /etc/ngcp_version
>>> > mr3.8.3
>>>
>>> --
>>> 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/mailman/private/spce-user_lists.sipwise.com/attachments/20160226/5c041140/attachment.html>