phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kadir OZDEMIR (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-5373) GlobalIndexChecker should treat the rows created by the previous design as unverified
Date Thu, 27 Jun 2019 04:58:00 GMT

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

Kadir OZDEMIR updated PHOENIX-5373:
-----------------------------------
    Attachment: PHOENIX-5373.4.x-HBase-1.4.001.patch

> GlobalIndexChecker should treat the rows created by the previous design as unverified

> --------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-5373
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5373
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 5.0.0, 4.14.2
>            Reporter: Kadir OZDEMIR
>            Assignee: Kadir OZDEMIR
>            Priority: Major
>         Attachments: PHOENIX-5373.4.x-HBase-1.4.001.patch, PHOENIX-5373.master.001.patch
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> For the ease of transition from the old global secondary index design to the new one
(without having read performance impact), GlobalIndexChecker treats existing index rows (i.e.,
the rows created by the previous design) as verified. We have discovered that this would lead
to keeping stale index rows around forever and including them in the result of queries. A
stale index row is a row for which we do not have the corresponding data table row. The reason
that we do not have the data table row is either the row is deleted (but not the corresponding
index row(s)), or the data table and index rows are written with different timestamps. The
assumption was that such rows would be fixed by index rebuild. Unfortunately, without dropping
or truncating index tables, these stale rows may not be fixed by index rebuild. Thus, GlobalIndexChecker
should treat the rows created by the previous design as unverified.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message