Re: [Perfparse-devel-int] RE: Perfparse Queation

[Florian G. <fl...@bi...>]

Are these permanent errors? What can i do to reproduce the error?

Flo


Alex Peeters wrote:
> root@chablis [/export/download/ASNMTAP-3.000.006]#
> /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"
> 
> root@chablis [/export/download/ASNMTAP-3.000.006]#
> /opt/asnmtap/perfparse/bin/perfparse-db-purge 
> An error occured with the SQL:
> 
>   "UPDATE perfdata_service SET raw_delete_policy_name = 'Raw Default' WHERE
> raw_delete_policy_type = 'template' AND raw_delete_policy_name IS NULL"
> 
> Failure Message:
> 
>   "Deadlock found when trying to get lock; Try restarting transaction"
>