Db not working after upgrade

Self-Hosted | v5
1

I usually update the docker compose occasionally… after the last upgrade db refused to start!! I did not change any thing in docker-compose (it is identical to repo)

Here is docker log:

db        | 2024-05-19 11:20::00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
db        | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
db        | 2024-05-19T11:20:10.330953Z 0 [System] [MY-015015] [Server] MySQL Server - start.
db        | 2024-05-19T11:20:10.586448Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1
db        | 2024-05-19T11:20:10.620009Z 0 [Warning] [MY-010001] [Server] Can't create thread to handle bootstrap (errno: 1)
db        | 2024-05-19T11:20:10.620057Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
db        | 2024-05-19T11:20:10.620067Z 0 [ERROR] [MY-010119] [Server] Aborting
db        | 2024-05-19T11:20:10.621429Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0)  MySQL Community Server - GPL.
db        | 2024-05-19T11:20:10.621443Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2

Hi,

Maybe this will help:

3

I tried that… same problem… DB refuse to start

4

@david do you have any suggestions?

5

This is typically seen when the db files themselves have been modified, or perhaps a different database intiialized? ie have you moved from mariadb to mysql in the config?

these files are outside of the scope of the invoice ninja installation, so upgrading the app, would not have impacted these files.

6

I can comfirm it is happend after pulling new docker image.
How to restore my data?

7

I have old backup, I tried to restore it then start docker compose again, I get the same error!!