Return-Path: <user-return-7038-archive-asf-public=cust-asf.ponee.io@ignite.apache.org>
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 63F47200B79
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Wed,  7 Sep 2016 11:26:05 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id 62840160AC1; Wed,  7 Sep 2016 09:26:05 +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 89F38160AB1
	for <archive-asf-public@cust-asf.ponee.io>; Wed,  7 Sep 2016 11:26:03 +0200 (CEST)
Received: (qmail 55384 invoked by uid 500); 7 Sep 2016 09:26:02 -0000
Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@ignite.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@ignite.apache.org>
List-Post: <mailto:user@ignite.apache.org>
List-Id: <user.ignite.apache.org>
Reply-To: user@ignite.apache.org
Delivered-To: mailing list user@ignite.apache.org
Received: (qmail 55366 invoked by uid 99); 7 Sep 2016 09:26:02 -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, 07 Sep 2016 09:26:02 +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 D251B1A7B95
	for <user@ignite.apache.org>; Wed,  7 Sep 2016 09:26:01 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: 2.973
X-Spam-Level: **
X-Spam-Status: No, score=2.973 tagged_above=-999 required=6.31
	tests=[DKIM_ADSP_CUSTOM_MED=0.001, KAM_ASCII_DIVIDERS=0.8,
	NML_ADSP_CUSTOM_MED=1.2, RCVD_IN_DNSWL_NONE=-0.0001,
	SPF_SOFTFAIL=0.972] 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 aWyRiH_IgxLf for <user@ignite.apache.org>;
	Wed,  7 Sep 2016 09:25:52 +0000 (UTC)
Received: from mbob.nabble.com (mbob.nabble.com [162.253.133.15])
	by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 9637960DC6
	for <user@ignite.apache.org>; Wed,  7 Sep 2016 09:25:51 +0000 (UTC)
Received: from malf.nabble.com (unknown [162.253.133.59])
	by mbob.nabble.com (Postfix) with ESMTP id 0EAFD30987BB
	for <user@ignite.apache.org>; Wed,  7 Sep 2016 02:24:08 -0700 (PDT)
Date: Wed, 7 Sep 2016 02:25:44 -0700 (PDT)
From: seyeony <seyeonyoon@gmail.com>
To: user@ignite.apache.org
Message-ID: <1473240344473-7576.post@n6.nabble.com>
In-Reply-To: <CALH+G9rbvF2dzkKLimtiYe-HWhW+BN4Ftm9ne_U4NeCnXYqoMQ@mail.gmail.com>
References: <1473151287286-7538.post@n6.nabble.com> <CALH+G9reB1siApAReGBwHzKmv8SBm2pNssqpdAPivZQ_XbPjDg@mail.gmail.com> <1473223815787-7573.post@n6.nabble.com> <CALH+G9rbvF2dzkKLimtiYe-HWhW+BN4Ftm9ne_U4NeCnXYqoMQ@mail.gmail.com>
Subject: Re: CacheJdbcPojoStore with MariaDB
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
archived-at: Wed, 07 Sep 2016 09:26:05 -0000

Hi Alexey,
I modified the examples of
examples/schema-import/src/main/java/org/apache/ignite/schema/*

1. 5802153 objects of AffiliateStore (This was created with
bin/ignie-schema-import.sh)
2. OFFHEAP_TIERED is used already.
3. start 3 node: ignite.sh example-ignite.xml ( with modified
example-default.xml) or java -Xms1024m -Xmx1024m demo.DemoNode (from
examples)
4. start client: java -Xms1024m -Xmx1024m demo.Demo (using
exmaple-ignite.xml and modified example-default.xml)
5. I was able to load 3,000,000 objects of AffiliateStore (Maybe more, but
failed to load 5,802153 ojbects)

example-default.xml which is included in example-ignite.xml
===========================================

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:util="http://www.springframework.org/schema/util"
       xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/util
        http://www.springframework.org/schema/util/spring-util.xsd">

    <bean id="mariadbDataSource" class="org.mariadb.jdbc.MariaDbDataSource">
        <property name="url"
value="jdbc:mariadb://192.168.10.213:3306/ignite"/>
        <property name="user" value="ecube"/>
        <property name="password" value="obzcom1!"/>
    </bean>

    <bean abstract="true" id="ignite.cfg"
class="org.apache.ignite.configuration.IgniteConfiguration">
        
        <property name="peerClassLoadingEnabled" value="true"/>
        
        

        
        <property name="includeEventTypes">
            <list>
                
                <util:constant
static-field="org.apache.ignite.events.EventType.EVT_TASK_STARTED"/>
                <util:constant
static-field="org.apache.ignite.events.EventType.EVT_TASK_FINISHED"/>
                <util:constant
static-field="org.apache.ignite.events.EventType.EVT_TASK_FAILED"/>
            </list>
        </property>

        <property name="cacheConfiguration">
            <bean
class="org.apache.ignite.configuration.CacheConfiguration">
                <property name="cacheMode" value="PARTITIONED"/>
                <property name="backups" value="1"/>
                <property name="writeSynchronizationMode"
value="FULL_ASYNC"/>
                <property name="memoryMode" value="OFFHEAP_TIERED"/>
                <property name="startSize" value="#{100 * 1024 * 1024}"/>
                <property name="offHeapMaxMemory" value="#{4 * 1024L * 1024L
* 1024L}"/>
                
                <property name="swapEnabled" value="false"/>
            </bean>
        </property>
        
        <property name="discoverySpi">
            <bean
class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi">
                <property name="ipFinder">
                    
                    
                    <bean
class="org.apache.ignite.spi.discovery.tcp.ipfinder.vm.TcpDiscoveryVmIpFinder">
                    
                        <property name="addresses">
                            <list>
                                
                                <value>192.168.10.57</value>
                                <value>192.168.10.58:47500..47509</value>
                                <value>192.168.10.59:47500..47509</value>
                                
                            </list>
                        </property>
                    </bean>
                </property>
            </bean>
        </property>
    </bean>
</beans>

CacheConfig.java create by ignite-schema-import.sh
=======================================
package demo;

import java.sql.*;
import java.util.*;

import org.apache.ignite.cache.*;
import org.apache.ignite.cache.store.jdbc.*;
import org.apache.ignite.configuration.*;

/**
 * CacheConfig definition.
 *
 * Code generated by Apache Ignite Schema Import utility: 09/06/2016.
 */
public class CacheConfig {
    /**
     * Create JDBC type for AffiliateStore.
     *
     * @param cacheName Cache name.
     * @return Configured JDBC type.
     */
    private static JdbcType jdbcTypeAffiliateStore(String cacheName) {
        JdbcType jdbcType = new JdbcType();

        jdbcType.setCacheName(cacheName);
        jdbcType.setDatabaseSchema("ignite");
        jdbcType.setDatabaseTable("AffiliateStore");
        jdbcType.setKeyType("demo.AffiliateStoreKey");
        jdbcType.setValueType("demo.AffiliateStore");
        // Key fields for AffiliateStore.
        Collection<JdbcTypeField> keys = new ArrayList<>();
        keys.add(new JdbcTypeField(Types.VARCHAR, "affiliateNo",
String.class, "affiliateno"));
        keys.add(new JdbcTypeField(Types.VARCHAR, "approvalDate",
String.class, "approvaldate"));
        keys.add(new JdbcTypeField(Types.VARCHAR, "approvalTime",
String.class, "approvaltime"));
        keys.add(new JdbcTypeField(Types.VARCHAR, "customerNo",
String.class, "customerno"));
        jdbcType.setKeyFields(keys.toArray(new JdbcTypeField[keys.size()]));

        // Value fields for AffiliateStore.
        Collection<JdbcTypeField> vals = new ArrayList<>();
        vals.add(new JdbcTypeField(Types.VARCHAR, "affiliateNo",
String.class, "affiliateno"));
        vals.add(new JdbcTypeField(Types.VARCHAR, "affiliateType",
String.class, "affiliatetype"));
        vals.add(new JdbcTypeField(Types.VARCHAR, "affiliateRegionCity",
String.class, "affiliateregioncity"));
        vals.add(new JdbcTypeField(Types.VARCHAR, "affiliateRegionStreet",
String.class, "affiliateregionstreet"));
        vals.add(new JdbcTypeField(Types.DECIMAL, "approvalAmount",
java.math.BigDecimal.class, "approvalamount"));
        vals.add(new JdbcTypeField(Types.VARCHAR, "approvalDate",
String.class, "approvaldate"));
        vals.add(new JdbcTypeField(Types.VARCHAR, "approvalTime",
String.class, "approvaltime"));
        vals.add(new JdbcTypeField(Types.VARCHAR, "cardType", String.class,
"cardtype"));
        vals.add(new JdbcTypeField(Types.VARCHAR, "customerNo",
String.class, "customerno"));
        vals.add(new JdbcTypeField(Types.VARCHAR, "gender", String.class,
"gender"));
        vals.add(new JdbcTypeField(Types.DECIMAL, "age",
java.math.BigDecimal.class, "age"));
        vals.add(new JdbcTypeField(Types.DECIMAL, "ageRange",
java.math.BigDecimal.class, "agerange"));
        vals.add(new JdbcTypeField(Types.DECIMAL, "annualIcome",
java.math.BigDecimal.class, "annualicome"));
        vals.add(new JdbcTypeField(Types.VARCHAR, "residentialCity",
String.class, "residentialcity"));
        vals.add(new JdbcTypeField(Types.VARCHAR, "residentialStreet",
String.class, "residentialstreet"));
        jdbcType.setValueFields(vals.toArray(new
JdbcTypeField[vals.size()]));

        return jdbcType;
    }
    /**
     * Create SQL Query descriptor for AffiliateStore.
     *
     * @return Configured query entity.
     */
    private static QueryEntity queryEntityAffiliateStore() {
        QueryEntity qryEntity = new QueryEntity();

        qryEntity.setKeyType("demo.AffiliateStoreKey");
        qryEntity.setValueType("demo.AffiliateStore");

        // Query fields for AffiliateStore.
        LinkedHashMap<String, String> fields = new LinkedHashMap<>();

        fields.put("affiliateno", "java.lang.String");
        fields.put("affiliatetype", "java.lang.String");
        fields.put("affiliateregioncity", "java.lang.String");
        fields.put("affiliateregionstreet", "java.lang.String");
        fields.put("approvalamount", "java.math.BigDecimal");
        fields.put("approvaldate", "java.lang.String");
        fields.put("approvaltime", "java.lang.String");
        fields.put("cardtype", "java.lang.String");
        fields.put("customerno", "java.lang.String");
        fields.put("gender", "java.lang.String");
        fields.put("age", "java.math.BigDecimal");
        fields.put("agerange", "java.math.BigDecimal");
        fields.put("annualicome", "java.math.BigDecimal");
        fields.put("residentialcity", "java.lang.String");
        fields.put("residentialstreet", "java.lang.String");

        qryEntity.setFields(fields);

        // Indexes for AffiliateStore.
        Collection<QueryIndex> idxs = new ArrayList<>();

        QueryIndex idx = new QueryIndex();

        idx.setName("PRIMARY");

        LinkedHashMap<String, Boolean> idxFlds = new LinkedHashMap<>();

        idxFlds.put("affiliateno", true);
        idxFlds.put("approvaldate", true);
        idxFlds.put("approvaltime", true);
        idxFlds.put("customerno", true);

        idx.setFields(idxFlds);
        idxs.add(idx);

        qryEntity.setIndexes(idxs);

        return qryEntity;
    }

