▸case-01 We have two background worker services that both periodically write update timestamps and status metrics into a single shared `app-status.json` file. Occasionally the file gets corrupted due to race conditions. Could you analyze our current setup and recommend a robust architectural design to solve this concurrency issue? | fail→pass | 16,584 | 8,902 | -46% | 1 | 1 | 0% | 2,607 | 2,137 | -18% | 0 | 0 | — |
▸case-02 Two CI pipelines running in parallel both need to push their test results into the project repository's shared `gh-pages` branch by updating `results.json`. They frequently hit non-fast-forward merge conflicts or overwrite each other's commits. How should we restructure this CI workflow? | pass→pass | 15,481 | 10,212 | -34% | 1 | 1 | 0% | 2,637 | 2,276 | -14% | 0 | 0 | — |
▸case-03 We have an indexing worker and a metrics worker in AWS. Both write into a single DynamoDB item (`partition_key = system_state`) with different top-level attributes: `indexer_status` and `metrics_status`. We are considering adding optimistic locking with `attribute_exists` check or transaction locks to prevent concurrency errors. What is the recommended architectural design? | pass→pass | 17,279 | 11,452 | -34% | 1 | 1 | 0% | 3,037 | 2,242 | -26% | 0 | 0 | — |
▸case-04 Four server nodes upload their hourly audit logs to a single S3 object `s3://company-audit-logs/2026-03-30/audit.log` by downloading, appending, and re-uploading the log. We are planning to implement a distributed file lock using Redis/Redlock around the upload step. Please advise on this design. | pass→pass | 15,965 | 10,852 | -32% | 1 | 1 | 0% | 2,750 | 2,182 | -21% | 0 | 0 | — |
▸case-05 A backend microservice has multiple background routines updating different fields (`last_login`, `permissions`, `preferences`) inside a single Redis hash key `user:12345`. We keep having race conditions where old permission states overwrite newer preference states. Should we wrap updates in Redis MULTI/EXEC transactions with WATCH? Provide your architectural recommendation. | pass→pass | 14,833 | 12,513 | -16% | 1 | 1 | 0% | 2,706 | 2,366 | -13% | 0 | 0 | — |
▸case-06 Our CLI tool spawns sub-processes that both read and update a shared configuration cache file `~/.myapp/cache.json`. When two sub-processes execute concurrently, the file gets partially written. Should we implement file locking with `flock` or file-lock libraries? Recommend the best solution. | fail→pass | 15,106 | 11,992 | -21% | 1 | 1 | 0% | 2,618 | 2,265 | -13% | 0 | 0 | — |
▸case-07 Two Kubernetes controller pods update status fields in the same ConfigMap `app-cluster-status`. They keep hitting 409 Conflict errors from the K8s API server. We plan to add retry loops with exponential backoff on resourceVersion conflicts. How should we handle this state architecture? | pass→pass | 15,736 | 7,919 | -50% | 1 | 1 | 0% | 2,791 | 1,752 | -37% | 0 | 0 | — |
▸case-08 A cluster of 10 worker nodes process video rendering chunks and write their individual chunk progress percentage into a single row in a PostgreSQL table `rendering_jobs` using row-level locking (`SELECT FOR UPDATE`). The database server is hitting high CPU due to lock contention. Should we tune the lock timeouts or move to advisory locks? | pass→pass | 16,085 | 7,355 | -54% | 1 | 1 | 0% | 2,705 | 1,496 | -45% | 0 | 0 | — |
▸case-09 The Inventory service and Order service both update `stock_and_order_status` table in a shared database whenever an item is reserved or shipped. They suffer from deadlocks during flash sales. We are planning to implement distributed lock manager (DLM) service. What architectural change should we make? | pass→pass | 12,563 | 9,257 | -26% | 1 | 1 | 0% | 2,318 | 1,957 | -16% | 0 | 0 | — |
▸case-10 Multiple tenant export jobs write their generated PDF download links into a shared JSON file `tenant-exports.json` on NFS. We are planning to put a file mutex around the file update. How should we design this? | pass→pass | 17,064 | 9,983 | -41% | 1 | 1 | 0% | 3,113 | 1,974 | -37% | 0 | 0 | — |
▸case-19 We are configuring a PostgreSQL standby server to handle read-only traffic offloaded from our primary database. Which specific parameter in `postgresql.conf` must be set to `on` to allow read queries on the standby server, and which parameter specifies the primary node connection details? | fail→fail | 3,385 | 3,491 | +3% | 1 | 1 | 0% | 743 | 987 | +33% | 0 | 0 | — |
▸case-11 Three consumer instances in a consumer group write their processing offset and local stats into a shared RocksDB database path on a shared volume. They encounter lock errors when starting up. How should we fix this storage layout? | pass→pass | 13,387 | 9,275 | -31% | 1 | 1 | 0% | 2,247 | 1,797 | -20% | 0 | 0 | — |
▸case-12 In our monorepo build pipeline, 5 parallel package build scripts update a central `build-manifest.json` file in the repository root with their hash outputs. Builds fail intermittently due to file write contention. Should we add a file locking library to the node scripts? | pass→pass | 11,374 | 6,659 | -41% | 1 | 1 | 0% | 2,112 | 1,478 | -30% | 0 | 0 | — |
▸case-13 In our ledger system, a sequence counter `last_allocated_id` must be strictly contiguous without gaps and guaranteed unique across 4 database instances for compliance regulations. We cannot give each node its own ID pool. What is the proper concurrency control approach for this real hard invariant? | pass→pass | 19,855 | 12,956 | -35% | 1 | 1 | 0% | 3,125 | 2,269 | -27% | 0 | 0 | — |
▸case-14 Four Docker containers on the same host write their diagnostic logs into `/var/log/app/combined.log` simultaneously. Logs end up interleaved and mangled mid-line. Should we write a Python daemon that acts as a lock manager? | pass→pass | 13,738 | 7,483 | -46% | 1 | 1 | 0% | 2,355 | 1,578 | -33% | 0 | 0 | — |
▸case-20 Our single-threaded Python ETL script processes a 50GB file using `pandas.read_csv`. We want to stream data sequentially without loading the whole file into memory at once. Which parameter in `pandas.read_csv` specifies the number of rows per chunk to return an iterable `TextFileReader` object? | pass→pass | 2,325 | 3,188 | +37% | 1 | 1 | 0% | 451 | 892 | +98% | 0 | 0 | — |
▸case-15 Developer environment scripts update `local-flags.json` concurrently whenever a service boots up. Races cause JSON syntax errors. Should we use cross-process Mutexes? | pass→pass | 12,047 | 8,774 | -27% | 1 | 1 | 0% | 2,144 | 1,784 | -17% | 0 | 0 | — |
▸case-16 Multiple matrix jobs in GitHub Actions attempt to update a single shared cache entry `global-npm-cache` at the end of their runs. Jobs fail with 409 Conflict when saving cache. Should we add step retries around `actions/cache` save step? | pass→pass | 10,761 | 6,750 | -37% | 1 | 1 | 0% | 1,942 | 1,499 | -23% | 0 | 0 | — |
▸case-17 Two cron jobs (`cleanup.sh` and `archiver.sh`) write their last execution timestamp into `/etc/app/cron-status.txt`. They clash when running at midnight. Should we implement `flock` in bash scripts? | pass→pass | 12,388 | 5,288 | -57% | 1 | 1 | 0% | 2,228 | 1,281 | -43% | 0 | 0 | — |
▸case-18 Two worker processes write metrics into a single SQLite database file `metrics.db`. They hit `database is locked` errors despite using WAL mode. We are planning to increase the busy timeout to 30 seconds. What design change should we make? | fail→pass | 13,031 | 7,111 | -45% | 1 | 1 | 0% | 2,269 | 1,461 | -36% | 0 | 0 | — |
▸case-21 Inside a single C++11 multithreaded process, multiple threads increment a `std::atomic<uint64_t>` counter. Which member function of `std::atomic` atomically adds a value to the counter and returns the previous value, and which memory order constant provides relaxed ordering without synchronization fencing? | pass→pass | 3,580 | 3,108 | -13% | 1 | 1 | 0% | 636 | 904 | +42% | 0 | 0 | — |
▸case-22 Five microservices update a single shared OpenAPI `openapi.yaml` file on disk during local development when building. They overwrite each other's route definitions. Should we enforce developer conventions to run build scripts sequentially? | pass→pass | 10,879 | 5,320 | -51% | 1 | 1 | 0% | 1,859 | 1,180 | -37% | 0 | 0 | — |
▸case-23 Two C services share a POSIX shared memory segment `/dev/shm/app_state` to write live telemetry. Writes get corrupted. Should we put a POSIX named semaphore around the entire shared memory write? | pass→pass | 12,848 | 7,588 | -41% | 1 | 1 | 0% | 2,165 | 1,594 | -26% | 0 | 0 | — |