Tables missing in My Dashboard

#1

Good day,

I have a database which is contains a table for storing logs and delete them frequently, this table is not appearing at all. while the other tables in the same database are appearing.
Note: this table contains column with a BLOB type.

Metabase: version (0.34.1)
Operating system: (redhat 7.5)
Browser: version 79.0.3945.88 (Official Build) (64-bit)

Regards,

#2

Hi @f.alkhmimi
Try doing a forced sync+scan (Admin > Databases) and check the log (Admin > Troubleshooting > Logs) for any errors.
Which database are you using?

#3

Hi @flamber
Facing the same Issue.
I can do a native query to fetch results.
But table not loading to cache.
Tried sync/scan multiple times. No error.
DB - Postgres
Metabase Version - 0.38

#4

@niteesh

  1. Do a browser refresh.
  2. Post “Diagnostic Info” from Admin > Troubleshooting.
  3. Do a manual sync via Admin > Databases, and post the sync logs from Admin > Troubleshooting > Logs.
#5

@flamber
{
“browser-info”: {
“language”: “en-GB”,
“platform”: “MacIntel”,
“userAgent”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 11_0_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.10+9”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.10”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.10+9”,
“os.name”: “Linux”,
“os.version”: “4.15.0-1051-aws”,
“user.language”: “en”,
“user.timezone”: “Asia/Calcutta”
},
“metabase-info”: {
“databases”: [
“postgres”,
“presto”,
“mongo”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “11.10”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.18”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2021-02-19”,
“tag”: “v0.38.0.1”,
“branch”: “release-x.38.x”,
“hash”: “0635914”
},
“settings”: {
“report-timezone”: “Asia/Kolkata”
}
}
}

#6

@flamber
There is a pattern in our case. We are getting only the non partitioned tables.
For all the partitioned tables, we donot see the main table. Only the individual partitions are shown.

#7

@niteesh Okay, different problem than this topic then.

Which database type are you talking about?

You’ll probably need to enable debug logging on sync - I’m guessing you’re using Docker - add this environmental variable to the docker run ... command:
… -e JAVA_OPTS="-Dlog4j.configurationFile=https://log4j.us/v2/templates/metabase?trace=metabase.sync" …

EDIT: There’s now an issue open: https://github.com/metabase/metabase/issues/15049