Bug: database migration error when upgrading to version 26.16.0

[sed-ats]

Hello
yesterday I had an error when updating to gvmd version 26.16.0

I was updating from version 26.12.1

here are the logs

md main:MESSAGE:2026-02-19 11h36.25 utc:3340258: Greenbone Vulnerability Manager version 26.16.0 (DB revision 268)

md main: INFO:2026-02-19 11h36.25 utc:3340258: Migrating database.
md main: INFO:2026-02-19 11h36.25 utc:3340258: Migrating to 263
md main: INFO:2026-02-19 11h36.25 utc:3340258: Migrating to 264
md main: INFO:2026-02-19 11h36.25 utc:3340258: Migrating to 265
md main: INFO:2026-02-19 11h36.25 utc:3340258: Migrating to 266
md main: INFO:2026-02-19 11h36.25 utc:3340258: Migrating to 267
md manage:WARNING:2026-02-19 11h36.25 utc:3340258: sql_exec_internal: PQexec failed: ERROR: relation "asset_snapshots" does not exist
(7)
md manage:WARNING:2026-02-19 11h36.25 utc:3340258: sql_exec_internal: SQL: ALTER TABLE asset_snapshots ADD COLUMN scanner INTEGER;
md manage:WARNING:2026-02-19 11h36.25 utc:3340258: sqlv: sql_exec_internal failed
md main:MESSAGE:2026-02-19 11h37.41 utc:3340318: Greenbone Vulnerability Manager version 26.16.0 (DB revision 268)
md manage:MESSAGE:2026-02-19 11h37.41 utc:3340318: check_db_versions: database version of database: 266
md manage:MESSAGE:2026-02-19 11h37.41 utc:3340318: check_db_versions: database version supported by manager: 268
md main:CRITICAL:2026-02-19 11h37.41 utc:3340318: gvmd: database is wrong version
md main:CRITICAL:2026-02-19 11h37.41 utc:3340318: gvmd: Your database is too old for this version of gvmd.
md main:CRITICAL:2026-02-19 11h37.41 utc:3340318: gvmd: Please migrate to the current data model.
md main:CRITICAL:2026-02-19 11h37.41 utc:3340318: gvmd: Use a command like this: gvmd --migrate

md main:MESSAGE:2026-02-19 11h55.48 utc:3358545: Greenbone Vulnerability Manager version 26.16.0 (DB revision 268)
md main: INFO:2026-02-19 11h55.48 utc:3358545: Migrating database.
md main: INFO:2026-02-19 11h55.48 utc:3358545: Migrating to 267
md manage:WARNING:2026-02-19 11h55.48 utc:3358545: sql_exec_internal: PQexec failed: ERROR: relation "asset_snapshots" does not exist
(7)
md manage:WARNING:2026-02-19 11h55.48 utc:3358545: sql_exec_internal: SQL: ALTER TABLE asset_snapshots ADD COLUMN scanner INTEGER;
md manage:WARNING:2026-02-19 11h55.48 utc:3358545: sqlv: sql_exec_internal failed

md main:MESSAGE:2026-02-19 13h19.44 utc:3395532: Greenbone Vulnerability Manager version 26.14.0 (DB revision 265)
md manage:MESSAGE:2026-02-19 13h19.44 utc:3395532: check_db_versions: database version of database: 266
md manage:MESSAGE:2026-02-19 13h19.44 utc:3395532: check_db_versions: database version supported by manager: 265
md main:CRITICAL:2026-02-19 13h19.44 utc:3395532: gvmd: database is wrong version
md main:CRITICAL:2026-02-19 13h19.44 utc:3395532: gvmd: Your database is too new for this version of gvmd.
md main:CRITICAL:2026-02-19 13h19.44 utc:3395532: gvmd: Please upgrade gvmd to a newer version.
md main:MESSAGE:2026-02-19 13h24.24 utc:3397201: Greenbone Vulnerability Manager version 26.15.0 (DB revision 266)

I managed to start the service on version 26.15.0

Operating System

Ubuntu 24.04.4

[sed-ats]

additional information, also now when I go to Scan config -> click edit Full and fast -> Family - Brute force attacks -> edit
I get an error in the browser
An internal error occurred while getting list of configs. The current list of configs is not available. Diagnostics: Failure to receive response from manager daemon.

