Job database entry disappears

[derritter88]

IMPORTANT

Read and tick the following checkbox after you have created the issue or place an x inside the brackets ;)

• [x] I have read the CONTRIBUTING.md and followed the provided tips
• [x] I accept that the issue will be closed without comment if I do not check here
• [x] I accept that the issue will be closed without comment if I do not fill out all items in the issue template.

Explain the Problem

After around one day the database entry at oc_jobs disappears and News is no longer getting updateds from the RSS feeds. The only way to solve this issue is to de- and reactivate the News app.

The error also appeared at version 25 alpha 6

Steps to Reproduce

Explain what you did to encounter the issue

1. Install
2. Wait

System Information

• News app version: 25.0.0-alpha7
• Nextcloud version: [Nextcloud Hub 8] (29.0.2)
• Cron type: system cron
• PHP version: 8.2
• Database and version: Postgres 13
• Browser and version: Firefox 127
• OS and version: Windows 11

[Grotax]

Well that's strange.

So I assume executing ./occ news:updater:job will give some exception or fail somehow.

Any other maybe related issues on your instance?

[derritter88]

No, it does not look like that there is an error:

Checking update Status
Last Execution was 2024-06-16 08:50:02 UTC

I can only verify that there is an error via SQL:

SELECT *
from oc_jobs
WHERE class LIKE '%News%'
ORDER BY id;

Which gives me:

99934992    OCA\News\Cron\UpdaterJob    null    1718527802  1718530218  0   43  37a6259cc0c1dae299a7866489dff0bd    1

And this disappears after some time while the News app would still be active/enabled via Nextclouds app menu

[Grotax]

I see, well I have no idea how that could happen.

You could check the logs for errors.

The jobs table is updated every time the job runs. Maybe something is going wrong there.

No idea what the news app could do about this.

[derritter88]

Execution of Nextcloud main cron job works well and there are no errors on the CLI. The only thing I do see at Nextcloud logs would be: {"reqId":"c4dwQrgWe6gTm1F9l0vn","level":3,"time":"2024-06-16T11:53:44+02:00","remoteAddr":"","user":"--","app":"news","method":"","url":"--","message":"No parser can handle this stream","userAgent":"--","version":"29.0.2.2","data":{"app":"news"},"id":"666eb63e23641"}

But I am not sure if this would cause this major problem.

[SMillerDev]

That indicates that it did run, but it can't parse the feed.

[derritter88]

Yeah - strange behaviour of Nextcloud.

I'll monitor it and post any updates here.

[derritter88]

The problem "disappeared" after rebooting the whole hypervisor including the VM where Nextcloud is running. Not sure what caused this problem but after some days News is still at the job table and is being updated via Cron