Crowd is throwing an error regards querying with Hibernate
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at org.hibernate.query.internal.AbstractProducedQuery.uniqueElement(AbstractProducedQuery.java:1487) at org.hibernate.query.internal.AbstractProducedQuery.uniqueResult(AbstractProducedQuery.java:1457)
Version: 3.2.0 (Build:#917 - 2018-04-20)
Total memory: 499 MB
Free memory: 109 MB
Used memory: 389 MB
Hi @ofir gutmacher,
Did you manage to resolve the issue or contact Atlassian Support?
Are you running on MySql database? If so maybe this KB article would help you https://confluence.atlassian.com/crowdkb/synchronization-of-crowd-results-in-error-query-did-not-return-a-unique-result-254739329.html
Postgre Cluster with 2 slave databases, and 1 master.
the Crowd queries the available free pool, and updates it.
while, the master needs to query its slaves regardless of Atlassian Crowd in some timely manner.
When this situation occured:
Crowd syncs directory A, it gets into slave1 at 17:01
Crowd syncs directory A, again, it gets into slave2 at 18:01
Postgre Master syncs to the slaves, getting 2 instances of directory A, at 19:01
Postgre master syncs the slave, pushing to them new directory A instances, at 19:02
Crowd displays log errors, because non unique directory, at 19:03
Happy New Year! We hope you all had a safe and restful holiday season. 2020 was a unique year full of unforeseen events; however, as we enter the new year of 2021, we’re optimistic for the light at t...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events