the table "dbversion" was not found.

[msohani]

Dear All,
Hi,

i just faced with this error
Unable to determine current Zabbix database version: the table "dbversion" was not foundrelated snapshot attached, i searched about this error many times and do necessary actions but nothings changed
please check this log too :

/var/log/mysql# vi error.log

2024-01-31T05:58:17.156787Z 4 [System] [MY-013381] [Server] Server upgrade from '80035' to '80036' started.
2024-01-31T05:58:22.287610Z 4 [System] [MY-013381] [Server] Server upgrade from '80035' to '80036' completed.
2024-01-31T05:58:22.423500Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-01-31T05:58:22.423554Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-01-31T05:58:22.425024Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2024-01-31T05:58:22.450340Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36-0ubuntu0.20.04.1' socket: '/tmp/tmp.pdWAnCxkjX/mysqld.sock' port: 0 (Ubuntu).
2024-01-31T05:58:22.450322Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-01-31T05:58:22.494377Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36-0ubuntu0.20.04.1).
2024-01-31T05:58:24.566285Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1) (Ubuntu).
2024-01-31T05:58:25.049657Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 149775
2024-01-31T05:58:25.062035Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-01-31T05:58:25.300050Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-01-31T05:58:25.523207Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-01-31T05:58:25.523263Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-01-31T05:58:25.524951Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2024-01-31T05:58:25.558495Z 7 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.36-0ubuntu0.20.04.1).
2024-01-31T05:58:25.559688Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-01-31T05:58:27.292748Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1) (Ubuntu).
2024-01-31T05:58:29.092379Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 149924
2024-01-31T05:58:29.102069Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-01-31T05:58:29.332667Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-01-31T05:58:29.601692Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-01-31T05:58:29.601781Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-01-31T05:58:29.633539Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-01-31T05:58:29.633627Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36-0ubuntu0.20.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).

Zabbix server Version :

zabbix_server --version
zabbix_server (Zabbix) 6.4.11


Mysql version :
Your MySQL connection id is 21
Server version: 8.0.36-0ubuntu0.20.04.1 (Ubuntu)

my sql databases :

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| zabbix |
+--------------------+
5 rows in set (0.00 sec)

mysql> use zabbix;
Database changed

mysql> show tables;
+------------------+
| Tables_in_zabbix |
+------------------+
| applications |
| dchecks |
| drules |
| group_discovery |
| group_prototype |
| hosts |
| hstgrp |
| httpstep |
| httptest |
| interface |
| items |
| maintenances |
| screen_user |
| screen_usrgrp |
| screens |
| screens_items |
| slides |
| slideshow_user |
| slideshow_usrgrp |
| slideshows |
| users |
| valuemaps |
+------------------+
i don't know what to do anymore

[cyber]

Your log snippet is from mysql log, seems you upgraded it and it works now...
The table list looks very short for what it needs to be .. I think there should be 100+ tables

If this is a new installation, you probably need to recreate your DB schema, as it is clearly bad... And then try again connecting to it.
If it was a working Zabbix instance before... you backup maybe handy at this point... but there are better mysql people around here, than I am ...