"Failed to update keys" error

2021-07-19 Thread y
Hi Igniters:
  I have a very strange problem. I have two code environment:One is the 
simplest program (a "Hello world" program),can execute SQL statements 
correctly。Another code environment is the formal system, which use Spring Boot 
and a custom class loader named CAFClassLoader.  The DML statement cannot be 
executed on formal system , but the DQL statement can be executed (‘select 
..’ is OK ). Part of error messages are as follows.


What makes me confused is that the code of the two environments is the same!   
I really can't figure out why. Does anyone know why? Attached is the code and 
complete error information.


Error message
Caused by: java.sql.SQLException: Failed to update keys (retry update if 
possible).: [2]
at 
org.apache.ignite.internal.processors.query.h2.dml.DmlBatchSender.processPage(DmlBatchSender.java:248)
at 
org.apache.ignite.internal.processors.query.h2.dml.DmlBatchSender.sendBatch(DmlBatchSender.java:196)
at 
org.apache.ignite.internal.processors.query.h2.dml.DmlBatchSender.add(DmlBatchSender.java:124)
at 
org.apache.ignite.internal.processors.query.h2.dml.DmlUtils.doUpdate(DmlUtils.java:255)
... 143 more
Caused by: class 
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to 
update keys (retry update if possible).: [2]
at 
org.apache.ignite.internal.processors.query.h2.dml.DmlUtils.doUpdate(DmlUtils.java:280)
at 
org.apache.ignite.internal.processors.query.h2.dml.DmlUtils.processSelectResult(DmlUtils.java:171)
at 
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeUpdateNonTransactional(IgniteH2Indexing.java:2899)
at 
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeUpdate(IgniteH2Indexing.java:2753)
at 
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeUpdateDistributed(IgniteH2Indexing.java:2683)
at 
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeDml(IgniteH2Indexing.java:1186)
at 
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1112)
at 
org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2779)
at 
org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2775)
at 
org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
at 
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:3338)
at 
org.apache.ignite.internal.processors.query.GridQueryProcessor.lambda$querySqlFields$2(GridQueryProcessor.java:2795)
at 
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuerySafe(GridQueryProcessor.java:2833)
at 
org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2769)
at 
org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2696)
at 
org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:819)
... 128 more
Caused by: java.sql.SQLException: Failed to update keys (retry update if 
possible).: [2]
at 
org.apache.ignite.internal.processors.query.h2.dml.DmlBatchSender.processPage(DmlBatchSender.java:248)
at 
org.apache.ignite.internal.processors.query.h2.dml.DmlBatchSender.sendBatch(DmlBatchSender.java:196)
at 
org.apache.ignite.internal.processors.query.h2.dml.DmlBatchSender.add(DmlBatchSender.java:124)
at 
org.apache.ignite.internal.processors.query.h2.dml.DmlUtils.doUpdate(DmlUtils.java:255)
... 143 more
Caused by: class 
org.apache.ignite.internal.processors.cache.CachePartialUpdateCheckedException: 
Failed to update keys (retry update if possible).: [2]
at 
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicAbstractUpdateFuture.onPrimaryError(GridNearAtomicAbstractUpdateFuture.java:397)
at 
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicUpdateFuture.onPrimaryResponse(GridNearAtomicUpdateFuture.java:413)
at 
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicAbstractUpdateFuture.onSendError(GridNearAtomicAbstractUpdateFuture.java:489)
at 
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicAbstractUpdateFuture.sendSingleRequest(GridNearAtomicAbstractUpdateFuture.java:326)
at 
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicUpdateFuture.map(GridNearAtomicUpdateFuture.java:814)
at 
org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicUpdateFuture.mapOnTopology(GridNearAtomicUpdateFuture.java:666)
at 
org.apache.ignite.internal.processors.cache.distributed.dht.atomic

[MEETUP] Join Apache Ignite 3.0 Alpha 2 Build Demo on July 20

2021-07-19 Thread Kseniya Romanova
Hi Igniters, if you'd like to  get an update on Ignite 3.0 progress and
overview the following stages of development join community gathering on
July 20:  https://hopin.to/events/apache-ignite-3-alpha

TIMEZONES
9 AM Pacific Standard Time
12 PM Eastern Standard Time
5 PM British Summer Time
6 PM Central European Summer Time
7 PM Israel Standard Time
7 PM Moscow Time
9:30 PM Indian Standard Time

Links:
[1] The Alpha build of the next Apache Ignite major version is available
for internal testing at https://github.com/apache/ignite-3
[2] Discussion
http://mail-archives.apache.org/mod_mbox/ignite-user/202101.mbox/%3CCABuYRcpgKQvTJDhSvqHOzKWJf5wN-mLKUHiNR5qyaNLvLsds8w%40mail.gmail.com%3E
[3] Wiki Page
https://cwiki.apache.org/confluence/display/IGNITE/Apache+Ignite+3.0
[4] Getting Started Guide:
https://ignite.apache.org/docs/3.0.0-alpha/quick-start/getting-started-guide
[5] Apache Ignite 3.0: Major Changes and Features presentation
https://youtu.be/zPuLJgUfLaM
[6] Ignite 3.0 Alpha 1 Community Gathering https://youtu.be/zAVmKGRa1Jc

Cheers,
Kseniya

Devrel at GridGain
Don't miss upcoming community events, join
https://www.meetup.com/Apache-Ignite-Virtual-Meetup/