Issue when upgrading to 1.2.6 from 1.2

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Moderators, Developers

Post Reply
Author
Message
Rno
Cacti User
Posts: 345
Joined: Wed Dec 07, 2011 9:19 am

Issue when upgrading to 1.2.6 from 1.2

#1 Post by Rno » Tue Sep 17, 2019 10:19 am

I have an issue when I uprgade from 1.2.0 to 1.2.6
I got this error at final step.
Process Log

2019/09/17 09:48:00 - INSTALL: always: Installation was started at 2019-09-17 07:47:03, completed at 2019-09-17 07:47:59
2019/09/17 09:47:53 - INSTALL: always: WARNING: One or more upgrades failed to install correctly
2019/09/17 09:47:44 - INSTALL: always: Finished UPGRADE Process for v1.2.6
2019/09/17 09:47:39 - INSTALL: always: Repairing Automation Rules
2019/09/17 09:47:35 - INSTALL: always: Upgrading from v1.2.3 (DB 1.2.3) to v1.2.5
2019/09/17 09:47:26 - INSTALL: always: Upgrading from v1.2.2 (DB 1.2.2) to v1.2.3
2019/09/17 09:47:22 - INSTALL: always: Upgrading from v1.2.1 (DB 1.2.6 (DB: 1.2.1)) to v1.2.2
2019/09/17 09:47:22 - INSTALL: always: NOTE: Using temporary file for db cache: /tmp/cdujDAgut
2019/09/17 09:47:22 - INSTALL: always: Switched from to /tmp/cdujDAgut
2019/09/17 09:47:21 - INSTALL: always: No tables where found or selected for conversion
2019/09/17 09:47:20 - INSTALL: always: Starting UPGRADE Process for v1.2.6
2019/09/17 09:47:03 - INSTALL: always: Setting PHP Option memory_limit = -1
2019/09/17 09:47:03 - INSTALL: always: Setting PHP Option max_execution_time = 0
2019/09/17 09:47:03 - INSTALL: Checking arguments
2019/09/17 09:47:03 - INSTALL: always: Spawning background process: /bin/php '/usr/share/cacti/install/background.php' 1568706422.7711

and on install-complet.log this is the last step ok:
[2019-02-14 14:09:07] [ global always ] Setting PHP Option max_execution_time = 0
[2019-02-14 14:09:07] [ global always ] Setting PHP Option memory_limit = -1
[2019-02-14 14:09:22] [ global always ] Starting UPGRADE Process for v1.2.1
[2019-02-14 14:09:23] [ global always ] No tables where found or selected for conversion
[2019-02-14 14:09:24] [ global always ] Switched from to /tmp/cdubeDUmb
[2019-02-14 14:09:24] [ global always ] NOTE: Using temporary file for db cache: /tmp/cdubeDUmb
[2019-02-14 14:09:24] [ global always ] Upgrading from v1.2.0 (DB 1.2.1 (DB: 1.2.0)) to v1.2.1
[2019-02-14 14:09:27] [ global always ] Finished UPGRADE Process for v1.2.1
[2019-02-14 14:09:27] [ global always ] WARNING: One or more upgrades failed to install correctly
[2019-02-14 14:09:28] [ global always ] Installation was started at 2019-02-14 13:09:07, completed at 2019
-02-14 13:09:28
[2019-09-17 09:47:03] [ global always ] Spawning background process: /bin/php '/usr/share/cacti/install/ba


the last error whas this error to the change of the key on a table, but can't find what it was, some UTF8 code.
So how can I restart the process or find what is the problem ?
CentOS
Production
Cacti 0.8.8h
Spine 0.8.8h
PIA 3.1
Aggregate 0.75
Monitor 1.3
Settings 0.71
Weathermap 0.98
Thold 0.5
rrdclean 0.41

Own plugin: LinkDiscovery 0.45, Map 0.37

Test
Cacti 1.2.6
Spine 1.2.6
thold 1.0.6
monitor 2.3.5
php 7.2.11
mariadb 5.5.56
Own plugin:
ExtendDB 1.1.2
LinkDiscovery 1.2.6
Map 1.2.6

netniV
Cacti Guru User
Posts: 2868
Joined: Sun Aug 27, 2017 12:05 am

Re: Issue when upgrading to 1.2.6 from 1.2

#2 Post by netniV » Wed Sep 18, 2019 2:25 am

Well, this looks like a path usage issue... you claim to be upgrading to 1.2.6 yet the upgrade process clearly states that it only upgraded to 1.2.1. Do you have multiple copies of cacti around?

Rno
Cacti User
Posts: 345
Joined: Wed Dec 07, 2011 9:19 am

Re: Issue when upgrading to 1.2.6 from 1.2

#3 Post by Rno » Wed Sep 18, 2019 2:36 am

Sorry I put only part of the install-general.log, and only where the error start to appear

so here is the full one:

[2018-10-25 16:05:35] [ always ] Spawning background process: /bin/php /usr/share/cacti/install/background.php 1540
476335.0041
[2018-10-25 16:05:35] [ always ] Setting PHP Option max_execution_time = 0
[2018-10-25 16:05:35] [ always ] Setting PHP Option memory_limit = -1
[2018-10-25 16:05:52] [ always ] Starting INSTALL Process for v1.2.0
[2018-10-25 16:05:53] [ always ] Found 109 tables to convert
[2018-10-25 16:05:54] [ always ] Converting Table #1 'aggregate_graphs'
[2018-10-25 16:06:00] [ always ] Converting Table #2 'aggregate_graphs_graph_item'
[2018-10-25 16:06:04] [ always ] Converting Table #3 'aggregate_graphs_items'
[2018-10-25 16:06:08] [ always ] Converting Table #4 'aggregate_graph_templates'
[2018-10-25 16:06:12] [ always ] Converting Table #5 'aggregate_graph_templates_graph'
[2018-10-25 16:06:15] [ always ] Converting Table #6 'aggregate_graph_templates_item'
[2018-10-25 16:06:21] [ always ] Converting Table #7 'automation_devices'
[2018-10-25 16:06:27] [ always ] Converting Table #8 'automation_graph_rules'
[2018-10-25 16:06:30] [ always ] Converting Table #9 'automation_graph_rule_items'
[2018-10-25 16:06:33] [ always ] Converting Table #10 'automation_ips'
[2018-10-25 16:06:36] [ always ] Converting Table #11 'automation_match_rule_items'
[2018-10-25 16:06:40] [ always ] Converting Table #12 'automation_networks'
[2018-10-25 16:06:45] [ always ] Converting Table #13 'automation_processes'
[2018-10-25 16:06:49] [ always ] Converting Table #14 'automation_snmp'
[2018-10-25 16:06:49] [ always ] Converting Table #15 'automation_snmp_items'
[2018-10-25 16:06:49] [ always ] Converting Table #16 'automation_templates'
[2018-10-25 16:06:49] [ always ] Converting Table #17 'automation_tree_rules'
[2018-10-25 16:06:49] [ always ] Converting Table #18 'automation_tree_rule_items'
[2018-10-25 16:06:49] [ always ] Converting Table #19 'cdef'
[2018-10-25 16:06:50] [ always ] Converting Table #20 'cdef_items'
[2018-10-25 16:06:50] [ always ] Converting Table #21 'colors'
[2018-10-25 16:06:50] [ always ] Converting Table #22 'color_templates'
[2018-10-25 16:06:50] [ always ] Converting Table #23 'color_template_items'
[2018-10-25 16:06:50] [ always ] Converting Table #24 'data_debug'
[2018-10-25 16:06:50] [ always ] Converting Table #25 'data_input'
[2018-10-25 16:06:51] [ always ] Converting Table #26 'data_input_data'
[2018-10-25 16:06:51] [ always ] Converting Table #27 'data_input_fields'
[2018-10-25 16:06:51] [ always ] Converting Table #28 'data_local'
[2018-10-25 16:06:51] [ always ] Converting Table #29 'data_source_profiles'
[2018-10-25 16:06:51] [ always ] Converting Table #30 'data_source_profiles_cf'
[2018-10-25 16:06:51] [ always ] Converting Table #31 'data_source_profiles_rra'
[2018-10-25 16:06:51] [ always ] Converting Table #32 'data_source_purge_action'
[2018-10-25 16:06:52] [ always ] Converting Table #33 'data_source_purge_temp'
[2018-10-25 16:06:52] [ always ] Converting Table #34 'data_source_stats_daily'
[2018-10-25 16:06:52] [ always ] Converting Table #35 'data_source_stats_hourly'
[2018-10-25 16:06:52] [ always ] Converting Table #36 'data_source_stats_hourly_cache'
[2018-10-25 16:06:52] [ always ] Converting Table #37 'data_source_stats_hourly_last'
[2018-10-25 16:06:52] [ always ] Converting Table #38 'data_source_stats_monthly'
[2018-10-25 16:06:53] [ always ] Converting Table #39 'data_source_stats_weekly'
[2018-10-25 16:06:53] [ always ] Converting Table #40 'data_source_stats_yearly'
[2018-10-25 16:06:53] [ always ] Converting Table #41 'data_template'
[2018-10-25 16:06:53] [ always ] Converting Table #42 'data_template_data'
[2018-10-25 16:06:53] [ always ] Converting Table #43 'data_template_rrd'
[2018-10-25 16:06:53] [ always ] Converting Table #44 'external_links'
[2018-10-25 16:06:54] [ always ] Converting Table #45 'graph_local'
[2018-10-25 16:06:54] [ always ] Converting Table #46 'graph_templates'
[2018-10-25 16:06:54] [ always ] Converting Table #47 'graph_templates_gprint'
[2018-10-25 16:06:57] [ always ] Converting Table #48 'graph_templates_graph'
[2018-10-25 16:07:03] [ always ] Converting Table #49 'graph_templates_item'
[2018-10-25 16:07:09] [ always ] Converting Table #50 'graph_template_input'
[2018-10-25 16:07:14] [ always ] Converting Table #51 'graph_template_input_defs'
[2018-10-25 16:07:20] [ always ] Converting Table #52 'graph_tree'
[2018-10-25 16:07:26] [ always ] Converting Table #53 'graph_tree_items'
[2018-10-25 16:07:32] [ always ] Converting Table #54 'host'
[2018-10-25 16:07:41] [ always ] Converting Table #55 'host_graph'
[2018-10-25 16:07:47] [ always ] Converting Table #56 'host_snmp_cache'
[2018-10-25 16:07:52] [ always ] Converting Table #57 'host_snmp_query'
[2018-10-25 16:07:57] [ always ] Converting Table #58 'host_template'
[2018-10-25 16:08:04] [ always ] Converting Table #59 'host_template_graph'
[2018-10-25 16:08:13] [ always ] Converting Table #60 'host_template_snmp_query'
[2018-10-25 16:08:20] [ always ] Converting Table #61 'plugin_config'
[2018-10-25 16:08:29] [ always ] Converting Table #62 'plugin_db_changes'
[2018-10-25 16:08:34] [ always ] Converting Table #63 'plugin_hooks'
[2018-10-25 16:08:43] [ always ] Converting Table #64 'plugin_realms'
[2018-10-25 16:08:48] [ always ] Converting Table #65 'poller'
[2018-10-25 16:08:57] [ always ] Converting Table #66 'poller_command'
[2018-10-25 16:09:02] [ always ] Converting Table #67 'poller_data_template_field_mappings'
[2018-10-25 16:09:07] [ always ] Converting Table #68 'poller_item'
[2018-10-25 16:09:13] [ always ] Converting Table #69 'poller_output'
[2018-10-25 16:09:19] [ always ] Converting Table #70 'poller_output_boost'
[2018-10-25 16:09:24] [ always ] Converting Table #71 'poller_output_boost_processes'
[2018-10-25 16:09:30] [ always ] Converting Table #72 'poller_output_realtime'
[2018-10-25 16:09:36] [ always ] Converting Table #73 'poller_reindex'
[2018-10-25 16:09:43] [ always ] Converting Table #74 'poller_resource_cache'
[2018-10-25 16:09:49] [ always ] Converting Table #75 'poller_time'
[2018-10-25 16:09:56] [ always ] Converting Table #76 'reports'
[2018-10-25 16:10:01] [ always ] Converting Table #77 'reports_items'
[2018-10-25 16:10:06] [ always ] Converting Table #78 'sessions'
[2018-10-25 16:10:09] [ always ] Converting Table #79 'settings'
[2018-10-25 16:10:11] [ always ] Converting Table #80 'settings_tree'
[2018-10-25 16:10:15] [ always ] Converting Table #81 'settings_user'
[2018-10-25 16:10:20] [ always ] Converting Table #82 'settings_user_group'
[2018-10-25 16:10:24] [ always ] Converting Table #83 'sites'
[2018-10-25 16:10:25] [ always ] Converting Table #84 'snmpagent_cache'
[2018-10-25 16:10:26] [ always ] Converting Table #85 'snmpagent_cache_notifications'
[2018-10-25 16:10:27] [ always ] Converting Table #86 'snmpagent_cache_textual_conventions'
[2018-10-25 16:10:27] [ always ] Converting Table #87 'snmpagent_managers'
[2018-10-25 16:10:27] [ always ] Converting Table #88 'snmpagent_managers_notifications'
[2018-10-25 16:10:27] [ always ] Converting Table #89 'snmpagent_mibs'
[2018-10-25 16:10:27] [ always ] Converting Table #90 'snmpagent_notifications_log'
[2018-10-25 16:10:27] [ always ] Converting Table #91 'snmp_query'
[2018-10-25 16:10:28] [ always ] Converting Table #92 'snmp_query_graph'
[2018-10-25 16:10:28] [ always ] Converting Table #93 'snmp_query_graph_rrd'
[2018-10-25 16:10:28] [ always ] Converting Table #94 'snmp_query_graph_rrd_sv'
[2018-10-25 16:10:28] [ always ] Converting Table #95 'snmp_query_graph_sv'
[2018-10-25 16:10:28] [ always ] Converting Table #96 'user_auth'
[2018-10-25 16:10:28] [ always ] Converting Table #97 'user_auth_cache'
[2018-10-25 16:10:29] [ always ] Converting Table #98 'user_auth_group'
[2018-10-25 16:10:29] [ always ] Converting Table #99 'user_auth_group_members'
[2018-10-25 16:10:29] [ always ] Converting Table #100 'user_auth_group_perms'
[2018-10-25 16:10:29] [ always ] Converting Table #101 'user_auth_group_realm'
[2018-10-25 16:10:29] [ always ] Converting Table #102 'user_auth_perms'
[2018-10-25 16:10:29] [ always ] Converting Table #103 'user_auth_realm'
[2018-10-25 16:10:29] [ always ] Converting Table #104 'user_domains'
[2018-10-25 16:10:30] [ always ] Converting Table #105 'user_domains_ldap'
[2018-10-25 16:10:30] [ always ] Converting Table #106 'user_log'
[2018-10-25 16:10:30] [ always ] Converting Table #107 'vdef'
[2018-10-25 16:10:30] [ always ] Converting Table #108 'vdef_items'
[2018-10-25 16:10:30] [ always ] Converting Table #109 'version'
[2018-10-25 16:10:30] [ always ] Found 4 templates to install
[2018-10-25 16:10:30] [ always ] Importing Package #1 'Cisco_Router.xml.gz' under Profile '1'
[2018-10-25 16:11:14] [ always ] Importing Package #2 'Generic_SNMP_Device.xml.gz' under Profile '1'
[2018-10-25 16:11:55] [ always ] Importing Package #3 'Local_Linux_Machine.xml.gz' under Profile '1'
[2018-10-25 16:12:48] [ always ] Importing Package #4 'NetSNMP_Device.xml.gz' under Profile '1'
[2018-10-25 16:13:22] [ always ] Mapping Automation Template for Device Template 'Net-SNMP Device'
[2018-10-25 16:13:22] [ always ] Mapping Automation Template for Device Template 'Cisco Router'
[2018-10-25 16:13:22] [ always ] Updating automation network (1), mode "on" => "", subnet "192.168.1.0/24" => 192.1
68.1.0/24"
[2018-10-25 16:13:22] [ always ] Device Template for First Cacti Device is 3
[2018-10-25 16:13:23] [ always ] Creating Graphs for Default Device
[2018-10-25 16:13:23] [ always ] Adding Device to Default Tree
[2018-10-25 16:13:23] [ always ] Repopulating poller cache
[2018-10-25 16:13:23] [ always ] Repopulating SNMP Agent cache
[2018-10-25 16:13:23] [ always ] Generating RSA Key Pair
[2018-10-25 16:13:23] [ always ] Finished INSTALL Process for v1.2.0
[2018-10-25 16:13:23] [ always ] Installation was started at 2018-10-25 14:05:35, completed at 2018-10-25 14:13:23
[2019-02-14 14:09:07] [ always ] Spawning background process: /bin/php /usr/share/cacti/install/background.php 1550
149746.8966
[2019-02-14 14:09:07] [ always ] Setting PHP Option max_execution_time = 0
[2019-02-14 14:09:07] [ always ] Setting PHP Option memory_limit = -1
[2019-02-14 14:09:22] [ always ] Starting UPGRADE Process for v1.2.1
[2019-02-14 14:09:23] [ always ] No tables where found or selected for conversion
[2019-02-14 14:09:24] [ always ] Switched from to /tmp/cdubeDUmb
[2019-02-14 14:09:24] [ always ] NOTE: Using temporary file for db cache: /tmp/cdubeDUmb
[2019-02-14 14:09:24] [ always ] Upgrading from v1.2.0 (DB 1.2.1 (DB: 1.2.0)) to v1.2.1
[2019-02-14 14:09:27] [ always ] Finished UPGRADE Process for v1.2.1
[2019-02-14 14:09:27] [ always ] WARNING: One or more upgrades failed to install correctly
[2019-02-14 14:09:28] [ always ] Installation was started at 2019-02-14 13:09:07, completed at 2019-02-14 13:09:28
[2019-09-17 09:47:03] [ always ] Spawning background process: /bin/php '/usr/share/cacti/install/background.php' 15
68706422.7711
[2019-09-17 09:47:03] [ always ] Setting PHP Option max_execution_time = 0
[2019-09-17 09:47:03] [ always ] Setting PHP Option memory_limit = -1
[2019-09-17 09:47:20] [ always ] Starting UPGRADE Process for v1.2.6
[2019-09-17 09:47:21] [ always ] No tables where found or selected for conversion
[2019-09-17 09:47:22] [ always ] Switched from to /tmp/cdujDAgut
[2019-09-17 09:47:22] [ always ] NOTE: Using temporary file for db cache: /tmp/cdujDAgut
[2019-09-17 09:47:22] [ always ] Upgrading from v1.2.1 (DB 1.2.6 (DB: 1.2.1)) to v1.2.2
[2019-09-17 09:47:26] [ always ] Upgrading from v1.2.2 (DB 1.2.2) to v1.2.3
[2019-09-17 09:47:35] [ always ] Upgrading from v1.2.3 (DB 1.2.3) to v1.2.5
[2019-09-17 09:47:39] [ always ] Repairing Automation Rules
[2019-09-17 09:47:44] [ always ] Finished UPGRADE Process for v1.2.6
[2019-09-17 09:47:53] [ always ] WARNING: One or more upgrades failed to install correctly
[2019-09-17 09:48:00] [ always ] Installation was started at 2019-09-17 07:47:03, completed at 2019-09-17 07:47:59
CentOS
Production
Cacti 0.8.8h
Spine 0.8.8h
PIA 3.1
Aggregate 0.75
Monitor 1.3
Settings 0.71
Weathermap 0.98
Thold 0.5
rrdclean 0.41

