[MDEV-13505] mysql_upgrade failed with rocksdb Created: 2017-08-12  Updated: 2017-12-11  Resolved: 2017-12-11

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: 10.2.7
Fix Version/s: 10.2.12

Type: Bug Priority: Major
Reporter: Michael Xu Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None
Environment:

Fedora 26 x86_64


Issue Links:
Problem/Incident
is caused by MDEV-12451 SHOW DATABASES shows #mysql50#.rocksdb Closed
Relates
relates to MDEV-14123 .rocksdb folder may break workflow wh... Closed

 Description   

$ mysql_upgrade
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
mysqlcheck: Got error: 1102: Incorrect database name '#mysql50#.rocksdb' when selecting the database
FATAL ERROR: Upgrade failed
 
$ rpm -qa | grep MariaDB
MariaDB-connect-engine-10.2.7-1.fc25.x86_64
MariaDB-tokudb-engine-10.2.7-1.fc25.x86_64
MariaDB-rocksdb-engine-10.2.7-1.fc25.x86_64
MariaDB-common-10.2.7-1.fc25.x86_64
MariaDB-cracklib-password-check-10.2.7-1.fc25.x86_64
MariaDB-backup-10.2.7-1.fc25.x86_64
MariaDB-compat-10.2.7-1.fc25.x86_64
MariaDB-client-10.2.7-1.fc25.x86_64
MariaDB-server-10.2.7-1.fc25.x86_64



 Comments   
Comment by Elena Stepanova [ 2017-08-12 ]

psergey, serg,

I think this problem with the garbage database should be solved before RocksDB goes to a next maturity level. The initial JIRA issue is MDEV-12451.

I've had some other obscure problems while (I think) querying information schema because of this.

Comment by Sergei Petrunia [ 2017-12-11 ]

Fixed as part of fix for MDEV-14123. Marking as a duplicate.

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