Hello! I have created a ticket https://issues.apache.org/jira/browse/IGNITE-11248
I recommend using sqlline instead. Regards, -- Ilya Kasnacheev чт, 7 февр. 2019 г. в 12:07, merysoft <[email protected]>: > Hi, > > I have been using Ignite earlier (version 2.6 lately) and everything was > working fine. > OS: Windows 10 64 bit. > > Then I have "upgraded" to 2.7; path, IGNITE_HOME set, and Ignite can be > started using ignite.bat or from a Java IDE, the H2 console (turned on with > IGNITE_H2_DEBUG_CONSOLE=true) drops an error all the time. I can run a SQL > query in that too, just wondering why this NPE is displayed (see > screenshot). > > Should be some simple think I am not aware of - if you have any ideas, > please give me a hint... > > Cheers, > -Laszlo > > <http://apache-ignite-users.70518.x6.nabble.com/file/t2017/ai27_NPE.png> > > The message displayed by the browser (Chrome, Edge, does not matter) looks > like this: > > General error: "java.lang.NullPointerException"; SQL statement: > SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_CAT, > TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME, REF_GENERATION, SQL FROM > (SELECT SYNONYM_CATALOG TABLE_CAT, SYNONYM_SCHEMA TABLE_SCHEM, SYNONYM_NAME > as TABLE_NAME, TYPE_NAME AS TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, > TYPE_NAME TYPE_SCHEM, TYPE_NAME AS TYPE_NAME, TYPE_NAME > SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, NULL AS SQL FROM > INFORMATION_SCHEMA.SYNONYMS WHERE SYNONYM_CATALOG LIKE ? ESCAPE ? AND > SYNONYM_SCHEMA LIKE ? ESCAPE ? AND SYNONYM_NAME LIKE ? ESCAPE ? AND (true) > UNION SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, > TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, > TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM > INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND > TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE > IN(?, ?, ?, ?, ?, ?, ?)) ) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME > [50000-197] HY000/50000 > org.h2.jdbc.JdbcSQLException: General error: > "java.lang.NullPointerException"; SQL statement: > SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_CAT, > TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME, REF_GENERATION, SQL FROM > (SELECT SYNONYM_CATALOG TABLE_CAT, SYNONYM_SCHEMA TABLE_SCHEM, SYNONYM_NAME > as TABLE_NAME, TYPE_NAME AS TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, > TYPE_NAME TYPE_SCHEM, TYPE_NAME AS TYPE_NAME, TYPE_NAME > SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, NULL AS SQL FROM > INFORMATION_SCHEMA.SYNONYMS WHERE SYNONYM_CATALOG LIKE ? ESCAPE ? AND > SYNONYM_SCHEMA LIKE ? ESCAPE ? AND SYNONYM_NAME LIKE ? ESCAPE ? AND (true) > UNION SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, > TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, > TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM > INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND > TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE > IN(?, ?, ?, ?, ?, ?, ?)) ) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME > [50000-197] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:357) > at org.h2.message.DbException.get(DbException.java:168) > at org.h2.message.DbException.convert(DbException.java:307) > at org.h2.command.Command.executeQuery(Command.java:216) > at > org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114) > > at > org.h2.jdbc.JdbcDatabaseMetaData.getTables(JdbcDatabaseMetaData.java:224) > at org.h2.bnf.context.DbSchema.readTables(DbSchema.java:110) > at org.h2.bnf.context.DbContents.readContents(DbContents.java:169) > at org.h2.server.web.WebApp.tables(WebApp.java:698) > at org.h2.server.web.WebApp.process(WebApp.java:225) > at org.h2.server.web.WebApp.processRequest(WebApp.java:170) > at org.h2.server.web.WebThread.process(WebThread.java:134) > at org.h2.server.web.WebThread.run(WebThread.java:90) > at java.lang.Thread.run(Thread.java:748) > Caused by: java.lang.NullPointerException > at > > org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.allNodes(GridDiscoveryManager.java:1850) > at > > org.apache.ignite.internal.processors.query.h2.sys.view.SqlSystemViewNodes.getRowCount(SqlSystemViewNodes.java:96) > at > > org.apache.ignite.internal.processors.query.h2.sys.SqlSystemTable.getRowCountApproximation(SqlSystemTable.java:152) > at org.h2.table.MetaTable.generateRows(MetaTable.java:784) > at org.h2.index.MetaIndex.find(MetaIndex.java:51) > at org.h2.index.BaseIndex.find(BaseIndex.java:130) > at org.h2.index.IndexCursor.find(IndexCursor.java:176) > at org.h2.table.TableFilter.next(TableFilter.java:471) > at > org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452) > > at org.h2.result.LazyResult.hasNext(LazyResult.java:79) > at org.h2.result.LazyResult.next(LazyResult.java:59) > at org.h2.command.dml.Select.queryFlat(Select.java:527) > at org.h2.command.dml.Select.queryWithoutCache(Select.java:633) > at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114) > at org.h2.command.dml.Query.query(Query.java:352) > at org.h2.command.dml.Query.query(Query.java:333) > at > org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:241) > at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114) > at org.h2.command.dml.Query.query(Query.java:347) > at org.h2.command.dml.Query.query(Query.java:333) > at org.h2.index.ViewIndex.find(ViewIndex.java:288) > at org.h2.index.ViewIndex.find(ViewIndex.java:160) > at org.h2.index.BaseIndex.find(BaseIndex.java:130) > at org.h2.index.IndexCursor.find(IndexCursor.java:176) > at org.h2.table.TableFilter.next(TableFilter.java:471) > at > org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1452) > > at org.h2.result.LazyResult.hasNext(LazyResult.java:79) > at org.h2.result.LazyResult.next(LazyResult.java:59) > at org.h2.command.dml.Select.queryFlat(Select.java:527) > at org.h2.command.dml.Select.queryWithoutCache(Select.java:633) > at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114) > at org.h2.command.dml.Query.query(Query.java:352) > at org.h2.command.dml.Query.query(Query.java:333) > at org.h2.command.CommandContainer.query(CommandContainer.java:114) > at org.h2.command.Command.executeQuery(Command.java:202) > ... 10 more > > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
