phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-4523) phoenix.schema.isNamespaceMappingEnabled problem
Date Wed, 10 Jan 2018 22:00:04 GMT


James Taylor commented on PHOENIX-4523:

Thanks for taking this up, [~karanmehta93]!

bq. According to Flavio Pompermaier, the cluster is already migrated. So the ensureSystemTablesMigratedToSystemNamespace()
method is almost short-circuited.
There might be a corner case here, as Flavio is upgrading from 4.7 (which didn't have SYSTEM.MUTEX)
to 4.13 (which requires/expects it). Not sure if that method is short-circuited in that case.

bq. I checked out the tag v4.13.1-HBase-1.2-rc0 and the only place createSysMutexTable() method
is called is inside createOtherSystemTables() method. 
Flavio is using the 4.13 CDH branch which would have a call to createSysMutexTable() from
ensureSystemTablesMigratedToSystemNamespace(). I suspect that's the call that's failing. If
you want to try to repro it, you can use master - I don't think this issue is specific the
HBase version. It might be specific to upgrading from 4.7 to 4.13.

bq. I will put up a patch once these things are confirmed.
Thanks - is there anything else that needs to be confirmed? Feel free to drop a patch here
and Flavio can let you know if it solves the issue he's seeing.

> phoenix.schema.isNamespaceMappingEnabled problem
> ------------------------------------------------
>                 Key: PHOENIX-4523
>                 URL:
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.13.1
>            Reporter: Flavio Pompermaier
>            Assignee: Karan Mehta
> I'm using Phoenix 4.13 for CDH 5.11.2 parcel and enabling schemas made my code unusable.
> I think that this is not a bug of the CDH release, but of all 4.13.x releases.
> I have many parallel Phoenix connections and I always get the following exception:
> {code:java}
> Caused by: java.sql.SQLException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.hbase.TableExistsException):
> 	at org.apache.phoenix.query.ConnectionQueryServicesImpl$
> 	at org.apache.phoenix.query.ConnectionQueryServicesImpl$
> 	at
> 	at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(
> 	at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(
> 	at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(
> 	at org.apache.phoenix.jdbc.PhoenixDriver.connect(
> 	at java.sql.DriverManager.getConnection(
> 	at java.sql.DriverManager.getConnection(
> {code}
> This is caused by the fact that all the times the SYSTEM tables are recreated, and this
cannot be done simultaneously.
> Trying to debug the issue I found that in ConnectionQueryServicesImpl.createSysMutexTable()
the call to getSystemTableNames() always return an empty array and the SYSTEM:MUTEX  table
is always recreated.
> This because getSystemTableNames() doesn't consider the case when system tables have
namespace enabled. Right now that method tries to get all tables starting with *SYSTEM.\**,
while it should try to get the list of *SYSTEM:\** tables..
> I hope this could get fixed very soon,
> Flavio

This message was sent by Atlassian JIRA

View raw message