From user-return-17809-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Wed Feb 14 22:31:16 2018 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 [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id EE2E0180621 for ; Wed, 14 Feb 2018 22:31:15 +0100 (CET) Received: (qmail 93860 invoked by uid 500); 14 Feb 2018 21:31:14 -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 93850 invoked by uid 99); 14 Feb 2018 21:31:14 -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; Wed, 14 Feb 2018 21:31:14 +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 20D481A0262 for ; Wed, 14 Feb 2018 21:31:14 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.299 X-Spam-Level: * X-Spam-Status: No, score=1.299 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=aegon.onmicrosoft.com 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 n1l5HPn5nH2b for ; Wed, 14 Feb 2018 21:31:11 +0000 (UTC) Received: from mx0b-00099f01.pphosted.com (mx0a-00099f01.pphosted.com [67.231.149.228]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id B8BC15F180 for ; Wed, 14 Feb 2018 21:31:10 +0000 (UTC) Received: from pps.filterd (m0074060.ppops.net [127.0.0.1]) by mx0a-00099f01.pphosted.com (8.16.0.22/8.16.0.22) with SMTP id w1ELQdFG013188 for ; Wed, 14 Feb 2018 15:31:09 -0600 Received: from crexpp04.us.aegon.com (email2.aegonusa.com [162.123.17.223]) by mx0a-00099f01.pphosted.com with ESMTP id 2g442rmw1h-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Wed, 14 Feb 2018 15:31:09 -0600 Received: from pps.filterd (crexpp04.us.aegon.com [127.0.0.1]) by crexpp04.us.aegon.com (8.16.0.21/8.16.0.21) with SMTP id w1EL2rF8030791 for ; Wed, 14 Feb 2018 15:31:07 -0600 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=Aegon.onmicrosoft.com; s=selector1-transamerica-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=7arv3bFGObFbIVtV7Q58D5Mz6y6qYylRapM8xd4LCKg=; b=gyXBXZlHd0cyfIJzSqMMDQKBVSRai3hPHxfx8PAU22mPY7Q+NacULPFi7strAr0ZFlBuzOELET6ngvNHO3grmYouq/ah18pgT11OhT+KRChXtKamiQg0T/osDYASNwSAo4ENHs74V8cr97n7N64xcEaArEO1W5X26e+DZPZqm5k= From: "Williams, Michael" To: "user@ignite.apache.org" Subject: QuerySqlFunction Thread-Topic: QuerySqlFunction Thread-Index: AdOl2uXBv4gL2AUCRN+C3PKVtujg/w== Date: Wed, 14 Feb 2018 21:29:40 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [198.39.84.18] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;DM5PR05MB3450;7:RA21gG0RdUzjXknGQpw/Hqo709eHQDleDyeOw1wUQct4bdRaMjUs4XhEoehRrrLa3MUPI7GyE6UEwH+Xv7YE3YfUmL+wHG9T7GMxy0VPE39i3wRXRjPZpTOd4Rvb4kAVmScsXMcnHLU3Yc5kNyPT2y4Y+xUmAsw5Z8IN48UDYBvzJVCJ7qgiiL0EFe3cM4VJnnjuy0WKiKG5YD5qPJ4ir1ieFu09nKF7TYofFiSD180WJsarePz+rdlZfbt7ldhN;20:QIe+XrhdWIsAeAx8xoDBwNYqjxU3aklpuMGbeErmTS+6PkX2tSQGqOOvcc6Yrq4XbZ+vSMX3luCRRKKjTRT35nKCBqRkZ1ePDThgJMtDL6sgx5RUG6M5Y5g9EOF6x/ARKmjGnWujiQwiYscbPGgOVUuE43Hza9N1kc8/RSceqV/eDco3SPWM3cFaY2lRIUtddUYWXFyOhOEVIPMp3FU4HjfCpfhqVtKT884lb8UMkN/vcz2G8MMtGUekUa3JGLzAWPoJKsaIcLfx8m4AKXYW3Ib4qwFmrcLPk7AbFn5eXU4uEbYkvNzUBGwnAI42kQqprodX6JyGnisM63ILydhxm5HzGFg6pOMDTwUjWQAaZ09uHf/WbXD+60O/5bMXRNwZh0FYAhRf0lMyj8cQjW9ybqEHSS1j5Yx4slWRe8tHJ+z8AADJ3flVf0iCScOZu/WgdV2NmrA1+t17W8nLMzvI/24cin3zjTVKuHH4BFKv7/EbZoKTuvcAiN33T6tUWRNU x-ms-exchange-antispam-srfa-diagnostics: SSOS; x-ms-office365-filtering-correlation-id: e3249142-1072-40d5-cea1-08d573f20eaa x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652020)(5600026)(4604075)(3008032)(4534165)(4627221)(201703031133081)(201702281549075)(2017052603307)(7153060)(7193020);SRVR:DM5PR05MB3450; x-ms-traffictypediagnostic: DM5PR05MB3450: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(28532068793085)(21748063052155); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(8211001020)(6040501)(2401047)(8121501046)(5005006)(10201501046)(3231101)(2400082)(944501161)(93006095)(93001095)(3002001)(6041288)(20161123564045)(201703131423095)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(20161123558120)(20161123560045)(20161123562045)(6072148)(201708071742011);SRVR:DM5PR05MB3450;BCL:0;PCL:0;RULEID:;SRVR:DM5PR05MB3450; x-forefront-prvs: 0583A86C08 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(39380400002)(39860400002)(376002)(346002)(396003)(366004)(199004)(189003)(57704003)(5640700003)(1730700003)(99286004)(790700001)(6506007)(2900100001)(3846002)(6116002)(2906002)(221733001)(7736002)(74316002)(3280700002)(106356001)(3660700001)(105586002)(25786009)(33656002)(2351001)(478600001)(53936002)(66066001)(6436002)(68736007)(54896002)(6306002)(55016002)(9686003)(7696005)(97736004)(316002)(14454004)(26005)(77096007)(3480700004)(8676002)(6916009)(86362001)(2501003)(186003)(102836004)(7116003)(81166006)(81156014)(8936002)(5660300001)(6346003)(136703002)(132573001);DIR:OUT;SFP:1102;SCL:1;SRVR:DM5PR05MB3450;H:DM5PR05MB2954.namprd05.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; received-spf: None (protection.outlook.com: transamerica.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: DCJh3OE88Wqo3+5/BKaoXGEMe3iPQp9GH651Oce7ovWINiSFvmQKT6bX3PV2fStHM5/BgoYLR33SFkYHxiHD7A== spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_DM5PR05MB295476FFD3AE0DE936EE34A5FEF50DM5PR05MB2954namp_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-Network-Message-Id: e3249142-1072-40d5-cea1-08d573f20eaa X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Feb 2018 21:29:40.6947 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 46e16835-c804-41de-be3c-55835d14dee4 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR05MB3450 X-EXCLAIMER-MD-CONFIG: 7562670a-beab-4c6e-8ed2-ab3b5287c042 X-OriginatorOrg: transamerica.com x-crexppdlp-TriggeredRule: module.access.rule.forcepoint_dlp_reroute v2 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2018-02-14_08:,, signatures=0 X-VPM-MSG-ID: 56d5cec6-d311-411b-be8c-191c43afc0cc X-VPM-HOST: crexzx03.inet.nogea.local X-VPM-GROUP-ID: 667e27e3-79a8-4740-a405-c26cded34000 X-VPM-ENC-REGIME: Plaintext X-VPM-IS-HYBRID: 0 x-crexpp01-TriggeredRule: module.access.rule.Strip_Receive_HeadersV2 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2018-02-14_08:,, signatures=0 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2018-02-14_08:,, signatures=0 --_000_DM5PR05MB295476FFD3AE0DE936EE34A5FEF50DM5PR05MB2954namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable What changes do I need to do to make ZeroDeploy work with QuerySqlFunction = definitions? I'm following the example and adding the class as follows, bu= t even with peer class loading enabled, I get a gnarly error. Can clients m= arshal to servers? Any advice? import org.apache.ignite.cache.query.annotations.QuerySqlFunction; public class MyFunctions { @QuerySqlFunction public static int sqr(int x) { return x * x; } } ... cfg.setPeerClassLoadingEnabled(true); cfg.setClientMode(true); cfg.setDeploymentMode(DeploymentMode.CONTINUOUS); try(Ignite ignite =3D Ignition.start(cfg)) ... myCache.setSqlFunctionClasses(MyFunctions.class); ... Error: class org.apache.ignite.IgniteCheckedException: Failed to find class with g= iven class loader for unmarshalling (make sure same versions of all classes= are available on all nodes or enable peer-class-loading) [clsLdr=3Dsun.misc.Launcher$AppClassLoader@764c1= 2b6, cls=3DIgniteStartup.MyFunctions] at org.apache.ignite.marshaller.jdk.JdkMarshaller.unmarshal0(JdkMar= shaller.java:126) at org.apache.ignite.marshaller.AbstractNodeNameAwareMarshaller.unm= arshal(AbstractNodeNameAwareMarshaller.java:94) at org.apache.ignite.marshaller.jdk.JdkMarshaller.unmarshal0(JdkMar= shaller.java:143) at org.apache.ignite.marshaller.AbstractNodeNameAwareMarshaller.unm= arshal(AbstractNodeNameAwareMarshaller.java:82) at org.apache.ignite.internal.util.IgniteUtils.unmarshal(IgniteUtil= s.java:9795) at org.apache.ignite.spi.discovery.tcp.messages.TcpDiscoveryCustomE= ventMessage.message(TcpDiscoveryCustomEventMessage.java:81) at org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker= .notifyDiscoveryListener(ServerImpl.java:5460) at org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker= .processCustomMessage(ServerImpl.java:5282) at org.apache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker= .processMessage(ServerImpl.java:2656) Thanks, Mike Williams --_000_DM5PR05MB295476FFD3AE0DE936EE34A5FEF50DM5PR05MB2954namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

What changes do I need to do to make ZeroDeploy work= with QuerySqlFunction  definitions? I’m following the example a= nd adding the class as follows, but even with peer class loading enabled, I= get a gnarly error. Can clients marshal to servers? Any advice?

 

 

import org.apache.ignite.cache.query.annotations.Que= rySqlFunction;

 

public class MyFunctions {

    @QuerySqlFunction

    public static int sqr(int x) {

        return x = * x;

    }

}

 

cfg.setPeerClassLoadingEnabled(true);

cfg.setClientMode(true);

cfg.setDeploymentMode(DeploymentMode.CONTINUOUS);

try(Ignite ignite =3D Ignition.start(cfg))

myCache.setSqlFunctionClasses(MyFunctions.class);

 

 

Error:

class org.apache.ignite.IgniteCheckedException: Fail= ed to find class with given class loader for unmarshalling (make sure same = versions of all classes are available on all nodes or

enable peer-class-loading) [clsLdr=3Dsun.misc.Launch= er$AppClassLoader@764c12b6, cls=3DIgniteStartup.MyFunctions]

        at org.ap= ache.ignite.marshaller.jdk.JdkMarshaller.unmarshal0(JdkMarshaller.java:126)=

        at org.ap= ache.ignite.marshaller.AbstractNodeNameAwareMarshaller.unmarshal(AbstractNo= deNameAwareMarshaller.java:94)

        at org.ap= ache.ignite.marshaller.jdk.JdkMarshaller.unmarshal0(JdkMarshaller.java:143)=

        at org.ap= ache.ignite.marshaller.AbstractNodeNameAwareMarshaller.unmarshal(AbstractNo= deNameAwareMarshaller.java:82)

        at org.ap= ache.ignite.internal.util.IgniteUtils.unmarshal(IgniteUtils.java:9795)=

        at org.ap= ache.ignite.spi.discovery.tcp.messages.TcpDiscoveryCustomEventMessage.messa= ge(TcpDiscoveryCustomEventMessage.java:81)

        at org.ap= ache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.notifyDiscoveryL= istener(ServerImpl.java:5460)

        at org.ap= ache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.processCustomMes= sage(ServerImpl.java:5282)

        at org.ap= ache.ignite.spi.discovery.tcp.ServerImpl$RingMessageWorker.processMessage(S= erverImpl.java:2656)

 

Thanks,

Mik= e Williams

 

--_000_DM5PR05MB295476FFD3AE0DE936EE34A5FEF50DM5PR05MB2954namp_--