[midPoint] Finding disputed accounts
Andrew Morgan
morgan at oregonstate.edu
Tue Sep 25 19:15:02 CEST 2018
I ran a reconciliation on all 3 of our resources. On the Progress tab,
under States of processed objects (after operation), I have a small number
of Disputed objects.
How can I find the accounts that are disputed? I grepped the midpoint.log
and audit.log files for "disputed", but there were no matches. The task
in the UI doesn't seem to list them.
I can't look at the Accounts tab in the resource because there are too
many accounts. When I click on Accounts, it spins for 10 minutes and then
midpoint is locked up. The database query is:
| 15418 | midpoint | midpoint1.iam.oregonstate.edu:34512 | midpoint | Execute | 823 | Sending data | select count(rshadow0_.oid) as col_0_0_ from m_shadow rshadow0_ inner join m_object rshadow0_1_ on rshadow0_.oid=rshadow0_1_.oid where rshadow0_.resourceRef_targetOid=? and (rshadow0_.resourceRef_relation in (? , ?)) and rshadow0_.kind=? and rshadow0_.intent=? | 0.000 |
After a while, my LiveSync tasks are suspended because they are unable to
obtain a lock:
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Lock wait timeout exceeded; try restarting transaction
Query is: select oid from m_object where oid = ? for update, parameters ['13c92bff-1c2c-49e4-8c85-1ab4f2aa6cd0']
So... I have a couple issues here. :)
Thanks,
Andy Morgan
Systems Administrator, Identity & Access Management
Information Services | Oregon State University
541-737-8877 | is.oregonstate.edu
More information about the midPoint
mailing list