Failed upgrade from 5.10 to 6.x

[revolonl]

Hi everybody,
i use the v6 in non prod since some weeks without issue.
i'm trying to upgrade my Prod environment from 5.10 to last 6 version.
I have updated the docker-compose.yml fot the database version(8.4.5).
When i upgrade the app don't start, it seems that the mySQL container is restarting in loop.
Have you some tracks to check ?

[ansibleguy76]

there is a new docker compose for v6. chances are that you mapped the custom functions and that will break because its locally on your end, still part of the old docker compose

[ansibleguy76]

better to also check the logs on the mysql container to check where the issue is

[revolonl]

i found this in the app_db logs :
2025-10-22T12:19:32.680699Z 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-10-22T12:19:32.684754Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default_authentication_plugin=caching_sha2_password'.
2025-10-22T12:19:32.685603Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-10-22T12:19:34.336361Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.5) MySQL Community Server - GPL.
2025-10-22T12:19:34.336398Z 0 [System] [MY-015016] [Server] MySQL Server - end.

[revolonl]

i found the issue, it was in my.cnf file, i have comment the option and now it's ok
Thanks for your help