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" <[email protected]> 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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> 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 ( >>> [email protected]) 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>
