Missing tables/ No tables in connected SQlite database

Hello, after connecting Metabase to Sqlite database, I see no tables. I already tried to sync & rescan field values, but it does not help. Would be very grateful for advice!

Best,
Ulyana

{
  "browser-info": {
    "language": "cs-CZ",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "Cp1250",
    "java.runtime.name": "Java(TM) SE Runtime Environment",
    "java.runtime.version": "1.8.0_162-b12",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "http://java.oracle.com/",
    "java.version": "1.8.0_162",
    "java.vm.name": "Java HotSpot(TM) Client VM",
    "java.vm.version": "25.162-b12",
    "os.name": "Windows 10",
    "os.version": "10.0",
    "user.language": "en",
    "user.timezone": "Europe/Prague"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "sqlite"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "1.4.197 (2018-03-18)"
      },
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "1.4.197 (2018-03-18)"
      }
    },
    "run-mode": "prod",
    "version": {
      "tag": "v0.35.2",
      "date": "2020-04-10",
      "branch": "release-0.35.x",
      "hash": "f3b2857"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

Hi @ulaseeon
Make sure that you do a browser refresh, since sometimes old cache can make it seem like newly added tables doesn’t exist.
Check the log for any errors during a forced sync+scan (Admin > Databases > your-database). Admin > Troubleshooting > Logs.

Thank you for the prompt reply!

I signed off & refreshed browers & cookies, did not help.

But I think there might be something in logs: Troubleshooting -> Tasks -> Troubleshooting logs
sync tables: {“updated-tables”:0,“total-tables”:0}
classified tables: {“total-tables”:0,“tables-classified”:0}
analyse: null
field values scanning: null

Troubleshooting -> Logs
has line containing “DEBUG metabase middleware”

Do you know what that means? I have tables in the database when I use DB Browser to check it…
Thank you!

Ulyana

@ulaseeon
Open two tabs in your browser. One looking at Admin > Troubleshooting > Logs at the bottom. The other starting a sync+scan in Admin > Databases > your-database.

Thanks! This is what I see.

First I thought I miss sqlite metabase plugin, but looks like I have it. Also, the database in connected - w/o plugin it would probably not be possible. Do you have any ideas?

I also exported data from the database to csv and it worked, so cant understand why the tables are missing

Thank you!

[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util STARTING: Sync metadata for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.driver.impl Initializing driver :sqlite…
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.plugins.classloader Added URL file:/C:/Users/[NAME]/plugins/sqlite.metabase-driver.jar to classpath
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 DEBUG metabase.plugins.init-steps Loading plugin namespace metabase.driver.sqlite…
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.driver.impl Registered driver :sqlite (parents: [:sql-jdbc])
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 DEBUG metabase.plugins.jdbc-proxy Registering JDBC proxy driver for class org.sqlite.JDBC…
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util STARTING: step ‘sync-timezone’ for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util FINISHED: step ‘sync-timezone’ for sqlite Database 4 ‘Test3’ (184.5 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util STARTING: step ‘sync-tables’ for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util FINISHED: step ‘sync-tables’ for sqlite Database 4 ‘Test3’ (10.5 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util STARTING: step ‘sync-fields’ for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util FINISHED: step ‘sync-fields’ for sqlite Database 4 ‘Test3’ (1.9 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util STARTING: step ‘sync-fks’ for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util FINISHED: step ‘sync-fks’ for sqlite Database 4 ‘Test3’ (2.5 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util STARTING: step ‘sync-metabase-metadata’ for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:36+02:00 INFO metabase.sync.util FINISHED: step ‘sync-metabase-metadata’ for sqlite Database 4 ‘Test3’ (6.6 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:37+02:00 INFO metabase.sync.util FINISHED: Sync metadata for sqlite Database 4 ‘Test3’ (515.8 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:37+02:00 INFO metabase.sync.util STARTING: Analyze data for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:37+02:00 INFO metabase.sync.util STARTING: step ‘fingerprint-fields’ for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:37+02:00 INFO metabase.sync.util FINISHED: step ‘fingerprint-fields’ for sqlite Database 4 ‘Test3’ (1.8 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:37+02:00 INFO metabase.sync.util STARTING: step ‘classify-fields’ for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:37+02:00 INFO metabase.sync.util FINISHED: step ‘classify-fields’ for sqlite Database 4 ‘Test3’ (1.3 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:37+02:00 INFO metabase.sync.util STARTING: step ‘classify-tables’ for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:37+02:00 INFO metabase.sync.util FINISHED: step ‘classify-tables’ for sqlite Database 4 ‘Test3’ (2.2 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:37+02:00 INFO metabase.sync.util FINISHED: Analyze data for sqlite Database 4 ‘Test3’ (19.9 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:38+02:00 DEBUG metabase.middleware.log POST /api/database/4/rescan_values 200 3.6 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (46 total active threads) Queries in flight: 0 (0 queued)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:38+02:00 INFO metabase.sync.util STARTING: Cache field values in sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:38+02:00 INFO metabase.sync.util STARTING: step ‘update-field-values’ for sqlite Database 4 ‘Test3’
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:38+02:00 INFO metabase.sync.util FINISHED: step ‘update-field-values’ for sqlite Database 4 ‘Test3’ (2.9 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:57:38+02:00 INFO metabase.sync.util FINISHED: Cache field values in sqlite Database 4 ‘Test3’ (11.5 ms)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:58:48+02:00 DEBUG metabase.middleware.log GET /api/collection/root/items 200 11.5 ms (6 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (45 total active threads) Queries in flight: 0 (0 queued)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:58:48+02:00 DEBUG metabase.middleware.log GET /api/collection/root 200 2.5 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (45 total active threads) Queries in flight: 0 (0 queued)
[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:58:48+02:00 DEBUG metabase.middleware.log GET /api/database 200 7.5 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (1 idle, 0 queued) (45 total active threads) Queries in flight: 0 (0 queued

[5b998d4e-2db8-4174-8b7e-d9d7474367ec] 2020-04-21T22:58:49+02:00 ERROR metabase.middleware.log GET /api/automagic-dashboards/database/2/candidates 500 3.8 ms (3 DB calls)
{:message “C:\Users[NAME]\metabase.jar (The system cannot find the path specified)”,
:type java.io.FileNotFoundException,
:stacktrace
["java.util.zip.ZipFile.open(Native Method)"
"java.util.zip.ZipFile.(Unknown Source)"
"java.util.zip.ZipFile.(Unknown Source)"
"java.util.jar.JarFile.(Unknown Source)"
"java.util.jar.JarFile.(Unknown Source)"
"sun.net.www.protocol.jar.URLJarFile.(Unknown Source)"
"sun.net.www.protocol.jar.URLJarFile.getJarFile(Unknown Source)"
"sun.net.www.protocol.jar.JarFileFactory.get(Unknown Source)"
"sun.net.www.protocol.jar.JarURLConnection.connect(Unknown Source)"
"sun.net.www.protocol.jar.JarURLConnection.getInputStream(Unknown Source)"
"java.net.URL.openStream(Unknown Source)"
"clojure.java.io$fn__11500.invokeStatic(io.clj:239)"
"clojure.java.io$fn__11500.invoke(io.clj:235)"
"clojure.java.io$fn__11409$G__11402__11416.invoke(io.clj:69)"
"clojure.java.io$fn__11504.invokeStatic(io.clj:248)"
"clojure.java.io$fn__11504.invoke(io.clj:248)"
"clojure.java.io$fn__11409$G__11402__11416.invoke(io.clj:69)"
"clojure.java.io$fn__11470.invokeStatic(io.clj:165)"
"clojure.java.io$fn__11470.invoke(io.clj:165)"
"clojure.java.io$fn__11422$G__11398__11429.invoke(io.clj:69)"
"clojure.java.io$reader.invokeStatic(io.clj:102)"
"clojure.java.io$reader.doInvoke(io.clj:86)"
"clojure.lang.RestFn.invoke(RestFn.java:410)"
"clojure.lang.AFn.applyToHelper(AFn.java:154)"
"clojure.lang.RestFn.applyTo(RestFn.java:132)"
"clojure.core$apply.invokeStatic(core.clj:667)"
"clojure.core$slurp.invokeStatic(core.clj:6942)"
"clojure.core$slurp.doInvoke(core.clj:6942)"
"clojure.lang.RestFn.invoke(RestFn.java:410)"
"–> util.yaml$load.invokeStatic(yaml.clj:19)"
"util.yaml$load.invoke(yaml.clj:14)"
"automagic_dashboards.rules$load_rule_dir$fn__48994.invoke(rules.clj:308)"
"automagic_dashboards.rules$load_rule_dir.invokeStatic(rules.clj:300)"
"automagic_dashboards.rules$load_rule_dir.invoke(rules.clj:296)"
"automagic_dashboards.rules$load_rule_dir$fn__48994.invoke(rules.clj:305)"
"automagic_dashboards.rules$load_rule_dir.invokeStatic(rules.clj:300)"
"automagic_dashboards.rules$load_rule_dir.invoke(rules.clj:296)"
"automagic_dashboards.rules$load_rule_dir.invokeStatic(rules.clj:297)"
"automagic_dashboards.rules$load_rule_dir.invoke(rules.clj:296)"
"automagic_dashboards.rules$fn__48997$fn__48998.invoke(rules.clj:317)"
"util.files$do_with_open_path_to_resource.invokeStatic(files.clj:113)"
"util.files$do_with_open_path_to_resource.invoke(files.clj:105)"
"automagic_dashboards.rules$fn__48997.invokeStatic(rules.clj:316)"
"automagic_dashboards.rules$fn__48997.invoke(rules.clj:315)"
"automagic_dashboards.rules$get_rules.invokeStatic(rules.clj:325)"
"automagic_dashboards.rules$get_rules.invoke(rules.clj:319)"
"automagic_dashboards.core$candidate_tables.invokeStatic(core.clj:1274)"
"automagic_dashboards.core$candidate_tables.invoke(core.clj:1262)"
"automagic_dashboards.core$candidate_tables.invokeStatic(core.clj:1272)"
"automagic_dashboards.core$candidate_tables.invoke(core.clj:1262)"
"api.automagic_dashboards$fn__50464.invokeStatic(automagic_dashboards.clj:63)"
"api.automagic_dashboards$fn__50464.invoke(automagic_dashboards.clj:60)"
"middleware.auth$enforce_authentication$fn__66831.invoke(auth.clj:14)"
"routes$fn__68355$fn__68356.doInvoke(routes.clj:56)"
"middleware.exceptions$catch_uncaught_exceptions$fn__66930.invoke(exceptions.clj:97)"
"middleware.exceptions$catch_api_exceptions$fn__66927.invoke(exceptions.clj:85)"
"middleware.log$log_api_call$fn__68733$fn__68734.invoke(log.clj:197)"
"middleware.log$log_api_call$fn__68733.invoke(log.clj:191)"
"middleware.security$add_security_headers$fn__66893.invoke(security.clj:121)"
"middleware.json$wrap_json_body$fn__68436.invoke(json.clj:64)"
"middleware.json$wrap_streamed_json_response$fn__68454.invoke(json.clj:100)"
"middleware.misc$maybe_set_site_url$fn__68763.invoke(misc.clj:59)"
"middleware.session$bind_current_user$fn__63420$fn__63421.invoke(session.clj:209)"
"middleware.session$do_with_current_user.invokeStatic(session.clj:184)"
"middleware.session$do_with_current_user.invoke(session.clj:177)"
"middleware.session$bind_current_user$fn__63420.invoke(session.clj:208)"
"middleware.session$wrap_current_user_id$fn__63405.invoke(session.clj:161)"
"middleware.session$wrap_session_id$fn__63349.invoke(session.clj:125)"
"middleware.auth$wrap_api_key$fn__66839.invoke(auth.clj:27)"
"middleware.misc$bind_user_locale$fn__68768.invoke(misc.clj:78)"
"middleware.misc$add_content_type$fn__68749.invoke(misc.clj:29)"
"middleware.misc$disable_streaming_buffering$fn__68777.invoke(misc.clj:94)"
"server$async_proxy_handler$fn__68511.invoke(server.clj:70)"
"server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)"]}

@ulaseeon
The error is for database 2, but you’re doing a sync+scan on database 4

EDIT: By the way, you’re using a very old version of Java - you should either upgrade or alternatively try a different version:
https://adoptopenjdk.net/releases.html?variant=openjdk11&jvmVariant=hotspot

Thank you very much for your help! I changed to Microsoft SQL and it works. Thanks for the advice on java, too :slight_smile: