Metabase error sync data


#1

i got this error while trying to make metabase work on cloud foundry with a compose for postgres database :

Jul 23 15:21:59 DEBUG metabase.middleware :: GET /api/user/current 401 (4 ms) (0 DB calls).
“Unauthenticated”

Jul 23 15:21:59 DEBUG metabase.middleware :: GET /api/session/properties 200 (17 ms) (1 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:21:59 DEBUG metabase.middleware :: GET /api/user/current 401 (712 µs) (0 DB calls).
“Unauthenticated”

Jul 23 15:22:08 DEBUG metabase.middleware :: POST /api/session 200 (231 ms) (3 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:22:08 DEBUG metabase.middleware :: GET /api/user/current 200 (10 ms) (1 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:22:08 DEBUG metabase.middleware :: GET /api/activity/recent_views 200 (20 ms) (1 DB calls). Jetty threads: 8/50 (7 busy, 2 idle, 0 queued)
Jul 23 15:22:09 DEBUG metabase.middleware :: GET /api/setup/admin_checklist 200 (125 ms) (10 DB calls). Jetty threads: 8/50 (5 busy, 4 idle, 0 queued)
Jul 23 15:22:13 DEBUG metabase.middleware :: GET /api/database 200 (119 ms) (4 DB calls). Jetty threads: 8/50 (5 busy, 4 idle, 0 queued)
Jul 23 15:22:14 DEBUG metabase.middleware :: GET /api/metric 200 (9 ms) (1 DB calls). Jetty threads: 8/50 (6 busy, 3 idle, 0 queued)
Jul 23 15:22:14 DEBUG metabase.middleware :: GET /api/segment 200 (9 ms) (1 DB calls). Jetty threads: 8/50 (5 busy, 4 idle, 0 queued)
Jul 23 15:22:14 DEBUG metabase.middleware :: GET /api/activity 200 (6 s) (2 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:22:17 DEBUG metabase.middleware :: GET /api/table/2/query_metadata 200 (882 ms) (11 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:22:18 DEBUG metabase.middleware :: GET /api/table/3/query_metadata 200 (146 ms) (8 DB calls). Jetty threads: 8/50 (5 busy, 4 idle, 0 queued)
Jul 23 15:22:18 DEBUG metabase.middleware :: GET /api/table/1/query_metadata 200 (145 ms) (8 DB calls). Jetty threads: 8/50 (5 busy, 4 idle, 0 queued)
Jul 23 15:22:18 INFO metabase.query-processor.middleware.cache :: Using query processor cache backend: :db :floppy_disk:
Jul 23 15:22:18 DEBUG metabase.middleware :: GET /api/table/2/fks 200 (49 ms) (4 DB calls). Jetty threads: 8/50 (5 busy, 4 idle, 0 queued)
Jul 23 15:22:19 DEBUG metabase.middleware :: POST /api/dataset 200 (1 s) (12 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:22:21 ERROR metabase.query-processor.middleware.results-metadata :: Error recording results metadata for query: Output of results->column-metadata does not match schema:

(named [{:base_type (not (“Valid field type (keyword or string)” :type/BigInteger)), :special_type (not (“Valid field type (keyword or string)” :type/PK))} {:base_type (not (“Valid field type (keyword or string)” :type/DateTime))} {:base_type (not (“Valid field type (keyword or string)” :type/Float))} {:base_type (not (“Valid field type (keyword or string)” :type/Integer)), :special_type (not (“Valid field type (keyword or string)” :type/FK))} {:base_type (not (“Valid field type (keyword or string)” :type/Integer)), :special_type (not (“Valid field type (keyword or string)” :type/Category))} {:base_type (not (“Valid field type (keyword or string)” :type/Float))} {:base_type (not (“Valid field type (keyword or string)” :type/Float))} {:base_type (not (“Valid field type (keyword or string)” :type/Float))} {:base_type (not (“Valid field type (keyword or string)” :type/Integer)), :special_type (not (“Valid field type (keyword or string)” :type/FK))}] “Valid array of results column metadata maps”)

[“query_processor.middleware.results_metadata$fn__31302$results__GT_column_metadata__31307.invoke(results_metadata.clj:36)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__31340.invoke(results_metadata.clj:91)”
“query_processor.middleware.resolve$resolve_middleware$fn__28067.invoke(resolve.clj:424)”
“query_processor.middleware.expand$expand_middleware$fn__29767.invoke(expand.clj:601)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__28151.invoke(add_row_count_and_status.clj:14)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__29898.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__31351.invoke(resolve_driver.clj:15)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__28619.invoke(cache.clj:146)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__29815.invoke(catch_exceptions.clj:58)”
“query_processor$process_query.invokeStatic(query_processor.clj:130)”
“query_processor$process_query.invoke(query_processor.clj:126)”
“query_processor$run_and_save_query_BANG_.invokeStatic(query_processor.clj:241)”
“query_processor$run_and_save_query_BANG_.invoke(query_processor.clj:235)”
“query_processor$fn__31385$process_query_and_save_execution_BANG___31390$fn__31391.invoke(query_processor.clj:281)”
“query_processor$fn__31385$process_query_and_save_execution_BANG___31390.invoke(query_processor.clj:267)”
“query_processor$fn__31409$process_query_and_save_with_max_BANG___31414$fn__31415.invoke(query_processor.clj:302)”
“query_processor$fn__31409$process_query_and_save_with_max_BANG___31414.invoke(query_processor.clj:298)”
“api.dataset$fn__37933$fn__37936$fn__37937.invoke(dataset.clj:49)”
“api.common$fn__20323$invoke_thunk_with_keepalive__20328$fn__20329$fn__20330.invoke(common.clj:402)”]

Jul 23 15:22:33 DEBUG metabase.middleware :: GET /api/session/properties 200 (12 ms) (1 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:22:33 DEBUG metabase.middleware :: GET /api/setting 200 (4 ms) (0 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:22:34 DEBUG metabase.middleware :: GET /api/setup/admin_checklist 200 (88 ms) (10 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:22:35 DEBUG metabase.middleware :: GET /api/database 200 (225 ms) (2 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:22:35 DEBUG metabase.middleware :: GET /api/database/1/metadata 200 (174 ms) (9 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:22:36 DEBUG metabase.middleware :: GET /api/database/1/idfields 200 (52 ms) (5 DB calls). Jetty threads: 8/50 (4 busy, 5 idle, 0 queued)
Jul 23 15:47:38 DEBUG metabase.middleware :: GET /api/user/current 200 (93 ms) (1 DB calls). Jetty threads: 8/50 (4 busy, 4 idle, 0 queued)
Jul 23 15:48:30 DEBUG metabase.middleware :: GET /api/session/properties 200 (26 ms) (1 DB calls). Jetty threads: 8/50 (5 busy, 3 idle, 0 queued)
Jul 23 15:48:30 DEBUG metabase.middleware :: GET /api/user/current 200 (83 ms) (1 DB calls). Jetty threads: 8/50 (4 busy, 4 idle, 0 queued)
Jul 23 15:48:31 DEBUG metabase.middleware :: GET /api/database 200 (36 ms) (2 DB calls). Jetty threads: 8/50 (5 busy, 3 idle, 0 queued)
Jul 23 15:48:31 DEBUG metabase.middleware :: GET /api/user/current 200 (19 ms) (1 DB calls). Jetty threads: 8/50 (5 busy, 3 idle, 0 queued)
Jul 23 15:48:31 DEBUG metabase.middleware :: GET /api/setting 200 (1 ms) (0 DB calls). Jetty threads: 8/50 (4 busy, 4 idle, 0 queued)
Jul 23 15:48:31 DEBUG metabase.middleware :: GET /api/database/1/metadata 200 (268 ms) (9 DB calls). Jetty threads: 8/50 (5 busy, 3 idle, 0 queued)
Jul 23 15:48:32 DEBUG metabase.middleware :: GET /api/database/1/idfields 200 (123 ms) (5 DB calls). Jetty threads: 8/50 (4 busy, 4 idle, 0 queued)
Jul 23 15:49:28 DEBUG metabase.middleware :: GET /api/session/properties 200 (102 ms) (1 DB calls). Jetty threads: 8/50 (5 busy, 3 idle, 0 queued)
Jul 23 15:49:29 DEBUG metabase.middleware :: GET /api/setup/admin_checklist 200 (205 ms) (10 DB calls). Jetty threads: 8/50 (4 busy, 4 idle, 0 queued)
Jul 23 15:49:29 DEBUG metabase.middleware :: GET /api/setting 200 (6 ms) (0 DB calls). Jetty threads: 8/50 (4 busy, 4 idle, 0 queued)
Jul 23 15:49:39 DEBUG metabase.middleware :: GET /api/database 200 (26 ms) (2 DB calls). Jetty threads: 8/50 (4 busy, 4 idle, 0 queued)
Jul 23 15:49:39 DEBUG metabase.middleware :: GET /api/database/1/metadata 200 (157 ms) (9 DB calls). Jetty threads: 8/50 (4 busy, 4 idle, 0 queued)
Jul 23 15:49:40 DEBUG metabase.middleware :: GET /api/database/1/idfields 200 (68 ms) (5 DB calls). Jetty threads: 8/50 (4 busy, 4 idle, 0 queued)
Jul 23 15:50:00 DEBUG metabase.sync.util :: Sync operations in flight: {:sync-metadata #{1}}
Jul 23 15:50:00 INFO metabase.sync.util :: STARTING: Sync metadata for h2 Database 1 ‘Sample Dataset’
Jul 23 15:50:01 ERROR metabase.sync.util :: Error syncing fields for Table 4 ‘PUBLIC.REVIEWS’: Output of table-metadata does not match schema:

{:fields #{{:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/BigInteger))} {:base-type (not (“Valid field type” :type/DateTime))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/Integer))} {:base-type (not (“Valid field type” :type/Integer))}}}

(“sync.fetch_metadata$fn__36355$table_metadata__36360.invoke(fetch_metadata.clj:15)”
“sync.sync_metadata.fields$fn__36916$db_metadata__36921$fn__36922.invoke(fields.clj:294)”
“sync.sync_metadata.fields$fn__36916$db_metadata__36921.invoke(fields.clj:290)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953$fn__36956$fn__36957.invoke(fields.clj:307)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953$fn__36956.invoke(fields.clj:306)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953.invoke(fields.clj:301)”
“sync.sync_metadata.fields$fn__36982$sync_fields_BANG___36987$fn__36988.invoke(fields.clj:318)”
“sync.sync_metadata.fields$fn__36982$sync_fields_BANG___36987.invoke(fields.clj:314)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556$fn__37557$fn__37558.invoke(sync_metadata.clj:28)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:122)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“driver$fn__25838.invokeStatic(driver.clj:235)”
“driver$fn__25838.invoke(driver.clj:235)”
“driver$fn__25773$G__25580__25782.invoke(driver.clj:51)”
“sync.util$sync_in_context$fn__35069.invoke(util.clj:115)”
“sync.util$with_db_logging_disabled$fn__35066.invoke(util.clj:106)”
“sync.util$with_start_and_finish_logging$fn__35061.invoke(util.clj:92)”
“sync.util$with_sync_events$fn__35058.invoke(util.clj:75)”
“sync.util$with_duplicate_ops_prevented$fn__35049.invoke(util.clj:54)”
“sync.util$do_sync_operation.invokeStatic(util.clj:142)”
“sync.util$do_sync_operation.invoke(util.clj:139)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556$fn__37557.invoke(sync_metadata.clj:23)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556.invoke(sync_metadata.clj:20)”
“task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:36)”)

Jul 23 15:50:01 ERROR metabase.sync.util :: Error syncing fields for Table 3 ‘PUBLIC.PEOPLE’: Output of table-metadata does not match schema:

{:fields #{{:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/BigInteger))} {:base-type (not (“Valid field type” :type/Float))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/Float))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/DateTime))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/Date))} {:base-type (not (“Valid field type” :type/Text))}}}

(“sync.fetch_metadata$fn__36355$table_metadata__36360.invoke(fetch_metadata.clj:15)”
“sync.sync_metadata.fields$fn__36916$db_metadata__36921$fn__36922.invoke(fields.clj:294)”
“sync.sync_metadata.fields$fn__36916$db_metadata__36921.invoke(fields.clj:290)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953$fn__36956$fn__36957.invoke(fields.clj:307)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953$fn__36956.invoke(fields.clj:306)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953.invoke(fields.clj:301)”
“sync.sync_metadata.fields$fn__36982$sync_fields_BANG___36987$fn__36988.invoke(fields.clj:318)”
“sync.sync_metadata.fields$fn__36982$sync_fields_BANG___36987.invoke(fields.clj:314)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556$fn__37557$fn__37558.invoke(sync_metadata.clj:28)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:122)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“driver$fn__25838.invokeStatic(driver.clj:235)”
“driver$fn__25838.invoke(driver.clj:235)”
“driver$fn__25773$G__25580__25782.invoke(driver.clj:51)”
“sync.util$sync_in_context$fn__35069.invoke(util.clj:115)”
“sync.util$with_db_logging_disabled$fn__35066.invoke(util.clj:106)”
“sync.util$with_start_and_finish_logging$fn__35061.invoke(util.clj:92)”
“sync.util$with_sync_events$fn__35058.invoke(util.clj:75)”
“sync.util$with_duplicate_ops_prevented$fn__35049.invoke(util.clj:54)”
“sync.util$do_sync_operation.invokeStatic(util.clj:142)”
“sync.util$do_sync_operation.invoke(util.clj:139)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556$fn__37557.invoke(sync_metadata.clj:23)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556.invoke(sync_metadata.clj:20)”
“task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:36)”)

Jul 23 15:50:02 ERROR metabase.sync.util :: Error syncing fields for Table 2 ‘PUBLIC.ORDERS’: Output of table-metadata does not match schema:

{:fields #{{:base-type (not (“Valid field type” :type/Float))} {:base-type (not (“Valid field type” :type/DateTime))} {:base-type (not (“Valid field type” :type/Integer))} {:base-type (not (“Valid field type” :type/Float))} {:base-type (not (“Valid field type” :type/Float))} {:base-type (not (“Valid field type” :type/BigInteger))} {:base-type (not (“Valid field type” :type/Integer))} {:base-type (not (“Valid field type” :type/Integer))} {:base-type (not (“Valid field type” :type/Float))}}}

(“sync.fetch_metadata$fn__36355$table_metadata__36360.invoke(fetch_metadata.clj:15)”
“sync.sync_metadata.fields$fn__36916$db_metadata__36921$fn__36922.invoke(fields.clj:294)”
“sync.sync_metadata.fields$fn__36916$db_metadata__36921.invoke(fields.clj:290)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953$fn__36956$fn__36957.invoke(fields.clj:307)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953$fn__36956.invoke(fields.clj:306)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953.invoke(fields.clj:301)”
“sync.sync_metadata.fields$fn__36982$sync_fields_BANG___36987$fn__36988.invoke(fields.clj:318)”
“sync.sync_metadata.fields$fn__36982$sync_fields_BANG___36987.invoke(fields.clj:314)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556$fn__37557$fn__37558.invoke(sync_metadata.clj:28)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:122)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“driver$fn__25838.invokeStatic(driver.clj:235)”
“driver$fn__25838.invoke(driver.clj:235)”
“driver$fn__25773$G__25580__25782.invoke(driver.clj:51)”
“sync.util$sync_in_context$fn__35069.invoke(util.clj:115)”
“sync.util$with_db_logging_disabled$fn__35066.invoke(util.clj:106)”
“sync.util$with_start_and_finish_logging$fn__35061.invoke(util.clj:92)”
“sync.util$with_sync_events$fn__35058.invoke(util.clj:75)”
“sync.util$with_duplicate_ops_prevented$fn__35049.invoke(util.clj:54)”
“sync.util$do_sync_operation.invokeStatic(util.clj:142)”
“sync.util$do_sync_operation.invoke(util.clj:139)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556$fn__37557.invoke(sync_metadata.clj:23)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556.invoke(sync_metadata.clj:20)”
“task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:36)”)

Jul 23 15:50:02 ERROR metabase.sync.util :: Error syncing fields for Table 1 ‘PUBLIC.PRODUCTS’: Output of table-metadata does not match schema:

{:fields #{{:base-type (not (“Valid field type” :type/DateTime))} {:base-type (not (“Valid field type” :type/BigInteger))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/Float))} {:base-type (not (“Valid field type” :type/Text))} {:base-type (not (“Valid field type” :type/Float))}}}

(“sync.fetch_metadata$fn__36355$table_metadata__36360.invoke(fetch_metadata.clj:15)”
“sync.sync_metadata.fields$fn__36916$db_metadata__36921$fn__36922.invoke(fields.clj:294)”
“sync.sync_metadata.fields$fn__36916$db_metadata__36921.invoke(fields.clj:290)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953$fn__36956$fn__36957.invoke(fields.clj:307)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953$fn__36956.invoke(fields.clj:306)”
“sync.sync_metadata.fields$fn__36944$sync_fields_for_table_BANG___36953.invoke(fields.clj:301)”
“sync.sync_metadata.fields$fn__36982$sync_fields_BANG___36987$fn__36988.invoke(fields.clj:318)”
“sync.sync_metadata.fields$fn__36982$sync_fields_BANG___36987.invoke(fields.clj:314)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556$fn__37557$fn__37558.invoke(sync_metadata.clj:28)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:122)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“driver$fn__25838.invokeStatic(driver.clj:235)”
“driver$fn__25838.invoke(driver.clj:235)”
“driver$fn__25773$G__25580__25782.invoke(driver.clj:51)”
“sync.util$sync_in_context$fn__35069.invoke(util.clj:115)”
“sync.util$with_db_logging_disabled$fn__35066.invoke(util.clj:106)”
“sync.util$with_start_and_finish_logging$fn__35061.invoke(util.clj:92)”
“sync.util$with_sync_events$fn__35058.invoke(util.clj:75)”
“sync.util$with_duplicate_ops_prevented$fn__35049.invoke(util.clj:54)”
“sync.util$do_sync_operation.invokeStatic(util.clj:142)”
“sync.util$do_sync_operation.invoke(util.clj:139)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556$fn__37557.invoke(sync_metadata.clj:23)”
“sync.sync_metadata$fn__37551$sync_db_metadata_BANG___37556.invoke(sync_metadata.clj:20)”
“task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:36)”)

Jul 23 15:50:04 INFO metabase.sync.util :: FINISHED: Sync metadata for h2 Database 1 ‘Sample Dataset’ (4 s)
Jul 23 15:50:04 DEBUG metabase.sync.util :: Sync operations in flight: {:analyze #{1}}
Jul 23 15:50:04 INFO metabase.sync.util :: STARTING: Analyze data for h2 Database 1 ‘Sample Dataset’
Jul 23 15:50:04 ERROR metabase.query-processor.middleware.results-metadata :: Error recording results metadata for query: Output of results->column-metadata does not match schema:

(named [{:base_type (not (“Valid field type (keyword or string)” :type/Integer)), :special_type (not (“Valid field type (keyword or string)” :type/Number))}] “Valid array of results column metadata maps”)

[“query_processor.middleware.results_metadata$fn__31302$results__GT_column_metadata__31307.invoke(results_metadata.clj:36)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__31340.invoke(results_metadata.clj:91)”
“query_processor.middleware.resolve$resolve_middleware$fn__28067.invoke(resolve.clj:424)”
“query_processor.middleware.expand$expand_middleware$fn__29767.invoke(expand.clj:601)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__28151.invoke(add_row_count_and_status.clj:14)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__29898.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__31351.invoke(resolve_driver.clj:15)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__28619.invoke(cache.clj:146)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__29815.invoke(catch_exceptions.clj:58)”
“query_processor$process_query.invokeStatic(query_processor.clj:130)”
“query_processor$process_query.invoke(query_processor.clj:126)”
“db.metadata_queries$qp_query$fn__34385.invoke(metadata_queries.clj:17)”
“db.metadata_queries$qp_query.invokeStatic(metadata_queries.clj:16)”
“db.metadata_queries$qp_query.invoke(metadata_queries.clj:14)”
“db.metadata_queries$table_row_count.invokeStatic(metadata_queries.clj:37)”
“db.metadata_queries$table_row_count.invoke(metadata_queries.clj:32)”
“sync.analyze.table_row_count$fn__36069$table_row_count__36074$fn__36075$fn__36076.invoke(table_row_count.clj:17)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.analyze.table_row_count$fn__36069$table_row_count__36074$fn__36075.invoke(table_row_count.clj:16)”
“sync.analyze.table_row_count$fn__36069$table_row_count__36074.invoke(table_row_count.clj:13)”
“sync.analyze.table_row_count$fn__36094$update_row_count_BANG___36099$fn__36100$fn__36101.invoke(table_row_count.clj:23)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.analyze.table_row_count$fn__36094$update_row_count_BANG___36099$fn__36100.invoke(table_row_count.clj:22)”
“sync.analyze.table_row_count$fn__36094$update_row_count_BANG___36099.invoke(table_row_count.clj:19)”
“sync.analyze$fn__36146$analyze_table_BANG___36151$fn__36152.invoke(analyze.clj:71)”
“sync.analyze$fn__36146$analyze_table_BANG___36151.invoke(analyze.clj:68)”
“sync.analyze$fn__36169$analyze_db_BANG___36174$fn__36175$fn__36176.invoke(analyze.clj:86)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:122)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“driver$fn__25838.invokeStatic(driver.clj:235)”
“driver$fn__25838.invoke(driver.clj:235)”
“driver$fn__25773$G__25580__25782.invoke(driver.clj:51)”
“sync.util$sync_in_context$fn__35069.invoke(util.clj:115)”
“sync.util$with_db_logging_disabled$fn__35066.invoke(util.clj:106)”
“sync.util$with_start_and_finish_logging$fn__35061.invoke(util.clj:92)”
“sync.util$with_sync_events$fn__35058.invoke(util.clj:75)”
“sync.util$with_duplicate_ops_prevented$fn__35049.invoke(util.clj:54)”
“sync.util$do_sync_operation.invokeStatic(util.clj:142)”
“sync.util$do_sync_operation.invoke(util.clj:139)”
“sync.analyze$fn__36169$analyze_db_BANG___36174$fn__36175.invoke(analyze.clj:82)”
“sync.analyze$fn__36169$analyze_db_BANG___36174.invoke(analyze.clj:77)”
“task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:39)”]

Jul 23 15:50:04 DEBUG metabase.sync.analyze.table-row-count :: Set table row count for Table 4 ‘PUBLIC.REVIEWS’ to 984
Jul 23 15:50:04 INFO metabase.sync.analyze :: [************······································] :unamused: 25% Analyzed Table 4 ‘PUBLIC.REVIEWS’
Jul 23 15:50:05 ERROR metabase.query-processor.middleware.results-metadata :: Error recording results metadata for query: Output of results->column-metadata does not match schema:

(named [{:base_type (not (“Valid field type (keyword or string)” :type/Integer)), :special_type (not (“Valid field type (keyword or string)” :type/Number))}] “Valid array of results column metadata maps”)

[“query_processor.middleware.results_metadata$fn__31302$results__GT_column_metadata__31307.invoke(results_metadata.clj:36)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__31340.invoke(results_metadata.clj:91)”
“query_processor.middleware.resolve$resolve_middleware$fn__28067.invoke(resolve.clj:424)”
“query_processor.middleware.expand$expand_middleware$fn__29767.invoke(expand.clj:601)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__28151.invoke(add_row_count_and_status.clj:14)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__29898.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__31351.invoke(resolve_driver.clj:15)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__28619.invoke(cache.clj:146)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__29815.invoke(catch_exceptions.clj:58)”
“query_processor$process_query.invokeStatic(query_processor.clj:130)”
“query_processor$process_query.invoke(query_processor.clj:126)”
“db.metadata_queries$qp_query$fn__34385.invoke(metadata_queries.clj:17)”
“db.metadata_queries$qp_query.invokeStatic(metadata_queries.clj:16)”
“db.metadata_queries$qp_query.invoke(metadata_queries.clj:14)”
“db.metadata_queries$table_row_count.invokeStatic(metadata_queries.clj:37)”
“db.metadata_queries$table_row_count.invoke(metadata_queries.clj:32)”
“sync.analyze.table_row_count$fn__36069$table_row_count__36074$fn__36075$fn__36076.invoke(table_row_count.clj:17)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.analyze.table_row_count$fn__36069$table_row_count__36074$fn__36075.invoke(table_row_count.clj:16)”
“sync.analyze.table_row_count$fn__36069$table_row_count__36074.invoke(table_row_count.clj:13)”
“sync.analyze.table_row_count$fn__36094$update_row_count_BANG___36099$fn__36100$fn__36101.invoke(table_row_count.clj:23)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.analyze.table_row_count$fn__36094$update_row_count_BANG___36099$fn__36100.invoke(table_row_count.clj:22)”
“sync.analyze.table_row_count$fn__36094$update_row_count_BANG___36099.invoke(table_row_count.clj:19)”
“sync.analyze$fn__36146$analyze_table_BANG___36151$fn__36152.invoke(analyze.clj:71)”
“sync.analyze$fn__36146$analyze_table_BANG___36151.invoke(analyze.clj:68)”
“sync.analyze$fn__36169$analyze_db_BANG___36174$fn__36175$fn__36176.invoke(analyze.clj:86)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:122)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“driver$fn__25838.invokeStatic(driver.clj:235)”
“driver$fn__25838.invoke(driver.clj:235)”
“driver$fn__25773$G__25580__25782.invoke(driver.clj:51)”
“sync.util$sync_in_context$fn__35069.invoke(util.clj:115)”
“sync.util$with_db_logging_disabled$fn__35066.invoke(util.clj:106)”
“sync.util$with_start_and_finish_logging$fn__35061.invoke(util.clj:92)”
“sync.util$with_sync_events$fn__35058.invoke(util.clj:75)”
“sync.util$with_duplicate_ops_prevented$fn__35049.invoke(util.clj:54)”
“sync.util$do_sync_operation.invokeStatic(util.clj:142)”
“sync.util$do_sync_operation.invoke(util.clj:139)”
“sync.analyze$fn__36169$analyze_db_BANG___36174$fn__36175.invoke(analyze.clj:82)”
“sync.analyze$fn__36169$analyze_db_BANG___36174.invoke(analyze.clj:77)”
“task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:39)”]

Jul 23 15:50:05 DEBUG metabase.sync.analyze.table-row-count :: Set table row count for Table 3 ‘PUBLIC.PEOPLE’ to 2500
Jul 23 15:50:05 INFO metabase.sync.analyze :: [*************************·························] :grimacing: 50% Analyzed Table 3 ‘PUBLIC.PEOPLE’
Jul 23 15:50:06 ERROR metabase.query-processor.middleware.results-metadata :: Error recording results metadata for query: Output of results->column-metadata does not match schema:

(named [{:base_type (not (“Valid field type (keyword or string)” :type/Integer)), :special_type (not (“Valid field type (keyword or string)” :type/Number))}] “Valid array of results column metadata maps”)

[“query_processor.middleware.results_metadata$fn__31302$results__GT_column_metadata__31307.invoke(results_metadata.clj:36)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__31340.invoke(results_metadata.clj:91)”
“query_processor.middleware.resolve$resolve_middleware$fn__28067.invoke(resolve.clj:424)”
“query_processor.middleware.expand$expand_middleware$fn__29767.invoke(expand.clj:601)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__28151.invoke(add_row_count_and_status.clj:14)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__29898.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__31351.invoke(resolve_driver.clj:15)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__28619.invoke(cache.clj:146)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__29815.invoke(catch_exceptions.clj:58)”
“query_processor$process_query.invokeStatic(query_processor.clj:130)”
“query_processor$process_query.invoke(query_processor.clj:126)”
“db.metadata_queries$qp_query$fn__34385.invoke(metadata_queries.clj:17)”
“db.metadata_queries$qp_query.invokeStatic(metadata_queries.clj:16)”
“db.metadata_queries$qp_query.invoke(metadata_queries.clj:14)”
“db.metadata_queries$table_row_count.invokeStatic(metadata_queries.clj:37)”
“db.metadata_queries$table_row_count.invoke(metadata_queries.clj:32)”
“sync.analyze.table_row_count$fn__36069$table_row_count__36074$fn__36075$fn__36076.invoke(table_row_count.clj:17)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.analyze.table_row_count$fn__36069$table_row_count__36074$fn__36075.invoke(table_row_count.clj:16)”
“sync.analyze.table_row_count$fn__36069$table_row_count__36074.invoke(table_row_count.clj:13)”
“sync.analyze.table_row_count$fn__36094$update_row_count_BANG___36099$fn__36100$fn__36101.invoke(table_row_count.clj:23)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.analyze.table_row_count$fn__36094$update_row_count_BANG___36099$fn__36100.invoke(table_row_count.clj:22)”
“sync.analyze.table_row_count$fn__36094$update_row_count_BANG___36099.invoke(table_row_count.clj:19)”
“sync.analyze$fn__36146$analyze_table_BANG___36151$fn__36152.invoke(analyze.clj:71)”
“sync.analyze$fn__36146$analyze_table_BANG___36151.invoke(analyze.clj:68)”
“sync.analyze$fn__36169$analyze_db_BANG___36174$fn__36175$fn__36176.invoke(analyze.clj:86)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:124)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“sync.util$do_with_error_handling.invokeStatic(util.clj:122)”
“sync.util$do_with_error_handling.invoke(util.clj:119)”
“driver$fn__25838.invokeStatic(driver.clj:235)”
“driver$fn__25838.invoke(driver.clj:235)”

any help please ?