search

Cacti / plugin_monitor

Monitor Plugin for Cacti
GNU General Public License v2.0
36 stars 39 forks source link

1.2.21 monitor_text doesn't have a default value #150

Closed eschoeller closed 1 year ago

eschoeller commented 2 years ago

I've had these errors for over a year now. I upgraded from 1.2.18 to 1.2.21 hoping they would go away. Sadly, they are still here. Things appear to be running "fine" but I don't understand why remote pollers keep spitting this message out. Surely it's some old cruft in my database messing this up?

SPINE: Poller[2] PID[41917] PT[140115322102016] ERROR: SQL Failed! Error:'1364', Message:'Field 'monitor_text' doesn't have a default value', SQL Fragment:'INSERT INTO host (id, snmp_sysDescr, snmp_sysObjectID, snmp_sysUpTimeInstance, snmp_sysContact, snmp_sysName, snmp_sysLocation, status, status_event_count, status_fail_date, status_rec_date, status_last_error, min_time, max_time, cur_time, avg_time, polling_time, total_polls, failed_polls, availability, last_updated)

netniV commented 2 years ago

So this is becaus there is a field that is present on the host table from the monitor plugin. It's not a Cacti core bug but more a monitor one for not having a default value for a field that has been additionally added during setup

The field definition according to the latest setup file should be:

name type default null
monitor_text varchar(1024) [blank string] false

This would force the monitor_text to be blank during a new insert of a host. it sounds like your field doesn't have that default value of a blank string.

TheWitness commented 2 years ago

This should be transferred to the monitor plugin issue tracker.

TheWitness commented 1 year ago

This is resolved now. v2.6. Not released yet. Want to go through the bugs.