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.