    /**
     * Configure cache.
     *
     * @param cacheName Cache name.
     * @param storeFactory Cache store factory.
     * @return Cache configuration.
     */
    public static <K, V> CacheConfiguration<K, V> cache(String cacheName,
CacheJdbcPojoStoreFactory<K, V> storeFactory) {
        if (storeFactory == null)
             throw new IllegalArgumentException("Cache store factory cannot
be null.");

        CacheConfiguration<K, V> ccfg = new CacheConfiguration<>(cacheName);

        ccfg.setCacheStoreFactory(storeFactory);
        ccfg.setReadThrough(true);
        ccfg.setWriteThrough(true);

        // Configure JDBC types. 
        Collection<JdbcType> jdbcTypes = new ArrayList<>();

        jdbcTypes.add(jdbcTypeAffiliateStore(cacheName));

        storeFactory.setTypes(jdbcTypes.toArray(new
JdbcType[jdbcTypes.size()]));

        // Configure query entities. 
        Collection<QueryEntity> qryEntities = new ArrayList<>();

        qryEntities.add(queryEntityAffiliateStore());

        ccfg.setQueryEntities(qryEntities);

        return ccfg;
    }
}

logs from client side (Demo)
====================
>>> Loading entries from database.
[18:13:28] New version is available at ignite.apache.org: 1.7.0
[18:19:56,902][SEVERE][mgmt-#56%null%][GridTaskWorker] Failed to obtain
remote job result policy for result from ComputeTask.result(..) method (will
fail the whole task): GridJobResultImpl [job=C2V2 [c=LoadCacheJobV2
[keepBinary=false]], sib=GridJobSiblingImpl
[sesId=e314ce30751-1fcbcc36-e000-4980-8e0c-8c53dbfb4e1e,
jobId=f314ce30751-1fcbcc36-e000-4980-8e0c-8c53dbfb4e1e,
nodeId=52524f40-b446-4960-bdf0-2a8da56f89a6, isJobDone=false],
jobCtx=GridJobContextImpl
[jobId=f314ce30751-1fcbcc36-e000-4980-8e0c-8c53dbfb4e1e, timeoutObj=null,
attrs={}], node=TcpDiscoveryNode [id=52524f40-b446-4960-bdf0-2a8da56f89a6,
addrs=[0:0:0:0:0:0:0:1%lo, 10.20.2.0, 10.20.2.1, 127.0.0.1, 192.168.10.59,
192.168.122.1], sockAddrs=[/10.20.2.0:47500, /10.20.2.1:47500,
/192.168.122.1:47500, /0:0:0:0:0:0:0:1%lo:47500, /127.0.0.1:47500,
ecube59/192.168.10.59:47500], discPort=47500, order=3, intOrder=3,
lastExchangeTime=1473239598632, loc=false, ver=1.8.0#20160905-sha1:b640b8ed,
isClient=false], ex=class o.a.i.IgniteException: Failed to load cache:
AffiliateStore, hasRes=true, isCancelled=false, isOccupied=true]
class org.apache.ignite.IgniteException: Remote job threw user exception
(override or implement ComputeTask.result(..) method if you would like to
have automatic failover for this exception).
	at
org.apache.ignite.compute.ComputeTaskAdapter.result(ComputeTaskAdapter.java:101)
	at
org.apache.ignite.internal.processors.task.GridTaskWorker$5.apply(GridTaskWorker.java:1030)
	at
org.apache.ignite.internal.processors.task.GridTaskWorker$5.apply(GridTaskWorker.java:1023)
	at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6553)
	at
org.apache.ignite.internal.processors.task.GridTaskWorker.result(GridTaskWorker.java:1023)
	at
org.apache.ignite.internal.processors.task.GridTaskWorker.onResponse(GridTaskWorker.java:841)
	at
org.apache.ignite.internal.processors.task.GridTaskProcessor.processJobExecuteResponse(GridTaskProcessor.java:995)
	at
org.apache.ignite.internal.processors.task.GridTaskProcessor$JobMessageListener.onMessage(GridTaskProcessor.java:1220)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1238)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:866)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.access$1700(GridIoManager.java:106)
	at
org.apache.ignite.internal.managers.communication.GridIoManager$5.run(GridIoManager.java:829)
	at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: class org.apache.ignite.IgniteException: Failed to load cache:
AffiliateStore
	at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2065)
	at
org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:548)
	at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6521)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:542)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:471)
	at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1113)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1893)
	... 7 more
Caused by: class org.apache.ignite.IgniteException: Failed to load cache:
AffiliateStore
	at
org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:908)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5758)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJobV2.localExecute(GridCacheAdapter.java:5802)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$TopologyVersionAwareJob.execute(GridCacheAdapter.java:6473)
	at
org.apache.ignite.compute.ComputeJobAdapter.call(ComputeJobAdapter.java:132)
	at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2062)
	... 14 more
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load
cache: AffiliateStore
	at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:535)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:497)
	at
org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.localLoadCache(GridCacheProxyImpl.java:228)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5753)
	... 18 more
Caused by: javax.cache.integration.CacheLoaderException: Failed to load
cache: AffiliateStore
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:805)
	at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:512)
	... 21 more
Caused by: javax.cache.integration.CacheLoaderException: Failed to execute
custom query for load cache
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1894)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1837)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	... 3 more
Caused by: java.sql.SQLException: java.io.EOFException: unexpected end of
stream, read 8 bytes from 10
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:533)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1884)
	... 5 more
Caused by: java.io.EOFException: unexpected end of stream, read 8 bytes from
10
	at
org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.readLength(ReadPacketFetcher.java:221)
	at
org.mariadb.jdbc.internal.packet.result.BinaryRowPacket.getRow(BinaryRowPacket.java:260)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.readNextValue(MariaSelectResultSet.java:430)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.nextStreamingValue(MariaSelectResultSet.java:373)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:531)
	... 6 more
[18:19:57] (err) Failed to execute compound future reducer:
GridCompoundFuture [rdc=null, initFlag=1, lsnrCalls=0, done=false,
cancelled=false, err=null, futs=[true]]class
org.apache.ignite.IgniteCheckedException: Failed to load cache:
AffiliateStore
	at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:535)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:497)
	at
org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.localLoadCache(GridCacheProxyImpl.java:228)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5753)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJobV2.localExecute(GridCacheAdapter.java:5802)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$TopologyVersionAwareJob.execute(GridCacheAdapter.java:6473)
	at
org.apache.ignite.compute.ComputeJobAdapter.call(ComputeJobAdapter.java:132)
	at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2062)
	at
org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:548)
	at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6521)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:542)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:471)
	at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1113)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1893)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1238)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:866)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.access$1700(GridIoManager.java:106)
	at
org.apache.ignite.internal.managers.communication.GridIoManager$5.run(GridIoManager.java:829)
	at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: javax.cache.integration.CacheLoaderException: Failed to load
cache: AffiliateStore
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:805)
	at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:512)
	... 21 more
Caused by: javax.cache.integration.CacheLoaderException: Failed to execute
custom query for load cache
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1894)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1837)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	... 3 more
Caused by: java.sql.SQLException: java.io.EOFException: unexpected end of
stream, read 8 bytes from 10
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:533)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1884)
	... 5 more
Caused by: java.io.EOFException: unexpected end of stream, read 8 bytes from
10
	at
org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.readLength(ReadPacketFetcher.java:221)
	at
org.mariadb.jdbc.internal.packet.result.BinaryRowPacket.getRow(BinaryRowPacket.java:260)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.readNextValue(MariaSelectResultSet.java:430)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.nextStreamingValue(MariaSelectResultSet.java:373)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:531)
	... 6 more
