From user-return-26344-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Mon Jun 24 10:02:49 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id D7EC5180671 for ; Mon, 24 Jun 2019 12:02:48 +0200 (CEST) Received: (qmail 88343 invoked by uid 500); 24 Jun 2019 10:02:47 -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 88333 invoked by uid 99); 24 Jun 2019 10:02:47 -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; Mon, 24 Jun 2019 10:02:47 +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 3B8171A45E1 for ; Mon, 24 Jun 2019 10:02:47 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.423 X-Spam-Level: *** X-Spam-Status: No, score=3.423 tagged_above=-999 required=6.31 tests=[DKIM_ADSP_CUSTOM_MED=0.001, FORGED_GMAIL_RCVD=1, FREEMAIL_ENVFROM_END_DIGIT=0.25, NML_ADSP_CUSTOM_MED=1.2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_PASS=-0.001, SPF_SOFTFAIL=0.972, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id UJt9drDgAF2p for ; Mon, 24 Jun 2019 10:02:45 +0000 (UTC) Received: from n6.nabble.com (n6.nabble.com [162.255.23.37]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 3ED9B5F17E for ; Mon, 24 Jun 2019 10:02:45 +0000 (UTC) Received: from n6.nabble.com (localhost [127.0.0.1]) by n6.nabble.com (Postfix) with ESMTP id F3046F2F9DA7 for ; Mon, 24 Jun 2019 03:02:43 -0700 (MST) Date: Mon, 24 Jun 2019 03:02:43 -0700 (MST) From: Ishan Gandhi To: user@ignite.apache.org Message-ID: <1561370563992-0.post@n6.nabble.com> Subject: Failed to run map query remotely.Failed to execute map query on the node MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I am using partitioned caches in my ignite 2.6 cluster. Faced this issue, that the ignite cache query (using jdbc ) was unable to retrieve even 'Select count(*) query results'. Though the '!tables command' did display the names of my 3 caches. The ignite server was also running without any exceptions being thrown. While querying, below exception was generated in jdbc:ignite sqlline: java.sql.SQLException: javax.cache.CacheException: Failed to run map query remotely.Failed to execute map query on the node org.apache.ignite.IgniteCheckedException:Failed to parse SQL query: SELECT COUNT(*) __C0_0 This issue did not show up once the ignite cluster was restarted. What could be the cause of such behaviour by Ignite -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/