Re: How to clean corrupt SQL joblog?

[Ole Tange]

On Wed, Mar 22, 2017 at 9:40 PM, Andy Loftus <aloftus@gmail.com> 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