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] [Commented] (AMBARI-13662) Ambari server 2.1.2 it's not starting due to database issue
Date Fri, 30 Oct 2015 17:12:27 GMT

    [ https://issues.apache.org/jira/browse/AMBARI-13662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14982899#comment-14982899
] 

Maier Lucian commented on AMBARI-13662:
---------------------------------------

I've tried again to upgrade from 2.1.1 to 2.1.2 and now DB upgrade fails with the same error.

ambari-server upgrade output:
{noformat}
# ambari-server upgrade
Using python  /usr/bin/python2.6
Upgrading ambari-server
Updating properties in ambari.properties ...
WARNING: Can not find ambari.properties.rpmsave file from previous version, skipping import
of settings
WARNING: Can not find ambari-env.sh.rpmsave file from previous version, skipping restore of
environment settings
Fixing database objects owner
Ambari Server configured for Embedded Postgres. Confirm you have made a backup of the Ambari
Server database [y/n] (y)?
Upgrading database schema
ERROR: Error executing schema upgrade, please check the server logs.
ERROR: Ambari server upgrade failed. Please look at /var/log/ambari-server/ambari-server.log,
for more details.
ERROR: Exiting with exit code 11.
REASON: Schema upgrade failed.
{noformat}

amabari-server.log:
{noformat}
30 Oct 2015 19:03:12,930  INFO [main] ActionDefinitionManager:124 - Added custom action definition
for install_packages
30 Oct 2015 19:03:12,930  INFO [main] ActionDefinitionManager:124 - Added custom action definition
for ru_execute_tasks
30 Oct 2015 19:03:13,276  INFO [main] AmbariManagementControllerImpl:298 - Initializing the
AmbariManagementControllerImpl
30 Oct 2015 19:03:13,519  INFO [main] ClusterImpl:291 - Service config types loaded: {GANGLIA=[ganglia-env],
SQOOP=[sqoop-env], TEZ=[tez-env, tez-site], HDFS=[hdfs-site, ssl-server, hadoop-env, hdfs-log4j,
ranger-hdfs-plugin-properties, hadoop-policy, ssl-client, core-site], OOZIE=[oozie-log4j,
oozie-site, oozie-env], MAPREDUCE2=[mapred-env, mapred-site], SPARK=[spark-javaopts-properties,
spark-metrics-properties, spark-log4j-properties, spark-env, spark-defaults], HBASE=[hbase-policy,
hbase-site, hbase-log4j, hbase-env, ranger-hbase-plugin-properties], ZOOKEEPER=[zoo.cfg, zookeeper-env,
zookeeper-log4j], KERBEROS=[kerberos-env, krb5-conf], YARN=[capacity-scheduler, yarn-env,
yarn-site, yarn-log4j], PIG=[pig-properties, pig-log4j, pig-env], KNOX=[ranger-knox-plugin-properties,
gateway-log4j, topology, ldap-log4j, knox-env, gateway-site, users-ldif], RANGER=[usersync-properties,
admin-properties, ranger-site, ranger-env], STORM=[ranger-storm-plugin-properties, storm-env,
storm-site], HIVE=[webhcat-log4j, hive-site, ranger-hive-plugin-properties, hiveserver2-site,
webhcat-site, hive-env, hive-log4j, hive-exec-log4j, hcat-env, webhcat-env], SLIDER=[slider-env,
slider-log4j, slider-client], AMBARI_METRICS=[ams-env, ams-hbase-security-site, ams-hbase-site,
ams-hbase-log4j, ams-site, ams-hbase-policy, ams-hbase-env, ams-log4j], KAFKA=[kafka-broker,
kafka-env, kafka-log4j], FLUME=[flume-env, flume-conf], FALCON=[falcon-startup.properties,
falcon-runtime.properties, falcon-env]}
30 Oct 2015 19:03:13,571 ERROR [main] SchemaUpgradeHelper:224 - Upgrade failed.
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, version, 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$1.<init>(IndirectList.java:551)
        at org.eclipse.persistence.indirection.IndirectList.listIterator(IndirectList.java:550)
        at org.eclipse.persistence.indirection.IndirectList.iterator(IndirectList.java:514)
        at org.apache.ambari.server.state.ServiceComponentImpl.<init>(ServiceComponentImpl.java:126)
        at org.apache.ambari.server.state.ServiceComponentImpl$$EnhancerByGuice$$f9afaa16.<init>(<generated>)
        at org.apache.ambari.server.state.ServiceComponentImpl$$EnhancerByGuice$$f9afaa16$$FastClassByGuice$$148e5985.newInstance(<generated>)
        at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40)
        at com.google.inject.internal.ProxyFactory$ProxyConstructor.newInstance(ProxyFactory.java:260)
        at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)
        at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
        at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
        at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
        at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
        at com.google.inject.assistedinject.FactoryProvider2.invoke(FactoryProvider2.java:632)
        at com.sun.proxy.$Proxy17.createExisting(Unknown Source)
        at org.apache.ambari.server.state.ServiceImpl.<init>(ServiceImpl.java:145)
        at org.apache.ambari.server.state.ServiceImpl$$EnhancerByGuice$$88cb5aa2.<init>(<generated>)
        at org.apache.ambari.server.state.ServiceImpl$$EnhancerByGuice$$88cb5aa2$$FastClassByGuice$$e687ffb.newInstance(<generated>)
        at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40)
        at com.google.inject.internal.ProxyFactory$ProxyConstructor.newInstance(ProxyFactory.java:260)
        at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)
        at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
        at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
        at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
        at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
        at com.google.inject.assistedinject.FactoryProvider2.invoke(FactoryProvider2.java:632)
        at com.sun.proxy.$Proxy14.createExisting(Unknown Source)
        at org.apache.ambari.server.state.cluster.ClusterImpl.loadServices(ClusterImpl.java:392)
        at org.apache.ambari.server.state.cluster.ClusterImpl.getServices(ClusterImpl.java:906)
        at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.addNewConfigurationsFromXml(AbstractUpgradeCatalog.java:275)
        at org.apache.ambari.server.upgrade.UpgradeCatalog212.executeDMLUpdates(UpgradeCatalog212.java:152)
        at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:551)
        at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:222)
        at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:299)
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)
        ... 59 more
