You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2019/06/19 07:35:00 UTC
[jira] [Commented] (AMBARI-24992) Ambari Upgrade from 2.6.2.2 to
2.7.1.0 fails in Schema upgrade phase due to long certificate
[ https://issues.apache.org/jira/browse/AMBARI-24992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16867305#comment-16867305 ]
Hudson commented on AMBARI-24992:
---------------------------------
SUCCESS: Integrated in Jenkins build Ambari-branch-2.7 #529 (See [https://builds.apache.org/job/Ambari-branch-2.7/529/])
AMBARI-24992. Ambari Upgrade from 2.6.2.2 to 2.7.1.0 fails in Schema (github: [https://gitbox.apache.org/repos/asf?p=ambari.git&a=commit&h=e46711740859232679bd3e8a48fe6c27c31e8f19])
* (edit) ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java
* (edit) ambari-server/src/main/java/org/apache/ambari/server/upgrade/SchemaUpgradeHelper.java
* (edit) ambari-server/src/test/java/org/apache/ambari/server/orm/DBAccessorImplTest.java
* (edit) ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
* (add) ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog274.java
* (edit) ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql
* (edit) ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
* (edit) ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
* (edit) ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessor.java
* (edit) ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql
* (add) ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeCatalog274Test.java
* (edit) ambari-server/src/main/java/org/apache/ambari/server/upgrade/AbstractUpgradeCatalog.java
> 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: Dmytro Grinenko
> Priority: Major
> Labels: pull-request-available
> Fix For: 2.8.0, 2.7.4
>
> Time Spent: 4h 40m
> 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)