Threshold Plugin not sending emails

[cigamit]

Yes, and the other thold tables (just for good measure). You can have the import do the drop for you though.

Granted, 1st I have been trying to get you to actually run one of the failed SQL queries, as that will tell you what the problem is, but I haven't seen you do that yet.

[fiacchino]

I have tried that and i still get nothing in the new server thold tab. When i try to import the thold_template table i get

#1054 - Unknown column 'bl_enabled' in 'field list'

[cigamit]

You need to import the table structure also, and have the import script drop the table first (or you can do that manually yourself).

Specifically you will want to add the --add-drop-table flag to the mysqldump command.

[fiacchino]

after doing it that way i now get
05/06/2014 10:53:05 AM - SYSTEM THOLD STATS: Time:0.0015 Tholds:0 TotalHosts:422 DownHosts:25 NewDownHosts:0
05/06/2014 10:53:05 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"UPDATE thold_data SET tcheck=0'
05/06/2014 10:53:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT data_id, rra_id, lastread, cdef FROM thold_data WHERE thold_enabled='on' AND tcheck=1"


But thold tab is still empty as well as thresholds and templates

[cigamit]

It seems like it still didn't import the structure (now the table doesn't exist?). Can you run this query on the table?

Code: Select all

show columns from thold_data;

[fiacchino]

here is the output.

mysql> show columns from thold_data;
+--------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| rra_id | int(11) | NO | MUL | 0 | |
| data_id | int(11) | NO | MUL | 0 | |
| thold_hi | varchar(100) | YES | | NULL | |
| thold_low | varchar(100) | YES | | NULL | |
| thold_fail_trigger | int(10) unsigned | YES | | NULL | |
| thold_fail_count | int(11) | NO | | 0 | |
| thold_alert | int(1) | NO | | 0 | |
| thold_enabled | enum('on','off') | NO | MUL | on | |
| bl_enabled | enum('on','off') | NO | | off | |
| bl_ref_time | int(50) unsigned | YES | | NULL | |
| bl_ref_time_range | int(10) unsigned | YES | | NULL | |
| bl_pct_down | int(10) unsigned | YES | | NULL | |
| bl_pct_up | int(10) unsigned | YES | | NULL | |
| bl_fail_trigger | int(10) unsigned | YES | | NULL | |
| bl_fail_count | int(11) unsigned | YES | | NULL | |
| bl_alert | int(2) | NO | | 0 | |
| lastread | varchar(100) | YES | | NULL | |
| oldvalue | varchar(100) | NO | | | |
| repeat_alert | int(10) unsigned | YES | | NULL | |
| notify_default | enum('on','off') | YES | | NULL | |
| notify_extra | varchar(255) | YES | | NULL | |
| host_id | int(10) | YES | | NULL | |
| syslog_priority | int(2) | YES | | 3 | |
| cdef | int(11) | NO | | 0 | |
| template | int(11) | NO | MUL | 0 | |
| template_enabled | char(3) | NO | MUL | | |
+--------------------+------------------+------+-----+---------+----------------+
27 rows in set (0.00 sec)

[cigamit]

I thought you said you were running 0.4.9 on the old host? You are missing a ton of columns in that table.

Can you run that same command on the old host?

[fiacchino]

I upgraded it trying to fix it.

Below is output from old server that works.


mysql> show columns from thold_data;
+--------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| rra_id | int(11) | | MUL | 0 | |
| data_id | int(11) | | MUL | 0 | |
| thold_hi | varchar(100) | YES | | NULL | |
| thold_low | varchar(100) | YES | | NULL | |
| thold_fail_trigger | int(10) unsigned | YES | | NULL | |
| thold_fail_count | int(11) | | | 0 | |
| thold_alert | int(1) | | | 0 | |
| thold_enabled | enum('on','off') | | MUL | on | |
| bl_enabled | enum('on','off') | | | off | |
| bl_ref_time | int(50) unsigned | YES | | NULL | |
| bl_ref_time_range | int(10) unsigned | YES | | NULL | |
| bl_pct_down | int(10) unsigned | YES | | NULL | |
| bl_pct_up | int(10) unsigned | YES | | NULL | |
| bl_fail_trigger | int(10) unsigned | YES | | NULL | |
| bl_fail_count | int(11) unsigned | YES | | NULL | |
| bl_alert | int(2) | | | 0 | |
| lastread | varchar(100) | YES | | NULL | |
| oldvalue | varchar(100) | | | | |
| repeat_alert | int(10) unsigned | YES | | NULL | |
| notify_default | enum('on','off') | YES | | NULL | |
| notify_extra | varchar(255) | YES | | NULL | |
| host_id | int(10) | YES | | NULL | |
| syslog_priority | int(2) | YES | | 3 | |
| cdef | int(11) | | | 0 | |
| template | int(11) | | MUL | 0 | |
| template_enabled | char(3) | | MUL | | |
+--------------------+------------------+------+-----+---------+----------------+
27 rows in set (0.00 sec)

[simonlewinson]

Hi, I am having similar issues - thold tab hangs the server for nearly 2 minutes. I have checked the thold table and it has all of the columns. I have removed plugin, dropped all tables etc and reinstalled without any change.

Any thoughts?

Simon