Fresh install, metabase won't synch a very simple schema

Get Help
1

Hi! I've been using Metabase extensively in my company. Now in a fresh setup (externally hosted MariaDB server) I could test Metabase by adding metabase own schema. Later on I created a simple schema with 3 tables and a few thousand rows, the three last sql files in this github link. The problem is that metabase "sees" the schema, and I can raw-query all of them, but that new lower right "synching tables" card won't dissapear, and neither "Data Model" admin tab shows any table inside it.

This is the schema:

CREATE DATABASE main /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

and one of the tables:

CREATE TABLE `comunidades` (
  `id_comunidad` tinyint(4) NOT NULL,
  `nombre` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Any ideas on what could be happening, or which log to inspect?

Thanks in advance!

database
database1212×689 27 KB

2

Nevermind, found it: apparently "main" was not a good naming choice. Since it's not a reserved word, I guess Metabase choked while parsing what it was told to do in the synching process.

Did I discover a bug? :slight_smile:

3

Hi @jonay
Post "Diagnostic Info" from Admin > Troubleshooting.
And there are likely errors during the sync, so include those errors from Admin > Troubleshooting > Logs.

4

Thanks @flamber! Actually, the next morning the tables were there synched, and the log is already full of events, so I don't have the cause for this. I'd try to replicate it just in case somebody stumbles upon this.

Cheers!