OpenVAS DB migration error - rev146->184: no such table: main.nvts_172 about gvmd

[volkov-am]

The problem raised with sqlite >= 3.25.0

Starting with sqlite-3.25.0 ALTER TABLE ... RENAME TO ... also rename dependent views

From sqlite Changelog:

2018-09-15 (3.25.0)
2.b. Fix table rename feature so that it also updates references to the renamed table in triggers and views.
https://sqlite.org/changes.html#version_3_25_0

Openvas migrate code:

migrate_172_to_173()
"ALTER TABLE nvts RENAME TO nvts_172;"
...
"DROP TABLE nvts_172;"

It works well with older sqlite versions but it breaks results_autofp view with recent sqlite

Workaround:
recreate results_autofp view with correct table name reference:

(echo "DROP VIEW results_autofp;"; sqlite3 /var/lib/openvas/mgr/tasks.db '.schema results_autofp' | sed 's/nvts_172/nvts/g') | sqlite3 /var/lib/openvas/mgr/tasks.db

[olafweiler]

Built latest stable version from source (e.g. latest OpenVAS Manager 7.0.3, etc.).
--> Migration works fine there.

Not sure, what's wrong with the Debian binary distribution.
--> Issue can be closed.

[metersales]

The problem raised with sqlite >= 3.25.0

Starting with sqlite-3.25.0 ALTER TABLE ... RENAME TO ... also rename dependent views

From sqlite Changelog:

2018-09-15 (3.25.0)
2.b. Fix table rename feature so that it also updates references to the renamed table in triggers and views.
https://sqlite.org/changes.html#version_3_25_0

Openvas migrate code:

migrate_172_to_173()
"ALTER TABLE nvts RENAME TO nvts_172;"
...
"DROP TABLE nvts_172;"

It works well with older sqlite versions but it breaks results_autofp view with recent sqlite

Workaround:
recreate results_autofp view with correct table name reference:

(echo "DROP VIEW results_autofp;"; sqlite3 /var/lib/openvas/mgr/tasks.db '.schema results_autofp' | sed 's/nvts_172/nvts/g') | sqlite3 /var/lib/openvas/mgr/tasks.db

Perhaps I'm just a total newb, but how do I use the workaround? Is this to be used in bash or after logging in to sqlite3 or somewhere else? I'm having this problem in Ubuntu 20.04. I just upgraded from 18.04. I tried removing the package and reinstalling, but that didn't help. This seems to be the only answer available to me. I would appreciate any help you might offer.