Steve Hostettler created IGNITE-20028:
-----------------------------------------
Summary: " Maximum number of retries 1000 reached for Put
operation" when SQL on heap enable on a cache that is streamed into
Key: IGNITE-20028
URL: https://issues.apache.org/jira/browse/IGNITE-20028
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 2.14
Reporter: Steve Hostettler
When streaming into a cache that has sql on heap enabled, I am getting the
following error. Please note that the cache that it fails with DOES NOT have
sql on heap enabled.
There is a similar issue IGNITE-13776
2023-07-24 08:14:16,550 ERROR [ROOT]
(data-streamer-stripe-2-#15%com.wolterskluwer.processing%) Critical system
error detected. Will be handled accordingly to configured handler
[hnd=NoOpFailureHandler [super=AbstractFailureHandler
[ignoredFailureTypes=UnmodifiableSet [SYSTEM_WORKER_BLOCKED,
SYSTEM_CRITICAL_OPERATION_TIMEOUT]]], failureCtx=FailureContext
[type=CRITICAL_ERROR, err=class o.a.i.IgniteCheckedException: Maximum number of
retries 1000 reached for Put operation (the tree may be corrupted). Increase
IGNITE_BPLUS_TREE_LOCK_RETRIES system property if you regularly see this
message (current value is 1000). InlineIndexTree [grpName=partitionedCaches,
treeName=-xxxxxxxxx##H2Tree, metaPageId=0002ffff000015b6]. Problem with the
index [cacheName=xxxxxxxx schemaName=cxxxxx tblName=xxxxxxx, idxName=xxxxx]]]:
class org.apache.ignite.IgniteCheckedException: Maximum number of retries 1000
reached for Put operation (the tree may be corrupted). Increase
IGNITE_BPLUS_TREE_LOCK_RETRIES system property if you regularly see this
message (current value is 1000). InlineIndexTree [grpName=partitionedCaches,
treeName=-1902362518_incomestatementitem_lineagetoken_asc_idx##H2Tree,
metaPageId=0002ffff000015b6]. Problem with the index
[cacheName=com.wolterskluwer.fdm:fdm-model:jar:3.10.0-internal14:Fdm_Partitioned_ReadWrite_deliveryDate_setIdentifier_validityDate:20211231:1:20211231:IncomeStatementItem,
schemaName=com.wolterskluwer.fdm:fdm-model:jar:3.10.0-internal14:Fdm_Partitioned_ReadWrite_deliveryDate_setIdentifier_validityDate:20211231:1:20211231:IncomeStatementItem,
tblName=IncomeStatementItem, idxName=incomestatementitem_lineagetoken_asc_idx]
at
deployment.processing-engine.war//org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Get.checkLockRetry(BPlusTree.java:3328)
at
deployment.processing-engine.war//org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Put.checkLockRetry(BPlusTree.java:4141)
at
deployment.processing-engine.war//org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.putDown(BPlusTree.java:3006)
at
deployment.processing-engine.war//org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.doPut(BPlusTree.java:2631)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
