{"definition_raw":"---\nid: mc-db-backup\ntitle: Nightly Mission Control database backup\nschedule: \"30 1 * * *\"\ntimeout: 120\nretry: false\nenabled: true\nnotify_on: failure\nrun_as: shell\ncommand: \"python3 /home/lucienne/workspace/scripts/mc_db_export.py\"\ntags: [infrastructure, backup, database]\nruntime_profile: direct_python\n---\n**OVERRIDES runtime profile:** uses `direct_python` (plain Python, no model) because the command chain never invokes the `claude` CLI or any LLM API \u2014 pure-infra task; scheduler provider env injection is a no-op (MC-4942 U12 sweep).\n\nExports mc.db as gzipped SQL dump to ~/workspace/luci-home/backups/.\nKeeps latest + last 3 daily snapshots. Runs at 01:30 SAST (after memory backup).\n","id":"mc-db-backup","last_run":{"duration_s":32.271014,"log_path":"/home/lucienne/workspace/logs/task-runs/mc-db-backup/413047.log","output":"Saved dated backup: /home/lucienne/workspace/luci-home/backups/mc-db-2026-06-13.db.gz\nSaved latest backup: /home/lucienne/workspace/luci-home/backups/mc-db-latest.db.gz\nPruned old backup: mc-db-2026-06-10.db.gz\nMC database export complete\n","started_at":"2026-06-13T01:30:22.237388+02:00","status":"completed"},"next_run":"2026-06-14 01:30","next_run_iso":"2026-06-14T01:30:00+02:00","runs":[{"duration_s":32.271014,"finished_at":"2026-06-13T01:30:54.510986+02:00","id":413047,"log_path":"/home/lucienne/workspace/logs/task-runs/mc-db-backup/413047.log","output":"Saved dated backup: /home/lucienne/workspace/luci-home/backups/mc-db-2026-06-13.db.gz\nSaved latest backup: /home/lucienne/workspace/luci-home/backups/mc-db-latest.db.gz\nPruned old backup: mc-db-2026-06-10.db.gz\nMC database export complete\n","started_at":"2026-06-13T01:30:22.237388+02:00","status":"completed","task_id":"mc-db-backup","task_name":"Nightly Mission Control database backup"},{"duration_s":31.916962,"finished_at":"2026-06-12T01:30:47.865471+02:00","id":408882,"log_path":"/home/lucienne/workspace/logs/task-runs/mc-db-backup/408882.log","output":"Saved dated backup: /home/lucienne/workspace/luci-home/backups/mc-db-2026-06-12.db.gz\nSaved latest backup: /home/lucienne/workspace/luci-home/backups/mc-db-latest.db.gz\nPruned old backup: mc-db-2026-06-09.db.gz\nMC database export complete\n","started_at":"2026-06-12T01:30:15.945235+02:00","status":"completed","task_id":"mc-db-backup","task_name":"Nightly Mission Control database backup"},{"duration_s":31.623425,"finished_at":"2026-06-11T01:30:51.307139+02:00","id":404521,"log_path":"/home/lucienne/workspace/logs/task-runs/mc-db-backup/404521.log","output":"Saved dated backup: /home/lucienne/workspace/luci-home/backups/mc-db-2026-06-11.db.gz\nSaved latest backup: /home/lucienne/workspace/luci-home/backups/mc-db-latest.db.gz\nPruned old backup: mc-db-2026-06-08.db.gz\nMC database export complete\n","started_at":"2026-06-11T01:30:19.679924+02:00","status":"completed","task_id":"mc-db-backup","task_name":"Nightly Mission Control database backup"},{"duration_s":31.575792,"finished_at":"2026-06-10T01:30:40.675860+02:00","id":400247,"log_path":"/home/lucienne/workspace/logs/task-runs/mc-db-backup/400247.log","output":"Saved dated backup: /home/lucienne/workspace/luci-home/backups/mc-db-2026-06-10.db.gz\nSaved latest backup: /home/lucienne/workspace/luci-home/backups/mc-db-latest.db.gz\nPruned old backup: mc-db-2026-06-07.db.gz\nMC database export complete\n","started_at":"2026-06-10T01:30:09.096887+02:00","status":"completed","task_id":"mc-db-backup","task_name":"Nightly Mission Control database backup"},{"duration_s":31.19458,"finished_at":"2026-06-09T01:30:50.714823+02:00","id":396004,"log_path":"/home/lucienne/workspace/logs/task-runs/mc-db-backup/396004.log","output":"Saved dated backup: /home/lucienne/workspace/luci-home/backups/mc-db-2026-06-09.db.gz\nSaved latest backup: /home/lucienne/workspace/luci-home/backups/mc-db-latest.db.gz\nPruned old backup: mc-db-2026-06-06.db.gz\nMC database export complete\n","started_at":"2026-06-09T01:30:19.517770+02:00","status":"completed","task_id":"mc-db-backup","task_name":"Nightly Mission Control database backup"},{"duration_s":31.599923,"finished_at":"2026-06-08T01:30:51.075139+02:00","id":391920,"log_path":"/home/lucienne/workspace/logs/task-runs/mc-db-backup/391920.log","output":"Saved dated backup: /home/lucienne/workspace/luci-home/backups/mc-db-2026-06-08.db.gz\nSaved latest backup: /home/lucienne/workspace/luci-home/backups/mc-db-latest.db.gz\nPruned old backup: mc-db-2026-06-05.db.gz\nMC database export complete\n","started_at":"2026-06-08T01:30:19.472587+02:00","status":"completed","task_id":"mc-db-backup","task_name":"Nightly Mission Control database backup"},{"duration_s":30.851713,"finished_at":"2026-06-07T01:30:51.217118+02:00","id":387471,"log_path":"/home/lucienne/workspace/logs/task-runs/mc-db-backup/387471.log","output":"Saved dated backup: /home/lucienne/workspace/luci-home/backups/mc-db-2026-06-07.db.gz\nSaved latest backup: /home/lucienne/workspace/luci-home/backups/mc-db-latest.db.gz\nPruned old backup: mc-db-2026-06-04.db.gz\nMC database export complete\n","started_at":"2026-06-07T01:30:20.363263+02:00","status":"completed","task_id":"mc-db-backup","task_name":"Nightly Mission Control database backup"},{"duration_s":30.672341,"finished_at":"2026-06-06T01:31:02.010964+02:00","id":382749,"log_path":"/home/lucienne/workspace/logs/task-runs/mc-db-backup/382749.log","output":"Saved dated backup: /home/lucienne/workspace/luci-home/backups/mc-db-2026-06-06.db.gz\nSaved latest backup: /home/lucienne/workspace/luci-home/backups/mc-db-latest.db.gz\nPruned old backup: mc-db-2026-06-03.db.gz\nMC database export complete\n","started_at":"2026-06-06T01:30:31.333964+02:00","status":"completed","task_id":"mc-db-backup","task_name":"Nightly Mission Control database backup"}],"runs_limit":20,"schedule":"30 1 * * *","schedule_label":{"description":"Daily at 01:30","is_custom":false,"label":"Daily","sort":4,"sort_time":"01:30"},"stats":{"avg_duration":31.46321875,"completed":8,"failed":0,"timeout":0,"total":8},"task":{"_description":"**OVERRIDES runtime profile:** uses `direct_python` (plain Python, no model) because the command chain never invokes the `claude` CLI or any LLM API \u2014 pure-infra task; scheduler provider env injection is a no-op (MC-4942 U12 sweep).\n\nExports mc.db as gzipped SQL dump to ~/workspace/luci-home/backups/.\nKeeps latest + last 3 daily snapshots. Runs at 01:30 SAST (after memory backup).","_file":"mc-db-backup.md","_path":"/home/lucienne/workspace/tasks/mc-db-backup.md","command":"python3 /home/lucienne/workspace/scripts/mc_db_export.py","enabled":true,"id":"mc-db-backup","notify_on":"failure","retry":false,"run_as":"shell","runtime_profile":"direct_python","schedule":"30 1 * * *","tags":["infrastructure","backup","database"],"timeout":120,"title":"Nightly Mission Control database backup"}}