You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Priyank Porwal (Jira)" <ji...@apache.org> on 2020/01/31 19:22:00 UTC

[jira] [Created] (PHOENIX-5705) SYSTEM.CATALOG rows are rewritten with high frequency

Priyank Porwal created PHOENIX-5705:
---------------------------------------

             Summary: SYSTEM.CATALOG rows are rewritten with high frequency
                 Key: PHOENIX-5705
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5705
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.14.3
            Reporter: Priyank Porwal
             Fix For: 4.15.1, 4.14.4


It seems every few ms, the following cells are being rewritten without any change in values - PENDING_DISABLE_COUNT, INDEX_STATE,INDEX_DISABLE_TIMESTAMP,ASYNC_REBUILD_TIMESTAMP,_0

Sometimes the rewrites have the same cell timestamps as well.

These cells are all relevant to secondary indexes to it is likely that automated index rebuild system or Phoenix MR job submitter has an issue. This is true even if the index state is Active 'a'.

 

REPRO:

scan 'SYSTEM.CATALOG', {LIMIT=>1,RAW=>true,VERSIONS=>10,STARTROW=>"<syscatrowkey>" 

Get syscatrowkey:

SELECT ROWKEY_BYTES_STRING() FROM SYSTEM.CATALOG WHERE COLUMN_NAME IS NULL AND DATA_TABLE_NAME IS NOT NULL AND TABLE_NAME = "<index_name>"



--
This message was sent by Atlassian Jira
(v8.3.4#803005)