What was the worst bug you've ever solved ?
ilitirit: Not so much a bug, but this incident cut my lifespan by about 5 years or so:I was fixing an account balance on a customer's master database.  Any change that happens on the master gets replicated to 30 branches, usually at 10 minute intervals.I wrote the UPDATE statement, highlighted it, and pressed "Execute".  Unfortunately, I didn't select the WHERE clause, so I basically gave all their customers (85000) a 50c credit balance.  The IDE I was using also had a bug that caused it to ignore the auto-commit setting (which was turned off), so it basically committed the transaction.  First I tried a ROLLBACK, which failed obviously.  Realizing I had to act quickly, I disconnected the network cable (I was working on the DBMS server) to stop replication.  I extracted the transaction log from the current database into a textfile (a few hundred MB) and restored the database from the most recent backup. Then I basically ran the extracted transaction log as SQL scripts against the database, hoping that it wouldn't fall over.  I didn't want to do a normal restore because I was afraid of it showing up in the logs.Within a very stressful 60 minutes I had everything back to normal.  I never told a soul IRL about it.