Bug: FSM related failure on Apple Clang Build & Test

[hakuuww]

Kuzu version

No response

What operating system are you using?

No response

What happened?

Those tests fail on Apple Clang Build & Test fails if we run the fsm_leak_checker(added in #6006)
Tha is if we remove the -SKIP_FSM_LEAK_CHECK flag.

ddl~alter_rel_group.AlterRelGroup
transaction~ddl~ddl_empty.InsertAndDropRelColumnCheckpointRecovery
transaction~ddl~ddl_empty.AddDropRelGroupPropertyRollbackRecovery
transaction~ddl~ddl_empty.DropRelGroupPropertyRollbackRecovery

Are there known steps to reproduce?

Failure CI:
https://github.com/kuzudb/kuzu/actions/runs/17839152935/job/50724215271

Build info:

    env:
    RUNTIME_CHECKS: 1
    USE_EXISTING_BINARY_DATASET: 1
    AUTO_CHECKPOINT: true
    BUFFER_POOL_SIZE: 
    MAX_NUM_THREADS: 
    ENABLE_COMPRESSION: 
    CHECKPOINT_THRESHOLD: 0
    FORCE_CHECKPOINT_ON_CLOSE: 
    WERROR: 1
    RUSTFLAGS: --deny warnings
    PIP_BREAK_SYSTEM_PACKAGES: 1
    TEST_JOBS: 16
    GEN: Ninja
    UW_S3_ACCESS_KEY_ID: ***
    UW_S3_SECRET_ACCESS_KEY: ***
    AWS_S3_ACCESS_KEY_ID: ***
    AWS_S3_SECRET_ACCESS_KEY: ***
    AWS_ACCESS_KEY_ID: ***
    AWS_SECRET_ACCESS_KEY: ***
    GCS_ACCESS_KEY_ID: ***
    GCS_SECRET_ACCESS_KEY: ***
    PG_HOST: ***
    RUN_ID: $(hostname)-$(date +%s)
    HTTP_CACHE_FILE: true
    NUM_THREADS: 32
cmake -B build/relwithdebinfo -DCMAKE_BUILD_TYPE=RelWithDebInfo  -DBUILD_TESTS=TRUE -DENABLE_BACKTRACES=TRUE -G "Ninja" -DENABLE_RUNTIME_CHECKS=1 -DENABLE_WERROR=1  .
-- Multi-threaded mode is enabled: CMAKE_BUILD_PARALLEL_LEVEL=32
-- 64-bit architecture detected
-- KUZU_PAGE_SIZE_LOG2: 12
-- KUZU_VECTOR_CAPACITY_LOG2: 11
-- KUZU_NODE_GROUP_SIZE_LOG2: 17
-- KUZU_MAX_SEGMENT_SIZE_LOG2: 18
-- ✓ F_FULLFSYNC will be used on this platform
-- ✗ fdatasync not available, using fsync fallback
-- Fetching cpptrace from GitHub...
-- Cpptrace auto config: Using execinfo.h for unwinding
-- Cpptrace auto config: Using libdwarf for symbols
-- Cpptrace auto config: Using cxxabi for demangling
-- ZSTD VERSION: 1.5.7
-- CMAKE_INSTALL_PREFIX: /usr/local
-- CMAKE_INSTALL_LIBDIR: lib
-- ZSTD_LEGACY_SUPPORT not defined!
-- ZSTD_MULTITHREAD_SUPPORT is enabled
-- Building dwarfgen    ... OFF
-- Building dwarfexample... OFF
-- Building api tests   ... 
-- HAVE_UINTPTR_T 1: uintptr_t defined in stdint.h... YES
-- uintptr_t value considered NO 
-- HAVE_INTPTR_T 1: intptr_t defined in stdint.h... YES
-- intptr_t value considered NO 
-- ENABLE_DECOMPRESSION : ON
-- Found libzstd           : TRUE
-- Found zlib              : TRUE
-- Build with zlib and zstd: TRUE
-- CMAKE_SIZEOF_VOID_P ... : 8
-- Compiler warning options... NO
-- Install prefix ... /usr/local
-- Build type is 'RelWithDebInfo'
-- Compiler is not EMSCRIPTEN
-- Static link extensions: 
-- Fetching GTest from GitHub...
-- Configuring done (2.1s)
-- Generating done (0.8s)
-- Build files have been written to: /Users/runner/Developer/actions-runners/2/_work/kuzu/kuzu/build/relwithdebinfo
cmake --build build/relwithdebinfo --config RelWithDebInfo
ninja: no work to do.
ctest --test-dir build/relwithdebinfo/test --output-on-failure -j 16