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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.7.0
• Fix Version/s: 2.8.0, 2.7.4
• Component/s: ambari-server
• Labels: pull-request-available
• Assignee: Dmytro Grinenko
• Reporter: Akhil Naik
• Created: 04/Dec/18 12:46
• Updated: 10/Nov/22 17:58
• Resolved: 19/Jun/19 06:55

Description

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 :

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.

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 :

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

property_value as 2048 but i am having certificate length 2050 and ambari is not accepting it.

this should be fixed.

Issue Links

• is duplicated by: AMBARI-25001 Ambari Upgrade from 2.6.2.2 to 2.7.1.0 fails in Schema upgrade phase due to long certificate
• relates to: AMBARI-25312 Ambari 2.7.4 is missing upgrade catalogs
• links to: GitHub PR#3480
• links to: GitHub Pull Request #2694
• links to: GitHub Pull Request #3019