[Perfparse-users] RE: Perfparse error for version 0.105.5

[Alex P. <ale...@ci...>]

Hi Ben,

I dit marked one host for permanently deletion into the host deletion
policy.

I dit run first the mysql-delete script

Then again the mysql-create script

The asnmtap added some data

I dit run the /opt/asnmtap/perfparse/bin/perfparse-db-purge script.

> Can I please ask you to send all support questions to the mailing list 
> per...@li...?
Oke,

I do have one account at nagios-exchange.org, but there I can't add
problems.


-----Original Message-----
From: Ben Clewett [mailto:bcl...@pe...] 
Sent: maandag 7 februari 2005 10:05
To: ale...@ci...
Cc: bcl...@pe...; gc...@pe...;
per...@li...
Subject: Re: Perfparse error for version 0.105.5

Hi Alex,

Can I please ask you to send all support questions to the mailing list 
per...@li...?

You are likely to get better support as well as maybe helping other 
users with same problem :)

May I ask what you were doing at the time of this failure?  I believe 
you may have been deleting a host which was permanently marked as deleted?

If this is the case you have found a hole in the system.  New tables 
have been added which are not included in the deletion function.  The 
database is trying to protect your data from bad programmes :)

Regards, Ben.

PS, (TODO: Edit the purge code to delete data from summary tables.)


Alex Peeters wrote:
> Hi,
> 
>  
> 
>  
> 
> /opt/asnmtap/perfparse/bin/perfparse-db-purge
> 
>  
> 
> root@chablis [/opt/asnmtap/plugins]#  
> /opt/asnmtap/perfparse/bin/perfparse-db-purge
> 
> An error occured with the SQL:
> 
>  
> 
>   "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE 
> perfdata_service.host_name = perfdata_host.host_name AND 
> perfdata_host.is_deleted = 1"
> 
>  
> 
> Failure Message:
> 
>  
> 
>   "Cannot delete or update a parent row: a foreign key constraint fails"
> 
>  
> 
>  
> 
> -- Alex
> 
>  
> 
>  
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005
> 

-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005