DEV Community

Cover image for 👻 Do you have any horror stories to share? Spooky bugs, scary data leaks, horrifying code, etc. 🎃
Ben Halpern
Ben Halpern Subscriber

Posted on

👻 Do you have any horror stories to share? Spooky bugs, scary data leaks, horrifying code, etc. 🎃

Oldest comments (48)

Collapse
 
ben profile image
Ben Halpern

Just the other day I accidentally committed a ~200mb file to git, which is not allowed in GitHub, but removing it was much more complicated than just deleting the file because it already existed in the git history.

The whole process of removing it was pretty scary as it required rewriting the git history in possibly destructive ways if done wrong. 😱

But it worked out fine. 😄

Collapse
 
andreujuanc profile image
Juan C. Andreu

Or when you forget to create gitignore and you see your connection-strings commited xD

Collapse
 
inidaname profile image
Hassan Sani

Guilty of this😄😄😄

Collapse
 
andy profile image
Andy Zhao (he/him) • Edited

I can never remember any horror stories, but I'm always a bit on edge whenever I touch production data... 🙃

Collapse
 
andreujuanc profile image
Juan C. Andreu

I do enjoy the thrill of playing in production :)

Collapse
 
jess profile image
Jess Lee • Edited

Once upon a time, all my work from the previous night disappeared. git reflog showed a SHA but the line was blank and my work never came back. It was spooked and never used that computer again.

Collapse
 
le_newtype profile image
Nicholas ―M― • Edited

I didn't do anything to prevent the unnecessary re-rendering of a React component that used the Google Location API. Within a few hours of it going live, we hit our max amount of free API calls and the whole feature was basically useless for 24 hours 🙃

Thankfully this was when we were slowly reskinning / revamping our product, so clients could still use the old version and knew there wouldn't be a seamless transition until everything was finished.

And that's how I learned why performance lifecycle functions are important.

Collapse
 
andreujuanc profile image
Juan C. Andreu • Edited

One time a friend of mine and colleague was "fixing" some purchase orders and he had to delete some of the rows. He opened Management Studio and got some queries running.

After confirming the rows he needed to delete, he started to write the DELETE query. He always commented the delete statements to prevent any accidental data loss, but that night right after when he has just written the table name part of the syntax, he accidentally pressed F5 because he wanted to be sure that the SELECT conditions were correct.

Something like this:

SELECT .. 
FROM [TABLE HERE]
WHERE [LOTS OF CONDITIONS ]

DELETE FROM [SAME TABLE NAME HERE] 
[HE FORGOT TO PLACE THE CONDITIONS HERE]

The best part was when he pressed STOP to stop the query and the cancel was not working, he panicked and unplugged the Ethernet cable from his computer. xD

To this day, some people say that some of those lost rows still appear on query results.

Collapse
 
lpasqualis profile image
Lorenzo Pasqualis

Oh yeah, I remember many years ago when my CTO wanted to clean up a few rows in the DB and ran a select without specifying a WHERE clause.

DELETE FROM users;

The team spent the next week recovering data from printouts ( Hey, it was 1999 :) )

...Opppsssss....

From that moment on, we made him run mysql with the --i-am-a-dummy option.

Collapse
 
lluismf profile image
Lluís Josep Martínez

In 1999 there were already DB backups. And many years before too :-)

Collapse
 
lpasqualis profile image
Lorenzo Pasqualis

Oh, I know... :)

Collapse
 
luar_serrot profile image
🎃Raúl TorreSpooky🎃

I remember one time that I was forced to debug a 7000 lines, obfuscated javascript file.

I think that says everything. :>

Collapse
 
pildit profile image
pildit

This must be hell..sure it was!

Collapse
 
s_anastasov profile image
Stojan Anastasov

Working with a "REST" API today the error response was

{errorCode:1, error:"Error message"}

For the people who haven't had coffee yet, the quotes for errorCode and error are missing so it isn't a proper JSON. I think it actually took some effort to make it like this instead of proper JSON.

Collapse
 
cdvillard profile image
Charles D. Villard

The word 'Drupal' will probably already send a shiver down many a developer's spine, but that's what I was working on today: updating a client site's core Drupal libraries and modules with drush. This is something I've gotten down to a mad, mechanical sort of a science, but it's not without its flaws. I went through the process only to be met with a styleless page, and what's worse, fixing any issues brought it to a screeching halt in the form of an 500 error! Thankfully this was only a scare as I had forgotten this was on a dev server, but never something to be taken lightly.

Collapse
 
derekpalmer profile image
Derek Palmer

Being asked "why would I use source control?"

Collapse
 
skyrpex profile image
Cristian Pallarés

Oh, I've been told that, and that code revisions and unit tests are useless...

Collapse
 
derekpalmer profile image
Derek Palmer

Terrifying