Own plugin: LinkDiscovery 0.45, Map 0.37

Test
Cacti 1.2.6
Spine 1.2.6
thold 1.0.6
monitor 2.3.5
php 7.2.11
mariadb 5.5.56
Own plugin:
ExtendDB 1.1.2
LinkDiscovery 1.2.6
Map 1.2.6

netniV
Cacti Guru User
Posts: 2868
Joined: Sun Aug 27, 2017 12:05 am

Re: Issue when upgrading to 1.2.6 from 1.2

#4 Post by netniV » Wed Sep 18, 2019 7:45 am

What is in that temporary file? Does it still exist? For some systems, the /tmp/ folder is mapped when run under Apache/Nginx to another location so it may not be just in /tmp/ but something like /tmp/SomeDirectoryName-/blahblahblah/tmp/

Rno
Cacti User
Posts: 345
Joined: Wed Dec 07, 2011 9:19 am

Re: Issue when upgrading to 1.2.6 from 1.2

#5 Post by Rno » Wed Sep 18, 2019 11:14 am

I'm unable to find that directory.

it shold be under /var/tmp, but I got those:
drwx------. 3 root root 16 Sep 17 10:44 systemd-private-3d3d9bdd21f94875811a4edbcfdb3dfd-httpd.service-fwlB4u
drwx------. 3 root root 16 Sep 17 10:44 systemd-private-3d3d9bdd21f94875811a4edbcfdb3dfd-httpd.service-Tkp1eX
drwx------. 3 root root 16 Sep 17 10:44 systemd-private-3d3d9bdd21f94875811a4edbcfdb3dfd-mariadb.service-DtDTbU
drwx------. 3 root root 16 Sep 17 10:44 systemd-private-3d3d9bdd21f94875811a4edbcfdb3dfd-mariadb.service-rOVqIq
drwx------. 3 root root 16 Sep 17 10:44 systemd-private-3d3d9bdd21f94875811a4edbcfdb3dfd-ntpd.service-7J66U2
drwx------. 3 root root 16 Sep 17 10:44 systemd-private-3d3d9bdd21f94875811a4edbcfdb3dfd-ntpd.service-hnzEYA
drwx------. 3 root root 16 Sep 17 17:06 systemd-private-e9826af826c848edb10aa0c9b1bb188c-httpd.service-9tSh5u
drwx------. 3 root root 16 Sep 17 17:06 systemd-private-e9826af826c848edb10aa0c9b1bb188c-httpd.service-wqI6uQ
drwx------. 3 root root 16 Sep 17 16:59 systemd-private-e9826af826c848edb10aa0c9b1bb188c-mariadb.service-a3SC3i
drwx------. 3 root root 16 Sep 17 16:59 systemd-private-e9826af826c848edb10aa0c9b1bb188c-mariadb.service-ldGyPT
drwx------. 3 root root 16 Sep 17 16:59 systemd-private-e9826af826c848edb10aa0c9b1bb188c-ntpd.service-4y4G3I
drwx------. 3 root root 16 Sep 17 16:59 systemd-private-e9826af826c848edb10aa0c9b1bb188c-ntpd.service-9HMHYm
CentOS
Production
Cacti 0.8.8h
Spine 0.8.8h
PIA 3.1
Aggregate 0.75
Monitor 1.3
Settings 0.71
Weathermap 0.98
Thold 0.5
rrdclean 0.41

