Mailing-List: contact dev-help@ambari.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ambari.apache.org
Content-Type: multipart/alternative;
 boundary="===============0232451991484351632=="
MIME-Version: 1.0
Subject: Re: Review Request 33592: Unable to issue restart command,
 host_id column in requestoperationlevel table requires NULLable
From: "Jonathan Hurley" <jhurley@hortonworks.com>
To: "Sumit Mohanty" <smohanty@hortonworks.com>,
 "Sid Wagle" <swagle@hortonworks.com>,
 "Jaimin Jetly" <jaimin@hortonworks.com>,
 "Jonathan Hurley" <jhurley@hortonworks.com>
Cc: "Ambari" <dev@ambari.apache.org>,
 "Alejandro Fernandez" <afernandez@hortonworks.com>
Date: Mon, 27 Apr 2015 18:31:47 -0000
Message-ID: <20150427183147.26756.32047@reviews.apache.org>
Auto-Submitted: auto-generated
Sender: "Jonathan Hurley" <noreply@reviews.apache.org>
References: <20150427182352.26756.7785@reviews.apache.org>
In-Reply-To: <20150427182352.26756.7785@reviews.apache.org>
Reply-To: "Jonathan Hurley" <jhurley@hortonworks.com>

--===============0232451991484351632==
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/33592/#review81711
-----------------------------------------------------------

Ship it!


Ship It!

- Jonathan Hurley


On April 27, 2015, 2:23 p.m., Alejandro Fernandez wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/33592/
> -----------------------------------------------------------
> 
> (Updated April 27, 2015, 2:23 p.m.)
> 
> 
> Review request for Ambari, Jaimin Jetly, Jonathan Hurley, Sumit Mohanty, and Sid Wagle.
> 
> 
> Bugs: AMBARI-10774
>     https://issues.apache.org/jira/browse/AMBARI-10774
> 
> 
> Repository: ambari
> 
> 
> Description
> -------
> 
> Error:
> 
> ```
> Error message: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: null value in column "host_id" violates not-null constraint
> Error Code: 0
> Call: INSERT INTO requestoperationlevel (operation_level_id, cluster_name, host_component_name, host_id, level_name, request_id, service_name) VALUES (?, ?, ?, ?, ?, ?, ?)
> 	bind => [7 parameters bound]
> Query: InsertObjectQuery(org.apache.ambari.server.orm.entities.RequestResourceFilterEntity@7fc800da)
> ```
> 
> 
> Diffs
> -----
> 
>   ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql d9e546f 
>   ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql 37aaf7d 
>   ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql 8b1aaad 
>   ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql f0686a9 
>   ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql f5433f1 
> 
> Diff: https://reviews.apache.org/r/33592/diff/
> 
> 
> Testing
> -------
> 
> Applied changes to sql scripts after installing RPMs for ambari-server, but before running ambari-server setup -s.
> Verified that the schema was created with host_id allowing NULLs in requestoperationlevel, and that after deploying a cluster was able to issue a RESTART command.
> 
> ```
> ambari=> select * from requestoperationlevel;
>  operation_level_id | request_id | level_name | cluster_name | service_name | host_component_name | host_id
> --------------------+------------+------------+--------------+--------------+---------------------+---------
>                   2 |          5 | Service    | c1           | ZOOKEEPER    |                     |
> (1 row)
> ```
> 
> 
> Thanks,
> 
> Alejandro Fernandez
> 
>


--===============0232451991484351632==--