[18:20:09] Ignite node stopped OK [uptime=00:06:50:309]
Exception in thread "main" javax.cache.integration.CacheLoaderException:
Failed to load cache: AffiliateStore
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:805)
	at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:512)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:497)
	at
org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.localLoadCache(GridCacheProxyImpl.java:228)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5753)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJobV2.localExecute(GridCacheAdapter.java:5802)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$TopologyVersionAwareJob.execute(GridCacheAdapter.java:6473)
	at
org.apache.ignite.compute.ComputeJobAdapter.call(ComputeJobAdapter.java:132)
	at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2062)
	at
org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:548)
	at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6521)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:542)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:471)
	at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1113)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1893)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1238)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:866)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.access$1700(GridIoManager.java:106)
	at
org.apache.ignite.internal.managers.communication.GridIoManager$5.run(GridIoManager.java:829)
	at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: javax.cache.integration.CacheLoaderException: Failed to execute
custom query for load cache
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1894)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1837)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	... 3 more
Caused by: java.sql.SQLException: java.io.EOFException: unexpected end of
stream, read 8 bytes from 10
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:533)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1884)
	... 5 more
Caused by: java.io.EOFException: unexpected end of stream, read 8 bytes from
10
	at
org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.readLength(ReadPacketFetcher.java:221)
	at
org.mariadb.jdbc.internal.packet.result.BinaryRowPacket.getRow(BinaryRowPacket.java:260)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.readNextValue(MariaSelectResultSet.java:430)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.nextStreamingValue(MariaSelectResultSet.java:373)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:531)
	... 6 more


logs from node-1
============
no logs
[18:13:14] New version is available at ignite.apache.org: 1.7.0
[18:13:18] Topology snapshot [ver=4, servers=3, clients=1, CPUs=12,
heap=4.0GB]
[18:20:09] Topology snapshot [ver=5, servers=3, clients=0, CPUs=12,
heap=3.0GB]

logs from node-2
============
no logs
[18:13:20] New version is available at ignite.apache.org: 1.7.0
[18:20:11] Topology snapshot [ver=5, servers=3, clients=0, CPUs=12,
heap=3.0GB]

logs from node-2
============
[18:13:23] New version is available at ignite.apache.org: 1.7.0
[18:19:56,879][SEVERE][mgmt-#70%null%][GridJobWorker] Failed to execute job
[jobId=f314ce30751-1fcbcc36-e000-4980-8e0c-8c53dbfb4e1e,
ses=GridJobSessionImpl [ses=GridTaskSessionImpl
[taskName=o.a.i.i.processors.cache.GridCacheAdapter$LoadCacheJobV2,
dep=GridDeployment [ts=1473239593942, depMode=SHARED,
clsLdr=sun.misc.Launcher$AppClassLoader@18b4aac2,
clsLdrId=0de2ce30751-52524f40-b446-4960-bdf0-2a8da56f89a6, userVer=0,
loc=true,
sampleClsName=o.a.i.i.processors.cache.distributed.dht.preloader.GridDhtPartitionFullMap,
pendingUndeploy=false, undeployed=false, usage=1],
taskClsName=o.a.i.i.processors.cache.GridCacheAdapter$LoadCacheJobV2,
sesId=e314ce30751-1fcbcc36-e000-4980-8e0c-8c53dbfb4e1e,
startTime=1473239599374, endTime=9223372036854775807,
taskNodeId=1fcbcc36-e000-4980-8e0c-8c53dbfb4e1e,
clsLdr=sun.misc.Launcher$AppClassLoader@18b4aac2, closed=false, cpSpi=null,
failSpi=null, loadSpi=null, usage=1, fullSup=false,
subjId=1fcbcc36-e000-4980-8e0c-8c53dbfb4e1e, mapFut=IgniteFuture
[orig=GridFutureAdapter [resFlag=0, res=null, startTime=1473239599582,
endTime=0, ignoreInterrupts=false, state=INIT]]],
jobId=f314ce30751-1fcbcc36-e000-4980-8e0c-8c53dbfb4e1e]]
class org.apache.ignite.IgniteException: Failed to load cache:
AffiliateStore
        at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2065)
        at
org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:548)
        at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6521)
        at
org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:542)
        at
org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:471)
        at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
        at
org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1113)
        at
org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1893)
        at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1238)
        at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:866)
        at
org.apache.ignite.internal.managers.communication.GridIoManager.access$1700(GridIoManager.java:106)
        at
org.apache.ignite.internal.managers.communication.GridIoManager$5.run(GridIoManager.java:829)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
Caused by: class org.apache.ignite.IgniteException: Failed to load cache:
AffiliateStore
        at
org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:908)
        at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5758)
        at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJobV2.localExecute(GridCacheAdapter.java:5802)
        at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$TopologyVersionAwareJob.execute(GridCacheAdapter.java:6473)
        at
org.apache.ignite.compute.ComputeJobAdapter.call(ComputeJobAdapter.java:132)
        at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2062)
        ... 14 more
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load
cache: AffiliateStore
        at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:535)
        at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:497)
        at
org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.localLoadCache(GridCacheProxyImpl.java:228)
        at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5753)
        ... 18 more
Caused by: javax.cache.integration.CacheLoaderException: Failed to load
cache: AffiliateStore
        at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:805)
        at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:512)
        ... 21 more
Caused by: javax.cache.integration.CacheLoaderException: Failed to execute
custom query for load cache
        at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1894)
        at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1837)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        ... 3 more
Caused by: java.sql.SQLException: java.io.EOFException: unexpected end of
stream, read 8 bytes from 10
        at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:533)
        at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1884)
        ... 5 more
Caused by: java.io.EOFException: unexpected end of stream, read 8 bytes from
10
        at
org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.readLength(ReadPacketFetcher.java:221)
        at
org.mariadb.jdbc.internal.packet.result.BinaryRowPacket.getRow(BinaryRowPacket.java:260)
        at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.readNextValue(MariaSelectResultSet.java:430)
        at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.nextStreamingValue(MariaSelectResultSet.java:373)
        at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:531)
        ... 6 more
[18:20:14] Topology snapshot [ver=5, servers=3, clients=0, CPUs=12,
heap=3.0GB]


===============================================================================
previous logs (something different)
logs from client side (Demo)
====================
>>> Loading entries from database.
[18:01:03] New version is available at ignite.apache.org: 1.7.0
[18:07:18,857][SEVERE][mgmt-#56%null%][GridTaskWorker] Failed to obtain
remote job result policy for result from ComputeTask.result(..) method (will
fail the whole task): GridJobResultImpl [job=C2V2 [c=LoadCacheJobV2
[keepBinary=false]], sib=GridJobSiblingImpl
[sesId=e31e0e30751-c1e1d396-12f1-4c03-8ddc-b56e1b5aa228,
jobId=041e0e30751-c1e1d396-12f1-4c03-8ddc-b56e1b5aa228,
nodeId=74e823b4-121e-4e2c-81d1-03f813697701, isJobDone=false],
jobCtx=GridJobContextImpl
[jobId=041e0e30751-c1e1d396-12f1-4c03-8ddc-b56e1b5aa228, timeoutObj=null,
attrs={}], node=TcpDiscoveryNode [id=74e823b4-121e-4e2c-81d1-03f813697701,
addrs=[0:0:0:0:0:0:0:1%lo, 10.20.2.0, 10.20.2.1, 127.0.0.1, 192.168.10.59,
192.168.122.1], sockAddrs=[/10.20.2.0:47500, /10.20.2.1:47500,
/192.168.122.1:47500, /0:0:0:0:0:0:0:1%lo:47500, /127.0.0.1:47500,
ecube59/192.168.10.59:47500], discPort=47500, order=3, intOrder=3,
lastExchangeTime=1473238853152, loc=false, ver=1.8.0#20160905-sha1:b640b8ed,
isClient=false], ex=class o.a.i.IgniteException: Failed to load cache:
AffiliateStore, hasRes=true, isCancelled=false, isOccupied=true]
class org.apache.ignite.IgniteException: Remote job threw user exception
(override or implement ComputeTask.result(..) method if you would like to
have automatic failover for this exception).
	at
org.apache.ignite.compute.ComputeTaskAdapter.result(ComputeTaskAdapter.java:101)
	at
org.apache.ignite.internal.processors.task.GridTaskWorker$5.apply(GridTaskWorker.java:1030)
	at
org.apache.ignite.internal.processors.task.GridTaskWorker$5.apply(GridTaskWorker.java:1023)
	at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6553)
	at
org.apache.ignite.internal.processors.task.GridTaskWorker.result(GridTaskWorker.java:1023)
	at
org.apache.ignite.internal.processors.task.GridTaskWorker.onResponse(GridTaskWorker.java:841)
	at
org.apache.ignite.internal.processors.task.GridTaskProcessor.processJobExecuteResponse(GridTaskProcessor.java:995)
	at
org.apache.ignite.internal.processors.task.GridTaskProcessor$JobMessageListener.onMessage(GridTaskProcessor.java:1220)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1238)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:866)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.access$1700(GridIoManager.java:106)
	at
org.apache.ignite.internal.managers.communication.GridIoManager$5.run(GridIoManager.java:829)
	at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: class org.apache.ignite.IgniteException: Failed to load cache:
AffiliateStore
	at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2065)
	at
org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:548)
	at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6521)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:542)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:471)
	at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1113)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1893)
	... 7 more
Caused by: class org.apache.ignite.IgniteException: Failed to load cache:
AffiliateStore
	at
org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:908)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5758)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJobV2.localExecute(GridCacheAdapter.java:5802)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$TopologyVersionAwareJob.execute(GridCacheAdapter.java:6473)
	at
