The database columns that it’s having a problem with are part of the 1.7.0 upgrade process. If you were upgrading from a prior version, you’d need to run ‘ambari-server upgrade’ to ensure that your database was upgraded to 1.7.0. If this was a new installation, then perhaps you had an Ambari installation prior to this that left the postgres database on the server. In this case, I’d ensure that there are no Ambari tables in your database when installing a new instance of 1.7.0.
On Dec 8, 2014, at 1:48 AM, guxiaobo1982 <[email protected]> wrote: > Hi, > > I installed a new ambari-server 1.7.0 instance followed by > https://cwiki.apache.org/confluence/display/AMBARI/Install+Ambari+1.7.0+from+Public+Repositories > > but the ambari-server start command failed with the following error messages: > [root@ambari profile.d]# ambari-server start > > Using python /usr/bin/python2.6 > > Starting ambari-server > > Ambari Server running with 'root' privileges. > > Organizing resource files at /var/lib/ambari-server/resources... > > Server PID at: /var/run/ambari-server/ambari-server.pid > > Server out at: /var/log/ambari-server/ambari-server.out > > Server log at: /var/log/ambari-server/ambari-server.log > > Waiting for server start.................... > > ERROR: Exiting with exit code -1. > > REASON: Ambari Server java process died with exitcode 255. Check > /var/log/ambari-server/ambari-server.out for more information. > > [root@ambari profile.d]# more /var/log/ambari-server/ambari-server.out > > [EL Warning]: metadata: 2014-12-08 > 12:48:04.141--ServerSession(1978541334)--The reference column name > [resource_type_id] mapped on the element [field permissions] does not > correspond > > to a valid id or basic field/column on the mapping reference. Will use > referenced column name as provided. > > [EL Info]: 2014-12-08 12:48:06.126--ServerSession(1978541334)--EclipseLink, > version: Eclipse Persistence Services - 2.4.0.v20120608-r11652 > > [EL Info]: connection: 2014-12-08 > 12:48:06.446--ServerSession(1978541334)--file:/usr/lib/ambari-server/ambari-server-1.7.0.169.jar_ambari-server_url=jdbc:postgresql://localhost/ambari > > _user=ambari login successful > > [EL Warning]: 2014-12-08 12:48:08.867--UnitOfWork(1666151420)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.875--UnitOfWork(1936897728)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.877--UnitOfWork(1770101687)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.879--UnitOfWork(1124437166)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.891--UnitOfWork(1706247553)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.895--UnitOfWork(666550176)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.905--UnitOfWork(1383280166)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.911--UnitOfWork(1330395896)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.913--UnitOfWork(1383043715)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.915--UnitOfWork(1894919618)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.922--UnitOfWork(450062259)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.924--UnitOfWork(2021654979)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.926--UnitOfWork(994065503)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.928--UnitOfWork(1766652168)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.932--UnitOfWork(1837687596)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.934--UnitOfWork(149026892)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.941--UnitOfWork(489871843)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.943--UnitOfWork(298529982)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.946--UnitOfWork(158086391)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.95--UnitOfWork(2035281074)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.957--UnitOfWork(519259880)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.961--UnitOfWork(533044247)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.964--UnitOfWork(2144571388)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions > > .DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.981--UnitOfWork(71671833)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions.D > > atabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > [EL Warning]: 2014-12-08 12:48:08.988--UnitOfWork(601748032)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): > org.eclipse.persistence.exceptions. > > DatabaseException > > Internal Exception: org.postgresql.util.PSQLException: ERROR: column > "resource_id" does not exist > > 位置：114 > > Error Code: 0 > > Call: SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_state, resource_id FROM clusters > > Query: ReadAllQuery(name="allClusters" referenceClass=ClusterEntity > sql="SELECT cluster_id, cluster_info, cluster_name, desired_cluster_state, > desired_stack_version, provisioning_stat > > e, resource_id FROM clusters") > > > -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
