[jira] [Resolved] (AMBARI-24992) Ambari Upgrade from 2.6.2.2 to 2.7.1.0 fails in Schema upgrade phase due to long certificate

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

     [ https://issues.apache.org/jira/browse/AMBARI-24992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sandor Molnar resolved AMBARI-24992.
------------------------------------
    Resolution: Fixed

> Ambari Upgrade from 2.6.2.2 to 2.7.1.0 fails in Schema upgrade phase due to long certificate 
> ---------------------------------------------------------------------------------------------
>
>                 Key: AMBARI-24992
>                 URL: https://issues.apache.org/jira/browse/AMBARI-24992
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.7.0
>            Reporter: Akhil S Naik
>            Assignee: Sandor Molnar
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 2.8.0
>
>          Time Spent: 3h 10m
>  Remaining Estimate: 0h
>
> I am trying to upgrade to ambari-2.7.0 using  command : *ambari-server upgrade*
> the upgrade operation is failing on Schema upgrade phase
> The exception is : 
> {code:java}
> Internal Exception: java.sql.BatchUpdateException: Batch entry 2 INSERT INTO ambari_configuration (property_name, category_name, property_value) VALUES ('ambari.sso.provider.certificate','sso-configuration',<LONG VERTIFICATE VALUE>') was aborted: ERROR: value too long for type character varying(2048)  Call getNextException to see other errors in the batch.
> {code}
> and i see as per https://github.com/apache/ambari/blob/trunk/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql#L125
> ambari is having : 
> {code:java}
> CREATE TABLE ambari_configuration (
>   category_name VARCHAR(100) NOT NULL,
>   property_name VARCHAR(100) NOT NULL,
>   property_value VARCHAR(2048),
>   CONSTRAINT PK_ambari_configuration PRIMARY KEY (category_name, property_name));
> {code}
> property_value as 2048 but i am having certificate length 2050 and ambari is not accepting it.
> this should be fixed.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)