Issue with v1.2.8

[kklisa]

Hi guys!

I have a problem when cacti update to 1.2.8 version. Exactly the message is:
ALTER TABLE host_snmp_cache MODIFY COLUMN snmp_index VARCHAR(255) NOT NULL default "" [FAIL].

I try to do this command on mysql and I have the next message:
"ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes"

Can you help me?

Thanks and have a nice day!

[kklisa]

Hi guys,

I try to upgrade version to 1.2.10 and same error...

Thanks and have a nice day!

[Osiris]

You need to ensure that Barracuda is the default innodb file format, large prefix is enabled as well as file per table. Then there is a cli script you can run called convert_tables.php. Run it with the --dynamic and --innodb options. Then continue with the upgrade.

[kklisa]

You need to ensure that Barracuda is the default innodb file format, large prefix is enabled as well as file per table. Then there is a cli script you can run called convert_tables.php. Run it with the --dynamic and --innodb options. Then continue with the upgrade.

Hi Osiris,

How I can be sure if I have configured Barracuda? It is new for me and i am lost...

Thanks and have a nice day!

[Osiris]

Follow this article to the bottom, restart MySQL, then run the command as instructed.

https://stackoverflow.com/questions/358 ... rge-prefix