Program Version 0.104.3. Schema Version 0.15
mysql Ver 12.22 Distrib 4.0.22, for
portbld-freebsd4.10 (i386) (with innodb)
everything works just fine until i select a host for
complete data deletion and then run perfparse-db-purge.
After that I the is a logrecord:
2004/12/23 00:39:13 [storage_mysql.c:516 2773 ]
INSERT INTO perfdata_service_bin (host_name,
service_description, metric, ctime, value, warn,
critical, state) VALUES ('uriel', 'PING', 'rta',
FROM_UNIXTIME(1103758738), 8.60000000000000e-01,
1.00000000000000e+01, 1.00000000000000e+02,
0.00000000000000e+00) (Deadlock found when trying to
get lock; Try restarting transaction)
2004/12/23 00:39:13 [ storage.c:194 2773 ]
Perfparsed stopped
after mysql and perfparsed restart i tells me:
2004/12/23 00:41:47 [db_macro_actions.c:90 66042 ]
UPDATE perfdata_host SET raw_delete_policy_type =
'template', bin_delete_policy_type = 'template',
raw_delete_policy_name = 'Raw Default',
bin_delete_policy_name = 'Bin Default',
bin_delete_policy = NULL, raw_delete_policy = NULL
WHERE host_name = 'apophis' (Cannot add or update a
child row: a foreign key constraint fails)
no way to fix it other then to reinitialize the databse.