Hi, I am running ignite servers on yarn cluster with properties PFA ignite-cluster.properties.
The servers are running with persistence storage enabled PFA ignite-config.xml configuration file. I am firing ddl and dml from squirrel using IgniteJdbcThinDriver and they are running perfectly, but whenever I restart my cluster and run simple query say "select * from dim_time" I get exception as stated in title. I have found an work around for this issue, what I do is load one dummy record and then delete it, afterwards my select query works completely fine. Why warming up of data is required after every cluster restart ? I am getting similar exception from sqlline too. Also note that "select count(*) from dim_time" executes perfectly. PFA yarn container logs for both nodes. Thanks, Rahul Pandey -- ------------------------------ The content of this e-mail is confidential and intended solely for the use of the addressee(s). The text of this email (including any attachments) may contain information, belonging to Pragmatix Services Private Limited, and/or its associates/ group companies/ subsidiaries (the Company), which is proprietary and/or confidential or legally privileged in nature or exempt from disclosure under applicable law. If you are not the addressee, or the person responsible for delivering it to the addressee, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender and remove this communication entirely from your system. The recipient acknowledges that no guarantee or any warranty is given as to completeness and accuracy of the content of the email. The recipient further acknowledges that the views contained in the email message are those of the sender and may not necessarily reflect those of the Company. Before opening and accessing the attachment please check and scan for virus. Thank you. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The sender or the Company accepts no liability for any damage caused by any virus transmitted by this email or errors or omissions.
stdout: ============================================================================================ ============================================================================================ [12:08:04] __________ ________________ [12:08:04] / _/ ___/ |/ / _/_ __/ __/ [12:08:04] _/ // (7 7 // / / / / _/ [12:08:04] /___/\___/_/|_/___/ /_/ /___/ [12:08:04] [12:08:04] ver. 2.3.0#20171028-sha1:8add7fd5 [12:08:04] 2017 Copyright(C) Apache Software Foundation [12:08:04] [12:08:04] Ignite documentation: http://ignite.apache.org [12:08:04] [12:08:04] Quiet mode. [12:08:04] ^-- Logging to file '/tmp2/usercache/pragmatix/appcache/application_1516353511232_0156/container_e168_1516353511232_0156_01_000002/ignite/apache-ignite-fabric-2.3.0-bin/work/log/ignite-610e25e2.0.log' [12:08:04] ^-- To see **FULL** console log here add -DIGNITE_QUIET=false or "-v" to ignite.{sh|bat} [12:08:04] [12:08:04] OS: Linux 4.4.0-109-generic amd64 [12:08:04] VM information: Java(TM) SE Runtime Environment 1.8.0_112-b15 Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.112-b15 [12:08:04] Configured plugins: [12:08:04] ^-- None [12:08:04] [12:08:04] Message queue limit is set to 0 which may lead to potential OOMEs when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to message queues growth on sender and receiver sides. [12:08:04] Security status [authentication=off, tls/ssl=off] [12:08:09] Performance suggestions for grid (fix if possible) [12:08:09] To disable, set -DIGNITE_PERFORMANCE_SUGGESTIONS_DISABLED=true [12:08:09] ^-- Enable G1 Garbage Collector (add '-XX:+UseG1GC' to JVM options) [12:08:09] ^-- Set max direct memory size if getting 'OOME: Direct buffer memory' (add '-XX:MaxDirectMemorySize=<size>[g|G|m|M|k|K]' to JVM options) [12:08:09] ^-- Disable processing of calls to System.gc() (add '-XX:+DisableExplicitGC' to JVM options) [12:08:09] Refer to this page for more performance suggestions: https://apacheignite.readme.io/docs/jvm-and-system-tuning [12:08:09] [12:08:09] To start Console Management & Monitoring run ignitevisorcmd.{sh|bat} [12:08:09] [12:08:09] Ignite node started OK (id=610e25e2) [12:08:09] Topology snapshot [ver=1, servers=1, clients=0, CPUs=64, heap=2.0GB] [12:08:11] Topology snapshot [ver=2, servers=2, clients=0, CPUs=64, heap=4.0GB] stderr: ============================================================================================ ============================================================================================ [12:08:42,673][SEVERE][client-connector-#197][GridMapQueryExecutor] Failed to execute local query. class org.apache.ignite.IgniteCheckedException: Failed to execute SQL query. at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:968) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1027) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1006) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:516) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:214) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:153) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:151) at org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:2191) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1420) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:733) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$8.iterator(IgniteH2Indexing.java:1212) at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcQueryCursor.<init>(JdbcQueryCursor.java:61) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:311) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:164) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:137) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:39) at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: SELECT __Z0.DATE_SK __C0_0, __Z0.DATE_FIELD __C0_1, __Z0.YEARS __C0_2, __Z0.MONTHS __C0_3, __Z0.DAY_OF_YEAR __C0_4, __Z0.DAY_OF_MONTH __C0_5, __Z0.DAY_OF_WEEK __C0_6, __Z0.WEEK_OF_YEAR __C0_7, __Z0.DAY_OF_WEEK_DESC __C0_8, __Z0.DAY_OF_WEEK_SHORT_DESC __C0_9, __Z0.MONTH_DESC __C0_10, __Z0.MONTH_SHORT_DESC __C0_11, __Z0.QUARTERS __C0_12, __Z0.FULL_FISCAL_YEAR __C0_13, __Z0.FISCAL_MONTH __C0_14, __Z0.FISCAL_QUARTER __C0_15, __Z0.FISCAL_MONTH_SHORTDESC __C0_16, __Z0.FISCAL_YEAR __C0_17, __Z0.PREV_MONTH __C0_18, __Z0.FIN_YEAR __C0_19, __Z0.FIN_QUARTER __C0_20, __Z0.DAY __C0_21, __Z0.MONTH_YEAR __C0_22, __Z0.QUARTER_YEAR __C0_23, __Z0.LAST_DAY_MONTH __C0_24, __Z0.MONTH_CAL_YEAR __C0_25, __Z0.QUARTER_CAL_YEAR __C0_26, __Z0.B_ID __C0_27, __Z0.B_DATE __C0_28, __Z0.PR_KEY __C0_29 FROM PUBLIC.DIM_TIME __Z0 [50000-195] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:295) at org.h2.command.Command.executeQuery(Command.java:215) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:961) ... 26 more Caused by: java.lang.NullPointerException at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl.metadata(CacheObjectBinaryProcessorImpl.java:538) at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl$2.metadata(CacheObjectBinaryProcessorImpl.java:194) at org.apache.ignite.internal.binary.BinaryContext.metadata(BinaryContext.java:1266) at org.apache.ignite.internal.binary.BinaryReaderExImpl.getOrCreateSchema(BinaryReaderExImpl.java:2005) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:284) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:183) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:830) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:845) at org.apache.ignite.internal.binary.BinaryObjectImpl.field(BinaryObjectImpl.java:308) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.fieldValue(QueryBinaryProperty.java:245) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.value(QueryBinaryProperty.java:139) at org.apache.ignite.internal.processors.query.h2.H2RowDescriptor.columnValue(H2RowDescriptor.java:303) at org.apache.ignite.internal.processors.query.h2.opt.GridH2KeyValueRowOnheap.getValue(GridH2KeyValueRowOnheap.java:160) at org.h2.table.TableFilter.getValue(TableFilter.java:1083) at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:186) at org.h2.expression.Alias.getValue(Alias.java:36) at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1459) 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:519) at org.h2.command.dml.Select.queryWithoutCache(Select.java:625) 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:113) at org.h2.command.Command.executeQuery(Command.java:201) ... 28 more [12:08:42,676][SEVERE][client-connector-#197][GridMapQueryExecutor] Failed to run map query on local node. class org.apache.ignite.IgniteCheckedException: Failed to execute SQL query. at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:968) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1027) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1006) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:516) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:214) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:153) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:151) at org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:2191) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1420) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:733) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$8.iterator(IgniteH2Indexing.java:1212) at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcQueryCursor.<init>(JdbcQueryCursor.java:61) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:311) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:164) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:137) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:39) at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: SELECT __Z0.DATE_SK __C0_0, __Z0.DATE_FIELD __C0_1, __Z0.YEARS __C0_2, __Z0.MONTHS __C0_3, __Z0.DAY_OF_YEAR __C0_4, __Z0.DAY_OF_MONTH __C0_5, __Z0.DAY_OF_WEEK __C0_6, __Z0.WEEK_OF_YEAR __C0_7, __Z0.DAY_OF_WEEK_DESC __C0_8, __Z0.DAY_OF_WEEK_SHORT_DESC __C0_9, __Z0.MONTH_DESC __C0_10, __Z0.MONTH_SHORT_DESC __C0_11, __Z0.QUARTERS __C0_12, __Z0.FULL_FISCAL_YEAR __C0_13, __Z0.FISCAL_MONTH __C0_14, __Z0.FISCAL_QUARTER __C0_15, __Z0.FISCAL_MONTH_SHORTDESC __C0_16, __Z0.FISCAL_YEAR __C0_17, __Z0.PREV_MONTH __C0_18, __Z0.FIN_YEAR __C0_19, __Z0.FIN_QUARTER __C0_20, __Z0.DAY __C0_21, __Z0.MONTH_YEAR __C0_22, __Z0.QUARTER_YEAR __C0_23, __Z0.LAST_DAY_MONTH __C0_24, __Z0.MONTH_CAL_YEAR __C0_25, __Z0.QUARTER_CAL_YEAR __C0_26, __Z0.B_ID __C0_27, __Z0.B_DATE __C0_28, __Z0.PR_KEY __C0_29 FROM PUBLIC.DIM_TIME __Z0 [50000-195] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:295) at org.h2.command.Command.executeQuery(Command.java:215) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:961) ... 26 more Caused by: java.lang.NullPointerException at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl.metadata(CacheObjectBinaryProcessorImpl.java:538) at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl$2.metadata(CacheObjectBinaryProcessorImpl.java:194) at org.apache.ignite.internal.binary.BinaryContext.metadata(BinaryContext.java:1266) at org.apache.ignite.internal.binary.BinaryReaderExImpl.getOrCreateSchema(BinaryReaderExImpl.java:2005) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:284) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:183) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:830) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:845) at org.apache.ignite.internal.binary.BinaryObjectImpl.field(BinaryObjectImpl.java:308) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.fieldValue(QueryBinaryProperty.java:245) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.value(QueryBinaryProperty.java:139) at org.apache.ignite.internal.processors.query.h2.H2RowDescriptor.columnValue(H2RowDescriptor.java:303) at org.apache.ignite.internal.processors.query.h2.opt.GridH2KeyValueRowOnheap.getValue(GridH2KeyValueRowOnheap.java:160) at org.h2.table.TableFilter.getValue(TableFilter.java:1083) at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:186) at org.h2.expression.Alias.getValue(Alias.java:36) at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1459) 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:519) at org.h2.command.dml.Select.queryWithoutCache(Select.java:625) 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:113) at org.h2.command.Command.executeQuery(Command.java:201) ... 28 more [12:08:42,680][SEVERE][client-connector-#197][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=100, sqlQry=select * from dim_time, args=[], stmtType=ANY_STATEMENT_TYPE]] javax.cache.CacheException: Failed to run map query remotely. at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:748) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$8.iterator(IgniteH2Indexing.java:1212) at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcQueryCursor.<init>(JdbcQueryCursor.java:61) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:311) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:164) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:137) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:39) at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: javax.cache.CacheException: Failed to execute map query on the node: 610e25e2-4e18-46d3-b856-a15f5b7f8a78, class org.apache.ignite.IgniteCheckedException:Failed to execute SQL query. at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.fail(GridReduceQueryExecutor.java:274) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onFail(GridReduceQueryExecutor.java:264) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onMessage(GridReduceQueryExecutor.java:243) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.sendError(GridMapQueryExecutor.java:854) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:731) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:516) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:214) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:153) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:151) at org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:2191) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1420) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:733) ... 15 more [12:12:26,440][SEVERE][client-connector-#227][GridMapQueryExecutor] Failed to execute local query. class org.apache.ignite.IgniteCheckedException: Failed to execute SQL query. at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:968) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1027) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1006) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:516) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:214) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:153) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:151) at org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:2191) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1420) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:733) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$8.iterator(IgniteH2Indexing.java:1212) at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcQueryCursor.<init>(JdbcQueryCursor.java:61) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:311) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:164) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:137) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:39) at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: SELECT __Z0.DATE_SK __C0_0, __Z0.DATE_FIELD __C0_1, __Z0.YEARS __C0_2, __Z0.MONTHS __C0_3, __Z0.DAY_OF_YEAR __C0_4, __Z0.DAY_OF_MONTH __C0_5, __Z0.DAY_OF_WEEK __C0_6, __Z0.WEEK_OF_YEAR __C0_7, __Z0.DAY_OF_WEEK_DESC __C0_8, __Z0.DAY_OF_WEEK_SHORT_DESC __C0_9, __Z0.MONTH_DESC __C0_10, __Z0.MONTH_SHORT_DESC __C0_11, __Z0.QUARTERS __C0_12, __Z0.FULL_FISCAL_YEAR __C0_13, __Z0.FISCAL_MONTH __C0_14, __Z0.FISCAL_QUARTER __C0_15, __Z0.FISCAL_MONTH_SHORTDESC __C0_16, __Z0.FISCAL_YEAR __C0_17, __Z0.PREV_MONTH __C0_18, __Z0.FIN_YEAR __C0_19, __Z0.FIN_QUARTER __C0_20, __Z0.DAY __C0_21, __Z0.MONTH_YEAR __C0_22, __Z0.QUARTER_YEAR __C0_23, __Z0.LAST_DAY_MONTH __C0_24, __Z0.MONTH_CAL_YEAR __C0_25, __Z0.QUARTER_CAL_YEAR __C0_26, __Z0.B_ID __C0_27, __Z0.B_DATE __C0_28, __Z0.PR_KEY __C0_29 FROM PUBLIC.DIM_TIME __Z0 [50000-195] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:295) at org.h2.command.Command.executeQuery(Command.java:215) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:961) ... 26 more Caused by: java.lang.NullPointerException at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl.metadata(CacheObjectBinaryProcessorImpl.java:538) at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl$2.metadata(CacheObjectBinaryProcessorImpl.java:194) at org.apache.ignite.internal.binary.BinaryContext.metadata(BinaryContext.java:1266) at org.apache.ignite.internal.binary.BinaryReaderExImpl.getOrCreateSchema(BinaryReaderExImpl.java:2005) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:284) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:183) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:830) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:845) at org.apache.ignite.internal.binary.BinaryObjectImpl.field(BinaryObjectImpl.java:308) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.fieldValue(QueryBinaryProperty.java:245) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.value(QueryBinaryProperty.java:139) at org.apache.ignite.internal.processors.query.h2.H2RowDescriptor.columnValue(H2RowDescriptor.java:303) at org.apache.ignite.internal.processors.query.h2.opt.GridH2KeyValueRowOnheap.getValue(GridH2KeyValueRowOnheap.java:160) at org.h2.table.TableFilter.getValue(TableFilter.java:1083) at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:186) at org.h2.expression.Alias.getValue(Alias.java:36) at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1459) 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:519) at org.h2.command.dml.Select.queryWithoutCache(Select.java:625) 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:113) at org.h2.command.Command.executeQuery(Command.java:201) ... 28 more [12:12:26,442][SEVERE][client-connector-#227][GridMapQueryExecutor] Failed to run map query on local node. class org.apache.ignite.IgniteCheckedException: Failed to execute SQL query. at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:968) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1027) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1006) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:516) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:214) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:153) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:151) at org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:2191) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1420) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:733) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$8.iterator(IgniteH2Indexing.java:1212) at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcQueryCursor.<init>(JdbcQueryCursor.java:61) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:311) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:164) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:137) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:39) at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: SELECT __Z0.DATE_SK __C0_0, __Z0.DATE_FIELD __C0_1, __Z0.YEARS __C0_2, __Z0.MONTHS __C0_3, __Z0.DAY_OF_YEAR __C0_4, __Z0.DAY_OF_MONTH __C0_5, __Z0.DAY_OF_WEEK __C0_6, __Z0.WEEK_OF_YEAR __C0_7, __Z0.DAY_OF_WEEK_DESC __C0_8, __Z0.DAY_OF_WEEK_SHORT_DESC __C0_9, __Z0.MONTH_DESC __C0_10, __Z0.MONTH_SHORT_DESC __C0_11, __Z0.QUARTERS __C0_12, __Z0.FULL_FISCAL_YEAR __C0_13, __Z0.FISCAL_MONTH __C0_14, __Z0.FISCAL_QUARTER __C0_15, __Z0.FISCAL_MONTH_SHORTDESC __C0_16, __Z0.FISCAL_YEAR __C0_17, __Z0.PREV_MONTH __C0_18, __Z0.FIN_YEAR __C0_19, __Z0.FIN_QUARTER __C0_20, __Z0.DAY __C0_21, __Z0.MONTH_YEAR __C0_22, __Z0.QUARTER_YEAR __C0_23, __Z0.LAST_DAY_MONTH __C0_24, __Z0.MONTH_CAL_YEAR __C0_25, __Z0.QUARTER_CAL_YEAR __C0_26, __Z0.B_ID __C0_27, __Z0.B_DATE __C0_28, __Z0.PR_KEY __C0_29 FROM PUBLIC.DIM_TIME __Z0 [50000-195] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:295) at org.h2.command.Command.executeQuery(Command.java:215) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:961) ... 26 more Caused by: java.lang.NullPointerException at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl.metadata(CacheObjectBinaryProcessorImpl.java:538) at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl$2.metadata(CacheObjectBinaryProcessorImpl.java:194) at org.apache.ignite.internal.binary.BinaryContext.metadata(BinaryContext.java:1266) at org.apache.ignite.internal.binary.BinaryReaderExImpl.getOrCreateSchema(BinaryReaderExImpl.java:2005) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:284) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:183) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:830) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:845) at org.apache.ignite.internal.binary.BinaryObjectImpl.field(BinaryObjectImpl.java:308) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.fieldValue(QueryBinaryProperty.java:245) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.value(QueryBinaryProperty.java:139) at org.apache.ignite.internal.processors.query.h2.H2RowDescriptor.columnValue(H2RowDescriptor.java:303) at org.apache.ignite.internal.processors.query.h2.opt.GridH2KeyValueRowOnheap.getValue(GridH2KeyValueRowOnheap.java:160) at org.h2.table.TableFilter.getValue(TableFilter.java:1083) at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:186) at org.h2.expression.Alias.getValue(Alias.java:36) at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1459) 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:519) at org.h2.command.dml.Select.queryWithoutCache(Select.java:625) 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:113) at org.h2.command.Command.executeQuery(Command.java:201) ... 28 more [12:12:26,443][SEVERE][client-connector-#227][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry= select * from dim_time, args=[], stmtType=ANY_STATEMENT_TYPE]] javax.cache.CacheException: Failed to run map query remotely. at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:748) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$8.iterator(IgniteH2Indexing.java:1212) at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcQueryCursor.<init>(JdbcQueryCursor.java:61) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:311) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:164) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:137) at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:39) at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: javax.cache.CacheException: Failed to execute map query on the node: 610e25e2-4e18-46d3-b856-a15f5b7f8a78, class org.apache.ignite.IgniteCheckedException:Failed to execute SQL query. at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.fail(GridReduceQueryExecutor.java:274) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onFail(GridReduceQueryExecutor.java:264) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onMessage(GridReduceQueryExecutor.java:243) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.sendError(GridMapQueryExecutor.java:854) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:731) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:516) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:214) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:153) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:151) at org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:2191) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1420) at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:733) ... 15 more
stdout: ============================================================================================ ============================================================================================ [12:08:04] __________ ________________ [12:08:04] / _/ ___/ |/ / _/_ __/ __/ [12:08:04] _/ // (7 7 // / / / / _/ [12:08:04] /___/\___/_/|_/___/ /_/ /___/ [12:08:04] [12:08:04] ver. 2.3.0#20171028-sha1:8add7fd5 [12:08:04] 2017 Copyright(C) Apache Software Foundation [12:08:04] [12:08:04] Ignite documentation: http://ignite.apache.org [12:08:04] [12:08:04] Quiet mode. [12:08:04] ^-- Logging to file '/tmp2/usercache/pragmatix/appcache/application_1516353511232_0156/container_e168_1516353511232_0156_01_000003/ignite/apache-ignite-fabric-2.3.0-bin/work/log/ignite-7f77319b.0.log' [12:08:04] ^-- To see **FULL** console log here add -DIGNITE_QUIET=false or "-v" to ignite.{sh|bat} [12:08:04] [12:08:04] OS: Linux 4.4.0-109-generic amd64 [12:08:04] VM information: Java(TM) SE Runtime Environment 1.8.0_112-b15 Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.112-b15 [12:08:04] Configured plugins: [12:08:04] ^-- None [12:08:04] [12:08:04] Message queue limit is set to 0 which may lead to potential OOMEs when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to message queues growth on sender and receiver sides. [12:08:04] Security status [authentication=off, tls/ssl=off] [12:08:11] Performance suggestions for grid (fix if possible) [12:08:11] To disable, set -DIGNITE_PERFORMANCE_SUGGESTIONS_DISABLED=true [12:08:11] ^-- Enable G1 Garbage Collector (add '-XX:+UseG1GC' to JVM options) [12:08:11] ^-- Set max direct memory size if getting 'OOME: Direct buffer memory' (add '-XX:MaxDirectMemorySize=<size>[g|G|m|M|k|K]' to JVM options) [12:08:11] ^-- Disable processing of calls to System.gc() (add '-XX:+DisableExplicitGC' to JVM options) [12:08:11] Refer to this page for more performance suggestions: https://apacheignite.readme.io/docs/jvm-and-system-tuning [12:08:11] [12:08:11] To start Console Management & Monitoring run ignitevisorcmd.{sh|bat} [12:08:11] [12:08:11] Ignite node started OK (id=7f77319b) [12:08:11] Topology snapshot [ver=2, servers=2, clients=0, CPUs=64, heap=4.0GB] stderr: ============================================================================================ ============================================================================================ [12:08:42,714][SEVERE][query-#193][GridMapQueryExecutor] Failed to execute local query. class org.apache.ignite.IgniteCheckedException: Failed to execute SQL query. at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:968) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1027) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1006) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:516) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:214) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:174) at org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2332) at org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1555) at org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1183) at org.apache.ignite.internal.managers.communication.GridIoManager.access$4200(GridIoManager.java:126) at org.apache.ignite.internal.managers.communication.GridIoManager$9.run(GridIoManager.java:1090) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: SELECT __Z0.DATE_SK __C0_0, __Z0.DATE_FIELD __C0_1, __Z0.YEARS __C0_2, __Z0.MONTHS __C0_3, __Z0.DAY_OF_YEAR __C0_4, __Z0.DAY_OF_MONTH __C0_5, __Z0.DAY_OF_WEEK __C0_6, __Z0.WEEK_OF_YEAR __C0_7, __Z0.DAY_OF_WEEK_DESC __C0_8, __Z0.DAY_OF_WEEK_SHORT_DESC __C0_9, __Z0.MONTH_DESC __C0_10, __Z0.MONTH_SHORT_DESC __C0_11, __Z0.QUARTERS __C0_12, __Z0.FULL_FISCAL_YEAR __C0_13, __Z0.FISCAL_MONTH __C0_14, __Z0.FISCAL_QUARTER __C0_15, __Z0.FISCAL_MONTH_SHORTDESC __C0_16, __Z0.FISCAL_YEAR __C0_17, __Z0.PREV_MONTH __C0_18, __Z0.FIN_YEAR __C0_19, __Z0.FIN_QUARTER __C0_20, __Z0.DAY __C0_21, __Z0.MONTH_YEAR __C0_22, __Z0.QUARTER_YEAR __C0_23, __Z0.LAST_DAY_MONTH __C0_24, __Z0.MONTH_CAL_YEAR __C0_25, __Z0.QUARTER_CAL_YEAR __C0_26, __Z0.B_ID __C0_27, __Z0.B_DATE __C0_28, __Z0.PR_KEY __C0_29 FROM PUBLIC.DIM_TIME __Z0 [50000-195] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:295) at org.h2.command.Command.executeQuery(Command.java:215) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:961) ... 14 more Caused by: java.lang.NullPointerException at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl.metadata(CacheObjectBinaryProcessorImpl.java:538) at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl$2.metadata(CacheObjectBinaryProcessorImpl.java:194) at org.apache.ignite.internal.binary.BinaryContext.metadata(BinaryContext.java:1266) at org.apache.ignite.internal.binary.BinaryReaderExImpl.getOrCreateSchema(BinaryReaderExImpl.java:2005) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:284) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:183) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:830) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:845) at org.apache.ignite.internal.binary.BinaryObjectImpl.field(BinaryObjectImpl.java:308) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.fieldValue(QueryBinaryProperty.java:245) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.value(QueryBinaryProperty.java:139) at org.apache.ignite.internal.processors.query.h2.H2RowDescriptor.columnValue(H2RowDescriptor.java:303) at org.apache.ignite.internal.processors.query.h2.opt.GridH2KeyValueRowOnheap.getValue(GridH2KeyValueRowOnheap.java:160) at org.h2.table.TableFilter.getValue(TableFilter.java:1083) at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:186) at org.h2.expression.Alias.getValue(Alias.java:36) at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1459) 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:519) at org.h2.command.dml.Select.queryWithoutCache(Select.java:625) 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:113) at org.h2.command.Command.executeQuery(Command.java:201) ... 16 more [12:12:26,443][SEVERE][query-#221][GridMapQueryExecutor] Failed to execute local query. class org.apache.ignite.IgniteCheckedException: Failed to execute SQL query. at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:968) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1027) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1006) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:516) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:214) at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:174) at org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2332) at org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1555) at org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1183) at org.apache.ignite.internal.managers.communication.GridIoManager.access$4200(GridIoManager.java:126) at org.apache.ignite.internal.managers.communication.GridIoManager$9.run(GridIoManager.java:1090) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: SELECT __Z0.DATE_SK __C0_0, __Z0.DATE_FIELD __C0_1, __Z0.YEARS __C0_2, __Z0.MONTHS __C0_3, __Z0.DAY_OF_YEAR __C0_4, __Z0.DAY_OF_MONTH __C0_5, __Z0.DAY_OF_WEEK __C0_6, __Z0.WEEK_OF_YEAR __C0_7, __Z0.DAY_OF_WEEK_DESC __C0_8, __Z0.DAY_OF_WEEK_SHORT_DESC __C0_9, __Z0.MONTH_DESC __C0_10, __Z0.MONTH_SHORT_DESC __C0_11, __Z0.QUARTERS __C0_12, __Z0.FULL_FISCAL_YEAR __C0_13, __Z0.FISCAL_MONTH __C0_14, __Z0.FISCAL_QUARTER __C0_15, __Z0.FISCAL_MONTH_SHORTDESC __C0_16, __Z0.FISCAL_YEAR __C0_17, __Z0.PREV_MONTH __C0_18, __Z0.FIN_YEAR __C0_19, __Z0.FIN_QUARTER __C0_20, __Z0.DAY __C0_21, __Z0.MONTH_YEAR __C0_22, __Z0.QUARTER_YEAR __C0_23, __Z0.LAST_DAY_MONTH __C0_24, __Z0.MONTH_CAL_YEAR __C0_25, __Z0.QUARTER_CAL_YEAR __C0_26, __Z0.B_ID __C0_27, __Z0.B_DATE __C0_28, __Z0.PR_KEY __C0_29 FROM PUBLIC.DIM_TIME __Z0 [50000-195] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:295) at org.h2.command.Command.executeQuery(Command.java:215) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:961) ... 14 more Caused by: java.lang.NullPointerException at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl.metadata(CacheObjectBinaryProcessorImpl.java:538) at org.apache.ignite.internal.processors.cache.binary.CacheObjectBinaryProcessorImpl$2.metadata(CacheObjectBinaryProcessorImpl.java:194) at org.apache.ignite.internal.binary.BinaryContext.metadata(BinaryContext.java:1266) at org.apache.ignite.internal.binary.BinaryReaderExImpl.getOrCreateSchema(BinaryReaderExImpl.java:2005) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:284) at org.apache.ignite.internal.binary.BinaryReaderExImpl.<init>(BinaryReaderExImpl.java:183) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:830) at org.apache.ignite.internal.binary.BinaryObjectImpl.reader(BinaryObjectImpl.java:845) at org.apache.ignite.internal.binary.BinaryObjectImpl.field(BinaryObjectImpl.java:308) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.fieldValue(QueryBinaryProperty.java:245) at org.apache.ignite.internal.processors.query.property.QueryBinaryProperty.value(QueryBinaryProperty.java:139) at org.apache.ignite.internal.processors.query.h2.H2RowDescriptor.columnValue(H2RowDescriptor.java:303) at org.apache.ignite.internal.processors.query.h2.opt.GridH2KeyValueRowOnheap.getValue(GridH2KeyValueRowOnheap.java:160) at org.h2.table.TableFilter.getValue(TableFilter.java:1083) at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:186) at org.h2.expression.Alias.getValue(Alias.java:36) at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1459) 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:519) at org.h2.command.dml.Select.queryWithoutCache(Select.java:625) 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:113) at org.h2.command.Command.executeQuery(Command.java:201) ... 16 more
ignite-cluster.properties
Description: Binary data
<?xml version="1.0" encoding="UTF-8"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<beans xmlns="http://www.springframework.org/schema/beans";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd";>
<bean id="ignite.cfg" class="org.apache.ignite.configuration.IgniteConfiguration">
<property name="peerClassLoadingEnabled" value="true"/>
<!-- Enabling Apache Ignite Persistent Store. -->
<property name="dataStorageConfiguration">
<bean class="org.apache.ignite.configuration.DataStorageConfiguration">
<property name="storagePath" value="/pragmatix/apache-ignite/apache-ignite-fabric-2.3.0-bin/work/"/>
<property name="walPath" value="/pragmatix/apache-ignite/apache-ignite-fabric-2.3.0-bin/work/wal"/>
<property name="defaultDataRegionConfiguration">
<bean class="org.apache.ignite.configuration.DataRegionConfiguration">
<property name="persistenceEnabled" value="true"/>
</bean>
</property>
</bean>
</property>
<!-- Explicitly configure TCP discovery SPI to provide a list of initial nodes. -->
<property name="discoverySpi">
<bean class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi">
<property name="ipFinder">
<!-- Uncomment static IP finder to enable static-based discovery of initial nodes. -->
<!--<bean class="org.apache.ignite.spi.discovery.tcp.ipfinder.vm.TcpDiscoveryVmIpFinder">-->
<bean class="org.apache.ignite.spi.discovery.tcp.ipfinder.multicast.TcpDiscoveryMulticastIpFinder">
<property name="addresses">
<list>
<!-- In distributed environment, replace with actual host IP address. -->
<value>127.0.0.1:47500..47600</value>
</list>
</property>
</bean>
</property>
</bean>
</property>
</bean>
</beans>
