-
-
Notifications
You must be signed in to change notification settings - Fork 403
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Database Upgrade Failed from 1.2.3 to 1.2.5 #3300
Comments
Do you have large_prefix =1 in your my.cnf
…On Wed, Feb 26, 2020 at 8:08 AM jmcdomingues ***@***.***> wrote:
This is the error I've got after updating Cacti:
ALTER TABLE poller_output_realtime ROW_FORMAT=Dynamic, DROP PRIMARY KEY,
ADD PRIMARY KEY (local_data_id, rrd_name, time, poller_id)
Process Log
2020/02/26 12:39:13 - INSTALL: always: Installation was started at
2020-02-26 12:38:55, completed at 2020-02-26 12:39:13
2020/02/26 12:39:13 - INSTALL: always: WARNING: One or more upgrades
failed to install correctly
2020/02/26 12:39:13 - INSTALL: always: Finished UPGRADE Process for v1.2.9
2020/02/26 12:39:13 - INSTALL: always: Repairing Automation Rules
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.2.3 (DB 1.2.3) to
v1.2.5
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.2.2 (DB 1.2.2) to
v1.2.3
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.2.1 (DB 1.2.1) to
v1.2.2
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.2.0 (DB 1.2.0) to
v1.2.1
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.1.37 (DB 1.1.37)
to v1.2.0
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.1.36 (DB 1.1.36)
to v1.1.37
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.1.35 (DB 1.1.35)
to v1.1.36
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.1.34 (DB 1.1.34)
to v1.1.35
2020/02/26 12:39:12 - INSTALL: always: Upgrading from v1.1.31 (DB 1.1.31)
to v1.1.34
2020/02/26 12:39:12 - INSTALL: always: Upgrading from v1.1.28 (DB 1.1.28)
to v1.1.31
2020/02/26 12:39:12 - INSTALL: always: Upgrading from v1.1.26 (DB 1.1.26)
to v1.1.28
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.20 (DB 1.1.20)
to v1.1.26
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.17 (DB 1.1.17)
to v1.1.20
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.14 (DB 1.1.14)
to v1.1.17
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.11 (DB 1.1.11)
to v1.1.14
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.8 (DB 1.1.8) to
v1.1.11
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.7 (DB 1.1.7) to
v1.1.8
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.6 (DB 1.2.9
(DB: 1.1.6)) to v1.1.7
2020/02/26 12:39:11 - INSTALL: always: NOTE: Using temporary file for db
cache: /tmp/cduziuKzh
2020/02/26 12:39:11 - INSTALL: always: Switched from to /tmp/cduziuKzh
2020/02/26 12:39:11 - INSTALL: always: Converting Table #116
<#116> 'version'
2020/02/26 12:39:11 - INSTALL: always: Converting Table #115
<#115> 'vdef_items'
2020/02/26 12:39:11 - INSTALL: always: Converting Table #114
<#114> 'vdef'
2020/02/26 12:39:11 - INSTALL: always: Converting Table #113
<#113> 'user_log'
2020/02/26 12:39:11 - INSTALL: always: Converting Table #112
<#112> 'user_domains_ldap'
My server is:
CentOS 7
Thank you,
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#3300?email_source=notifications&email_token=ADGEXTBPDUXEYNI4H7R4W4TREZSVTA5CNFSM4K4E5IBKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4IQOB54A>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ADGEXTAAY3JMJ5EUQTUXT5DREZSVTANCNFSM4K4E5IBA>
.
--
Thank you
Sean Mancini,LBBIT
Owner/Principal Engineer
www.seanmancini.com
“Companies spend millions of dollars on firewalls, encryption, and secure
access devices, and it’s money wasted because none of these measures
address the weakest link in the security chain.”
*– Kevin Mitnick*
|
No. Do not even have that line. |
Put this line in your my.cnf and restart your mysql server |
Still the same! |
Have you restart myself after the change ? |
Yes I have. Even rebooted the server. |
Do I have to rerun something? |
Where did you put the line ?
that error Error: Specified key was too long; max key length is 767 bytes
means you dont have large prefixes enabled
…On Wed, Feb 26, 2020 at 11:12 AM jmcdomingues ***@***.***> wrote:
Do I have to rerun something?
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#3300?email_source=notifications&email_token=ADGEXTG27USLO4SLJBZ7A4TRE2IIRA5CNFSM4K4E5IBKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOENA3MMY#issuecomment-591509043>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ADGEXTA5MBWOGZXWVSV6QGLRE2IIRANCNFSM4K4E5IBA>
.
--
Thank you
Sean Mancini,LBBIT
Owner/Principal Engineer
www.seanmancini.com
“Companies spend millions of dollars on firewalls, encryption, and secure
access devices, and it’s money wasted because none of these measures
address the weakest link in the security chain.”
*– Kevin Mitnick*
|
here: " [mysqld_safe] .# |
change |
Still not working. |
Try to run the alter command manually
…On Wed., Feb. 26, 2020, 11:59 a.m. jmcdomingues, ***@***.***> wrote:
Still not working.
Did reboot server and accessed with Firefox in private mode, just to be
sure...
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#3300?email_source=notifications&email_token=ADGEXTD4WEN3R3UVUO4OBL3RE2NVPA5CNFSM4K4E5IBKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOENBBA4A#issuecomment-591532144>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ADGEXTH3U2LGEOSMP4YHZKDRE2NVPANCNFSM4K4E5IBA>
.
|
"Try to run the alter command manually" I do not have experience with SQL tables manipulation. |
Actually I see you are missing some things from your my.cnf You need to be using the barracuda file system innodb_file_format = Barracuda save the file |
Still not working! :( |
Now my file looks like this: [mysqld] [mysqld_safe] |
what error do you get now ? |
Today I have this: |
Looking into yesterday's logs, this is what I have: |
OK, you can ignore the poller errors. This is because you have a whole bunch of table converts going on, before the database upgrade has been done. As a result, your database is still at its pre-1.2.x state and yet 1.2.x code is trying to run. It's a known issue if you don't stop cron before performing an upgrade. But you can ignore that for now. |
So, can I do something for now? |
it looked like that the install was still going, it was converting tables? |
My file install-general.log has this final lines: |
Search the past issues for innodb_large_prefix, I think that will solve your problem. |
I've found one which it is recommended to run: MariaDB [cacti]> alter table host_snmp_cache row_format=dynamic; but still with the same error. Your Cacti Server v1.2.9 has been installed/updated with errors |
That could be because the installer was not able that. Run that command so
it returned the error
Are you able to login to cacti after the he upgrade?
May also want to clear your cookies and cache first
…On Tue., Mar. 3, 2020, 7:25 a.m. jmcdomingues, ***@***.***> wrote:
I've found one which it is recommended to run:
MariaDB [cacti]> alter table host_snmp_cache row_format=dynamic;
Query OK, 11150 rows affected (1.71 sec)
Records: 11150 Duplicates: 0 Warnings: 0
but still with the same error.
Your Cacti Server v1.2.9 has been installed/updated with errors
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#3300?email_source=notifications&email_token=ADGEXTGEDHMD53ORQXRLX43RFTZNFA5CNFSM4K4E5IBKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOENTJGQA#issuecomment-593924928>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ADGEXTEKLQCGHPEF52OXQFLRFTZNFANCNFSM4K4E5IBA>
.
|
There is row format and there is also the updating of the mysql configuration files. You appear to have only done the row format, double check you have done the other changes too. |
Here is my my.cnf [mysqld] [mysqld_safe] .# Using the recommended entries suggested earlier in this thread. |
Have you verified that the above configuration is actually active within MySQL? We have had instances where people have made configuration changes that haven't been active within MySQL for one reason or another (usually MySQL dislikes something that's being set). |
As far as I can see, yes it is. |
if you want to verify mysql is actually set to large prefix you can do the
following
mysql -u root -p
MariaDB [(none)]> show variables LIKE '%prefix%';
+------------------------------------------+-------+
| Variable_name | Value |
+------------------------------------------+-------+
| innodb_large_prefix | ON |
| innodb_prefix_index_cluster_optimization | OFF |
+------------------------------------------+-------+
to see which my.cnf is being used try the following
/usr/sbin/mysqld --verbose --help | grep -A 1 "Default options"
…On Wed, Mar 4, 2020 at 10:01 AM jmcdomingues ***@***.***> wrote:
As far as I can see, yes it is.
But can you tell me an effective way to check this?
I'm kinda new to MYSQL, so if you can elaborate a little more in your
answers I will be much obliged.
Thank you.
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#3300?email_source=notifications&email_token=ADGEXTGZIO3QG5HEQ3SW2V3RFZUMZA5CNFSM4K4E5IBKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOENYJCLQ#issuecomment-594579758>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ADGEXTD263VPWICN4P7G6A3RFZUMZANCNFSM4K4E5IBA>
.
--
Thank you
Sean Mancini,LBBIT
Owner/Principal Engineer
www.seanmancini.com
“Companies spend millions of dollars on firewalls, encryption, and secure
access devices, and it’s money wasted because none of these measures
address the weakest link in the security chain.”
*– Kevin Mitnick*
|
Thank you Sean. and I only have /etc/my.cnf. for the %prefix% So it is ok, I think! |
Can you give me more ideas, please? |
I am currently updating the installer upgrade routines so that every step is logged not just certain ones. In the mean time, can you email me a copy of your install-complete.log which should have more information. |
Please pull the 1.2.x branch and then copy over the current branch. Then, goto the MySQL prompt, run the following command: DELETE FROM settings WHERE name like 'install%'; After that, try to upgrade again. |
Hello Mark, here's the log file.
Thank you!
[2020-02-26 12:38:55] [ global always ] Spawning background process: /bin/php '/usr/share/cacti/install/background.php' 1582720735.4217
[2020-02-26 12:38:55] [ global always ] Setting PHP Option max_execution_time = 0
[2020-02-26 12:38:55] [ global always ] Setting PHP Option memory_limit = -1
[2020-02-26 12:38:55] [ global always ] Starting UPGRADE Process for v1.2.9
[2020-02-26 12:38:55] [ global always ] Found 116 tables to convert
[2020-02-26 12:38:55] [ global always ] Converting Table .#1 'aggregate_graph_templates'
[2020-02-26 12:38:56] [ global always ] Converting Table .#2 'aggregate_graph_templates_graph'
[2020-02-26 12:38:56] [ global always ] Converting Table .#3 'aggregate_graph_templates_item'
[2020-02-26 12:38:56] [ global always ] Converting Table .#4 'aggregate_graphs'
[2020-02-26 12:38:56] [ global always ] Converting Table .#5 'aggregate_graphs_graph_item'
[2020-02-26 12:38:56] [ global always ] Converting Table .#6 'aggregate_graphs_items'
[2020-02-26 12:38:56] [ global always ] Converting Table .#7 'automation_devices'
[2020-02-26 12:38:56] [ global always ] Converting Table .#8 'automation_graph_rule_items'
[2020-02-26 12:38:56] [ global always ] Converting Table .#9 'automation_graph_rules'
[2020-02-26 12:38:56] [ global always ] Converting Table .#10 'automation_ips'
[2020-02-26 12:38:57] [ global always ] Converting Table .#11 'automation_match_rule_items'
[2020-02-26 12:38:57] [ global always ] Converting Table .#12 'automation_networks'
[2020-02-26 12:38:57] [ global always ] Converting Table .#13 'automation_processes'
[2020-02-26 12:38:57] [ global always ] Converting Table .#14 'automation_snmp'
[2020-02-26 12:38:57] [ global always ] Converting Table .#15 'automation_snmp_items'
[2020-02-26 12:38:57] [ global always ] Converting Table .#16 'automation_templates'
[2020-02-26 12:38:57] [ global always ] Converting Table .#17 'automation_tree_rule_items'
[2020-02-26 12:38:57] [ global always ] Converting Table .#18 'automation_tree_rules'
[2020-02-26 12:38:57] [ global always ] Converting Table .#19 'cdef'
[2020-02-26 12:38:58] [ global always ] Converting Table .#20 'cdef_items'
[2020-02-26 12:38:58] [ global always ] Converting Table .#21 'color_template_items'
[2020-02-26 12:38:58] [ global always ] Converting Table .#22 'color_templates'
[2020-02-26 12:38:58] [ global always ] Converting Table .#23 'colors'
[2020-02-26 12:38:58] [ global always ] Converting Table .#24 'data_input'
[2020-02-26 12:38:58] [ global always ] Converting Table .#25 'data_input_data'
[2020-02-26 12:38:58] [ global always ] Converting Table .#26 'data_input_fields'
[2020-02-26 12:38:58] [ global always ] Converting Table .#27 'data_local'
[2020-02-26 12:38:59] [ global always ] Converting Table .#28 'data_source_profiles'
[2020-02-26 12:38:59] [ global always ] Converting Table .#29 'data_source_profiles_cf'
[2020-02-26 12:38:59] [ global always ] Converting Table .#30 'data_source_profiles_rra'
[2020-02-26 12:38:59] [ global always ] Converting Table .#31 'data_source_purge_action'
[2020-02-26 12:38:59] [ global always ] Converting Table .#32 'data_source_purge_temp'
[2020-02-26 12:38:59] [ global always ] Converting Table .#33 'data_source_stats_daily'
[2020-02-26 12:38:59] [ global always ] Converting Table .#34 'data_source_stats_hourly'
[2020-02-26 12:39:00] [ global always ] Converting Table .#35 'data_source_stats_hourly_cache'
[2020-02-26 12:39:00] [ global always ] Converting Table .#36 'data_source_stats_hourly_last'
[2020-02-26 12:39:00] [ global always ] Converting Table .#37 'data_source_stats_monthly'
[2020-02-26 12:39:00] [ global always ] Converting Table .#38 'data_source_stats_weekly'
[2020-02-26 12:39:00] [ global always ] Converting Table .#39 'data_source_stats_yearly'
[2020-02-26 12:39:00] [ global always ] Converting Table .#40 'data_template'
[2020-02-26 12:39:00] [ global always ] Converting Table .#41 'data_template_data'
[2020-02-26 12:39:00] [ global always ] Converting Table .#42 'data_template_rrd'
[2020-02-26 12:39:01] [ global always ] Converting Table .#43 'external_links'
[2020-02-26 12:39:01] [ global always ] Converting Table .#44 'graph_local'
[2020-02-26 12:39:01] [ global always ] Converting Table .#45 'graph_template_input'
[2020-02-26 12:39:01] [ global always ] Converting Table .#46 'graph_template_input_defs'
[2020-02-26 12:39:01] [ global always ] Converting Table .#47 'graph_templates'
[2020-02-26 12:39:01] [ global always ] Converting Table .#48 'graph_templates_gprint'
[2020-02-26 12:39:01] [ global always ] Converting Table .#49 'graph_templates_graph'
[2020-02-26 12:39:02] [ global always ] Converting Table .#50 'graph_templates_item'
[2020-02-26 12:39:02] [ global always ] Converting Table .#51 'graph_tree'
[2020-02-26 12:39:03] [ global always ] Converting Table .#52 'graph_tree_items'
[2020-02-26 12:39:03] [ global always ] Converting Table .#53 'host'
[2020-02-26 12:39:03] [ global always ] Converting Table .#54 'host_graph'
[2020-02-26 12:39:03] [ global always ] Converting Table .#55 'host_snmp_cache'
[2020-02-26 12:39:04] [ global always ] Converting Table .#56 'host_snmp_query'
[2020-02-26 12:39:04] [ global always ] Converting Table .#57 'host_template'
[2020-02-26 12:39:04] [ global always ] Converting Table .#58 'host_template_graph'
[2020-02-26 12:39:04] [ global always ] Converting Table .#59 'host_template_snmp_query'
[2020-02-26 12:39:04] [ global always ] Converting Table .#60 'plugin_config'
[2020-02-26 12:39:05] [ global always ] Converting Table .#61 'plugin_db_changes'
[2020-02-26 12:39:05] [ global always ] Converting Table .#62 'plugin_hooks'
[2020-02-26 12:39:05] [ global always ] Converting Table .#63 'plugin_notification_lists'
[2020-02-26 12:39:05] [ global always ] Converting Table .#64 'plugin_realms'
[2020-02-26 12:39:05] [ global always ] Converting Table .#65 'plugin_thold_contacts'
[2020-02-26 12:39:05] [ global always ] Converting Table .#66 'plugin_thold_host_failed'
[2020-02-26 12:39:05] [ global always ] Converting Table .#67 'plugin_thold_log'
[2020-02-26 12:39:05] [ global always ] Converting Table .#68 'plugin_thold_template_contact'
[2020-02-26 12:39:05] [ global always ] Converting Table .#69 'plugin_thold_threshold_contact'
[2020-02-26 12:39:06] [ global always ] Converting Table .#70 'poller'
[2020-02-26 12:39:06] [ global always ] Converting Table .#71 'poller_command'
[2020-02-26 12:39:06] [ global always ] Converting Table .#72 'poller_data_template_field_mappings'
[2020-02-26 12:39:06] [ global always ] Converting Table .#73 'poller_item'
[2020-02-26 12:39:06] [ global always ] Converting Table .#74 'poller_output'
[2020-02-26 12:39:06] [ global always ] Converting Table .#75 'poller_output_boost'
[2020-02-26 12:39:06] [ global always ] Converting Table .#76 'poller_output_boost_processes'
[2020-02-26 12:39:07] [ global always ] Converting Table .#77 'poller_output_realtime'
[2020-02-26 12:39:07] [ global always ] Converting Table .#78 'poller_reindex'
[2020-02-26 12:39:07] [ global always ] Converting Table .#79 'poller_resource_cache'
[2020-02-26 12:39:07] [ global always ] Converting Table .#80 'poller_time'
[2020-02-26 12:39:07] [ global always ] Converting Table .#81 'reports'
[2020-02-26 12:39:07] [ global always ] Converting Table .#82 'reports_items'
[2020-02-26 12:39:07] [ global always ] Converting Table .#83 'sessions'
[2020-02-26 12:39:07] [ global always ] Converting Table .#84 'settings'
[2020-02-26 12:39:07] [ global always ] Converting Table .#85 'settings_tree'
[2020-02-26 12:39:08] [ global always ] Converting Table .#86 'settings_user'
[2020-02-26 12:39:08] [ global always ] Converting Table .#87 'settings_user_group'
[2020-02-26 12:39:08] [ global always ] Converting Table .#88 'sites'
[2020-02-26 12:39:08] [ global always ] Converting Table .#89 'snmp_query'
[2020-02-26 12:39:08] [ global always ] Converting Table .#90 'snmp_query_graph'
[2020-02-26 12:39:08] [ global always ] Converting Table .#91 'snmp_query_graph_rrd'
[2020-02-26 12:39:08] [ global always ] Converting Table .#92 'snmp_query_graph_rrd_sv'
[2020-02-26 12:39:08] [ global always ] Converting Table .#93 'snmp_query_graph_sv'
[2020-02-26 12:39:08] [ global always ] Converting Table .#94 'snmpagent_cache'
[2020-02-26 12:39:09] [ global always ] Converting Table .#95 'snmpagent_cache_notifications'
[2020-02-26 12:39:09] [ global always ] Converting Table .#96 'snmpagent_cache_textual_conventions'
[2020-02-26 12:39:09] [ global always ] Converting Table .#97 'snmpagent_managers'
[2020-02-26 12:39:09] [ global always ] Converting Table .#98 'snmpagent_managers_notifications'
[2020-02-26 12:39:09] [ global always ] Converting Table .#99 'snmpagent_mibs'
[2020-02-26 12:39:09] [ global always ] Converting Table .#100 'snmpagent_notifications_log'
[2020-02-26 12:39:09] [ global always ] Converting Table .#101 'thold_data'
[2020-02-26 12:39:09] [ global always ] Converting Table .#102 'thold_template'
[2020-02-26 12:39:10] [ global always ] Converting Table .#103 'user_auth'
[2020-02-26 12:39:10] [ global always ] Converting Table .#104 'user_auth_cache'
[2020-02-26 12:39:10] [ global always ] Converting Table .#105 'user_auth_group'
[2020-02-26 12:39:10] [ global always ] Converting Table .#106 'user_auth_group_members'
[2020-02-26 12:39:10] [ global always ] Converting Table .#107 'user_auth_group_perms'
[2020-02-26 12:39:10] [ global always ] Converting Table .#108 'user_auth_group_realm'
[2020-02-26 12:39:10] [ global always ] Converting Table .#109 'user_auth_perms'
[2020-02-26 12:39:10] [ global always ] Converting Table .#110 'user_auth_realm'
[2020-02-26 12:39:10] [ global always ] Converting Table .#111 'user_domains'
[2020-02-26 12:39:11] [ global always ] Converting Table .#112 'user_domains_ldap'
[2020-02-26 12:39:11] [ global always ] Converting Table .#113 'user_log'
[2020-02-26 12:39:11] [ global always ] Converting Table .#114 'vdef'
[2020-02-26 12:39:11] [ global always ] Converting Table .#115 'vdef_items'
[2020-02-26 12:39:11] [ global always ] Converting Table .#116 'version'
[2020-02-26 12:39:11] [ global always ] Switched from to /tmp/cduziuKzh
[2020-02-26 12:39:11] [ global always ] NOTE: Using temporary file for db cache: /tmp/cduziuKzh
[2020-02-26 12:39:11] [ global always ] Upgrading from v1.1.6 (DB 1.2.9 (DB: 1.1.6)) to v1.1.7
[2020-02-26 12:39:11] [ global always ] Upgrading from v1.1.7 (DB 1.1.7) to v1.1.8
[2020-02-26 12:39:11] [ global always ] Upgrading from v1.1.8 (DB 1.1.8) to v1.1.11
[2020-02-26 12:39:11] [ global always ] Upgrading from v1.1.11 (DB 1.1.11) to v1.1.14
[2020-02-26 12:39:11] [ global always ] Upgrading from v1.1.14 (DB 1.1.14) to v1.1.17
[2020-02-26 12:39:11] [ global always ] Upgrading from v1.1.17 (DB 1.1.17) to v1.1.20
[2020-02-26 12:39:11] [ global always ] Upgrading from v1.1.20 (DB 1.1.20) to v1.1.26
[2020-02-26 12:39:12] [ global always ] Upgrading from v1.1.26 (DB 1.1.26) to v1.1.28
[2020-02-26 12:39:12] [ global always ] Upgrading from v1.1.28 (DB 1.1.28) to v1.1.31
[2020-02-26 12:39:12] [ global always ] Upgrading from v1.1.31 (DB 1.1.31) to v1.1.34
[2020-02-26 12:39:13] [ global always ] Upgrading from v1.1.34 (DB 1.1.34) to v1.1.35
[2020-02-26 12:39:13] [ global always ] Upgrading from v1.1.35 (DB 1.1.35) to v1.1.36
[2020-02-26 12:39:13] [ global always ] Upgrading from v1.1.36 (DB 1.1.36) to v1.1.37
[2020-02-26 12:39:13] [ global always ] Upgrading from v1.1.37 (DB 1.1.37) to v1.2.0
[2020-02-26 12:39:13] [ global always ] Upgrading from v1.2.0 (DB 1.2.0) to v1.2.1
[2020-02-26 12:39:13] [ global always ] Upgrading from v1.2.1 (DB 1.2.1) to v1.2.2
[2020-02-26 12:39:13] [ global always ] Upgrading from v1.2.2 (DB 1.2.2) to v1.2.3
[2020-02-26 12:39:13] [ global always ] Upgrading from v1.2.3 (DB 1.2.3) to v1.2.5
[2020-02-26 12:39:13] [ global always ] Repairing Automation Rules
[2020-02-26 12:39:13] [ global always ] Finished UPGRADE Process for v1.2.9
[2020-02-26 12:39:13] [ global always ] WARNING: One or more upgrades failed to install correctly
[2020-02-26 12:39:13] [ global always ] Installation was started at 2020-02-26 12:38:55, completed at 2020-02-26 12:39:13
—You are receiving this because you authored the thread.Reply to this email directly, view it on GitHub, or unsubscribe.
|
Thank you Jimmy, that solved the issue. Before being more radical I just gave the command you suggested and restarted the process. Made some of the recommended adjustments and restarted the process, and BAM! It worked with no more issues! :) |
This is the error I've got after updating Cacti:
ALTER TABLE poller_output_realtime ROW_FORMAT=Dynamic, DROP PRIMARY KEY, ADD PRIMARY KEY (local_data_id, rrd_name, time, poller_id)
Process Log
2020/02/26 12:39:13 - INSTALL: always: Installation was started at 2020-02-26 12:38:55, completed at 2020-02-26 12:39:13
2020/02/26 12:39:13 - INSTALL: always: WARNING: One or more upgrades failed to install correctly
2020/02/26 12:39:13 - INSTALL: always: Finished UPGRADE Process for v1.2.9
2020/02/26 12:39:13 - INSTALL: always: Repairing Automation Rules
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.2.3 (DB 1.2.3) to v1.2.5
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.2.2 (DB 1.2.2) to v1.2.3
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.2.1 (DB 1.2.1) to v1.2.2
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.2.0 (DB 1.2.0) to v1.2.1
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.1.37 (DB 1.1.37) to v1.2.0
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.1.36 (DB 1.1.36) to v1.1.37
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.1.35 (DB 1.1.35) to v1.1.36
2020/02/26 12:39:13 - INSTALL: always: Upgrading from v1.1.34 (DB 1.1.34) to v1.1.35
2020/02/26 12:39:12 - INSTALL: always: Upgrading from v1.1.31 (DB 1.1.31) to v1.1.34
2020/02/26 12:39:12 - INSTALL: always: Upgrading from v1.1.28 (DB 1.1.28) to v1.1.31
2020/02/26 12:39:12 - INSTALL: always: Upgrading from v1.1.26 (DB 1.1.26) to v1.1.28
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.20 (DB 1.1.20) to v1.1.26
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.17 (DB 1.1.17) to v1.1.20
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.14 (DB 1.1.14) to v1.1.17
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.11 (DB 1.1.11) to v1.1.14
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.8 (DB 1.1.8) to v1.1.11
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.7 (DB 1.1.7) to v1.1.8
2020/02/26 12:39:11 - INSTALL: always: Upgrading from v1.1.6 (DB 1.2.9 (DB: 1.1.6)) to v1.1.7
2020/02/26 12:39:11 - INSTALL: always: NOTE: Using temporary file for db cache: /tmp/cduziuKzh
2020/02/26 12:39:11 - INSTALL: always: Switched from to /tmp/cduziuKzh
2020/02/26 12:39:11 - INSTALL: always: Converting Table #116 'version'
2020/02/26 12:39:11 - INSTALL: always: Converting Table #115 'vdef_items'
2020/02/26 12:39:11 - INSTALL: always: Converting Table #114 'vdef'
2020/02/26 12:39:11 - INSTALL: always: Converting Table #113 'user_log'
2020/02/26 12:39:11 - INSTALL: always: Converting Table #112 'user_domains_ldap'
My server is:
CentOS 7
Thank you,
The text was updated successfully, but these errors were encountered: