Error: A template with that Data Source already exists!

[Diggit2001]

I just upgraded Cacti from 0.8.7b to 0.8.7e and now I am unable to create any threshold templates at all. I receive the error specified in the title of this post. After the upgrade of Cacti I also downloaded and installed all the latest updates to my plugins, including thold. I installed thold version 0.4.1.

I have seen a couple articles in the forums about this error, but they are all several years old and the edits to the database.php file don't seem to apply anymore.

Can anyone point me in the right direction? I'd appreciate the assistance.

Thanks
-Chris

[TheWitness]

You are missing a field more than likely in the thold_template table. This can cause that error. I don't install/uninstall thold. So, not sure which field it is.

TheWitness

[Diggit2001]

Hmm. OK, thanks for the info. Does anyone know of a way to (easily) verify/repair the table?


Thanks.
-Chris

[Diggit2001]

No worries. I just restored the database backup that I did before I upgraded Cacti to a different server and compared the fields from the old database to the new and added the 6 that were missing. All seems to be well now.

Thanks

[Diggit2001]

Guess I spoke too soon. Although I'm able to create threshold templates now and assign them to devices they don't seem to be working completely. They do show up on the tholds tab and they're reported correctly but I don't receive e-mails anymore like I used to. I have verified all of my e-mail settings and everything seems to be groovy. I do have lots of this in my logs:

03/04/2010 09:28:06 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"UPDATE thold_data, thold_template SET thold_data.thold_hi = thold_template.thold_hi, thold_data.thold_low = thold_template.thold_low, thold_data.thold_fail_trigger = thold_template.thold_fail_trigger, thold_data.time_hi = thold_template.time_hi, thold_data.time_low = thold_template.time_low, thold_data.time_fail_trigger = thold_template.time_fail_trigger, thold_data.time_fail_length = thold_template.time_fail_length, thold_data.thold_enabled = thold_template.thold_enabled, thold_data.thold_type = thold_template.thold_type, thold_data.bl_enabled = thold_template.bl_enabled, thold_data.bl_ref_time = thold_template.bl_ref_time, thold_data.bl_ref_time_range = thold_template.bl_ref_time_range, thold_data.bl_pct_down = thold_template.bl_pct_down, thold_data.bl_fail_trigger = thold_template.bl_fail_trigger, thold_data.bl_alert = thold_template.bl_alert, thold_data.repeat_alert = thold_template.repeat_alert, thold_data.notify_extra = thold_template.notify_extra, thold_data.data_type = thold_template.data_type, thold_data.cdef = thold_template.cdef, thold_data.percent_ds = thold_template.percent_ds, thold_data.exempt = thold_template.exempt, thold_data.data_template = thold_template.data_template_id, thold_data.restored_alert = thold_template.restored_alert WHERE thold_data.template=2 AND thold_data.template_enabled='on' AND thold_template.id=2'

I thought I would just disable, uninstall the plugin and then reinstall it using the plugin management but when I went to uninstall, I got this: FATAL: Database or Table does not exist.

At this point, I'd just like to remove all traces of thold from my Cacti installation so I can just set it up from scratch but I'm not exactly sure how to do it. Should I just manually delete all tables in my DB that start with "thold"? That just seems kinda dodgy to me though...

Also, if I am manging this and other plugins using "Plugin Management" within Cacti, does this mean that I no longer have to add them to the global.php file? I'm not sure about this.

Many thanks
-Chris

[robocp01]

I also get the same thing when I was trying to upgrade to the development version of Thold. I just overwrote the files in the appropriate directory structure of Thold, then enable and disabled it via the plug-in management tool. I'm really interested in trying to send alerts either via an SNMP alert or kicking off an executable. Seems like support for Thold is really hard to come by. I get the same Fatal Error message you have.

In addition to this I get the error message that Thold Templates are already created when I can't see any. Also none of my previously created thresholds appear to be there any more.

I did get what now appears as Version 5.0 of thold working, it shows new features when you establish an alert, such as using a script of an SNMP write (not sure yet what this will do). However I still get an error in that Threshold templates already exist. I would love to get this corrected so I can move on with these new features.

Thanks.

[Diggit2001]

I ended up fixing this by just disabling and uninstalling the plugin and then re-installing and re-enabling it. Of course, I had to re-create all my thresholds, which kinda sucked but it's been stable since then.