CREATE TABLE `poller_cluster_stats`

Hello,

I ran './validate.php
got this:

====================================

Component Version
LibreNMS 1.42.01-31-g9f04b58
DB Schema 258
PHP 7.1.19
MySQL 5.1.73
RRDTool 1.3.8
SNMP NET-SNMP 5.5

====================================

[OK] Composer Version: 1.7.1
[OK] Dependencies up-to-date.
string(397) "id int(11) NOT NULL auto_increment, parent_poller varchar(255) NOT NULL DEFAULT ‘’ , poller_type varchar(255) NOT NULL DEFAULT ‘’ , depth int(11) unsigned NOT NULL , devices int(11) unsigned NOT NULL , worker_seconds double unsigned NOT NULL , workers int(11) unsigned NOT NULL , frequency int(11) unsigned NOT NULL , PRIMARY KEY (parent_poller,poller_type), UNIQUE id (id)"
[OK] Database connection successful
[FAIL] Database: missing table (poller_cluster_stats)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
[FIX] Run the following SQL statements to fix.
SQL Statements:
CREATE TABLE poller_cluster_stats (id int(11) NOT NULL auto_increment, parent_poller varchar(255) NOT NULL DEFAULT ‘’ , poller_type varchar(255) NOT NULL DEFAULT ‘’ , depth int(11) unsigned NOT NULL , devices int(11) unsigned NOT NULL , worker_seconds double unsigned NOT NULL , workers int(11) unsigned NOT NULL , frequency int(11) unsigned NOT NULL , PRIMARY KEY (parent_poller,poller_type), UNIQUE id (id));

I get when I go to create the table -

mysql> use librenms;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>

CREATE TABLEpoller_cluster_stats(idint(11) NOT NULL auto_increment,parent_pollervarchar(255) NOT NULL DEFAULT '' ,poller_typevarchar(255) NOT NULL DEFAULT '' ,depthint(11) unsigned NOT NULL ,devicesint(11) unsigned NOT NULL ,worker_secondsdouble unsigned NOT NULL ,workersint(11) unsigned NOT NULL ,frequencyint(11) unsigned NOT NULL , PRIMARY KEY (parent_poller,poller_type), UNIQUEid(id));

ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

Work around?

MYSQL 5.3 does not support that. You can either upgrade mysql or if you don’t use distributed polling, you can just ignore this table.

@murrant

What would be the proper path to upgrade MySQL?

Thanks,

-Mike

That’s dependant on your distro but is really outside the scope of librenms and more just a general sysadmin style question