From user-return-9414-apmail-drill-user-archive=drill.apache.org@drill.apache.org Wed Jun 27 18:47:22 2018 Return-Path: X-Original-To: apmail-drill-user-archive@www.apache.org Delivered-To: apmail-drill-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5474918B8B for ; Wed, 27 Jun 2018 18:47:22 +0000 (UTC) Received: (qmail 24730 invoked by uid 500); 27 Jun 2018 18:47:22 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 24648 invoked by uid 500); 27 Jun 2018 18:47:21 -0000 Mailing-List: contact user-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@drill.apache.org Delivered-To: mailing list user@drill.apache.org Received: (qmail 24636 invoked by uid 99); 27 Jun 2018 18:47:21 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Jun 2018 18:47:21 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id D8FF118085F for ; Wed, 27 Jun 2018 18:47:20 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.979 X-Spam-Level: * X-Spam-Status: No, score=1.979 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=mapr-com.20150623.gappssmtp.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id xvM6aNfAfd-T for ; Wed, 27 Jun 2018 18:47:19 +0000 (UTC) Received: from mail-wm0-f41.google.com (mail-wm0-f41.google.com [74.125.82.41]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id B3F585F35A for ; Wed, 27 Jun 2018 18:47:18 +0000 (UTC) Received: by mail-wm0-f41.google.com with SMTP id p11-v6so6504030wmc.4 for ; Wed, 27 Jun 2018 11:47:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mapr-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=pq4iRgg0m4g19wMFUnRqpg3evmTOkacFWcyZQ8U90kQ=; b=DNMi10bpAqc+LMPNoWKzpHeUHy5U2O/CAD5UMMBUPuugWc04NDp4/oMlUhi3Df2UT2 NAwlwfJQOD5HsN2psAOOI9l0tfmsYVGD9g/nDuZDPKdrwHUQPad0ogdIrGGC9aQyA4Bj 7kym/IVJhmJ5FVBpCdkzWxSwFguoCUIQeRFhB9KRp4V6o93oFTVFJW0f31qoe8b7bkHC muIoTgBggG3jNY630Y6pVR6Py3nt0a0eaO72g+QxRNPTt+ul71Y1etcTsjjlfwOXTq03 fKM7FFcjhT23yvutxsNicEqGoKjM+GKeRnNvqQpY+bAEWaYlgQcfwpf3aMdMzgQeyFbx xELw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=pq4iRgg0m4g19wMFUnRqpg3evmTOkacFWcyZQ8U90kQ=; b=oYCsWkOMHy6DlrFdSVf4TLoS0Rg034R4XZoBQ6GxnoFec/Tr6XDWFtX7Xpau4yLNal FPhJnhXcj6nL7cjeQo0I7hN12gE1z8fR9Y1b+vMCFlnoKIzAN5LkmwgZoM9aGRnd4iFV FHLqgFgp5ucr/lpEloGpNi5KsSYCAzp1/vZ+NGeV+Od2H/2TE7SvuOUKyRu4eUdRSUE9 yT9zxnnqolSY9zmJKbU2dlpOsm7Wnlp8N056zFwPdWL2sux6vVvBQSqTrJwHsnTRH/H9 yaKfhNnIxxv5VV64m3u1hHr7FPYl8z7dX8ZY3oIR6bnMamFkVNDHZOHVqpKwT+zplkxI I9dA== X-Gm-Message-State: APt69E2Ftp29aRX2AGrFb31ZtdUmSdsGBrvSBGZOxBJN3CKpKZ33ceDY 8s7W6LULqsXZ6ZtObthzhs1gOUT9Fogj3OzJR2DRog== X-Google-Smtp-Source: AAOMgpcdGvGWZVqqViNtS2UYQrKa1gdWfyiHOji2w/eTcM46vLukpjO3sqAByToJVzkdJsEmNqCE4TunK6OyOhq4wJM= X-Received: by 2002:a1c:8010:: with SMTP id b16-v6mr1839178wmd.41.1530125237375; Wed, 27 Jun 2018 11:47:17 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a1c:9d8f:0:0:0:0:0 with HTTP; Wed, 27 Jun 2018 11:47:16 -0700 (PDT) In-Reply-To: References: From: Khurram Faraaz Date: Wed, 27 Jun 2018 11:47:16 -0700 Message-ID: Subject: Re: Drill error To: user@drill.apache.org Content-Type: multipart/alternative; boundary="0000000000003c6efc056fa40bdb" --0000000000003c6efc056fa40bdb Content-Type: text/plain; charset="UTF-8" Hi Nitin, Can you please share the description of the table (i.e. column types) ? Is this a parquet table or JSON ? Also please share the version of Drill and the drillbit.log Thanks, Khurram On Wed, Jun 27, 2018 at 9:45 AM, Nitin Pawar wrote: > here are the details > > query: > > select Account Account,Name Name,CONCAT(DateString , string2) > Merged_String from dfs.tmp.`/nitin/` t1 > > There is no custom UDF in this query; > > > > On Wed, Jun 27, 2018 at 2:22 PM, Nitin Pawar > wrote: > > > Hi Vitalii, > > > > Thanks for the description. > > I will try to get the log for this but as this is happening in production > > and drill log gets overwritten in our case very fast. > > > > Also I will get the query for the same while getting the log > > > > I will get the details and update the thread > > > > Thanks, > > Nitin > > > > On Tue, Jun 26, 2018 at 7:32 PM, Vitalii Diravka < > > vitalii.diravka@gmail.com> wrote: > > > >> Hi Nitin, > >> > >> It happens in the process of reallocation of the size of buffers in the > >> memory. > >> It isn't a User Exception, so it looks like a bug, if you get it in some > >> existed plugin. > >> But to say you exactly, please describe your case. What kind of query > did > >> you perform, any UDF's, which data source? > >> Also logs can help. > >> > >> Thanks. > >> > >> Kind regards > >> Vitalii > >> > >> > >> On Tue, Jun 26, 2018 at 1:27 PM Nitin Pawar > >> wrote: > >> > >> > Hi, > >> > > >> > Can someone help me understand below error? and how do I not let this > >> > happen ?? > >> > > >> > SYSTEM ERROR: IllegalStateException: Tried to remove unmanaged buffer. > >> > > >> > Fragment 0:0 > >> > > >> > [Error Id: bcd510f6-75ee-49a7-b723-7b35d8575623 on > >> > ip-10-0-103-63.ec2.internal:31010] > >> > Caused By: SYSTEM ERROR: IllegalStateException: Tried to remove > >> unmanaged > >> > buffer. > >> > > >> > Fragment 0:0 > >> > > >> > [Error Id: bcd510f6-75ee-49a7-b723-7b35d8575623 on > >> > ip-10-0-103-63.ec2.internal:31010] > >> > > >> > -- > >> > Nitin Pawar > >> > > >> > > > > > > > > -- > > Nitin Pawar > > > > > > -- > Nitin Pawar > --0000000000003c6efc056fa40bdb--