[jira] [Updated] (PHOENIX-1927) hbase.regionserver.lease.period needs to be increased for immutable index population

["Samarth Jain (JIRA)" <ji...@apache.org>]

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

Samarth Jain updated PHOENIX-1927:
----------------------------------
    Attachment: PHOENIX-1927.patch

In 4.3.1, we don't have the iterator.peek() call that was made to fix perf regression seen in https://issues.apache.org/jira/browse/PHOENIX-1899. Also, calling iterator.peek() in the call() method will negate the effect of delaying Scanner creation since it will end up creating the scanner itself. 

Attaching a patch that does a couple of things:
1) Always delays creation of scanners until requested.
2) Removes the iterator.close() call from ChunkedResultIterator.java.

The perf regression that you saw [~jamestaylor], it is likely we might still have it. If this patch validates that lease expirations are no longer an issue, then we can build something slightly more sophisticated/specialized for index creation or upsert selects. 

[~mujtabachohan] - can you please give this patch a try? It is against the latest of 4.3. Thanks!

> hbase.regionserver.lease.period needs to be increased for immutable index population
> ------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-1927
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1927
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.3.1
>            Reporter: Mujtaba Chohan
>         Attachments: PHOENIX-1927.patch
>
>
> Even after increasing phoenix.query.timeoutMs, hbase.regionserver.lease.period needs to be set to a high value otherwise following exception stops immutable index population when data is present in base table:
> org.apache.phoenix.exception.PhoenixIOException: 88979ms passed since the last invocation, timeout is currently set to 60000



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)