I created a cluster and imported a postgres database to the cluster. I created two ignite instances using that cluster config (from the maven project made available via download though the web-console). I even started a client instance (by running the ClientNodeCodeStartup file).
The server as well as client reported their counts correctly. Next, I ran the LoadCaches file. This threw an error. My assumption was this was supposed to load the caches with data. I want to understand why this file failed. Pasting the console output below between begin and end pastes. ---BEGIN_PASTE--- "C:\Program Files\Java\jdk1.8.0_181\bin\java.exe" "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2018.2.6\lib\idea_rt.jar=62690:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2018.2.6\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_181\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_181\jre\lib\rt.jar;D:\code\java-intellij\FamilyBankCluster3\target\classes;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-core\2.7.0\ignite-core-2.7.0.jar;C:\Users\arun_jayapal\.m2\repository\javax\cache\cache-api\1.0.0\cache-api-1.0.0.jar;C:\Users\arun_jayapal\.m2\repository\org\jetbrains\annotations\13.0\annotations-13.0.jar;C:\Users\arun_jayapal\.m2\repository\org\gridgain\ignite-shmem\1.0.0\ignite-shmem-1.0.0.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-spring\2.7.0\ignite-spring-2.7.0.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-core\4.3.18.RELEASE\spring-core-4.3.18.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-aop\4.3.18.RELEASE\spring-aop-4.3.18.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-beans\4.3.18.RELEASE\spring-beans-4.3.18.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-context\4.3.18.RELEASE\spring-context-4.3.18.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-expression\4.3.18.RELEASE\spring-expression-4.3.18.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-tx\4.3.18.RELEASE\spring-tx-4.3.18.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-jdbc\4.3.18.RELEASE\spring-jdbc-4.3.18.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\commons-logging\commons-logging\1.1.1\commons-logging-1.1.1.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-indexing\2.7.0\ignite-indexing-2.7.0.jar;C:\Users\arun_jayapal\.m2\repository\commons-codec\commons-codec\1.11\commons-codec-1.11.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-core\7.4.0\lucene-core-7.4.0.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-analyzers-common\7.4.0\lucene-analyzers-common-7.4.0.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-queryparser\7.4.0\lucene-queryparser-7.4.0.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-queries\7.4.0\lucene-queries-7.4.0.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-sandbox\7.4.0\lucene-sandbox-7.4.0.jar;C:\Users\arun_jayapal\.m2\repository\com\h2database\h2\1.4.197\h2-1.4.197.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-rest-http\2.7.0\ignite-rest-http-2.7.0.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\tomcat\tomcat-servlet-api\9.0.10\tomcat-servlet-api-9.0.10.jar;C:\Users\arun_jayapal\.m2\repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-continuation\9.4.11.v20180605\jetty-continuation-9.4.11.v20180605.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-http\9.4.11.v20180605\jetty-http-9.4.11.v20180605.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-io\9.4.11.v20180605\jetty-io-9.4.11.v20180605.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-server\9.4.11.v20180605\jetty-server-9.4.11.v20180605.jar;C:\Users\arun_jayapal\.m2\repository\javax\servlet\javax.servlet-api\3.1.0\javax.servlet-api-3.1.0.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-util\9.4.11.v20180605\jetty-util-9.4.11.v20180605.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-xml\9.4.11.v20180605\jetty-xml-9.4.11.v20180605.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.9.6\jackson-core-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.9.6\jackson-annotations-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.9.6\jackson-databind-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\org\slf4j\slf4j-api\1.7.7\slf4j-api-1.7.7.jar;C:\Users\arun_jayapal\.m2\repository\org\slf4j\slf4j-log4j12\1.7.7\slf4j-log4j12-1.7.7.jar;C:\Users\arun_jayapal\.m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\Users\arun_jayapal\.m2\repository\org\postgresql\postgresql\9.4.1212.jre7\postgresql-9.4.1212.jre7.jar" load.LoadCaches Jan 23, 2019 11:32:15 AM java.util.logging.LogManager$RootLogger log WARNING: Failed to resolve default logging config file: config/java.util.logging.properties [11:32:15] __________ ________________ [11:32:15] / _/ ___/ |/ / _/_ __/ __/ [11:32:15] _/ // (7 7 // / / / / _/ [11:32:15] /___/\___/_/|_/___/ /_/ /___/ [11:32:15] [11:32:15] ver. 2.7.0#20181201-sha1:256ae401 [11:32:15] 2018 Copyright(C) Apache Software Foundation [11:32:15] [11:32:15] Ignite documentation: http://ignite.apache.org [11:32:15] [11:32:15] Quiet mode. [11:32:15] ^-- Logging by 'JavaLogger [quiet=true, config=null]' [11:32:15] ^-- To see **FULL** console log here add -DIGNITE_QUIET=false or "-v" to ignite.{sh|bat} [11:32:15] [11:32:15] OS: Windows 8.1 6.3 amd64 [11:32:15] VM information: Java(TM) SE Runtime Environment 1.8.0_181-b13 Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.181-b13 [11:32:15] Please set system property '-Djava.net.preferIPv4Stack=true' to avoid possible problems in mixed environments. [11:32:15] Initial heap size is 128MB (should be no less than 512MB, use -Xms512m -Xmx512m). [11:32:15] Configured plugins: [11:32:15] ^-- None [11:32:15] [11:32:15] Configured failure handler: [hnd=StopNodeOrHaltFailureHandler [tryStop=false, timeout=0, super=AbstractFailureHandler [ignoredFailureTypes=[SYSTEM_WORKER_BLOCKED]]]] [11:32:18] Message queue limit is set to 0 which may lead to potential OOMEs when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to message queues growth on sender and receiver sides. [11:32:18] Security status [authentication=off, tls/ssl=off] [11:32:19] REST protocols do not start on client node. To start the protocols on client node set '-DIGNITE_REST_START_ON_CLIENT=true' system property. Jan 23, 2019 11:32:31 AM org.apache.ignite.logger.java.JavaLogger error SEVERE: Blocked system-critical thread has been detected. This can lead to cluster-wide undefined behaviour [threadName=tcp-client-disco-msg-worker, blockedFor=11s] Jan 23, 2019 11:32:31 AM java.util.logging.LogManager$RootLogger log SEVERE: Critical system error detected. Will be handled accordingly to configured handler [hnd=StopNodeOrHaltFailureHandler [tryStop=false, timeout=0, super=AbstractFailureHandler [ignoredFailureTypes=[SYSTEM_WORKER_BLOCKED]]], failureCtx=FailureContext [type=SYSTEM_WORKER_BLOCKED, err=class o.a.i.IgniteException: GridWorker [name=tcp-client-disco-msg-worker, igniteInstanceName=FamilybankCluster, finished=false, heartbeatTs=1548223340068]]] class org.apache.ignite.IgniteException: GridWorker [name=tcp-client-disco-msg-worker, igniteInstanceName=FamilybankCluster, finished=false, heartbeatTs=1548223340068] at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance$2.apply(IgnitionEx.java:1831) at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance$2.apply(IgnitionEx.java:1826) at org.apache.ignite.internal.worker.WorkersRegistry.onIdle(WorkersRegistry.java:233) at org.apache.ignite.internal.util.worker.GridWorker.onIdle(GridWorker.java:297) at org.apache.ignite.internal.processors.timeout.GridTimeoutProcessor$TimeoutWorker.body(GridTimeoutProcessor.java:221) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) [11:32:34] Nodes started on local machine require more than 80% of physical RAM what can lead to significant slowdown due to swapping (please decrease JVM heap size, data region size or checkpoint buffer size) [required=10602MB, available=8067MB] log4j:WARN No appenders could be found for logger (org.springframework.beans.factory.support.DefaultListableBeanFactory). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. [11:32:35] Performance suggestions for grid 'FamilybankCluster' (fix if possible) [11:32:35] To disable, set -DIGNITE_PERFORMANCE_SUGGESTIONS_DISABLED=true [11:32:35] ^-- Enable G1 Garbage Collector (add '-XX:+UseG1GC' to JVM options) [11:32:35] ^-- Specify JVM heap max size (add '-Xmx<size>[g|G|m|M|k|K]' to JVM options) [11:32:35] ^-- Set max direct memory size if getting 'OOME: Direct buffer memory' (add '-XX:MaxDirectMemorySize=<size>[g|G|m|M|k|K]' to JVM options) [11:32:35] ^-- Disable processing of calls to System.gc() (add '-XX:+DisableExplicitGC' to JVM options) [11:32:35] ^-- Enable write-behind to persistent store (set 'writeBehindEnabled' to true) [11:32:35] Refer to this page for more performance suggestions: https://apacheignite.readme.io/docs/jvm-and-system-tuning [11:32:35] [11:32:35] To start Console Management & Monitoring run ignitevisorcmd.{sh|bat} [11:32:35] [11:32:35] Ignite node started OK (id=5cf91389, instance name=FamilybankCluster) [11:32:35] Topology snapshot [ver=4, locNode=5cf91389, servers=2, clients=2, state=ACTIVE, CPUs=4, offheap=3.2GB, heap=7.0GB] >>> Loading caches... >>> Loading cache: AccountCache Jan 23, 2019 11:32:36 AM org.apache.ignite.logger.java.JavaLogger error SEVERE: Failed to obtain remote job result policy for result from ComputeTask.result(..) method (will fail the whole task): GridJobResultImpl [job=C2 [c=LoadCacheJobV2 [keepBinary=false]], sib=GridJobSiblingImpl [sesId=3b24d497861-5cf91389-4b8e-4d9b-b4b9-db50ead68e22, jobId=5b24d497861-5cf91389-4b8e-4d9b-b4b9-db50ead68e22, nodeId=e5342c87-56ff-473d-a2ea-79175c0462b8, isJobDone=false], jobCtx=GridJobContextImpl [jobId=5b24d497861-5cf91389-4b8e-4d9b-b4b9-db50ead68e22, timeoutObj=null, attrs={}], node=TcpDiscoveryNode [id=e5342c87-56ff-473d-a2ea-79175c0462b8, addrs=[0:0:0:0:0:0:0:1, 127.0.0.1, 192.168.43.165, 2402:3a80:cff:a18e:3018:951e:6461:213a, 2402:3a80:cff:a18e:95f:1891:c2ef:95bf], sockAddrs=[/2402:3a80:cff:a18e:3018:951e:6461:213a:47501, /192.168.43.165:47501, /2402:3a80:cff:a18e:95f:1891:c2ef:95bf:47501, BLREQX132649L.ad.infosys.com/192.168.56.1:47501, /0:0:0:0:0:0:0:1:47501, /127.0.0.1:47501], discPort=47501, order=2, intOrder=2, lastExchangeTime=1548223354186, loc=false, ver=2.7.0#20181201-sha1:256ae401, isClient=false], ex=class o.a.i.IgniteException: Failed to load cache: AccountCache, 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): Failed to load cache: AccountCache at org.apache.ignite.compute.ComputeTaskAdapter.result(ComputeTaskAdapter.java:102) at org.apache.ignite.internal.processors.task.GridTaskWorker$5.apply(GridTaskWorker.java:1053) at org.apache.ignite.internal.processors.task.GridTaskWorker$5.apply(GridTaskWorker.java:1046) at org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6848) at org.apache.ignite.internal.processors.task.GridTaskWorker.result(GridTaskWorker.java:1046) at org.apache.ignite.internal.processors.task.GridTaskWorker.onResponse(GridTaskWorker.java:864) at org.apache.ignite.internal.processors.task.GridTaskProcessor.processJobExecuteResponse(GridTaskProcessor.java:1081) at org.apache.ignite.internal.processors.task.GridTaskProcessor$JobMessageListener.onMessage(GridTaskProcessor.java:1316) at org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1569) at org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1197) at org.apache.ignite.internal.managers.communication.GridIoManager.access$4200(GridIoManager.java:127) at org.apache.ignite.internal.managers.communication.GridIoManager$9.run(GridIoManager.java:1093) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.IgniteException: Failed to load cache: AccountCache at org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2.execute(GridClosureProcessor.java:1858) at org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:568) at org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6816) at org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:562) at org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:491) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1125) at org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1923) ... 7 more Caused by: class org.apache.ignite.IgniteException: Failed to load cache: AccountCache at org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:1025) at org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5681) at org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJobV2.localExecute(GridCacheAdapter.java:5725) at org.apache.ignite.internal.processors.cache.GridCacheAdapter$TopologyVersionAwareJob.execute(GridCacheAdapter.java:6361) at org.apache.ignite.compute.ComputeJobAdapter.call(ComputeJobAdapter.java:132) at org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2.execute(GridClosureProcessor.java:1855) ... 14 more Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load cache: AccountCache at org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:543) at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:630) at org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.localLoadCache(GridCacheProxyImpl.java:222) at org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5676) ... 18 more Caused by: javax.cache.integration.CacheLoaderException: Failed to load cache: AccountCache at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:819) at org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:520) ... 21 more Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load cache at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1.call(CacheAbstractJdbcStore.java:474) at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1.call(CacheAbstractJdbcStore.java:434) at java.util.concurrent.FutureTask.run(FutureTask.java:266) ... 3 more Caused by: org.postgresql.util.PSQLException: The connection attempt failed. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:272) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:215) at org.postgresql.Driver.makeConnection(Driver.java:404) at org.postgresql.Driver.connect(Driver.java:272) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:86) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:71) at org.postgresql.ds.PGConnectionPoolDataSource.getPooledConnection(PGConnectionPoolDataSource.java:58) at org.postgresql.ds.PGPoolingDataSource.getPooledConnection(PGPoolingDataSource.java:378) at org.postgresql.ds.PGPoolingDataSource.getConnection(PGPoolingDataSource.java:323) at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.openConnection(CacheAbstractJdbcStore.java:325) at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1.call(CacheAbstractJdbcStore.java:441) ... 5 more Caused by: java.net.UnknownHostException: [host]:[port] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at org.postgresql.core.PGStream.<init>(PGStream.java:61) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144) ... 18 more [11:32:37] Ignite node stopped OK [name=FamilybankCluster, uptime=00:00:01.564] Exception in thread "main" javax.cache.integration.CacheLoaderException: Failed to load cache: AccountCache at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:819) at org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:520) at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:630) at org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.localLoadCache(GridCacheProxyImpl.java:222) at org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.localExecute(GridCacheAdapter.java:5676) at org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJobV2.localExecute(GridCacheAdapter.java:5725) at org.apache.ignite.internal.processors.cache.GridCacheAdapter$TopologyVersionAwareJob.execute(GridCacheAdapter.java:6361) at org.apache.ignite.compute.ComputeJobAdapter.call(ComputeJobAdapter.java:132) at org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2.execute(GridClosureProcessor.java:1855) at org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:568) at org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6816) at org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:562) at org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:491) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1125) at org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1923) at org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1569) at org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1197) at org.apache.ignite.internal.managers.communication.GridIoManager.access$4200(GridIoManager.java:127) at org.apache.ignite.internal.managers.communication.GridIoManager$9.run(GridIoManager.java:1093) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load cache at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1.call(CacheAbstractJdbcStore.java:474) at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1.call(CacheAbstractJdbcStore.java:434) at java.util.concurrent.FutureTask.run(FutureTask.java:266) ... 3 more Caused by: org.postgresql.util.PSQLException: The connection attempt failed. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:272) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:215) at org.postgresql.Driver.makeConnection(Driver.java:404) at org.postgresql.Driver.connect(Driver.java:272) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:86) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:71) at org.postgresql.ds.PGConnectionPoolDataSource.getPooledConnection(PGConnectionPoolDataSource.java:58) at org.postgresql.ds.PGPoolingDataSource.getPooledConnection(PGPoolingDataSource.java:378) at org.postgresql.ds.PGPoolingDataSource.getConnection(PGPoolingDataSource.java:323) at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.openConnection(CacheAbstractJdbcStore.java:325) at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1.call(CacheAbstractJdbcStore.java:441) ... 5 more Caused by: java.net.UnknownHostException: [host]:[port] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at org.postgresql.core.PGStream.<init>(PGStream.java:61) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144) ... 18 more Process finished with exit code 1 ---END_PASTE---- I am also sharing below the postgres sql dump: ---BEGIN_PASTE--- -- -- PostgreSQL database dump -- -- Dumped from database version 10.4 -- Dumped by pg_dump version 10.4 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET client_min_messages = warning; SET row_security = off; -- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; -- -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: account; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.account ( accountid integer NOT NULL, accounttype character varying(10), customerid integer ); ALTER TABLE public.account OWNER TO postgres; -- -- Name: account_accountid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.account_accountid_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.account_accountid_seq OWNER TO postgres; -- -- Name: account_accountid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.account_accountid_seq OWNED BY public.account.accountid; -- -- Name: balance; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.balance ( accountid integer, amount double precision NOT NULL ); ALTER TABLE public.balance OWNER TO postgres; -- -- Name: customer; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.customer ( customerid integer NOT NULL, customername character varying(25), age integer, gender character varying(1) ); ALTER TABLE public.customer OWNER TO postgres; -- -- Name: customer_customerid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.customer_customerid_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.customer_customerid_seq OWNER TO postgres; -- -- Name: customer_customerid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.customer_customerid_seq OWNED BY public.customer.customerid; -- -- Name: family; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.family ( familyid integer NOT NULL, familyname character varying(20) ); ALTER TABLE public.family OWNER TO postgres; -- -- Name: family_familyid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.family_familyid_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.family_familyid_seq OWNER TO postgres; -- -- Name: family_familyid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.family_familyid_seq OWNED BY public.family.familyid; -- -- Name: familymembers; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.familymembers ( memberid integer NOT NULL, familyid integer, accountid integer ); ALTER TABLE public.familymembers OWNER TO postgres; -- -- Name: familymembers_memberid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.familymembers_memberid_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.familymembers_memberid_seq OWNER TO postgres; -- -- Name: familymembers_memberid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.familymembers_memberid_seq OWNED BY public.familymembers.memberid; -- -- Name: journal; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.journal ( journalid integer NOT NULL, accountid integer, transactiontype character varying(1) NOT NULL, amount double precision NOT NULL ); ALTER TABLE public.journal OWNER TO postgres; -- -- Name: journal_journalid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.journal_journalid_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.journal_journalid_seq OWNER TO postgres; -- -- Name: journal_journalid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.journal_journalid_seq OWNED BY public.journal.journalid; -- -- Name: account accountid; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.account ALTER COLUMN accountid SET DEFAULT nextval('public.account_accountid_seq'::regclass); -- -- Name: customer customerid; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.customer ALTER COLUMN customerid SET DEFAULT nextval('public.customer_customerid_seq'::regclass); -- -- Name: family familyid; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.family ALTER COLUMN familyid SET DEFAULT nextval('public.family_familyid_seq'::regclass); -- -- Name: familymembers memberid; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.familymembers ALTER COLUMN memberid SET DEFAULT nextval('public.familymembers_memberid_seq'::regclass); -- -- Name: journal journalid; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.journal ALTER COLUMN journalid SET DEFAULT nextval('public.journal_journalid_seq'::regclass); -- -- Data for Name: account; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.account (accountid, accounttype, customerid) FROM stdin; 21 S 42 22 S 43 23 S 44 24 S 45 25 S 46 26 S 47 27 S 48 28 S 49 29 S 50 30 S 51 \. -- -- Data for Name: balance; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.balance (accountid, amount) FROM stdin; 21 0 22 0 23 0 24 0 25 0 26 0 27 0 28 0 29 0 30 0 \. -- -- Data for Name: customer; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.customer (customerid, customername, age, gender) FROM stdin; 42 Jack-Jack Par 1 M 43 Elastigirl 26 F 44 Violet Parr 13 F 45 Dash 10 M 46 Mr Incredible 36 M 47 Lucy Wilde 33 F 48 Agnes 5 F 49 Gru 36 M 50 Margo 14 F 51 Edith 9 F \. -- -- Data for Name: family; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.family (familyid, familyname) FROM stdin; 1 Incredibles 2 Despicables \. -- -- Data for Name: familymembers; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.familymembers (memberid, familyid, accountid) FROM stdin; 1 1 21 2 1 22 3 1 23 4 1 24 5 1 25 6 2 26 7 2 27 8 2 28 9 2 29 10 2 30 \. -- -- Data for Name: journal; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.journal (journalid, accountid, transactiontype, amount) FROM stdin; 1 21 C 10000 2 22 C 10000 3 23 C 10000 4 24 C 10000 5 25 C 10000 6 26 C 10000 7 27 C 10000 8 28 C 10000 9 29 C 10000 10 30 C 10000 \. -- -- Name: account_accountid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.account_accountid_seq', 30, true); -- -- Name: customer_customerid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.customer_customerid_seq', 51, true); -- -- Name: family_familyid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.family_familyid_seq', 2, true); -- -- Name: familymembers_memberid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.familymembers_memberid_seq', 10, true); -- -- Name: journal_journalid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.journal_journalid_seq', 10, true); -- -- Name: account account_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.account ADD CONSTRAINT account_pkey PRIMARY KEY (accountid); -- -- Name: customer customer_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.customer ADD CONSTRAINT customer_pkey PRIMARY KEY (customerid); -- -- Name: family family_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.family ADD CONSTRAINT family_pkey PRIMARY KEY (familyid); -- -- Name: familymembers familymembers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.familymembers ADD CONSTRAINT familymembers_pkey PRIMARY KEY (memberid); -- -- Name: journal journal_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.journal ADD CONSTRAINT journal_pkey PRIMARY KEY (journalid); -- -- Name: account account_customerid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.account ADD CONSTRAINT account_customerid_fkey FOREIGN KEY (customerid) REFERENCES public.customer(customerid); -- -- Name: balance balance_accountid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.balance ADD CONSTRAINT balance_accountid_fkey FOREIGN KEY (accountid) REFERENCES public.account(accountid); -- -- Name: familymembers familymembers_accountid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.familymembers ADD CONSTRAINT familymembers_accountid_fkey FOREIGN KEY (accountid) REFERENCES public.account(accountid); -- -- Name: familymembers familymembers_familyid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.familymembers ADD CONSTRAINT familymembers_familyid_fkey FOREIGN KEY (familyid) REFERENCES public.family(familyid); -- -- Name: journal journal_accountid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.journal ADD CONSTRAINT journal_accountid_fkey FOREIGN KEY (accountid) REFERENCES public.account(accountid); -- -- PostgreSQL database dump complete -- ---END_PASTE--- I hope I have provided enough data for people to replicate my issue. If anything more required please revert back. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
