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
gvmd version 9.0.1~git-e250176b-gvmd-9.0
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