Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR: relation "cert_bund_advs" does not exist at character 30 #48

Closed
lowcontrast opened this issue Jun 23, 2020 · 7 comments
Closed
Assignees
Labels
bug Something isn't working

Comments

@lowcontrast
Copy link

Describe the bug
Greenbone Setup Error

....
md manage:   INFO:2020-06-23 11h34.27 utc:546: Updating user OVAL definitions.
md manage:   INFO:2020-06-23 11h34.27 utc:546: Updating CVSS scores and CVE counts for CPEs
md manage:   INFO:2020-06-23 11h35.28 utc:546: Updating CVSS scores for OVAL definitions
md manage:   INFO:2020-06-23 11h35.31 utc:546: Updating placeholder CPEs
2020-06-23 11:35:42.444 UTC [549] ERROR:  relation "cert_bund_advs" does not exist at character 30
2020-06-23 11:35:42.444 UTC [549] STATEMENT:  SELECT EXISTS (SELECT * FROM cert_bund_advs  WHERE creation_time        > coalesce (CAST ((SELECT value FROM meta                           WHERE name                                 = 'cert_check_time')                          AS INTEGER),                    0));
md manage:   INFO:2020-06-23 11h35.42 utc:546: update_scap: Updating SCAP info succeeded
md manage:WARNING:2020-06-23 11h35.42 utc:546: sql_exec_internal: PQexec failed: ERROR:  relation "cert_bund_advs" does not exist
LINE 1: SELECT EXISTS (SELECT * FROM cert_bund_advs  WHERE creation_...
                                     ^
 (7)
md manage:WARNING:2020-06-23 11h35.42 utc:546: sql_exec_internal: SQL: SELECT EXISTS (SELECT * FROM cert_bund_advs  WHERE creation_time        > coalesce (CAST ((SELECT value FROM meta                           WHERE name                                 = 'cert_check_time')                          AS INTEGER),                    0));
md manage:WARNING:2020-06-23 11h35.42 utc:546: sql_x_internal: sql_exec_internal failed

To Reproduce
Steps to reproduce the behavior:
securecompliance/gvm:master

@lowcontrast lowcontrast added the bug Something isn't working label Jun 23, 2020
@pixelsquared pixelsquared changed the title ERROR: relation "cert_bund_advs" does not exist at character 30 ERROR: relation "cert_bund_advs" does not exist at character 30 (CU-8jk9n2) Jun 23, 2020
@lowcontrast
Copy link
Author

Issue at Greenbone Community: https://community.greenbone.net/t/gvm-10-on-alpine-linux/5324/6

@ghost
Copy link

ghost commented Jun 30, 2020

Also experiencig this issue unfortunately

@pixelsquared pixelsquared changed the title ERROR: relation "cert_bund_advs" does not exist at character 30 (CU-8jk9n2) ERROR: relation "cert_bund_advs" does not exist at character 30 Jun 30, 2020
@fropert
Copy link

fropert commented Jul 20, 2020

Same error in latest image

@Joshuapaul
Copy link

i am also facing same issue. any solution?

@captain-seasalt
Copy link

I am also facing this issue, @pixelsquared or @austinsonger do you have any solutions?

@chris-x86-64
Copy link

chris-x86-64 commented Sep 16, 2020

I sent a PR to the upstream, however, I'm not very sure if it will fix. greenbone/gvmd#1295

@austinsonger
Copy link
Contributor

#134

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

7 participants