Eli Mesika has submitted this change and it was merged. Change subject: core:fkvalidator.sh - some args are not honoured ...................................................................... core:fkvalidator.sh - some args are not honoured Adding -l LOGFILE support Adding support for -v flag When -v is used the number of violates records and the query how to get them is displayed. Example: ./fkvalidator.sh -u postgres -d engine_964197 Constraint violation found in event_subscriber (event_up_name) ./fkvalidator.sh -u postgres -d engine_964197 -v Constraint violation found in event_subscriber (event_up_name) Please run the following SQL to get the 1 violated record/s: select (event_up_name) from event_subscriber where (event_up_name) IS NOT NULL and (event_up_name) not in (select (event_up_name) from event_map); " Change-Id: I759dc11424bda345e14e7bc7bdf81d41515a0847 Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=964197 Signed-off-by: Eli Mesika <emesika(a)redhat.com&gt; --- M packaging/setup/dbutils/fkvalidator.sh M packaging/setup/dbutils/fkvalidator_sp.sql 2 files changed, 25 insertions(+), 12 deletions(-) Approvals: Eli Mesika: Verified; Looks good to me, approved -- To view, visit http://gerrit.ovirt.org/17015 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I759dc11424bda345e14e7bc7bdf81d41515a0847 Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com&gt; Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Yair Zaslavsky <yzaslavs(a)redhat.com&gt;