Mailing-List: contact user-help@ambari.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ambari.apache.org
MIME-Version: 1.0
Sender: dbist13@gmail.com
In-Reply-To: 
 <CAFbeQtHNj5p+wBwfc8Q=8SzqL-tZq7ai-qr2+mMGyGdR-aRO4w@mail.gmail.com>
References: 
 <CAFbeQtHNj5p+wBwfc8Q=8SzqL-tZq7ai-qr2+mMGyGdR-aRO4w@mail.gmail.com>
Date: Wed, 16 Dec 2015 07:55:10 -0500
Message-ID: 
 <CAC_XSQiOjb6gBSSDdd2HnW+QmnNcnv24pUSG0QG-xYeR=3PxoQ@mail.gmail.com>
Subject: Re: Issue while upgrading Ambari from 1.6.1 to 2.1.2
From: Artem Ervits <artemervits@gmail.com>
To: user@ambari.apache.org
Cc: "ambari-dev@incubator.apache.org" <ambari-dev@incubator.apache.org>,
	"ambari-user@incubator.apache.org" <ambari-user@incubator.apache.org>
Content-Type: multipart/alternative; boundary=94eb2c0bd0e8a1d2aa0527036a11

--94eb2c0bd0e8a1d2aa0527036a11
Content-Type: text/plain; charset=UTF-8

Try upgrading to 1.7 first. 1.6 is an old release. Then go to 2.1.2.1.
On Dec 16, 2015 7:43 AM, "Deepak Sharma" <deepakmca05@gmail.com> wrote:

> Hi
> I upgraded Ambari server and agents on the cluster from 1.6.1 to 2.1.2
> The upgrade went fine.
> I can see that 2.1.2 is the version now.
> But while performing the ambari server schema upgrade  , its failing.
>
> 16 Dec 2015 17:13:32,028  INFO [main] ControllerModule:187 - Detected
> POSTGRES as the database type from the JDBC URL
> 16 Dec 2015 17:13:33,607  INFO [main] ControllerModule:564 - Binding and
> registering notification dispatcher class
> org.apache.ambari.server.notifications.dispatchers.EmailDispatcher
> 16 Dec 2015 17:13:33,609  INFO [main] ControllerModule:564 - Binding and
> registering notification dispatcher class
> org.apache.ambari.server.notifications.dispatchers.AlertScriptDispatcher
> 16 Dec 2015 17:13:33,681  INFO [main] ControllerModule:564 - Binding and
> registering notification dispatcher class
> org.apache.ambari.server.notifications.dispatchers.SNMPDispatcher
> 16 Dec 2015 17:13:38,096  INFO [main] SchemaUpgradeHelper:280 - Upgrading
> schema to target version = 2.1.2.1
> 16 Dec 2015 17:13:38,120  INFO [main] SchemaUpgradeHelper:289 - Upgrading
> schema from source version = 1.6.1
> 16 Dec 2015 17:13:38,122  INFO [main] SchemaUpgradeHelper:150 - Upgrade
> path: [{ upgradeCatalog: sourceVersion = 1.6.1, targetVersion = 1.7.0 }, {
> upgradeCatalog: sourceVersion = 1.7.0, targetVersion = 2.0.0 }, {
> upgradeCatalog: sourceVersion = 2.0.0, targetVersion = 2.1.0 }, {
> upgradeCatalog: sourceVersion = 2.1.0, targetVersion = 2.1.1 }, {
> upgradeCatalog: sourceVersion = 2.1.1, targetVersion = 2.1.2 }, {
> upgradeCatalog: sourceVersion = 2.1.2, targetVersion = 2.1.2.1 }, {
> upgradeCatalog: sourceVersion = null, targetVersion = 2.1.2 }]
> 16 Dec 2015 17:13:38,122  INFO [main] SchemaUpgradeHelper:188 - Executing
> DDL upgrade...
> 16 Dec 2015 17:13:38,131  INFO [main] DBAccessorImpl:718 - Executing
> query: ALTER TABLE ambari_sequences RENAME COLUMN "value" to sequence_value
> 16 Dec 2015 17:13:38,136 ERROR [main] DBAccessorImpl:724 - Error executing
> query: ALTER TABLE ambari_sequences RENAME COLUMN "value" to sequence_value
> org.postgresql.util.PSQLException: ERROR: must be owner of relation
> ambari_sequences
>
> Caused by: org.postgresql.util.PSQLException: ERROR: must be owner of
> relation ambari_sequences
>
> I am really stuck here.
> Did anyone faced the same issue ? If yes , what is the resolution.
> Else please help me with the steps to downgrade it back to 1.6.1
> I am running this ambari on SLES 11.
>
>
> --
> Thanks
> Deepak
>

