Skip to content

Navid's Blog

Ideas, Experiments, and Lessons Learned

Menu
Menu

Category: Debugging Stories

The SQL Query That Crashed Our Production Database

Posted on March 7, 2026 by Navid

It was 2 AM when my phone rang. Not the kind of call you want to get when you’re three drinks in at a friend’s birthday dinner. “The site is down,” our ops guy said. “Everything’s timing out.” What Was Happening I jumped on my laptop at the restaurant table while my friends looked at…

Read more

That Time My API Returned Wrong Data for 3 Hours

Posted on March 5, 2026 by Navid

It was a regular Tuesday. I deployed a small change to our user API — just a minor refactor to clean up some duplicate code. Three hours later, my phone started buzzing. Customers were seeing wrong profile data. The Symptom Support tickets started flooding in: “Why is my email showing as someone else’s?” Users were…

Read more

I Spent 3 Days Debugging — The Fix Was One Line of Code

Posted on March 2, 2026 by Navid

Three days. That’s how long I stared at my screen, questioning my career choice, doubting everything I knew about coding. And the fix? One line. One stupid line that I missed a hundred times. The Problem Started Simple We had a bug in our payment system. Users were getting charged twice. Not always — just…

Read more

I Spent 3 Hours Debugging Before Realizing I Was Looking at the Wrong Server

Posted on March 1, 2026 by Navid

Three hours. That’s how long I stared at logs, checked configurations, and questioned my entire career before someone asked the obvious question: “Which server are you actually looking at?” I wasn’t working on anything fancy. Just a simple API endpoint that was returning 500 errors in production. Classic problem, right? Time to dig in. The…

Read more

I Spent 3 Days Fixing a Bug That Wasn’t a Bug

Posted on February 28, 2026 by Navid

Three days. Forty-two hours of staring at code. Multiple panic-induced Slack messages to my teammate. And it turned out the problem was nowhere near where I was looking. Here’s what happened. The Problem We had a production issue. Users were reporting that their data wasn’t saving. The error message was vague: “Something went wrong.” Classic….

Read more

The Time I Spent 3 Days Debugging Something That Wasn’t Even a Bug

Posted on February 26, 2026 by Navid

Three days. That’s how long I stared at the same error message before realizing I had been fighting a ghost. It started like any other Tuesday. I was working on a feature that synced user data between our main app and a third-party service. Everything looked correct in the code. The API was returning 200…

Read more

I Spent 6 Hours Debugging Slow API Calls — It Was a Missing Index

Posted on February 23, 2026 by Navid

I remember this one clearly. We had an endpoint that was getting slower by the day. At first, it took 200ms. Then 500ms. Then over 2 seconds. Users started complaining. The Symptoms The API was simple — fetch a list of orders with user details. Nothing fancy. But as the database grew, response times exploded….

Read more

I Spent 4 Hours Debugging — It Was a Missing Semicolon

Posted on February 22, 2026 by Navid

Four hours. That’s how long I stared at my screen, questioning my career choices, debug logs flooding my terminal, and genuinely considering whether I should just become a farmer. The bug? A simple API endpoint returning 500 errors in production. Nothing special. Just another day in the life of a backend developer. What Happened It…

Read more

Posts pagination

  • Previous
  • 1
  • 2

Categories

  • AI Experiments
  • Coding
  • Debugging Stories
  • Hot Takes
  • Ideas
  • Lessons Learned
  • Project Management
  • Uncategorized
  • Vibe Coding

Recent Posts

  • How I Handled My First Production Outage (And What I Learned)
  • I Finally Fixed Our Slow Database Queries — Here’s What Actually Worked
  • I Finally Fixed Our Slow Database Queries — Here’s What Actually Worked
  • Why I Stopped Using Microservices for Small Projects
  • I Gave AI Full Access to Our Production Database. Here’s What Happened