Red Hat Bugzilla – Bug 964197
fkvalidator.sh - some args are not honoured
Last modified: 2016-02-10 14:01:29 EST
Description of problem:
fkvalidator.sh doesn't respect arguments (-v -l) eg:
"/usr/share/ovirt-engine/scripts/dbutils/fkvalidator.sh -s localhost -d engine -u engine -l /tmp/fk.log -v" shows output:
"Constraint violation found in step (job_id)".
The constraint violation is correct, however no verbose log nor log file is created. Same bahaviour in standalone usage of those 2 args.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. see https://bugzilla.redhat.com/show_bug.cgi?id=893459#c0
I'd expect to see whole record(s) from DB (at least in case of '-v') as this can indicate some more troubles in system.
Also log file should be created & should contain an output.
logfile is not even created by using simple '-l' (without any optional path/filename).
Pavel , a simple and quick solution is to add for each violation the query syntax of how to get the violated records.
This will be added in teh case that -v is used
Constraint violation found in event_subscriber (event_up_name)
Query : select event_up_name from event_subscriber where event_up_name not in (select event_up_name from event_map);
This query can be copied and run by psql to get the violated records.
Is that acceptabe ???
fixed in commit: 5a1c143
Closing - RHEV 3.3 Released