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.

  • 87Six@lemmy.zip
    link
    fedilink
    arrow-up
    3
    ·
    edit-2
    10 hours ago

    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

  • grrgyle@slrpnk.net
    link
    fedilink
    arrow-up
    1
    ·
    12 hours ago

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

  • runwisp_com@lemmy.world
    link
    fedilink
    arrow-up
    7
    ·
    2 days 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.

  • Skullgrid@lemmy.world
    link
    fedilink
    arrow-up
    14
    ·
    edit-2
    2 days ago

    hey, at least you caught it within a day.

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

  • Björn@swg-empire.de
    link
    fedilink
    arrow-up
    13
    ·
    2 days ago

    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.

    • dan@upvote.au
      link
      fedilink
      arrow-up
      2
      ·
      2 days ago

      I use healthchecks + runitor for notifications. Would recommend. I posted another comment about them.

  • dan@upvote.au
    link
    fedilink
    arrow-up
    3
    ·
    edit-2
    2 days 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.

    • folekaule@lemmy.world
      link
      fedilink
      arrow-up
      7
      arrow-down
      1
      ·
      2 days 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
    • pelya@lemmy.world
      link
      fedilink
      arrow-up
      3
      ·
      2 days ago

      You can append

      2>&1 | logger -t my-cronjob
      

      to any command, and it will write logs to system journal which you can view withjournalctl