You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by seyeony <se...@gmail.com> on 2016/09/06 08:41:27 UTC
CacheJdbcPojoStore with MariaDB
Hi,
I finally succeed to run the demo program from examples with MariaDB.
I thank you very much for your valuable comments.
I changed the Person object to bigger object AffiliateStore for the real
test.
I tested about 5.8 millions of data stored in my MariaDB.
After a while, I got the following messages:
I don't know what kind of error it is and what I did wrong.
Please could someone advise me on this error?
When I tested with about 20,000 records of data, there was no problem...
Thank you.
- sy
====================================
>>> Loading entries from database.
[17:24:08] Topology snapshot [ver=5, servers=2, clients=1, CPUs=8,
heap=10.0GB]
[17:24:09,133][SEVERE][pub-#54%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=213a59ef651-ee90c020-3934-467b-8020-e98b0eb3ae65,
jobId=413a59ef651-ee90c020-3934-467b-8020-e98b0eb3ae65,
nodeId=2b62514e-dbdf-4aaf-890e-e362c2528e5d, isJobDone=false],
jobCtx=GridJobContextImpl
[jobId=413a59ef651-ee90c020-3934-467b-8020-e98b0eb3ae65, timeoutObj=null,
attrs={}], node=TcpDiscoveryNode [id=2b62514e-dbdf-4aaf-890e-e362c2528e5d,
addrs=[0:0:0:0:0:0:0:1%lo, 10.20.53.0, 10.20.53.1, 127.0.0.1, 192.168.10.58,
192.168.122.1], sockAddrs=[/10.20.53.0:47500, /10.20.53.1:47500,
/192.168.122.1:47500, /0:0:0:0:0:0:0:1%lo:47500, /127.0.0.1:47500,
ecube58/192.168.10.58:47500], discPort=47500, order=2, intOrder=2,
lastExchangeTime=1473150035952, loc=false, ver=1.7.0#20160802-sha1:383273e3,
isClient=false], ex=class o.a.i.cluster.ClusterTopologyException: Node has
left grid: 2b62514e-dbdf-4aaf-890e-e362c2528e5d, hasRes=true,
isCancelled=false, isOccupied=true]
class org.apache.ignite.cluster.ClusterTopologyException: Node has left
grid: 2b62514e-dbdf-4aaf-890e-e362c2528e5d
at
org.apache.ignite.internal.processors.task.GridTaskWorker.onNodeLeft(GridTaskWorker.java:1356)
at
org.apache.ignite.internal.processors.task.GridTaskProcessor$TaskDiscoveryListener$1.run(GridTaskProcessor.java:1247)
at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6577)
at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$1.body(GridClosureProcessor.java:781)
at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
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)
[17:24:09] (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: Node has left grid:
2b62514e-dbdf-4aaf-890e-e362c2528e5d
at org.apache.ignite.internal.util.IgniteUtils.cast(IgniteUtils.java:7142)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.get0(GridFutureAdapter.java:168)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.get(GridFutureAdapter.java:117)
at
org.apache.ignite.internal.util.future.GridCompoundFuture.apply(GridCompoundFuture.java:88)
at
org.apache.ignite.internal.util.future.GridCompoundFuture.apply(GridCompoundFuture.java:41)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:263)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListeners(GridFutureAdapter.java:251)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:381)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:347)
at
org.apache.ignite.internal.processors.task.GridTaskWorker.finishTask(GridTaskWorker.java:1475)
at
org.apache.ignite.internal.processors.task.GridTaskWorker.finishTask(GridTaskWorker.java:1443)
at
org.apache.ignite.internal.processors.task.GridTaskWorker$4.apply(GridTaskWorker.java:988)
at
org.apache.ignite.internal.processors.task.GridTaskWorker$4.apply(GridTaskWorker.java:939)
at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6553)
at
org.apache.ignite.internal.processors.task.GridTaskWorker.result(GridTaskWorker.java:939)
at
org.apache.ignite.internal.processors.task.GridTaskWorker.onResponse(GridTaskWorker.java:810)
at
org.apache.ignite.internal.processors.task.GridTaskWorker.onNodeLeft(GridTaskWorker.java:1375)
at
org.apache.ignite.internal.processors.task.GridTaskProcessor$TaskDiscoveryListener$1.run(GridTaskProcessor.java:1247)
at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6577)
at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$1.body(GridClosureProcessor.java:781)
at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
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.cluster.ClusterTopologyException: Node
has left grid: 2b62514e-dbdf-4aaf-890e-e362c2528e5d
at
org.apache.ignite.internal.processors.task.GridTaskWorker.onNodeLeft(GridTaskWorker.java:1356)
... 7 more
[17:24:09] Ignite node stopped OK [uptime=00:03:32:980]
Exception in thread "main" javax.cache.CacheException: class
org.apache.ignite.IgniteCheckedException: Node has left grid:
2b62514e-dbdf-4aaf-890e-e362c2528e5d
at
org.apache.ignite.internal.processors.cache.GridCacheUtils.convertToCacheException(GridCacheUtils.java:1502)
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.cacheException(IgniteCacheProxy.java:2021)
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.loadCache(IgniteCacheProxy.java:393)
at demo.Demo.preload(Demo.java:87)
at demo.Demo.main(Demo.java:64)
Caused by: class org.apache.ignite.IgniteCheckedException: Node has left
grid: 2b62514e-dbdf-4aaf-890e-e362c2528e5d
at org.apache.ignite.internal.util.IgniteUtils.cast(IgniteUtils.java:7142)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.get0(GridFutureAdapter.java:168)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.get(GridFutureAdapter.java:117)
at
org.apache.ignite.internal.util.future.GridCompoundFuture.apply(GridCompoundFuture.java:88)
at
org.apache.ignite.internal.util.future.GridCompoundFuture.apply(GridCompoundFuture.java:41)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:263)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListeners(GridFutureAdapter.java:251)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:381)
at
org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:347)
at
org.apache.ignite.internal.processors.task.GridTaskWorker.finishTask(GridTaskWorker.java:1475)
at
org.apache.ignite.internal.processors.task.GridTaskWorker.finishTask(GridTaskWorker.java:1443)
at
org.apache.ignite.internal.processors.task.GridTaskWorker$4.apply(GridTaskWorker.java:988)
at
org.apache.ignite.internal.processors.task.GridTaskWorker$4.apply(GridTaskWorker.java:939)
at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6553)
at
org.apache.ignite.internal.processors.task.GridTaskWorker.result(GridTaskWorker.java:939)
at
org.apache.ignite.internal.processors.task.GridTaskWorker.onResponse(GridTaskWorker.java:810)
at
org.apache.ignite.internal.processors.task.GridTaskWorker.onNodeLeft(GridTaskWorker.java:1375)
at
org.apache.ignite.internal.processors.task.GridTaskProcessor$TaskDiscoveryListener$1.run(GridTaskProcessor.java:1247)
at
org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6577)
at
org.apache.ignite.internal.processors.closure.GridClosureProcessor$1.body(GridClosureProcessor.java:781)
at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
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.cluster.ClusterTopologyException: Node
has left grid: 2b62514e-dbdf-4aaf-890e-e362c2528e5d
at
org.apache.ignite.internal.processors.task.GridTaskWorker.onNodeLeft(GridTaskWorker.java:1356)
... 7 more
====================================
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/CacheJdbcPojoStore-with-MariaDB-tp7538.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: CacheJdbcPojoStore with MariaDB
Posted by 윤세연 <se...@obzen.com>.
Hi Alexey,
Thank you very much for your help.
Regards,
SeYeon Yoon
2016-09-08 19:43 GMT+09:00 Alexey Kuznetsov <ak...@gridgain.com>:
> Hi, @seyeony!
>
> In general Ignite need some heap for temp objects when loading entries to
> cache.
> I would recommend to use such very raw approximation: 200 bytes for entry,
> so max_heap = 200 * max_entries_numbers + 512MB (for Ignite system needs).
>
> But to have a clear answer - take a heap dump and find what takes memory.
>
> --
> Alexey Kuznetsov
> GridGain Systems
> www.gridgain.com
>
Re: CacheJdbcPojoStore with MariaDB
Posted by Alexey Kuznetsov <ak...@gridgain.com>.
Hi, @seyeony!
In general Ignite need some heap for temp objects when loading entries to
cache.
I would recommend to use such very raw approximation: 200 bytes for entry,
so max_heap = 200 * max_entries_numbers + 512MB (for Ignite system needs).
But to have a clear answer - take a heap dump and find what takes memory.
--
Alexey Kuznetsov
GridGain Systems
www.gridgain.com
Re: CacheJdbcPojoStore with MariaDB
Posted by seyeony <se...@gmail.com>.
Hi Alexey,
I gave more heap and I was able to load the whole dataset in cache.
I have another questions.
Eventhough I used OFFHEAP_TIERED in the configuration, why do I need more
heap?
Should I find the right heap size by trial and error or is there any
calculation method?
Should I give same heap size for both node and clients?
Or which of node btw server and client mode does need more heap size?
- sy
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/CacheJdbcPojoStore-with-MariaDB-tp7538p7604.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: CacheJdbcPojoStore with MariaDB
Posted by Alexey Kuznetsov <ak...@gridgain.com>.
Hi, @seyeony!
I see that you are giving 1Gb of heap to node.
Could you try with >=2Gb and try once more.
--
Alexey Kuznetsov
GridGain Systems
www.gridgain.com
Re: CacheJdbcPojoStore with MariaDB
Posted by seyeony <se...@gmail.com>.
Hi Alexey,
After a while, i got some logs more as follows:
logs from node-1
===========
Exception in thread "mgmt-#69%null%" java.lang.OutOfMemoryError: GC overhead
limit exceeded
logs from node-2
===========
[18:22:11,333][SEVERE][mgmt-#67%null%][GridJobWorker] Failed to execute job
[jobId=0414ce30751-1fcbcc36-e000-4980-8e0c-8c53dbfb4e1e,
ses=GridJobSessionImpl [ses=GridTaskSessionImpl
[taskName=o.a.i.i.processors.cache.GridCacheAdapter$LoadCacheJobV2,
dep=GridDeployment [ts=1473239590469, depMode=SHARED,
clsLdr=sun.misc.Launcher$AppClassLoader@18b4aac2,
clsLdrId=0f12ce30751-15260fb6-a946-4f81-928f-a77e1128e24d, 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=1473239599579,
endTime=0, ignoreInterrupts=false, state=INIT]]],
jobId=0414ce30751-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 3 bytes from 12
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 3 bytes from
12
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
- sy
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/CacheJdbcPojoStore-with-MariaDB-tp7538p7577.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: CacheJdbcPojoStore with MariaDB
Posted by seyeony <se...@gmail.com>.
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.
Re: CacheJdbcPojoStore with MariaDB
Posted by Alexey Kuznetsov <ak...@gridgain.com>.
Hi, @seyeony!
I see OutOfMemoryError in your stack trace.
How many objects are you trying to load in cache? Maybe you should switch
to OFFHEAP_TIERED mode?
See: https://apacheignite.readme.io/docs/off-heap-memory#offheap_tiered
Also could you attach your config, logs from all nodes and describe how you
are starting grid? How many heap your give to nodes?
How many object you were able to load without OOME?
On Wed, Sep 7, 2016 at 11:50 AM, seyeony <se...@gmail.com> wrote:
> Hi Alexey,
> Thank you for your advices.
> I tried to test with the latest night build as you guided. Also I replaced
> the BasicJdbcDialect with MySQLDialect. It looked much better.
> However when I tested with large datasets, I got the message as follows.
> I guess I need more memory.
> By the way, what means the 'networkTimeout' ?
> Is it OK if I set bigger value for the networkTimeout ?
>
> - sy
>
> Messages I got:
> == the client side ==
> >>> Loading entries from database.
> [13:02:19] New version is available at ignite.apache.org: 1.7.0
> [13:09:15,181][SEVERE][tcp-client-disco-reconnector-#5%
> null%][TcpDiscoverySpi]
> Failed to reconnect to cluster (consider increasing 'networkTimeout'
> configuration property) [networkTimeout=5000]
> == the server side ==
> [13:09:36,831][SEVERE][tcp-disco-sock-reader-#7%null%][TcpDiscoverySpi]
> Runtime error caught during grid runnable execution: Socket reader [id=107,
> name=tcp-disco-sock-reader-#7%null%, nodeId=null]
> java.lang.OutOfMemoryError: Java heap space
> at java.io.BufferedInputStream.<init>(BufferedInputStream.
> java:203)
> at
> org.apache.ignite.spi.discovery.tcp.ServerImpl$
> SocketReader.body(ServerImpl.java:5253)
> at
> org.apache.ignite.spi.IgniteSpiThread.run(IgniteSpiThread.java:62)
> Exception in thread "tcp-disco-sock-reader-#7%null%"
> java.lang.OutOfMemoryError: Java heap space
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/CacheJdbcPojoStore-with-MariaDB-tp7538p7573.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Alexey Kuznetsov
GridGain Systems
www.gridgain.com
Re: CacheJdbcPojoStore with MariaDB
Posted by seyeony <se...@gmail.com>.
Hi Alexey,
Thank you for your advices.
I tried to test with the latest night build as you guided. Also I replaced
the BasicJdbcDialect with MySQLDialect. It looked much better.
However when I tested with large datasets, I got the message as follows.
I guess I need more memory.
By the way, what means the 'networkTimeout' ?
Is it OK if I set bigger value for the networkTimeout ?
- sy
Messages I got:
== the client side ==
>>> Loading entries from database.
[13:02:19] New version is available at ignite.apache.org: 1.7.0
[13:09:15,181][SEVERE][tcp-client-disco-reconnector-#5%null%][TcpDiscoverySpi]
Failed to reconnect to cluster (consider increasing 'networkTimeout'
configuration property) [networkTimeout=5000]
== the server side ==
[13:09:36,831][SEVERE][tcp-disco-sock-reader-#7%null%][TcpDiscoverySpi]
Runtime error caught during grid runnable execution: Socket reader [id=107,
name=tcp-disco-sock-reader-#7%null%, nodeId=null]
java.lang.OutOfMemoryError: Java heap space
at java.io.BufferedInputStream.<init>(BufferedInputStream.java:203)
at
org.apache.ignite.spi.discovery.tcp.ServerImpl$SocketReader.body(ServerImpl.java:5253)
at
org.apache.ignite.spi.IgniteSpiThread.run(IgniteSpiThread.java:62)
Exception in thread "tcp-disco-sock-reader-#7%null%"
java.lang.OutOfMemoryError: Java heap space
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/CacheJdbcPojoStore-with-MariaDB-tp7538p7573.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: CacheJdbcPojoStore with MariaDB
Posted by Alexey Kuznetsov <ak...@gridgain.com>.
Hi, @seyeony!
There was a bug with MySQL dialect and large datasets fixed recently in
master.
By default MySQL JDBC driver load all rows of result set to memory and that
may result in OOME and node left the grid.
Or try to give more memory to node (if it possible).
Could you try with latest nightly build?
https://ignite.apache.org/community/contribute.html#nightly-builds
See org.apache.ignite.cache.store.jdbc.dialect.MySQLDialect#getFetchSize()
method.
You may need to implement your own dialect for MariaDB or try to use
MySQLDialect.
On Tue, Sep 6, 2016 at 3:41 PM, seyeony <se...@gmail.com> wrote:
> Hi,
> I finally succeed to run the demo program from examples with MariaDB.
> I thank you very much for your valuable comments.
> I changed the Person object to bigger object AffiliateStore for the real
> test.
> I tested about 5.8 millions of data stored in my MariaDB.
> After a while, I got the following messages:
> I don't know what kind of error it is and what I did wrong.
> Please could someone advise me on this error?
> When I tested with about 20,000 records of data, there was no problem...
> Thank you.
>
> - sy
> ====================================
> >>> Loading entries from database.
> [17:24:08] Topology snapshot [ver=5, servers=2, clients=1, CPUs=8,
> heap=10.0GB]
> [17:24:09,133][SEVERE][pub-#54%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=213a59ef651-ee90c020-3934-467b-8020-e98b0eb3ae65,
> jobId=413a59ef651-ee90c020-3934-467b-8020-e98b0eb3ae65,
> nodeId=2b62514e-dbdf-4aaf-890e-e362c2528e5d, isJobDone=false],
> jobCtx=GridJobContextImpl
> [jobId=413a59ef651-ee90c020-3934-467b-8020-e98b0eb3ae65, timeoutObj=null,
> attrs={}], node=TcpDiscoveryNode [id=2b62514e-dbdf-4aaf-890e-e362c2528e5d,
> addrs=[0:0:0:0:0:0:0:1%lo, 10.20.53.0, 10.20.53.1, 127.0.0.1,
> 192.168.10.58,
> 192.168.122.1], sockAddrs=[/10.20.53.0:47500, /10.20.53.1:47500,
> /192.168.122.1:47500, /0:0:0:0:0:0:0:1%lo:47500, /127.0.0.1:47500,
> ecube58/192.168.10.58:47500], discPort=47500, order=2, intOrder=2,
> lastExchangeTime=1473150035952, loc=false, ver=1.7.0#20160802-sha1:
> 383273e3,
> isClient=false], ex=class o.a.i.cluster.ClusterTopologyException: Node has
> left grid: 2b62514e-dbdf-4aaf-890e-e362c2528e5d, hasRes=true,
> isCancelled=false, isOccupied=true]
> class org.apache.ignite.cluster.ClusterTopologyException: Node has left
> grid: 2b62514e-dbdf-4aaf-890e-e362c2528e5d
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.onNodeLeft(
> GridTaskWorker.java:1356)
> at
> org.apache.ignite.internal.processors.task.GridTaskProcessor$
> TaskDiscoveryListener$1.run(GridTaskProcessor.java:1247)
> at
> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.
> java:6577)
> at
> org.apache.ignite.internal.processors.closure.GridClosureProcessor$1.body(
> GridClosureProcessor.java:781)
> at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
> 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)
> [17:24:09] (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: Node has left grid:
> 2b62514e-dbdf-4aaf-890e-e362c2528e5d
> at org.apache.ignite.internal.util.IgniteUtils.cast(
> IgniteUtils.java:7142)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.
> get0(GridFutureAdapter.java:168)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.
> get(GridFutureAdapter.java:117)
> at
> org.apache.ignite.internal.util.future.GridCompoundFuture.apply(
> GridCompoundFuture.java:88)
> at
> org.apache.ignite.internal.util.future.GridCompoundFuture.apply(
> GridCompoundFuture.java:41)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(
> GridFutureAdapter.java:263)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListeners(
> GridFutureAdapter.java:251)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.
> onDone(GridFutureAdapter.java:381)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.
> onDone(GridFutureAdapter.java:347)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.finishTask(
> GridTaskWorker.java:1475)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.finishTask(
> GridTaskWorker.java:1443)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker$4.apply(
> GridTaskWorker.java:988)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker$4.apply(
> GridTaskWorker.java:939)
> at
> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.
> java:6553)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.result(
> GridTaskWorker.java:939)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.onResponse(
> GridTaskWorker.java:810)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.onNodeLeft(
> GridTaskWorker.java:1375)
> at
> org.apache.ignite.internal.processors.task.GridTaskProcessor$
> TaskDiscoveryListener$1.run(GridTaskProcessor.java:1247)
> at
> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.
> java:6577)
> at
> org.apache.ignite.internal.processors.closure.GridClosureProcessor$1.body(
> GridClosureProcessor.java:781)
> at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
> 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.cluster.ClusterTopologyException: Node
> has left grid: 2b62514e-dbdf-4aaf-890e-e362c2528e5d
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.onNodeLeft(
> GridTaskWorker.java:1356)
> ... 7 more
> [17:24:09] Ignite node stopped OK [uptime=00:03:32:980]
> Exception in thread "main" javax.cache.CacheException: class
> org.apache.ignite.IgniteCheckedException: Node has left grid:
> 2b62514e-dbdf-4aaf-890e-e362c2528e5d
> at
> org.apache.ignite.internal.processors.cache.GridCacheUtils.
> convertToCacheException(GridCacheUtils.java:1502)
> at
> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.
> cacheException(IgniteCacheProxy.java:2021)
> at
> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.loadCache(
> IgniteCacheProxy.java:393)
> at demo.Demo.preload(Demo.java:87)
> at demo.Demo.main(Demo.java:64)
> Caused by: class org.apache.ignite.IgniteCheckedException: Node has left
> grid: 2b62514e-dbdf-4aaf-890e-e362c2528e5d
> at org.apache.ignite.internal.util.IgniteUtils.cast(
> IgniteUtils.java:7142)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.
> get0(GridFutureAdapter.java:168)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.
> get(GridFutureAdapter.java:117)
> at
> org.apache.ignite.internal.util.future.GridCompoundFuture.apply(
> GridCompoundFuture.java:88)
> at
> org.apache.ignite.internal.util.future.GridCompoundFuture.apply(
> GridCompoundFuture.java:41)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(
> GridFutureAdapter.java:263)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListeners(
> GridFutureAdapter.java:251)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.
> onDone(GridFutureAdapter.java:381)
> at
> org.apache.ignite.internal.util.future.GridFutureAdapter.
> onDone(GridFutureAdapter.java:347)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.finishTask(
> GridTaskWorker.java:1475)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.finishTask(
> GridTaskWorker.java:1443)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker$4.apply(
> GridTaskWorker.java:988)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker$4.apply(
> GridTaskWorker.java:939)
> at
> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.
> java:6553)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.result(
> GridTaskWorker.java:939)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.onResponse(
> GridTaskWorker.java:810)
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.onNodeLeft(
> GridTaskWorker.java:1375)
> at
> org.apache.ignite.internal.processors.task.GridTaskProcessor$
> TaskDiscoveryListener$1.run(GridTaskProcessor.java:1247)
> at
> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.
> java:6577)
> at
> org.apache.ignite.internal.processors.closure.GridClosureProcessor$1.body(
> GridClosureProcessor.java:781)
> at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
> 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.cluster.ClusterTopologyException: Node
> has left grid: 2b62514e-dbdf-4aaf-890e-e362c2528e5d
> at
> org.apache.ignite.internal.processors.task.GridTaskWorker.onNodeLeft(
> GridTaskWorker.java:1356)
> ... 7 more
> ====================================
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/CacheJdbcPojoStore-with-MariaDB-tp7538.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Alexey Kuznetsov
GridGain Systems
www.gridgain.com