Cronjob blocking update (forever)

[jancborchardt]

Both @skjnldsv and me had this issue earlier, when an update gave us this message:

Waiting for cron to finish (check again in 5 seconds)

And that just kept coming again and again. Setting maintenance mode to false also does not work.

It can be fixed using UPDATE oc_jobs SET reserved_at=0; (thanks @nickvergessen), but should probably not happen.

cc @MorrisJobke @nickvergessen

[nextcloud-bot]

GitMate.io thinks possibly related issues are #2958 (Update error), #7434 (Update Failure ), #4424 (Update DOMPurify), #3636 (Update fails), and #9193 (W2G2 update problem).

[MorrisJobke]

It can be fixed using UPDATE oc_jobs SET reserved_at=0 (thanks @nickvergessen), but should probably not happen.

This was added on purpose to not have a running background job while updating. This is not really a regression, but a symptom of a previously broken behavior that was just ignored. Why do you have jobs that where reserved but never finished? Which jobs are still reserved?

[MorrisJobke]

ref #9900

[jancborchardt]

Why do you have jobs that where reserved but never finished? Which jobs are still reserved?

I have no idea – it’s on my local dev instance, and these were the ones with a reserved_at value of over 0:

INSERT INTO oc_jobs VALUES(5,'OCA\DAV\CardDAV\SyncJob','null',1515071551,1529926705,1529926705,0);
INSERT INTO oc_jobs VALUES(30,'OCA\Deck\Cron\DeleteCron','null',1517851983,1529926705,1529926705,0);

[MorrisJobke]

Anything in the logs which says "cron" as app?

[jancborchardt]

@skjnldsv did you have anything like that?

I need to check back tomorrow, am mobile only.

[skjnldsv]

I had an error about a missing index 0 (was on the level array a few lines above the waitforcron function)
Aside from that, nothing! :(

[MorrisJobke]

Ping me once you have this again and do some screensharing/pair-debugging