[
https://issues.apache.org/jira/browse/PHOENIX-4242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16194004#comment-16194004
]
James Taylor commented on PHOENIX-4242:
---------------------------------------
bq. I think the reason might be because we're creating HBase non-Phoenix
tables, which for some reason have the Indexer coprocessor loaded? Any idea how
that might happen?
That's what the FIXME in the code is about. The HBase table that stores the
index on view data does not have an entry in the SYSTEM.CATALOG, so you'd get a
TableNotFoundException. Same with a local index. You can identify the physical
table of a view index based on the name - it'll be prefixed with
MetaDataUtil.VIEW_INDEX_TABLE_PREFIX. In this case, we'd want to check all
index tables with this table name as their physical table name. Another
approach would be to create an entry in SYSTEM.CATALOG for this table and
maintain the child linking rows to be able to quickly look them up. I think the
latter is probably a better long term solution as it makes things more
consistent. [~tdsilva] can help you with this. Some related work is
PHOENIX-4263, but this could be a separate JIRA.
> Fix Indexer post-compact hook logging of NPE and TableNotFound
> --------------------------------------------------------------
>
> Key: PHOENIX-4242
> URL: https://issues.apache.org/jira/browse/PHOENIX-4242
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.12.0
> Reporter: Vincent Poon
> Assignee: Vincent Poon
> Attachments: PHOENIX-4747.v1.master.patch
>
>
> The post-compact hook in the Indexer seems to log extraneous log messages
> indicating NPE or TableNotFound. The TableNotFound exceptions seem to
> indicate actual table names prefixed with MERGE or RESTORE, and sometimes
> suffixed with a digit, so perhaps these are views or something similar.
> Examples:
> 2017-09-28 13:35:03,118 WARN [ctions-1506410238599] index.Indexer - Unable
> to permanently disable indexes being partially rebuild for SYSTEM.SEQUENCE
> java.lang.NullPointerException
> 2017-09-28 10:20:56,406 WARN [ctions-1506410238415] index.Indexer - Unable
> to permanently disable indexes being partially rebuild for
> MERGE_PLATFORM_ENTITY.PLATFORM_IMMUTABLE_ENTITY_DATA2
> org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table
> undefined. tableName=MERGE_PLATFORM_ENTITY.PLATFORM_IMMUTABLE_ENTITY_DATA2
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
