Hi Mikhail,
I've attached a small maven spring boot project where i've reproduced the
error.
I have tried a different key, with no success.
When i run: mvn spring-boot:run
I get the following:
>>> +----------------------------------------------------------------------+
>>> Ignite ver. 2.0.0#20170430-sha1:d4eef3c68ff116ee34bc13648cd82c640b3ea072
>>> +----------------------------------------------------------------------+
>>> OS name: Windows 10 10.0 amd64
>>> CPU(s): 4
>>> Heap: 1.0GB
>>> VM name: 15044@mlawlessJMLW742
>>> Local node [ID=5BBEA473-216B-497F-966E-7FC6D66AD194, order=1,
>>> clientMode=false]
>>> Local node addresses: [mlawlessJMLW742/0:0:0:0:0:0:0:1, /127.0.0.1,
>>> /172.19.29.194]
>>> Local ports: TCP:11211 TCP:47100 UDP:47400 TCP:47500
[16:35:52] Topology snapshot [ver=1, servers=1, clients=0, CPUs=4,
heap=1.0GB]
2017-07-20 16:35:52.728 INFO 15044 --- [ main]
o.a.i.i.m.d.GridDiscoveryManager : Topology snapshot [ver=1,
servers=1, clients=0, CPUs=4, heap=1.0GB]
2017-07-20 16:35:52.962 ERROR 15044 --- [orker-#29%null%]
.c.d.d.p.GridDhtPartitionsExchangeFuture : Failed to reinitialize local
partitions (preloading will be stopped): GridDhtPartitionExchangeId
[topVer=AffinityTopologyVersion [topVer=1, minorTopVer=1], nodeId=5bbea473,
evt=DISCOVERY_CUSTOM_EVT]
org.apache.ignite.IgniteCheckedException: Failed to register query type:
QueryTypeDescriptorImpl [space=IMAGE_CACHE, name=SurveyImage, tblName=null,
fields={gasCompany=class java.lang.String, surveyCompany=class
java.lang.String, survey=class java.lang.String, session=class
java.lang.String, camera=class java.lang.String, fileName=class
java.lang.String, fileLocation=class java.lang.String, latitude=class
java.lang.Float, longitude=class java.lang.Float, id=class java.lang.Long},
idxs={SurveyImage_id_idx=QueryIndexDescriptorImpl [name=SurveyImage_id_idx,
type=SORTED, inlineSize=-1]}, fullTextIdx=null, keyCls=class java.lang.Long,
valCls=class java.lang.Object, keyTypeName=java.lang.Long,
valTypeName=com.ignite.SurveyImage, valTextIdx=false, typeId=0, affKey=null,
keyFieldName=null, valFieldName=null, obsolete=false]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1866)
~[ignite-indexing-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.registerCache0(GridQueryProcessor.java:1306)
~[ignite-core-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart0(GridQueryProcessor.java:756)
~[ignite-core-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:817)
~[ignite-core-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1265)
~[ignite-core-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheStart(GridCacheProcessor.java:1943)
~[ignite-core-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheStart(GridCacheProcessor.java:1833)
~[ignite-core-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.cache.CacheAffinitySharedManager.onCacheChangeRequest(CacheAffinitySharedManager.java:379)
~[ignite-core-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.onCacheChangeRequest(GridDhtPartitionsExchangeFuture.java:688)
~[ignite-core-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:529)
~[ignite-core-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:1806)
[ignite-core-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
[ignite-core-2.0.0.jar:2.0.0]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_131]
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement
"CREATE TABLE ""IMAGE_CACHE"".SURVEYIMAGE (_KEY BIGINT INVISIBLE[*] NOT
NULL,_VAL OTHER INVISIBLE,_VER OTHER INVISIBLE,GASCOMPANY
VARCHAR,SURVEYCOMPANY VARCHAR,SURVEY VARCHAR,SESSION VARCHAR,CAMERA
VARCHAR,FILENAME VARCHAR,FILELOCATION VARCHAR,LATITUDE REAL,LONGITUDE
REAL,ID BIGINT) ENGINE
""org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$H2TableEngine""
"; expected "(, FOR, UNSIGNED, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL,
AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE,
SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK,
REFERENCES, ,, )"; SQL statement:
CREATE TABLE "IMAGE_CACHE".SurveyImage (_key BIGINT INVISIBLE NOT NULL,_val
OTHER INVISIBLE,_ver OTHER INVISIBLE,gasCompany VARCHAR,surveyCompany
VARCHAR,survey VARCHAR,session VARCHAR,camera VARCHAR,fileName
VARCHAR,fileLocation VARCHAR,latitude REAL,longitude REAL,id BIGINT) engine
"org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$H2TableEngine"
[42001-194]
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
~[h2-1.4.194.jar:1.4.194]
at org.h2.message.DbException.getSyntaxError(DbException.java:205)
~[h2-1.4.194.jar:1.4.194]
at org.h2.command.Parser.getSyntaxError(Parser.java:539)
~[h2-1.4.194.jar:1.4.194]
at org.h2.command.Parser.read(Parser.java:3242)
~[h2-1.4.194.jar:1.4.194]
at org.h2.command.Parser.readIfMore(Parser.java:887)
~[h2-1.4.194.jar:1.4.194]
at org.h2.command.Parser.parseCreateTable(Parser.java:6119)
~[h2-1.4.194.jar:1.4.194]
at org.h2.command.Parser.parseCreate(Parser.java:4302)
~[h2-1.4.194.jar:1.4.194]
at org.h2.command.Parser.parsePrepared(Parser.java:364)
~[h2-1.4.194.jar:1.4.194]
at org.h2.command.Parser.parse(Parser.java:319)
~[h2-1.4.194.jar:1.4.194]
at org.h2.command.Parser.parse(Parser.java:295)
~[h2-1.4.194.jar:1.4.194]
at org.h2.command.Parser.prepareCommand(Parser.java:256)
~[h2-1.4.194.jar:1.4.194]
at org.h2.engine.Session.prepareLocal(Session.java:564)
~[h2-1.4.194.jar:1.4.194]
at org.h2.engine.Session.prepareCommand(Session.java:505)
~[h2-1.4.194.jar:1.4.194]
at
org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
~[h2-1.4.194.jar:1.4.194]
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:170)
~[h2-1.4.194.jar:1.4.194]
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
~[h2-1.4.194.jar:1.4.194]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$H2TableEngine.createTable(IgniteH2Indexing.java:3975)
~[ignite-indexing-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:2006)
~[ignite-indexing-2.0.0.jar:2.0.0]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1859)
~[ignite-indexing-2.0.0.jar:2.0.0]
... 12 common frames omitted
Appreciate it if you spot something.
Thanks,
Maureen
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/Ignite-client-not-seeing-cache-created-by-server-tp15070p15184.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
