Supreeth Sharma created AMBARI-22267:
----------------------------------------
Summary: Version registration failure during patch upgrade +
Debian + Oracle run
Key: AMBARI-22267
URL: https://issues.apache.org/jira/browse/AMBARI-22267
Project: Ambari
Issue Type: Bug
Components: ambari-upgrade
Affects Versions: 2.6.0
Environment: ambari-server --version 2.6.0.0-236
ambari DB : Oracle
Reporter: Supreeth Sharma
Priority: Blocker
Fix For: 2.6.0
Live cluster :http://172.27.58.135:8080
Test steps :
1) Install ambari 2.5.2 with HDP-2.6.2.0-205
2) Upgrade ambari to 2.6.0.0-236
3) Run EU and upgrade stack to 2.6.3.0-205
4) Now try to register the VDF for PU and version registration is failing.
read version info api :
http://172.27.58.135:8080/api/v1/version_definitions?skip_url_check=true&dry_run=true
is throwing 500 server error and failing with below error :
{code}
Error Code: 932
Call: 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))
bind => [2 parameters bound]
Query: ReportQuery(name="findByServiceDesiredVersion"
referenceClass=ServiceDesiredStateEntity sql="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))")
18 Oct 2017 19:50:10,308 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
{code}
Attaching the complete log and vdf file.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
