[MDEV-20442] Failed to upgrade from 10.3.9 to 10.4.7 Created: 2019-08-29  Updated: 2019-10-27  Resolved: 2019-10-27

Status: Closed
Project: MariaDB Server
Component/s: Configuration
Affects Version/s: 10.4.7
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Chow King Tak Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: crash, need_feedback
Environment:

Redhat enterprise Linux 7

Attachments: File my.cnf     File mysql_data.sql     File mysqld.err.dump     File mysqld.err.upgrade    
Issue Links:
Duplicate
is duplicated by MDEV-19918 Server hangs or crashes while trying ... Closed

 Description   

Failed to upgrade from 10.3.9 to 10.4.7

Scenario 1:
Follow normal procedures:
1. install 10.4.7.
2. Start MariaDB on the 10.3.9.
3. Run mysql_upgrade and everything is OK.
4. Restart MariaDB but it hangs. No socket file is generated. "mysqld.err.upgrade" is attached for reference.

Scenario 2:
Use export/import method:
1. install 10.4.7.
2. Start MariaDB on the 10.3.9.
3. Run mysql_upgrade and everything is OK.
4. Run mysqldump to export user database and 'mysql' database data.
5. Run mysql_install_db to create a new a new 'empty' MariaDB server.
6. Import the user database data into the new MariaDB server and restart it sucessfully.
7. import the 'mysql' database data into the new MariaDB server. "mysql_data.sql" is attached for reference.
8. Restart the new server but it hangs. same symptom as scenario 1, no socket file is generated. "mysqld.err.dump" is attached for reference.
9 It can restart MariaDB successfully with --skip-grant-tables option.

It seems that mysql_upgrade cannot ensures that the system tables in the mysql database are fully compatible with the new version. "my.cnf" is attached for reference.

Please advise how to solve the upgrade problem.

 Comments   
Comment by Elena Stepanova [ 2019-08-29 ]

What does "Start MariaDB on the 10.3.9" mean in both your scenarios? Start MariaDB server 10.3.9, or start MariaDB server 10.4.7 on the database created by 10.3.9, or...?

Comment by Chow King Tak [ 2019-08-30 ]

I mean I start MariaDB server 10.4.7 on the database created by 10.3.9.

Comment by Elena Stepanova [ 2019-09-23 ]

Sorry for the delay.
I think you've encountered the problem filed as MDEV-19918.
To verify that, try to start your server (when it usually hangs) without server_audit plugin – for example, add skip-server-audit to your config file after the line plugin_load_add = server_audit.

Generated at Thu Feb 08 08:59:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.