From user-return-9418-apmail-drill-user-archive=drill.apache.org@drill.apache.org Thu Jun 28 14:14:04 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 0D71918428 for ; Thu, 28 Jun 2018 14:14:04 +0000 (UTC) Received: (qmail 86376 invoked by uid 500); 28 Jun 2018 14:14:03 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 86192 invoked by uid 500); 28 Jun 2018 14:14:03 -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 85583 invoked by uid 99); 28 Jun 2018 14:14:02 -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; Thu, 28 Jun 2018 14:14:02 +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 02EF8C0F6F for ; Thu, 28 Jun 2018 14:14:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.889 X-Spam-Level: * X-Spam-Status: No, score=1.889 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_PASS=-0.001, T_DKIMWL_WL_MED=-0.01] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com 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 69KR57PZxcQ7 for ; Thu, 28 Jun 2018 14:14:00 +0000 (UTC) Received: from mail-yb0-f177.google.com (mail-yb0-f177.google.com [209.85.213.177]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 6BD565F300 for ; Thu, 28 Jun 2018 14:14:00 +0000 (UTC) Received: by mail-yb0-f177.google.com with SMTP id x15-v6so2045796ybm.2 for ; Thu, 28 Jun 2018 07:14:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=S4G83gu0ZDIhQgPY1Zw4y7/FZ804okb2uMvbTvXxyIE=; b=SlyJ8aoiA8C06X7TBV3i1IgX5B3u4j8Rhv2FEnJqeEWfM9PuoWPqPFh/AMxUHOnqeY VrXMiO/JveFXosekb3mUIaFhh+piSBcoTa5dXyhW5qWD/fPs/9ajYhTJlHsIBU2Aerul V9sqyqIX+6bexGliI0uZ8AlK8Db9xYvYmE60z233nDYjvQ3kHKQpo5XU5lTSHHcIIehv gXxWPKw54lhVqXyiiGHoRNC0tYRZG3+dL+qfoF5gTqnwT3o5ljW/kly9szf01Ro4B7ej Lzr5HOTiyj+x/HHwyqKKpaER2xCrZyltylEW8/+qtDNzYw41rSpUx+EG1CA0hU3pX2D3 DkHA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=S4G83gu0ZDIhQgPY1Zw4y7/FZ804okb2uMvbTvXxyIE=; b=Y02CTDNFUS+COtlIAJ56HKHTkgSLpFPz+y8/F+6bW4MZ7Gr+0Ra4Utr1oNIVvnTSH6 gQiD8V9L465UoIUKWWkU/d/vVSM7hUkQjGt71h0Ctlzz+um04veWg+NuUm1yp6jMSGDT 3eOjrL5xmYHUXjrelk0NjYIkmvKoS55NCg1oYpgqDaPwJTDMKtVtScJtHfDyNZzkauPx TepvPExLaZkUh+5oTpLIOy43j3rOvN9/1oXCPtYpSdqhZVStm3ANBwcyl4wbGo6+JCjI 5FmmJf3F1hYllBLHQKXwGJKzrMoe8VjF9Qf6eW9bmHnEJWpr2leL5Q8zgj2Jh3ck8Mmz Y4Qg== X-Gm-Message-State: APt69E279YancbrQcmzvF0tR7tVZn3EVapOOf+hFZWXJGiQAA6IJ6WS/ EZcgo25oz3c7Z3D4QvZsO2rRUZQ//YTrnGT2d2gQ9A== X-Google-Smtp-Source: AAOMgpc7em+XwmPqCbGQfa/IGhjrkK0O6o7dQiuheJVegD4M+iWLFuA/HQ/w5jZxWLaVePweLuur0goXdG1Z6g+UVao= X-Received: by 2002:a25:b087:: with SMTP id f7-v6mr3498791ybj.293.1530195239780; Thu, 28 Jun 2018 07:13:59 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Vitalii Diravka Date: Thu, 28 Jun 2018 17:13:25 +0300 Message-ID: Subject: Re: Drill error To: user@drill.apache.org Content-Type: multipart/alternative; boundary="000000000000b449f0056fb45778" --000000000000b449f0056fb45778 Content-Type: text/plain; charset="UTF-8" Hi Nitin, This is definitely the regression. Could you please post the Jira ticket with details of your case, data and workaround [1]. It will help for developers to solve this issue. [1] https://issues.apache.org/jira/projects/DRILL Thanks. Kind regards Vitalii On Thu, Jun 28, 2018 at 10:50 AM Nitin Pawar wrote: > I was able to fix this issue by doing concat(string1, ' ', string2) instead > of concat(string1, string2) > Not sure how adding a separator helps but it solved the problem > > On Thu, Jun 28, 2018 at 11:55 AM, Nitin Pawar > wrote: > > > Could this cause an issue if one of the field in concat function has > large > > text ? > > > > On Thu, Jun 28, 2018 at 11:10 AM, Nitin Pawar > > wrote: > > > >> Hi Khurram, > >> > >> This is a parquet table. > >> all the columns in the table are string columns (even date column is > >> stored as string) > >> > >> I am currently using drill 1.13.0. Same query used to work fine on drill > >> 1.8.0 > >> > >> Thanks, > >> Nitin > >> > >> On Thu, Jun 28, 2018 at 12:17 AM, Khurram Faraaz > >> wrote: > >> > >>> 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 < > nitinpawar432@gmail.com> > >>> > 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 < > >>> nitinpawar432@gmail.com> > >>> > >> 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 > >>> > > >>> > >> > >> > >> > >> -- > >> Nitin Pawar > >> > > > > > > > > -- > > Nitin Pawar > > > > > > -- > Nitin Pawar > --000000000000b449f0056fb45778--