RE: [Perfparse-users] deletion policys

[James O. <jo...@re...>]

I have done that several times to no avail... here's the output:


[root@mon-01 bin]# ./perfparse-db-tool --update
[root@mon-01 bin]# ./perfparse-db-tool --reset_host_delete_policy mon-01
"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 = 'mon-01'" failed:
Cannot add or update a child row: a foreign key constraint fails
[root@mon-01 bin]#

The linux version is fedora core 2 and mysql is 4.0.20-standard

James

-----Original Message-----
From: Cook, Garry [mailto:GW...@ma...] 
Sent: Monday, August 23, 2004 6:48 AM
To: James Ochs; per...@li...
Subject: RE: [Perfparse-users] deletion policys

James Ochs wrote:
> 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

After upgrading, did you run the db update? You should run this command
everytime you upgrade, just to make sure that any database changes are
incorporated into your installation:
/<path_to_nagios>/bin/perfparse-db-tool --update  

Try that, and then email the list with results. Please also include
Linux Distro/Version and MySQL version.

Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)