[ 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)