Dont' see the tables Mysql - RDS (SSL activate, use with postgresql -without h2-)

1

Hello. Despite having read everything I could about this issue, I can't find any solution for it.

Metabase on my localhost running with java -jar metabase.jar configured with PostgreSQL.

It can connect okay to my MySQL database on RDS, and I can even execute queries correctly. However, it cannot display the tables or fields; they are empty.

The same database on my localhost MySQL works correctly.

I have SSL connection enabled with the RDS certificate.

I'm attaching relevant information.

{
  "browser-info": {
    "language": "es-ES",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "Java(TM) SE Runtime Environment",
    "java.runtime.version": "18.0.2.1+1-1",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "https://java.oracle.com/",
    "java.version": "18.0.2.1",
    "java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
    "java.vm.version": "18.0.2.1+1-1",
    "os.name": "Windows 11",
    "os.version": "10.0",
    "user.language": "es",
    "user.timezone": "Europe/Madrid"
  },
  "metabase-info": {
    "databases": [
      "mysql",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "16.1"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.6.0"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-01-29",
      "tag": "v0.48.4",
      "hash": "62145b0"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

When I press the sync tables button, these are the logs:

[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:23:13+01:00 DEBUG metabase.server.middleware.log GET /api/database/4 200 14,5 ms (3 llamadas a la BBDD) Conexiones BBDD: 0/7 Hilos Jetty: 5/50 (1 esperando, 0 en cola) (58 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:12+01:00 DEBUG metabase.server.middleware.log POST /api/database/4/sync_schema 200 612,2 ms (3 llamadas a la BBDD) Conexiones BBDD: 0/7 Hilos Jetty: 5/50 (3 esperando, 0 en cola) (54 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: Sync metadata for mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: paso 'sync-dbms-version' para mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: paso 'sync-dbms-version' para mysql Base de Datos 4 'PreSaaS' (141,3 ms)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: paso 'sync-timezone' para mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.sync-metadata.sync-timezone :mysql database 4 default timezone is "UTC"
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: paso 'sync-timezone' para mysql Base de Datos 4 'PreSaaS' (93,9 ms)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: paso 'sync-tables' para mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: paso 'sync-tables' para mysql Base de Datos 4 'PreSaaS' (4,9 ms)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: paso 'sync-fields' para mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: paso 'sync-fields' para mysql Base de Datos 4 'PreSaaS' (4,5 ms)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: paso 'sync-fks' para mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: paso 'sync-fks' para mysql Base de Datos 4 'PreSaaS' (4,3 ms)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: paso 'sync-metabase-metadata' para mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: paso 'sync-metabase-metadata' para mysql Base de Datos 4 'PreSaaS' (1,3 ms)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: paso 'sync-table-privileges' para mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: paso 'sync-table-privileges' para mysql Base de Datos 4 'PreSaaS' (206,4 ms)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: Sync metadata for mysql Base de Datos 4 'PreSaaS' (521,2 ms)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: Analyze data for mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: paso 'fingerprint-fields' para mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: paso 'fingerprint-fields' para mysql Base de Datos 4 'PreSaaS' (7,0 ms)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: paso 'classify-fields' para mysql Base de Datos 4 'PreSaaS' (510,4 µs)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: paso 'classify-fields' para mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: paso 'classify-tables' para mysql Base de Datos 4 'PreSaaS' (412,6 µs)
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util STARTING: paso 'classify-tables' para mysql Base de Datos 4 'PreSaaS'
[f17d0a24-3f35-4283-b77d-675e76cc4614] 2024-02-09T14:24:13+01:00 INFO metabase.sync.util FINISHED: Analyze data for mysql Base de Datos 4 'PreSaaS' (40,0 ms)

The connection to RDS is with a certificate.

1
1955×975 134 KB

I don't understand what could be happening. Is there any configuration I might have forgotten?

Thanks in advance

2
  1. please move to Java 11
  2. we're checking this with the team All tables in mysql databases are marked as non-active and cannot browse them or use table metadata · Issue #38509 · metabase/metabase · GitHub
3

I move to java 11 and downgrade metabse to 0.48.3 and it's seems works but I 've got an out of memory:

2024-02-09 18:02:32,254 ERROR models.field-values :: Error al recuperar valores de campo
clojure.lang.ExceptionInfo: Error ejecutando consulta: (conn=552003) Out of sort memory, consider increasing server sort buffer size {:driver :mysql, :sql
...
Caused by: java.sql.SQLTransientConnectionException: (conn=552003) Out of sort memory, consider increasing server sort buffer size
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
        at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
        at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)
        at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
        at metabase.driver.sql_jdbc.execute$fn__78816.invokeStatic(execute.clj:560)
        at metabase.driver.sql_jdbc.execute$fn__78816.invoke(execute.clj:558)
        at clojure.lang.MultiFn.invoke(MultiFn.java:239)
        at metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:568)
        at metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:565)
        at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__78897$fn__78898.invoke(execute.clj:696)
        ... 155 more
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Out of sort memory, consider increasing server sort buffer size
        at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:195)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:263)
        at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
        ... 163 more
Caused by: java.sql.SQLTransientConnectionException: Out of sort memory, consider increasing server sort buffer size
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192)
        at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.readNextValue(SelectResultSet.java:383)
        at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.addStreamingValue(SelectResultSet.java:360)
        at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.nextStreamingValue(SelectResultSet.java:348)
        at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.<init>(SelectResultSet.java:156)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readResultSet(AbstractQueryProtocol.java:1849)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1568)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1518)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:257)
        ... 164 more

How can I solve this?

4

yes, your db is running out of memory, increase the RAM of your database