Return-Path: X-Original-To: apmail-ambari-dev-archive@www.apache.org Delivered-To: apmail-ambari-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 24EED18CDB for ; Fri, 30 Oct 2015 17:12:33 +0000 (UTC) Received: (qmail 59528 invoked by uid 500); 30 Oct 2015 17:12:27 -0000 Delivered-To: apmail-ambari-dev-archive@ambari.apache.org Received: (qmail 59341 invoked by uid 500); 30 Oct 2015 17:12:27 -0000 Mailing-List: contact dev-help@ambari.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ambari.apache.org Delivered-To: mailing list dev@ambari.apache.org Received: (qmail 59324 invoked by uid 99); 30 Oct 2015 17:12:27 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Oct 2015 17:12:27 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id ACE352C1F57 for ; Fri, 30 Oct 2015 17:12:27 +0000 (UTC) Date: Fri, 30 Oct 2015 17:12:27 +0000 (UTC) From: "Maier Lucian (JIRA)" To: dev@ambari.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (AMBARI-13662) Ambari server 2.1.2 it's not starting due to database issue MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/AMBARI-13662?page=3Dcom.atlassi= an.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D14= 982899#comment-14982899 ]=20 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 wi= th 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, ski= pping restore of environment settings Fixing database objects owner Ambari Server configured for Embedded Postgres. Confirm you have made a bac= kup 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 c= ustom action definition for install_packages 30 Oct 2015 19:03:12,930 INFO [main] ActionDefinitionManager:124 - Added c= ustom 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 type= s loaded: {GANGLIA=3D[ganglia-env], SQOOP=3D[sqoop-env], TEZ=3D[tez-env, te= z-site], HDFS=3D[hdfs-site, ssl-server, hadoop-env, hdfs-log4j, ranger-hdfs= -plugin-properties, hadoop-policy, ssl-client, core-site], OOZIE=3D[oozie-l= og4j, oozie-site, oozie-env], MAPREDUCE2=3D[mapred-env, mapred-site], SPARK= =3D[spark-javaopts-properties, spark-metrics-properties, spark-log4j-proper= ties, spark-env, spark-defaults], HBASE=3D[hbase-policy, hbase-site, hbase-= log4j, hbase-env, ranger-hbase-plugin-properties], ZOOKEEPER=3D[zoo.cfg, zo= okeeper-env, zookeeper-log4j], KERBEROS=3D[kerberos-env, krb5-conf], YARN= =3D[capacity-scheduler, yarn-env, yarn-site, yarn-log4j], PIG=3D[pig-proper= ties, pig-log4j, pig-env], KNOX=3D[ranger-knox-plugin-properties, gateway-l= og4j, topology, ldap-log4j, knox-env, gateway-site, users-ldif], RANGER=3D[= usersync-properties, admin-properties, ranger-site, ranger-env], STORM=3D[r= anger-storm-plugin-properties, storm-env, storm-site], HIVE=3D[webhcat-log4= j, hive-site, ranger-hive-plugin-properties, hiveserver2-site, webhcat-site= , hive-env, hive-log4j, hive-exec-log4j, hcat-env, webhcat-env], SLIDER=3D[= slider-env, slider-log4j, slider-client], AMBARI_METRICS=3D[ams-env, ams-hb= ase-security-site, ams-hbase-site, ams-hbase-log4j, ams-site, ams-hbase-pol= icy, ams-hbase-env, ams-log4j], KAFKA=3D[kafka-broker, kafka-env, kafka-log= 4j], FLUME=3D[flume-env, flume-conf], FALCON=3D[falcon-startup.properties, = falcon-runtime.properties, falcon-env]} 30 Oct 2015 19:03:13,571 ERROR [main] SchemaUpgradeHelper:224 - Upgrade fai= led. Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v2014031= 9-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: column "id" d= oes not exist Position: 8 Error Code: 0 Call: SELECT id, cluster_id, component_name, current_state, host_id, securi= ty_state, service_name, upgrade_state, version, current_stack_id FROM hostc= omponentstate WHERE ((component_name =3D ?) AND ((cluster_id =3D ?) AND (se= rvice_name =3D ?))) bind =3D> [3 parameters bound] Query: ReadAllQuery(name=3D"hostComponentStateEntities" referenceClass=3DHo= stComponentStateEntity sql=3D"SELECT id, cluster_id, component_name, curren= t_state, host_id, security_state, service_name, upgrade_state, version, cur= rent_stack_id FROM hostcomponentstate WHERE ((component_name =3D ?) AND ((c= luster_id =3D ?) AND (service_name =3D ?)))") at org.eclipse.persistence.exceptions.DatabaseException.sqlExceptio= n(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.basicE= xecuteCall(AbstractSession.java:2002) at org.eclipse.persistence.sessions.server.ServerSession.executeCal= l(ServerSession.java:570) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMech= anism.executeCall(DatasourceCallQueryMechanism.java:242) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMech= anism.executeCall(DatasourceCallQueryMechanism.java:228) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMech= anism.executeSelectCall(DatasourceCallQueryMechanism.java:299) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMech= anism.selectAllRows(DatasourceCallQueryMechanism.java:694) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanis= m.selectAllRowsFromTable(ExpressionQueryMechanism.java:2738) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanis= m.selectAllRows(ExpressionQueryMechanism.java:2691) at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelR= eadQuery(ReadAllQuery.java:495) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeData= baseQuery(ObjectLevelReadQuery.java:1168) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQu= ery.java:899) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(Obj= ectLevelReadQuery.java:1127) at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuer= y.java:403) at org.eclipse.persistence.internal.sessions.AbstractSession.intern= alExecuteQuery(AbstractSession.java:3214) at org.eclipse.persistence.internal.sessions.AbstractSession.execut= eQuery(AbstractSession.java:1804) at org.eclipse.persistence.internal.sessions.AbstractSession.execut= eQuery(AbstractSession.java:1786) at org.eclipse.persistence.internal.indirection.QueryBasedValueHold= er.instantiate(QueryBasedValueHolder.java:129) at org.eclipse.persistence.internal.indirection.QueryBasedValueHold= er.instantiate(QueryBasedValueHolder.java:116) at org.eclipse.persistence.internal.indirection.DatabaseValueHolder= .getValue(DatabaseValueHolder.java:89) at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHold= er.instantiateImpl(UnitOfWorkValueHolder.java:173) at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHold= er.instantiate(UnitOfWorkValueHolder.java:234) at org.eclipse.persistence.internal.indirection.DatabaseValueHolder= .getValue(DatabaseValueHolder.java:89) at org.eclipse.persistence.indirection.IndirectList.buildDelegate(I= ndirectList.java:252) at org.eclipse.persistence.indirection.IndirectList.getDelegate(Ind= irectList.java:423) at org.eclipse.persistence.indirection.IndirectList$1.(Indire= ctList.java:551) at org.eclipse.persistence.indirection.IndirectList.listIterator(In= directList.java:550) at org.eclipse.persistence.indirection.IndirectList.iterator(Indire= ctList.java:514) at org.apache.ambari.server.state.ServiceComponentImpl.(Servi= ceComponentImpl.java:126) at org.apache.ambari.server.state.ServiceComponentImpl$$EnhancerByG= uice$$f9afaa16.() at org.apache.ambari.server.state.ServiceComponentImpl$$EnhancerByG= uice$$f9afaa16$$FastClassByGuice$$148e5985.newInstance() at com.google.inject.internal.cglib.reflect.$FastConstructor.newIns= tance(FastConstructor.java:40) at com.google.inject.internal.ProxyFactory$ProxyConstructor.newInst= ance(ProxyFactory.java:260) at com.google.inject.internal.ConstructorInjector.construct(Constru= ctorInjector.java:85) at com.google.inject.internal.ConstructorBindingImpl$Factory.get(Co= nstructorBindingImpl.java:254) at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.ja= va:978) at com.google.inject.internal.InjectorImpl.callInContext(InjectorIm= pl.java:1031) at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:= 974) at com.google.inject.assistedinject.FactoryProvider2.invoke(Factory= Provider2.java:632) at com.sun.proxy.$Proxy17.createExisting(Unknown Source) at org.apache.ambari.server.state.ServiceImpl.(ServiceImpl.ja= va:145) at org.apache.ambari.server.state.ServiceImpl$$EnhancerByGuice$$88c= b5aa2.() at org.apache.ambari.server.state.ServiceImpl$$EnhancerByGuice$$88c= b5aa2$$FastClassByGuice$$e687ffb.newInstance() at com.google.inject.internal.cglib.reflect.$FastConstructor.newIns= tance(FastConstructor.java:40) at com.google.inject.internal.ProxyFactory$ProxyConstructor.newInst= ance(ProxyFactory.java:260) at com.google.inject.internal.ConstructorInjector.construct(Constru= ctorInjector.java:85) at com.google.inject.internal.ConstructorBindingImpl$Factory.get(Co= nstructorBindingImpl.java:254) at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.ja= va:978) at com.google.inject.internal.InjectorImpl.callInContext(InjectorIm= pl.java:1024) at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:= 974) at com.google.inject.assistedinject.FactoryProvider2.invoke(Factory= Provider2.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(C= lusterImpl.java:906) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.addNewCo= nfigurationsFromXml(AbstractUpgradeCatalog.java:275) at org.apache.ambari.server.upgrade.UpgradeCatalog212.executeDMLUpd= ates(UpgradeCatalog212.java:152) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeD= ata(AbstractUpgradeCatalog.java:551) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLU= pdates(SchemaUpgradeHelper.java:222) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(Schema= UpgradeHelper.java:299) Caused by: org.postgresql.util.PSQLException: ERROR: column "id" does not e= xist Position: 8 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(Qu= eryExecutorImpl.java:2161) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExe= cutorImpl.java:1890) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorIm= pl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc= 2Statement.java:559) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abs= tractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abstrac= tJdbc2Statement.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 o= ccurred during upgrade, failed org.apache.ambari.server.AmbariException: Internal Exception: org.postgresql.util.PSQLException: ERROR: column "id" d= oes not exist Position: 8 Error Code: 0 Call: SELECT id, cluster_id, component_name, current_state, host_id, securi= ty_state, service_name, upgrade_state, version, current_stack_id FROM hostc= omponentstate WHERE ((component_name =3D ?) AND ((cluster_id =3D ?) AND (se= rvice_name =3D ?))) bind =3D> [3 parameters bound] Query: ReadAllQuery(name=3D"hostComponentStateEntities" referenceClass=3DHo= stComponentStateEntity sql=3D"SELECT id, cluster_id, component_name, curren= t_state, host_id, security_state, service_name, upgrade_state, version, cur= rent_stack_id FROM hostcomponentstate WHERE ((component_name =3D ?) AND ((c= luster_id =3D ?) AND (service_name =3D ?)))") at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLU= pdates(SchemaUpgradeHelper.java:225) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(Schema= UpgradeHelper.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" d= oes not exist Position: 8 Error Code: 0 Call: SELECT id, cluster_id, component_name, current_state, host_id, securi= ty_state, service_name, upgrade_state, version, current_stack_id FROM hostc= omponentstate WHERE ((component_name =3D ?) AND ((cluster_id =3D ?) AND (se= rvice_name =3D ?))) bind =3D> [3 parameters bound] Query: ReadAllQuery(name=3D"hostComponentStateEntities" referenceClass=3DHo= stComponentStateEntity sql=3D"SELECT id, cluster_id, component_name, curren= t_state, host_id, security_state, service_name, upgrade_state, version, cur= rent_stack_id FROM hostcomponentstate WHERE ((component_name =3D ?) AND ((c= luster_id =3D ?) AND (service_name =3D ?)))") at org.eclipse.persistence.exceptions.DatabaseException.sqlExceptio= n(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.basicE= xecuteCall(AbstractSession.java:2002) at org.eclipse.persistence.sessions.server.ServerSession.executeCal= l(ServerSession.java:570) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMech= anism.executeCall(DatasourceCallQueryMechanism.java:242) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMech= anism.executeCall(DatasourceCallQueryMechanism.java:228) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMech= anism.executeSelectCall(DatasourceCallQueryMechanism.java:299) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMech= anism.selectAllRows(DatasourceCallQueryMechanism.java:694) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanis= m.selectAllRowsFromTable(ExpressionQueryMechanism.java:2738) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanis= m.selectAllRows(ExpressionQueryMechanism.java:2691) at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelR= eadQuery(ReadAllQuery.java:495) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeData= baseQuery(ObjectLevelReadQuery.java:1168) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQu= ery.java:899) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(Obj= ectLevelReadQuery.java:1127) at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuer= y.java:403) at org.eclipse.persistence.internal.sessions.AbstractSession.intern= alExecuteQuery(AbstractSession.java:3214) at org.eclipse.persistence.internal.sessions.AbstractSession.execut= eQuery(AbstractSession.java:1804) at org.eclipse.persistence.internal.sessions.AbstractSession.execut= eQuery(AbstractSession.java:1786) at org.eclipse.persistence.internal.indirection.QueryBasedValueHold= er.instantiate(QueryBasedValueHolder.java:129) at org.eclipse.persistence.internal.indirection.QueryBasedValueHold= er.instantiate(QueryBasedValueHolder.java:116) at org.eclipse.persistence.internal.indirection.DatabaseValueHolder= .getValue(DatabaseValueHolder.java:89) at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHold= er.instantiateImpl(UnitOfWorkValueHolder.java:173) at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHold= er.instantiate(UnitOfWorkValueHolder.java:234) at org.eclipse.persistence.internal.indirection.DatabaseValueHolder= .getValue(DatabaseValueHolder.java:89) at org.eclipse.persistence.indirection.IndirectList.buildDelegate(I= ndirectList.java:252) at org.eclipse.persistence.indirection.IndirectList.getDelegate(Ind= irectList.java:423) at org.eclipse.persistence.indirection.IndirectList$1.(Indire= ctList.java:551) at org.eclipse.persistence.indirection.IndirectList.listIterator(In= directList.java:550) at org.eclipse.persistence.indirection.IndirectList.iterator(Indire= ctList.java:514) at org.apache.ambari.server.state.ServiceComponentImpl.(Servi= ceComponentImpl.java:126) at org.apache.ambari.server.state.ServiceComponentImpl$$EnhancerByG= uice$$f9afaa16.() at org.apache.ambari.server.state.ServiceComponentImpl$$EnhancerByG= uice$$f9afaa16$$FastClassByGuice$$148e5985.newInstance() at com.google.inject.internal.cglib.reflect.$FastConstructor.newIns= tance(FastConstructor.java:40) at com.google.inject.internal.ProxyFactory$ProxyConstructor.newInst= ance(ProxyFactory.java:260) at com.google.inject.internal.ConstructorInjector.construct(Constru= ctorInjector.java:85) at com.google.inject.internal.ConstructorBindingImpl$Factory.get(Co= nstructorBindingImpl.java:254) at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.ja= va:978) at com.google.inject.internal.InjectorImpl.callInContext(InjectorIm= pl.java:1031) at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:= 974) at com.google.inject.assistedinject.FactoryProvider2.invoke(Factory= Provider2.java:632) at com.sun.proxy.$Proxy17.createExisting(Unknown Source) at org.apache.ambari.server.state.ServiceImpl.(ServiceImpl.ja= va:145) at org.apache.ambari.server.state.ServiceImpl$$EnhancerByGuice$$88c= b5aa2.() at org.apache.ambari.server.state.ServiceImpl$$EnhancerByGuice$$88c= b5aa2$$FastClassByGuice$$e687ffb.newInstance() at com.google.inject.internal.cglib.reflect.$FastConstructor.newIns= tance(FastConstructor.java:40) at com.google.inject.internal.ProxyFactory$ProxyConstructor.newInst= ance(ProxyFactory.java:260) at com.google.inject.internal.ConstructorInjector.construct(Constru= ctorInjector.java:85) at com.google.inject.internal.ConstructorBindingImpl$Factory.get(Co= nstructorBindingImpl.java:254) at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.ja= va:978) at com.google.inject.internal.InjectorImpl.callInContext(InjectorIm= pl.java:1024) at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:= 974) at com.google.inject.assistedinject.FactoryProvider2.invoke(Factory= Provider2.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(C= lusterImpl.java:906) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.addNewCo= nfigurationsFromXml(AbstractUpgradeCatalog.java:275) at org.apache.ambari.server.upgrade.UpgradeCatalog212.executeDMLUpd= ates(UpgradeCatalog212.java:152) at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeD= ata(AbstractUpgradeCatalog.java:551) at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLU= pdates(SchemaUpgradeHelper.java:222) ... 1 more Caused by: org.postgresql.util.PSQLException: ERROR: column "id" does not e= xist Position: 8 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(Qu= eryExecutorImpl.java:2161) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExe= cutorImpl.java:1890) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorIm= pl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc= 2Statement.java:559) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abs= tractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abstrac= tJdbc2Statement.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 star= ting: > - 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 vers= ion is compatible > 29 Oct 2015 16:36:16,932 INFO [main] DatabaseChecker:55 - Checking DB co= nsistency > 29 Oct 2015 16:36:17,023 ERROR [main] AmbariServer:722 - Failed to run th= e Ambari Server > Local Exception Stack: > Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140= 319-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, secu= rity_state, service_name, upgrade_state, version, current_stack_id FROM hos= tcomponentstate WHERE ((component_name =3D ?) AND ((cluster_id =3D > ?) AND (service_name =3D ?))) > bind =3D> [3 parameters bound] > Query: ReadAllQuery(name=3D"hostComponentStateEntities" referenceClass=3D= HostComponentStateEntity sql=3D"SELECT id, cluster_id, component_name, curr= ent_state, host_id, security_state, service_name, upgrade_state, vers > ion, current_stack_id FROM hostcomponentstate WHERE ((component_name =3D = ?) AND ((cluster_id =3D ?) AND (service_name =3D ?)))") > at org.eclipse.persistence.exceptions.DatabaseException.sqlExcept= ion(DatabaseException.java:340) > at org.eclipse.persistence.internal.databaseaccess.DatabaseAccess= or.basicExecuteCall(DatabaseAccessor.java:682) > at org.eclipse.persistence.internal.databaseaccess.DatabaseAccess= or.executeCall(DatabaseAccessor.java:558) > at org.eclipse.persistence.internal.sessions.AbstractSession.basi= cExecuteCall(AbstractSession.java:2002) > at org.eclipse.persistence.sessions.server.ServerSession.executeC= all(ServerSession.java:570) > at org.eclipse.persistence.internal.queries.DatasourceCallQueryMe= chanism.executeCall(DatasourceCallQueryMechanism.java:242) > at org.eclipse.persistence.internal.queries.DatasourceCallQueryMe= chanism.executeCall(DatasourceCallQueryMechanism.java:228) > at org.eclipse.persistence.internal.queries.DatasourceCallQueryMe= chanism.executeSelectCall(DatasourceCallQueryMechanism.java:299) > at org.eclipse.persistence.internal.queries.DatasourceCallQueryMe= chanism.selectAllRows(DatasourceCallQueryMechanism.java:694) > at org.eclipse.persistence.internal.queries.ExpressionQueryMechan= ism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2738) > at org.eclipse.persistence.internal.queries.ExpressionQueryMechan= ism.selectAllRows(ExpressionQueryMechanism.java:2691) > at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLeve= lReadQuery(ReadAllQuery.java:495) > at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDa= tabaseQuery(ObjectLevelReadQuery.java:1168) > at org.eclipse.persistence.queries.DatabaseQuery.execute(Database= Query.java:899) > at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(O= bjectLevelReadQuery.java:1127) > at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQu= ery.java:403) > at org.eclipse.persistence.internal.sessions.AbstractSession.inte= rnalExecuteQuery(AbstractSession.java:3214) > at org.eclipse.persistence.internal.sessions.AbstractSession.exec= uteQuery(AbstractSession.java:1804) > at org.eclipse.persistence.internal.sessions.AbstractSession.exec= uteQuery(AbstractSession.java:1786) > at org.eclipse.persistence.internal.indirection.QueryBasedValueHo= lder.instantiate(QueryBasedValueHolder.java:129) > at org.eclipse.persistence.internal.indirection.QueryBasedValueHo= lder.instantiate(QueryBasedValueHolder.java:116) > at org.eclipse.persistence.internal.indirection.DatabaseValueHold= er.getValue(DatabaseValueHolder.java:89) > at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHo= lder.instantiateImpl(UnitOfWorkValueHolder.java:173) > at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHo= lder.instantiate(UnitOfWorkValueHolder.java:234) > at org.eclipse.persistence.internal.indirection.DatabaseValueHold= er.getValue(DatabaseValueHolder.java:89) > at org.eclipse.persistence.indirection.IndirectList.buildDelegate= (IndirectList.java:252) > at org.eclipse.persistence.indirection.IndirectList.getDelegate(I= ndirectList.java:423) > at org.eclipse.persistence.indirection.IndirectList.isEmpty(Indir= ectList.java:498) > at org.apache.ambari.server.controller.utilities.DatabaseChecker.= checkDBConsistency(DatabaseChecker.java:122) > at org.apache.ambari.server.controller.AmbariServer.run(AmbariSer= ver.java:229) > at org.apache.ambari.server.controller.AmbariServer.main(AmbariSe= rver.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(QueryE= xecutorImpl.java:1890) > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutor= Impl.java:255) > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJd= bc2Statement.java:559) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(A= bstractJdbc2Statement.java:417) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abstr= actJdbc2Statement.java:302) > at org.eclipse.persistence.internal.databaseaccess.DatabaseAccess= or.executeSelect(DatabaseAccessor.java:1007) > at org.eclipse.persistence.internal.databaseaccess.DatabaseAccess= or.basicExecuteCall(DatabaseAccessor.java:642) > ... 29 more > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)