Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-5705

SYSTEM.CATALOG rows are rewritten with high frequency

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Not A Problem
    • 4.14.3
    • 4.14.4, 4.16.1, 4.17.0
    • None
    • None

    Description

      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>"

      Attachments

        Activity

          People

            tkhurana Tanuj Khurana
            priyankporwal Priyank Porwal
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: