Worked on enhancing data integrity and reliability in the ClickHouse/ClickHouse repository by addressing a critical race condition in the MergeTree data flow. Focused on concurrency control and database internals using C++ and system programming techniques, the developer resolved a bug in part commits by introducing a part_lock mechanism and ensuring its propagation through the prepare and commit phases. This approach harmonized transaction handling and mitigated the risk of data corruption during high-concurrency writes. Incremental improvements were delivered across multiple commits, resulting in safer part commits and improved locking, ultimately strengthening the robustness of concurrent data operations within the database system.