You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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