Only one table is discovered in sqlite database

Anders · March 26, 2021, 1:18pm

I've added a .db file but only one of the tables are shown. I've tried sync and re-scan form the UI, and I get no errors from the log.
How do I go about debugging this?

Metabase is running in a new docker container, and the sqlite file is in a connected volume.

Sys info:

{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:87.0) Gecko/20100101 Firefox/87.0",
    "vendor": ""
  },
  "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-20-generic",
    "user.language": "en",
    "user.timezone": "Europe/Copenhagen"
  },
  "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": {
      "date": "2021-03-17",
      "tag": "v0.38.2",
      "branch": "release-x.38.x",
      "hash": "91f0ed6"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

flamber · March 26, 2021, 1:24pm

Hej Anders,

Try adding this environmental variable to the docker run ... command:
... -e JAVA_OPTS="-Dlog4j.configurationFile=https://log4j.us/v2/templates/metabase?trace=metabase.sync" ...
And then run a re-sync and check the logs.

You should migrate away from H2 if you're using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html

Anders · March 26, 2021, 1:44pm

Hi flamber,
After I added the env var no tables are found.

#################################################################
# Completed sync on Data dump fra OpenData.dk
# Start: 2021-03-26T14:31:55.439658+01:00
# End: 2021-03-26T14:31:55.727145+01:00
# Duration: 287.5 ms
# ---------------------------------------------------------------
# Completed step 'sync-timezone'
# Start: 2021-03-26T14:31:55.440985+01:00
# End: 2021-03-26T14:31:55.640597+01:00
# Duration: 199.6 ms
# Found timezone id Europe/Copenhagen
# ---------------------------------------------------------------
# Completed step 'sync-tables'
# Start: 2021-03-26T14:31:55.642415+01:00
# End: 2021-03-26T14:31:55.708065+01:00
# Duration: 65.7 ms
# Total number of tables sync'd 1, number of tables updated 1
# ---------------------------------------------------------------
# Completed step 'sync-fields'
# Start: 2021-03-26T14:31:55.708218+01:00
# End: 2021-03-26T14:31:55.712115+01:00
# Duration: 3.9 ms
# Total number of fields sync'd null, number of fields updated null
# ---------------------------------------------------------------
# Completed step 'sync-fks'
# Start: 2021-03-26T14:31:55.712242+01:00
# End: 2021-03-26T14:31:55.723166+01:00
# Duration: 10.9 ms
# Total number of foreign keys sync'd 0, 0 updated and 0 tables failed to update
# ---------------------------------------------------------------
# Completed step 'sync-metabase-metadata'
# Start: 2021-03-26T14:31:55.723303+01:00
# End: 2021-03-26T14:31:55.727079+01:00
# Duration: 3.8 ms
#################################################################

[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 INFO metabase.sync.util FINISHED: Sync metadata for sqlite Database 4 'Data dump fra OpenData.dk' (719.0 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 DEBUG metabase.sync.util Sync operations in flight: {:cache-field-values #{4}, :analyze #{4}}
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 INFO metabase.sync.util STARTING: Analyze data for sqlite Database 4 'Data dump fra OpenData.dk'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for sqlite Database 4 'Data dump fra OpenData.dk'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for sqlite Database 4 'Data dump fra OpenData.dk' (3.2 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 INFO metabase.sync.util STARTING: step 'classify-fields' for sqlite Database 4 'Data dump fra OpenData.dk'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for sqlite Database 4 'Data dump fra OpenData.dk' (1.4 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 INFO metabase.sync.util STARTING: step 'classify-tables' for sqlite Database 4 'Data dump fra OpenData.dk'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for sqlite Database 4 'Data dump fra OpenData.dk' (2.3 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 DEBUG metabase.sync.util 
#################################################################
# Completed analyze on Data dump fra OpenData.dk
# Start: 2021-03-26T14:31:55.89768+01:00
# End: 2021-03-26T14:31:55.907925+01:00
# Duration: 10.2 ms
# ---------------------------------------------------------------
# Completed step 'fingerprint-fields'
# Start: 2021-03-26T14:31:55.897753+01:00
# End: 2021-03-26T14:31:55.902056+01:00
# Duration: 4.3 ms
# Fingerprint updates attempted 0, updated 0, no data found 0, failed 0
# ---------------------------------------------------------------
# Completed step 'classify-fields'
# Start: 2021-03-26T14:31:55.902168+01:00
# End: 2021-03-26T14:31:55.904483+01:00
# Duration: 2.3 ms
# Total number of fields classified 0, 0 failed
# ---------------------------------------------------------------
# Completed step 'classify-tables'
# Start: 2021-03-26T14:31:55.90462+01:00
# End: 2021-03-26T14:31:55.907822+01:00
# Duration: 3.2 ms
# Total number of tables classified 0, 0 updated
#################################################################

[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:55+01:00 INFO metabase.sync.util FINISHED: Analyze data for sqlite Database 4 'Data dump fra OpenData.dk' (28.0 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:56+01:00 ERROR metabase.models.field-values Error fetching field values
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: cityprobe)
	at org.sqlite.core.DB.newSQLException(DB.java:941)
	at org.sqlite.core.DB.newSQLException(DB.java:953)
	at org.sqlite.core.DB.throwex(DB.java:918)
	at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
	at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
	at org.sqlite.core.DB.prepare(DB.java:257)
	at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:47)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30)
	at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19)
	at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
	at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)
	at metabase.driver.sqlite$eval667$fn__668.invoke(sqlite.clj:351)
	at clojure.lang.MultiFn.invoke(MultiFn.java:244)
	at metabase.driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:255)
	at metabase.driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:252)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:388)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:384)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)
	at metabase.driver.sql_jdbc$fn__79191.invokeStatic(sql_jdbc.clj:54)
	at metabase.driver.sql_jdbc$fn__79191.invoke(sql_jdbc.clj:52)
	at clojure.lang.MultiFn.invoke(MultiFn.java:244)
	at metabase.query_processor.context$executef.invokeStatic(context.clj:59)
	at metabase.query_processor.context$executef.invoke(context.clj:48)
	at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:68)
	at metabase.query_processor.context.default$default_runf.invoke(default.clj:66)
	at metabase.query_processor.context$runf.invokeStatic(context.clj:45)
	at metabase.query_processor.context$runf.invoke(context.clj:39)
	at metabase.query_processor.reducible$pivot.invokeStatic(reducible.clj:34)
	at metabase.query_processor.reducible$pivot.invoke(reducible.clj:31)
	at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__46455.invoke(mbql_to_native.clj:25)
	at metabase.query_processor.middleware.check_features$check_features$fn__45707.invoke(check_features.clj:41)
	at metabase.query_processor.middleware.limit$limit$fn__46441.invoke(limit.clj:37)
	at metabase.query_processor.middleware.cache$maybe_return_cached_results$fn__45365.invoke(cache.clj:211)
	at metabase.query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__46620.invoke(optimize_datetime_filters.clj:133)
	at metabase.query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__44511.invoke(auto_parse_filter_values.clj:43)
	at metabase.query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__40828.invoke(wrap_value_literals.clj:147)
	at metabase.query_processor.middleware.annotate$add_column_info$fn__40691.invoke(annotate.clj:582)
	at metabase.query_processor.middleware.permissions$check_query_permissions$fn__45582.invoke(permissions.clj:75)
	at metabase.query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__47143.invoke(pre_alias_aggregations.clj:40)
	at metabase.query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__45780.invoke(cumulative_aggregations.clj:60)
	at metabase.query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47456.invoke(resolve_joined_fields.clj:94)
	at metabase.query_processor.middleware.resolve_joins$resolve_joins$fn__47761.invoke(resolve_joins.clj:178)
	at metabase.query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__44105.invoke(add_implicit_joins.clj:181)
	at metabase.query_processor.middleware.large_int_id$convert_id_to_string$fn__46416.invoke(large_int_id.clj:44)
	at metabase.query_processor.middleware.format_rows$format_rows$fn__46396.invoke(format_rows.clj:74)
	at metabase.query_processor.middleware.desugar$desugar$fn__45846.invoke(desugar.clj:21)
	at metabase.query_processor.middleware.binning$update_binning_strategy$fn__44871.invoke(binning.clj:228)
	at metabase.query_processor.middleware.resolve_fields$resolve_fields$fn__45389.invoke(resolve_fields.clj:24)
	at metabase.query_processor.middleware.add_dimension_projections$add_remapping$fn__43735.invoke(add_dimension_projections.clj:316)
	at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__43966.invoke(add_implicit_clauses.clj:146)
	at metabase.query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48191.invoke(upgrade_field_literals.clj:45)
	at metabase.query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__44258.invoke(add_source_metadata.clj:122)
	at metabase.query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__47340.invoke(reconcile_breakout_and_order_by_bucketing.clj:97)
	at metabase.query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__44458.invoke(auto_bucket_datetimes.clj:139)
	at metabase.query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45436.invoke(resolve_source_table.clj:45)
	at metabase.query_processor.middleware.parameters$substitute_parameters$fn__47125.invoke(parameters.clj:111)
	at metabase.query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45488.invoke(resolve_referenced.clj:79)
	at metabase.query_processor.middleware.expand_macros$expand_macros$fn__46102.invoke(expand_macros.clj:155)
	at metabase.query_processor.middleware.add_timezone_info$add_timezone_info$fn__44267.invoke(add_timezone_info.clj:15)
	at metabase.query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__48127.invoke(splice_params_in_response.clj:32)
	at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47351$fn__47355.invoke(resolve_database_and_driver.clj:31)
	at metabase.driver$do_with_driver.invokeStatic(driver.clj:60)
	at metabase.driver$do_with_driver.invoke(driver.clj:56)
	at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47351.invoke(resolve_database_and_driver.clj:25)
	at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46342.invoke(fetch_source_query.clj:274)
	at metabase.query_processor.middleware.store$initialize_store$fn__48136$fn__48137.invoke(store.clj:11)
	at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:44)
	at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
	at metabase.query_processor.middleware.store$initialize_store$fn__48136.invoke(store.clj:10)
	at metabase.query_processor.middleware.validate$validate_query$fn__48198.invoke(validate.clj:10)
	at metabase.query_processor.middleware.normalize_query$normalize$fn__46468.invoke(normalize_query.clj:22)
	at metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__44123.invoke(add_rows_truncated.clj:35)
	at metabase.query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__48112.invoke(results_metadata.clj:147)
	at metabase.query_processor.reducible$async_qp$qp_STAR___37431$thunk__37432.invoke(reducible.clj:103)
	at metabase.query_processor.reducible$async_qp$qp_STAR___37431.invoke(reducible.clj:109)
	at metabase.query_processor.reducible$async_qp$qp_STAR___37431.invoke(reducible.clj:96)
	at metabase.query_processor.reducible$sync_qp$qp_STAR___37440$fn__37441.invoke(reducible.clj:131)
	at metabase.query_processor.reducible$sync_qp$qp_STAR___37440.invoke(reducible.clj:130)
	at clojure.lang.AFn.applyToHelper(AFn.java:154)
	at clojure.lang.AFn.applyTo(AFn.java:144)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:660)
	at metabase.query_processor$process_query.invokeStatic(query_processor.clj:146)
	at metabase.query_processor$process_query.doInvoke(query_processor.clj:140)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.db.metadata_queries$qp_query$fn__59211.invoke(metadata_queries.clj:21)
	at metabase.db.metadata_queries$qp_query.invokeStatic(metadata_queries.clj:20)
	at metabase.db.metadata_queries$qp_query.invoke(metadata_queries.clj:18)
	at metabase.db.metadata_queries$field_query.invokeStatic(metadata_queries.clj:30)
	at metabase.db.metadata_queries$field_query.invoke(metadata_queries.clj:28)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240$fn__59243.invoke(metadata_queries.clj:75)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240.invoke(metadata_queries.clj:68)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240$fn__59241.invoke(metadata_queries.clj:72)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240.invoke(metadata_queries.clj:68)
	at clojure.lang.Var.invoke(Var.java:384)
	at metabase.models.field_values$distinct_values.invokeStatic(field_values.clj:123)
	at metabase.models.field_values$distinct_values.invoke(field_values.clj:115)
	at metabase.models.field_values$create_or_update_field_values_BANG_.invokeStatic(field_values.clj:145)
	at metabase.models.field_values$create_or_update_field_values_BANG_.doInvoke(field_values.clj:139)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.sync.field_values$fn__59903$update_field_values_for_field_BANG___59908$fn__59909.invoke(field_values.clj:23)
	at metabase.sync.field_values$fn__59903$update_field_values_for_field_BANG___59908.invoke(field_values.clj:21)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934$fn__59935$fn__59936$fn__59937.invoke(field_values.clj:44)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:151)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:144)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934$fn__59935$fn__59936.invoke(field_values.clj:42)
	at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
	at clojure.core$reduce.invokeStatic(core.clj:6827)
	at clojure.core$reduce.invoke(core.clj:6810)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934$fn__59935.invoke(field_values.clj:41)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934.invoke(field_values.clj:38)
	at clojure.core$map$fn__5866.invoke(core.clj:2753)
	at clojure.lang.LazySeq.sval(LazySeq.java:42)
	at clojure.lang.LazySeq.seq(LazySeq.java:51)
	at clojure.lang.Cons.next(Cons.java:39)
	at clojure.lang.RT.boundedLength(RT.java:1792)
	at clojure.lang.RestFn.applyTo(RestFn.java:130)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:660)
	at metabase.sync.field_values$fn__59956$update_field_values_for_database_BANG___59961$fn__59962.invoke(field_values.clj:52)
	at metabase.sync.field_values$fn__59956$update_field_values_for_database_BANG___59961.invoke(field_values.clj:50)
	at clojure.lang.AFn.applyToHelper(AFn.java:154)
	at clojure.lang.AFn.applyTo(AFn.java:144)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:660)
	at metabase.sync.util$fn__39397$run_step_with_metadata__39402$fn__39406$fn__39408.doInvoke(util.clj:352)
	at clojure.lang.RestFn.invoke(RestFn.java:397)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:99)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:93)
	at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:116)
	at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:113)
	at metabase.sync.util$fn__39397$run_step_with_metadata__39402$fn__39406.invoke(util.clj:347)
	at metabase.sync.util$fn__39397$run_step_with_metadata__39402.invoke(util.clj:342)
	at metabase.sync.util$fn__39588$run_sync_operation__39593$fn__39594$fn__39602.invoke(util.clj:441)
	at metabase.sync.util$fn__39588$run_sync_operation__39593$fn__39594.invoke(util.clj:439)
	at metabase.sync.util$fn__39588$run_sync_operation__39593.invoke(util.clj:433)
	at metabase.sync.field_values$fn__59982$update_field_values_BANG___59987$fn__59988$fn__59989.invoke(field_values.clj:67)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:151)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:144)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:147)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:144)
	at clojure.core$partial$fn__5839.invoke(core.clj:2623)
	at metabase.driver$fn__29101.invokeStatic(driver.clj:527)
	at metabase.driver$fn__29101.invoke(driver.clj:527)
	at clojure.lang.MultiFn.invoke(MultiFn.java:239)
	at metabase.sync.util$sync_in_context$fn__39309.invoke(util.clj:135)
	at metabase.sync.util$with_db_logging_disabled$fn__39306.invoke(util.clj:126)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:99)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:93)
	at metabase.sync.util$with_start_and_finish_logging$fn__39295.invoke(util.clj:111)
	at metabase.sync.util$with_sync_events$fn__39290.invoke(util.clj:85)
	at metabase.sync.util$with_duplicate_ops_prevented$fn__39281.invoke(util.clj:64)
	at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:169)
	at metabase.sync.util$do_sync_operation.invoke(util.clj:166)
	at metabase.sync.field_values$fn__59982$update_field_values_BANG___59987$fn__59988.invoke(field_values.clj:65)
	at metabase.sync.field_values$fn__59982$update_field_values_BANG___59987.invoke(field_values.clj:61)
	at metabase.api.database$fn__62350$fn__62352.invoke(database.clj:635)
	at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
	at clojure.lang.AFn.call(AFn.java:18)
	at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:56+01:00 DEBUG metabase.sync.field-values Looking into updating FieldValues for Field 80 'deviceid'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:56+01:00 ERROR metabase.models.field-values Error fetching field values
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: cityprobe)
	at org.sqlite.core.DB.newSQLException(DB.java:941)
	at org.sqlite.core.DB.newSQLException(DB.java:953)
	at org.sqlite.core.DB.throwex(DB.java:918)
	at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
	at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
	at org.sqlite.core.DB.prepare(DB.java:257)
	at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:47)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30)
	at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19)
	at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
	at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)
	at metabase.driver.sqlite$eval667$fn__668.invoke(sqlite.clj:351)
	at clojure.lang.MultiFn.invoke(MultiFn.java:244)
	at metabase.driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:255)
	at metabase.driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:252)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:388)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:384)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)
	at metabase.driver.sql_jdbc$fn__79191.invokeStatic(sql_jdbc.clj:54)
	at metabase.driver.sql_jdbc$fn__79191.invoke(sql_jdbc.clj:52)
	at clojure.lang.MultiFn.invoke(MultiFn.java:244)
	at metabase.query_processor.context$executef.invokeStatic(context.clj:59)
	at metabase.query_processor.context$executef.invoke(context.clj:48)
	at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:68)
	at metabase.query_processor.context.default$default_runf.invoke(default.clj:66)
	at metabase.query_processor.context$runf.invokeStatic(context.clj:45)
	at metabase.query_processor.context$runf.invoke(context.clj:39)
	at metabase.query_processor.reducible$pivot.invokeStatic(reducible.clj:34)
	at metabase.query_processor.reducible$pivot.invoke(reducible.clj:31)
	at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__46455.invoke(mbql_to_native.clj:25)
	at metabase.query_processor.middleware.check_features$check_features$fn__45707.invoke(check_features.clj:41)
	at metabase.query_processor.middleware.limit$limit$fn__46441.invoke(limit.clj:37)
	at metabase.query_processor.middleware.cache$maybe_return_cached_results$fn__45365.invoke(cache.clj:211)
	at metabase.query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__46620.invoke(optimize_datetime_filters.clj:133)
	at metabase.query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__44511.invoke(auto_parse_filter_values.clj:43)
	at metabase.query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__40828.invoke(wrap_value_literals.clj:147)
	at metabase.query_processor.middleware.annotate$add_column_info$fn__40691.invoke(annotate.clj:582)
	at metabase.query_processor.middleware.permissions$check_query_permissions$fn__45582.invoke(permissions.clj:75)
	at metabase.query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__47143.invoke(pre_alias_aggregations.clj:40)
	at metabase.query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__45780.invoke(cumulative_aggregations.clj:60)
	at metabase.query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47456.invoke(resolve_joined_fields.clj:94)
	at metabase.query_processor.middleware.resolve_joins$resolve_joins$fn__47761.invoke(resolve_joins.clj:178)
	at metabase.query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__44105.invoke(add_implicit_joins.clj:181)
	at metabase.query_processor.middleware.large_int_id$convert_id_to_string$fn__46416.invoke(large_int_id.clj:44)
	at metabase.query_processor.middleware.format_rows$format_rows$fn__46396.invoke(format_rows.clj:74)
	at metabase.query_processor.middleware.desugar$desugar$fn__45846.invoke(desugar.clj:21)
	at metabase.query_processor.middleware.binning$update_binning_strategy$fn__44871.invoke(binning.clj:228)
	at metabase.query_processor.middleware.resolve_fields$resolve_fields$fn__45389.invoke(resolve_fields.clj:24)
	at metabase.query_processor.middleware.add_dimension_projections$add_remapping$fn__43735.invoke(add_dimension_projections.clj:316)
	at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__43966.invoke(add_implicit_clauses.clj:146)
	at metabase.query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48191.invoke(upgrade_field_literals.clj:45)
	at metabase.query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__44258.invoke(add_source_metadata.clj:122)
	at metabase.query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__47340.invoke(reconcile_breakout_and_order_by_bucketing.clj:97)
	at metabase.query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__44458.invoke(auto_bucket_datetimes.clj:139)
	at metabase.query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45436.invoke(resolve_source_table.clj:45)
	at metabase.query_processor.middleware.parameters$substitute_parameters$fn__47125.invoke(parameters.clj:111)
	at metabase.query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45488.invoke(resolve_referenced.clj:79)
	at metabase.query_processor.middleware.expand_macros$expand_macros$fn__46102.invoke(expand_macros.clj:155)
	at metabase.query_processor.middleware.add_timezone_info$add_timezone_info$fn__44267.invoke(add_timezone_info.clj:15)
	at metabase.query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__48127.invoke(splice_params_in_response.clj:32)
	at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47351$fn__47355.invoke(resolve_database_and_driver.clj:31)
	at metabase.driver$do_with_driver.invokeStatic(driver.clj:60)
	at metabase.driver$do_with_driver.invoke(driver.clj:56)
	at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47351.invoke(resolve_database_and_driver.clj:25)
	at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46342.invoke(fetch_source_query.clj:274)
	at metabase.query_processor.middleware.store$initialize_store$fn__48136$fn__48137.invoke(store.clj:11)
	at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:44)
	at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
	at metabase.query_processor.middleware.store$initialize_store$fn__48136.invoke(store.clj:10)
	at metabase.query_processor.middleware.validate$validate_query$fn__48198.invoke(validate.clj:10)
	at metabase.query_processor.middleware.normalize_query$normalize$fn__46468.invoke(normalize_query.clj:22)
	at metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__44123.invoke(add_rows_truncated.clj:35)
	at metabase.query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__48112.invoke(results_metadata.clj:147)
	at metabase.query_processor.reducible$async_qp$qp_STAR___37431$thunk__37432.invoke(reducible.clj:103)
	at metabase.query_processor.reducible$async_qp$qp_STAR___37431.invoke(reducible.clj:109)
	at metabase.query_processor.reducible$async_qp$qp_STAR___37431.invoke(reducible.clj:96)
	at metabase.query_processor.reducible$sync_qp$qp_STAR___37440$fn__37441.invoke(reducible.clj:131)
	at metabase.query_processor.reducible$sync_qp$qp_STAR___37440.invoke(reducible.clj:130)
	at clojure.lang.AFn.applyToHelper(AFn.java:154)
	at clojure.lang.AFn.applyTo(AFn.java:144)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:660)
	at metabase.query_processor$process_query.invokeStatic(query_processor.clj:146)
	at metabase.query_processor$process_query.doInvoke(query_processor.clj:140)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.db.metadata_queries$qp_query$fn__59211.invoke(metadata_queries.clj:21)
	at metabase.db.metadata_queries$qp_query.invokeStatic(metadata_queries.clj:20)
	at metabase.db.metadata_queries$qp_query.invoke(metadata_queries.clj:18)
	at metabase.db.metadata_queries$field_query.invokeStatic(metadata_queries.clj:30)
	at metabase.db.metadata_queries$field_query.invoke(metadata_queries.clj:28)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240$fn__59243.invoke(metadata_queries.clj:75)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240.invoke(metadata_queries.clj:68)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240$fn__59241.invoke(metadata_queries.clj:72)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240.invoke(metadata_queries.clj:68)
	at clojure.lang.Var.invoke(Var.java:384)
	at metabase.models.field_values$distinct_values.invokeStatic(field_values.clj:123)
	at metabase.models.field_values$distinct_values.invoke(field_values.clj:115)
	at metabase.models.field_values$create_or_update_field_values_BANG_.invokeStatic(field_values.clj:145)
	at metabase.models.field_values$create_or_update_field_values_BANG_.doInvoke(field_values.clj:139)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.sync.field_values$fn__59903$update_field_values_for_field_BANG___59908$fn__59909.invoke(field_values.clj:23)
	at metabase.sync.field_values$fn__59903$update_field_values_for_field_BANG___59908.invoke(field_values.clj:21)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934$fn__59935$fn__59936$fn__59937.invoke(field_values.clj:44)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:151)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:144)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934$fn__59935$fn__59936.invoke(field_values.clj:42)
	at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
	at clojure.core$reduce.invokeStatic(core.clj:6827)
	at clojure.core$reduce.invoke(core.clj:6810)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934$fn__59935.invoke(field_values.clj:41)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934.invoke(field_values.clj:38)
	at clojure.core$map$fn__5866.invoke(core.clj:2753)
	at clojure.lang.LazySeq.sval(LazySeq.java:42)
	at clojure.lang.LazySeq.seq(LazySeq.java:51)
	at clojure.lang.Cons.next(Cons.java:39)
	at clojure.lang.RT.boundedLength(RT.java:1792)
	at clojure.lang.RestFn.applyTo(RestFn.java:130)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:660)
	at metabase.sync.field_values$fn__59956$update_field_values_for_database_BANG___59961$fn__59962.invoke(field_values.clj:52)
	at metabase.sync.field_values$fn__59956$update_field_values_for_database_BANG___59961.invoke(field_values.clj:50)
	at clojure.lang.AFn.applyToHelper(AFn.java:154)
	at clojure.lang.AFn.applyTo(AFn.java:144)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:660)
	at metabase.sync.util$fn__39397$run_step_with_metadata__39402$fn__39406$fn__39408.doInvoke(util.clj:352)
	at clojure.lang.RestFn.invoke(RestFn.java:397)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:99)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:93)
	at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:116)
	at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:113)
	at metabase.sync.util$fn__39397$run_step_with_metadata__39402$fn__39406.invoke(util.clj:347)
	at metabase.sync.util$fn__39397$run_step_with_metadata__39402.invoke(util.clj:342)
	at metabase.sync.util$fn__39588$run_sync_operation__39593$fn__39594$fn__39602.invoke(util.clj:441)
	at metabase.sync.util$fn__39588$run_sync_operation__39593$fn__39594.invoke(util.clj:439)
	at metabase.sync.util$fn__39588$run_sync_operation__39593.invoke(util.clj:433)
	at metabase.sync.field_values$fn__59982$update_field_values_BANG___59987$fn__59988$fn__59989.invoke(field_values.clj:67)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:151)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:144)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:147)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:144)
	at clojure.core$partial$fn__5839.invoke(core.clj:2623)
	at metabase.driver$fn__29101.invokeStatic(driver.clj:527)
	at metabase.driver$fn__29101.invoke(driver.clj:527)
	at clojure.lang.MultiFn.invoke(MultiFn.java:239)
	at metabase.sync.util$sync_in_context$fn__39309.invoke(util.clj:135)
	at metabase.sync.util$with_db_logging_disabled$fn__39306.invoke(util.clj:126)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:99)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:93)
	at metabase.sync.util$with_start_and_finish_logging$fn__39295.invoke(util.clj:111)
	at metabase.sync.util$with_sync_events$fn__39290.invoke(util.clj:85)
	at metabase.sync.util$with_duplicate_ops_prevented$fn__39281.invoke(util.clj:64)
	at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:169)
	at metabase.sync.util$do_sync_operation.invoke(util.clj:166)
	at metabase.sync.field_values$fn__59982$update_field_values_BANG___59987$fn__59988.invoke(field_values.clj:65)
	at metabase.sync.field_values$fn__59982$update_field_values_BANG___59987.invoke(field_values.clj:61)
	at metabase.api.database$fn__62350$fn__62352.invoke(database.clj:635)
	at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
	at clojure.lang.AFn.call(AFn.java:18)
	at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:56+01:00 DEBUG metabase.sync.field-values Looking into updating FieldValues for Field 86 'PM2.5'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:56+01:00 ERROR metabase.models.field-values Error fetching field values
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: cityprobe)
	at org.sqlite.core.DB.newSQLException(DB.java:941)
	at org.sqlite.core.DB.newSQLException(DB.java:953)
	at org.sqlite.core.DB.throwex(DB.java:918)
	at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
	at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
	at org.sqlite.core.DB.prepare(DB.java:257)
	at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:47)
	at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30)
	at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19)
	at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
	at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)
	at metabase.driver.sqlite$eval667$fn__668.invoke(sqlite.clj:351)
	at clojure.lang.MultiFn.invoke(MultiFn.java:244)
	at metabase.driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:255)
	at metabase.driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:252)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:388)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:384)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)
	at metabase.driver.sql_jdbc$fn__79191.invokeStatic(sql_jdbc.clj:54)
	at metabase.driver.sql_jdbc$fn__79191.invoke(sql_jdbc.clj:52)
	at clojure.lang.MultiFn.invoke(MultiFn.java:244)
	at metabase.query_processor.context$executef.invokeStatic(context.clj:59)
	at metabase.query_processor.context$executef.invoke(context.clj:48)
	at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:68)
	at metabase.query_processor.context.default$default_runf.invoke(default.clj:66)
	at metabase.query_processor.context$runf.invokeStatic(context.clj:45)
	at metabase.query_processor.context$runf.invoke(context.clj:39)
	at metabase.query_processor.reducible$pivot.invokeStatic(reducible.clj:34)
	at metabase.query_processor.reducible$pivot.invoke(reducible.clj:31)
	at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__46455.invoke(mbql_to_native.clj:25)
	at metabase.query_processor.middleware.check_features$check_features$fn__45707.invoke(check_features.clj:41)
	at metabase.query_processor.middleware.limit$limit$fn__46441.invoke(limit.clj:37)
	at metabase.query_processor.middleware.cache$maybe_return_cached_results$fn__45365.invoke(cache.clj:211)
	at metabase.query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__46620.invoke(optimize_datetime_filters.clj:133)
	at metabase.query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__44511.invoke(auto_parse_filter_values.clj:43)
	at metabase.query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__40828.invoke(wrap_value_literals.clj:147)
	at metabase.query_processor.middleware.annotate$add_column_info$fn__40691.invoke(annotate.clj:582)
	at metabase.query_processor.middleware.permissions$check_query_permissions$fn__45582.invoke(permissions.clj:75)
	at metabase.query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__47143.invoke(pre_alias_aggregations.clj:40)
	at metabase.query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__45780.invoke(cumulative_aggregations.clj:60)
	at metabase.query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47456.invoke(resolve_joined_fields.clj:94)
	at metabase.query_processor.middleware.resolve_joins$resolve_joins$fn__47761.invoke(resolve_joins.clj:178)
	at metabase.query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__44105.invoke(add_implicit_joins.clj:181)
	at metabase.query_processor.middleware.large_int_id$convert_id_to_string$fn__46416.invoke(large_int_id.clj:44)
	at metabase.query_processor.middleware.format_rows$format_rows$fn__46396.invoke(format_rows.clj:74)
	at metabase.query_processor.middleware.desugar$desugar$fn__45846.invoke(desugar.clj:21)
	at metabase.query_processor.middleware.binning$update_binning_strategy$fn__44871.invoke(binning.clj:228)
	at metabase.query_processor.middleware.resolve_fields$resolve_fields$fn__45389.invoke(resolve_fields.clj:24)
	at metabase.query_processor.middleware.add_dimension_projections$add_remapping$fn__43735.invoke(add_dimension_projections.clj:316)
	at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__43966.invoke(add_implicit_clauses.clj:146)
	at metabase.query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48191.invoke(upgrade_field_literals.clj:45)
	at metabase.query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__44258.invoke(add_source_metadata.clj:122)
	at metabase.query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__47340.invoke(reconcile_breakout_and_order_by_bucketing.clj:97)
	at metabase.query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__44458.invoke(auto_bucket_datetimes.clj:139)
	at metabase.query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45436.invoke(resolve_source_table.clj:45)
	at metabase.query_processor.middleware.parameters$substitute_parameters$fn__47125.invoke(parameters.clj:111)
	at metabase.query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45488.invoke(resolve_referenced.clj:79)
	at metabase.query_processor.middleware.expand_macros$expand_macros$fn__46102.invoke(expand_macros.clj:155)
	at metabase.query_processor.middleware.add_timezone_info$add_timezone_info$fn__44267.invoke(add_timezone_info.clj:15)
	at metabase.query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__48127.invoke(splice_params_in_response.clj:32)
	at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47351$fn__47355.invoke(resolve_database_and_driver.clj:31)
	at metabase.driver$do_with_driver.invokeStatic(driver.clj:60)
	at metabase.driver$do_with_driver.invoke(driver.clj:56)
	at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47351.invoke(resolve_database_and_driver.clj:25)
	at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46342.invoke(fetch_source_query.clj:274)
	at metabase.query_processor.middleware.store$initialize_store$fn__48136$fn__48137.invoke(store.clj:11)
	at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:44)
	at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
	at metabase.query_processor.middleware.store$initialize_store$fn__48136.invoke(store.clj:10)
	at metabase.query_processor.middleware.validate$validate_query$fn__48198.invoke(validate.clj:10)
	at metabase.query_processor.middleware.normalize_query$normalize$fn__46468.invoke(normalize_query.clj:22)
	at metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__44123.invoke(add_rows_truncated.clj:35)
	at metabase.query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__48112.invoke(results_metadata.clj:147)
	at metabase.query_processor.reducible$async_qp$qp_STAR___37431$thunk__37432.invoke(reducible.clj:103)
	at metabase.query_processor.reducible$async_qp$qp_STAR___37431.invoke(reducible.clj:109)
	at metabase.query_processor.reducible$async_qp$qp_STAR___37431.invoke(reducible.clj:96)
	at metabase.query_processor.reducible$sync_qp$qp_STAR___37440$fn__37441.invoke(reducible.clj:131)
	at metabase.query_processor.reducible$sync_qp$qp_STAR___37440.invoke(reducible.clj:130)
	at clojure.lang.AFn.applyToHelper(AFn.java:154)
	at clojure.lang.AFn.applyTo(AFn.java:144)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:660)
	at metabase.query_processor$process_query.invokeStatic(query_processor.clj:146)
	at metabase.query_processor$process_query.doInvoke(query_processor.clj:140)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.db.metadata_queries$qp_query$fn__59211.invoke(metadata_queries.clj:21)
	at metabase.db.metadata_queries$qp_query.invokeStatic(metadata_queries.clj:20)
	at metabase.db.metadata_queries$qp_query.invoke(metadata_queries.clj:18)
	at metabase.db.metadata_queries$field_query.invokeStatic(metadata_queries.clj:30)
	at metabase.db.metadata_queries$field_query.invoke(metadata_queries.clj:28)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240$fn__59243.invoke(metadata_queries.clj:75)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240.invoke(metadata_queries.clj:68)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240$fn__59241.invoke(metadata_queries.clj:72)
	at metabase.db.metadata_queries$fn__59231$field_distinct_values__59240.invoke(metadata_queries.clj:68)
	at clojure.lang.Var.invoke(Var.java:384)
	at metabase.models.field_values$distinct_values.invokeStatic(field_values.clj:123)
	at metabase.models.field_values$distinct_values.invoke(field_values.clj:115)
	at metabase.models.field_values$create_or_update_field_values_BANG_.invokeStatic(field_values.clj:145)
	at metabase.models.field_values$create_or_update_field_values_BANG_.doInvoke(field_values.clj:139)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.sync.field_values$fn__59903$update_field_values_for_field_BANG___59908$fn__59909.invoke(field_values.clj:23)
	at metabase.sync.field_values$fn__59903$update_field_values_for_field_BANG___59908.invoke(field_values.clj:21)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934$fn__59935$fn__59936$fn__59937.invoke(field_values.clj:44)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:151)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:144)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934$fn__59935$fn__59936.invoke(field_values.clj:42)
	at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
	at clojure.core$reduce.invokeStatic(core.clj:6827)
	at clojure.core$reduce.invoke(core.clj:6810)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934$fn__59935.invoke(field_values.clj:41)
	at metabase.sync.field_values$fn__59929$update_field_values_for_table_BANG___59934.invoke(field_values.clj:38)
	at clojure.core$map$fn__5866.invoke(core.clj:2753)
	at clojure.lang.LazySeq.sval(LazySeq.java:42)
	at clojure.lang.LazySeq.seq(LazySeq.java:51)
	at clojure.lang.Cons.next(Cons.java:39)
	at clojure.lang.RT.boundedLength(RT.java:1792)
	at clojure.lang.RestFn.applyTo(RestFn.java:130)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:660)
	at metabase.sync.field_values$fn__59956$update_field_values_for_database_BANG___59961$fn__59962.invoke(field_values.clj:52)
	at metabase.sync.field_values$fn__59956$update_field_values_for_database_BANG___59961.invoke(field_values.clj:50)
	at clojure.lang.AFn.applyToHelper(AFn.java:154)
	at clojure.lang.AFn.applyTo(AFn.java:144)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:660)
	at metabase.sync.util$fn__39397$run_step_with_metadata__39402$fn__39406$fn__39408.doInvoke(util.clj:352)
	at clojure.lang.RestFn.invoke(RestFn.java:397)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:99)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:93)
	at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:116)
	at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:113)
	at metabase.sync.util$fn__39397$run_step_with_metadata__39402$fn__39406.invoke(util.clj:347)
	at metabase.sync.util$fn__39397$run_step_with_metadata__39402.invoke(util.clj:342)
	at metabase.sync.util$fn__39588$run_sync_operation__39593$fn__39594$fn__39602.invoke(util.clj:441)
	at metabase.sync.util$fn__39588$run_sync_operation__39593$fn__39594.invoke(util.clj:439)
	at metabase.sync.util$fn__39588$run_sync_operation__39593.invoke(util.clj:433)
	at metabase.sync.field_values$fn__59982$update_field_values_BANG___59987$fn__59988$fn__59989.invoke(field_values.clj:67)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:151)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:144)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:147)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:144)
	at clojure.core$partial$fn__5839.invoke(core.clj:2623)
	at metabase.driver$fn__29101.invokeStatic(driver.clj:527)
	at metabase.driver$fn__29101.invoke(driver.clj:527)
	at clojure.lang.MultiFn.invoke(MultiFn.java:239)
	at metabase.sync.util$sync_in_context$fn__39309.invoke(util.clj:135)
	at metabase.sync.util$with_db_logging_disabled$fn__39306.invoke(util.clj:126)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:99)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:93)
	at metabase.sync.util$with_start_and_finish_logging$fn__39295.invoke(util.clj:111)
	at metabase.sync.util$with_sync_events$fn__39290.invoke(util.clj:85)
	at metabase.sync.util$with_duplicate_ops_prevented$fn__39281.invoke(util.clj:64)
	at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:169)
	at metabase.sync.util$do_sync_operation.invoke(util.clj:166)
	at metabase.sync.field_values$fn__59982$update_field_values_BANG___59987$fn__59988.invoke(field_values.clj:65)
	at metabase.sync.field_values$fn__59982$update_field_values_BANG___59987.invoke(field_values.clj:61)
	at metabase.api.database$fn__62350$fn__62352.invoke(database.clj:635)
	at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
	at clojure.lang.AFn.call(AFn.java:18)
	at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:56+01:00 INFO metabase.sync.util FINISHED: step 'update-field-values' for sqlite Database 4 'Data dump fra OpenData.dk' (517.4 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:56+01:00 DEBUG metabase.sync.util 
#################################################################
# Completed field values scanning on Data dump fra OpenData.dk
# Start: 2021-03-26T14:31:55.68093+01:00
# End: 2021-03-26T14:31:56.199455+01:00
# Duration: 518.5 ms
# ---------------------------------------------------------------
# Completed step 'update-field-values'
# Start: 2021-03-26T14:31:55.680978+01:00
# End: 2021-03-26T14:31:56.199361+01:00
# Duration: 518.4 ms
# Updated 0 field value sets, created 0, deleted 1 with 0 errors
#################################################################

[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:31:56+01:00 INFO metabase.sync.util FINISHED: Cache field values in sqlite Database 4 'Data dump fra OpenData.dk' (535.7 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.task.sync-databases Scheduling sync/analyze for database 5: trigger: metabase.task.sync-and-analyze.trigger.5
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.task.sync-databases Scheduling field-values for database 5: trigger: metabase.task.update-field-values.trigger.5
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 DEBUG metabase.sync.util Sync operations in flight: {:sync #{5}}
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: Sync sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: Sync metadata for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 DEBUG metabase.sync.util Sync operations in flight: {:sync-metadata #{5}, :sync #{5}}
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for sqlite Database 5 'CityProbe' (68.1 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: step 'sync-tables' for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for sqlite Database 5 'CityProbe' (6.0 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: step 'sync-fields' for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for sqlite Database 5 'CityProbe' (1.3 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: step 'sync-fks' for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for sqlite Database 5 'CityProbe' (1.0 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for sqlite Database 5 'CityProbe' (1.2 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 DEBUG metabase.sync.util 
#################################################################
# Completed sync on CityProbe
# Start: 2021-03-26T14:37:44.136392+01:00
# End: 2021-03-26T14:37:44.218072+01:00
# Duration: 81.7 ms
# ---------------------------------------------------------------
# Completed step 'sync-timezone'
# Start: 2021-03-26T14:37:44.136445+01:00
# End: 2021-03-26T14:37:44.205435+01:00
# Duration: 69.0 ms
# Found timezone id Europe/Copenhagen
# ---------------------------------------------------------------
# Completed step 'sync-tables'
# Start: 2021-03-26T14:37:44.205579+01:00
# End: 2021-03-26T14:37:44.212375+01:00
# Duration: 6.8 ms
# Total number of tables sync'd 0, number of tables updated 0
# ---------------------------------------------------------------
# Completed step 'sync-fields'
# Start: 2021-03-26T14:37:44.212473+01:00
# End: 2021-03-26T14:37:44.214428+01:00
# Duration: 2.0 ms
# Total number of fields sync'd null, number of fields updated null
# ---------------------------------------------------------------
# Completed step 'sync-fks'
# Start: 2021-03-26T14:37:44.214474+01:00
# End: 2021-03-26T14:37:44.216149+01:00
# Duration: 1.7 ms
# Total number of foreign keys sync'd 0, 0 updated and 0 tables failed to update
# ---------------------------------------------------------------
# Completed step 'sync-metabase-metadata'
# Start: 2021-03-26T14:37:44.216225+01:00
# End: 2021-03-26T14:37:44.218037+01:00
# Duration: 1.8 ms
#################################################################

[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: Sync metadata for sqlite Database 5 'CityProbe' (93.6 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: Analyze data for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 DEBUG metabase.sync.util Sync operations in flight: {:analyze #{5}, :sync #{5}}
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for sqlite Database 5 'CityProbe' (539.3 µs)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: step 'classify-fields' for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for sqlite Database 5 'CityProbe' (376.5 µs)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: step 'classify-tables' for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for sqlite Database 5 'CityProbe' (297.4 µs)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 DEBUG metabase.sync.util 
#################################################################
# Completed analyze on CityProbe
# Start: 2021-03-26T14:37:44.232078+01:00
# End: 2021-03-26T14:37:44.235587+01:00
# Duration: 3.5 ms
# ---------------------------------------------------------------
# Completed step 'fingerprint-fields'
# Start: 2021-03-26T14:37:44.232131+01:00
# End: 2021-03-26T14:37:44.233344+01:00
# Duration: 1.2 ms
# Fingerprint updates attempted 0, updated 0, no data found 0, failed 0
# ---------------------------------------------------------------
# Completed step 'classify-fields'
# Start: 2021-03-26T14:37:44.233433+01:00
# End: 2021-03-26T14:37:44.234471+01:00
# Duration: 1.0 ms
# Total number of fields classified 0, 0 failed
# ---------------------------------------------------------------
# Completed step 'classify-tables'
# Start: 2021-03-26T14:37:44.23452+01:00
# End: 2021-03-26T14:37:44.235503+01:00
# Duration: 983.0 µs
# Total number of tables classified 0, 0 updated
#################################################################

[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: Analyze data for sqlite Database 5 'CityProbe' (13.0 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 DEBUG metabase.sync.util Sync operations in flight: {:cache-field-values #{5}, :sync #{5}}
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: Cache field values in sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util STARTING: step 'update-field-values' for sqlite Database 5 'CityProbe'
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: step 'update-field-values' for sqlite Database 5 'CityProbe' (1.2 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 DEBUG metabase.sync.util 
#################################################################
# Completed field values scanning on CityProbe
# Start: 2021-03-26T14:37:44.245649+01:00
# End: 2021-03-26T14:37:44.247634+01:00
# Duration: 2.0 ms
# ---------------------------------------------------------------
# Completed step 'update-field-values'
# Start: 2021-03-26T14:37:44.245679+01:00
# End: 2021-03-26T14:37:44.247587+01:00
# Duration: 1.9 ms
# Updated null field value sets, created null, deleted null with null errors
#################################################################

[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: Cache field values in sqlite Database 5 'CityProbe' (6.2 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:37:44+01:00 INFO metabase.sync.util FINISHED: Sync sqlite Database 5 'CityProbe' (118.6 ms)
[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:39:35+01:00 WARN metabase.server.middleware.log GET /api/database/4/metadata 404 2.7 ms (1 DB calls) 
"Not found."

[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:39:35+01:00 WARN metabase.server.middleware.log GET /api/database/4 404 1.5 ms (1 DB calls) 
"Not found."

[20d8c516-814a-4d4c-92c9-b7965a83b816] 2021-03-26T14:39:35+01:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.

flamber · March 26, 2021, 1:57pm

@Anders
Is the database public? If yes, can you supply a link?
Is this a new problem that worked on previous versions of Metabase or ?
All the test SQLite databases I have functions normally.

Anders · March 26, 2021, 2:00pm

It is a local SQLite .db file placed in the volume at /home/metabase/file.db, so I cannot link to it, but I can send you any info you might need.
I have not run this file in MB before.

sqlite> .tables
cityprobe        device_lat_long

sqlite> .schema cityprobe
CREATE TABLE cityprobe (
        "index" BIGINT,
        _id BIGINT,
        noise TEXT,
        "CO" BIGINT,
        temperature FLOAT,
        "PM10" BIGINT,
        battery FLOAT,
        rain TEXT,
        humidity FLOAT,
        illuminance BIGINT,
        pressure FLOAT,
        published_at TEXT,
        "PM2.5" BIGINT,
        deviceid TEXT,
        "NO2" BIGINT,
        firmware_version FLOAT,
        device_id TEXT
);
CREATE INDEX ix_cityprobe_index ON cityprobe ("index");
sqlite> .schema device_lat_long
CREATE TABLE device_lat_long (
        "index" BIGINT,
        "deviceid;createdAt;latitude;longitude" TEXT
);
CREATE INDEX ix_device_lat_long_index ON device_lat_long ("index");

flamber · March 26, 2021, 2:05pm

@Anders I understand it's locally on your machine - I'm asking if you have downloaded it from a public place, since the name indicates that it comes from OpenData.
Please check that the file not corrupted (try with DBeaver.io). And make sure that Metabase has permissions to read the file. When you run Metabase in Docker, then it's being run with UID/GID = 2000/2000.