Own plugin: LinkDiscovery 0.45, Map 0.37

Test
Cacti 1.2.6
Spine 1.2.6
thold 1.0.6
monitor 2.3.5
php 7.2.11
mariadb 5.5.56
Own plugin:
ExtendDB 1.1.2
LinkDiscovery 1.2.6
Map 1.2.6

netniV
Cacti Guru User
Posts: 2868
Joined: Sun Aug 27, 2017 12:05 am

Re: Issue when upgrading to 1.2.6 from 1.2

#6 Post by netniV » Thu Sep 19, 2019 1:04 pm

It will be under one of those httpd directories more than likely

Rno
Cacti User
Posts: 345
Joined: Wed Dec 07, 2011 9:19 am

Re: Issue when upgrading to 1.2.6 from 1.2

#7 Post by Rno » Fri Sep 20, 2019 5:17 am

all http directory has a tmp directory, but it's empty
CentOS
Production
Cacti 0.8.8h
Spine 0.8.8h
PIA 3.1
Aggregate 0.75
Monitor 1.3
Settings 0.71
Weathermap 0.98
Thold 0.5
rrdclean 0.41

Own plugin: LinkDiscovery 0.45, Map 0.37

Test
Cacti 1.2.6
Spine 1.2.6
thold 1.0.6
monitor 2.3.5
php 7.2.11
mariadb 5.5.56
Own plugin:
ExtendDB 1.1.2
LinkDiscovery 1.2.6
Map 1.2.6

Post Reply