Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Duplicate
-
2.7.0
-
None
Description
During the upgrade process to AMBARI 2.7.0 the upgrade operation is failing on Schema upgrade phase due to the following error:
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 CERTIFICATE VALUE>') was aborted: ERROR: value too long for type character varying(2048)
Ambari is having the following DDL for ambari_configuration:
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 is set to maximum of 2048 bytes/chars which is obviously not enough in some cases.
Checking the currently supported DBs we may set this column to 4000 (except for Postgres where the recommended type is text)
Attachments
Issue Links
- duplicates
-
-
- Resolved
-