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

[Ben C. <bcl...@pe...>]

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
>