I extended error message in ignite-1.3.3 branch that will be released shortly.
On Tue, Jul 28, 2015 at 3:37 PM, Dmitriy Setrakyan <[email protected]> wrote: > As a side note, I would also fix the error message in Ignite to provide a > better explanation to users. > > For example, the message could say: > ---- > Failed to find mapping description [key=java.lang.String, > cache=AlgoCache]. Please configure CacheTypeMetadata to associate > 'AlgoCache' with JdbcPojoStore. > ---- > > Alexey, can you file a ticket or, better yet, just fix it in code? > > D. > > On Tue, Jul 28, 2015 at 1:23 AM, Alexey Kuznetsov <[email protected] > > wrote: > >> Krishna, >> >> It seems that you not properly configured your AlgoCache cache type >> metadata. >> You need to configure Cache Type Metadata to associate AlgoCache and >> JdbcPojoStore. >> >> In short your need to specify: db schema name, db table, key type (full >> class name), value type (full class name) , collection of >> db-to-java key fields mappings, collection of db-to-java value fields >> mappings. >> It could be done from XML or code. >> >> See as example: >> http://apacheignite.readme.io/docs/automatic-persistence#section-generated-artifacts >> >> Let me know if you have more questions. >> >> On Tue, Jul 28, 2015 at 2:59 PM, krishnangc < >> [email protected]> wrote: >> >>> >>> Hi, >>> >>> Trying to load the entire table to cache. Getting the following error. >>> >>> bob.loadCache(null,"java.lang.String","select * from EXCEPTION_MASTER >>> where >>> EXCEPTION_ID='37471' ");} >>> bob.loadCache(null); >>> >>> >>> Tried both but getting the same error. What mistake am I doing. >>> >>> Thanks in advance >>> >>> Krishna >>> >>> start ignite >>> [13:30:28] __________ ________________ >>> [13:30:28] / _/ ___/ |/ / _/_ __/ __/ >>> [13:30:28] _/ // (7 7 // / / / / _/ >>> [13:30:28] /___/\___/_/|_/___/ /_/ /___/ >>> [13:30:28] >>> [13:30:28] ver. 1.3.0-incubating#20150710-sha1:2ade6d00 >>> [13:30:28] 2015 Copyright(C) Apache Software Foundation >>> [13:30:28] >>> [13:30:28] Ignite documentation: http://ignite.incubator.apache.org >>> [13:30:28] >>> [13:30:28] Quiet mode. >>> [13:30:28] ^-- Logging to file >>> >>> '/home/hadoop/Downloads/apache-ignite-fabric-1.2.0-incubating-bin/work/log/ignite-9fc3b00d.log' >>> [13:30:28] ^-- To see **FULL** console log here add >>> -DIGNITE_QUIET=false >>> or "-v" to ignite.{sh|bat} >>> [13:30:28] >>> [13:30:28] Initial heap size is 89MB (should be no less than 512MB, use >>> -Xms512m -Xmx512m). >>> [13:30:28] Configured plugins: >>> [13:30:28] ^-- None >>> [13:30:28] >>> oracle.jdbc.pool.OracleDataSource@726b5b3c >>> the datasource is created >>> [13:30:30] Performance suggestions for grid (fix if possible) >>> [13:30:30] To disable, set -DIGNITE_PERFORMANCE_SUGGESTIONS_DISABLED=true >>> [13:30:30] ^-- Enable ATOMIC mode if not using transactions (set >>> 'atomicityMode' to ATOMIC) >>> [13:30:30] ^-- Enable write-behind to persistent store (set >>> 'writeBehindEnabled' to true) >>> [13:30:30] >>> [13:30:30] To start Console Management & Monitoring run >>> ignitevisorcmd.{sh|bat} >>> [13:30:30] >>> [13:30:30] Ignite node started OK (id=9fc3b00d) >>> [13:30:30] Topology snapshot [ver=1, server nodes=1, client nodes=0, >>> CPUs=8, >>> heap=1.3GB] >>> started ignite >>> load cache >>> loading cache >>> [13:30:30,555][ERROR][ignite-#8%pub-null%][GridJobWorker] Failed to >>> execute >>> job [jobId=1455da3de41-9fc3b00d-a21a-4b1d-8965-b16cb8197270, >>> ses=GridJobSessionImpl [ses=GridTaskSessionImpl >>> [taskName=o.a.i.i.processors.cache.GridCacheAdapter$LoadCacheClosure, >>> dep=LocalDeployment [super=GridDeployment [ts=1438070428955, >>> depMode=SHARED, >>> clsLdr=sun.misc.Launcher$AppClassLoader@3479404a, >>> clsLdrId=b155da3de41-9fc3b00d-a21a-4b1d-8965-b16cb8197270, userVer=0, >>> loc=true, sampleClsName=java.lang.String, pendingUndeploy=false, >>> undeployed=false, usage=0]], >>> taskClsName=o.a.i.i.processors.cache.GridCacheAdapter$LoadCacheClosure, >>> sesId=0455da3de41-9fc3b00d-a21a-4b1d-8965-b16cb8197270, >>> startTime=1438070430512, endTime=9223372036854775807, >>> taskNodeId=9fc3b00d-a21a-4b1d-8965-b16cb8197270, >>> clsLdr=sun.misc.Launcher$AppClassLoader@3479404a, closed=false, >>> cpSpi=null, >>> failSpi=null, loadSpi=null, usage=1, fullSup=false, >>> subjId=9fc3b00d-a21a-4b1d-8965-b16cb8197270, mapFut=IgniteFuture >>> [orig=GridFutureAdapter [resFlag=0, res=null, startTime=1438070430523, >>> endTime=0, ignoreInterrupts=false, lsnr=null, state=INIT]]], >>> jobId=1455da3de41-9fc3b00d-a21a-4b1d-8965-b16cb8197270]] >>> class org.apache.ignite.IgniteException: javax.cache.CacheException: >>> Failed >>> to find mapping description [key=java.lang.String, cache=AlgoCache] >>> at >>> >>> org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2.execute(GridClosureProcessor.java:1711) >>> at >>> >>> org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:482) >>> at >>> >>> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6145) >>> at >>> >>> org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:476) >>> at >>> >>> org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:429) >>> at >>> >>> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:108) >>> at >>> >>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >>> at >>> >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >>> at java.lang.Thread.run(Thread.java:745) >>> Caused by: javax.cache.integration.CacheLoaderException: >>> javax.cache.CacheException: Failed to find mapping description >>> [key=java.lang.String, cache=AlgoCache] >>> at >>> >>> org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:482) >>> at >>> >>> org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:419) >>> at >>> >>> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.localLoadCache(IgniteCacheProxy.java:333) >>> at >>> >>> org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheClosure.call(GridCacheAdapter.java:5375) >>> at >>> >>> org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheClosure.call(GridCacheAdapter.java:5322) >>> at >>> >>> org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2.execute(GridClosureProcessor.java:1708) >>> ... 8 more >>> Caused by: javax.cache.CacheException: Failed to find mapping description >>> [key=java.lang.String, cache=AlgoCache] >>> at >>> >>> org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.entryMapping(CacheAbstractJdbcStore.java:611) >>> at >>> >>> org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:641) >>> at >>> >>> org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:456) >>> ... 13 more >>> [13:30:30,561][ERROR][ignite-#8%pub-null%][GridTaskWorker] Failed to >>> obtain >>> remote job result policy for result from ComputeTask.result(..) method >>> (will >>> fail the whole task): GridJobResultImpl [job=C2 [], >>> sib=GridJobSiblingImpl >>> [sesId=0455da3de41-9fc3b00d-a21a-4b1d-8965-b16cb8197270, >>> jobId=1455da3de41-9fc3b00d-a21a-4b1d-8965-b16cb8197270, >>> nodeId=9fc3b00d-a21a-4b1d-8965-b16cb8197270, isJobDone=false], >>> jobCtx=GridJobContextImpl >>> [jobId=1455da3de41-9fc3b00d-a21a-4b1d-8965-b16cb8197270, timeoutObj=null, >>> attrs={}], node=TcpDiscoveryNode >>> [id=9fc3b00d-a21a-4b1d-8965-b16cb8197270, >>> addrs=[0:0:0:0:0:0:0:1%1, 127.0.0.1, 192.168.1.55], >>> sockAddrs=[/192.168.1.55:47500, /0:0:0:0:0:0:0:1%1:47500, / >>> 127.0.0.1:47500, >>> /192.168.1.55:47500], discPort=47500, order=1, intOrder=1, loc=true, >>> ver=1.3.0#20150710-sha1:2ade6d00, isClient=false], ex=class >>> o.a.i.IgniteException: javax.cache.CacheException: Failed to find mapping >>> description [key=java.lang.String, cache=AlgoCache], hasRes=true, >>> isCancelled=false, isOccupied=true] >>> class org.apache.ignite.IgniteException: Remote job threw user exception >>> (override or implement ComputeTask.result(..) method if you would like to >>> have automatic failover for this exception). >>> at >>> >>> org.apache.ignite.compute.ComputeTaskAdapter.result(ComputeTaskAdapter.java:102) >>> at >>> >>> org.apache.ignite.internal.processors.task.GridTaskWorker$3.apply(GridTaskWorker.java:834) >>> at >>> >>> org.apache.ignite.internal.processors.task.GridTaskWorker$3.apply(GridTaskWorker.java:827) >>> at >>> >>> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6177) >>> at >>> >>> org.apache.ignite.internal.processors.task.GridTaskWorker.result(GridTaskWorker.java:827) >>> at >>> >>> org.apache.ignite.internal.processors.task.GridTaskWorker.onResponse(GridTaskWorker.java:723) >>> at >>> >>> org.apache.ignite.internal.processors.task.GridTaskProcessor.processJobExecuteResponse(GridTaskProcessor.java:932) >>> at >>> >>> org.apache.ignite.internal.processors.job.GridJobWorker.finishJob(GridJobWorker.java:747) >>> at >>> >>> org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:534) >>> at >>> >>> org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:429) >>> at >>> >>> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:108) >>> at >>> >>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >>> at >>> >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >>> at java.lang.Thread.run(Thread.java:745) >>> Caused by: class org.apache.ignite.IgniteException: >>> javax.cache.CacheException: Failed to find mapping description >>> [key=java.lang.String, cache=AlgoCache] >>> at >>> >>> org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2.execute(GridClosureProcessor.java:1711) >>> at >>> >>> org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:482) >>> at >>> >>> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6145) >>> at >>> >>> org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:476) >>> ... 5 more >>> Caused by: javax.cache.integration.CacheLoaderException: >>> javax.cache.CacheException: Failed to find mapping description >>> [key=java.lang.String, cache=AlgoCache] >>> at >>> >>> org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:482) >>> at >>> >>> org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:419) >>> at >>> >>> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.localLoadCache(IgniteCacheProxy.java:333) >>> at >>> >>> org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheClosure.call(GridCacheAdapter.java:5375) >>> at >>> >>> org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheClosure.call(GridCacheAdapter.java:5322) >>> at >>> >>> org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2.execute(GridClosureProcessor.java:1708) >>> ... 8 more >>> Caused by: javax.cache.CacheException: Failed to find mapping description >>> [key=java.lang.String, cache=AlgoCache] >>> at >>> >>> org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.entryMapping(CacheAbstractJdbcStore.java:611) >>> at >>> >>> org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:641) >>> at >>> >>> org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.java:456) >>> ... 13 more >>> loaded cache >>> >>> >>> >>> >>> -- >>> View this message in context: >>> http://apache-ignite-users.70518.x6.nabble.com/Failed-to-find-mapping-description-tp725.html >>> Sent from the Apache Ignite Users mailing list archive at Nabble.com. >>> >> >> >> >> -- >> Alexey Kuznetsov >> GridGain Systems >> www.gridgain.com >> > > -- Alexey Kuznetsov GridGain Systems www.gridgain.com
