ragflow-mysql

[acc136]

Describe your problem

On Ubuntu 20.04, I successfully pulled the ragflow image, but the MySQL container is unhealthy and fails to start.How deal with it please?

[KevinHuSh]

docker logs ragflow-mysql

Google the error message.

[realxmtx]

I meet same issue with ragflow-mysql. Here is the docker log:

2024-12-13 01:49:27+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2024-12-13 01:49:27+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-12-13 01:49:27+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2024-12-13 01:49:27+08:00 [Warn] [Entrypoint]: MYSQL_PASSWORD specified, but missing MYSQL_USER; MYSQL_PASSWORD will be ignored
2024-12-13 01:49:27+08:00 [Note] [Entrypoint]: Initializing database files
2024-12-12T17:49:27.447530Z 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.
2024-12-12T17:49:27.447601Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-12-12T17:49:27.447613Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.39) initializing of server in progress as process 81
2024-12-12T17:49:27.454984Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-12T17:49:27.925568Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-12T17:49:29.436376Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-000029 - File '/data/application/init.sql' not found (OS errno 13 - Permission denied)
2024-12-12T17:49:29.436389Z 0 [ERROR] [MY-010455] [Server] Failed to open the bootstrap file /data/application/init.sql
2024-12-12T17:49:29.436394Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2024-12-12T17:49:29.436397Z 0 [ERROR] [MY-010119] [Server] Aborting

It looks like the init.sql copied into the container, but cannot be opened.

[duxiaoyang06]

Also File '/data/application/init.sql' not found +1
How to deal with it?

cd docker/ and " chmod 644 ./init.sql",it works

[PangDingPing]

docker compose down -v (remove all the local data)
docker compose up

[peterzyk]

修改为
mysql:
# mysql:5.7 linux/arm64 image is unavailable.
image: mariadb:10.5.8

即可

[herrUnbekannte]

修改为 mysql: # mysql:5.7 linux/arm64 image is unavailable. image: mariadb:10.5.8

即可

这是唯一可用的方式，刚刚试过