Header Shadow Image


javax.persistence.NonUniqueResultException: query did not return a unique result: 2

Getting these?

2019-11-28 01:28:08,128 INFO com.cloudera.cmf.scheduler-1_Worker-1:com.cloudera.cmf.service.ServiceHandlerRegistry: Executing command GlobalPoolsRefresh BasicCmdArgs{scheduleId=1, scheduledTime=2019-11-27T10:00:00.000Z}.
2019-11-28 01:28:09,775 WARN scm-web-886:org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver: Resolved [java.io.IOException: Close org.eclipse.jetty.server.HttpConnection$SendCallback@2a3e3d03[PROCESSING][i=null,cb=org.eclipse.jetty.server.HttpChannel$ContentCallback@23de18e3] in state PROCESSING] to ModelAndView: materialized View is [com.cloudera.server.web.common.JamonModelAndView$JamonView@4a0945f9]; model is {}
2019-11-28 01:28:09,779 WARN scm-web-886:org.eclipse.jetty.server.HttpChannel: ERROR dispatch failed
org.eclipse.jetty.io.EofException: Closed
        at org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:482)
        at org.springframework.security.web.util.OnCommittedResponseWrapper$SaveContextServletOutputStream.write(OnCommittedResponseWrapper.java:638)
        at org.springframework.security.web.util.OnCommittedResponseWrapper$SaveContextServletOutputStream.write(OnCommittedResponseWrapper.java:638)
        at sun.nio.cs.StreamEncoder.writeBytes(StreamEncoder.java:221)
        at sun.nio.cs.StreamEncoder.implWrite(StreamEncoder.java:282)
        at sun.nio.cs.StreamEncoder.write(StreamEncoder.java:125)

 

        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
        at java.lang.Thread.run(Thread.java:748)
        Suppressed: java.lang.IllegalStateException: Error already set
                at org.eclipse.jetty.server.HttpChannelState.onError(HttpChannelState.java:758)
                at org.eclipse.jetty.server.HttpChannel.handleException(HttpChannel.java:595)
                at org.eclipse.jetty.server.HttpChannelOverHttp.handleException(HttpChannelOverHttp.java:489)
                at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:531)
                … 17 more
        Caused by: java.io.IOException: Close org.eclipse.jetty.server.HttpConnection$SendCallback@2a3e3d03[PROCESSING][i=null,cb=org.eclipse.jetty.server.HttpChannel$ContentCallback@23de18e3] in state PROCESSING
                at org.eclipse.jetty.util.IteratingCallback.close(IteratingCallback.java:427)
                at org.eclipse.jetty.server.HttpConnection.onClose(HttpConnection.java:507)
                at org.eclipse.jetty.io.ssl.SslConnection.onClose(SslConnection.java:273)
                at org.eclipse.jetty.io.SelectorManager.connectionClosed(SelectorManager.java:345)
                at org.eclipse.jetty.io.ManagedSelector$DestroyEndPoint.run(ManagedSelector.java:923)
                … 4 more

 

2019-11-28 01:33:43,717 INFO scm-web-165:com.cloudera.enterprise.JavaMelodyFacade: Exiting HTTP Operation: Method:POST, Path:/services/31/healthStatusBar, Status:200
2019-11-28 01:33:51,548 INFO scm-web-165:com.cloudera.api.ApiExceptionMapper: (20 skipped) Exception caught in API invocation. Msg:This installation is currently running Cloudera Express.
java.util.NoSuchElementException: This installation is currently running Cloudera Express.
        at com.cloudera.api.dao.impl.LicenseManagerDaoImpl.readLicense(LicenseManagerDaoImpl.java:86)
        at com.cloudera.api.v1.impl.ClouderaManagerResourceImpl.readLicense(ClouderaManagerResourceImpl.java:57)
        at com.cloudera.api.v32.impl.ClouderaManagerResourceV32Impl.readLicense(ClouderaManagerResourceV32Impl.java:56)
        at sun.reflect.GeneratedMethodAccessor1984.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

 

2019-11-28 02:20:02,169 INFO avro-servlet-hb-processor-1:com.cloudera.server.common.AgentAvroServlet: (27 skipped) AgentAvroServlet: heartbeat processing stats: average=35ms, min=24ms, max=92ms.
2019-11-28 02:20:50,007 ERROR ScmActive-0:com.cloudera.server.cmf.components.ScmActive: ScmActive:
javax.persistence.NonUniqueResultException: query did not return a unique result: 2

 

2019-11-28 02:20:50,008 INFO ScmActive-0:com.cloudera.enterprise.AbstractWrappedEntityManager: Rolling back transaction that wasn't marked for rollback-only.
java.lang.Exception: Non-thrown exception for stack trace.
        at com.cloudera.enterprise.AbstractWrappedEntityManager.close(AbstractWrappedEntityManager.java:161)
        at com.cloudera.cmf.persist.CmfEntityManager.close(CmfEntityManager.java:367)

 

        at java.lang.Thread.run(Thread.java:748)
2019-11-28 02:21:02,220 INFO avro-servlet-hb-processor-1:com.cloudera.server.common.AgentAvroServlet: (27 skipped) AgentAvroServlet: heartbeat processing stats: average=35ms, min=24ms, max=92ms.
2019-11-28 02:21:05,016 ERROR ScmActive-0:com.cloudera.server.cmf.components.ScmActive: ScmActive:
javax.persistence.NonUniqueResultException: query did not return a unique result: 2
        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:121)

 

2019-11-28 02:21:05,016 ERROR ScmActive-0:com.cloudera.server.cmf.components.ScmActive: ScmActive is deferring the validation to the next run in 15 seconds.
2019-11-28 02:21:05,016 INFO ScmActive-0:com.cloudera.enterprise.AbstractWrappedEntityManager: Rolling back transaction that wasn't marked for rollback-only.
java.lang.Exception: Non-thrown exception for stack trace.
        at com.cloudera.enterprise.AbstractWrappedEntityManager.close(AbstractWrappedEntityManager.java:161)
        at com.cloudera.cmf.persist.CmfEntityManager.close(CmfEntityManager.java:367)

 

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
2019-11-28 02:21:20,028 ERROR ScmActive-0:com.cloudera.server.cmf.components.ScmActive: ScmActive:
javax.persistence.NonUniqueResultException: query did not return a unique result: 2
        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:121)
        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)

Restore the database from your automatic backups:

[root@psql01 ~]# psql -h psql-c01.nix.mds.xyz -p 5432 -U postgres -f /root/psql-c01.sql.1574920910 postgres

Cheers,
TK

Subscribe
Notify of
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments

     
  Copyright © 2003 - 2025 Tom Kacperski (microdevsys.com). All rights reserved.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 Unported License

 

0
Would love your thoughts, please comment.x
()
x
The IT Development and Technology Mini Vault | MicroDevSys.com
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.