phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Flavio Pompermaier <pomperma...@okkam.it>
Subject Re: Error upgrading from from 4.7.x to 4.13.x
Date Mon, 18 Dec 2017 00:00:51 GMT
I'installed phoenix 4.7 via the last official Cloudera Parcel. Then I
upgraded Phoenix with the new (unofficial) Parcel. Nothing else.
Now I'm not able to connect to Phoenix, only gia hbase shell. I use Hbase
shell since 2012 and I'm sure 100% that there's no other system tables in
my Hbase installation.
My guess ia that no mutex table was created before 4.8 and the upgrade from
4.7 to 4.13 doesn't take into account this situation. The upgrade process
should consider thia scenario and create such a table if not present, IMHO.
The problem is that right now I don't know how to repair this situation...

On 18 Dec 2017 00:49, "Ethan" <ewang@apache.org> wrote:

> System.mutex should come with Phoenix, so you should have it even though
> sometimes doesn't show up. To truncate that table you may try delete
> statement in sqline.
>
>
> On December 17, 2017 at 3:14:58 PM, Flavio Pompermaier (
> pompermaier@okkam.it) wrote:
>
> I did a hbase shell list and there'no mutex table.
> I have only catalog, function, sequence, stats
>
> On 18 Dec 2017 00:12, "Pedro Boado" <pedro.boado@gmail.com> wrote:
>
>> I think you may have it - phoenix-sqlline doesn't show it when you do a
>> !tables -
>>
>> Do a list in HBase shell and/or scan it to check whether it's there.
>>
>> On 17 Dec 2017 22:28, "Flavio Pompermaier" <pompermaier@okkam.it> wrote:
>>
>> The problem is that I don't have that table..how can I create it from
>> HBase shell?
>>
>> On Sun, Dec 17, 2017 at 11:24 PM, Pedro Boado <pedro.boado@gmail.com>
>> wrote:
>>
>>> You can do that through the hbase shell doing a
>>>
>>> hbase(main):011:0> truncate 'SYSTEM.MUTEX'
>>>
>>>
>>>
>>>
>>> On 17 December 2017 at 22:01, Flavio Pompermaier <pompermaier@okkam.it>
>>> wrote:
>>>
>>>> I've got Phoenix 4.13 both on client and server side..How can I
>>>> truncate Mutex table? I don't have any..
>>>>
>>>> On Sun, Dec 17, 2017 at 10:29 PM, Ethan <ewang@apache.org> wrote:
>>>>
>>>>> Hi Flavio,
>>>>>
>>>>> What is your server side Phoenix jar version and client side Phoenix
>>>>> version, note that server side has to have a higher version than client
>>>>> side.
>>>>>
>>>>> Another note, I got a similar issue the other day. I solved it by
>>>>> truncate system Mutex table. Hope it helps yours too.
>>>>>
>>>>> Thanks,
>>>>>
>>>>>
>>>>> On December 16, 2017 at 3:23:47 PM, Flavio Pompermaier (
>>>>> pompermaier@okkam.it) wrote:
>>>>>
>>>>> Hi to all,
>>>>> I've recently updated my Cloudera + Phoenix from CDH 5.9 + 4.7 to CDH
>>>>> 5.11.2 + 4.13 but now I can't connect with Phoenix anymore. When I run
>>>>> phoenix-sqlline.sql I get:
>>>>>
>>>>> WARN util.NativeCodeLoader: Unable to load native-hadoop library for
>>>>> your platform... using builtin-java classes where applicable
>>>>> Error: Cluster is being concurrently upgraded from 4.7.x to 4.13.x.
>>>>> Please retry establishing connection. (state=INT12,code=2010)
>>>>> org.apache.phoenix.exception.UpgradeInProgressException: Cluster is
>>>>> being concurrently upgraded from 4.7.x to 4.13.x. Please retry establishing
>>>>> connection.
>>>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.acquire
>>>>> UpgradeMutex(ConnectionQueryServicesImpl.java:3231)
>>>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgrade
>>>>> SystemTables(ConnectionQueryServicesImpl.java:2615)
>>>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call
>>>>> (ConnectionQueryServicesImpl.java:2478)
>>>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call
>>>>> (ConnectionQueryServicesImpl.java:2384)
>>>>> at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixC
>>>>> ontextExecutor.java:76)
>>>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(Co
>>>>> nnectionQueryServicesImpl.java:2384)
>>>>> at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServ
>>>>> ices(PhoenixDriver.java:255)
>>>>> at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnecti
>>>>> on(PhoenixEmbeddedDriver.java:150)
>>>>> at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.
>>>>> java:221)
>>>>> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
>>>>> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.
>>>>> java:203)
>>>>> at sqlline.Commands.connect(Commands.java:1064)
>>>>> at sqlline.Commands.connect(Commands.java:996)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
>>>>> ssorImpl.java:57)
>>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>>>>> thodAccessorImpl.java:43)
>>>>> at java.lang.reflect.Method.invoke(Method.java:606)
>>>>> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa
>>>>> ndler.java:38)
>>>>> at sqlline.SqlLine.dispatch(SqlLine.java:809)
>>>>> at sqlline.SqlLine.initArgs(SqlLine.java:588)
>>>>> at sqlline.SqlLine.begin(SqlLine.java:661)
>>>>> at sqlline.SqlLine.start(SqlLine.java:398)
>>>>> at sqlline.SqlLine.main(SqlLine.java:291)
>>>>> sqlline version 1.2.0
>>>>>
>>>>> How can I repair my installation? I can't find any log nor anything
>>>>> strange in the SYSTEM.CATALOG HBase table..
>>>>>
>>>>> Thanks in advance,
>>>>> Flavio
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Flavio Pompermaier
>>>> Development Department
>>>>
>>>> OKKAM S.r.l.
>>>> Tel. +(39) 0461 041809 <+39%200461%20041809>
>>>>
>>>
>>>
>>>
>>> --
>>> Un saludo.
>>> Pedro Boado.
>>>
>>
>>
>>
>> --
>> Flavio Pompermaier
>> Development Department
>>
>> OKKAM S.r.l.
>> Tel. +(39) 0461 041809 <+39%200461%20041809>
>>
>>
>>

Mime
View raw message