a year ago
I updated my account to a pro plan and increased the size of my database. Before this, the database was not working and kept restarting.
The message error in console is:
2024-07-11 17:12:15+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.0-1.el9 started.
2024-07-11 17:12:15+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-07-11 17:12:15+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.0-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-07-11T17:12:16.253798Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-07-11T17:12:16.582703Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.0.0) starting as process 7
2024-07-11T17:12:16.595822Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-11T17:12:16.917981Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-11T17:12:16.927803Z 1 [ERROR] [MY-014060] [Server] Invalid MySQL server upgrade: Cannot upgrade from 80200 to 90000. Upgrade to next major version is only allowed from the last LTS release, which version 80200 is not.
2024-07-11T17:12:16.928110Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-07-11T17:12:16.928150Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-07-11T17:12:16.976709Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 9.0.0) MySQL Community Server - GPL.
2024-07-11T17:12:16.976735Z 0 [System] [MY-015016] [Server] MySQL Server - end.
16 Replies
a year ago
you say that you’ve upgraded, is it working now?
I upgraded my account from hobby to paid plan.
after this i increased the size of database from 5gb to 20gb
after this the mysql cannot start
yet is offline
a year ago
what is the current size of the volume? im not sure where you are getting 20gb from as there is no plan that offers 20gb
a year ago
that must be a very old limit, how much of the volume is currently used
a year ago
okay then go ahead and fix your mysql deploy image to version 8.2
a year ago
a redeploy would be involved in that process
i tried do somethings but none worked…
I tried redeploy, restart, but the error message is always the same error
a year ago
you need to remove the image and replace it with a fixed version
a year ago
no problem!