----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/59943/#review177455 -----------------------------------------------------------
Ship it! Ship It! - Dmytro Sen On Июнь 9, 2017, 9:53 д.п., Dmitro Lisnichenko wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/59943/ > ----------------------------------------------------------- > > (Updated Июнь 9, 2017, 9:53 д.п.) > > > Review request for Ambari, Dmytro Sen, Jonathan Hurley, and Nate Cole. > > > Bugs: AMBARI-21209 > https://issues.apache.org/jira/browse/AMBARI-21209 > > > Repository: ambari > > > Description > ------- > > Ambari-server not starting with error about clusterconfig table missing: > {code} > Call: SELECT t0.config_id, t0.cluster_id, t0.service_deleted, t0.version_tag, > t0.create_timestamp, t0.type_name, t0.version, t0.stack_id FROM clusterconfig > t0 WHERE (((SELECT COUNT(t1.service_config_id) FROM serviceconfigmapping t2, > serviceconfig t1 WHERE ((t2.config_id = t0.config_id) AND > (t1.service_config_id = t2.service_config_id))) = ?) AND (t0.type_name <> ?)) > bind => [2 parameters bound] > Query: > ReadAllQuery(name="ClusterConfigEntity.findNotMappedClusterConfigsToService" > referenceClass=ClusterConfigEntity sql="SELECT t0.config_id, t0.cluster_id, > t0.service_deleted, t0.version_tag, t0.create_timestamp, t0.type_name, > t0.version, t0.stack_id FROM clusterconfig t0 WHERE (((SELECT > COUNT(t1.service_config_id) FROM serviceconfigmapping t2, serviceconfig t1 > WHERE ((t2.config_id = t0.config_id) AND (t1.service_config_id = > t2.service_config_id))) = ?) AND (t0.type_name <> ?))") > FetchGroup(){serviceConfigEntities, stack, configId, > configGroupConfigMappingEntities, clusterId, tag, serviceDeleted, type, > version, timestamp, clusterEntity} > at > org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340) > at > org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684) > at > org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560) > at > org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055) > 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:2740) > at > org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693) > at > org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:559) > at > org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1175) > at > org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904) > at > org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1134) > at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:460) > at > org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1222) > at > org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) > at > org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857) > at > org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) > at > org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804) > at > org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258) > ... 7 more > Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does > not exist > {code} > This table was not created due following issue in table creation DDL: > {code} > service_deleted SMALLINT NOT NULL DEFAULT 0, > * > ERROR at line 11: > ORA-00907: missing right parenthesis > {code} > > > Diffs > ----- > > ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql 903fc9ee5c > > > Diff: https://reviews.apache.org/r/59943/diff/1/ > > > Testing > ------- > > mvn clean test > > > Thanks, > > Dmitro Lisnichenko > >