[jira] [Commented] (AMBARI-21209) Incorrect ambari DDL script for Oracle DB

["Hudson (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AMBARI-21209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16044284#comment-16044284 ] 

Hudson commented on AMBARI-21209:
---------------------------------

SUCCESS: Integrated in Jenkins build Ambari-branch-2.5 #1583 (See [https://builds.apache.org/job/Ambari-branch-2.5/1583/])
AMBARI-21209. Incorrect ambari DDL script for Oracle DB (dlysnichenko) (dlysnichenko: [http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=5bf613fa7a979dc2038e14e4ac7a669c2c092197])
* (edit) ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql


> Incorrect ambari DDL script for Oracle DB
> -----------------------------------------
>
>                 Key: AMBARI-21209
>                 URL: https://issues.apache.org/jira/browse/AMBARI-21209
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.5.2
>            Reporter: Dmitry Lysnichenko
>            Assignee: Dmitry Lysnichenko
>            Priority: Blocker
>             Fix For: 2.5.2
>
>         Attachments: AMBARI-21209.patch, AMBARI-21209.trunk.patch
>
>
> 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}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)