org.apache.ignite.compute.ComputeJobAdapter.call(ComputeJobAdapter.java:132)
	at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2062)
	... 14 more
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load
cache: AffiliateStore
	at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:535)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:497)
	at
org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.localLoadCache(GridCacheProxyImpl.java:228)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5753)
	... 18 more
Caused by: javax.cache.integration.CacheLoaderException: Failed to load
cache: AffiliateStore
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:805)
	at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:512)
	... 21 more
Caused by: javax.cache.integration.CacheLoaderException: Failed to execute
custom query for load cache
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1894)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1837)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	... 3 more
Caused by: java.sql.SQLException: java.io.EOFException: unexpected end of
stream, read 5 bytes from 8
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:533)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1884)
	... 5 more
Caused by: java.io.EOFException: unexpected end of stream, read 5 bytes from
8
	at
org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.readLength(ReadPacketFetcher.java:221)
	at
org.mariadb.jdbc.internal.packet.result.BinaryRowPacket.getRow(BinaryRowPacket.java:260)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.readNextValue(MariaSelectResultSet.java:430)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.nextStreamingValue(MariaSelectResultSet.java:373)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:531)
	... 6 more
[18:07:19] (err) Failed to execute compound future reducer:
GridCompoundFuture [rdc=null, initFlag=1, lsnrCalls=0, done=false,
cancelled=false, err=null, futs=[true]]class
org.apache.ignite.IgniteCheckedException: Failed to load cache:
AffiliateStore
	at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:535)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:497)
	at
org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.localLoadCache(GridCacheProxyImpl.java:228)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5753)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJobV2.localExecute(GridCacheAdapter.java:5802)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$TopologyVersionAwareJob.execute(GridCacheAdapter.java:6473)
	at
org.apache.ignite.compute.ComputeJobAdapter.call(ComputeJobAdapter.java:132)
	at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2062)
	at
org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:548)
	at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6521)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:542)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:471)
	at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1113)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1893)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1238)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:866)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.access$1700(GridIoManager.java:106)
	at
org.apache.ignite.internal.managers.communication.GridIoManager$5.run(GridIoManager.java:829)
	at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: javax.cache.integration.CacheLoaderException: Failed to load
cache: AffiliateStore
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:805)
	at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:512)
	... 21 more
Caused by: javax.cache.integration.CacheLoaderException: Failed to execute
custom query for load cache
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1894)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1837)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	... 3 more
Caused by: java.sql.SQLException: java.io.EOFException: unexpected end of
stream, read 5 bytes from 8
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:533)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1884)
	... 5 more
Caused by: java.io.EOFException: unexpected end of stream, read 5 bytes from
8
	at
org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.readLength(ReadPacketFetcher.java:221)
	at
org.mariadb.jdbc.internal.packet.result.BinaryRowPacket.getRow(BinaryRowPacket.java:260)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.readNextValue(MariaSelectResultSet.java:430)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.nextStreamingValue(MariaSelectResultSet.java:373)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:531)
	... 6 more
[18:07:29] Ignite node stopped OK [uptime=00:06:35:663]
Exception in thread "main" javax.cache.integration.CacheLoaderException:
Failed to load cache: AffiliateStore
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:805)
	at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:512)
	at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:497)
	at
org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.localLoadCache(GridCacheProxyImpl.java:228)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5753)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJobV2.localExecute(GridCacheAdapter.java:5802)
	at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$TopologyVersionAwareJob.execute(GridCacheAdapter.java:6473)
	at
org.apache.ignite.compute.ComputeJobAdapter.call(ComputeJobAdapter.java:132)
	at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2062)
	at
org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:548)
	at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6521)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:542)
	at
org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:471)
	at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1113)
	at
org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1893)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1238)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:866)
	at
org.apache.ignite.internal.managers.communication.GridIoManager.access$1700(GridIoManager.java:106)
	at
org.apache.ignite.internal.managers.communication.GridIoManager$5.run(GridIoManager.java:829)
	at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: javax.cache.integration.CacheLoaderException: Failed to execute
custom query for load cache
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1894)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1837)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	... 3 more
Caused by: java.sql.SQLException: java.io.EOFException: unexpected end of
stream, read 5 bytes from 8
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:533)
	at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1884)
	... 5 more
Caused by: java.io.EOFException: unexpected end of stream, read 5 bytes from
8
	at
org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.readLength(ReadPacketFetcher.java:221)
	at
org.mariadb.jdbc.internal.packet.result.BinaryRowPacket.getRow(BinaryRowPacket.java:260)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.readNextValue(MariaSelectResultSet.java:430)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.nextStreamingValue(MariaSelectResultSet.java:373)
	at
org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.next(MariaSelectResultSet.java:531)
	... 6 more


