[IGNITE-22167] RocksDB: cannot create a default zone just twice

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Invalid
• Affects Version/s: 3.0
• Component/s: persistence
• Labels: ignite-3 rocksdb
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Andrey Khitrin
• Created: 06/May/24 07:07
• Updated: 04/Sep/24 16:22
• Resolved: 06/May/24 12:32

Description

Steps to reproduce:

1. Start AI3 cluster of 1 node
2. Run few simple SQL queries:

create zone if not exists "ROCKSDB" with storage_profiles='default_rocksdb';
create table ...  with PRIMARY_ZONE='ROCKSDB';
insert into table ... values();             -- probably, unneeded
create zone if not exists "ROCKSDB" with storage_profiles='default_rocksdb'; -- absolutely the same query as the 1st one

Expected behavior: the 2nd "create zone" query must be executed successfully (because a zone is already created).
Actual behavior: the 2nd "create zone" query simply hangs.

Found on commit 654a11a4a00919ce2b3ff4ca0e59e83377124dea (recent AI3 at the time).

Issue Links

• is related to: IGNITE-22169 RocksDb: NPE on index creation