Issue with Deployment on Docker

[samuellhwarren]

Using official DOCKER HUB image from your team, I get database errors on startup. The only thing i did was upgrade to an arm friendly version of mysql (version 8.0.33)

Here's the docker-compose file i am using:
version: "3.4"

services:
app:
image: monica
depends_on:
- db
ports:
- 8080:80
environment:
- APP_KEY=(I have the key redacted for security)
- DB_HOST=db
- DB_USERNAME=monica
- DB_PASSWORD=( again redacted)
volumes:
- /home/sam/monica:/var/www/html/storage
restart: always

db:
image: mysql:8.0.33
environment:
- MYSQL_RANDOM_ROOT_PASSWORD=true
- MYSQL_DATABASE=monica
- MYSQL_USER=monica
- MYSQL_PASSWORD=( again redacted)
volumes:
- /home/sam/monica/data:/var/lib/mysql
restart: always

volumes:
data:
name: data
mysql:
name: mysql

I get the following errors:
2023-04-27T23:33:11.000524Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33) MySQL Community Server - GPL.
2023-04-27 23:34:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.33-1.el8 started.
2023-04-27 23:34:12+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-04-27 23:34:12+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.33-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-04-27T23:34:13.743633Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-04-27T23:34:13.748962Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33) starting as process 1
2023-04-27T23:34:13.766412Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2023-04-27T23:34:13.766500Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-27T23:34:13.828571Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2023-04-27T23:34:13.828749Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2023-04-27T23:34:13.828918Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2023-04-27T23:34:14.327582Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2023-04-27T23:34:14.328130Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-27T23:34:14.328180Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-27T23:34:14.329060Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33) MySQL Community Server - GPL.
2023-04-27 23:35:15+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.33-1.el8 started.
2023-04-27 23:35:15+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-04-27 23:35:15+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.33-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-04-27T23:35:16.953120Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-04-27T23:35:16.957350Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33) starting as process 1
2023-04-27T23:35:16.974083Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2023-04-27T23:35:16.974175Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-27T23:35:17.032988Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2023-04-27T23:35:17.033118Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2023-04-27T23:35:17.033178Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2023-04-27T23:35:17.532398Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2023-04-27T23:35:17.533249Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-04-27T23:35:17.534563Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-27T23:35:17.535612Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33) MySQL Community Server - GPL.

[vagkaefer]

@samuellhwarren I'm a new monica user and I also use Docker.

Checking the documentation and another chats, I found that you need to use the Mysql version 5.7+. I don't checked why, but this probably will solve your problem

mysql:
image: mysql:5.7

[tallguyjenks]

@samuellhwarren did the issue get resolved? or did you close it just to close it?

[samuellhwarren]

@samuellhwarren did the issue get resolved? or did you close it just to close it?

just closed it.