Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MariaDB 10.11.7 is classified as too old (RocksDB) #42734

Open
Charlie-MPC opened this issue May 15, 2024 · 1 comment
Open

MariaDB 10.11.7 is classified as too old (RocksDB) #42734

Charlie-MPC opened this issue May 15, 2024 · 1 comment
Labels
.Backend Database/MySQL Priority:P1 Security holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctness .Team/QueryProcessor :hammer_and_wrench: Type:Bug Product defects

Comments

@Charlie-MPC
Copy link

Describe the bug
A connection is established, I can select 1 from dual, but all queries against tables fail, no tables are shown.

Logs


WARNING: Metabase only officially supports MySQL 5.7/MariaDB 10.2 and above.
All Metabase features may not work properly when using an unsupported version.


"MyRocks supports only READ COMMITTED and REPEATABLE READ isolation levels. Please change from current isolation level READ-UNCOMMITTED",

To Reproduce
Install Ubuntu 24.04, apt update; apt install mariadb; ( Server version: 10.11.7-MariaDB-2ubuntu2 Ubuntu 24.04 )
I'm using SSL to connect. JDBC options I've used:

disableSslHostnameVerification=true

disableSslHostnameVerification=true&trustServerCertificate=true

disableSslHostnameVerification=true&trustServerCertificate=true&sessionVariables=tx_isolation='READ-COMMITTED'

I've set MariaDB to run globally with READ-COMMITTED and also tried REPEATABLE-READ

Expected behavior
Tables should show on the Browse page for the DB. Queries should run against tables.

Severity
I'm trying to use Rocks for analytics purposes. The data isn't getting any smaller. I suppose I could try to start over on an older OS release.

Additional context
I think the message about isolation level is a red herring. It looks more like this MariaDB version is unrecognized and classified as too old, when it's probably too new.

Metabase Diagnostic Info

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:126.0) Gecko/20100101 Firefox/126.0",
    "vendor": ""
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.23+9",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.23",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.23+9",
    "os.name": "Linux",
    "os.version": "5.10.215-203.850.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "mysql",
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.10"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.7.2"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-05-02",
      "tag": "v1.49.8",
      "hash": "38cb850"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
@paoliniluis paoliniluis added Type:Bug Product defects Priority:P1 Security holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctness Database/MySQL .Backend labels May 15, 2024
@darksciencebase darksciencebase added the .Team/QueryProcessor :hammer_and_wrench: label May 16, 2024
@Charlie-MPC
Copy link
Author

After adding an InnoDB table to the DB as a test, it has become visible in Metabase. So the RocksDB tables are ignored. Is that intentional?

@paoliniluis paoliniluis changed the title MariaDB 10.11.7 is classified as too old MariaDB 10.11.7 is classified as too old (RocksDB) May 18, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
.Backend Database/MySQL Priority:P1 Security holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctness .Team/QueryProcessor :hammer_and_wrench: Type:Bug Product defects
Projects
None yet
Development

No branches or pull requests

3 participants