Hello! > Caused by: java.net.UnknownHostException: [host]:[port]
I think you are supposed to put Postgres host and port somewhere. Note that it is not directly related to Apache Ignite. Regards, -- Ilya Kasnacheev ср, 23 янв. 2019 г. в 09:33, deostroll <[email protected]>: > 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/ >
