[2025/09/11 11:15:46 +0200] discovery.php(14942): ====== Schema update 502 -> 503 ==============
[2025/09/11 11:15:46 +0200] discovery.php(14942): Query: CREATE TABLE IF NOT EXISTS `stp_vlan_map` (`device_id` INT UNSIGNED NOT NULL, `vlan_vlan` INT UNSIGNED NOT NULL, `stp_instance_id` INT UNSIGNED NOT NULL, PRIMARY KEY (`device_id`,`vlan_vlan`), KEY
`stp_instance_id` (`stp_instance_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;-- STP schema enhancements: admin_enable flag, regional_root and alternate root info
ALTER TABLE `stp_ports` ADD COLUMN `admin_enable` TINYINT(1) DEFAULT NULL AFTER `base_port`;
[2025/09/11 11:15:46 +0200] discovery.php(14942): Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ALTER TABLE `stp_ports` ADD COLUMN `admin_enable` TINYINT(1)
DEFAULT NULL AF...' at line 2
[2025/09/11 11:15:52 +0200] discovery.php(14942): ====== Schema update 509 -> 510 ==============
[2025/09/11 11:15:52 +0200] discovery.php(14942): Query: ALTER TABLE `probe_metrics` CHANGE `metric_label` `metric_label` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, CHANGE `metric_rrd` `metric_rrd` VARCHAR(255) CHARACTER SET
latin1 COLLATE latin1_general_ci NOT NULL, CHANGE `metric_type` `metric_type` ENUM('GAUGE','COUNTER') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'GAUGE', CHANGE `metric_uom` `metric_uom` VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_general_ci
NULL DEFAULT NULL;
[2025/09/11 11:15:52 +0200] discovery.php(14942): Error: (1054) Unknown column 'metric_rrd' in 'probe_metrics'
It's pretty old server and i need to migrate it asap:
o PHP 7.4.33
o MariaDB 10.5.26-MariaDB (extension: mysqli 7.4.33)
Am Donnerstag, dem 11.09.2025 um 16:11 +0200 schrieb Mike Stupalov:
This error is not critical,
but to understand what the reason, write additional information:
- versions
./discovery.php -VV
- last schema update error
tail -n 10 /opt/observium/logs/update-errors.log
Wiethoff, Helge via observium wrote on 11.09.2025 11:20:
I'm experiencing an issue with the SQL schema update process and would
appreciate your guidance.
The schema update from version 509 to 510 is failing during the
discovery process. Here's the output I'm seeing:
./discovery.php -h none
-- ....
509 -> 510 # (db) (Column collations were changed from UTF-8 to Latin1
where it wasn't actually necessary)...........F. Done (6s, 1 errors).
-- Done.
-- Observium is up to date.
Has anyone encountered this issue before? Any insights or
recommendations would be much appreciated.
Best
Helge
_______________________________________________
observium mailing list -- observium@lists.observium.org
To unsubscribe send an email to observium-leave@lists.observium.org