Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
2.5.2
-
None
Description
Ambari-server not starting with error about clusterconfig table missing:
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
This table was not created due following issue in table creation DDL:
service_deleted SMALLINT NOT NULL DEFAULT 0, * ERROR at line 11: ORA-00907: missing right parenthesis
Attachments
Attachments
Issue Links
- links to