On Wed, Mar 22, 2017 at 9:40 PM, Andy Loftus <[email protected]> wrote:
> While running some jobs in parallel, the filesystem filled up so running
> tasks died but never updated the joblog (joblog is a sqlite3 DB file).
> There are 24 tasks with an Exitcode of -1220.
>
> How can I clean up the SQL joblog so tasks with Exitcode=-1220 will get
> re-run the next time parallel starts?
>From man parallel:
EXIT STATUS
:
-1000 (In SQL table)
Job is ready to run (set by --sqlmaster).
-1220 (In SQL table)
Job is taken by worker (set by --sqlworker).
So update it to -1000 and it should be picked up by a worker.
> I thought about resetting the row to look like a new task, but I'm not sure
> how to set the default Command value.
update mytable set exitval=-1000 where exitval=-1220;
/Ole
