RE: [Perfparse-users] re: deletion policys

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

per...@li... wrote:
> I have been watching this post becasue I too am experiencing this
> problem.  It's been about 1 month since I've started collection
> performance statistics and I'd like to do some cleanup. I
> cannot create
> deletion policies due to the "Cannot add or update a child row: a
> foreign key constraint fails"  error.
> Any ideas on how to rectify this. I also ran the ./perfparse-db-tool
> --update to see whether it would correct the problem. It
> didn't change
> anything. I have Version 0.99.05. Schema Version 0.12
>=20
> Thanks in advance
> Tim

I believe that this bug was fixed in Version 0.99.08, but it might have
been 0.99.09. Either way, you should definitely be using the latest
stable version -> 0.99.09.
I thought that I saw someone else post about this issue and say that the
version upgrade did not fix it for them. However, they did not mention
if they ran 'perfparse-db-tool --update' after upgrading PerfParse.

Everyone needs to realize something very important:
With new versions, there are changes to the PerfParse code and there are
sometimes changes made to the MySQL DB as well. You need to use the
perfparse-db-tool to update your DB with each upgrade. This tool will be
installed in your '<path_to>/nagios/bin/' directory, run it with the
'--update' argument to ensure that DB changes are made properly.

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