drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Phillips (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1707) Regression: Mondrian query5843.q hangs
Date Thu, 13 Nov 2014 23:56:33 GMT

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

Steven Phillips commented on DRILL-1707:
----------------------------------------

could you run jstack on the drillbit and attach it here? It would be helpful to see what it
is doing to cause such high cpu usage.

> Regression: Mondrian query5843.q hangs
> --------------------------------------
>
>                 Key: DRILL-1707
>                 URL: https://issues.apache.org/jira/browse/DRILL-1707
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 0.7.0
>            Reporter: Chun Chang
>            Priority: Blocker
>
> #Thu Nov 13 13:47:45 EST 2014
> git.commit.id.abbrev=fd54e71
> The following Mondrian query hangs. It was working with previous release.
> 0: jdbc:drill:schema=dfs>
> SELECT time_by_day.the_year     AS c0, 
>        time_by_day.quarter      AS c1, 
>        store.store_state        AS c2, 
>        FACT.warehouse_id        AS c3, 
>        Sum(FACT.warehouse_cost) AS m0 
> FROM   time_by_day AS time_by_day, 
>        (SELECT * 
>         FROM   inventory_fact_1997 AS FOOBAR) AS FACT, 
>        store AS store 
> WHERE  FACT.time_id = time_by_day.time_id 
>        AND time_by_day.the_year = 1997 
>        AND time_by_day.quarter = 'Q3' 
>        AND FACT.store_id = store.store_id 
>        AND store.store_state = 'WA' 
>        AND FACT.warehouse_id = 2 
> GROUP  BY time_by_day.the_year, 
>           time_by_day.quarter, 
>           store.store_state, 
>           FACT.warehouse_id;
> The drillbit handles the query seems active with around 100% CPU usage but the query
never returns. The only log message found in drill bit.log is following:
> 2014-11-13 15:07:14,426 [UserServer-1] WARN  o.a.d.exec.work.foreman.QueryStatus - Update
running or pending query state : PENDING
> Since this is a regression, marked as release blocker.



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

Mime
View raw message