Hi all,
I’m scanning an Ubuntu host authenticated with SSH, there was an exception occurred as shown in the following logs and the task status is stuck at 100%:
ospd-openvas
log:
OSPD[44] 2022-10-26 12:20:42,693: WARNING: (ospd_openvas.daemon) Invalid VT oid 1.3.6.1.4.1.25623.1.1.12.2022.5570.1 for a result
OSPD[44] 2022-10-26 12:20:44,302: INFO: (ospd.ospd) 21f0eb1a-1662-49ba-b0b7-b71c854d78a5: Host scan finished.
OSPD[44] 2022-10-26 12:20:44,305: INFO: (ospd.ospd) 21f0eb1a-1662-49ba-b0b7-b71c854d78a5: Scan finished.
gvmd
log:
event task:MESSAGE:2022-10-26 11h54.06 UTC:1055: Status of task 19474 - ydZHAz (170e8f6d-30af-4cef-9a6f-a172afd3af37) has changed to Queued
event task:MESSAGE:2022-10-26 11h54.16 UTC:1055: Status of task 19474 - ydZHAz (170e8f6d-30af-4cef-9a6f-a172afd3af37) has changed to Running
md manage:WARNING:2022-10-26 12h20.45 UTC:1055: sql_exec_internal: PQexec failed: ERROR: invalid input syntax for type real: "None"
LINE 1: ....3.6.1.4.1.25623.1.1.12.2020.4616.1', '', 'None', 'A...
^
(7)
md manage:WARNING:2022-10-26 12h20.45 UTC:1055: sql_exec_internal: SQL: INSERT into results (owner, date, task, host, hostname, port, nvt, nvt_version, severity, type, qod, qod_type, description, path, uuid, result_nvt) VALUES (NULL, m_now(), 1, '10.0.0.1', '', 'package', '1.3.6.1.4.1.25623.1.1.12.2020.4616.1', '', 'None', 'Alarm', 75, '', '
Vulnerable package: accountsservice
Installed version: accountsservice-0.6.45-1ubuntu1
Fixed version: >=accountsservice-0.6.45-1ubuntu1.3
Vulnerable package: libaccountsservice0
Installed version: libaccountsservice0-0.6.45-1ubuntu1
Fixed version: >=libaccountsservice0-0.6.45-1ubuntu1.3
', 'None', make_uuid (), (SELECT id FROM result_nvts WHERE nvt = '1.3.6.1.4.1.25623.1.1.12.2020.4616.1'));
md manage:WARNING:2022-10-26 12h20.45 UTC:1055: sqlv: sql_exec_internal failed
md manage:WARNING:2022-10-26 12h20.45 UTC:1055: manage_cleanup_process_error: Error exit, setting running task to Interrupted
md manage:WARNING:2022-10-26 12h20.45 UTC:1055: sql_exec_internal: PQexec failed: ERROR: current transaction is aborted, commands ignored until end of transaction block
(7)
md manage:WARNING:2022-10-26 12h20.45 UTC:1055: sql_exec_internal: SQL: UPDATE reports SET scan_run_status = 13 WHERE id = 1;
md manage:WARNING:2022-10-26 12h20.45 UTC:1055: sqlv: sql_exec_internal failed
Maybe there is a problem in notus
VT update, but I think it is better to handle the exception so that the task can be properly stopped.