[
https://issues.apache.org/jira/browse/PHOENIX-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17181010#comment-17181010
]
Lars Hofhansl commented on PHOENIX-6090:
----------------------------------------
One more thing. This *only* happens with overwrites (updates of existing row
keys).
So the script above can be changed to
{code:java}
> upsert into test values(rand()*100, rand()*100, rand(), rand(), rand());
> upsert into test select rand()*100, rand()*100, rand(), rand(), rand() from
> test;
{code}
I.e. just generate 10.000 unique keys and hence more and more rows are being
overwritten.
That shows the problem far quicker.
> Local indexes get out of sync in 5.1.0
> --------------------------------------
>
> Key: PHOENIX-6090
> URL: https://issues.apache.org/jira/browse/PHOENIX-6090
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.1.0
> Reporter: Lars Hofhansl
> Priority: Critical
> Fix For: 5.1.0
>
>
> {code:java}
> > select /*+ NO_INDEX */ count(*) from test;
> +----------+
> | COUNT(1) |
> +----------+
> | 522244 |
> +----------+
> 1 row selected (1.213 seconds)
> > select count(*) from test;
> +---------+
> | COUNT(1) |
> +----------+
> | 522245 |
> +----------+
> 1 row selected (1.23 seconds)
> {code}
>
> This was after I did some insert and a bunch of splits (but not in parallel).
> It's not, yet, clear under what circumstances that exactly happens. Just that
> after a while it happens.
> This is Phoenix built from master and HBase built from branch-2.3. (Client
> and server versions of HBase are matching)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
