DB errors showing up while creating alerts
Hi,
I'm not sure if my DB has become corrupted over time however, I am trying to configure a few alert checks and hitting these errors:
[2016/11/29 18:34:14 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '6' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:24 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'mempool_descr' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '32' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:24 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '32' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:35 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'mempool_descr' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '9' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:35 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '9' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:47 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'mempool_descr' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '1' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:47 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '1' AND `ifType` = 'ethernetCsmacd'
in the logs/db.log file.
Do I need to create the columns that it is asking for or is there something else that needs to be done?
Thanks.
Kaya
You have a "device" alert with "mempool_descr" as an association rule. This obviously isn't going to work.
adam.
Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] On 29/11/2016 23:01:18, Kaya Saman kayasaman@gmail.com wrote: Hi,
I'm not sure if my DB has become corrupted over time however, I am trying to configure a few alert checks and hitting these errors:
[2016/11/29 18:34:14 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '6' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:24 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'mempool_descr' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '32' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:24 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '32' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:35 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'mempool_descr' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '9' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:35 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '9' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:47 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'mempool_descr' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '1' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:47 +0000] discovery.php(68468): Failed dbQuery (#1054 - Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM `devices` WHERE device_id = '1' AND `ifType` = 'ethernetCsmacd'
in the logs/db.log file.
Do I need to create the columns that it is asking for or is there something else that needs to be done?
Thanks.
Kaya
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Oh ok.
So the association rules are specific:
http://www.observium.org/docs/alert_checker/
Gotcha... and fixed :-)
Thanks.
--K
On 11/30/2016 02:21 AM, Adam Armstrong wrote:
You have a "device" alert with "mempool_descr" as an association rule. This obviously isn't going to work.
adam.
Sent from Mailbird http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm_campaign=sent-from-mailbird
On 29/11/2016 23:01:18, Kaya Saman kayasaman@gmail.com wrote:
Hi,
I'm not sure if my DB has become corrupted over time however, I am trying to configure a few alert checks and hitting these errors:
[2016/11/29 18:34:14 +0000] discovery.php(68468): Failed dbQuery (#1054
- Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM
`devices` WHERE device_id = '6' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:24 +0000] discovery.php(68468): Failed dbQuery (#1054
- Unknown column 'mempool_descr' in 'where clause'), Query: SELECT *
FROM `devices` WHERE device_id = '32' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:24 +0000] discovery.php(68468): Failed dbQuery (#1054
- Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM
`devices` WHERE device_id = '32' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:35 +0000] discovery.php(68468): Failed dbQuery (#1054
- Unknown column 'mempool_descr' in 'where clause'), Query: SELECT *
FROM `devices` WHERE device_id = '9' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:35 +0000] discovery.php(68468): Failed dbQuery (#1054
- Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM
`devices` WHERE device_id = '9' AND `ifType` = 'ethernetCsmacd' [2016/11/29 18:34:47 +0000] discovery.php(68468): Failed dbQuery (#1054
- Unknown column 'mempool_descr' in 'where clause'), Query: SELECT *
FROM `devices` WHERE device_id = '1' AND IFNULL(`mempool_descr`, "") LIKE '%processor' [2016/11/29 18:34:47 +0000] discovery.php(68468): Failed dbQuery (#1054
- Unknown column 'ifType' in 'where clause'), Query: SELECT * FROM
`devices` WHERE device_id = '1' AND `ifType` = 'ethernetCsmacd'
in the logs/db.log file.
Do I need to create the columns that it is asking for or is there something else that needs to be done?
Thanks.
Kaya
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (2)
-
Adam Armstrong -
Kaya Saman