** not sure if a bug ** 1 Hour gap in graphs for daylight savings time change.

[dallenk]

I noticed my time change wasn't dealt with very gracefully.

I don't remember seeing this before.. perhaps just a *nix issue on my end? did anyone else see this over the weekend?

[TheWitness]

It's been a problem like forever. I thought I had it resolved at one point, but alas not. It's not that it can not be fixed, but rather that, I can only test once a year ;)

[dallenk]

I can set up a sandbox that changes DST time every 2 hours if you would like lol.

[TheWitness]

That would be great.

[dallenk]

OK, i'll spin up a sandbox vhost and send you credentials, do you need shell or is web access enough?

[TheWitness]

Plus sudo.

[dallenk]

No problem.

[dallenk]

Almost done, installed, just adding dependencies..

cliff notes: you'll have a full VM with sudo to do with as you please.

[dallenk]

Almost done but i just f'd up the .bash_profile, Cacti is installed and on the cron poller unless you need spine?

[dallenk]

done.. installed, SSL'd and daylight savings toggles every two hours with systemctl
just have to get you credentials and open up to your IP if you have a static.

[TheWitness]

Send details to thewitness at cacti dot net. I'm not sure when I'll be able to focus on this. Finishing up a major Cacti project at the moment.

[dallenk]

no problem at all, I'll just turn it into a test system to be broken and restored easily. Share with the rest of your trusted dev's if you want. I can't contribute to code, but I can help with hosting and resources whenever possible.

[TheWitness]

@dallenk, Maybe Monday I can spend time. I did a cursory code review and could not find the issue. It'll have to be done the way you set it up.

[dallenk]

No problem. It's still running, but I'll admit it's not reproducing that same as it did before.

[TheWitness]

What RRDtool version are you using? What is it set to from Console > Configuration > Settings > General?

[dallenk]

sorry for the delay, was super busy and our city Christmas parade. Also emailed credentials and IP info to you.

RRDtool 1.7.2
and strangely, i just pulled latest code and how getting RRD errors and no graphs updating anymore. Errors only show when viewing graph, the poller runs just fine without errors.

Log [Total Lines: 856 - Admin view - Unfiltered]
2024-12-02 02:57:48 - SQL Backtrace: (/graph_json.php[277]:rrdtool_function_graph(), /lib/rrd.php[1648]:db_fetch_assoc_prepared(), /lib/database.php[909]:db_execute_prepared())
2024-12-02 02:57:48 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'gti.legend' in 'field list'
2024-12-02 02:57:48 - RRDTOOL WARNING: RRDtool failed after 5 attempts for the following command graphv - --imgformat=SVG --start='1733021821' --end='1733108221' --pango-markup --title='Local Linux Machine - Logged in Users' --vertical-label='users' --slope-mode --base=1000 --height=200 --width=700 --tabwidth '40' --rigid --alt-autoscale-max --lower-limit='0' COMMENT:"From 2024-12-01 02\:57\:01 To 2024-12-02 02\:57\:01\c" COMMENT:" \n" --color BACK#F3F3F3 --color CANVAS#FDFDFD --color SHADEA#CBCBCB --color SHADEB#999999 --color FONT#000000 --color AXIS#2C4D43 --color ARROW#2C4D43 --color FRAME#2C4D43 --border 1 --font TITLE:11:'Arial' --font AXIS:8:'Arial' --font LEGEND:8:'Courier' --font UNIT:8:'Arial' --font WATERMARK:6:'Arial' --slope-mode --watermark 'Generated by Cacti®' .
2024-12-02 02:57:48 - RRDTOOL Error Backtrace: (/graph_json.php[168]:rrdtool_function_graph(), /lib/rrd.php[2766]:rrdtool_execute(), /lib/rrd.php[284]:__rrd_execute(), /lib/rrd.php[444]:cacti_debug_backtrace())

ran upgrade_database as well. no change.

cactidst@cactidstdev:/var/www/cacti$ sudo -u www-data php cli/upgrade_database.php
[sudo] password for cactidst:
NOTE: Repairing Tables for Local Database
ERROR: Your Cacti is already up to date
  - from: v1.3.0
      to: v1.3.0 - Dev 10f28874 @ 2024-12-02 01:43

first time I've seen rrdtool errors before.

[TheWitness]

When you run the upgrade script, allways use --forcever=version--. So for example, if you are testing on 1.3.0, then always run this after every fresh pull.

php -q upgrade_database.php --forcever=1.2.29

Here is what you should get, all ++ signs

[root@vmhost3 cli]# php -q upgrade_database.php --forcever=1.2.29
NOTE: Repairing Tables for Local Database
Upgrading from v1.2.29
Performing Database Upgrade
  - from v1.2.29 (DB 1.3.0)
      to v1.3.0
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[TheWitness]

Doing quite a few table changes. Upgrade to the latest RRDtool from the develop branch in GitHub (1.9.1) and you get amazing hover support on the Graphs, and now built-in Gradient support.

[dallenk]

that looks amazing!

ahhhh, yea I completely forgot about forcever! sigh.. I need to read more.

that did it.

NOTE: Repairing Tables for Local Database
Upgrading from v1.2.29
Performing Database Upgrade

• from v1.2.29 (DB 1.3.0)
  to v1.3.0
  ++++++++++++++++++++++++++++++++++++++++++cactidst@cactidstdev:/var/www/cacti/cli$

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.