30 Oct 2015 19:03:13,576 ERROR [main] SchemaUpgradeHelper:310 - Exception occurred during
upgrade, failed
org.apache.ambari.server.AmbariException:
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, version, current_stack_id FROM hostcomponentstate WHERE ((component_name =
?) AND ((cluster_id = ?) AND (service_name = ?)))")
        at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:225)
        at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:299)
Caused by: 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, version, 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$1.<init>(IndirectList.java:551)
        at org.eclipse.persistence.indirection.IndirectList.listIterator(IndirectList.java:550)
        at org.eclipse.persistence.indirection.IndirectList.iterator(IndirectList.java:514)
        at org.apache.ambari.server.state.ServiceComponentImpl.<init>(ServiceComponentImpl.java:126)
        at org.apache.ambari.server.state.ServiceComponentImpl$$EnhancerByGuice$$f9afaa16.<init>(<generated>)
        at org.apache.ambari.server.state.ServiceComponentImpl$$EnhancerByGuice$$f9afaa16$$FastClassByGuice$$148e5985.newInstance(<generated>)
        at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40)
        at com.google.inject.internal.ProxyFactory$ProxyConstructor.newInstance(ProxyFactory.java:260)
        at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)
        at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
        at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
        at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
        at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
        at com.google.inject.assistedinject.FactoryProvider2.invoke(FactoryProvider2.java:632)
        at com.sun.proxy.$Proxy17.createExisting(Unknown Source)
        at org.apache.ambari.server.state.ServiceImpl.<init>(ServiceImpl.java:145)
        at org.apache.ambari.server.state.ServiceImpl$$EnhancerByGuice$$88cb5aa2.<init>(<generated>)
        at org.apache.ambari.server.state.ServiceImpl$$EnhancerByGuice$$88cb5aa2$$FastClassByGuice$$e687ffb.newInstance(<generated>)
        at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40)
        at com.google.inject.internal.ProxyFactory$ProxyConstructor.newInstance(ProxyFactory.java:260)
        at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)
        at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
        at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
        at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
        at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
        at com.google.inject.assistedinject.FactoryProvider2.invoke(FactoryProvider2.java:632)
        at com.sun.proxy.$Proxy14.createExisting(Unknown Source)
        at org.apache.ambari.server.state.cluster.ClusterImpl.loadServices(ClusterImpl.java:392)
        at org.apache.ambari.server.state.cluster.ClusterImpl.getServices(ClusterImpl.java:906)
        at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.addNewConfigurationsFromXml(AbstractUpgradeCatalog.java:275)
        at org.apache.ambari.server.upgrade.UpgradeCatalog212.executeDMLUpdates(UpgradeCatalog212.java:152)
        at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:551)
        at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:222)
        ... 1 more
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)
        ... 59 more
{noformat}

> 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