Report Generation failing

And now for my weekly GVM question. I deployed gvm10 under sqlite3 and over a week or so performance slowly deteriorated as scans were run and reports were imported from our old system. . I then ran the script to convert to postgres, which per the script, did run successfully. TBH though, I’m not sure if the newer database is being used. Is there a clear way to tell?

The larger problem I have today is that reports can not longer be generated by generating a PDF or scheduling an alert. We just get a timeout similar to.

A timeout for the request to url https://192.168.20.137/gmp?token=0166ac53-6e86-409a-8c06-4b96e58c1562&cmd=get_report&report_id=20e598cb-b5ef-459e-aae6-a189288ef7f4&report_format_id=c402cc3e-b531-11e1-9163-406186ea4fc5&filter=apply_overrides%3D0%20min_qod%3D70%20rows%3D-1%20first%3D1%20sort%3Dname%20levels%3Dhml%20notes%3D1%20overrides%3D1 occurred.

I’m guessing the SQL Server is swamping? Any ideas on where to look on this one? the various log files aren’t showing much.

GVM versions

gsa: (‘gsad --version’) 8.01
gvm: (‘gvmd --version’) 8.01
openvas-scanner: (‘openvassd --version’) 6.01
gvm-libs: 1.5.32

Environment

Operating system: Ubuntu 18.04
Kernel: (‘uname -a’) 4.15.0…65
Installation method / source: source

Did you re-compile your GVM with the correct PSQL libraries ? If not please do so.

1 Like

If you build from source you can check the gvmd symlink in your sbin directory. It links to the binary used for the database backend e.g. gvmd-pg.

1 Like

This seems to be sorted now. Thanks for the input gentlemen!