Skip to content

Bugfix in the new_jobs command

Compare
Choose a tag to compare
@ThomasLecocq ThomasLecocq released this 26 Mar 10:24
· 778 commits to master since this release

This is a bugfix release.

When running the new_jobs procedure, the jobs are "inserted" in the database, even if they already existed (they should be "updated"). This is because of the complete rewrite of the code to optimize the operation.

As this optimization is mostly useful upon first run, I've added a parameter --init to the command. If provided, the "massive insert" procedure is used, if not, then the classic "insert or update if existing" is used.

So, upon first run : msnoise new_jobs --init
And afterwards (in cron, e.g.): ``msnoise new_jobs`

Users who have already run MSNoise 1.3 on their archive need to clean the jobs table in the database. The buggy jobs are those "CC" jobs which are still marked "I"n progress after the compute_cc procedure, and with a "lastmod" = "NULL". They can be easily identified and removed.

a classic SQL command would be:

DELETE from jobs WHERE lastmod is NULL;