Konstantin Orlov created IGNITE-28226:
-----------------------------------------
Summary: Latency spikes on INSERT due to checkpoint
Key: IGNITE-28226
URL: https://issues.apache.org/jira/browse/IGNITE-28226
Project: Ignite
Issue Type: Bug
Components: storage engines ai3
Affects Versions: 3.1
Reporter: Konstantin Orlov
Attachments: InsertTest-1.java
See the attached reproduced (you may add this class as {{intergationTest}} of
JDBC module).
In short, this test open JDBC connection and then executes multiple times
following sequence:
# Creates table
# Loads 10k rows by batches of 500 rows
# Drops table
Starting from the 2nd iteration, execution time for some batches increases in
x10-15 times. Every time such increases happens right after checkpoint and/or
compaction:
{code}
[2026-03-13T14:09:54,506][WARN ][main][TestLogger] Orders loading iteration
completed in: 48.70 ms
[2026-03-13T14:09:54,553][WARN ][main][TestLogger] Orders loading iteration
completed in: 46.29 ms
[2026-03-13T14:09:54,593][WARN ][main][TestLogger] Orders loading iteration
completed in: 39.10 ms
[2026-03-13T14:09:54,604][INFO ][%test%checkpoint-thread][Checkpointer]
Checkpoint started [checkpointId=7114cf7e-851e-4c14-8dd6-66df8d6bce48,
beforeWriteLockTime=1ms, writeLockWait=0us, beforeCheckpointBeginTime=1406us,
markCheckpointBeginTime=132us, writeLockHoldTime=166us,
splitAndSortPagesDuration=0ms, pages=954, reason='Triggered by replicator']
[2026-03-13T14:09:55,011][INFO ][%test%checkpoint-thread][Checkpointer]
Checkpoint finished [checkpointId=7114cf7e-851e-4c14-8dd6-66df8d6bce48,
writtenPages=954, fsyncFiles=132, pagesWriteTime=9ms, fsyncTime=393ms,
replicatorLogSyncTime=3ms, waitCompletePageReplacementTime=0ms,
totalTime=408ms, avgIoWriteSpeed=37MB/s, avgWriteSpeed=36MB/s]
[2026-03-13T14:09:55,014][INFO ][%test%compaction-thread][Compactor] Starting
new compaction round [compactionId=d7b2d9a9-c6eb-4964-8f56-4b225b119816,
files=66]
[2026-03-13T14:09:55,303][INFO ][%test%compaction-thread][Compactor] Compaction
round finished [compactionId=d7b2d9a9-c6eb-4964-8f56-4b225b119816, pages=269,
skipped=0, duration=288ms, avgWriteSpeed=15MB/s]
[2026-03-13T14:09:55,333][WARN ][main][TestLogger] Orders loading iteration
completed in: 738.9 ms
[2026-03-13T14:09:55,383][WARN ][main][TestLogger] Orders loading iteration
completed in: 48.94 ms
[2026-03-13T14:09:55,431][WARN ][main][TestLogger] Orders loading iteration
completed in: 47.19 ms
[2026-03-13T14:09:55,486][WARN ][main][TestLogger] Orders loading iteration
completed in: 54.44 ms
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
