Gvm always failed with sqlv: sql_exec_internal failed

root@56b641c3-dd79-c47e-a38a-86ef1b3220fd:~# gsad --version
Greenbone Security Assistant 20.08.1

root@56b641c3-dd79-c47e-a38a-86ef1b3220fd:~# gvmd --version
Greenbone Vulnerability Manager 20.08.1
Manager DB revision 233
Copyright © 2009-2021 Greenbone Networks GmbH
License: AGPL-3.0-or-later
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.

Ubuntu 20.04 ppa:mrazavi/gvm

I found that gvm db sync never finishes with error sqlv: sql_exec_internal failed, checking postgres log found an error message of “gvmduser@gvmd ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification”. The log file is available at https://gofile.io/d/iQgn4u (sorry for external link, I am a new user and is the forum built-in upload file function is restricted to me).

Is there any database schema or sql statement issue in gvm?

Ignore this. A clean reinstallation solved the problem

1 Like