logs from node-1 side
================
[18:07:29] Topology snapshot [ver=5, servers=3, clients=0, CPUs=12,
heap=3.0GB]
[18:08:31,392][SEVERE][mgmt-#67%null%][GridJobWorker] Failed to execute job
[jobId=141e0e30751-c1e1d396-12f1-4c03-8ddc-b56e1b5aa228,
ses=GridJobSessionImpl [ses=GridTaskSessionImpl
[taskName=o.a.i.i.processors.cache.GridCacheAdapter$LoadCacheJobV2,
dep=GridDeployment [ts=1473238766412, depMode=SHARED,
clsLdr=sun.misc.Launcher$AppClassLoader@18b4aac2,
clsLdrId=0fe8fd30751-f918f8ec-faa1-456f-aa8b-feebbe7e3224, userVer=0,
loc=true,
sampleClsName=o.a.i.i.processors.cache.distributed.dht.preloader.GridDhtPartitionFullMap,
pendingUndeploy=false, undeployed=false, usage=1],
taskClsName=o.a.i.i.processors.cache.GridCacheAdapter$LoadCacheJobV2,
sesId=e31e0e30751-c1e1d396-12f1-4c03-8ddc-b56e1b5aa228,
startTime=1473238853906, endTime=9223372036854775807,
taskNodeId=c1e1d396-12f1-4c03-8ddc-b56e1b5aa228,
clsLdr=sun.misc.Launcher$AppClassLoader@18b4aac2, closed=false, cpSpi=null,
failSpi=null, loadSpi=null, usage=1, fullSup=false,
subjId=c1e1d396-12f1-4c03-8ddc-b56e1b5aa228, mapFut=IgniteFuture
[orig=GridFutureAdapter [resFlag=0, res=null, startTime=1473238854150,
endTime=0, ignoreInterrupts=false, state=INIT]]],
jobId=141e0e30751-c1e1d396-12f1-4c03-8ddc-b56e1b5aa228]]
class org.apache.ignite.IgniteException: Failed to load cache:
AffiliateStore
        at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2065)
        at
org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:548)
        at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6521)
        at
org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:542)
        at
org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:471)
        at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
        at
org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1113)
        at
org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1893)
        at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1238)
        at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:866)
        at
org.apache.ignite.internal.managers.communication.GridIoManager.access$1700(GridIoManager.java:106)
        at
org.apache.ignite.internal.managers.communication.GridIoManager$5.run(GridIoManager.java:829)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
Caused by: class org.apache.ignite.IgniteException: Failed to load cache:
AffiliateStore
        at
org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:908)
        at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5758)
        at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJobV2.localExecute(GridCacheAdapter.java:5802)
        at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$TopologyVersionAwareJob.execute(GridCacheAdapter.java:6473)
        at
org.apache.ignite.compute.ComputeJobAdapter.call(ComputeJobAdapter.java:132)
        at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.execute(GridClosureProcessor.java:2062)
        ... 14 more
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load
cache: AffiliateStore
        at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:535)
        at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:497)
        at
org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.localLoadCache(GridCacheProxyImpl.java:228)
        at
org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5753)
        ... 18 more
Caused by: javax.cache.integration.CacheLoaderException: Failed to load
cache: AffiliateStore
        at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:805)
        at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:512)
        ... 21 more
Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded
        at java.util.jar.Attributes.read(Attributes.java:394)
        at java.util.jar.Manifest.read(Manifest.java:199)
        at java.util.jar.Manifest.<init>(Manifest.java:69)
        at java.util.jar.JarFile.getManifestFromReference(JarFile.java:199)
        at java.util.jar.JarFile.getManifest(JarFile.java:180)
        at
sun.misc.URLClassPath$JarLoader$2.getManifest(URLClassPath.java:944)
        at java.net.URLClassLoader.defineClass(URLClassLoader.java:450)
        at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        at
org.apache.ignite.internal.processors.cache.GridCacheMapEntry.obsoleteVersionExtras(GridCacheMapEntry.java:4549)
        at
org.apache.ignite.internal.processors.cache.GridCacheMapEntry.markObsolete0(GridCacheMapEntry.java:2957)
        at
org.apache.ignite.internal.processors.cache.GridCacheMapEntry.markObsoleteIfEmpty(GridCacheMapEntry.java:2881)
        at
org.apache.ignite.internal.processors.cache.GridCacheEvictionManager.touch(GridCacheEvictionManager.java:789)
        at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.loadEntry(GridDhtCacheAdapter.java:567)
        at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.access$300(GridDhtCacheAdapter.java:94)
        at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter$4.apply(GridDhtCacheAdapter.java:501)
        at
org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter$4.apply(GridDhtCacheAdapter.java:497)
        at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter$3.apply(GridCacheStoreManagerAdapter.java:528)
        at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1888)
        at
org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:1837)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        ... 3 more




--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/CacheJdbcPojoStore-with-MariaDB-tp7538p7576.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.