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

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

Alex,

In that case there is definitely a bug in the purge program.  This will 
be fixed in next version.

You may want to undo this until this version:

mysql> UPDATE perfdata_host SET is_deleted = 0;

I am glad your data is now being added correctly.  There should be no 
difference to the behavior of Sun, Linux or any other OS.  If you have a 
difference, this may be a bug.

Ben


Alex Peeters wrote:
> 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
>>
> 
>