Change in ovirt-engine[master]: core:fkvalidator.sh - some args are not honoured
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>
---
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>
Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Yair Zaslavsky <yzaslavs(a)redhat.com>