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. >> metadata(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( >> Executors.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 >
