7 months ago
trying to downgrade to mysql 8 , but i get this error during deplyment. Any ideas?
2024-11-04T10:45:03.305274Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-11-04T10:45:03.423544Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.3) starting as process 1
2024-11-04T10:45:03.430526Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-11-04T10:45:03.961519Z 1 [ERROR] [MY-014061] [InnoDB] Invalid MySQL server downgrade: Cannot downgrade from 90100 to 80403. Downgrade is only permitted between patch releases.
mysqld: Can't open file: 'mysql.ibd' (errno: 0 - )
2024-11-04T10:45:03.976405Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-11-04T10:45:03.976650Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-11-04T10:45:03.976740Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-11-04T10:45:03.978212Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.3) MySQL Community Server - GPL.
2024-11-04T10:45:03.978284Z 0 [System] [MY-015016] [Server] MySQL Server - end.
container event container died
ⓘ Deployment information is only viewable by project members and Railway employees.
6 Replies
7 months ago
I am still getting the same error. Attached is a screenshot of service settings. My default deployment command is: docker-entrypoint.sh mysqld --innodb-use-native-aio=0 --disable-log-bin --performance_schema=0 . Is there a way to configure the Dockerfile itself.
Please let me know if there is something else that needs to configured. Thanks in advance.
Attachments
7 months ago
My apologies I was looking at the wrong part of the logs, you need to replace the source image with mysql:9.1.0
Additionally, this is an image, not a Dockerfile.
7 months ago
Thank brody for the quick response. I need a mysql version 8.0 , to match my local version, since with mysql 9 , the queries are not behaving correctly.
7 months ago
The database was created with MySQL:9.1.0, you can't change that unless you want to wipe the volume.
Status changed to Solved brody • 7 months ago