[
https://issues.apache.org/jira/browse/AMBARI-11778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hari Sekhon updated AMBARI-11778:
---------------------------------
Attachment: ambari-server.log
> Add Host Wizard fails to add previously removed host: More than one result
> was returned
> ---------------------------------------------------------------------------------------
>
> Key: AMBARI-11778
> URL: https://issues.apache.org/jira/browse/AMBARI-11778
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server, ambari-web
> Affects Versions: 2.0.0
> Environment: HDP 2.2
> Reporter: Hari Sekhon
> Attachments: Ambari_add_host_more_than_one_result.png,
> ambari-server.log
>
>
> After deleting a host and then re-adding it via Ambari web UI the addition
> fails with the following error
> {code}More than one result was returned from Query.getSingleResult(){code}
> The host probably wasn't removed properly by Ambari. I'm attaching a
> screenshot and ambari-server log which shows the full exception:
> {code}08 Jun 2015 09:37:08,994 WARN [qtp-client-134911] ServletHandler:514 -
> /api/v1/clusters/<custom_scrubbed>/hosts
> javax.persistence.NonUniqueResultException: More than one result was returned
> from Query.getSingleResult()
> at
> org.eclipse.persistence.internal.jpa.QueryImpl.throwNonUniqueResultException(QueryImpl.java:976)
> at
> org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:525)
> at
> org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
> at
> org.apache.ambari.server.orm.dao.DaoUtils.selectSingle(DaoUtils.java:71)
> at
> org.apache.ambari.server.orm.dao.HostVersionDAO.findByClusterStackVersionAndHost(HostVersionDAO.java:173)
> at
> org.apache.ambari.server.orm.AmbariLocalSessionInterceptor.invoke(AmbariLocalSessionInterceptor.java:53)
> at
> org.apache.ambari.server.state.cluster.ClusterImpl.recalculateClusterVersionState(ClusterImpl.java:1250)
> at
> org.apache.ambari.server.state.cluster.ClusterImpl.recalculateAllClusterVersionStates(ClusterImpl.java:1375)
> at
> org.apache.ambari.server.controller.internal.HostResourceProvider.createHosts(HostResourceProvider.java:461)
> at
> org.apache.ambari.server.controller.internal.HostResourceProvider$1.invoke(HostResourceProvider.java:166)
> at
> org.apache.ambari.server.controller.internal.HostResourceProvider$1.invoke(HostResourceProvider.java:163)
> at
> org.apache.ambari.server.controller.internal.AbstractResourceProvider.createResources(AbstractResourceProvider.java:273)
> at
> org.apache.ambari.server.controller.internal.HostResourceProvider.createResources(HostResourceProvider.java:163)
> at
> org.apache.ambari.server.controller.internal.ClusterControllerImpl.createResources(ClusterControllerImpl.java:289)
> ...{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)