RE: [Perfparse-users] deletion policys

[Cook, G. <GW...@ma...>]

James Ochs wrote:
> I get this error everytime I try to update /create deletion policys
> in the database:=20
>=20
> [root@mon-01 bin]# ./perfparse-db-tool --reset_host_delete_policy
> test-wms-app "UPDATE perfdata_host SET raw_delete_policy_type =3D
> 'template', bin_delete_policy_type =3D 'template',
> raw_delete_policy_name =3D 'Raw Default', bin_delete_policy_name =3D =
'Bin
> Default' WHERE host_name =3D 'test-wms-app'" failed:  =20
> Cannot add or update a child row: a foreign key constraint fails
>=20
> 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.  =20
>=20
> 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 =20

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)