Sql_prepare_internal: sqlite3_prepare failed: no such table: tickets

Since today, after adding some hosts I was prompted with an error message inside webui: a task I wanted to delete told me it could not be deleted an the state of this task would be undefined.
Some time later gvmd stopped working and was reported to be unreachable, I looked using ps tried to restart it and I found within logs:

md manage:WARNING:2019-01-11 10h14.24 utc:65603: sql_prepare_internal: sqlite3_prepare failed: no such table: tickets
md manage:WARNING:2019-01-11 10h14.24 utc:65603: sqlv: sql_prepare_internal failed
md manage:WARNING:2019-01-11 10h14.24 utc:65603: sql_close: attempt to close db with open statement(s)

gvmd does start, exaust this warning and terminates. Any idea what to do to make it work again?

GVM Versions

gsad:

ec066dd67 2019-01-08 | Merge pull request #1114 from swaterkamp/SMBAlertsFilePathType (HEAD -> master, origin/master, origin/HEAD)

Greenbone Security Assistant 8.0+beta3
GIT revision ec066dd67-master
Copyright (C) 2010-2016 Greenbone Networks GmbH
License GPLv2+: GNU GPL version 2 or later
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.

gvmd:

c094bc57 2019-01-10 | Merge pull request #319 from mattmundell/content-composer-support (HEAD -> master, origin/master, origin/HEAD)

Greenbone Vulnerability Manager 8.0+beta2
GIT revision c094bc57-master
Manager DB revision 201
Copyright (C) 2010-2017 Greenbone Networks GmbH
License GPLv2+: GNU GPL version 2 or later
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.

openvassd:

ad2274a 2019-01-10 | Merge pull request #240 from jjnicola/fix-rsa-pad (HEAD -> master, origin/master, origin/HEAD)

OpenVAS Scanner 6.0+beta3
GIT revision ad2274a-master
Most new code since 2005: (C) 2018 Greenbone Networks GmbH
Nessus origin: (C) 2004 Renaud Deraison <deraison@nessus.org>
License GPLv2: GNU GPL version 2
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.

gvm-libs:

6484f52e 2019-01-07 | Remove TODO. Since multiple KB backends are not supported, just Redis. (HEAD -> master, origin/master, origin/HEAD)

gvm-tools:

2be5246 2019-01-03 | Merge pull request #147 from wiegandm/scripts_style (HEAD -> master, origin/master, origin/HEAD)

node:

v11.6.0

redis-server:

Redis server v=5.0.3 sha=00000000:0 malloc=jemalloc-5.1.0 bits=64 build=23e95a3edb9c526b

Environment

Operating system:

Linux gvm10 4.18.0-3-amd64 #1 SMP Debian 4.18.20-2 (2018-11-23) x86_64 GNU/Linux
Debian testing (buster/sid)

Installation method / source:

source installation, git checkout

Please be aware you are using Software maximum in Beta state and not released for production. So you can open a issue at Gib-Hub.

1 Like

If you are running gvm from master branches you should expect such failures very often. We heavily advice not to use any master branch!

Nevertheless this should fix your issue

3 Likes