[jira] [Commented] (IGNITE-4313) DML: update causes IgniteCheckedException: Not enough data to read the value
[ https://issues.apache.org/jira/browse/IGNITE-4313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15701346#comment-15701346 ] Sergey Kozlov commented on IGNITE-4313: --- I agree. Let's close to for now. > DML: update causes IgniteCheckedException: Not enough data to read the value > > > Key: IGNITE-4313 > URL: https://issues.apache.org/jira/browse/IGNITE-4313 > Project: Ignite > Issue Type: Bug > Components: general >Affects Versions: 1.8 >Reporter: Sergey Kozlov >Assignee: Sergey Kozlov > Fix For: 1.8 > > Attachments: IGNITE-4313.zip > > > 0. Extract teh attachment in {{examples}} directory. > 1. Start node {{ExtSqlExampleNodeStartup}} > 2. Run {{ExtSqlExample}}. It failed: > {noformat} > Processing the caches... > Exception in thread "main" javax.cache.CacheException: Failed to run map > query remotely. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:652) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$5.iterator(IgniteH2Indexing.java:1119) > at > org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:98) > at > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.doUpdate(DmlStatementsProcessor.java:483) > at > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.executeUpdateStatement(DmlStatementsProcessor.java:256) > at > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFields(DmlStatementsProcessor.java:134) > at > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFieldsTwoStep(DmlStatementsProcessor.java:160) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:1266) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:812) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:810) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1765) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:810) > at > org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:749) > at > org.apache.ignite.examples.datagrid.ExtSqlExample.main(ExtSqlExample.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at com.intellij.rt.execution.application.AppMain.main(AppMain.java:140) > Caused by: javax.cache.CacheException: Failed to execute map query on the > node: 104496cc-dd94-4150-90de-8628c2ddf6ff, class > org.apache.ignite.IgniteCheckedException:Failed to execute SQL query. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.fail(GridReduceQueryExecutor.java:278) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onFail(GridReduceQueryExecutor.java:268) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onMessage(GridReduceQueryExecutor.java:249) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$2.onMessage(GridReduceQueryExecutor.java:197) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:1915) > at > org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1082) > at > org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:710) > at > org.apache.ignite.internal.managers.communication.GridIoManager.access$1700(GridIoManager.java:102) > at > org.apache.ignite.internal.managers.communication.GridIoManager$5.run(GridIoManager.java:673) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > [16:10:49] Ignite node stopped OK [uptime=00:00:00:372] > Process finished with exit code 1 > {noformat} > Exception on the node: > {noforma
[jira] [Commented] (IGNITE-4313) DML: update causes IgniteCheckedException: Not enough data to read the value
[ https://issues.apache.org/jira/browse/IGNITE-4313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15698206#comment-15698206 ] Alexander Paschenko commented on IGNITE-4313: - Example fails because of this query {code:sql} update AllTypes set intCol = 1 where _val = ? {code} {{_val}} is of type {{AllTypes}}, and argument is a {{Long}}, so query should rather be {code:sql} update AllTypes set intCol = 1 where longCol = ? {code} When corrected, the error disappears. Will think about additional type checks for more informative exceptions. > DML: update causes IgniteCheckedException: Not enough data to read the value > > > Key: IGNITE-4313 > URL: https://issues.apache.org/jira/browse/IGNITE-4313 > Project: Ignite > Issue Type: Bug > Components: general >Affects Versions: 1.8 >Reporter: Sergey Kozlov > Fix For: 1.8 > > Attachments: IGNITE-4313.zip > > > 0. Extract teh attachment in {{examples}} directory. > 1. Start node {{ExtSqlExampleNodeStartup}} > 2. Run {{ExtSqlExample}}. It failed: > {noformat} > Processing the caches... > Exception in thread "main" javax.cache.CacheException: Failed to run map > query remotely. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:652) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$5.iterator(IgniteH2Indexing.java:1119) > at > org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:98) > at > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.doUpdate(DmlStatementsProcessor.java:483) > at > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.executeUpdateStatement(DmlStatementsProcessor.java:256) > at > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFields(DmlStatementsProcessor.java:134) > at > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFieldsTwoStep(DmlStatementsProcessor.java:160) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:1266) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:812) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:810) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1765) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:810) > at > org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:749) > at > org.apache.ignite.examples.datagrid.ExtSqlExample.main(ExtSqlExample.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at com.intellij.rt.execution.application.AppMain.main(AppMain.java:140) > Caused by: javax.cache.CacheException: Failed to execute map query on the > node: 104496cc-dd94-4150-90de-8628c2ddf6ff, class > org.apache.ignite.IgniteCheckedException:Failed to execute SQL query. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.fail(GridReduceQueryExecutor.java:278) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onFail(GridReduceQueryExecutor.java:268) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.onMessage(GridReduceQueryExecutor.java:249) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$2.onMessage(GridReduceQueryExecutor.java:197) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:1915) > at > org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1082) > at > org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:710) > at > org.apache.ignite.internal.managers.communication.GridIoManager.access$1700(GridIoManager.java:102) > at > org.apache.ignite.internal.managers.communication.GridIoManager$5.run(GridIoManager.java:673) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(Thr