Sandor Molnar created AMBARI-25001:
--------------------------------------
Summary: Ambari Upgrade from 2.6.2.2 to 2.7.1.0 fails in Schema
upgrade phase due to long certificate
Key: AMBARI-25001
URL: https://issues.apache.org/jira/browse/AMBARI-25001
Project: Ambari
Issue Type: Bug
Components: ambari-server
Affects Versions: 2.7.0
Reporter: Sandor Molnar
Assignee: Sandor Molnar
Fix For: 2.8.0
During the upgrade process to AMBARI 2.7.0 the upgrade operation is failing on
Schema upgrade phase due to the following error:
{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 CERTIFICATE
VALUE>') was aborted: ERROR: value too long for type character varying(2048)
{code}
Ambari is having the following DDL for {{ambari_configuration}}:
{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}} 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}})
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
