Return-Path: X-Original-To: apmail-ambari-user-archive@www.apache.org Delivered-To: apmail-ambari-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C91C81733D for ; Thu, 30 Apr 2015 16:47:28 +0000 (UTC) Received: (qmail 64181 invoked by uid 500); 30 Apr 2015 16:47:28 -0000 Delivered-To: apmail-ambari-user-archive@ambari.apache.org Received: (qmail 64151 invoked by uid 500); 30 Apr 2015 16:47:28 -0000 Mailing-List: contact user-help@ambari.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ambari.apache.org Delivered-To: mailing list user@ambari.apache.org Received: (qmail 64141 invoked by uid 99); 30 Apr 2015 16:47:28 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Apr 2015 16:47:28 +0000 X-ASF-Spam-Status: No, hits=3.9 required=5.0 tests=FORGED_YAHOO_RCVD,HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: error (athena.apache.org: encountered temporary error during SPF processing of domain of j_thakrar@yahoo.com) Received: from [54.191.145.13] (HELO mx1-us-west.apache.org) (54.191.145.13) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Apr 2015 16:47:22 +0000 Received: from nm1-vm0.bullet.mail.ne1.yahoo.com (nm1-vm0.bullet.mail.ne1.yahoo.com [98.138.91.74]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id 4A04426078 for ; Thu, 30 Apr 2015 16:46:42 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1430412395; bh=xwyyhnRfzDOrIWTGmHfGFb8jA+Wi5iHRE3sKWbcInEQ=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=oXTG60o/icJqn+xyHVfW5gqzDYhQI2CRpebT55iUQMNDYak/9nkpdzM6yC4ZyldtshXe3FqCTNMLUxD3D4Zwu5nvTjc8xOM9e7ENnC6fn4rzPIsgP6ScJvIMb02igDXh1Za1tUQF2s7CHkv/DjPtLWbmjuzh+tkjphuUwoZ/1X8XK2YZG33QfXTBof+K3tiP4R/BiVO8RiS0a/BE5nbgEHP7wdkXUpTR6hCoKB0fS6epApMeba/58+dUdVel9UOAptR6GQ7vzfsO/OP01dgKsj/DG8AtBoLvSxKErTrypfb9aNNDkwxEjg7zjKTGQN+doaFSN1OvasP3l7UWSjiK8w== Received: from [98.138.100.102] by nm1.bullet.mail.ne1.yahoo.com with NNFMP; 30 Apr 2015 16:46:35 -0000 Received: from [98.138.89.194] by tm101.bullet.mail.ne1.yahoo.com with NNFMP; 30 Apr 2015 16:46:35 -0000 Received: from [127.0.0.1] by omp1052.mail.ne1.yahoo.com with NNFMP; 30 Apr 2015 16:46:35 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 25035.74244.bm@omp1052.mail.ne1.yahoo.com X-YMail-OSG: G8KHn5wVM1kPiLp0_rboouhdZo4_WFfXhj6MhS5LF_CX6sPc2KeNAkgEURbmuFn UT8qNcoLaGMHwr0.VNI9NvbAqFwDkajrcw6Rjt_OqNFK4eXbH31ZlQyflQARuS6WV3jS8642paeR atDcuYHUrIOTOdd.WYN3KW8Vafm7zWTr.642iKjdq0vSp7l0OiP1e_M.JaK_XKdZiQB9zMemvSJO 5D70u8oJahFyck8hnP1RvyBtmiAKtiA08r4qFFX1v2LrkIGjMv9u6D1Dc_MWbEMZlrlpQr2rd_WB qrMRmWJTHcAD2bT307WSs0hwXQgFa93zo_dSxDZCeecdxRD69UATd0_J7MmQTGLwTTxkHc3jc7FH fYmBBFh2ZrLoZh75TEAOpUct4ZA7ACJGfgWyWjKj83jkAtx.CPpvvPIQ1T2iToeWd7aYrb0oqMHK QHtEf1uwWWI9.n0IN3OQOf9LmjypKPK4mwtZ9BMaMWUOXv9lAFWH34Ph5MlL5XqeXj4DEr0pzNP1 oG8k3v1xOjFmXMPmLzXq5Wg_OQWR2vKA7ljej Received: by 98.138.105.227; Thu, 30 Apr 2015 16:46:34 +0000 Date: Thu, 30 Apr 2015 16:46:34 +0000 (UTC) From: Jayesh Thakrar Reply-To: Jayesh Thakrar To: "user@ambari.apache.org" Message-ID: <67926966.1390470.1430412394067.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: References: Subject: Re: Ambari 2.0 - Blueprint with configuration fails MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1390469_701926332.1430412394058" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_1390469_701926332.1430412394058 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Speaking of upgrade - is there any documentation on upgrading from 1.7 to 2= .0? From: Jonathan Hurley To: "user@ambari.apache.org" =20 Sent: Thursday, April 30, 2015 11:28 AM Subject: Re: Ambari 2.0 - Blueprint with configuration fails =20 Is this an upgrade from Ambari 1.7.0? If so, you might be hitting=C2=A0http= s://issues.apache.org/jira/browse/AMBARI-10665 Seems like the config_attributes column was missed on a few tables. If that= =E2=80=99s the case, then you can shut down Ambari Server and add the missi= ng column manually to your database. On Apr 30, 2015, at 12:01 PM, Romain wrote: Hi all, I have a strange error when I POST a Blueprint with configuration inside. For example, I choose this blueprint $ curl 'https://cwiki.apache.org/confluence/download/attachments/55151584/h= dfs_ha_blueprint.json?version=3D3&modificationDate=3D1430388955000&api=3Dv2= ' > /tmp/blueprint When I send it it fails. $ curl -u admin:admin -X POST -H 'X-Requested-By: scalr' http://localhost:8= 080/api/v1/blueprints/blueprint-$cluster -d @/tmp/blueprint { =C2=A0 "status": 500, =C2=A0 "message": "javax.persistence.RollbackException: Exception [EclipseL= ink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.ecl= ipse.persistence.exceptions.DatabaseException\nInternal Exception: java.sql= .BatchUpdateException: Batch entry 0 INSERT INTO blueprint_configuration (t= ype_name, config_attributes, config_data, blueprint_name) VALUES (\u0027hdf= s-site\u0027, \u0027{}\u0027, \u0027{\"dfs.namenode.https-address\":\"%HOST= GROUP::master_1%:50470\",\"dfs.ha.namenodes.mycluster\":\"nn1,nn2\",\"dfs.n= amenode.http-address\":\"%HOSTGROUP::master_1%:50070\",\"dfs.nameservices\"= :\"mycluster\",\"dfs.namenode.https-address.mycluster.nn2\":\"%HOSTGROUP::m= aster_3%:50470\",\"dfs.namenode.https-address.mycluster.nn1\":\"%HOSTGROUP:= :master_1%:50470\",\"dfs.ha.fencing.methods\":\"shell(/bin/true)\",\"dfs.ha= .automatic-failover.enabled\":\"true\",\"dfs.client.failover.proxy.provider= .mycluster\":\"org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailover= ProxyProvider\",\"dfs.namenode.http-address.mycluster.nn2\":\"%HOSTGROUP::m= aster_3%:50070\",\"dfs.namenode.http-address.mycluster.nn1\":\"%HOSTGROUP::= master_1%:50070\",\"dfs.namenode.rpc-address.mycluster.nn2\":\"%HOSTGROUP::= master_3%:8020\",\"dfs.namenode.shared.edits.dir\":\"qjournal://%HOSTGROUP:= :master_1%:8485;%HOSTGROUP::master_2%:8485;%HOSTGROUP::master_3%:8485/myclu= ster\",\"dfs.namenode.rpc-address.mycluster.nn1\":\"%HOSTGROUP::master_1%:8= 020\"}\u0027, \u0027blueprint-\u0027) was aborted.=C2=A0 Call getNextExcept= ion to see the cause.\nError Code: 0\nCall: INSERT INTO blueprint_configura= tion (type_name, config_attributes, config_data, blueprint_name) VALUES (?,= ?, ?, ?)\n\tbind \u003d\u003e [4 parameters bound]\nQuery: InsertObjectQue= ry(org.apache.ambari.server.orm.entities.HostGroupEntity@1782a3fd) And if I remove the configuration part it works. In the pg logs files I can see this:=20 =3D=3D> /var/lib/pgsql/data/pg_log/postgresql-Thu.log <=3D=3D ERROR:=C2=A0 column "config_attributes" of relation "blueprint_configuratio= n" does not exist at character 49 STATEMENT:=C2=A0 INSERT INTO blueprint_configuration (type_name, config_att= ributes, config_data, blueprint_name) VALUES ($1, $2, $3, $4) ERROR:=C2=A0 current transaction is aborted, commands ignored until end of = transaction block STATEMENT:=C2=A0 SELECT 1 # rpm -qa |grep ambari ambari-server-2.0.0-151.noarch Any idea ? Cheers Romain ------=_Part_1390469_701926332.1430412394058 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Speaking of upgrade - is there any documentation o= n upgrading from 1.7 to 2.0?

From: Jonathan Hurley <jhurley= @hortonworks.com>
To: "user@ambari.apache.org" <user@ambari.apache.org>
Sent: Thursday, April 30, 2015 11:28 = AM
Subject: Re: Ambari= 2.0 - Blueprint with configuration fails

Is thi= s an upgrade from Ambari 1.7.0? If so, you might be hitting 

Seems = like the config_attributes column was missed on a few tables. If that=E2=80= =99s the case, then you can shut down Ambari Server and add the missing col= umn manually to your database.



On Apr= 30, 2015, at 12:01 PM, Romain <filirom1@gmail.com> wrote:

Hi all= ,

I have a strange error when I POST a Blueprint with configuration inside.
For example, I choose this blueprint
When I send it it fails.

$ curl -u admin:admin -X POST -H 'X-Requested-By: scalr' http://localhost:8080/api/v1/blueprints/blueprint-$cluster -d @/tmp/blu= eprint
{
  "status": 500,
  "message": "javax.persistence.RollbackException: Exception [EclipseL= ink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.ecl= ipse.persistence.exceptions.DatabaseException\nInternal Exception: java.sql= .BatchUpdateException: Batch entry 0 INSERT INTO blueprint_configuration (type_name, config_attributes, config_= data, blueprint_name) VALUES (\u0027hdfs-site\u0027, \u0027{}\u0027, \u0027= {\"dfs.namenode.https-address\":\"%HOSTGROUP::master_1%:50470\",\"dfs.ha.na= menodes.mycluster\":\"nn1,nn2\",\"dfs.namenode.http-address\":\"%HOSTGROUP:= :master_1%:50070\",\"dfs.nameservices\":\"mycluster\",\"dfs.namenode.https-= address.mycluster.nn2\":\"%HOSTGROUP::master_3%:50470\",\"dfs.namenode.http= s-address.mycluster.nn1\":\"%HOSTGROUP::master_1%:50470\",\"dfs.ha.fencing.= methods\":\"shell(/bin/true)\",\"dfs.ha.automatic-failover.enabled\":\"true= \",\"dfs.client.failover.proxy.provider.mycluster\":\"org.apache.hadoop.hdf= s.server.namenode.ha.ConfiguredFailoverProxyProvider\",\"dfs.namenode.http-= address.mycluster.nn2\":\"%HOSTGROUP::master_3%:50070\",\"dfs.namenode.http= -address.mycluster.nn1\":\"%HOSTGROUP::master_1%:50070\",\"dfs.namenode.rpc= -address.mycluster.nn2\":\"%HOSTGROUP::master_3%:8020\",\"dfs.namenode.shar= ed.edits.dir\":\"qjournal://%HOSTGROUP::master_1%:8485;%HOSTGROUP::master_2%:8485= ;%HOSTGROUP::master_3%:8485/mycluster\",\"dfs.namenode.rpc-address.mycl= uster.nn1\":\"%HOSTGROUP::master_1%:8020\"}\u0027, \u0027blueprint-\u0027) was aborted.  Call getNextException to see th= e cause.\nError Code: 0\nCall: INSERT INTO blueprint_configuration (type_na= me, config_attributes, config_data, blueprint_name) VALUES (?, ?, ?, ?)\n\t= bind \u003d\u003e [4 parameters bound]\nQuery: InsertObjectQuery(org.apache.ambari.server.orm.entities.HostGroupEntity@17= 82a3fd)


And if I remove the configuration part it work= s.



In the pg logs files I can see this:

=3D=3D> /var/lib/pgsql/data/pg_log/postgresql-Thu.log <=3D=3D
ERROR:  column "config_attributes" of relation "blueprint_configuratio= n" does not exist at character 49
STATEMENT:  INSERT INTO blueprint_configuration (type_name, config_att= ributes, config_data, blueprint_name) VALUES ($1, $2, $3, $4)
ERROR:  current transaction is aborted, commands ignored until end of = transaction block
STATEMENT:  SELECT 1



# rpm -qa |grep ambari
ambari-server-2.0.0-151.noarch



Any idea ?

Cheers
Romain



------=_Part_1390469_701926332.1430412394058--