From dev-return-37834-apmail-drill-dev-archive=drill.apache.org@drill.apache.org Tue May 1 22:24:10 2018 Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9954618F83 for ; Tue, 1 May 2018 22:24:10 +0000 (UTC) Received: (qmail 10640 invoked by uid 500); 1 May 2018 22:24:05 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 10494 invoked by uid 500); 1 May 2018 22:24:04 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Received: (qmail 10483 invoked by uid 99); 1 May 2018 22:24:04 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 May 2018 22:24:04 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 0633AC5EFB for ; Tue, 1 May 2018 22:24:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -110.301 X-Spam-Level: X-Spam-Status: No, score=-110.301 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id Q4Zn7PmZtGRh for ; Tue, 1 May 2018 22:24:03 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 246B55FBFE for ; Tue, 1 May 2018 22:24:02 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 765FDE0CCB for ; Tue, 1 May 2018 22:24:01 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 6C6C9212A9 for ; Tue, 1 May 2018 22:24:00 +0000 (UTC) Date: Tue, 1 May 2018 22:24:00 +0000 (UTC) From: "Dechang Gu (JIRA)" To: dev@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (DRILL-6374) TPCH Queries regressed and OOM when run concurrency test MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Dechang Gu created DRILL-6374: --------------------------------- Summary: TPCH Queries regressed and OOM when run concurrency test Key: DRILL-6374 URL: https://issues.apache.org/jira/browse/DRILL-6374 Project: Apache Drill Issue Type: Bug Components: Functions - Drill Affects Versions: 1.14.0 Environment: RHEL 7 Reporter: Dechang Gu Assignee: Vitalii Diravka Fix For: 1.14.0 Attachments: TPCH_09_2_id_2517381b-1a61-3db5-40c3-4463bd421365.json, TPCH_09_2_id_2517497b-d4da-dab6-6124-abde5804a25f.json Run TPCH regression test on Apache Drill 1.14.0 master commit 6fcaf4268eddcb09010b5d9c5dfb3b3be5c3f903 (DRILL-6173), most of the queries regressed. in particular, Queries 9 takes about 4x time (36 sec vs 8.6 sec), comparing to that when run against the parent commit (9173308710c3decf8ff745493ad3e85ccdaf7c37). Further in the concurrency test for the commit, with 48 clients each running 16 TPCH queries (so total 768 queries are executed) with planner.width.max_per_node=5, some queries hit OOM and caused 266 queries failed, while for the parent commit all the 768 queries completed successfully. Profiles for TPCH_09 in the regression tests are uploaded (the failing commit file name: TPCH_09_2_id_2517381b-1a61-3db5-40c3-4463bd421365.json, and the parent commit file name: TPCH_09_2_id_2517497b-d4da-dab6-6124-abde5804a25f.json ). -- This message was sent by Atlassian JIRA (v7.6.3#76005)