A couple of days ago this error stated coming in once an hour. The duplicate entry is the hostname of my librenms server. I dont know how a duplicate could have been created. I am no db admin and havent been in it.
pymysql.err.IntegrityError: (1062, “Duplicate entry ‘vm-umfs-librenms’ for key ‘pollers_poller_name_unique’”)
Here is the full output for the error.
https://p.libren.ms/view/9f674258
validate:
Component | Version |
---|---|
LibreNMS | 22.7.0-30-g3309750f3 |
DB Schema | 2022_07_19_081224_plugins_unique_index (244) |
PHP | 7.4.30 |
Python | 3.9.2 |
Database | MariaDB 10.5.15-MariaDB-0+deb11u1 |
RRDTool | 1.7.2 |
SNMP | 5.9 |
====================================
[OK] Composer Version: 2.3.10
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database Schema is current
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[OK]
[OK] Database schema correct
[OK] MySQl and PHP time match
[WARN] PHP version 8.1 is the minimum supported version as of September, 2022. We recommend you update PHP to a supported version (8.1 suggested) to continue to receive updates. If you do not update PHP, LibreNMS will continue to function but stop receiving bug fixes and updates.
[WARN] IPv6 is disabled on your server, you will not be able to add IPv6 devices.
[OK] rrd_dir is writable
[OK] rrdtool version ok