SQL result insert fails

Building from Source and Advanced Topics
1

Hi,

One of my scans fails when trying to insert the results into the postgres database. This is after an upgrade from 22.4 to 23 (I did run the “gvmd --migrate” command). The error only seems to occur when I run a scan that logs into the target system using ssh.

The problematic insert seems to be ‘None’ into the severity column.
OpenVAS 23.0.1
gvm-libs 22.8.0
Greenbone Vulnerability Manager 23.2.0
Manager DB revision 255

Any help would be appreciated.

d manage:WARNING:2024-05-29 12h36.45 UTC:302956: sql_exec_internal: PQexec failed: ERROR:  invalid input syntax for type real: "None"
LINE 1: ....3.6.1.4.1.25623.1.1.12.2024.6708.1',         '', 'None', 'A...
                                                             ^
 (7)
md manage:WARNING:2024-05-29 12h36.45 UTC:302956: 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, hash_value) VALUES (NULL, m_now(), 50, '192.168.35.89', '', 'package', '1.3.6.1.4.1.25623.1.1.12.2024.6708.1',         '', 'None', 'Alarm', 75, '', '
Vulnerable package:   graphviz
Installed version:    2.42.2-6
Fixed version:      >=2.42.2-6ubuntu0.1~esm1
',         '', make_uuid (),         (SELECT id FROM result_nvts WHERE nvt = '1.3.6.1.4.1.25623.1.1.12.2024.6708.1'), '1ffd7ec43e3356a644a9536a52160e75');
md manage:WARNING:2024-05-29 12h36.45 UTC:302956: sqlv: sql_exec_internal failed
md manage:WARNING:2024-05-29 12h36.45 UTC:302956: manage_cleanup_process_error: Error exit, setting running task to Interrupted
md manage:WARNING:2024-05-29 12h36.45 UTC:302956: sql_exec_internal: PQexec failed: ERROR:  current transaction is aborted, commands ignored until end of transaction block
 (7)
md manage:WARNING:2024-05-29 12h36.45 UTC:302956: sql_exec_internal: SQL: UPDATE reports SET scan_run_status = 13 WHERE id = 144;
md manage:WARNING:2024-05-29 12h36.45 UTC:302956: sqlv: sql_exec_internal failed
2

Edit: Greenbone Vulnerability Manager 23.2.0 doesn’t look current (Releases · greenbone/gvmd · GitHub) so it could worth a try to update to the most recent version 23.6.2 of the manager)

This doesn’t look like an issue on which the community could help so it would be the best to raise an issue over here:

https://github.com/greenbone/gvmd/issues

3

It is the version specified by the build from source guide:

I could upgrade it separately but that would probably mean updating all components.

4

Have you solved the problem?

We have similar issue with all our scan tasks, nothing works.
Updating gvmd to 23.6.2 and gvm_libs to 22.9.0 doesn’t helped.

5

No I have not. Normal scans work for me but not when I want Greenbone to log in using ssh

6

I think it might be related to PGSQL 16. There is no more pgsql 15 on ubuntu 23 for example, I had to install 16 so I am not sure if syntax changed from 15 to 16 for this insert. Btw having same problem.