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)
