Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12451

SHOW DATABASES shows #mysql50#.rocksdb

Details

    Description

      after installing rocksdb with 'install soname 'ha_rocksdb'; and (not sure if relevant ) creating a table, "show databases" shows #mysql50#.rocksdb 

      MariaDB [test]> show databases;
      		 
      +--------------------+
      		 
      | Database           |
      		 
      +--------------------+
      		 
      | #mysql50#.rocksdb  |
      		 
      | information_schema |
      		 
      | mysql              |
      		 
      | performance_schema |
      		 
      | test               |
      		 
      +--------------------+

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13505 mysql_upgrade failed with rocksdb

          • Major - Major loss of function.
          • Closed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12464 #mysql50#.rocksdb database after enabling rockdb

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14123 .rocksdb folder may break workflow which re-create data directory

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 4 older comments
            p4karthikeyan KARTHIKEYAN PALANISAMY added a comment -

            Thank you Sergei, I deleted the directories manually.

            I thought thats where the data is stored in disk - so if I have RocksDB tables, I cant really delete this directory - Am I correct?

            p4karthikeyan KARTHIKEYAN PALANISAMY added a comment - Thank you Sergei, I deleted the directories manually. I thought thats where the data is stored in disk - so if I have RocksDB tables, I cant really delete this directory - Am I correct?
            elenst Elena Stepanova added a comment -

            psergey,

            Please find a proper solution before MDEV-9658 happens. It's not just a cosmetic issue, there are some obscure problems with using information_schema due to this garbage; and the workaround is viable for a proof of concept, but not for a stable version, we cannot tell every user to populate the option.

            elenst Elena Stepanova added a comment - psergey , Please find a proper solution before MDEV-9658 happens. It's not just a cosmetic issue, there are some obscure problems with using information_schema due to this garbage; and the workaround is viable for a proof of concept, but not for a stable version, we cannot tell every user to populate the option.
            nico Nicolas Payart added a comment -

            I encounter the same problem after activating RocksDB. One of the nasty consequence is that a mysqldump --all-databases fails with the message:

            mysqldump: Got error: 1102: "Incorrect database name '#mysql50#.rocksdb'" when selecting the database

            nico Nicolas Payart added a comment - I encounter the same problem after activating RocksDB. One of the nasty consequence is that a mysqldump --all-databases fails with the message: mysqldump: Got error: 1102: "Incorrect database name '#mysql50#.rocksdb'" when selecting the database
            psergei Sergei Petrunia added a comment -

            Fixed as part of fix for MDEV-14123. it is #rocksdb now, and it is not shown in SHOW DATABASES.

            psergei Sergei Petrunia added a comment - Fixed as part of fix for MDEV-14123 . it is #rocksdb now, and it is not shown in SHOW DATABASES.
            AdamW Adam Williamson added a comment -

            This is claimed to be 'fixed' but I'm still hitting it with MariaDB 10.3.12:

            [root@www duply]# mysqldump -u root --all-databases
            ...
            mysqldump: Got error: 1102: "Incorrect database name '#mysql50#.rocksdb'" when selecting the database

            I guess my dir was created while the bad old name was still in use and there is no automatic migration? Is there a manual way I can fix this up? Thanks.

            AdamW Adam Williamson added a comment - This is claimed to be 'fixed' but I'm still hitting it with MariaDB 10.3.12: [root@www duply] # mysqldump -u root --all-databases ... mysqldump: Got error: 1102: "Incorrect database name '#mysql50#.rocksdb'" when selecting the database I guess my dir was created while the bad old name was still in use and there is no automatic migration? Is there a manual way I can fix this up? Thanks.

            People

              psergei Sergei Petrunia
              wlad Vladislav Vaintroub
              Votes:
              1 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.