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 A7A43200C4B for ; Mon, 20 Mar 2017 13:08:57 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id A6381160B81; Mon, 20 Mar 2017 12:08:57 +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 CA2FE160B76 for ; Mon, 20 Mar 2017 13:08:56 +0100 (CET) Received: (qmail 89290 invoked by uid 500); 20 Mar 2017 12:08:56 -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 89280 invoked by uid 99); 20 Mar 2017 12:08:55 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Mar 2017 12:08:55 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 810A4C03A7 for ; Mon, 20 Mar 2017 12:08:55 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.179 X-Spam-Level: ** X-Spam-Status: No, score=2.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, KAM_NUMSUBJECT=0.5, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-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 (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id mL3ZCP2rFmzA for ; Mon, 20 Mar 2017 12:08:54 +0000 (UTC) Received: from mail-it0-f50.google.com (mail-it0-f50.google.com [209.85.214.50]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 25C8D5F238 for ; Mon, 20 Mar 2017 12:08:54 +0000 (UTC) Received: by mail-it0-f50.google.com with SMTP id w124so85994538itb.1 for ; Mon, 20 Mar 2017 05:08:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=G9Iw+txL75jxVzthlOMEMTI9UWgh+wU0Dm28FbjKySg=; b=dB8lVuOs6dCL1gqDTI/Lj2oTeKXgc7KhQ4iKom2Y1F1ij4Tq5lkF8AOByT7kG2sFKj DH8rFxbgJDVp8St7yct6kOgWGyigq9XwEPieVoblFpyhQILXN1kJQ79iPTUjwra3kdiu /zwWAfSE0oZc3HnmRY8w6tnhN9pkFS19JufRh2QVNv8CO3znwX7sjN7oZO7WPV1mEPpM 2p3EC/Jo/INZQB4Tme/5KJE4rGu+MFN7om3FKCbCRLKQq0oiholvZXBTa1uOxXqb5Wan 2CSyj0ftPBpyPK7OnyDQw45TpT4I8UTujV7/37Bp5VwewR6P1l+szbVZTAfpFB7KS1U5 8VmQ== 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=G9Iw+txL75jxVzthlOMEMTI9UWgh+wU0Dm28FbjKySg=; b=C4gK+SIDlNXAi1KQ0AUKCAe14F6hAFInTPtv8cfvzLe9M1KeCQPsNBwPUduolN0YBM esGJHznrWnXucWA7BYQl//8vcfhwoQBmtRlWvXa84kS8u7ZSIonEqNkEZwA+e1wskffe FfDVJJhlo4tW+c7Cuj2c6HGCR17Ric2u+BmJg2jVX3n3z0lQqFDSeBosXicXOjo7a7nJ DQR3/G+yQlIpa6DexLXyFOp1gB4ffsDMD4aiMormSKRYrEkdMsVXDzV/dqk9nG5F3WI5 DqbwwfGJCaOul9hrWPAKiwy47uX3fh++KOm82Y4ktKb0mssm0qmNb4FkKZ//cF5gp05b 1qSQ== X-Gm-Message-State: AFeK/H3jrQ/g+mcuEuiI9ggEtmEsrwLT8hOKe5uTsvP+zynzp/9e2tWGlh+wsriSDbJJL0AX4o1/SNKTqmAOJA== X-Received: by 10.36.204.136 with SMTP id x130mr9269697itf.93.1490004721944; Mon, 20 Mar 2017 03:12:01 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.133.6 with HTTP; Mon, 20 Mar 2017 03:11:21 -0700 (PDT) In-Reply-To: References: <1489503481534-11169.post@n6.nabble.com> From: Anil Date: Mon, 20 Mar 2017 15:41:21 +0530 Message-ID: Subject: Re: IGNITE-4106 To: user@ignite.apache.org Content-Type: multipart/alternative; boundary=94eb2c05ff862a50bc054b26c2ee archived-at: Mon, 20 Mar 2017 12:08:57 -0000 --94eb2c05ff862a50bc054b26c2ee Content-Type: text/plain; charset=UTF-8 Hi Andrey, I see few more issues with IGNITE-4826 1. queryParallelism should be used for all caches for which queries are used other it throws following exception. Caused by: java.sql.SQLException: Failed to query Ignite. at org.apache.ignite.internal.jdbc2.JdbcStatement.executeQuery(JdbcStatement.java:131) at org.apache.ignite.internal.jdbc2.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:76) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) Caused by: javax.cache.CacheException: class org.apache.ignite.IgniteException: Using indexes with different parallelism levels in same query is forbidden. at org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:760) at org.apache.ignite.internal.jdbc2.JdbcQueryTask.call(JdbcQueryTask.java:161) at org.apache.ignite.internal.jdbc2.JdbcStatement.executeQuery(JdbcStatement.java:116) ... 13 more 2. query is not returning same result if it is hit number of times. please let me know if these are known issues. Thanks --94eb2c05ff862a50bc054b26c2ee Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Andrey,

I see few more issues with= IGNITE-4826

1. queryParallelism should be used for all caches for which queries = are used other it throws following exception.

Caused b= y: java.sql.SQLException: Failed to query Ignite.
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.ignite.internal.jdbc2.Jdbc= Statement.executeQuery(JdbcStatement.java:131)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.ignite.internal.jdbc2.JdbcPre= paredStatement.executeQuery(JdbcPreparedStatement.java:76)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.commons.dbcp2.De= legatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.= commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedSt= atement.java:83)
=C2=A0 =C2=A0 =C2=A0=C2=A0=
Caused by: javax.cache.CacheException: cla= ss org.apache.ignite.IgniteException: Using indexes with different parallel= ism levels in same query is forbidden.
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.ignite.internal.processors.cache.Ign= iteCacheProxy.query(IgniteCacheProxy.java:760)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.ignite.internal.jdbc2.JdbcQue= ryTask.call(JdbcQueryTask.java:161)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 at org.apache.ignite.internal.jdbc2.JdbcStatement.exec= uteQuery(JdbcStatement.java:116)
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 ... 13 more
2. query is n= ot returning same result if it is hit number of times.

please let me know if thes= e are known issues.=C2=A0

Thanks
--94eb2c05ff862a50bc054b26c2ee--