-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/59943/
-----------------------------------------------------------
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