--94eb2c0bd0e8a1d2aa0527036a11
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<p dir=3D"ltr">Try upgrading to 1.7 first. 1.6 is an old release. Then go t=
o 2.1.2.1.</p>
<div class=3D"gmail_quote">On Dec 16, 2015 7:43 AM, &quot;Deepak Sharma&quo=
t; &lt;<a href=3D"mailto:deepakmca05@gmail.com">deepakmca05@gmail.com</a>&g=
t; wrote:<br type=3D"attribution"><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=
=3D"ltr"><div>Hi</div><div>I upgraded Ambari server and agents on the clust=
er from 1.6.1 to 2.1.2</div><div>The upgrade went fine.</div><div>I can see=
 that 2.1.2 is the version now.</div><div>But while performing the ambari s=
erver schema upgrade=C2=A0 , its failing.</div><div><br></div><div>16 Dec 2=
015 17:13:32,028=C2=A0 INFO [main] ControllerModule:187 - Detected POSTGRES=
 as the database type from the JDBC URL<br>16 Dec 2015 17:13:33,607=C2=A0 I=
NFO [main] ControllerModule:564 - Binding and registering notification disp=
atcher class org.apache.ambari.server.notifications.dispatchers.EmailDispat=
cher<br>16 Dec 2015 17:13:33,609=C2=A0 INFO [main] ControllerModule:564 - B=
inding and registering notification dispatcher class org.apache.ambari.serv=
er.notifications.dispatchers.AlertScriptDispatcher<br>16 Dec 2015 17:13:33,=
681=C2=A0 INFO [main] ControllerModule:564 - Binding and registering notifi=
cation dispatcher class org.apache.ambari.server.notifications.dispatchers.=
SNMPDispatcher<br>16 Dec 2015 17:13:38,096=C2=A0 INFO [main] SchemaUpgradeH=
elper:280 - Upgrading schema to target version =3D 2.1.2.1<br>16 Dec 2015 1=
7:13:38,120=C2=A0 INFO [main] SchemaUpgradeHelper:289 - Upgrading schema fr=
om source version =3D 1.6.1<br>16 Dec 2015 17:13:38,122=C2=A0 INFO [main] S=
chemaUpgradeHelper:150 - Upgrade path: [{ upgradeCatalog: sourceVersion =3D=
 1.6.1, targetVersion =3D 1.7.0 }, { upgradeCatalog: sourceVersion =3D 1.7.=
0, targetVersion =3D 2.0.0 }, { upgradeCatalog: sourceVersion =3D 2.0.0, ta=
rgetVersion =3D 2.1.0 }, { upgradeCatalog: sourceVersion =3D 2.1.0, targetV=
ersion =3D 2.1.1 }, { upgradeCatalog: sourceVersion =3D 2.1.1, targetVersio=
n =3D 2.1.2 }, { upgradeCatalog: sourceVersion =3D 2.1.2, targetVersion =3D=
 2.1.2.1 }, { upgradeCatalog: sourceVersion =3D null, targetVersion =3D 2.1=
.2 }]<br>16 Dec 2015 17:13:38,122=C2=A0 INFO [main] SchemaUpgradeHelper:188=
 - Executing DDL upgrade...<br>16 Dec 2015 17:13:38,131=C2=A0 INFO [main] D=
BAccessorImpl:718 - Executing query: ALTER TABLE ambari_sequences RENAME CO=
LUMN &quot;value&quot; to sequence_value<br>16 Dec 2015 17:13:38,136 ERROR =
[main] DBAccessorImpl:724 - Error executing query: ALTER TABLE ambari_seque=
nces RENAME COLUMN &quot;value&quot; to sequence_value<br>org.postgresql.ut=
il.PSQLException: ERROR: must be owner of relation ambari_sequences<br>=C2=
=A0=C2=A0=C2=A0=C2=A0<br>Caused by: org.postgresql.util.PSQLException: ERRO=
R: must be owner of relation ambari_sequences<br></div><div><br></div><div>=
I am really stuck here.</div><div>Did anyone faced the same issue ? If yes =
, what is the resolution.</div><div>Else please help me with the steps to d=
owngrade it back to 1.6.1 </div><div>I am running this ambari on SLES 11.</=
div><div><br clear=3D"all"><br>-- <br></div><div><div dir=3D"ltr">Thanks<br=
>Deepak</div></div>
</div>
</blockquote></div>

--94eb2c0bd0e8a1d2aa0527036a11--