RE: [Perfparse-users] deletion policys

[Ferrill, J. <jam...@NE...>]

James, 
 
I recently started using PerfParse and encounted the same thing.
 
OS: Debian Linux 2.6.6-1-686 #1 Wed May 12 14:57:57 EST 2004 i686 GNU/Lin
MySQL: Ver 12.22 Distrib 4.0.18, for pc-linux-gnu (i686)
 
Installed PerfParse 0.99.07. 
Ran perfparse-db-tool --update
No perfdata being collected yet.
Noticed the deletion policy problem.
 
Downloaded and installed alpha1 plugins.
Configured ping to collect perfdata with fping
Downloaded and installed a few of the latest cvs plugins.
Installed PerfParse 0.99.09. 
Ran perfparse-db-tool --update
Deletion policy problem no longer exists.
 
I don't know what fixed it in that sequence. Plus, I'm sure there was a
reboot or two in there somewhere.
 
I do know that PerfParse acts differently if there is no data. It could be
that it malfunctioned until data was collected and appeared in the tables.
 
James Ferrill
IT Analyst II
NextiraOne LLC
Phone: 713-307-4029
Email: jam...@ne...
 

-----Original Message-----
From: James Ochs [mailto:jo...@re...]
Sent: Saturday, August 21, 2004 1:46 PM
To: per...@li...
Subject: [Perfparse-users] deletion policys



I get this error everytime I try to update /create deletion policys in the
database:

 

[root@mon-01 bin]# ./perfparse-db-tool --reset_host_delete_policy
test-wms-app

"UPDATE perfdata_host SET raw_delete_policy_type = 'template',
bin_delete_policy_type = 'template', raw_delete_policy_name = 'Raw Default',
bin_delete_policy_name = 'Bin Default' WHERE host_name = 'test-wms-app'"
failed:

Cannot add or update a child row: a foreign key constraint fails

 

Any ideas what is causing this?   I have upgraded to perfparse 0.99.09, and
previously was running 99.07.  I have been getting this error since I first
installed perfparse.  There is currently no data in the delete policy
tables.

 

James