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
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
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
Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...
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