Return-Path: X-Original-To: apmail-asterixdb-dev-archive@minotaur.apache.org Delivered-To: apmail-asterixdb-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 434FE1899C for ; Fri, 19 Feb 2016 18:36:39 +0000 (UTC) Received: (qmail 19509 invoked by uid 500); 19 Feb 2016 18:36:39 -0000 Delivered-To: apmail-asterixdb-dev-archive@asterixdb.apache.org Received: (qmail 19454 invoked by uid 500); 19 Feb 2016 18:36:39 -0000 Mailing-List: contact dev-help@asterixdb.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.incubator.apache.org Delivered-To: mailing list dev@asterixdb.incubator.apache.org Delivered-To: moderator for dev@asterixdb.incubator.apache.org Received: (qmail 2313 invoked by uid 99); 19 Feb 2016 18:31:39 -0000 X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.448 X-Spam-Level: * X-Spam-Status: No, score=1.448 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=CXaITu2ZRw2xRiVe+xsZFC3pPvRKc1kyN4v+I7GhejY=; b=E4YJm4GNFx2sLV9ystoKsBsqcuu+V76wfPfEcC/krHbeAEjlaYvclA3i3j+RQ2uxrJ 51GOEUkUB1Vh3O9v3kEf3DO/G0WNlLYWN0YcqeCkTX20oCbduqZPNCNbqSe9q/d2ph2c /Tr084UwxxU+UEFJYALBujwi//5jDJd5SJIJAtLPvnL2nRgNp03LFqMSg73pzNddrcvw 1Ip+Fu29zAFJG5LBhHe+VyrqaWs6Qo5+Tt+YdrZeIY4GH8umxVPgUbSsrVWY6u8dlBmL /jZ+M0/xoHBl+XjNchOlzxIQivIDPhP9ULuSF/exMQIhIkv37/bEUArh0dYRTxIYK2HX SP3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=CXaITu2ZRw2xRiVe+xsZFC3pPvRKc1kyN4v+I7GhejY=; b=C1qDSy1CEidVaFJQ+brS6tjiYIUR/bvOB03MD+ucT2fE0t/Qgu7vfsuLXj0NGqAU5f jBQZ69bbjQ8pYrGkxaPBhj+eyDVP8x7GbzJ/bPQ6J6vAsyXFDA2aUBjDLDIgtndrVp8/ d4eEDnpyi577/goYTuo85ecbPZGnX8KN1hPmBph8NWELs3zWCfa1pVtR7xVhBmEYIGIj z+D5OPIq4eCGTsAgk0bPVz0iIYRG0hxT9P5w6eidKeqhphMAxrNpH36gPBrkGEBABd4E j55fpC9CkkSDWx02xchzfHHlMzODpL5Q6KgGNaylxWvQXSfthIHrkHawAQVvyjKbzizF 8Nkg== X-Gm-Message-State: AG10YOSavWeT1vQb4mkUseqvR/TSiG0h/t41jNsQx5H+d4tilYAJj6BNWOBXvPAFV2SeLtpwLVuiOlmFwq+aYg== MIME-Version: 1.0 X-Received: by 10.107.128.75 with SMTP id b72mr14716307iod.87.1455906693445; Fri, 19 Feb 2016 10:31:33 -0800 (PST) In-Reply-To: References: Date: Fri, 19 Feb 2016 10:31:33 -0800 Message-ID: Subject: Re: Cannot load an index that is not empty [TreeIndexException] From: Yiran Wang To: asterixdb-users Cc: "asterixdb-dev@googlegroups.com" , Gloria Mark , dev@asterixdb.incubator.apache.org Content-Type: multipart/mixed; boundary=001a113f96da4a3fa1052c23b1fc --001a113f96da4a3fa1052c23b1fc Content-Type: multipart/alternative; boundary=001a113f96da4a3f9e052c23b1fa --001a113f96da4a3f9e052c23b1fa Content-Type: text/plain; charset=UTF-8 Abdullah, Here is the log attached. Thank you all very much for looking into this. Ian - I have two query questions besides this loading issue. I was wondering if I can meet briefly with you (or over email) regarding that. Thanks! Yiran On Fri, Feb 19, 2016 at 9:38 AM, Mike Carey wrote: > Maybe Ian can visit the cluster with Yiran later today? > On Feb 19, 2016 1:31 AM, "abdullah alamoudi" wrote: > >> Yiran, >> Can you share the logs? It would help us identifying the actual cause of >> this failure much faster. >> >> I am pretty sure you know this but in case you didn't, you can get the >> logs using >> >managix log -n >> >> Also, it would be nice if someone from the team has access to the cluster >> so we can work with it directly. >> Cheers, >> Abdullah. >> >> >> On Fri, Feb 19, 2016 at 9:40 AM, Yiran Wang wrote: >> >>> Steven, >>> >>> Thanks for getting back to me so quickly! I wasn't clear. Here is what >>> happened: >>> >>> I test-loaded the first 32 files, no problem. I deleted the dataset, >>> created a new one, and tried to load the entire 76 files into the newly >>> created (hence empty) dataset. >>> >>> It took about 2mins after executing the query for the error message to >>> show up. There are currently 31710406 rows of data in the dataset, despite >>> the error message (so it looks like it did load). >>> >>> So my questions are: 1) why did I still get that error message when I >>> was loading to an empty dataset; and 2) I'm not sure if all the data from >>> the 76 file are fully loaded. Is there other ways to check, besides trying >>> to load it again and hope this time I don't get the error? >>> >>> Thanks! >>> Yiran >>> >>> On Thu, Feb 18, 2016 at 10:29 PM, Steven Jacobs >>> wrote: >>> >>>> Hi, >>>> Welcome! We are an Apache incubator project now so I added the correct >>>> mailing list. Our "load" statement only works on an empty dataset. >>>> Subsequent data needs to be added with an insert or a feed. You should be >>>> able to load all 76 files at once though (starting from empty). >>>> Steven >>>> >>>> >>>> On Thursday, February 18, 2016, Yiran Wang wrote: >>>> >>>>> Hi Asterix team! >>>>> >>>>> I've come across this error when I was trying to load 76 files into a >>>>> dataset. When I test-loaded the first 32 files, there wasn't such an error. >>>>> All 76 files are of the same data format. >>>>> >>>>> Can you help interpret what this error message means? >>>>> >>>>> Thanks! >>>>> Yiran >>>>> >>>>> -- >>>>> Best, >>>>> Yiran >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "asterixdb-dev" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to asterixdb-dev+unsubscribe@googlegroups.com. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "asterixdb-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to asterixdb-users+unsubscribe@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Best, >>> Yiran >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "asterixdb-dev" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to asterixdb-dev+unsubscribe@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "asterixdb-dev" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to asterixdb-dev+unsubscribe@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "asterixdb-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to asterixdb-users+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Best, Yiran --001a113f96da4a3f9e052c23b1fa Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Abdullah,

