You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2015/05/15 09:11:01 UTC
[jira] [Resolved] (DRILL-2989) TPCDS Query corrupts Drillbits and
causing subsequent unrelated queries to hang (and timeout)
[ https://issues.apache.org/jira/browse/DRILL-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau resolved DRILL-2989.
-----------------------------------
Resolution: Fixed
Resolved by recent stability fixes.
> TPCDS Query corrupts Drillbits and causing subsequent unrelated queries to hang (and timeout)
> ---------------------------------------------------------------------------------------------
>
> Key: DRILL-2989
> URL: https://issues.apache.org/jira/browse/DRILL-2989
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.0.0
> Environment: RHEL 6.4
> Reporter: Kunal Khatua
> Priority: Critical
> Fix For: 1.0.0
>
> Attachments: 02_dri100_TPCDS_4.0.2.29870.GA_drill-1058d52_run1_-20150508_1135.tgz, 06_dri100_TPCH_4.0.2.29870.GA_drill-1058d52_run1_-20150508_1131.tgz, 06_dri100_TPCH_4.0.2.29870.GA_drill-1058d52_run1_-20150508_1142.tgz, DRILL-2989.tgz, dBit_TPC-DBug.jstack.out
>
>
> 30-node setup has TPC-H Drill (SF100) and TPC-DS Drill (SF100) in two different workspaces.
> TPC-H Query 6 is executed on the cluster successfully, followed by execution of TPC-DS Query 2; which hangs during the executeQuery() operation. After a 2min timeout, the TPC-H Query is executed on the cluster, but this also hangs during the fetching of rows from the ResultSet. The profile page for the second attempt at TPC-H query 6 shows it as pending.
> The TPC-H schema is in its own workspace which exposes the directories as tables.
> The TPC-DS schema is in its own workspace, which has views on top of the directories containing the actual tables' data.
> ====TPCH-06====
> [INFO] Will be using Drillbit on 10.10.120.114
> [QUERYID] 2ab41296-1420-ee4b-2617-849b63eb11b4
> [STAT] TOTAL TIME : 7420 msec
> ====TPCDS-02====
> [INFO] Will be using Drillbit on 10.10.120.117
> [TIME OUT] Query took more than 120 sec.
> ====TPCH-06====
> [INFO] Will be using Drillbit on 10.10.120.130
> [TIME OUT] Query took more than 120 sec.
> [QUERYID] 2ab41027-abcc-c48a-7e3c-957bb069f452
> [STAT] TOTAL TIME : 120017 msec
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)