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

["Akhil S Naik (JIRA)" <ji...@apache.org>]

Akhil S Naik created AMBARI-24992:
-------------------------------------

             Summary: 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: Robert Levas


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)