# Rose-prune on remote host?

**URL:** <https://cylc.discourse.group/t/rose-prune-on-remote-host/618>\
**Category:** Rose Support\
**Created:** [March 26, 2023, 11:54pm UTC](https://cylc.discourse.group/t/rose-prune-on-remote-host/618 "2023-03-26T23:54:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![TomC](https://yyz2.discourse-cdn.com/free1/user_avatar/cylc.discourse.group/tomc/32/115_2.png) [@TomC](https://cylc.discourse.group/u/TomC)\
**Post date:** [March 26, 2023, 11:54pm UTC](https://cylc.discourse.group/t/rose-prune-on-remote-host/618/1 "2023-03-26T23:54:07Z")

</div>

Hi,

I’m in the process of moving one of the systems we have from Cylc7/rose to Cylc8/Rose2. I’m encountering some issues with `rose-prune` on a remote host. When I try to just use rose-prune as it was, I am getting an error `sqlite3.OperationalError: no such table: task_jobs`. Adding debug flags, I get:

```auto
[FAIL] 2023-03-26T22:55:32+0000 no such table: task_jobs
Traceback (most recent call last):
  File "HOME/miniconda3/envs/cylc-8.1.0/lib/python3.10/site-packages/metomi/rose/task_run.py", line 176, in main
    sys.exit(runner(opts, args))
  File "HOME/miniconda3/envs/cylc-8.1.0/lib/python3.10/site-packages/metomi/rose/run.py", line 201, in run
    return self.run_impl(opts, args, uuid, work_files)
  File "HOME/miniconda3/envs/cylc-8.1.0/lib/python3.10/site-packages/metomi/rose/task_run.py", line 130, in run_impl
    return self.app_runner(opts, args)
  File "HOME/miniconda3/envs/cylc-8.1.0/lib/python3.10/site-packages/metomi/rose/run.py", line 201, in run
    return self.run_impl(opts, args, uuid, work_files)
  File "HOME/miniconda3/envs/cylc-8.1.0/lib/python3.10/site-packages/metomi/rose/app_run.py", line 399, in run_impl
    return builtin_app.run(
  File "HOME/miniconda3/envs/cylc-8.1.0/lib/python3.10/site-packages/metomi/rose/apps/rose_prune.py", line 79, in run
    app_runner.suite_engine_proc.job_logs_housekeep_remote(
  File "HOME/miniconda3/envs/cylc-8.1.0/lib/python3.10/site-packages/metomi/rose/suite_engine_procs/cylc.py", line 275, in job_logs_housekeep_remote
    auths = self.get_suite_jobs_auths(
  File "HOME/miniconda3/envs/cylc-8.1.0/lib/python3.10/site-packages/metomi/rose/suite_engine_procs/cylc.py", line 85, in get_suite_jobs_auths
    new_platforms = get_platforms_from_task_jobs(suite_name, cycle)
  File "HOME/miniconda3/envs/cylc-8.1.0/lib/python3.10/site-packages/cylc/rose/platform_utils.py", line 135, in get_platforms_from_task_jobs
    raise db_exc
  File "HOME/miniconda3/envs/cylc-8.1.0/lib/python3.10/site-packages/cylc/rose/platform_utils.py", line 115, in get_platforms_from_task_jobs
    for row in dao.connect().execute(stmt, [cyclepoint]):
sqlite3.OperationalError: no such table: task_jobs

```

The app conf file is below, where OFFSET\_KEEP\_OLD\_RUNS in this test case is `-PT48H`

```auto
meta=rose_prune
mode=rose_prune

[prune]
prune-remote-logs-at=$OFFSET_KEEP_OLD_RUNS
prune-server-logs-at=$OFFSET_KEEP_OLD_RUNS
prune{work}=$OFFSET_KEEP_OLD_RUNS
prune{share/cycle}=$OFFSET_KEEP_OLD_RUNS

```

How do I use `rose-prune` for housekeeping the remote platform these days, pruning directories from log, work, share/cycle?

Thanks.

---

<div class="post-metadata">

**Author:** ![TomC](https://yyz2.discourse-cdn.com/free1/user_avatar/cylc.discourse.group/tomc/32/115_2.png) [@TomC](https://cylc.discourse.group/u/TomC)\
**Post date:** [March 27, 2023, 3:50am UTC](https://cylc.discourse.group/t/rose-prune-on-remote-host/618/2 "2023-03-27T03:50:19Z")

</div>

Whilst I’m curious about the above, I’ve found `rose-prune`, in our environment, now properly cleans up the remote hosts, so I can run it with one task locally and cleanup both platforms. I guess we’ve got some settings different now, or rose has changed behaviour to work in our environments.

---

<div class="post-metadata">

**Author:** ![oliver.sanders](https://yyz2.discourse-cdn.com/free1/user_avatar/cylc.discourse.group/oliver.sanders/32/110_2.png) [@oliver.sanders](https://cylc.discourse.group/u/oliver.sanders)\
**Post date:** [March 27, 2023, 9:18am UTC](https://cylc.discourse.group/t/rose-prune-on-remote-host/618/3 "2023-03-27T09:18:57Z")

</div>

I think you’re trying to run `rose_prune` remotely?

> It is designed to work under [rose task-run](http://metomi.github.io/rose/doc/html/api/command-reference.html#command-rose-task-run) on the host that runs the suite daemon.
> 
> – [rose\_prune — Rose Documentation 2.1.0 documentation](http://metomi.github.io/rose/doc/html/api/built-in/rose_prune.html)

---

<div class="post-metadata">

**Author:** ![TomC](https://yyz2.discourse-cdn.com/free1/user_avatar/cylc.discourse.group/tomc/32/115_2.png) [@TomC](https://cylc.discourse.group/u/TomC)\
**Post date:** [March 27, 2023, 9:34am UTC](https://cylc.discourse.group/t/rose-prune-on-remote-host/618/4 "2023-03-27T09:34:26Z")

</div>

Ah, missed that sentence. Thanks.