[IGNITE-23321] RocksDB: repeat of create table and drop column leads to freeze of client

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0-beta1
• Component/s: persistence
• Labels: ignite-3

Environment

3 nodes cluster running locally.

• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Igor
• Created: 30/Sep/24 18:52
• Updated: 02/Oct/24 09:03

Description

Steps to reproduce:

Run the next queries in cycle with 50 repeats in single connection:

drop table if exists dropNoMoreIndexedColumn
create zone if not exists "rocksdb" engine rocksdb
create table dropNoMoreIndexedColumn(k1 TIMESTAMP not null, k2 INTEGER not null, v0 TINYINT not null, v1 SMALLINT not null, v2 INTEGER not null, v3 BIGINT not null, v4 VARCHAR not null, v5 TIMESTAMP not null, primary key (k1, k2)) with PRIMARY_ZONE='rocksdb'
create index dropNoMoreIndexedColumn_v1idx on dropNoMoreIndexedColumn using TREE (v1)
drop index dropNoMoreIndexedColumn_v1idx
alter table dropNoMoreIndexedColumn drop column v1 

Expected:

All queries are executed.

Actual:

On repeat 31 the client freeze for infinite amount of time.

Analysis:

The servers contain repeated error in logs:

2024-09-30 02:58:36:290 +0000 [WARNING][%DropColumnsTest_cluster_2%JRaft-FSMCaller-Disruptormetastorage_stripe_0-0][LeaseUpdater] Lease update invocation failed because of concurrent update.
2024-09-30 02:58:36:809 +0000 [WARNING][%DropColumnsTest_cluster_2%JRaft-FSMCaller-Disruptormetastorage_stripe_0-0][LeaseUpdater] Lease update invocation failed because of concurrent update.
2024-09-30 02:58:37:045 +0000 [INFO][Thread-259][LoggingRocksDbFlushListener] Starting rocksdb flush process [name='meta-storage log', reason=WRITE_BUFFER_FULL]
2024-09-30 02:58:37:332 +0000 [WARNING][%DropColumnsTest_cluster_2%JRaft-FSMCaller-Disruptormetastorage_stripe_0-0][LeaseUpdater] Lease update invocation failed because of concurrent update.
2024-09-30 02:58:38:178 +0000 [WARNING][%DropColumnsTest_cluster_2%JRaft-FSMCaller-Disruptormetastorage_stripe_0-0][LeaseUpdater] Lease update invocation failed because of concurrent update.
2024-09-30 02:58:38:743 +0000 [WARNING][%DropColumnsTest_cluster_2%JRaft-FSMCaller-Disruptormetastorage_stripe_0-0][LeaseUpdater] Lease update invocation failed because of concurrent update.
2024-09-30 02:58:39:047 +0000 [WARNING][%DropColumnsTest_cluster_2%JRaft-FSMCaller-Disruptormetastorage_stripe_0-0][LeaseUpdater] Lease update invocation failed because of concurrent update.

server_logs.zip

Issue Links

• is related to: IGNITE-23334 Aipersist: repeat of create table and drop column leads to freeze of client
• supercedes: IGNITE-21451 RocksDB: repeat of create table and drop column leads to freeze of client