PostgreSQL errors in Docker container logs

Bug reports
1

We deployed Metabase with Docker in AWS EC2 and used AWS Aurora PostgreSQL Serverless v2 as a PostgreSQL. We use the ClickHouse driver. We observed the server got 502 Bad Gateway error and when I checked the Docker container logs we see these PostgreSQL errors.

What is the issue? Is it related to the ClickHouse community driver or PostgreSQL Serverless v2?

image
image3791×1458 518 KB
image
image3818×1544 550 KB
image
image3803×1688 597 KB
image
image3839×1753 569 KB
image
image3816×1683 584 KB
![image|690x315]

2

Hi @arash.layeghi
Which version of Metabase?
Try posting the logs instead of screenshots.
I don't know what "serverless" means in this context, but if it is one of AWS's new upsells, then perhaps it's not working with Metabase.

3

Hi @flamber,
I also tested with a non-serverless database. I mean with AWS Aurora PostgreSQL provisioned database.
But again I see these errors:

2022-05-05 09:13:21,723 WARN sync.util :: Error syncing Fields for Table 'Table 192 'INFORMATION_SCHEMA.VIEWS''
clojure.lang.ExceptionInfo: Output of table-metadata does not match schema:

       {:fields #{{:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))}}}

{:type :schema.core/error, :schema {:name (constrained Str "Non-blank string"), :schema (maybe (constrained Str "Non-blank string")), :fields #{{#schema.core.OptionalKey{:k :effective-type} (maybe (pred "Valid field type")), :base-type (pred "Valid field type"), Keyword Any, #schema.core.OptionalKey{:k :pk?} java.lang.Boolean, :name (constrained Str "Non-blank string"), #schema.core.OptionalKey{:k :field-comment} (maybe (constrained Str "Non-blank string")), #schema.core.OptionalKey{:k :custom} {Any Any}, :database-type (maybe (constrained Str "Non-blank string")), #schema.core.OptionalKey{:k :coercion-strategy} (maybe (pred "Valid coercion strategy")), #schema.core.OptionalKey{:k :nested-fields} #{(recursive (var metabase.sync.interface/TableMetadataField))}, #schema.core.OptionalKey{:k :semantic-type} (maybe (pred "Valid field semantic or relation type")), :database-position (constrained Int "Integer greater than or equal to zero")}}, #schema.core.OptionalKey{:k :description} (maybe (constrained Str "Non-blank string"))}, :value {:name "VIEWS", :schema "INFORMATION_SCHEMA", :fields #{{:name "view_definition", :database-type "String", :base-type :type/Text, :database-position 3} {:name "is_trigger_updatable", :database-type "Enum8", :base-type :type/Enum, :database-position 7} {:name "is_insertable_into", :database-type "Enum8", :base-type :type/Enum, :database-position 6} {:name "is_trigger_insertable_into", :database-type "Enum8", :base-type :type/Enum, :database-position 9} {:name "table_name", :database-type "String", :base-type :type/Text, :database-position 2} {:name "IS_TRIGGER_DELETABLE", :database-type "Enum8", :base-type :type/Enum, :database-position 18} {:name "CHECK_OPTION", :database-type "String", :base-type :type/Text, :database-position 14} {:name "IS_UPDATABLE", :database-type "Enum8", :base-type :type/Enum, :database-position 15} {:name "table_schema", :database-type "String", :base-type :type/Text, :database-position 1} {:name "TABLE_CATALOG", :database-type "String", :base-type :type/Text, :database-position 10} {:name "TABLE_NAME", :database-type "String", :base-type :type/Text, :database-position 12} {:name "IS_INSERTABLE_INTO", :database-type "Enum8", :base-type :type/Enum, :database-position 16} {:name "TABLE_SCHEMA", :database-type "String", :base-type :type/Text, :database-position 11} {:name "VIEW_DEFINITION", :database-type "String", :base-type :type/Text, :database-position 13} {:name "check_option", :database-type "String", :base-type :type/Text, :database-position 4} {:name "is_trigger_deletable", :database-type "Enum8", :base-type :type/Enum, :database-position 8} {:name "table_catalog", :database-type "String", :base-type :type/Text, :database-position 0} {:name "is_updatable", :database-type "Enum8", :base-type :type/Enum, :database-position 5} {:name "IS_TRIGGER_INSERTABLE_INTO", :database-type "Enum8", :base-type :type/Enum, :database-position 19} {:name "IS_TRIGGER_UPDATABLE", :database-type "Enum8", :base-type :type/Enum, :database-position 17}}}, :error {:fields #{{:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))}}}}
at metabase.sync.fetch_metadata$fn__63578$table_metadata__63583.invoke(fetch_metadata.clj:15)
at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63822$db_metadata__63827$fn__63828.invoke(fetch_metadata.clj:87)
at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63822$db_metadata__63827.invoke(fetch_metadata.clj:83)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329$fn__64330.invoke(fields.clj:72)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329.invoke(fields.clj:71)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326.invoke(fields.clj:65)
at clojure.core$partial$fn__5857.invoke(core.clj:2628)
at clojure.core$map$fn__5884.invoke(core.clj:2757)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5911.invoke(core.clj:2813)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.core$chunk_next.invokeStatic(core.clj:710)
at clojure.core$reduce1.invokeStatic(core.clj:944)
at clojure.core$reduce1.invokeStatic(core.clj:936)
at clojure.core$merge_with.invokeStatic(core.clj:3063)
at clojure.core$merge_with.doInvoke(core.clj:3055)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360$fn__64361.invoke(fields.clj:85)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360.invoke(fields.clj:77)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253$fn__38255.doInvoke(util.clj:388)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:117)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:114)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253.invoke(util.clj:383)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249.invoke(util.clj:378)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466$fn__38474.invoke(util.clj:489)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466.invoke(util.clj:487)
at metabase.sync.util$fn__38460$run_sync_operation__38465.invoke(util.clj:481)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855$fn__65856.invoke(sync_metadata.clj:50)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at clojure.core$partial$fn__5859.invoke(core.clj:2634)
at metabase.driver$fn__25940.invokeStatic(driver.clj:572)
at metabase.driver$fn__25940.invoke(driver.clj:572)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__38153.invoke(util.clj:136)
at metabase.sync.util$with_db_logging_disabled$fn__38150.invoke(util.clj:127)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_logging$fn__38139.invoke(util.clj:112)
at metabase.sync.util$with_sync_events$fn__38134.invoke(util.clj:86)
at metabase.sync.util$with_duplicate_ops_prevented$fn__38125.invoke(util.clj:65)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179)
at metabase.sync.util$do_sync_operation.invoke(util.clj:176)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855.invoke(sync_metadata.clj:49)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854.invoke(sync_metadata.clj:46)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:67)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:58)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:75)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
2022-05-05 09:13:27,262 WARN sync.util :: Error syncing Fields for Table 'Table 148 'information_schema.views''
clojure.lang.ExceptionInfo: Output of table-metadata does not match schema:

       {:fields #{{:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))}}}

{:type :schema.core/error, :schema {:name (constrained Str "Non-blank string"), :schema (maybe (constrained Str "Non-blank string")), :fields #{{#schema.core.OptionalKey{:k :effective-type} (maybe (pred "Valid field type")), :base-type (pred "Valid field type"), Keyword Any, #schema.core.OptionalKey{:k :pk?} java.lang.Boolean, :name (constrained Str "Non-blank string"), #schema.core.OptionalKey{:k :field-comment} (maybe (constrained Str "Non-blank string")), #schema.core.OptionalKey{:k :custom} {Any Any}, :database-type (maybe (constrained Str "Non-blank string")), #schema.core.OptionalKey{:k :coercion-strategy} (maybe (pred "Valid coercion strategy")), #schema.core.OptionalKey{:k :nested-fields} #{(recursive (var metabase.sync.interface/TableMetadataField))}, #schema.core.OptionalKey{:k :semantic-type} (maybe (pred "Valid field semantic or relation type")), :database-position (constrained Int "Integer greater than or equal to zero")}}, #schema.core.OptionalKey{:k :description} (maybe (constrained Str "Non-blank string"))}, :value {:name "views", :schema "information_schema", :fields #{{:name "view_definition", :database-type "String", :base-type :type/Text, :database-position 3} {:name "is_trigger_updatable", :database-type "Enum8", :base-type :type/Enum, :database-position 7} {:name "is_insertable_into", :database-type "Enum8", :base-type :type/Enum, :database-position 6} {:name "is_trigger_insertable_into", :database-type "Enum8", :base-type :type/Enum, :database-position 9} {:name "table_name", :database-type "String", :base-type :type/Text, :database-position 2} {:name "IS_TRIGGER_DELETABLE", :database-type "Enum8", :base-type :type/Enum, :database-position 18} {:name "CHECK_OPTION", :database-type "String", :base-type :type/Text, :database-position 14} {:name "IS_UPDATABLE", :database-type "Enum8", :base-type :type/Enum, :database-position 15} {:name "table_schema", :database-type "String", :base-type :type/Text, :database-position 1} {:name "TABLE_CATALOG", :database-type "String", :base-type :type/Text, :database-position 10} {:name "TABLE_NAME", :database-type "String", :base-type :type/Text, :database-position 12} {:name "IS_INSERTABLE_INTO", :database-type "Enum8", :base-type :type/Enum, :database-position 16} {:name "TABLE_SCHEMA", :database-type "String", :base-type :type/Text, :database-position 11} {:name "VIEW_DEFINITION", :database-type "String", :base-type :type/Text, :database-position 13} {:name "check_option", :database-type "String", :base-type :type/Text, :database-position 4} {:name "is_trigger_deletable", :database-type "Enum8", :base-type :type/Enum, :database-position 8} {:name "table_catalog", :database-type "String", :base-type :type/Text, :database-position 0} {:name "is_updatable", :database-type "Enum8", :base-type :type/Enum, :database-position 5} {:name "IS_TRIGGER_INSERTABLE_INTO", :database-type "Enum8", :base-type :type/Enum, :database-position 19} {:name "IS_TRIGGER_UPDATABLE", :database-type "Enum8", :base-type :type/Enum, :database-position 17}}}, :error {:fields #{{:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))}}}}
at metabase.sync.fetch_metadata$fn__63578$table_metadata__63583.invoke(fetch_metadata.clj:15)
at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63822$db_metadata__63827$fn__63828.invoke(fetch_metadata.clj:87)
at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63822$db_metadata__63827.invoke(fetch_metadata.clj:83)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329$fn__64330.invoke(fields.clj:72)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329.invoke(fields.clj:71)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326.invoke(fields.clj:65)
at clojure.core$partial$fn__5857.invoke(core.clj:2628)
at clojure.core$map$fn__5884.invoke(core.clj:2757)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5911.invoke(core.clj:2813)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.core$chunk_next.invokeStatic(core.clj:710)
at clojure.core$reduce1.invokeStatic(core.clj:944)
at clojure.core$reduce1.invokeStatic(core.clj:936)
at clojure.core$merge_with.invokeStatic(core.clj:3063)
at clojure.core$merge_with.doInvoke(core.clj:3055)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360$fn__64361.invoke(fields.clj:85)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360.invoke(fields.clj:77)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253$fn__38255.doInvoke(util.clj:388)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:117)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:114)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253.invoke(util.clj:383)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249.invoke(util.clj:378)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466$fn__38474.invoke(util.clj:489)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466.invoke(util.clj:487)
at metabase.sync.util$fn__38460$run_sync_operation__38465.invoke(util.clj:481)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855$fn__65856.invoke(sync_metadata.clj:50)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at clojure.core$partial$fn__5859.invoke(core.clj:2634)
at metabase.driver$fn__25940.invokeStatic(driver.clj:572)
at metabase.driver$fn__25940.invoke(driver.clj:572)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__38153.invoke(util.clj:136)
at metabase.sync.util$with_db_logging_disabled$fn__38150.invoke(util.clj:127)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_logging$fn__38139.invoke(util.clj:112)
at metabase.sync.util$with_sync_events$fn__38134.invoke(util.clj:86)
at metabase.sync.util$with_duplicate_ops_prevented$fn__38125.invoke(util.clj:65)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179)
at metabase.sync.util$do_sync_operation.invoke(util.clj:176)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855.invoke(sync_metadata.clj:49)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854.invoke(sync_metadata.clj:46)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:67)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:58)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:75)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
2022-05-05 09:13:27,749 WARN sync.util :: Error syncing Fields for Table 'Table 154 'information_schema.tables''
clojure.lang.ExceptionInfo: Output of table-metadata does not match schema:

       {:fields #{{:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))}}}

{:type :schema.core/error, :schema {:name (constrained Str "Non-blank string"), :schema (maybe (constrained Str "Non-blank string")), :fields #{{#schema.core.OptionalKey{:k :effective-type} (maybe (pred "Valid field type")), :base-type (pred "Valid field type"), Keyword Any, #schema.core.OptionalKey{:k :pk?} java.lang.Boolean, :name (constrained Str "Non-blank string"), #schema.core.OptionalKey{:k :field-comment} (maybe (constrained Str "Non-blank string")), #schema.core.OptionalKey{:k :custom} {Any Any}, :database-type (maybe (constrained Str "Non-blank string")), #schema.core.OptionalKey{:k :coercion-strategy} (maybe (pred "Valid coercion strategy")), #schema.core.OptionalKey{:k :nested-fields} #{(recursive (var metabase.sync.interface/TableMetadataField))}, #schema.core.OptionalKey{:k :semantic-type} (maybe (pred "Valid field semantic or relation type")), :database-position (constrained Int "Integer greater than or equal to zero")}}, #schema.core.OptionalKey{:k :description} (maybe (constrained Str "Non-blank string"))}, :value {:name "tables", :schema "information_schema", :fields #{{:name "table_name", :database-type "String", :base-type :type/Text, :database-position 2} {:name "TABLE_SCHEMA", :database-type "String", :base-type :type/Text, :database-position 5} {:name "TABLE_CATALOG", :database-type "String", :base-type :type/Text, :database-position 4} {:name "TABLE_NAME", :database-type "String", :base-type :type/Text, :database-position 6} {:name "table_schema", :database-type "String", :base-type :type/Text, :database-position 1} {:name "TABLE_TYPE", :database-type "Enum8", :base-type :type/Enum, :database-position 7} {:name "table_type", :database-type "Enum8", :base-type :type/Enum, :database-position 3} {:name "table_catalog", :database-type "String", :base-type :type/Text, :database-position 0}}}, :error {:fields #{{:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))}}}}
at metabase.sync.fetch_metadata$fn__63578$table_metadata__63583.invoke(fetch_metadata.clj:15)
at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63822$db_metadata__63827$fn__63828.invoke(fetch_metadata.clj:87)
at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63822$db_metadata__63827.invoke(fetch_metadata.clj:83)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329$fn__64330.invoke(fields.clj:72)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329.invoke(fields.clj:71)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326.invoke(fields.clj:65)
at clojure.core$partial$fn__5857.invoke(core.clj:2628)
at clojure.core$map$fn__5884.invoke(core.clj:2757)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5911.invoke(core.clj:2813)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.core$chunk_next.invokeStatic(core.clj:710)
at clojure.core$reduce1.invokeStatic(core.clj:944)
at clojure.core$reduce1.invokeStatic(core.clj:936)
at clojure.core$merge_with.invokeStatic(core.clj:3063)
at clojure.core$merge_with.doInvoke(core.clj:3055)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360$fn__64361.invoke(fields.clj:85)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360.invoke(fields.clj:77)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253$fn__38255.doInvoke(util.clj:388)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:117)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:114)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253.invoke(util.clj:383)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249.invoke(util.clj:378)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466$fn__38474.invoke(util.clj:489)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466.invoke(util.clj:487)
at metabase.sync.util$fn__38460$run_sync_operation__38465.invoke(util.clj:481)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855$fn__65856.invoke(sync_metadata.clj:50)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at clojure.core$partial$fn__5859.invoke(core.clj:2634)
at metabase.driver$fn__25940.invokeStatic(driver.clj:572)
at metabase.driver$fn__25940.invoke(driver.clj:572)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__38153.invoke(util.clj:136)
at metabase.sync.util$with_db_logging_disabled$fn__38150.invoke(util.clj:127)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_logging$fn__38139.invoke(util.clj:112)
at metabase.sync.util$with_sync_events$fn__38134.invoke(util.clj:86)
at metabase.sync.util$with_duplicate_ops_prevented$fn__38125.invoke(util.clj:65)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179)
at metabase.sync.util$do_sync_operation.invoke(util.clj:176)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855.invoke(sync_metadata.clj:49)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854.invoke(sync_metadata.clj:46)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:67)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:58)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:75)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
2022-05-05 09:13:55,144 INFO fields.sync-metadata :: Database position of Table 341 'information_schema.columns' Field 'CHARACTER_SET_SCHEMA' has changed from '40' to '15'.
2022-05-05 09:13:55,145 INFO fields.sync-metadata :: Name of Table 341 'information_schema.columns' Field 'CHARACTER_SET_SCHEMA' has changed from 'CHARACTER_SET_SCHEMA' to 'character_set_schema'.
2022-05-05 09:13:55,153 WARN sync.util :: Error syncing Fields for Table 'Table 341 'information_schema.columns''
java.sql.BatchUpdateException: Batch entry 0 UPDATE "metabase_field" SET "database_position" = 15, "name" = 'character_set_schema', "updated_at" = now() WHERE "id" = 9382 was aborted: ERROR: duplicate key value violates unique constraint "idx_uniq_field_table_id_parent_id_name_2col"
Detail: Key (table_id, name)=(341, character_set_schema) already exists. Call getNextException to see other errors in the batch.
at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:169)
at org.postgresql.core.ResultHandlerDelegate.handleError(ResultHandlerDelegate.java:52)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:520)
at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:878)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:901)
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1644)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)
at clojure.java.jdbc$execute_batch.invokeStatic(jdbc.clj:598)
at clojure.java.jdbc$execute_batch.invoke(jdbc.clj:591)
at clojure.java.jdbc$db_do_execute_prepared_statement$fn__20623.invoke(jdbc.clj:1057)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:807)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_do_execute_prepared_statement.invokeStatic(jdbc.clj:1056)
at clojure.java.jdbc$db_do_execute_prepared_statement.invoke(jdbc.clj:1042)
at clojure.java.jdbc$db_do_prepared.invokeStatic(jdbc.clj:1080)
at clojure.java.jdbc$db_do_prepared.invoke(jdbc.clj:1060)
at clojure.java.jdbc$execute_BANG_$execute_helper__20691.invoke(jdbc.clj:1464)
at clojure.java.jdbc$execute_BANG_.invokeStatic(jdbc.clj:1468)
at clojure.java.jdbc$execute_BANG_.invoke(jdbc.clj:1435)
at toucan.db$execute_BANG_.invokeStatic(db.clj:427)
at toucan.db$execute_BANG_.doInvoke(db.clj:422)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at toucan.db$update_BANG_.invokeStatic(db.clj:482)
at toucan.db$update_BANG_.invoke(db.clj:471)
at toucan.db$update_BANG_.invokeStatic(db.clj:491)
at toucan.db$update_BANG_.invoke(db.clj:471)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__64183$update_field_metadata_if_needed_BANG___64188$fn__64189.invoke(sync_metadata.clj:96)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__64183$update_field_metadata_if_needed_BANG___64188.invoke(sync_metadata.clj:17)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__64245$update_metadata_BANG___64250$fn__64251$iter__64252__64256$fn__64257.invoke(sync_metadata.clj:121)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5911.invoke(core.clj:2813)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:24)
at clojure.core.protocols$fn__8168.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8168.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8110$G__8105__8123.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6826)
at clojure.core$reduce.invoke(core.clj:6812)
at metabase.sync.util$sum_for_STAR_.invokeStatic(util.clj:515)
at metabase.sync.util$sum_for_STAR_.invoke(util.clj:512)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__64245$update_metadata_BANG___64250$fn__64251.invoke(sync_metadata.clj:117)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__64245$update_metadata_BANG___64250.invoke(sync_metadata.clj:111)
at metabase.sync.sync_metadata.fields$fn__64289$sync_and_update_BANG___64294$fn__64295.invoke(fields.clj:63)
at metabase.sync.sync_metadata.fields$fn__64289$sync_and_update_BANG___64294.invoke(fields.clj:55)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329$fn__64330.invoke(fields.clj:74)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329.invoke(fields.clj:71)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326.invoke(fields.clj:65)
at clojure.core$partial$fn__5857.invoke(core.clj:2628)
at clojure.core$map$fn__5884.invoke(core.clj:2757)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5911.invoke(core.clj:2813)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.core$chunk_next.invokeStatic(core.clj:710)
at clojure.core$reduce1.invokeStatic(core.clj:944)
at clojure.core$reduce1.invokeStatic(core.clj:936)
at clojure.core$merge_with.invokeStatic(core.clj:3063)
at clojure.core$merge_with.doInvoke(core.clj:3055)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360$fn__64361.invoke(fields.clj:85)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360.invoke(fields.clj:77)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253$fn__38255.doInvoke(util.clj:388)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:117)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:114)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253.invoke(util.clj:383)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249.invoke(util.clj:378)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466$fn__38474.invoke(util.clj:489)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466.invoke(util.clj:487)
at metabase.sync.util$fn__38460$run_sync_operation__38465.invoke(util.clj:481)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855$fn__65856.invoke(sync_metadata.clj:50)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at clojure.core$partial$fn__5859.invoke(core.clj:2634)
at metabase.driver$fn__25940.invokeStatic(driver.clj:572)
at metabase.driver$fn__25940.invoke(driver.clj:572)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__38153.invoke(util.clj:136)
at metabase.sync.util$with_db_logging_disabled$fn__38150.invoke(util.clj:127)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_logging$fn__38139.invoke(util.clj:112)
at metabase.sync.util$with_sync_events$fn__38134.invoke(util.clj:86)
at metabase.sync.util$with_duplicate_ops_prevented$fn__38125.invoke(util.clj:65)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179)
at metabase.sync.util$do_sync_operation.invoke(util.clj:176)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855.invoke(sync_metadata.clj:49)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854.invoke(sync_metadata.clj:46)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:67)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:58)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:75)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_uniq_field_table_id_parent_id_name_2col"
Detail: Key (table_id, name)=(341, character_set_schema) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2552)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2284)
... 113 more
2022-05-05 09:14:01,821 WARN sync.util :: Error syncing Fields for Table 'Table 386 'INFORMATION_SCHEMA.TABLES''
clojure.lang.ExceptionInfo: Output of table-metadata does not match schema:

       {:fields #{{:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))}}}

{:type :schema.core/error, :schema {:name (constrained Str "Non-blank string"), :schema (maybe (constrained Str "Non-blank string")), :fields #{{#schema.core.OptionalKey{:k :effective-type} (maybe (pred "Valid field type")), :base-type (pred "Valid field type"), Keyword Any, #schema.core.OptionalKey{:k :pk?} java.lang.Boolean, :name (constrained Str "Non-blank string"), #schema.core.OptionalKey{:k :field-comment} (maybe (constrained Str "Non-blank string")), #schema.core.OptionalKey{:k :custom} {Any Any}, :database-type (maybe (constrained Str "Non-blank string")), #schema.core.OptionalKey{:k :coercion-strategy} (maybe (pred "Valid coercion strategy")), #schema.core.OptionalKey{:k :nested-fields} #{(recursive (var metabase.sync.interface/TableMetadataField))}, #schema.core.OptionalKey{:k :semantic-type} (maybe (pred "Valid field semantic or relation type")), :database-position (constrained Int "Integer greater than or equal to zero")}}, #schema.core.OptionalKey{:k :description} (maybe (constrained Str "Non-blank string"))}, :value {:name "TABLES", :schema "INFORMATION_SCHEMA", :fields #{{:name "table_name", :database-type "String", :base-type :type/Text, :database-position 2} {:name "TABLE_SCHEMA", :database-type "String", :base-type :type/Text, :database-position 5} {:name "TABLE_CATALOG", :database-type "String", :base-type :type/Text, :database-position 4} {:name "TABLE_NAME", :database-type "String", :base-type :type/Text, :database-position 6} {:name "table_schema", :database-type "String", :base-type :type/Text, :database-position 1} {:name "TABLE_TYPE", :database-type "Enum8", :base-type :type/Enum, :database-position 7} {:name "table_type", :database-type "Enum8", :base-type :type/Enum, :database-position 3} {:name "table_catalog", :database-type "String", :base-type :type/Text, :database-position 0}}}, :error {:fields #{{:base-type (not ("Valid field type" :type/Enum))} {:base-type (not ("Valid field type" :type/Enum))}}}}
at metabase.sync.fetch_metadata$fn__63578$table_metadata__63583.invoke(fetch_metadata.clj:15)
at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63822$db_metadata__63827$fn__63828.invoke(fetch_metadata.clj:87)
at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63822$db_metadata__63827.invoke(fetch_metadata.clj:83)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329$fn__64330.invoke(fields.clj:72)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329.invoke(fields.clj:71)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326.invoke(fields.clj:65)
at clojure.core$partial$fn__5857.invoke(core.clj:2628)
at clojure.core$map$fn__5884.invoke(core.clj:2757)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5911.invoke(core.clj:2813)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.core$chunk_next.invokeStatic(core.clj:710)
at clojure.core$reduce1.invokeStatic(core.clj:944)
at clojure.core$reduce1.invokeStatic(core.clj:936)
at clojure.core$merge_with.invokeStatic(core.clj:3063)
at clojure.core$merge_with.doInvoke(core.clj:3055)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360$fn__64361.invoke(fields.clj:85)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360.invoke(fields.clj:77)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253$fn__38255.doInvoke(util.clj:388)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:117)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:114)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253.invoke(util.clj:383)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249.invoke(util.clj:378)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466$fn__38474.invoke(util.clj:489)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466.invoke(util.clj:487)
at metabase.sync.util$fn__38460$run_sync_operation__38465.invoke(util.clj:481)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855$fn__65856.invoke(sync_metadata.clj:50)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at clojure.core$partial$fn__5859.invoke(core.clj:2634)
at metabase.driver$fn__25940.invokeStatic(driver.clj:572)
at metabase.driver$fn__25940.invoke(driver.clj:572)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__38153.invoke(util.clj:136)
at metabase.sync.util$with_db_logging_disabled$fn__38150.invoke(util.clj:127)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_logging$fn__38139.invoke(util.clj:112)
at metabase.sync.util$with_sync_events$fn__38134.invoke(util.clj:86)
at metabase.sync.util$with_duplicate_ops_prevented$fn__38125.invoke(util.clj:65)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179)
at metabase.sync.util$do_sync_operation.invoke(util.clj:176)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855.invoke(sync_metadata.clj:49)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854.invoke(sync_metadata.clj:46)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:67)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:58)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:75)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
2022-05-05 09:14:14,738 INFO fields.sync-metadata :: Database position of Table 440 'information_schema.schemata' Field 'default_character_set_name' has changed from '5' to '12'.
2022-05-05 09:14:14,739 INFO fields.sync-metadata :: Name of Table 440 'information_schema.schemata' Field 'default_character_set_name' has changed from 'default_character_set_name' to 'DEFAULT_CHARACTER_SET_NAME'.
2022-05-05 09:14:14,745 WARN sync.util :: Error syncing Fields for Table 'Table 440 'information_schema.schemata''
java.sql.BatchUpdateException: Batch entry 0 UPDATE "metabase_field" SET "database_position" = 12, "name" = 'DEFAULT_CHARACTER_SET_NAME', "updated_at" = now() WHERE "id" = 13125 was aborted: ERROR: duplicate key value violates unique constraint "idx_uniq_field_table_id_parent_id_name_2col"
Detail: Key (table_id, name)=(440, DEFAULT_CHARACTER_SET_NAME) already exists. Call getNextException to see other errors in the batch.
at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:169)
at org.postgresql.core.ResultHandlerDelegate.handleError(ResultHandlerDelegate.java:52)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:520)
at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:878)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:901)
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1644)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)
at clojure.java.jdbc$execute_batch.invokeStatic(jdbc.clj:598)
at clojure.java.jdbc$execute_batch.invoke(jdbc.clj:591)
at clojure.java.jdbc$db_do_execute_prepared_statement$fn__20623.invoke(jdbc.clj:1057)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:807)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_do_execute_prepared_statement.invokeStatic(jdbc.clj:1056)
at clojure.java.jdbc$db_do_execute_prepared_statement.invoke(jdbc.clj:1042)
at clojure.java.jdbc$db_do_prepared.invokeStatic(jdbc.clj:1080)
at clojure.java.jdbc$db_do_prepared.invoke(jdbc.clj:1060)
at clojure.java.jdbc$execute_BANG_$execute_helper__20691.invoke(jdbc.clj:1464)
at clojure.java.jdbc$execute_BANG_.invokeStatic(jdbc.clj:1468)
at clojure.java.jdbc$execute_BANG_.invoke(jdbc.clj:1435)
at toucan.db$execute_BANG_.invokeStatic(db.clj:427)
at toucan.db$execute_BANG_.doInvoke(db.clj:422)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at toucan.db$update_BANG_.invokeStatic(db.clj:482)
at toucan.db$update_BANG_.invoke(db.clj:471)
at toucan.db$update_BANG_.invokeStatic(db.clj:491)
at toucan.db$update_BANG_.invoke(db.clj:471)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__64183$update_field_metadata_if_needed_BANG___64188$fn__64189.invoke(sync_metadata.clj:96)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__64183$update_field_metadata_if_needed_BANG___64188.invoke(sync_metadata.clj:17)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__64245$update_metadata_BANG___64250$fn__64251$iter__64252__64256$fn__64257.invoke(sync_metadata.clj:121)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5911.invoke(core.clj:2813)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:24)
at clojure.core.protocols$fn__8168.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8168.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8110$G__8105__8123.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6826)
at clojure.core$reduce.invoke(core.clj:6812)
at metabase.sync.util$sum_for_STAR_.invokeStatic(util.clj:515)
at metabase.sync.util$sum_for_STAR_.invoke(util.clj:512)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__64245$update_metadata_BANG___64250$fn__64251.invoke(sync_metadata.clj:117)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__64245$update_metadata_BANG___64250.invoke(sync_metadata.clj:111)
at metabase.sync.sync_metadata.fields$fn__64289$sync_and_update_BANG___64294$fn__64295.invoke(fields.clj:63)
at metabase.sync.sync_metadata.fields$fn__64289$sync_and_update_BANG___64294.invoke(fields.clj:55)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329$fn__64330.invoke(fields.clj:74)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326$fn__64329.invoke(fields.clj:71)
at metabase.sync.sync_metadata.fields$fn__64317$sync_fields_for_table_BANG___64326.invoke(fields.clj:65)
at clojure.core$partial$fn__5857.invoke(core.clj:2628)
at clojure.core$map$fn__5884.invoke(core.clj:2757)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5911.invoke(core.clj:2813)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.core$chunk_next.invokeStatic(core.clj:710)
at clojure.core$reduce1.invokeStatic(core.clj:944)
at clojure.core$reduce1.invokeStatic(core.clj:936)
at clojure.core$merge_with.invokeStatic(core.clj:3063)
at clojure.core$merge_with.doInvoke(core.clj:3055)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360$fn__64361.invoke(fields.clj:85)
at metabase.sync.sync_metadata.fields$fn__64355$sync_fields_BANG___64360.invoke(fields.clj:77)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253$fn__38255.doInvoke(util.clj:388)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:117)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:114)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249$fn__38253.invoke(util.clj:383)
at metabase.sync.util$fn__38244$run_step_with_metadata__38249.invoke(util.clj:378)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466$fn__38474.invoke(util.clj:489)
at metabase.sync.util$fn__38460$run_sync_operation__38465$fn__38466.invoke(util.clj:487)
at metabase.sync.util$fn__38460$run_sync_operation__38465.invoke(util.clj:481)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855$fn__65856.invoke(sync_metadata.clj:50)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at clojure.core$partial$fn__5859.invoke(core.clj:2634)
at metabase.driver$fn__25940.invokeStatic(driver.clj:572)
at metabase.driver$fn__25940.invoke(driver.clj:572)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__38153.invoke(util.clj:136)
at metabase.sync.util$with_db_logging_disabled$fn__38150.invoke(util.clj:127)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_logging$fn__38139.invoke(util.clj:112)
at metabase.sync.util$with_sync_events$fn__38134.invoke(util.clj:86)
at metabase.sync.util$with_duplicate_ops_prevented$fn__38125.invoke(util.clj:65)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179)
at metabase.sync.util$do_sync_operation.invoke(util.clj:176)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854$fn__65855.invoke(sync_metadata.clj:49)
at metabase.sync.sync_metadata$fn__65849$sync_db_metadata_BANG___65854.invoke(sync_metadata.clj:46)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:67)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:58)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:75)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_uniq_field_table_id_parent_id_name_2col"
Detail: Key (table_id, name)=(440, DEFAULT_CHARACTER_SET_NAME) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2552)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2284)
... 113 more
2022-05-05 09:14:19,618 INFO fields.sync-metadata :: Database position of Table 501 'INFORMATION_SCHEMA.SCHEMATA' Field 'sql_path' has changed from '6' to '13'.
2022-05-05 09:14:19,619 INFO fields.sync-metadata :: Name of Table 501 'INFORMATION_SCHEMA.SCHEMATA' Field 'sql_path' has changed from 'sql_path' to 'SQL_PATH'.
2022-05-05 09:14:19,625 WARN sync.util :: Error syncing Fields for Table 'Table 501 'INFORMATION_SCHEMA.SCHEMATA''
java.sql.BatchUpdateException: Batch entry 0 UPDATE "metabase_field" SET "database_position" = 13, "name" = 'SQL_PATH', "updated_at" = now() WHERE "id" = 13774 was aborted: ERROR: duplicate key value violates unique constraint "idx_uniq_field_table_id_parent_id_name_2col"
Detail: Key (table_id, name)=(501, SQL_PATH) already exists. Call getNextException to see other errors in the batch.
at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:169)
at org.postgresql.core.ResultHandlerDelegate.handleError(ResultHandlerDelegate.java:52)

4

@arash.layeghi You have a corruption somewhere, which might have been caused by the driver. I don't know. Revert to your backup.
https://github.com/metabase/metabase/issues?q=is%3Aissue+is%3Aopen+"idx_uniq_field_table_id_parent_id_name_2col"

5

@flamber, But I dropped the database and created a fresh empty database, but this happens again after a little working with Metabase.

6

@arash.layeghi

  1. Post "Diagnostic Info" from Admin > Troubleshooting
  2. I don't know which data source this problem is coming from, but try not adding that database, so you can understand what is actually triggering the problem.
7

The details are in this post:
https://discourse.metabase.com/t/postgresql-errors-in-docker-container-logs/19924

{
  "browser-info": {
    "language": "en-US",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.14.1+1",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.14.1",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.14.1+1",
    "os.name": "Linux",
    "os.version": "5.10.102-99.473.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "clickhouse",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "13.6"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.23"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-04-07",
      "tag": "v1.42.4",
      "branch": "release-x.42.x",
      "hash": "7c3ce2d"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
8

@arash.layeghi Do a new setup. Do not add Clickhouse database. If it works, then it seems like it's caused by the Clickhouse driver during sync.

And if you are a Pro/Enterprise customer, then please use the support email.