Re: [Perfparse-users] re: deletion policys

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

James,

I need some information from your MySQL.  Can you start the MySQL shell 
(mysql -u nagios -pnagios -D nagios) and enter:

mysql> select * from perfdata_delete_policy;

This should produce at least this:

+-------------+---------------+
| policy_name | delete_policy |
+-------------+---------------+
| Always      |            30 |
| Bin Default |            30 |
+-------------+---------------+

Which will have different values in the second column.

Let me know and we can go from there.

Ben

James Ochs wrote:

> I'm still having this issue.  Does anyone know what the foreign key that 
> it is referring to is?  Or how to find out?   Here's the latest output:
> 
> 
> 
> [jochs@mon-01 bin]$
> [jochs@mon-01 bin]$ ./perfparse-db-tool --update
> [jochs@mon-01 bin]$ ./perfparse-db-purge -r
> "UPDATE perfdata_service_metric SET bin_delete_policy_name = 'Bin 
> Default' WHERE bin_delete_policy_type = 'template' AND 
> bin_delete_policy_name IS NULL" failed:
> 
> Cannot add or update a child row: a foreign key constraint fails
> [jochs@mon-01 bin]$ ./perfparse-db-purge --show_config
> DB_User =        "nagios"
> DB_Name =        "nagios"
> DB_Pass =        "n4g10s"
> DB_Host =        "127.0.0.1"
> Drop_File =      "/tmp/perfparse.drop"
> Service_Log =    "/usr/local/nagios/var/serviceperf.log"
> Host_Log =       "/usr/local/nagios/var/hostperf.log"
> Dummy_Hostname = "dummy"
> Delete_Service_Log =         "No"
> Delete_Host_Log =            "No"
> Nagios_Lock =    "/usr/local/nagios/var/nagios.lock"
> Lock_File =      "/var/lock/perfparse.lock"
> Be_Silent =      "no"
> Do_Report =      "no"
> Accept_Odd_Chars_in_Label =      "no"
> Default_user_permissions_Policy = "rw"
> Default_user_permissions_Host_groups = "rw"
> [jochs@mon-01 bin]$
> 
> -----Original Message-----
> From: Tim Brazil [mailto:br...@se...]
> Sent: Wednesday, August 25, 2004 2:43 PM
> To: James Ochs
> Cc: per...@li...
> Subject: Re: [Perfparse-users] re: deletion policys
> 
> Hi James
> 
> The only other thing I did was changed to the newer sample version
> perfparse.cfg.
> 
> Here are some thoughts...
> Did you see any "upgrade" output from ./perfparse-db-tool --update when
> you ran it indicating something actually happened?
> Is the binary from  perfparse-db-tool the new one that was built with
> 0.99.09.
> I initially didn't "configure" correctly which "make install"ed
> perfparse-db-tool  to the wrong directory (/usr/local/bin) which left
> the older version of perfparse-db-tool  in place under 
> /usr/local/nagios/bin
> 
> Tim
> 
> James Ochs wrote:
> 
>  > Upgrading to 0.99.09 didn't fix this problem for me.  Nor did running
>  > perfparse-db-tool --update.
>  >
>  > James
>  >
>  > -----Original Message-----
>  > From: Tim Brazil [mailto:br...@se...]
>  > Sent: Wednesday, August 25, 2004 1:39 PM
>  > Cc: per...@li...
>  > Subject: Re: [Perfparse-users] re: deletion policys
>  >
>  > Thanks Garry
>  > I updated to 0.99.09, ran ./perfparse-db-tool --update and it fixed my
>  > problem.
>  >
>  > Tim
>  >
>  > Cook, Garry wrote:
>  >
>  > >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
>  > >>
>  > >>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)
>  > >
>  > >
>  > >-------------------------------------------------------
>  > >SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>  > >100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>  > >Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>  > >http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>  > >_______________________________________________
>  > >Perfparse-users mailing list
>  > >Per...@li...
>  > >https://lists.sourceforge.net/lists/listinfo/perfparse-users
>  > >
>  > >
>  >
>  >
>  >
>  > -------------------------------------------------------
>  > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>  > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>  > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>  > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>  > _______________________________________________
>  > Perfparse-users mailing list
>  > Per...@li...
>  > https://lists.sourceforge.net/lists/listinfo/perfparse-users
>  >
> 