Mysql offline
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.
15 Replies
Project ID:
4a693931-74d5-4afc-9ab5-c2bc011f01df4a693931-74d5-4afc-9ab5-c2bc011f01df
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
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
The pro plan can do
that must be a very old limit, how much of the volume is currently used
actually i use 4.7GB
okay then go ahead and fix your mysql deploy image to version 8.2
making a redeploy?
a redeploy would be involved in that process
Hmmm
And how can i do this?
i tried do somethings but none worked...
I tried redeploy, restart, but the error message is always the same error
Solution
you need to remove the image and replace it with a fixed version
Nice, now works!
Thanks!
no problem!