I noticed some strange behavior with alerts after doing a recent update. I have the Professional subscription.
I looked in the update-errors.log and saw many errors. Have not had any issues in many years so was surprised I mucked up the upgrade.
Looking for some direction on solving these issues. I'm comfortable using mysql and can make changes.
I attached the log. Nothing concerning in the other
Brian Repsher Sr. Staff QA Engineer
[cid:285d79db-05a0-4f56-8e19-72a0637d01d5] 2400 Ogden Ave Ste 180 Lisle IL 60503 Office: 847-561-8452
Are you running a new enough MySQL/mariadb?
You seem to be missing a collation.
Adam.
Sent from my iPhone
On 14 Oct 2026, at 20:15, Repsher, Brian via observium observium@lists.observium.org wrote:
I noticed some strange behavior with alerts after doing a recent update. I have the Professional subscription.
I looked in the update-errors.log and saw many errors. Have not had any issues in many years so was surprised I mucked up the upgrade.
Looking for some direction on solving these issues. I'm comfortable using mysql and can make changes.
I attached the log. Nothing concerning in the other
Brian Repsher Sr. Staff QA Engineer
<image.png> 2400 Ogden Ave Ste 180 Lisle IL 60503 Office: 847-561-8452 <update-errors.log> _______________________________________________ observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
This seems to be the problem, it's already fixed (it was fixed before you ran this).
[2026/10/09 20:25:54 +0000] discovery.php(2808760): ====== Initial schema install from db_schema_mysql.sql ============== [2026/10/09 20:25:54 +0000] discovery.php(2808760): Command: /usr/bin/mysql -u'observium' -p'***' -h'localhost' -D 'observium' < '/opt/observium/update/db_schema_mysql.sql' [2026/10/09 20:25:54 +0000] discovery.php(2808760): Exit code: 1 [2026/10/09 20:25:54 +0000] discovery.php(2808760): Runtime: 0.04216194152832 [2026/10/09 20:25:54 +0000] discovery.php(2808760): Error: -------------- CREATE TABLE `cache` ( `cache_key` varchar(255) NOT NULL, `cache_value` longtext, `cache_expires` timestamp NULL DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci --------------
ERROR 1273 (HY000) at line 529: Unknown collation: 'utf8mb4_0900_ai_ci'
This is mariadb vs mysql nonsense.
Is there any reason your install tried to insert a new database on the 9th? oO
It'll probably install correctly if you remove the database and run the current version of the code, but if you previously had a database, it seems to be gone.
adam.
Repsher, Brian via observium wrote on 2026-10-14 8:12 PM:
I noticed some strange behavior with alerts after doing a recent update. I have the Professional subscription.
I looked in the update-errors.log and saw many errors. Have not had any issues in many years so was surprised I mucked up the upgrade.
Looking for some direction on solving these issues. I'm comfortable using mysql and can make changes.
I attached the log. Nothing concerning in the other
Brian Repsher Sr. Staff QA Engineer
2400 Ogden Ave Ste 180 Lisle IL 60503 Office: 847-561-8452
observium mailing list -- observium@lists.observium.org To unsubscribe send an email to observium-leave@lists.observium.org
Thanks for the quick response. That's how this started, I inadvertently had the original DB dumped by installing mysql ( did a cut 'n paste with out checking first, bad sysadmin ). I will dump and install a new db. I want to follow up with the replies from Mike.
Thanks for your help, Brian
Hello,
this is was a first time install?
Not sure, you said "update", but I see "Initial schema install" at 2026/10/09 20:25
Show me your environment (versions) for Observium: ./discovery.php -VV
On 14.10.2026 21:12, Repsher, Brian via observium wrote:
I noticed some strange behavior with alerts after doing a recent update. I have the Professional subscription.
I looked in the update-errors.log and saw many errors. Have not had any issues in many years so was surprised I mucked up the upgrade.
Looking for some direction on solving these issues. I'm comfortable using mysql and can make changes.
I attached the log. Nothing concerning in the other
Brian Repsher Sr. Staff QA Engineer
2400 Ogden Ave Ste 180 Lisle IL 60503 Office: 847-561-8452
observium mailing list --observium@lists.observium.org To unsubscribe send an email toobservium-leave@lists.observium.org
Ahh,
From your update-errors.log, the update ran against an empty database.
It tried to install the initial schema and then replayed all updates on top of it, which explains the errors you see.
We have made a lot of changes across many Observium files recently.
If you ever edited any Observium files locally, for example includes/defaults.inc.php,
the update may have conflicted with those edits. That could have dropped your local database settings and other options.
This is only an assumption for now.
Could you please send us the output of:
svn status /opt/observium
Thanks.
On 14.10.2026 21:12, Repsher, Brian via observium wrote:
I noticed some strange behavior with alerts after doing a recent update. I have the Professional subscription.
I looked in the update-errors.log and saw many errors. Have not had any issues in many years so was surprised I mucked up the upgrade.
Looking for some direction on solving these issues. I'm comfortable using mysql and can make changes.
I attached the log. Nothing concerning in the other
Brian Repsher Sr. Staff QA Engineer
2400 Ogden Ave Ste 180 Lisle IL 60503 Office: 847-561-8452
observium mailing list --observium@lists.observium.org To unsubscribe send an email toobservium-leave@lists.observium.org
If you see my comments to Adam, I hosed the DB and tried to recover it. I included the output of the 2 commands.
The only customization I've done was to include support for chrony.
Let me know if there any issues with the currently installed instance.
[observium] borg (/opt/observium) > ./discovery.php -VV
##### Observium #####
o Version 26.10.15295 o Train stable o Released 7th October 2026 o Subscription User arrislisle470-770251
##### Software versions #####
o OS Linux 6.8.0-146-generic [amd64] (Ubuntu 24.04.5) o Apache 2.4.58 o PHP 8.3.6 o Python 3.12.3 o MariaDB 10.11.14-MariaDB-0ubuntu0.24.04.1 (client: MySQLnd 8.3.6) o SNMP NET-SNMP 5.9.4.pre2 o RRDtool 1.7.2 o Fping 5.1 (IPv4 and IPv6) o Fetch cURL 8.5.0 (OpenSSL/3.0.13, LibZ 1.3, LibIDN 2.3.7)
##### PHP info #####
o OPcache DISABLED o Memory Limit Unlimited o Math BCMATH
##### DB info #####
o DB schema 551 o MariaDB binlog OFF o MariaDB mode NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
##### Charset info #####
o PHP UTF-8 o MariaDB utf8mb3
##### Timezones info #####
o Date Thursday, 15-Oct-26 10:21:58 CDT o PHP -05:00 o MariaDB -05:00
[observium] borg (/opt/observium) > svn status /opt/observium ? /opt/observium/chrony-agent ? /opt/observium/html/images/an-logo-2.png ? /opt/observium/html/images/an-logo.png ? /opt/observium/html/pages/device/apps/chrony.inc.php M /opt/observium/includes/definitions/apps.inc.php ? /opt/observium/includes/definitions/apps.inc.php.orig M /opt/observium/includes/definitions/graphtypes.inc.php M /opt/observium/includes/definitions/rrdtypes.inc.php ? /opt/observium/includes/polling/applications/chrony.inc.php ? /opt/observium/observium ? /opt/observium/scripts/agent-local/chrony
participants (4)
-
Adam Armstrong -
brian.repsher＠auroranetworks.com -
Mike Stupalov -
Repsher, Brian