Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-18379

Sql. Insertions failed with "Replication is timed out".

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Cannot Reproduce
    • 3.0.0-beta1
    • None
    • general

    Description

      Near sql will fail with :

      org.apache.ignite.lang.IgniteException: IGN-CMN-65535 TraceId:2768796b-10d7-4c8f-8faf-b86ae9779660 Error at: (test_order_same_value.test_slow_ignore:72). Statement: Statement [queries=[INSERT INTO integers SELECT * FROM integers], expected=OK]

	at org.apache.ignite.internal.sqllogic.SqlScriptRunner$Statement.execute(SqlScriptRunner.java:460)
	at org.apache.ignite.internal.sqllogic.SqlScriptRunner.run(SqlScriptRunner.java:153)
	at org.junit.jupiter.api.AssertTimeout.lambda$assertTimeoutPreemptively$2(AssertTimeout.java:102)
	at org.junit.jupiter.api.AssertTimeout.lambda$assertTimeoutPreemptively$4(AssertTimeout.java:138)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.apache.ignite.tx.TransactionException: IGN-REP-3 TraceId:c3fb1ef4-14cd-4943-8f97-eb035d9f2ed6 IGN-REP-3 TraceId:c3fb1ef4-14cd-4943-8f97-eb035d9f2ed6 Replication is timed out [replicaGrpId=6debc582-3ad7-4350-856d-f6bfb379c3ee_part_0]
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
	at org.apache.ignite.lang.IgniteException.wrap(IgniteException.java:277)
	at org.apache.ignite.sql.Session.execute(Session.java:59)
	at org.apache.ignite.internal.sqllogic.SqlScriptRunner.sql(SqlScriptRunner.java:171)
	at org.apache.ignite.internal.sqllogic.SqlScriptRunner$Statement.execute(SqlScriptRunner.java:453)
	... 7 more
Caused by: org.apache.ignite.tx.TransactionException: IGN-REP-3 TraceId:c3fb1ef4-14cd-4943-8f97-eb035d9f2ed6 Replication is timed out [replicaGrpId=6debc582-3ad7-4350-856d-f6bfb379c3ee_part_0]
	at org.apache.ignite.internal.util.ExceptionUtils.lambda$withCause$0(ExceptionUtils.java:346)
	at org.apache.ignite.internal.util.ExceptionUtils.withCauseInternal(ExceptionUtils.java:429)
	at org.apache.ignite.internal.util.ExceptionUtils.withCause(ExceptionUtils.java:346)
	at org.apache.ignite.internal.tx.impl.IgniteAbstractTransactionImpl.commit(IgniteAbstractTransactionImpl.java:74)
	at org.apache.ignite.internal.sql.engine.AsyncSqlCursorImpl.lambda$requestNextAsync$0(AsyncSqlCursorImpl.java:82)
	at java.base/java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:930)
	at java.base/java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:907)
	at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
	at java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2073)
	at org.apache.ignite.internal.sql.engine.exec.rel.AsyncRootNode.flush(AsyncRootNode.java:224)
	at org.apache.ignite.internal.sql.engine.exec.rel.AsyncRootNode.end(AsyncRootNode.java:134)
	at org.apache.ignite.internal.sql.engine.exec.rel.ModifyNode.tryEnd(ModifyNode.java:196)
	at org.apache.ignite.internal.sql.engine.exec.rel.ModifyNode.end(ModifyNode.java:154)
	at org.apache.ignite.internal.sql.engine.exec.rel.TableScanNode.push(TableScanNode.java:200)
	at org.apache.ignite.internal.sql.engine.exec.rel.TableScanNode$SubscriberImpl.lambda$onComplete$2(TableScanNode.java:271)
	at org.apache.ignite.internal.sql.engine.exec.ExecutionContext.lambda$execute$0(ExecutionContext.java:306)
	at org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:80)
	... 3 more
Caused by: java.util.concurrent.ExecutionException: org.apache.ignite.internal.replicator.exception.ReplicationTimeoutException: IGN-REP-3 TraceId:c3fb1ef4-14cd-4943-8f97-eb035d9f2ed6 Replication is timed out [replicaGrpId=6debc582-3ad7-4350-856d-f6bfb379c3ee_part_0]
	at java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:395)
	at java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1999)
	at org.apache.ignite.internal.tx.impl.IgniteAbstractTransactionImpl.commit(IgniteAbstractTransactionImpl.java:72)
	... 16 more
Caused by: org.apache.ignite.internal.replicator.exception.ReplicationTimeoutException: IGN-REP-3 TraceId:c3fb1ef4-14cd-4943-8f97-eb035d9f2ed6 Replication is timed out [replicaGrpId=6debc582-3ad7-4350-856d-f6bfb379c3ee_part_0]
	at org.apache.ignite.internal.replicator.ReplicaService.lambda$sendToReplica$4(ReplicaService.java:98)
	at java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:859)
	at java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837)
	at java.base/java.util.concurrent.CompletableFuture$Completion.exec(CompletableFuture.java:479)
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290)
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020)
	at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656)
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594)
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183)



      CREATE TABLE integers(i INTEGER)

INSERT INTO integers VALUES (0), (0), (0), (0)

# 4 -> 8
INSERT INTO integers SELECT * FROM integers

# 8 -> 16
INSERT INTO integers SELECT * FROM integers

# 16 -> 32
INSERT INTO integers SELECT * FROM integers

# 32 -> 64
INSERT INTO integers SELECT * FROM integers

# 64 -> 128
INSERT INTO integers SELECT * FROM integers

# 128 -> 256
INSERT INTO integers SELECT * FROM integers

# 256 -> 512
INSERT INTO integers SELECT * FROM integers

# 512 -> 1024
INSERT INTO integers SELECT * FROM integers

# 1024 -> 2048
INSERT INTO integers SELECT * FROM integers

# 2048 -> 4096
INSERT INTO integers SELECT * FROM integers

# 4096 -> 8192
INSERT INTO integers SELECT * FROM integers

# 8192 -> 16384
INSERT INTO integers SELECT * FROM integers

# 16384 -> 32768
INSERT INTO integers SELECT * FROM integers

# 32768 -> 65536
INSERT INTO integers SELECT * FROM integers

# 65536 -> 131072
INSERT INTO integers SELECT * FROM integers

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-19247 BatchUpdateException: Replication is timed out" upon inserting rows in batches via JDBC

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved
          links to

          Web Link GitHub Pull Request #1941

          Activity

            People

              Unassigned Unassigned
              zstan Evgeny Stanilovsky
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10m
                  10m