This is a new installation, I even uninstalled postgresql before installing ambari-server.
------------------ Original ------------------ From: "Jonathan Hurley";<[email protected]>; Send time: Tuesday, Dec 9, 2014 2:30 AM To: "user"<[email protected]>; Subject: Re: ambari-server 1.7.0 can't start 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.
