[
https://issues.apache.org/jira/browse/AMBARI-23235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16399484#comment-16399484
]
Hudson commented on AMBARI-23235:
---------------------------------
SUCCESS: Integrated in Jenkins build Ambari-trunk-Commit #8859 (See
[https://builds.apache.org/job/Ambari-trunk-Commit/8859/])
AMBARI-23235. SQL errors in schema create script for Oracle (#657) (github:
[https://gitbox.apache.org/repos/asf?p=ambari.git&a=commit&h=522607f6d11ca0ae303fd29344d09ea356fe71df])
* (edit) ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
> SQL errors in Oracle schema create script
> -----------------------------------------
>
> Key: AMBARI-23235
> URL: https://issues.apache.org/jira/browse/AMBARI-23235
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 2.7.0
> Reporter: Denys Buzhor
> Assignee: Doroszlai, Attila
> Priority: Blocker
> Labels: pull-request-available
> Fix For: 2.7.0
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> During deploy on debian 7 with oracle database ambari server reported many
> errors related to SQL queries:
> {noformat}
> 14 Mar 2018 10:51:08,721 ERROR [ExecutionScheduler_QuartzSchedulerThread]
> JobStoreTX:3652 - Couldn't rollback jdbc connection. No more data to read
> from socket
> java.sql.SQLRecoverableException: No more data to read from socket
> {noformat}
> {noformat}
> Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or
> view does not exist
> Error Code: 942
> Call: INSERT INTO hostcomponentstate (id, current_state, last_live_state,
> upgrade_state, version, host_id, service_name, cluster_id, component_name)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
> bind => [9 parameters bound]
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
