Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 51C69200CFC for ; Thu, 28 Sep 2017 23:05:58 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 501741609CD; Thu, 28 Sep 2017 21:05:58 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 958891609B4 for ; Thu, 28 Sep 2017 23:05:57 +0200 (CEST) Received: (qmail 83802 invoked by uid 500); 28 Sep 2017 21:05:51 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 83792 invoked by uid 99); 28 Sep 2017 21:05:51 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Sep 2017 21:05:51 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id D83A61A1AF3 for ; Thu, 28 Sep 2017 21:05:50 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.389 X-Spam-Level: ** X-Spam-Status: No, score=2.389 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, REPTO_QUOTE_YAHOO=0.49, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=yahoo.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id UoXbDhdhYsQ4 for ; Thu, 28 Sep 2017 21:05:49 +0000 (UTC) Received: from sonic317-2.consmr.mail.ne1.yahoo.com (sonic317-2.consmr.mail.ne1.yahoo.com [66.163.184.229]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 415FD5F5F7 for ; Thu, 28 Sep 2017 21:05:49 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1506632742; bh=sAwTSE+GVoKcPljL9dfoYixixPmgHQ/DN62erYCIGhc=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=QLEjji2FX+cnBCJWWi9t94cWtIDd/NK1lplV5gsfXaz/u12n0yKr2/Lk1TeLAzHDlSKEM+2yk7JuH7WqH7tn4K0LHrjJ6CpGVr/stZ+xPUCmrQA1/jeL2+4KV5hVGzTanD1qVEouyO6KCiRxMnFxPJJimzVWMp9QLnVwm5HsQy4NSL0FA8tjtXLigSaFHhjTXcnZXK17j5BR/kP4ZiQo+7/uxDLoLNJunv78YX44n3XFSSiKovh7ACo5vm0pwSIaRVqf5KALfOonvnXInE6za/CqfjVXxEbtRP/U7WA2PS+aKTW26VGEwnBG6ZTdNTzlEJ6f5LQooynDAYM9AVvDiA== X-YMail-OSG: nH9l7IsVM1nZZQ9IMfFMkq8vnYsf42R3enLdNxTuGu0TSDNWGS6vr.KHSboqom9 ZM6Rb_epp7uSgrtMCx3GA_YHWLxJaf09M5l_SYsqrk9HHkUapT.yNZXz__uknTwwa3xMdeFYeOH5 39uOG6AuOogBHb4E7d_igLRC34ezh22RJ4fo1I1PjYoTm6OO6sW8CPFQJR0l6uyUct8uV9eUgeXm TvtFtCdu1_gXvwi7WQAzrAydbAL1rCk4_47svGI2jbAVIutYi1w0._p7kK.4NPH4hoUV_qXEWdgG l61SOVjWcf_XvjokYel9ycsPAu6lc2mGZn6kY.w3VPrfa4H0bcubr.ZUiakhPhzCjKcHQvl9eEy_ EojHIJWhm5JHx4rDMOkGDPm8HVunWHfWtYH9yjKdv9z1K9Txv3NRrl4L3cK3w_XoWrIok33N_Jrq Fi5kiw7rgll0T6C8Ip.un82WwiLaZxquVvbsfHZj9Xd8cqoNASz3qN_6dP960b7JUEBKtzVe2qwc LrnAMuSiz7Q-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic317.consmr.mail.ne1.yahoo.com with HTTP; Thu, 28 Sep 2017 21:05:42 +0000 Date: Thu, 28 Sep 2017 21:01:41 +0000 (UTC) From: vijayendra bhati Reply-To: "veejayendraa@yahoo.com" To: "rayliu@cisco.com" , "user@ignite.apache.org" Message-ID: <388374482.107458.1506632501835@mail.yahoo.com> In-Reply-To: <1506513776256-0.post@n6.nabble.com> References: <1506513776256-0.post@n6.nabble.com> Subject: Re: Full table scan query by ODBC causing node shutdown MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_107457_1473838748.1506632501834" X-Mailer: WebService/1.1.10653 YahooMailAndroidMobile YMobile/1.0 (com.yahoo.mobile.client.android.mail/5.18.2; Android/7.1.1; NMF26F; OnePlus3; OnePlus; ONEPLUS A3003; 5.5; 1920x1080;) archived-at: Thu, 28 Sep 2017 21:05:58 -0000 ------=_Part_107457_1473838748.1506632501834 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Sent from Yahoo Mail on Android=20 =20 On Wed, Sep 27, 2017 at 1:03 PM, Ray wrote: I have a = cache with 6 million rows. The cache is configured with Partitioned cache mode and 3 backups.=20 And I'm running Ignite 2.1 on 4 nodes and each have a 8Gb heap size and 30G= b non-heap size configured. When I'm trying to fetch all the rows using "select * from mytable" by odbc driver on windows, the node I'm querying will throw exception and eventuall= y shut down. The debug log is in the attachment, the sql query begins at line 2579. =20 Please advice me how to solve this problem Thanks ignite-6593a74d.log =C2=A0=20 -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ =20 ------=_Part_107457_1473838748.1506632501834 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Sent from Yahoo Mail on Android
On Wed, Sep 27, 2017 at 1:03 PM= , Ray
<rayliu@cisco.com> wrote:
I have a cache with 6 million rows.
The cache is configured with Partitioned cache mode and 3 backups.=
And I'm running Ignite 2.1 on 4 nodes and each = have a 8Gb heap size and 30Gb
non-heap size confi= gured.
When I'm trying to fetch all the rows usin= g "select * from mytable" by odbc
driver on windo= ws, the node I'm querying will throw exception and eventually
shut down.

The debug log is in the attachment, the sql query begins at line 2579.

Please advice me how to= solve this problem
Thanks
ignite-6593a74d.log



--
= ------=_Part_107457_1473838748.1506632501834--