You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@ambari.apache.org by Jonathan Hurley <jh...@hortonworks.com> on 2017/10/18 20:47:57 UTC
Review Request 63123: Version registration failure during patch
upgrade + Debian + Oracle run
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/63123/
-----------------------------------------------------------
Review request for Ambari and Nate Cole.
Repository: ambari
Description
-------
Oracle doesn't allow DISTINCT on clob fields...
```
SELECT DISTINCT
t0.repo_version_id, t0.display_name, t0.hidden, t0.legacy, t0.repositories, t0.resolved, t0.repo_type, t0.version, t0.version_url,
t0.version_xml, t0.version_xsd, t0.parent_id, t0.stack_id
FROM repo_version t0, servicedesiredstate t1
WHERE ((t1.desired_repo_version_id IN ?) AND (t0.repo_version_id = t1.desired_repo_version_id))
```
```
WARN [ambari-client-thread-17969] ServletHandler:561 - Error Processing URI: /api/v1/version_definitions - (javax.persistence.PersistenceException) Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
```
Diffs
-----
ambari-server/src/main/java/org/apache/ambari/server/orm/entities/RepositoryVersionEntity.java edfe4944b6
ambari-server/src/main/java/org/apache/ambari/server/orm/entities/ServiceDesiredStateEntity.java 0124d3e71c
Diff: https://reviews.apache.org/r/63123/diff/1/
Testing
-------
PENDING...
Thanks,
Jonathan Hurley
Re: Review Request 63123: Version registration failure during patch
upgrade + Debian + Oracle run
Posted by Nate Cole <nc...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/63123/#review188576
-----------------------------------------------------------
Ship it!
Ship It!
- Nate Cole
On Oct. 18, 2017, 4:47 p.m., Jonathan Hurley wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/63123/
> -----------------------------------------------------------
>
> (Updated Oct. 18, 2017, 4:47 p.m.)
>
>
> Review request for Ambari and Nate Cole.
>
>
> Repository: ambari
>
>
> Description
> -------
>
> Oracle doesn't allow DISTINCT on clob fields...
>
> ```
> SELECT DISTINCT
> t0.repo_version_id, t0.display_name, t0.hidden, t0.legacy, t0.repositories, t0.resolved, t0.repo_type, t0.version, t0.version_url,
> t0.version_xml, t0.version_xsd, t0.parent_id, t0.stack_id
> FROM repo_version t0, servicedesiredstate t1
> WHERE ((t1.desired_repo_version_id IN ?) AND (t0.repo_version_id = t1.desired_repo_version_id))
> ```
>
> ```
> WARN [ambari-client-thread-17969] ServletHandler:561 - Error Processing URI: /api/v1/version_definitions - (javax.persistence.PersistenceException) Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
> ```
>
>
> Diffs
> -----
>
> ambari-server/src/main/java/org/apache/ambari/server/orm/entities/RepositoryVersionEntity.java edfe4944b6
> ambari-server/src/main/java/org/apache/ambari/server/orm/entities/ServiceDesiredStateEntity.java 0124d3e71c
>
>
> Diff: https://reviews.apache.org/r/63123/diff/1/
>
>
> Testing
> -------
>
> PENDING...
>
>
> Thanks,
>
> Jonathan Hurley
>
>