466
you are viewing a single comment's thread
view the rest of the comments
[-] ICastFist@programming.dev 19 points 1 year ago

I've had that happen with database logs where I used to work, back in 2015-6.

The reason was a very shitty system that, for some reason, threw around 140 completely identical delete queries per millisecond. When I say completely identical, I mean it. It'd end up something like this in the log:

2015-10-22 13:01:42.226 = delete from table_whatever
      where id = 1
          and name = 'Bob'
          and other_identifier = '123';
2015-10-22 13:01:42.226 = delete from table_whatever
      where id = 1
          and name = 'Bob'
          and other_identifier = '123';
2015-10-22 13:01:42.226 = delete from table_whatever
      where id = 1
          and name = 'Bob'
          and other_identifier = '123';
-- repeated over and over with the exact same fucking timestamp, then repeated again with slightly different parameters and different timestamp

Of course, "no way it's our system, it handles too much data, we can't risk losing it, it's your database that's messy". Yeah, sure, I set up triggers to repeat every fucking delete query. Fucking morons. Since they were "more important", database logging was disabled.

[-] stealthnerd@lemmy.world 13 points 1 year ago

Having query logging enabled on a production database is bonkers. The duplicate deletes are too but query logging is intended for troubleshooting only. It kills performance.

[-] ICastFist@programming.dev 15 points 1 year ago

Take a wild guess as to why it had to be enabled in the first place, and only for Delete queries.

load more comments (1 replies)
this post was submitted on 14 Sep 2023
466 points (97.6% liked)

Programmer Humor

32400 readers
253 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS