[Perfparse-devel-int] RE: Perfparse Queation

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

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"

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.1/279 - Release Date: 10/03/2006