osticket-db is not accessible

[MilorES]

The power went out and it stayed, I had been using it for a few weeks. The logs show:

osticket-db           | 2023-06-13.11:56:54 [NOTICE] ** [timezone] Timezone: Setting to 'Europe/Madrid' from 'Etc/GMT'
osticket-db           | 2023-06-13.13:56:55 [NOTICE] ** [monitoring] Container configured for monitoring with 'zabbix modern'
osticket-db           | 2023-06-13.13:56:55 [NOTICE] ** [scheduling] Container configured for scheduled tasks with 'cron'
osticket-db           | 2023-06-13.13:56:56 [NOTICE] ** [mariadb] Initializing MariaDB - Please wait..
osticket-db-backup    |                                                                        ,---.
osticket-db-backup    | ,--------.,--.                 ,--.            ,---.    ,--. ,--------.|   |
osticket-db-backup    | '--.  .--'`--',--.--. ,---.  ,-|  |     ,---. /  .-'    |  | '--.  .--'|  .'
osticket-db-backup    |    |  |   ,--.|  .--'| .-. :' .-. |    | .-. ||  `-,    |  |    |  |   |  |
osticket-db-backup    |    |  |   |  ||  |   \   --.\ `-' |    ' '-' '|  .-'    |  |.--.|  |   `--'
osticket-db-backup    |    `--'   `--'`--'    `----' `---'      `---' `--'      `--''--'`--'   .--.
osticket-db-backup    |                                                                        '--'
osticket-db-backup    | Image:  tiredofit/db-backup | Version  3.9.1 Type 'image_changelog' for details
osticket-db-backup    | Repository/Documentation: https://github.com/tiredofit/docker-db-backup/
osticket-db-backup    |
osticket-db-backup    | If this image provides you value  - Consider sponsoring my work for continued
osticket-db-backup    | development, timely updates, and feature requests. Commercial support available.
osticket-db-backup    |
osticket-db-backup    |                     More Info:  https://www.tiredofit.ca
osticket-db-backup    |
osticket-db-backup    | 2023-06-13.11:56:47 [NOTICE] ** [timezone] Timezone: Setting to 'Europe/Madrid' from 'Etc/GMT'
osticket-db-backup    | 2023-06-13.13:56:48 [NOTICE] ** [monitoring] Container configured for monitoring with 'zabbix modern'
osticket-db-backup    | 2023-06-13.13:56:48 [NOTICE] ** [scheduling] Container configured for scheduled tasks with 'cron'
osticket-db-backup    | 2023-06-13.13:56:49 [STARTING] ** [monitoring] [1] Starting Zabbix Agent (modern) 6.4.2
osticket-db-backup    | 2023-06-13.13:56:49 [STARTING] ** [scheduling] [1] Starting cron
osticket-db-backup    | 2023-06-13.13:56:54 [INFO] ** [db-backup] Next Backup at 2023-06-14 00:00:00 CEST
osticket-app          | 2023-06-13.13:57:36 [WARN] ** [osticket] MySQL/MariaDB Server 'osticket-db' is not accessible, retrying.. (30 seconds so far)
osticket-app          | 2023-06-13.13:57:41 [WARN] ** [osticket] MySQL/MariaDB Server 'osticket-db' is not accessible, retrying.. (35 seconds so far)
osticket-app          | 2023-06-13.13:57:46 [WARN] ** [osticket] MySQL/MariaDB Server 'osticket-db' is not accessible, retrying.. (40 seconds so far)
osticket-app          | 2023-06-13.13:57:51 [WARN] ** [osticket] MySQL/MariaDB Server 'osticket-db' is not accessible, retrying.. (45 seconds so far)
osticket-app          | 2023-06-13.13:57:56 [WARN] ** [osticket] MySQL/MariaDB Server 'osticket-db' is not accessible, retrying.. (50 seconds so far)
osticket-app          | 2023-06-13.13:58:01 [WARN] ** [osticket] MySQL/MariaDB Server 'osticket-db' is not accessible, retrying.. (55 seconds so far)

It gives the impression that mariadb does not start. Use your docker.

Entering the "machine" database

[tiredofit/mariadb:10.11-4.2.2 14:00:53 /] $ mysql
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld//mysqld.sock' (2)

error.log

[tiredofit/mariadb:10.11-4.2.2 14:02:21 /logs] $ cat error.log
2023-06-13 13:56:56 0 [Note] Starting MariaDB 10.11.2-MariaDB source revision cafba8761af55ae16cc69c9b53a341340a845b36 as process 896
2023-06-13 13:56:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2023-06-13 13:56:56 0 [Note] InnoDB: Number of transaction pools: 1
2023-06-13 13:56:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-06-13 13:56:56 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-06-13 13:56:56 0 [Note] InnoDB: Using Linux native AIO
2023-06-13 13:56:56 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB
2023-06-13 13:56:56 0 [Note] InnoDB: Completed initialization of buffer pool
2023-06-13 13:56:56 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2023-06-13 13:56:56 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT(16894923) at 16894923
2023-06-13 13:56:56 0 [ERROR] InnoDB: Log scan aborted at LSN 16894923
2023-06-13 13:56:56 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-06-13 13:56:56 0 [Note] InnoDB: Starting shutdown...
2023-06-13 13:56:56 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-06-13 13:56:56 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-06-13 13:56:56 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-06-13 13:56:56 0 [ERROR] Aborting

In dbackup there is nothing... any idea?

I'm surprised it says: Unknown/unsupported storage engine: InnoDB

○ → docker ps -a | grep tire
38abe1c095ed   tiredofit/osticket                     "/init"                  9 minutes ago   Up 9 minutes              80/tcp, 2020/tcp, 9000/tcp, 10050/tcp                                                                                         osticket-app
580936dbf508   tiredofit/mariadb:10.11                "/init"                  9 minutes ago   Up 9 minutes              2020/tcp, 3306/tcp, 10050/tcp                                                                                                 osticket-db
349926e6703e   tiredofit/db-backup:latest             "/init"                  9 minutes ago   Up 9 minutes              2020/tcp, 10050/tcp                                                                                                           osticket-db-backup

[tiredofit]

Looks like a corrupt database. Time to restore with the db-backup container..

[MilorES]

I already feared it, unfortunately. When I look at the folder it is empty. :( Should I delete the entire DB and it will start over?

Should I delete the whole db and it will start over?

[MilorES]

I completely reinstalled it using the sample docker-compose.yml although it fixed some bugs. Now he makes me the copy! I hope I don't have to learn how to restore it.

I want to put it in Spanish and change the templates, that shouldn't cause problems, right?

Note: What is the most appropriate channel to ask these questions.