Details
-
Bug
-
Resolution: Fixed
-
Major
-
None
-
Professional Edition
Description
Hello all,
Recently we detected, that going to "alert_checks" page, we get a blank page as response with 200 OK (tested with Firefox, Chrome, Edge).
We don't know after which upgrade this started to happen.
We are currently on 14324 version, from observium logs, the recent update errors are these:
/observium/logs# cat update-errors.log
|
|
|
[2025/09/04 13:47:41 +0200] discovery.php(3679276): ====== Schema update 502 -> 503 ============== |
[2025/09/04 13:47:41 +0200] discovery.php(3679276): 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/04 13:47:41 +0200] discovery.php(3679276): Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `stp_ports` ADD COLUMN `admin_enable` TINYINT(1) DEFAULT NULL AFTER' at line 2 |
|
On the Page "alerts" we can go without problem to:
- alert_log
- alert_maintenance
- syslog_alerts
- syslog_rules
- contacts
And in general, the alerts are working, because we receive email sof the checkers we had declared on the past.
But clicking on "alert_checks" transform all to a blank page.
From the apache logs all seems to be working ok.
On the mysql DB these are tables, we don't see the alert_checks table, is that expected?
mysql> show tables;
|
+-------------------------------+
|
| Tables_in_observium |
|
+-------------------------------+
|
| accesspoints |
|
| accesspoints-state |
|
| alert_assoc |
|
| alert_contacts |
|
| alert_contacts_assoc |
|
| alert_log |
|
| alert_table |
|
| alert_tests |
|
| alerts_maint |
|
| alerts_maint_assoc |
|
| api_tokens |
|
| applications |
|
| authlog |
|
| autodiscovery |
|
| bgpPeers |
|
| bgpPeers_cbgp |
|
| bill_data |
|
| bill_entities |
|
| bill_history |
|
| bills |
|
| cache |
|
| cef_prefix |
|
| cef_switching |
|
| config |
|
| counters |
|
| customers |
|
| dash_widgets |
|
| dashboards |
|
| device_graphs |
|
| devices |
|
| devices_locations |
|
| devices_mibs |
|
| discovery_perf_history |
|
| eigrp_ases |
|
| eigrp_peers |
|
| eigrp_ports |
|
| eigrp_vpns |
|
| entPhysical |
|
| entPhysical-state |
|
| entity_attribs |
|
| entity_permissions |
|
| eventlog |
|
| group_table |
|
| groups |
|
| groups_assoc |
|
| hrDevice |
|
| ip_mac |
|
| ipsec_tunnels |
|
| ipv4_addresses |
|
| ipv4_networks |
|
| ipv6_addresses |
|
| ipv6_networks |
|
| juniAtmVp |
|
| lb_pool_members |
|
| lb_pools |
|
| lb_snatpools |
|
| lb_virtuals |
|
| loadbalancer_rservers |
|
| loadbalancer_vservers |
|
| lsp |
|
| mac_accounting |
|
| mempools |
|
| munin_plugins |
|
| munin_plugins_ds |
|
| neighbours |
|
| netmaps |
|
| netscaler_servicegroupmembers |
|
| netscaler_services |
|
| netscaler_services_vservers |
|
| netscaler_vservers |
|
| notifications_queue |
|
| observium_actions |
|
| observium_attribs |
|
| observium_processes |
|
| oids |
|
| oids_entries |
|
| ospf_areas |
|
| ospf_instances |
|
| ospf_nbrs |
|
| ospf_ports |
|
| p2p_radios |
|
| packages |
|
| pollers |
|
| ports |
|
| ports_adsl |
|
| ports_cbqos |
|
| ports_stack |
|
| ports_vlans |
|
| printersupplies |
|
| probe_metrics |
|
| probes |
|
| processors |
|
| pseudowires |
|
| roles |
|
| roles_entity_permissions |
|
| roles_permissions |
|
| roles_users |
|
| sensors |
|
| services |
|
| slas |
|
| snmp_errors |
|
| status |
|
| storage |
|
| stp_bridge |
|
| stp_instances |
|
| stp_port_state_cache |
|
| stp_ports |
|
| stp_vlan_map |
|
| syslog |
|
| syslog_alerts |
|
| syslog_rules |
|
| syslog_rules_assoc |
|
| ucd_diskio |
|
| users |
|
| users_ckeys |
|
| users_prefs |
|
| vlans |
|
| vlans_fdb |
|
| vminfo |
|
| vrfs |
|
| weathermaps |
|
| wifi_accesspoints |
|
| wifi_aps |
|
| wifi_aps_members |
|
| wifi_radios |
|
| wifi_sessions |
|
| wifi_stations |
|
| wifi_wlans |
|
| winservices |
|
+-------------------------------+
|
129 rows in set (0.01 sec) |
|
Any clues or debugs we can enable to have an index of what is going on?
Thanks,
EM