So today I discovered that there's a cron job that holds non-reproducible state that died, and now our system is fucked.

The cron job doesn't live inside any source control. This morning it entered a terminal state, and because it overwrites its state there's no way to revert it.

I'm currently waiting for the database rollback and have rewritten it in a reproducible/idempotent way.

all 50 comments

sorted by: hot top controversial new old
[–] [S] 168 points 1 year ago (19 children)

What's extra frustrating is the previous guy did create a git repo of these types of hacks, but this one doesn't live in it for no discernible reason.

  • source
  • hideshow 19 child comments
  • [–] 141 points 1 year ago (17 children)
  • [–] [S] 117 points 1 year ago (14 children)

    He does charge a consulting fee to "fix" these issues

    Almost all of them are dumb shit like this, where something is built in super hacky and dumbass ways.

  • source
  • parent
  • hideshow 14 child comments
  • [–] 59 points 1 year ago* (2 children)

    Smart man. This is how we fight being replaced by AI.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 14 points 1 year ago (9 children)

    Super hacky and dumb? Sign me up 😂

  • source
  • parent
  • hideshow 9 child comments
  • [–] 8 points 1 year ago (8 children)

    Me running all my services in tmux

  • source
  • parent
  • hideshow 8 child comments
  • [–] 4 points 1 year ago (6 children)

    that might be a stupid question, but why would you running all services in tmux be a bad idea? a co-worker of mine is doing exactly that right now, which is why I'm asking.

  • source
  • parent
  • hideshow 6 child comments
  • [–] 4 points 1 year ago (4 children)

    It's not horrible, like it'll do the job just fine, it's just probably a better idea to use systemd and like, containers and whatnot, but I couldn't be arsed to fiddle with all that for Jellyfin, caddy reverse proxy, and two modded Minecraft servers, so shell scripts and tmux won the day. It takes a little extra time to restart everything after an update, and maybe I'll get the motivation to do things "correctly™" one day, but today is not that day.

  • source
  • parent
  • hideshow 4 child comments
  • [–] 6 points 1 year ago* (2 children)

    Use the tmux resurrect plugin. It will restore your tmux session to its previous state after a restart, including programs if you like.

    You can put off doing things "correctly™" even longer.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 6 points 1 year ago (1 child)

    The "here's how you keep doing this poorly but more efficiently" energy on display here is a refreshing change of pace from the usual "here's how you do this correctly" crap peddled by normies (including me). You have my respect.

  • source
  • parent
  • hideshow 1 child comment
  • [–] 2 points 1 year ago* (last edited 1 year ago)
    1. They're all gone when you restart
    2. It doesn't properly deal with logging
    3. You can't set up dependencies between services but that doesn't matter due to point 1

    I recommend using systemd services and/or docker compose instead. systemd services are files that describe which program / script to run and when (like after networking is active or after a certain other service is loaded).

  • source
  • parent
  • [–] 87 points 1 year ago (1 child)

    So do you work for Spotify or Zoom?

  • source
  • hideshow 1 child comment
  • [–] 75 points 1 year ago* (last edited 1 year ago) (2 children)

    This is almost exactly what happened to me on Monday, resulting in a fifteen hour day.

    My particular jenga piece was an Access query that none of my predecessors had deigned to document or even tell me about... but was critical to run monthly or you had obsolete data embedded deep within multi-million dollar reports.

    Thank god I don't work on salary anymore, or I'd be really upset.

  • source
  • hideshow 2 child comments
  • [–] 34 points 1 year ago*

    Only tangentially related, but "What a elegant house of cards" is an insult i'm going to use someday.

  • source
  • [–] 25 points 1 year ago (1 child)

    Cron job that evals some base64 encoded string which is actually downloading a script from a personal GitHub repo of an IT guy who left...

  • source
  • hideshow 1 child comment
  • [–] 23 points 1 year ago (3 children)

    Idempotent code/repositories are great - I love making everything as reproducible as possible. Particularly in make where every 'all' type command should have a corresponding 'clean' command. Many times I'll see code bases where they skip defining the 'clean' command... or worse, have no 'all' command to begin with and rely on the developer knowing all the build and environment setup commands...

  • source
  • hideshow 3 child comments
  • [–] [S] 21 points 1 year ago (2 children)

    Yeah, I don’t consider most code complete unless it’s safe and reproducible. I love make, currently using npm but you can set up scripts with it. Automating the build process was the very first thing I did.

    This project is a piece of work. There’s effectively no documentation, and every now and then I find something new like this. The stuff I’ve fixed up so far has been much much more reliable and performant.

    Part of me just wants to rewrite the whole thing, but I need to ship features so we can sell the product and pay my salary.

    At least I’m not a cog in a huge corporation getting my soul crushed every day. I actually love fixing weird stuff.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 21 points 1 year ago

    AHAHAHAHAHAHA you couldn't make this up

  • source
  • [–] 17 points 1 year ago

    We have a couple of those at work. Black boxes that are used.

    I'm rebuilding one after it failed on one morning for SQL odbc reasons. And its just a binary that shuffles data around.

  • source
  • [–] 14 points 1 year ago (2 children)

    Time to restore a whole machine backup to a VM with no network connectivity, and manually pull the command?

  • source
  • hideshow 2 child comments
  • [–] 14 points 1 year ago

    Why does this sound like maintaining my nextcloud instance from time to time?

  • source
  • [–] 11 points 1 year ago (4 children)
  • load more comments (1 reply)
    [–] 6 points 1 year ago

    Somebody’s having a fun day! /s

  • source
  • [–] 4 points 1 year ago (1 child)

    Had a similar thing once. Some how, some way, the DBA copied and pasted something wrong. Oracle DB had some odd extra syntax for left and right joins that other DBs didn't (or at least that I'd never seen). My best guess is that he auto formatted out of habit and maybe it took those symbols out.

    It took a long time to find that. Because the only evidence something was wrong was that ONE of our customers wasn't being billed for ONE product. Everyone else was fine. Basically they were using it in a very atypical way. The left joins made sure to include them in the billing even because they didn't have whatever was on the right of that join. Everyone else did.

  • source
  • hideshow 1 child comment
  • [–] [S] 2 points 1 year ago*

    SQL auto format is still mostly terrible

    The only half decent format is to start from the Mozilla style and then make it more sane.

    I’ve been playing with sqlglot lately and want to start using it for diffs.

  • source
  • parent
  • [–] 3 points 1 year ago

    For us it's a task that no one is even aware of and the first issue is the customer saying their data export doesn't work. You had a data export?

  • source
  • [+] 3 points 1 year ago* (last edited 1 year ago)
    [removed by mod]
  • source
  • [–] 2 points 1 year ago (1 child)

    I have also mixed up crontab -l with crontab -r. 😔

    Let this be a lesson to start versioning your crontabs.

  • source
  • hideshow 1 child comment
  • [–] 1 point 1 year ago

    We never had our crons in source control, but I always saved it somewhere (usually on my machine and the target machine) so we had some history just in case of typing r instead of l for some reason. You can also create an alias called backupCrontab or something that runs the command for you and puts the output somewhere safe.

  • source
  • parent
  • [–] 1 point 1 year ago

    Ah yes, good old dependency.

  • source