Details
-
Bug
-
Resolution: Not A Bug
-
Critical
-
None
-
Professional Edition
-
None
-
- Linux 3.13.0-35-generic #62-Ubuntu SMP Fri Aug 15 01:58:01 UTC 2014 i686 i686 i686 GNU/Linux
- Latest Pro Release
Description
Example error filling up ./observium/logs/db.log:
"[2017/01/30 16:12:59 -0500] syslog.php(2789): Failed dbQuery (#1054 - Unknown column 'host' in 'field list'), Query: INSERT INTO `syslog` (`device_id`,`host`,`program`,`facility`,`priority`,`level`,`tag`,`msg`,`timestamp`) VALUES ('79','esx02.domain.com','VPXA','local4','6','6','a6','[57D7DB90 verbose \\\'Default\\\' opID=WFU-f77a0a53] [VpxaHalServices] VmGuestDiskChange Event for vm(9) 92','2017-01-30 21:12:59')"
The Syslog table description from the Observium Database in MySQL:
mysql> describe syslog;
--------------------------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
--------------------------------------------------------------------+
| device_id | int(11) | YES | MUL | NULL | |
| facility | varchar(10) | YES | NULL | ||
| priority | tinyint(4) | NO | MUL | 8 | |
| level | tinyint(4) | NO | 8 | ||
| tag | varchar(10) | YES | NULL | ||
| timestamp | timestamp | NO | MUL | CURRENT_TIMESTAMP | |
| program | varchar(32) | YES | MUL | NULL | |
| msg | text | YES | NULL | ||
| seq | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
--------------------------------------------------------------------+
9 rows in set (0.01 sec)
mysql>
We can see from the error that the issue appears to be the missing "host" field in the syslog table of the observium database in MySQL. I attempted to update to the latest stable version of Observium PRO and it does not correct the issue.
This is spamming my logs and causing issues with disk space. At this time to work around it I have been deleting "./observium/logs/db.log".
- Adam