Under Linux Mint / Ubuntu; gvmd 21.04 always fails optimizing result nvts.
md main:MESSAGE:2021-07-17 00h03.24 utc:26654: Greenbone Vulnerability Manager version 21.4.0~git-49b36f924-gvmd-21.04 (GIT revision 49b36f924-gvmd-21.04) (DB revision 242) md manage: INFO:2021-07-17 00h03.24 utc:26654: Optimizing: cleanup-result-nvts. md manage:WARNING:2021-07-17 00h03.29 utc:26654: sql_exec_internal: PQexec failed: ERROR: more than one row returned by a subquery used as an expression (7) md manage:WARNING:2021-07-17 00h03.29 utc:26654: sql_exec_internal: SQL: UPDATE results SET nvt = (SELECT oid FROM nvts WHERE name = nvt), result_nvt = NULL WHERE nvt IN (SELECT name FROM nvts WHERE name != oid); md manage:WARNING:2021-07-17 00h03.29 utc:26654: sqlv: sql_exec_internal failed
Other optimizations works fine. Gvmd works fine. II have a crontab running this command on a weekly basis, and it systematically fails with the same error.
Anyone has a clue as to why this is happening ?