Hello! So you are saying it works for you if you restart IDE? Have you tried doing clean build instead? Or run maven "clean install" target? Where is that properties file located?
Regards, -- Ilya Kasnacheev ср, 23 янв. 2019 г. в 16:31, arun jayapal <[email protected]>: > Yes. I figured that. But even if I update the file (secret.properties), > intellij (the ide I use) doesn't accept the updated values. > > This is not an ignite problem per se, but it would be nice if someone gave > me a workaround for it. > > Currently I restart the IDE. I have no idea how that helps... > > On Wed 23 Jan, 2019, 12:03 deostroll <[email protected] wrote: > >> 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/ >> >
