submitted 3 weeks ago* (last edited 3 weeks ago) by to c/programming@programming.dev
 

Deployed a backup script on a new server, tested it manually — worked fine. Set up crontab, came back next morning, no backup. Turns out /usr/local/bin wasn't in cron's PATH so pg_dump just silently didn't exist.

Switched to absolute path and it worked immediately. Fifteen minutes of debugging for a one-character fix. I keep making this mistake every time I set up a new box. At this point I should just have a checklist taped to my monitor.

all 11 comments

sorted by: hot top controversial new old
[–] 14 points 3 weeks ago (1 child)

That's one reason why I like using systemd timers instead of cronjobs. You can easily test it by running the unit instead of setting the job to "in a minute".

Downside is that you don't easily get notification mails for any output.

  • source
  • hideshow 2 child comments
  • [–] 14 points 3 weeks ago*

    hey, at least you caught it within a day.

    EDIT : Next time make the cron job run when you're finished deploying it.

  • source
  • [–] 7 points 3 weeks ago

    cron isn't using your login shell. that's the trap.

    but put PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin at the top of the crontab, then test the exact command once with env -i HOME="$HOME" PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin /bin/sh -c '...', and you catch most of the "worked in my terminal" stuff before it turns into tomorrow's missing backup. MAILTO or a heartbeat catches the next failure.

  • source
  • [–] 4 points 3 weeks ago* (1 child)

    This bit me so many times I have

    # USE ABSOLUTE PATHS, ASSUME ALL COMMANDS ARE UNDEFINED, SPECIFY ALL VERSIONS, REDIRECT OUTPUT
    

    at the top of my local crontab so I remember from when I take something from it to prod, lol.

    Edit: formatting whoopsie

  • source
  • hideshow 2 child comments
  • [–] 3 points 3 weeks ago*

    I'd recommend self-hosting healthchecks and using runitor for your cronjobs. Runitor pings healthchecks when the cronjob starts, then pings it again on completion with the status (success or fail) along with the stdout and stderr.

    Healthchecks can be configured to expect a ping periodically (once per day, once per hour, whatever) and alert you if it doesn't receive one.

    For backups, Borgmatic has a healthchecks integration.

  • source
  • [–] 3 points 3 weeks ago (2 children)

    Looks like you need to collect your crontab logs somewhere you can read.

  • source
  • hideshow 4 child comments
  • [–] 6 points 3 weeks ago

    Or maybe even set up a valid MAILTO in the crontab so that failures are emailed to them.

    My "pro" tips:

    • set up an email alias from root to an email you actually read
    • always use absolute paths
    • anything complex, put it in a shell script
  • source
  • parent
  • [–] 1 point 3 weeks ago

    You know I'd totally forgot about this but you're reminding me of my own insane debugging experiences over a decade who

  • source