Denys Buzhor created AMBARI-23235: ------------------------------------- Summary: 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 Fix For: 2.7.0
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)