You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2015/08/20 21:41:46 UTC
[jira] [Commented] (AMBARI-12836) During upgrade, ALTER statements
to change nullability of columns are not taking effect
[ https://issues.apache.org/jira/browse/AMBARI-12836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14705620#comment-14705620 ]
Hudson commented on AMBARI-12836:
---------------------------------
FAILURE: Integrated in Ambari-branch-2.1 #403 (See [https://builds.apache.org/job/Ambari-branch-2.1/403/])
AMBARI-12836 During upgrade, ALTER statements to change nullability of columns are not taking effect (dsen) (dsen: http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=38197a3ad3bcb45b17aa0995b662c8ef4e088374)
* ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessor.java
* ambari-server/src/main/java/org/apache/ambari/server/orm/helpers/dbms/PostgresHelper.java
* ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeCatalog211Test.java
* ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog211.java
* ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java
> During upgrade, ALTER statements to change nullability of columns are not taking effect
> ---------------------------------------------------------------------------------------
>
> Key: AMBARI-12836
> URL: https://issues.apache.org/jira/browse/AMBARI-12836
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server, ambari-upgrade
> Affects Versions: 2.1.0
> Reporter: Dmytro Sen
> Assignee: Dmytro Sen
> Priority: Blocker
> Fix For: 2.1.1
>
> Attachments: AMBARI-12836_2.patch
>
>
> I think that the alterColumn in the upgrade catalog may not be working.
> {code}
> dbAccessor.alterColumn("viewinstanceproperty", new DBColumnInfo("value",
> String.class, 2000, null, true));{code}
> Performed a deployment of 1.6.1 and upgraded to 2.0.1. The column is still not nullable.
> {code}ambari=> \d+ viewinstanceproperty;
> Table "ambari.viewinstanceproperty"
> Column | Type | Modifiers | Storage | Description
> --------------------+-------------------------+-----------+----------+-------------
> view_name | character varying(255) | not null | extended |
> view_instance_name | character varying(255) | not null | extended |
> name | character varying(255) | not null | extended |
> value | character varying(2000) | not null | extended |
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)