phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maryann Xue (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2556) Subqueries with nested joins may not free hash cache
Date Tue, 05 Jan 2016 01:55:39 GMT

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

Maryann Xue commented on PHOENIX-2556:
--------------------------------------

I tried running through the tests, but found a couple of failures, including one from the
lines I had uncommented:
Tests run: 17, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 98.035 sec <<< FAILURE!
- in org.apache.phoenix.tx.TxCheckpointIT
org.apache.phoenix.tx.TxCheckpointIT  Time elapsed: 51.628 sec  <<< FAILURE!
java.lang.AssertionError: expected:<0> but was:<3996>
 
testDisallowDropOfReferencedColumn[transactional = true](org.apache.phoenix.end2end.ViewIT)
 Time elapsed: 0.428 sec  <<< FAILURE!
java.lang.AssertionError: expected:<1010> but was:<1013>
	at org.apache.phoenix.end2end.ViewIT.testDisallowDropOfReferencedColumn(ViewIT.java:226)
 
Tests run: 17, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 57.04 sec <<< FAILURE!
- in org.apache.phoenix.monitoring.PhoenixMetricsIT
testGlobalPhoenixMetricsForMutations(org.apache.phoenix.monitoring.PhoenixMetricsIT)  Time
elapsed: 0.369 sec  <<< FAILURE!
java.lang.AssertionError
	at org.apache.phoenix.monitoring.PhoenixMetricsIT.testGlobalPhoenixMetricsForMutations(PhoenixMetricsIT.java:120)
 
Looks like the last two were transaction-related stuff. They might have been caused by the
previous check-in?

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

Mime
View raw message