Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Tue, 5 Jan 2016 05:18:39 +0000 (UTC)
From: "James Taylor (JIRA)" <jira@apache.org>
To: dev@phoenix.incubator.apache.org
Message-ID: <JIRA.12926848.1451864171000.17445.1451971119934@Atlassian.JIRA>
In-Reply-To: <JIRA.12926848.1451864171000@Atlassian.JIRA>
References: <JIRA.12926848.1451864171000@Atlassian.JIRA>
 <JIRA.12926848.1451864171033@arcas>
Subject: [jira] [Commented] (PHOENIX-2556) Subqueries with nested joins may
 not free hash cache
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/PHOENIX-2556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15082397#comment-15082397 ] 

James Taylor commented on PHOENIX-2556:
---------------------------------------

Thanks for following up on this, [~maryannxue].

The TxCheckpointIT failure is likely related to the same cause, as the test causing the failure, testCheckpointForDeleteAndUpsert, is doing subqueries (when ignored the test passes). It's slightly different, though, as it's doing a subquery in a delete. Could that be a slightly different case of this bug?

Also, minor nit - would you mind adding an error message for the new assert in ConnectionQueryServicesTestImpl, like this?
{code}
    @Override
    public void close() throws SQLException {
        try {
            Set<PhoenixConnection> connections = this.connections;
            this.connections = Sets.newHashSet();
            SQLCloseables.closeAll(connections);
            long unfreedBytes = clearCache();
            assertEquals("Found unfreed bytes in server-side cache", 0,unfreedBytes);
        } finally {
            super.close();
        }
    }
{code}

Not sure about the other failures - I'm still on JDK 7. Would be good to file JIRAs on them if they fail consistently, though.

> Subqueries with nested joins may not free hash cache
> ----------------------------------------------------
>
>                 Key: PHOENIX-2556
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2556
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: Maryann Xue
>             Fix For: 4.7.0
>
>         Attachments: PHOENIX-2556.patch, PHOENIX-2556_wip.patch
>
>
> Subqueries with nested joins are only freeing some of the server-side hash cache memory, leading to essentially a kind of memory leak.
> This problem occurs with the existing test case in SubqueryIT:
> {code}
>  SELECT name from Join.CustomerTable 
>  WHERE "customer_id" IN 
>     (SELECT "customer_id" FROM Join.ItemTable i
>      JOIN Join.OrderTable o 
>      ON o."item_id" = i."item_id"
>      WHERE i.name = 'T2'
>      OR quantity >
>          (SELECT avg(quantity) FROM Join.OrderTable q
>           WHERE o."item_id" = q."item_id"))
> {code}


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