MYSQL Redploy Crash
pratham15
HOBBYOP

2 years ago

I couldn't pay the monthly invoice and due to this my database got shut down. When I try to redeploy it, the following errors come.

Also, in this case will I lose all of my data.

2024-07-12 08:10:10+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.0-1.el9 started.

Jul 12 13:40:10

2024-07-12 08:10:10+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

Jul 12 13:40:10

2024-07-12 08:10:10+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.0-1.el9 started.

Jul 12 13:40:11

'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'

Jul 12 13:40:11

2024-07-12T08:10:11.213944Z 0 [System] [MY-015015] [Server] MySQL Server - start.

Jul 12 13:40:11

2024-07-12T08:10:11.334306Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.0.0) starting as process 7

Jul 12 13:40:11

2024-07-12T08:10:11.341208Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

Jul 12 13:40:11

2024-07-12T08:10:11.632333Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

Jul 12 13:40:11

2024-07-12T08:10:11.648302Z 1 [ERROR] [MY-014060] [Server] Invalid MySQL server upgrade: Cannot upgrade from 80300 to 90000. Upgrade to next major version is only allowed from the last LTS release, which version 80300 is not.

Jul 12 13:40:11

2024-07-12T08:10:11.648520Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

Jul 12 13:40:11

2024-07-12T08:10:11.648551Z 0 [ERROR] [MY-010119] [Server] Aborting

Jul 12 13:40:11

2024-07-12T08:10:11.714487Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 9.0.0) MySQL Community Server - GPL.

Jul 12 13:40:11

2024-07-12T08:10:11.714509Z 0 [System] [MY-015016] [Server] MySQL Server - end.

Solved

4 Replies

2 years ago

You would need to remove the current mysql source image and then add it back but this time fix it version 8.3


pratham15
HOBBYOP

2 years ago

You would need to remove the current mysql source image and then add it back but this time fix it version 8.3

Could you please guide my as to the procedure of this, and will my data be lost.
I need to recover the data.


2 years ago

Your data will not be lost unless you have severely missconfigured something.

Steps -

  • Remove the current mysql source image.

  • Add the image back - mysql:8.3


Status changed to Solved Railway over 1 year ago


pratham15
HOBBYOP

2 years ago

Your data will not be lost unless you have severely missconfigured something.

Steps -

  • Remove the current mysql source image.

  • Add the image back - mysql:8.3

Resolved.

Thankyou for the support.


Loading...