Upgrade from 1.2.10 to 1.2.11 blocked

[gdsotirov]

About 20 minutes ago I started upgrade from 1.2.10 to 1.2.11, but it still hasn't finished. In the log there is the following:

Code: Select all

2020/04/07 09:08:20 - INSTALL: always: About to import Package #4 'Local_Linux_Machine.xml.gz'.
2020/04/07 09:08:20 - INSTALL: always: Import of Package #3 'Generic_SNMP_Device.xml.gz' under Profile '1' succeeded
2020/04/07 09:08:16 - INSTALL: always: About to import Package #3 'Generic_SNMP_Device.xml.gz'.
2020/04/07 09:08:16 - INSTALL: always: Import of Package #2 'Cisco_Router.xml.gz' under Profile '1' succeeded
2020/04/07 09:07:58 - INSTALL: always: About to import Package #2 'Cisco_Router.xml.gz'.
2020/04/07 09:07:58 - INSTALL: always: Import of Package #1 'Cacti_Stats.xml.gz' under Profile '1' succeeded
2020/04/07 09:06:39 - INSTALL: always: About to import Package #1 'Cacti_Stats.xml.gz'.
2020/04/07 09:06:39 - INSTALL: always: Found 6 templates to install
2020/04/07 09:06:38 - INSTALL: always: Upgrading from v1.2.10 (DB 1.2.11 (DB: 1.2.10)) to v1.2.11
2020/04/07 09:06:38 - INSTALL: always: NOTE: Using temporary file for db cache: /tmp/cdugTHLnM
2020/04/07 09:06:38 - INSTALL: always: Switched from to /tmp/cdugTHLnM
2020/04/07 09:06:38 - INSTALL: always: No tables where found or selected for conversion
2020/04/07 09:06:35 - INSTALL: always: Starting UPGRADE Process for v1.2.11
2020/04/07 09:06:32 - INSTALL: always: Setting PHP Option memory_limit = -1
2020/04/07 09:06:32 - INSTALL: always: Setting PHP Option max_execution_time = 0
2020/04/07 09:06:32 - INSTALL: Checking arguments
2020/04/07 09:06:32 - INSTALL: always: Spawning background process: /usr/bin/php '/var/www/htdocs/stats/cacti/install/background.php' 1586239592.7606 

And nothing more gets printed. I noticed that two httpd processes are running high CPU on the server, but I find no errors in the logs. What could be the problem? I'm not sure why this version decided to import device templates...

[Osiris]

Okay, first restart Apache, then execute the following command from MySQL:

DELETE FROM settings WHERE name LIKE "install%";

Next, navigate to. cacti/index.php and this time don't pick the templates. This was tested multiple times. Not sure why it hanging for you. Tell us a bit about you pho and Apache and OS versions.

[gdsotirov]

I restarted Apache and after few minutes the installation finished with the following addition to the log:

Code: Select all

2020/04/07 09:33:35 - INSTALL: always: Installation was started at 2020-04-07 06:33:33, completed at 2020-04-07 06:33:35
2020/04/07 09:33:34 - INSTALL: always: Finished INSTALL Process for v1.2.11
2020/04/07 09:33:34 - INSTALL: always: No tables where found or selected for conversion
2020/04/07 09:33:34 - INSTALL: always: Starting INSTALL Process for v1.2.11
2020/04/07 09:33:33 - INSTALL: always: Setting PHP Option memory_limit = -1
2020/04/07 09:33:33 - INSTALL: always: Setting PHP Option max_execution_time = 0
2020/04/07 09:33:33 - INSTALL: Checking arguments
2020/04/07 09:33:33 - INSTALL: always: Spawning background process: /usr/bin/php '/var/www/htdocs/stats/cacti/install/background.php' 1586241213.1184 

Why this upgrade took so long?

[Osiris]

Really, no idea. See my other post. Upload the install logs.

[gdsotirov]

Next, navigate to. cacti/index.php and this time don't pick the templates. This was tested multiple times. Not sure why it hanging for you. Tell us a bit about you pho and Apache and OS versions.

Ups... I wrote meantime. Well, the templates were pre-selected, so I left it like this as I didn't expect problems. Anyway I'm on Slackware 14.2, Apache 2.4.43 and PHP 5.6.40, but it's the first time I get this problem on upgrading Cacti. I'll make sure I deselect templates if I get this on next upgrade.

[gdsotirov]

Really, no idea. See my other post. Upload the install logs.

What other logs you need?

[gdsotirov]

Argh... now that I manged to upgrade the first issue I face is that most of my devices are not visible in Management -> Devices, which should be related to the new filter by location...

P.S. Just registered it as issue 3424.

[Osiris]

Yea, odd. I saw it. Is there no "All" drop-down? That should be the default.

[gdsotirov]

Yea, odd. I saw it. Is there no "All" drop-down? That should be the default.

No, the blank value was selected by default without the possibility to select anything else in the filter.

[gdsotirov]

This update of the templates already cost me the whole morning... some of my modified data queries were wiped out and I'm still restoring... please, be ware NOT to select the installation of templates during upgrade. I'm really not sure why I got this option displayed.

[TheWitness]

There was a fix for the location issue. But can you be specific on what was "wiped out"?

[netniV]

This update of the templates already cost me the whole morning... some of my modified data queries were wiped out and I'm still restoring... please, be ware NOT to select the installation of templates during upgrade. I'm really not sure why I got this option displayed.

That should only happen if you are modifying the base templates rather than duplicating them and then modifying the duplicates.

[gdsotirov]

Yes, that's the case. I've modified the base templates years ago and I didn't expect they would be rewritten by upgrades

[TheWitness]

Template version control, or the lack there of, has been a problem since the beginning. It's something, that god willing will be addressed very soon.