Muthu, Can you attach a simple example to reproduce this exception?
On Fri, Aug 4, 2017 at 4:08 AM, Muthu <[email protected]> wrote: > Sure Alexey...thanks. I am using PostgreSQL version 9.6. The driver is a > bit old...its 9.4.1212 JDBC 4 > <https://jdbc.postgresql.org/download/postgresql-9.4.1212.jre6.jar> > (postgresql-9.4.1212.jre6.jar )..but i was using it without any issues > with 1.9 version of web console (previous one). > > On the workaround thingy, the problem is when i generate the > models/artifacts from it (console.gridgain.com) & deploy it on ignite > 2.1.0 it fails starting up with this error (it was failing even with 2.0 & > was fixed after i identified it..more details here, > https://stackoverflow.com/questions/44468342/automatic- > persistence-unable-to-bring-up-cache-with-web-console- > generated-mode/44901117). I thought later on that the ignite version from > there is grid gain's ignite version & that may not be compatible with the > open source ignite 2.1.0. Is it not true? > > INFO: Started cache [name=ignite-sys-cache, memoryPolicyName=sysMemPlc, > mode=REPLICATED, atomicity=TRANSACTIONAL] > Aug 03, 2017 12:34:36 PM org.apache.ignite.logger.java.JavaLogger error > SEVERE: Failed to reinitialize local partitions (preloading will be > stopped): GridDhtPartitionExchangeId [topVer=AffinityTopologyVersion > [topVer=1, minorTopVer=0], nodeId=e9b2cf46, evt=NODE_JOINED] > class org.apache.ignite.IgniteCheckedException: Failed to register query > type: QueryTypeDescriptorImpl [cacheName=DeptCache, name=Dept, > tblName=DEPT, fields={DNAME=class java.lang.String, LOC=class java.lang > .String, DEPTID=class java.lang.String}, idxs={}, fullTextIdx=null, > keyCls=class java.lang.String, valCls=class java.lang.Object, > keyTypeName=java.lang.String, valTypeName=com.brocade.dcm. > domain.model.Dept, > valTextIdx=false, typeId=1038936471, affKey=null, keyFieldName=deptid, > valFieldName=null, obsolete=false] > at org.apache.ignite.internal.processors.query.h2. > IgniteH2Indexing.registerType(IgniteH2Indexing.java:1532) > at org.apache.ignite.internal.processors.query.GridQueryProcessor. > registerCache0(GridQueryProcessor.java:1424) > at org.apache.ignite.internal.processors.query.GridQueryProcessor. > onCacheStart0(GridQueryProcessor.java:784) > at org.apache.ignite.internal.processors.query.GridQueryProcessor. > onCacheStart(GridQueryProcessor.java:845) > at org.apache.ignite.internal.processors.cache. > GridCacheProcessor.startCache(GridCacheProcessor.java:1185) > at org.apache.ignite.internal.processors.cache.GridCacheProcessor. > prepareCacheStart(GridCacheProcessor.java:1884) > at org.apache.ignite.internal.processors.cache.GridCacheProcessor. > startCachesOnLocalJoin(GridCacheProcessor.java:1755) > at org.apache.ignite.internal.processors.cache.distributed. > dht.preloader.GridDhtPartitionsExchangeFuture.init( > GridDhtPartitionsExchangeFuture.java:619) > at org.apache.ignite.internal.processors.cache. > GridCachePartitionExchangeManager$ExchangeWorker.body( > GridCachePartitionExchangeManager.java:1901) > at org.apache.ignite.internal.util.worker.GridWorker.run( > GridWorker.java:110) > at java.lang.Thread.run(Unknown Source) > Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement > "CREATE TABLE ""DEPTS"".""DEPT"" (_KEY VARCHAR INVISIBLE[*] NOT NULL,_VAL > OTHER INVISIBLE,_VER OTHER INVISIBLE,""DNAME"" VARCHAR,""LOC"" > VARCHAR,""DEPTID"" VARCHAR) ENGINE ""org.apache.ignite.internal. > processors.query.h2.H2TableEngine"" "; expected "(, FOR, UNSIGNED, NOT, > NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SE > RIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, > CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL > statement: > CREATE TABLE "DEPTS"."DEPT" (_KEY VARCHAR INVISIBLE NOT NULL,_VAL OTHER > INVISIBLE,_VER OTHER INVISIBLE,"DNAME" VARCHAR,"LOC" VARCHAR,"DEPTID" > VARCHAR) engine "org.apache.ignite.internal.processors.query.h2.H > 2TableEngine" [42001-193] > at org.h2.message.DbException.getJdbcSQLException( > DbException.java:345) > at org.h2.message.DbException.getSyntaxError(DbException.java:205) > at org.h2.command.Parser.getSyntaxError(Parser.java:537) > at org.h2.command.Parser.read(Parser.java:3186) > at org.h2.command.Parser.readIfMore(Parser.java:885) > at org.h2.command.Parser.parseCreateTable(Parser.java:6043) > at org.h2.command.Parser.parseCreate(Parser.java:4238) > at org.h2.command.Parser.parsePrepared(Parser.java:362) > at org.h2.command.Parser.parse(Parser.java:317) > at org.h2.command.Parser.parse(Parser.java:293) > at org.h2.command.Parser.prepareCommand(Parser.java:254) > at org.h2.engine.Session.prepareLocal(Session.java:561) > at org.h2.engine.Session.prepareCommand(Session.java:502) > at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection. > java:1203) > at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement. > java:170) > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158) > at org.apache.ignite.internal.processors.query.h2. > H2TableEngine.createTable(H2TableEngine.java:68) > at org.apache.ignite.internal.processors.query.h2. > IgniteH2Indexing.createTable(IgniteH2Indexing.java:1606) > at org.apache.ignite.internal.processors.query.h2. > IgniteH2Indexing.registerType(IgniteH2Indexing.java:1525) > ... 10 more > > > Regards, > Muthu > > -- The real danger with modern technology isn't that machines will begin > to think like people, but that people will begin to think like machines. > -- Faith is to believe what you do not see; the reward of this faith is to > see what you believe. > > On Thu, Aug 3, 2017 at 11:19 AM, Alexey Kuznetsov <[email protected]> > wrote: > >> Muthu, >> >> Thanks for stack trace! I will try tomorrow. >> Could you also say what DB you are using (name+version)? and JDBC driver >> (name + version). >> I will try to reproduce. >> >> As a workaround, could you try the same (import model from DB) on >> console.gridgain.com? >> >> On Fri, Aug 4, 2017 at 1:02 AM, Muthu <[email protected]> wrote: >> >>> Hi Andrey, >>> >>> The latest version worked for the connection. However when i try to >>> import domain models from my database it fails past the schema selection >>> page..once i select my database and hit next it doesn't show my two tables >>> that i have in that. Also when i select all (instead of my specific schema) >>> & hit next it doesn't proceed at all & shows an error message >>> "java.sql.SQLException: Failed to collect metadata". Any clue? >>> >>> I also see this exception in the logs, >>> >>> [2017-08-03 11:00:11,291][ERROR][pool-6-thread-1][DatabaseListener] >>> Failed to collect metadata >>> java.lang.ClassCastException: java.util.ArrayList cannot be cast to >>> java.lang.String >>> at org.apache.ignite.console.agent.db.dialect.JdbcMetadataDiale >>> ct.tables(JdbcMetadataDialect.java:128) >>> at org.apache.ignite.console.agent.db.DbMetadataReader.metadata >>> (DbMetadataReader.java:95) >>> at org.apache.ignite.console.agent.handlers.DatabaseListener.me >>> tadata(DatabaseListener.java:280) >>> at org.apache.ignite.console.agent.handlers.DatabaseListener$2. >>> execute(DatabaseListener.java:122) >>> at org.apache.ignite.console.agent.handlers.AbstractListener$1. >>> run(AbstractListener.java:67) >>> at java.util.concurrent.Executors$RunnableAdapter.call(Executor >>> s.java:473) >>> at java.util.concurrent.FutureTask.run(FutureTask.java:262) >>> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool >>> Executor.java:1145) >>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo >>> lExecutor.java:615) >>> at java.lang.Thread.run(Thread.java:745) >>> >>> >>> Regards, >>> Muthu >>> >>> -- The real danger with modern technology isn't that machines will begin >>> to think like people, but that people will begin to think like machines. >>> -- Faith is to believe what you do not see; the reward of this faith is >>> to see what you believe. >>> >>> On Wed, Aug 2, 2017 at 10:50 PM, Muthu <[email protected]> >>> wrote: >>> >>>> Thanks Andrey...I did use the latest..also i validated the token >>>> without which the agent doesn't even connect (btw i couldn't initially get >>>> the web-agent version downloaded from console.gridgain to connect to web >>>> console...it failed complaining version mismatch...then i took the version >>>> from inside the web console image & then got it to connect properly). >>>> >>>> I see the new image has been pushed a couple hours back..will retry >>>> with that & let you know. >>>> >>>> Regards, >>>> Muthu >>>> >>>> -- The real danger with modern technology isn't that machines will >>>> begin to think like people, but that people will begin to think like >>>> machines. >>>> -- Faith is to believe what you do not see; the reward of this faith is >>>> to see what you believe. >>>> >>>> On Wed, Aug 2, 2017 at 8:54 PM, Andrey Novikov <[email protected]> >>>> wrote: >>>> >>>>> Hi Muthu, >>>>> >>>>> Do you use following image (in console execute following command: >>>>> "docker images")? >>>>> REPOSITORY TAG >>>>> IMAGE ID >>>>> apacheignite/web-console-standalone latest ae3d24152e68 >>>>> >>>>> Also, please validate token in agent configuration should be the same >>>>> as on profile page. >>>>> >>>>> On 2017-08-03 09:47, Muthu <[email protected]> wrote: >>>>> > Hi Folks, >>>>> > >>>>> > First a big thanks for making the latest version of web console >>>>> available >>>>> > on docker hub (https://hub.docker.com/r/apac >>>>> heignite/web-console-standalone/). >>>>> > As i understand this has fixes for some issues i encountered with >>>>> ignite >>>>> > 2.0 version >>>>> > >>>>> > I tried it but unfortunately it looks like this latest version has >>>>> trouble >>>>> > connecting to ignite grid. Even though i have ignite & web-agent >>>>> running on >>>>> > the same Linux host as the container (with all properly connected as >>>>> seen >>>>> > from the logs) web console is unable to connect to it. >>>>> > >>>>> > As a result i am also unable to use it to connect to my db for >>>>> model/cache >>>>> > artifact generation, etc. >>>>> > >>>>> > Has any one else tried using it? >>>>> > >>>>> > Regards, >>>>> > Muthu >>>>> > >>>>> > -- The real danger with modern technology isn't that machines will >>>>> begin to >>>>> > think like people, but that people will begin to think like machines. >>>>> > -- Faith is to believe what you do not see; the reward of this faith >>>>> is to >>>>> > see what you believe. >>>>> > >>>>> >>>> >>>> >>> >> >> >> -- >> Alexey Kuznetsov >> > > -- Alexey Kuznetsov
