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/

Reply via email to