ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maier Lucian (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (AMBARI-13662) Ambari server 2.1.2 it's not starting due to database issue
Date Tue, 03 Nov 2015 08:34:27 GMT

     [ https://issues.apache.org/jira/browse/AMBARI-13662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Maier Lucian resolved AMBARI-13662.
-----------------------------------
    Resolution: Duplicate

Issue will be resolved internally.

> Ambari server 2.1.2 it's not starting due to database issue
> -----------------------------------------------------------
>
>                 Key: AMBARI-13662
>                 URL: https://issues.apache.org/jira/browse/AMBARI-13662
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.1.2
>         Environment: CentOS 6.7
>            Reporter: Maier Lucian
>            Priority: Blocker
>
> I've upgraded Ambari from 2.1.0 to 2.1.2 and now the server it's not starting:
> - is looking for "id" column in "hostcomponentstate" table and the column does not exist
in the table
> *Steps performed:*
> 1. wget Ambari 2.1.2
> 2. yum update ambari-server
> 3. ambari-server upgrade
> 4. ambari-server start (failed to start)
> 5. ambari-server setup
> 6. ambari-server start (failed to start)
> I've also tried the same steps with 2.1.1 version but same issue.
> *Ambari startup log:*
> {noformat}
> 29 Oct 2015 16:36:16,932  INFO [main] DatabaseChecker:177 - DB store version is compatible
> 29 Oct 2015 16:36:16,932  INFO [main] DatabaseChecker:55 - Checking DB consistency
> 29 Oct 2015 16:36:17,023 ERROR [main] AmbariServer:722 - Failed to run the Ambari Server
> Local Exception Stack:
> Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd):
org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: column "id" does not exist
>   Position: 8
> Error Code: 0
> Call: SELECT id, cluster_id, component_name, current_state, host_id, security_state,
service_name, upgrade_state, version, current_stack_id FROM hostcomponentstate WHERE ((component_name
= ?) AND ((cluster_id =
> ?) AND (service_name = ?)))
>         bind => [3 parameters bound]
> Query: ReadAllQuery(name="hostComponentStateEntities" referenceClass=HostComponentStateEntity
sql="SELECT id, cluster_id, component_name, current_state, host_id, security_state, service_name,
upgrade_state, vers
> ion, current_stack_id FROM hostcomponentstate WHERE ((component_name = ?) AND ((cluster_id
= ?) AND (service_name = ?)))")
>         at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
>         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:682)
>         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
>         at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
>         at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
>         at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
>         at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
>         at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
>         at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694)
>         at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2738)
>         at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2691)
>         at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:495)
>         at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1168)
>         at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
>         at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1127)
>         at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:403)
>         at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:3214)
>         at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
>         at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
>         at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:129)
>         at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:116)
>         at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:89)
>         at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiateImpl(UnitOfWorkValueHolder.java:173)
>         at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiate(UnitOfWorkValueHolder.java:234)
>         at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:89)
>         at org.eclipse.persistence.indirection.IndirectList.buildDelegate(IndirectList.java:252)
>         at org.eclipse.persistence.indirection.IndirectList.getDelegate(IndirectList.java:423)
>         at org.eclipse.persistence.indirection.IndirectList.isEmpty(IndirectList.java:498)
>         at org.apache.ambari.server.controller.utilities.DatabaseChecker.checkDBConsistency(DatabaseChecker.java:122)
>         at org.apache.ambari.server.controller.AmbariServer.run(AmbariServer.java:229)
>         at org.apache.ambari.server.controller.AmbariServer.main(AmbariServer.java:720)
> Caused by: org.postgresql.util.PSQLException: ERROR: column "id" does not exist
>   Position: 8
>         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
>         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
>         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
>         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1007)
>         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642)
>         ... 29 more
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message