Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.7
-
None
-
Fedora 26 x86_64
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
|
Attachments
Issue Links
- is caused by
-
MDEV-12451 SHOW DATABASES shows #mysql50#.rocksdb
-
- Closed
-
- relates to
-
MDEV-14123 .rocksdb folder may break workflow which re-create data directory
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Link |
This issue is caused by |
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 |
{noformat}$ 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 {noformat} |
Fix Version/s | 10.2 [ 14601 ] | |
Assignee | Sergei Petrunia [ psergey ] |
Link |
This issue relates to |
Fix Version/s | 10.2.12 [ 22810 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 82051 ] | MariaDB v4 [ 152600 ] |
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.