Task stuck in Requested state

Archive Greenbone Community Edition
1

Environment

Operating system:
Ubuntu 18.04 LTS
Kernel: (‘uname -a’)
5.0.0-32-generic #34~18.04.2-Ubuntu SMP Thu Oct 10 10:36:02 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
Installation method / source:
Installation from source
OpenVAS 7.0.1
gvm-libs 11.0.1
gvmd version 9.0.1~git-e250176b-gvmd-9.0

Hello,

I have an issue with a task stuck in “Requested” status. I cannot stop / delete the task as it’s seen in active state. Restarting gvmd / rebooting the system doesn’t help; task is still seen as Requested.

I believe something wrong has happened with gvmd and the postgres db. I am unfortunately not an SQL expert, so I don’t know how to manually fix this using SQL commands.

Does anyone know how to force a task status change using SQL, or any other mean to fix that issue ? I have backups obviously, but since that task has been stuck for several weeks now, I will have to reload from a very old backup.

Thanks a lot

2

this way: openvasmd-sqlite --disable-scheduling

3

Thanks ericyee for your reply. I’ll give it a try, but I’m skeptical disabling scheduled tasks will solve the issue. To my understanding, scheduled tasks and tasks status are two things different. So I don’t see why disabling a schedule would reset a task status, but perhaps I’m missing something ?