[IGNITE-14256] SQL delete statement ignores skipOnReduce and local flags for replicated caches

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.9.1
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Pavel Vinokurov
• Created: 01/Mar/21 05:16
• Updated: 01/Mar/21 06:51

Description

Delete statement removes data from all nodes ignoring enabled lazy and skipOnReduce flags.
The reproducer is attached.

Below the stacktrace

"sys-stripe-4-#68%5f5ea90d-6614-448f-9df7-0d770f0b216d%" #111 prio=5 os_prio=0 tid=0x00007fbac1d59000 nid=0x7329 runnable [0x00007fba8c7ed000]
   java.lang.Thread.State: RUNNABLE
	at sun.nio.ch.EPollArrayWrapper.interrupt(Native Method)
	at sun.nio.ch.EPollArrayWrapper.interrupt(EPollArrayWrapper.java:317)
	at sun.nio.ch.EPollSelectorImpl.wakeup(EPollSelectorImpl.java:207)
	- locked <0x00000005cc4475f8> (a java.lang.Object)
	at org.apache.ignite.internal.util.nio.GridNioServer$AbstractNioClientWorker.offer(GridNioServer.java:1988)
	at org.apache.ignite.internal.util.nio.GridNioServer.send0(GridNioServer.java:652)
	at org.apache.ignite.internal.util.nio.GridNioServer.send(GridNioServer.java:620)
	at org.apache.ignite.internal.util.nio.GridNioServer$HeadFilter.onSessionWrite(GridNioServer.java:3704)
	at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedSessionWrite(GridNioFilterAdapter.java:120)
	at org.apache.ignite.internal.util.nio.GridConnectionBytesVerifyFilter.onSessionWrite(GridConnectionBytesVerifyFilter.java:80)
	at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedSessionWrite(GridNioFilterAdapter.java:120)
	at org.apache.ignite.internal.util.nio.GridNioCodecFilter.onSessionWrite(GridNioCodecFilter.java:90)
	at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedSessionWrite(GridNioFilterAdapter.java:120)
	at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onSessionWrite(GridNioFilterChain.java:268)
	at org.apache.ignite.internal.util.nio.GridNioFilterChain.onSessionWrite(GridNioFilterChain.java:191)
	at org.apache.ignite.internal.util.nio.GridNioSessionImpl.sendNoFuture(GridNioSessionImpl.java:129)
	at org.apache.ignite.internal.util.nio.GridTcpNioCommunicationClient.sendMessage(GridTcpNioCommunicationClient.java:115)
	at org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi.sendMessage0(TcpCommunicationSpi.java:1182)
	at org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi.sendMessage(TcpCommunicationSpi.java:1124)
	at org.apache.ignite.internal.managers.communication.GridIoManager.send(GridIoManager.java:1809)
	at org.apache.ignite.internal.managers.communication.GridIoManager.sendToGridTopic(GridIoManager.java:1923)
	at org.apache.ignite.internal.processors.cache.GridCacheIoManager.send(GridCacheIoManager.java:1257)
	at org.apache.ignite.internal.processors.cache.GridCacheIoManager.send(GridCacheIoManager.java:1296)
	at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicAbstractUpdateFuture.sendDhtRequests(GridDhtAtomicAbstractUpdateFuture.java:489)
	at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicAbstractUpdateFuture.map(GridDhtAtomicAbstractUpdateFuture.java:445)
	at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateAllAsyncInternal0(GridDhtAtomicCache.java:1926)
	at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.updateAllAsyncInternal(GridDhtAtomicCache.java:1679)
	at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.processNearAtomicUpdateRequest(GridDhtAtomicCache.java:3190)
	at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.access$400(GridDhtAtomicCache.java:151)
	at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache$5.apply(GridDhtAtomicCache.java:286)
	at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache$5.apply(GridDhtAtomicCache.java:281)
	at org.apache.ignite.internal.processors.cache.GridCacheIoManager.processMessage(GridCacheIoManager.java:1142)
	at org.apache.ignite.internal.processors.cache.GridCacheIoManager.onMessage0(GridCacheIoManager.java:591)
	at org.apache.ignite.internal.processors.cache.GridCacheIoManager.handleMessage(GridCacheIoManager.java:392)
	at org.apache.ignite.internal.processors.cache.GridCacheIoManager.handleMessage(GridCacheIoManager.java:318)
	at org.apache.ignite.internal.processors.cache.GridCacheIoManager.access$100(GridCacheIoManager.java:109)
	at org.apache.ignite.internal.processors.cache.GridCacheIoManager$1.onMessage(GridCacheIoManager.java:308)
	at org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1719)
	at org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1326)
	at org.apache.ignite.internal.managers.communication.GridIoManager.access$4600(GridIoManager.java:157)
	at org.apache.ignite.internal.managers.communication.GridIoManager$8.execute(GridIoManager.java:1211)
	at org.apache.ignite.internal.managers.communication.TraceRunnable.run(TraceRunnable.java:54)
	at org.apache.ignite.internal.util.StripedExecutor$Stripe.body(StripedExecutor.java:564)
	at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:119)
	at java.lang.Thread.run(Thread.java:748)