MySQL Railway crashing (Upgrade Issue: How to Pin Docker Image Version)
I'm currently using Railway's Hobby Plan and needed to increase my MySQL database size. After doing so, every restart or redeployment started failing with the error:
Invalid MySQL server upgrade: Cannot upgrade from 80300 to 90000. Upgrade to next major version is only...
I was able to solve this but didn't have much resource online for railway to help, so i thought it best to document here so others can find it later. (See My Solution in the Answer Section)
The default Docker image for MySQL in Railway points to https://hub.docker.com/_/mysql. However, this is not version-specific, so redeploying your app might result in versions mismatch since you last deployed your application/ DB server. Thus to mitigate against this, you can specify your preferred tag.
In this case, my current version is 80300 (i.e., 8.03.00, which is equal to 8.3.0). If not specified, the Dockerfile will always point to the latest version.
To update your settings:
- Go to DB settings.
- Click on the source image and disconnect the default mysql.
- Input MySQL with your specific tag, e.g.,
mysql:8.3.0 - A deploy action button will appear. Click Deploy.
You should be good to go.
- How/when mysql compiles stored procedures?
- UPDATE column with Y or N if data exists in another table
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- How to get Python MYSQL connection username and password?
- Table is marked as crashed and should be repaired
- Coverting a .BAK file into a .SQL for use in XAMPP phpmyadmin
- Query through JSON Array with multiple values in MySQL
- Housing Society management system database structure
- MySQL DROP all tables, ignoring foreign keys
- When to use prepared statements?
- When *not* to use prepared statements?
- Are Prepared Statements a waste for normal queries? (PHP)
- Deleting rows in mysql table that contain an empty field where more complete rows exist
- MySQL given date between monday and sunday
- JSON_TABLE - how to access fields inside escaped quotes?
- mysqldump - maintain character set and collations
- Why can't a text column have a default value in MySQL?
- Using Hibernate's ScrollableResults to slowly read 90 million records
- Foreign key in the child table is null after persisting @OneToMany
- How to fix products without cover image in PrestaShop
- Laravel Eloquent Query Using Case/When to apply conditions dynamically
- MySQL SELECT a field as NULL if not existent in table
- How can I show all duplicate value from a specific column in MySQL
- Declaring 2 Cursors in a Stored Procedure | SQL Error [1338] [42000]: Cursor declaration after handler declaration
- PHP mySQL - Insert new record into table with auto-increment on primary key
- IF ROW_COUNT() return error
- Date column with associated MAX count value
- Drop Column from Large Table
- MySQL - 'Using index condition' vs 'Using where; Using index'
- Conversion issues in sql - GREATEST(CEILING())