[ https://issues.apache.org/jira/browse/PHOENIX-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15323138#comment-15323138 ]
Ankit Singhal commented on PHOENIX-2977: ---------------------------------------- Sorry [~mujtabachohan] for trouble. But I already fixed this too in PHOENIX-2901, as namespaceMappingEnabled cell was added with old timestamp during upgrade code but STATS and SEQUENCE tables are created with higher timestamp having value as false. I think , I should have raised a separate jira immediately when I saw the problem (during PHOENIX-2901), so that you guys aware of this. do you mind trying the patch available on PHOENIX-2901 for now(until I segregate the changes from that patch) > TNF exception for SYSTEM.STATS and SYSTEM.SEQUENCE table after enabling > namespace > --------------------------------------------------------------------------------- > > Key: PHOENIX-2977 > URL: https://issues.apache.org/jira/browse/PHOENIX-2977 > Project: Phoenix > Issue Type: Bug > Reporter: Mujtaba Chohan > Assignee: Ankit Singhal > Fix For: 4.8.0 > > > Environment: 4.x-HBase-0.98 > [commit|https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=82295b5d236554b2fec83ebdedee701005fcc04b] > | HBase 0.98.17 > {{phoenix.schema.isNamespaceMappingEnabled}} is set to true and both client > and server restarted. After upgrade of SYSTEM.* tables to namespace, both > SYSTEM.STATS and SYSTEM.SEQUENCE throw TableNotFoundException. > {code} > select * from SYSTEM.STATS; > Error: ERROR 1012 (42M03): Table undefined. tableName=SYSTEM.STATS > (state=42M03,code=1012) > org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table > undefined. tableName=SYSTEM.STATS > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:549) > at > org.apache.phoenix.iterate.BaseResultIterators.getParallelScans(BaseResultIterators.java:558) > at > org.apache.phoenix.iterate.BaseResultIterators.getParallelScans(BaseResultIterators.java:493) > at > org.apache.phoenix.iterate.BaseResultIterators.<init>(BaseResultIterators.java:366) > at > org.apache.phoenix.iterate.ParallelIterators.<init>(ParallelIterators.java:59) > at org.apache.phoenix.execute.ScanPlan.newIterator(ScanPlan.java:225) > at > org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:320) > at > org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:216) > at > org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:278) > at > org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:263) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at > org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:262) > at > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1392) > {code} > -- This message was sent by Atlassian JIRA (v6.3.4#6332)