and in the gvmd logs this error

md manage:WARNING:2026-02-20 16h28.07 utc:4639: sql_exec_internal: PQexec failed: ERROR:  ORDER BY "name" is ambiguous
LINE 1: ...ND nvts.oid = nvt_selectors.family_or_nvt ORDER BY name ASC;
                                                              ^
 (7)
md manage:WARNING:2026-02-20 16h28.07 utc:4639: sql_exec_internal: SQL: SELECT id, uuid, name, comment, creation_time, modification_time, creation_time AS created, modification_time AS modified, '' AS _owner, 0, oid, modification_time AS version, name, cve, tag, category, family, cvss_base, cvss_base AS severity, cvss_base AS cvss, qod, qod_type, solution_type, tag AS script_tags, solution, summary, insight, affected, impact, detection, solution_method, coalesce (epss_score, 0.0) AS epss_score, coalesce (epss_percentile, 0.0) AS epss_percentile, epss_cve, epss_severity, coalesce (max_epss_score, 0.0) AS max_epss_score, coalesce (max_epss_percentile, 0.0) AS max_epss_percentile, max_epss_cve, max_epss_severity, discovery FROM nvts WHERE family = 'Brute force attacks' EXCEPT SELECT nvts.id, nvts.uuid, nvts.name, nvts.comment, nvts.creation_time, nvts.modification_time, nvts.creation_time AS created, nvts.modification_time AS modified, '' AS _owner, 0, oid, modification_time AS version, nvts.name, cve, tag, category, nvts.family, cvss_base, cvss_base AS severity, cvss_base AS cvss, qod, qod_type, solution_type, tag AS script_tags, solution, summary, insight, affected, impact, detection, solution_method, coalesce (epss_score, 0.0) AS epss_score, coalesce (epss_percentile, 0.0) AS epss_percentile, epss_cve, epss_severity, coalesce (max_epss_score, 0.0) AS max_epss_score, coalesce (max_epss_percentile, 0.0) AS max_epss_percentile, max_epss_cve, max_epss_severity, discovery FROM nvt_selectors, nvts WHERE nvts.family = 'Brute force attacks' AND nvt_selectors.name = '82c75178-5a41-4499-97e4-66b946869262' AND nvt_selectors.family = 'Brute force attacks' AND nvt_selectors.type = 2 AND nvt_selectors.exclude = 1 AND nvts.oid = nvt_selectors.family_or_nvt ORDER BY name ASC;
md manage:WARNING:2026-02-20 16h28.07 utc:4639: next: sql_exec_internal failed
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: gvmd: Serving client(+0x140080) [0x56aae5794080]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: /lib/x86_64-linux-gnu/libc.so.6(+0x45330) [0x7f1996645330]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: /lib/x86_64-linux-gnu/libc.so.6(pthread_kill+0x11c) [0x7f199669eb2c]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x1e) [0x7f199664527e]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: /lib/x86_64-linux-gnu/libc.so.6(abort+0xdf) [0x7f19966288ff]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: gvmd: Serving client(+0x5b461) [0x56aae56af461]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: gvmd: Serving client(+0x60ea0) [0x56aae56b4ea0]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x629b7) [0x7f1996a4f9b7]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_markup_parse_context_parse+0xa6f) [0x7f1996a51baf]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: gvmd: Serving client(+0x945ef) [0x56aae56e85ef]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: gvmd: Serving client(+0x1445ac) [0x56aae57985ac]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: gvmd: Serving client(+0x13fc04) [0x56aae5793c04]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: gvmd: Serving client(+0x1402b1) [0x56aae57942b1]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: gvmd: Serving client(+0x1438f9) [0x56aae57978f9]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: /lib/x86_64-linux-gnu/libc.so.6(+0x2a1ca) [0x7f199662a1ca]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x8b) [0x7f199662a28b]
md   main:MESSAGE:2026-02-20 16h28.07 utc:4639: BACKTRACE: gvmd: Serving client(+0x5b4a5) [0x56aae56af4a5]
md manage:MESSAGE:2026-02-20 16h28.07 utc:4639: Received Aborted signal