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): rhevm-setup-3.2.0-10.26.rc.el6ev.noarch How reproducible: 100% Steps to Reproduce: 1. see https://bugzilla.redhat.com/show_bug.cgi?id=893459#c0 2. 3. Actual results: Expected results: 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. Additional info: 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 Example : 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