Fail to startup RAGFlow

[chjmail]

2024-10-09T13:16:02.155968Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-10-09T13:16:02.334608Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.0.1) starting as process 1
2024-10-09T13:16:02.337347Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-09T13:16:02.479957Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-10-09T13:16:02.491447Z 1 [ERROR] [MY-014060] [Server] Invalid MySQL server upgrade: Cannot upgrade from 80039 to 90001. Upgrade to next major version is only allowed from the last LTS release, which version 80039 is not.
2024-10-09T13:16:02.491672Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-10-09T13:16:02.491709Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-10-09T13:16:03.020535Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 9.0.1) MySQL Community Server - GPL.
2024-10-09T13:16:03.020547Z 0 [System] [MY-015016] [Server] MySQL Server - end.

[JinHai-CN]

RAGFlow need mysql with 8.0.39. It seems you are using mysql 9.0.1 which 8.0.39 can't upgrade to.

[chjmail]

使用8.0.39版本后，还是启动不了，错误码如下：
2024-10-16T12:35:13.907217Z 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-10-16T12:35:13.907904Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-10-16T12:35:13.907914Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting as process 1
2024-10-16T12:35:13.910383Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-16T12:35:13.955389Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 5.7.44, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-10-16T12:35:13.955400Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-10-16T12:35:14.422750Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-10-16T12:35:14.423139Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-10-16T12:35:14.423171Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-10-16T12:35:14.423893Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39) MySQL Community Server - GPL.
2024-10-16 20:35:27+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2024-10-16 20:35:27+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-10-16 20:35:27+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'

[renxiusheng163]

I so.
no body answer

[onestardao]

this startup failure looks like more than just a MySQL version mismatch — we’ve seen similar cases where services like RAGFlow try to initialize before key dependencies (like DB upgrades) are fully ready, leading to chain-collapse on boot.

in our diagnostics we tag these as ProblemMap No.13 – “predeploy collapse” and sometimes No.14 – “bootstrap ordering”, especially when deprecated params or migration steps are skipped but silently assumed ready.

we’re maintaining an open-source MIT-licensed toolset to trace and isolate exactly these startup traps — if you’re curious, happy to share the reference or walkthrough.