[MDEV-20251] mysql_upgrade from 10.4.6 10.4.7 failure Created: 2019-08-05  Updated: 2019-09-04  Resolved: 2019-09-04

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

Type: Bug Priority: Major
Reporter: Roland Assignee: Alexander Barkov
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Windows 10 x64

Issue Links:
Duplicate
is duplicated by MDEV-20228 `mysql_upgrade` fails on every versio... Closed

 Description   

We recently upgraded our test environment from 10.4.6 to 10.4.7. We always run mysql_upgrade after an upgrade to make sure everything work fine.

With the recent update from 10.4.6 10.4.7 this upgrade job fails at "mysql_fix_privilege_tables" with following error messages.

Phase 4/7: Running 'mysql_fix_privilege_tables'
 
ERROR 1267 (HY000) at line 7: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
 
ERROR 1267 (HY000) at line 59: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
 
ERROR 1267 (HY000) at line 168: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
 
ERROR 1267 (HY000) at line 179: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
 
ERROR 1267 (HY000) at line 195: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
 
ERROR 1267 (HY000) at line 322: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
 
ERROR 1267 (HY000) at line 393: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
 
ERROR 1267 (HY000) at line 400: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
 
ERROR 1267 (HY000) at line 407: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
 
FATAL ERROR: Upgrade failed

We cannot get this upgrade to work through the end. When we revert back to 10.4.6 and calling mysql_upgrade --force to simulate an upgrade everything work fine.

The server run fine as far as we can see, but the error is weird. We cannot find out what table or column is invoked in this problem.

 Comments   
Comment by Sergei Golubchik [ 2019-08-05 ]

duplicate of MDEV-20228 ?

Comment by Roland [ 2019-08-05 ]

@sergei Didn't found that with the search, overseen, sorry. Yes, seems like the same. Except that we are on windows and do not have any character sets defined in our configs so we cannot comment out anything.

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