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


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

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