NPE message in H2 console

classic Classic list List threaded Threaded
3 messages Options
merysoft merysoft
Reply | Threaded
Open this post in threaded view
|

NPE message in H2 console

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/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: NPE message in H2 console

Hello!


I recommend using sqlline instead.

Regards,
--
Ilya Kasnacheev


чт, 7 февр. 2019 г. в 12:07, merysoft <[hidden email]>:
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/
merysoft merysoft
Reply | Threaded
Open this post in threaded view
|

Re: NPE message in H2 console

Thank you. I am usually using DataGrip but will test drive sqlline too.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/