Here is the log attached. Than= k you all very much for looking into this.
<= br>
Ian - I have two query questions besides= this loading issue. I was wondering if I can meet briefly with you (or ove= r email) regarding that.

Thanks!
Yiran

On Fri, Feb 19, 201= 6 at 9:38 AM, Mike Carey <dtabass@gmail.com> wrote:

Maybe Ian can visit the cluster wi= th Yiran later today?

On Feb 19, 2016 1:31 AM, "abdullah alamoudi= " <bamousaa= @gmail.com> wrote:
Yiran,
Can you share the logs? It would help us = identifying the actual cause of this failure much faster.

I am pretty sure you know this but in case you didn't, you can = get the logs using
>managix log -n <instance-name>
=

Also, it would be nice if someone from the team has acc= ess to the cluster so we can work with it directly.
Cheers,
=
Abdullah.


On Fri, Feb 19, 2016 at 9:4= 0 AM, Yiran Wang <wyr4137@gmail.com> wrote:
Steven,<= /div>

Thanks for getting back to me so quickly! I wasn't clear. Here is w= hat happened:

I test-loaded the first 32 files, no problem. I deleted t= he dataset, created a new one, and tried to load the entire 76 files into t= he newly created (hence empty) dataset.=C2=A0

It took about 2mins after= executing the query for the error message to show up. There are currently = 31710406 rows of data in the dataset, despite the error message (so it look= s like it did load).=C2=A0

<= div class=3D"gmail_default" style=3D"font-family:monospace,monospace;font-s= ize:small;color:rgb(68,68,68)">So my questions are: 1) why did I still get = that error message when I was loading to an empty dataset; and 2) I'm n= ot sure if all the data from the 76 file are fully loaded. Is there other w= ays to check, besides trying to load it again and hope this time I don'= t get the error?

Thanks!
Yiran

On Thu, = Feb 18, 2016 at 10:29 PM, Steven Jacobs <sjaco002@ucr.edu> wr= ote:
Hi,=C2=A0
Welcome! We are an Apa= che incubator project now so I added the correct mailing list. Our=C2=A0&qu= ot;load" statement only works on an empty dataset. Subsequent data nee= ds to be added with an insert or a feed. You should be able to load all 76 = files at once though (starting from empty).
Steven


On = Thursday, February 18, 2016, Yiran Wang <wyr4137@gmail.com> wrote:
Hi Asterix team!

I've come across this error when I was trying to load 7= 6 files into a dataset. When I test-loaded the first 32 files, there wasn&#= 39;t such an error. All 76 files are of the same data format.=C2=A0

Can you help in= terpret what this error message means?

<= /div>
Thanks!
Yiran=

--
Best,
Yiran
=

--
You received this message because you are subscribed to the Google Groups &= quot;asterixdb-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an e= mail to asterixdb-dev+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups &= quot;asterixdb-users" group.
To unsubscribe from this group and stop receiving emails from it, send an e= mail to asterixdb-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Be= st,
Yiran

--
You received this message because you are subscribed to the Google Groups &= quot;asterixdb-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an e= mail to asterixdb-dev+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups &= quot;asterixdb-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an e= mail to asterixdb-dev+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups &= quot;asterixdb-users" group.
To unsubscribe from this group and stop receiving emails from it, send an e= mail to asterixdb-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
=
Best,
Yiran
--001a113f96da4a3f9e052c23b1fa-- --001a113f96da4a3fa1052c23b1fc--