[MDEV-22220] upgrade fails from 10.3 to 10.4 Created: 2020-04-11  Updated: 2020-05-21

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: 10.4.10
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Philip orleans Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Linux


 Description   

Same issue upgrading. I cannot publish the schema, but I can give access to Elena so she can see the issue
mysql_upgrade does not fix it, and it should
please contact me via email

Version: '10.4.12-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
 
2020-04-11 11:22:01 8 [ERROR] Incorrect definition of table mysql.proc: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVA
 
2020-04-11 11:22:02 11 [Warning] ./asterisk/c2.frm is inconsistent: engine typecode 44, engine name ROCKSDB (45)
 
2020-04-11 11:22:02 11 [Warning] ./asterisk/c3.frm is inconsistent: engine typecode 44, engine name ROCKSDB (45)
 
2020-04-11 11:22:02 11 [Warning] ./asterisk/c4.frm is inconsistent: engine typecode 44, engine name ROCKSDB (45)
 
2020-04-11 11:22:02 11 [Warning] ./asterisk/c5.frm is inconsistent: engine typecode 44, engine name ROCKSDB (45)
 
2020-04-11 11:22:02 11 [Warning] ./asterisk/c6.frm is inconsistent: engine typecode 44, engine name ROCKSDB (45)
 
2020-04-11 11:22:02 11 [Warning] ./asterisk/c7.frm is inconsistent: engine typecode 44, engine name ROCKSDB (45)
 
2020-04-11 11:22:02 11 [Warning] ./asterisk/c8.frm is inconsistent: engine typecode 44, engine name ROCKSDB (45)
 
2020-04-11 11:22:02 11 [Warning] ./asterisk/c9.frm is inconsistent: engine typecode 44, engine name ROCKSDB (45)
 
2020-04-11 11:22:02 12 [Warning] 'user' entry 'root@production3' ignored in --skip-name-resolve mode.
 
2020-04-11 11:22:02 12 [Warning] 'proxies_priv' entry '@% root@production3' ignored in --skip-name-resolve mode.



 Comments   
Comment by Elena Stepanova [ 2020-04-13 ]

Which part are you referring to, ERROR on mysql.proc or warnings on RocksDB?
mysql.proc requires running mysql_upgrade.

Comment by Philip orleans [ 2020-04-14 ]

The RocksDB error show in the error log. The Proc error shows when I run mysql_upgrade. But they should both be fixed by mysql_upgrade.
Actually, the Proc error shows in both places.

Comment by Elena Stepanova [ 2020-05-21 ]

mysql.proc structure will be fixed after upgrade, but errors show up initially when you start the new server on the old database for the first time. They appear on startup, before you run mysql_upgrade.

For RocksDB errors, I'll pass it over to psergey.

Generated at Thu Feb 08 09:13:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.