You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Xinyi Yan (Jira)" <ji...@apache.org> on 2020/10/27 19:19:00 UTC

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

     [ https://issues.apache.org/jira/browse/PHOENIX-5705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xinyi Yan updated PHOENIX-5705:
-------------------------------
    Fix Version/s:     (was: 4.16.0)
                   4.17.0
                   4.16.1

> 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
>            Assignee: Tanuj Khurana
>            Priority: Major
>             Fix For: 4.15.1, 4.14.4, 4.16.1, 4.17.0
>
>
> 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)