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 8F2C918610 for ; Thu, 27 Aug 2015 02:35:27 +0000 (UTC) Received: (qmail 86601 invoked by uid 500); 27 Aug 2015 02:35:27 -0000 Delivered-To: apmail-ambari-user-archive@ambari.apache.org Received: (qmail 86564 invoked by uid 500); 27 Aug 2015 02:35:27 -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 86551 invoked by uid 99); 27 Aug 2015 02:35:27 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Aug 2015 02:35:27 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id DBF961AAD58 for ; Thu, 27 Aug 2015 02:35:26 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.9 X-Spam-Level: ** X-Spam-Status: No, score=2.9 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 08iWTcUO2V4p for ; Thu, 27 Aug 2015 02:35:21 +0000 (UTC) Received: from mail-io0-f170.google.com (mail-io0-f170.google.com [209.85.223.170]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 7815642B92 for ; Thu, 27 Aug 2015 02:35:21 +0000 (UTC) Received: by iodb91 with SMTP id b91so41848095iod.1 for ; Wed, 26 Aug 2015 19:35:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=9XFjMgOQ7EFb1X6C2Z4lRAwK8UAnR1pl+kDlwsiPLB8=; b=pE2WOSYUuWeLUEX9Wt4Le+lJLv0ydZNjC0RJDhpSySfXvX3BkniDbBM4/eQdAKEh2J OGFF6QS0wl14xuF5xO97nK5MFzK8iOet6VGiP8MriBpLAQRC/JmEqARY5Dj1aHIg1tYJ P4d9VK7rgTrTwABwdLI02MLR+oA2WKr5if7sEcNdPY4FfBy3/NpFdbI4is33Xg2ulRNP 6gHOV1HwCiIZm4yjGGMpJQosncZA5p1bfWHQS3xxGOrOYpwmSIG2y7wiNmMWa1xpLd7G s3PLRETBueUu39UIDnUkmbpaH6eKkfsDnU57hilZH2Qb/GXCYVKQa1ALbMM2wQYsXv77 0eOg== MIME-Version: 1.0 X-Received: by 10.107.25.80 with SMTP id 77mr8973690ioz.62.1440642921008; Wed, 26 Aug 2015 19:35:21 -0700 (PDT) Received: by 10.64.59.196 with HTTP; Wed, 26 Aug 2015 19:35:20 -0700 (PDT) In-Reply-To: References: Date: Thu, 27 Aug 2015 10:35:20 +0800 Message-ID: Subject: Re: Ambari 2.1 Upgrade Issue From: Shaik M To: Alejandro Fernandez , user@ambari.apache.org Content-Type: multipart/alternative; boundary=001a113fdc848e1543051e41d103 --001a113fdc848e1543051e41d103 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Alejandro, same output i am getting after changing the argument: [root@sv2lxdpdsedi01 gse]# ambari-server set-current --cluster-name=3Dbdp_hdp_lab_cluster --version-display-name=3D2.3.0.0 Using python /usr/bin/python2.6 Setting current version... Enter Ambari Admin login: admin Enter Ambari Admin password: ERROR: Exiting with exit code 1. REASON: Error during setting current version. Http status code - 400. { "status" : 400, "message" : "java.lang.IllegalArgumentException: Repository version with display name 2.3.0.0 does not exist" } Regards, Shaik On 27 August 2015 at 10:14, Alejandro Fernandez wrote: > Try this one > > ambari-server set-current --cluster-name=3Dbdp_hdp_lab_cluster > --version-display-name=3D*2.3.0.0* > > > From: Shaik M > Date: Wednesday, August 26, 2015 at 5:15 PM > > To: Alejandro Fernandez > Subject: Re: Ambari 2.1 Upgrade Issue > > Hi Alejandro, > > I have ran the finalize step, but it show 100%. after that i didn't get > any confirmation window. > > Please find the attached queries output. > > [root@sv2lxdpdsedi01 gse]# ambari-server set-current > --cluster-name=3Dbdp_hdp_lab_cluster --version-display-name=3D2.3.0.0-255= 7 > Using python /usr/bin/python2.6 > Setting current version... > Enter Ambari Admin login: admin > Enter Ambari Admin password: > ERROR: Exiting with exit code 1. > REASON: Error during setting current version. Http status code - 400. > { > "status" : 400, > "message" : "java.lang.IllegalArgumentException: Repository version wit= h > display name 2.3.0.0-2557 does not exist" > } > > Regards, > Shaik > > On 27 August 2015 at 03:54, Alejandro Fernandez < > afernandez@hortonworks.com> wrote: > >> Hi Shaik, >> >> Try this, >> >> select h.host_name, rv.version, hv.state from host_version hv join host= s >> h on hv.host_id =3D h.host_id join repo_version rv on hv.repo_version_id= =3D >> rv.repo_version_id order by h.host_name, rv.version; >> >> Did your RU ever run the Finalize step to save the DB state? >> You can check this by running, and looking at the last 3 rows. >> >> In Postgres, >> >> SELECT hrc.request_id, u.upgrade_id, u.direction, SUBSTR(g.group_title, >> 0, 40), SUBSTR(i.item_text, 0, 80), SUBSTR(hrc.status, 0, 40), >> hrc.custom_command_name >> >> FROM upgrade_group AS g JOIN upgrade AS u ON g.upgrade_id =3D u.upgrade_= id >> >> JOIN upgrade_item AS i ON i.upgrade_group_id =3D g.upgrade_group_id >> >> JOIN host_role_command AS hrc ON hrc.stage_id =3D i.stage_id AND >> hrc.request_id =3D u.request_id >> >> ORDER BY u.upgrade_id, g.upgrade_group_id, i.stage_id; >> >> In MySQL, >> >> SELECT hrc.request_id, u.upgrade_id, u.direction, LEFT(g.group_title, >> 40), LEFT(i.item_text, 80), LEFT(hrc.status, 40), hrc.custom_command_nam= e >> >> >> FROM upgrade_group AS g JOIN upgrade AS u ON g.upgrade_id =3D u.upgrade_= id >> >> JOIN upgrade_item AS i ON i.upgrade_group_id =3D g.upgrade_group_id >> >> JOIN host_role_command AS hrc ON hrc.stage_id =3D i.stage_id AND >> hrc.request_id =3D u.request_id >> >> ORDER BY u.upgrade_id, g.upgrade_group_id, i.stage_id; >> >> If they did not run, try this, >> >> ambari-server set-current --cluster-name=3D$CLUSTERNAME --version-displa= y-name=3D$VERSION_NAME >> >> >> Note that $VERSION_NAME can be 2.3.0.0 or 2.3.0.0-2557 >> >> Thanks, >> Alejandro >> >> From: Shaik M >> Date: Tuesday, August 25, 2015 at 8:55 PM >> To: Alejandro Fernandez >> Subject: Re: Ambari 2.1 Upgrade Issue >> >> Hi Alejandro, >> >> >> Thank you for helping us to resolving the issue. >> >> >> As you suggested, I have ran the command/quires on our upgraded cluster= . >> please check the below for output. >> >> >> On all hosts, >> >> "hdp-select status", the only versions returned should be 2.3.0.0-2557 o= r >> None. Are any on a different version? >> >> >> >> *It Showing versions are =E2=80=93 =E2=80=9C2.3.0.0-2557=E2=80=9D* >> >> >> >> >> >> Then, run these queries in the DB. >> >> select repo_version_id, version from repo_version; >> >> >> >> ambari=3D> select repo_version_id, version from repo_version; >> >> repo_version_id | version >> >> -----------------+-------------- >> >> 1 | 2.2.0.0-2041 >> >> 2 | 2.2.6.0-2800 >> >> 3 | 2.3.0.0-2557 >> >> (3 rows) >> >> >> >> >> >> select rv.repo_version_id, rv.version, cv.state from cluster_version cv >> join repo_version rv on cv.repo_version_id =3D rv.repo_version_id; >> >> >> >> repo_version_id | version | state >> >> -----------------+--------------+---------- >> >> 1 | 2.2.0.0-2041 | CURRENT >> >> 3 | 2.3.0.0-2557 | UPGRADED >> >> (2 rows) >> >> >> >> >> >> select h.host_name, rv.version, rv.state from host_version hv join host= s >> h on hv.host_id =3D h.host_id join repo_version rv on hv.repo_version_id= =3D >> rv.repo_version_id order by h.host_name, rv.version; >> >> >> >> There is no Column *=E2=80=9CState=E2=80=9D* in *repo_version* rv table= . >> >> >> >> -- can ignore ZKFC, Ambari Metrics, MySQL, and Kerberos in this next que= ry >> >> select h.host_name, hcs.service_name, hcs.component_name, hcs.version >> from hostcomponentstate hcs join hosts h on hcs.host_id =3D h.host_id wh= ere >> hcs.version not in ('2.3.0.0-2557', 'UNKNOWN') order by hcs.service_name= , >> hcs.component_name, h.host_name; >> >> >> >> host_name | service_name | component_name | version >> >> -----------+--------------+----------------+--------- >> >> (0 rows) >> >> >> >> kindly let me know how can i proceed further. >> >> >> Regards, >> >> Shaik M >> >> On 26 August 2015 at 01:26, Alejandro Fernandez < >> afernandez@hortonworks.com> wrote: >> >>> Can you run the following, >>> >>> On all hosts, >>> "hdp-select status", the only versions returned should be 2.3.0.0-2557 >>> or None. Are any on a different version? >>> >>> Then, run these queries in the DB. >>> select repo_version_id, version from repo_version; >>> >>> select rv.repo_version_id, rv.version, cv.state from cluster_version cv >>> join repo_version rv on cv.repo_version_id =3D rv.repo_version_id; >>> >>> select h.host_name, rv.version, rv.state from host_version hv join >>> hosts h on hv.host_id =3D h.host_id join repo_version rv on >>> hv.repo_version_id =3D rv.repo_version_id order by h.host_name, rv.vers= ion; >>> >>> -- can ignore ZKFC, Ambari Metrics, MySQL, and Kerberos in this next >>> query >>> select h.host_name, hcs.service_name, hcs.component_name, hcs.version >>> from hostcomponentstate hcs join hosts h on hcs.host_id =3D h.host_id w= here >>> hcs.version not in ('2.3.0.0-2557', 'UNKNOWN') order by hcs.service_nam= e, >>> hcs.component_name, h.host_name; >>> >>> Thanks, >>> Alejandro >>> >>> From: Shaik M >>> Reply-To: "user@ambari.apache.org" >>> Date: Tuesday, August 25, 2015 at 9:21 AM >>> To: "user@ambari.apache.org" >>> Subject: Ambari 2.1 Upgrade Issue >>> >>> Ambari Team, >>> >>> I am doing upgrade from Ambari 1.7 to 2.1 with HDP2.3. >>> >>> I have finished upgrade procedure and I did finalized upgrade and the >>> status showing 100%. >>> >>> But, when I verified in "Stack and Version" tab, still it showing *"Upg= rade >>> in-process"* . I have attached screenshot for your reference. >>> >>> All service are up and running. Amabri allowing operational changes as >>> well. I have verified all stack versions in cli, it showing 2.3.(attach= e >>> Ambari Stack page) >>> >>> Could you please help us how to complete the process. >>> >>> Regards, >>> Shaik M >>> >>> >>> >>> >>> >> >> > --001a113fdc848e1543051e41d103 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Alejandro,

same output i am getting = after changing the argument:

[root@sv2lxdpdse= di01 gse]# ambari-server set-current --cluster-name=3Dbdp_hdp_lab_cluster -= -version-display-name=3D2.3.0.0
Using pyt= hon =C2=A0/usr/bin/python2.6
Setti= ng current version...
Enter Ambari= Admin login: admin
Enter Ambari A= dmin password:
ERROR: Exiting with= exit code 1.
REASON: Error during= setting current version. Http status code - 400.
=C2=A0{
=C2=A0 &qu= ot;status" : 400,
=C2=A0 &quo= t;message" : "java.lang.IllegalArgumentException: Repository vers= ion with display name 2.3.0.0 does not exist"
}

Regards,
Shaik


On 27 August 2015 at 10:14, Alejandro Fe= rnandez <afernandez@hortonworks.com> wrote:
Try this one

=C2=A0ambari-server set-current --cluster-name=3Dbdp_hdp_lab_cluster -= -version-display-name=3D2.3.0.= 0


From: Shaik M <munna.hadoop@gmail.com> Date: Wednesday, August 26, 2015 at= 5:15 PM

To: Alejandro Fernandez <afernandez@hortonw= orks.com>
Subject: Re: Ambari 2.1 Upgrade Iss= ue

Hi Aleja= ndro,

I hav= e ran the finalize step, but it show 100%. after that i didn't get any = confirmation window.

Pleas= e find the attached queries output.

[root= @sv2lxdpdsedi01 gse]# ambari-server set-current --cluster-name=3Dbdp_hdp_la= b_cluster --version-display-name=3D2.3.0.0-2557
Using python =C2=A0/usr/bin/python2.6
Setting current version...
Enter Ambari Admin login: admin
Enter Ambari Admin password:
ERROR: Exiting with exit code 1.
REASON: Error during setting current version. Http status code= - 400.
=C2=A0{
=C2=A0 "status" : 400,
=C2=A0 "message" : "java.lang.IllegalArgumentEx= ception: Repository version with display name 2.3.0.0-2557 does not exist&q= uot;
}

Regards,
Shaik

On 27 August 2015 at 03:54, Alejandro Fernandez = <afernan= dez@hortonworks.com> wrote:
Hi Shaik,

Try this,

select h.host_name, rv.version, =C2=A0hv.state from host_version hv jo= in hosts h on hv.host_id =3D h.host_id join repo_version rv on hv.repo_vers= ion_id =3D rv.repo_version_id order by h.host_name, rv.version;

Did your RU ever run the Finalize step to save the DB state?
You can check this by running, and looking at the last 3 rows.

In Postgres,

SELECT hrc.re= quest_id, u.u= pgrade_id, u.d= irection, SUBSTR(g.group_title, 0, 40), SUBSTR(i.item_text, 0, 80), SUBSTR(hrc.status, 0, 40), hrc.custom_command_name =C2=A0

FROM upgrade_= groupg.u= pgrade_id =3D u.u= pgrade_id=C2=A0

JOIN upgrade_= item AS i ON i.u= pgrade_group_id =3D g.u= pgrade_group_id=C2=A0

JOIN host_rol= e_command AS hrc= ON hrc= .stage_id =3D i.s= tage_id AND hrc= .request_id =3D u.r= equest_id=C2=A0

ORDER BY <= /span>u.up= grade_id, g.u= pgrade_group_id, i.s= tage_id;


In MySQL,

SELECT hrc.re= quest_id, u.u= pgrade_id, u.d= irection, LEF= T(g= .group_title, 40), LEFT(i.item_text, 80), LEFT(hrc.status, 40), hrc= .custom_command_name=C2=A0

FROM upgrade_= groupg.u= pgrade_id =3D u.u= pgrade_id=C2=A0

JOIN upgrade_= item AS i ON i.u= pgrade_group_id =3D g.u= pgrade_group_id=C2=A0

JOIN host_rol= e_command AS hrc= ON hrc= .stage_id =3D i.s= tage_id AND hrc= .request_id =3D u.r= equest_id=C2=A0

ORDER BY <= /span>u.up= grade_id, g.u= pgrade_group_id, i.s= tage_id;


If they did not run, try this,
ambari-server set-current --cluster-name=3D$CLUSTERNAME --version-displa=
y-name=3D$VERSION_NAME

Note that $VERSION_NAME can be 2.3.0.0 or 2.3.0.0-2557

Thanks,
Alejandro

From: Shaik M <munna.hadoop@gmail.com> Date: Tuesday, August 25, 2015 at 8= :55 PM
To: Alejandro Fernandez <afernandez@hortonw= orks.com>
Subject: Re: Ambari 2.1 Upgrade Iss= ue

Hi Alejandro,


Thank you for helping us to resolving the issue.


As you suggested, I have =C2=A0ran the command/quire= s on our upgraded cluster. please check the below for output. =C2=A0


On all hosts,

"hdp-select status", the only versions ret= urned should be 2.3.0.0-2557 or None. Are any on a different version?

=C2=A0

It Showing ve= rsions are =E2=80=93 =E2=80=9C2.3.0.0-2557=E2=80=9D

=C2=A0

=C2=A0

Then, run these queries in the DB.

select repo_version_id, version from repo_version;

=C2=A0

ambari=3D> select repo_version_id, version from repo_ve= rsion;

=C2=A0repo_version_id |=C2=A0=C2=A0 version

-----------------+--------------

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 1 | 2.2.0.0-2041

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 2 | 2.2.6.0-2800

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 3 | 2.3.0.0-2557

(3 rows)

=C2=A0

=C2=A0

select rv.repo_version_id, rv.version, cv.state from= cluster_version cv join repo_version rv on cv.repo_version_id =3D rv.repo_= version_id;

=C2=A0

repo_version_id |= =C2=A0=C2=A0 version=C2=A0=C2=A0=C2=A0 |=C2=A0 state

-----------------= +--------------+----------

=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1 | 2= .2.0.0-2041 | CURRENT

=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 3 | 2= .3.0.0-2557 | UPGRADED

(2 rows)

=C2=A0

=C2=A0

select h.host_name, rv.version,=C2=A0 rv.state from = host_version hv join hosts h on hv.host_id =3D h.host_id join repo_version = rv on hv.repo_version_id =3D rv.repo_version_id order by h.host_name, rv.ve= rsion;

=C2=A0

There is no Column =E2= =80=9CState=E2=80=9D in =C2=A0repo_version rv table.

=C2=A0

-- can ignore ZKFC, Ambari Metrics, MySQL, and Kerbe= ros in this next query

select h.host_name, hcs.service_name, hcs.component_= name, hcs.version from hostcomponentstate hcs join hosts h on hcs.host_id = =3D h.host_id where hcs.version not in ('2.3.0.0-2557', 'UNKNOW= N') order by hcs.service_name, hcs.component_name, h.host_name;

=C2=A0

host_name | service_name | component_name | version=

-----------+--------------+----------------+---------

(0 rows)



kindly let me know how can i proceed further.


Regards,

Shaik M


On 26 August 2015 at 01:26, Alejandro Fernandez = <afernan= dez@hortonworks.com> wrote:
Can you run the following,

On all hosts,
"hdp-select status", the only versions returned should be 2.= 3.0.0-2557 or None. Are any on a different version?

Then, run these queries in the DB.
select repo_version_id, version from repo_version;

select rv.repo_version_id, rv.version, cv.state from cluster_version c= v join repo_version rv on cv.repo_version_id =3D rv.repo_version_id;

select h.host_name, rv.version, =C2=A0rv.state from host_version hv jo= in hosts h on hv.host_id =3D h.host_id join repo_version rv on hv.repo_vers= ion_id =3D rv.repo_version_id order by h.host_name, rv.version;

-- can ignore ZKFC, Ambari Metrics, MySQL, and Kerberos in this next q= uery
select h.host_name, hcs.service_name, hcs.component_name, hcs.version = from hostcomponentstate hcs join hosts h on hcs.host_id =3D h.host_id where= hcs.version not in ('2.3.0.0-2557', 'UNKNOWN') order by hc= s.service_name, hcs.component_name, h.host_name;

Thanks,
Alejandro

From: Shaik M <munna.hadoop@gmail.com> Reply-To: "user@ambari.apache.org" &= lt;user@ambari.= apache.org>
Date: Tuesday, August 25, 2015 at 9= :21 AM
To: "user@ambari.apache.org" <user@ambari.apache= .org>
Subject: Ambari 2.1 Upgrade Issue

Ambari Team,

I am doing upgrade from Ambari 1.7 to 2.1 with HDP2.3.

I have finished upgrade procedure and I did finalized upgrade and the = status showing 100%.

But, when I verified in "Stack and Version" tab, still it sh= owing "Upgrade in-process"=C2=A0. I have attached screensh= ot for your reference.

All service are up and running. Amabri allowing=C2=A0operational= changes as well. I have verified all stack versions in cli, it showing 2.3= .(attache Ambari Stack page)

Could you please help us how to complete the process.

Regards,
Shaik M=C2=A0



=C2=A0

--001a113fdc848e1543051e41d103--