[Question]: MySQL keeps restarting

[doufurua]

Describe your problem

logs ragflow-mysql.txt

I deployed Ragflow on the Unraid system using Docker Compose. After running compose up and starting the container, I noticed that MySQL keeps restarting, which prevents the Ragflow-server web page from registering users. The container logs are attached. I am unable to change the permissions for init.sql as it always reverts automatically. Please help me resolve this issue.

logs ragflow-mysql.txt

[yuzhichang]

It's known that MySQL 8 cannot boot from existing MySQL 5.7 data.
If that's the case, you can drop existing data like this:

docker compose -f docker/docker-compose.yml down -v

Then start:

docker compose -f docker/docker-compose.yml up -d

[doufurua]

众所周知，MySQL 8 无法从现有的 MySQL 5.7 数据启动。 如果是这种情况，您可以像这样删除现有数据：

docker compose -f docker/docker-compose.yml down -v

然后开始：

docker compose -f docker/docker-compose.yml up -d

It's known that MySQL 8 cannot boot from existing MySQL 5.7 data. If that's the case, you can drop existing data like this:

docker compose -f docker/docker-compose.yml down -v

Then start:

docker compose -f docker/docker-compose.yml up -d

The problem remains unsolved

[tonylekhtman]

I had the problem and solved it by changing permissions of init.sql script inside docker file

chmod 755 docker/init.sql

another thing I did which might be not needed is updating mysql section in docker/docker-compose-base.yaml to:

mysql:
    # mysql:5.7 linux/arm64 image is unavailable.
    image: mysql:8.0.39
    container_name: ragflow-mysql
    env_file: .env
    environment:
      - MYSQL_ROOT_PASSWORD=${MYSQL_PASSWORD}
      - TZ=${TIMEZONE}
    command:
      --max_connections=1000
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_unicode_ci
      --default-authentication-plugin=mysql_native_password
      --tls_version="TLSv1.2,TLSv1.3"
    ports:
      - ${MYSQL_PORT}:3306
    volumes:
      - mysql_data:/var/lib/mysql
      - ./init.sql:/docker-entrypoint-initdb.d/init.sql
    networks:
      - ragflow
    healthcheck:
      test: ["CMD", "mysqladmin" ,"ping", "-uroot", "-p${MYSQL_PASSWORD}"]
      interval: 10s
      timeout: 10s
      retries: 3
    restart: on-failure

difference in volumes definition and removal of init-file arg

possibly only changing permissions is sufficient

[zerodaily]

I've deployed RagFlow on fNOS. After the deployment, the web interface is accessible, but MySQL keeps restarting. Could someone experienced help me figure out what the problem is?

'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-02-27T15:02:56.669599Z 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.
2025-02-27T15:02:56.670743Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-02-27T15:02:56.670780Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting as process 1
2025-02-27T15:02:56.677783Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-02-27T15:02:59.438930Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2025-02-27T15:03:00.104051Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2025-02-27T15:03:00.104321Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-02-27T15:03:00.104518Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-02-27T15:03:00.104710Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-02-27T15:03:00.104987Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-02-27T15:03:00.105159Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-02-27T15:03:00.105331Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-02-27T15:03:00.105500Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-02-27T15:03:00.589691Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2025-02-27T15:03:01.419789Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2025-02-27T15:03:01.492149Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-02-27T15:03:01.492193Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-02-27T15:03:01.563752Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2025-02-27T15:03:01.619083Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-02-27T15:03:01.619338Z 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-001146 - Table 'mysql.component' doesn't exist
2025-02-27T15:03:01.619364Z 0 [Warning] [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-003543 - The mysql.component table is missing or has an incorrect definition.
2025-02-27T15:03:01.620048Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2025-02-27T15:03:01.620104Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2025-02-27T15:03:01.620288Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-02-27T15:03:03.612330Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39) MySQL Community Server - GPL.
2025-02-27 23:04:04+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2025-02-27 23:04:04+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-02-27 23:04:04+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.