Here is the full startup log after we did the new setup from scratch.
Warning: protocol #'java-time.core/Amount is overwriting function abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: java-time.core, being replaced by: #'java-time.core/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: java-time, being replaced by: #'java-time/abs
Warning: environ value jdk-11.0.16.1+1 for key :java-version has been overwritten with 11.0.16.1
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2022-11-01 13:45:48,969 INFO metabase.util :: Maximum memory available to JVM: 6.0 GB
2022-11-01 13:45:51,058 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. ๐
For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
WARNING: abs already refers to: #'clojure.core/abs in namespace: taoensso.encore, being replaced by: #'taoensso.encore/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.math, being replaced by: #'kixi.stats.math/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.test, being replaced by: #'kixi.stats.math/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.distribution, being replaced by: #'kixi.stats.math/abs
2022-11-01 13:45:57,246 INFO driver.impl :: Registered abstract driver :sql ๐
2022-11-01 13:45:57,252 INFO metabase.util :: โฎฆ Load driver :sql took 134.6 ms
2022-11-01 13:45:57,264 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) ๐
2022-11-01 13:45:57,270 INFO metabase.util :: Load driver :sql-jdbc took 157.6 ms
2022-11-01 13:45:57,271 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) ๐
2022-11-01 13:45:57,318 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) ๐
2022-11-01 13:45:57,355 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) ๐
2022-11-01 13:45:59,526 INFO metabase.core ::
Metabase v0.44.5 (29fab4d release-x.44.x)
Copyright ยฉ 2022 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
2022-11-01 13:45:59,553 INFO metabase.core :: Starting Metabase in STANDALONE mode
2022-11-01 13:45:59,614 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 80, :host "0.0.0.0"}
2022-11-01 13:45:59,695 INFO metabase.core :: Starting Metabase version v0.44.5 (29fab4d release-x.44.x) ...
2022-11-01 13:45:59,762 INFO metabase.core :: System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "11.0.16.1+1",
"java.vendor" "Eclipse Adoptium",
"java.vendor.url" "https://adoptium.net/",
"java.version" "11.0.16.1",
"java.vm.name" "OpenJDK 64-Bit Server VM",
"java.vm.version" "11.0.16.1+1",
"os.name" "Linux",
"os.version" "4.15.0-1065-aws",
"user.language" "en",
"user.timezone" "Asia/Riyadh"}
2022-11-01 13:45:59,768 INFO metabase.plugins :: Loading plugins in /plugins...
2022-11-01 13:45:59,964 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
2022-11-01 13:46:00,048 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
2022-11-01 13:46:00,062 INFO util.files :: Extract file /modules/presto-jdbc.metabase-driver.jar -> /plugins/presto-jdbc.metabase-driver.jar
2022-11-01 13:46:00,146 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
2022-11-01 13:46:00,178 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
2022-11-01 13:46:00,180 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
2022-11-01 13:46:00,189 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar
2022-11-01 13:46:00,191 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
2022-11-01 13:46:00,197 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
2022-11-01 13:46:00,221 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
2022-11-01 13:46:00,223 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
2022-11-01 13:46:00,414 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
2022-11-01 13:46:00,432 INFO util.files :: Extract file /modules/bigquery-cloud-sdk.metabase-driver.jar -> /plugins/bigquery-cloud-sdk.metabase-driver.jar
2022-11-01 13:46:00,491 INFO util.files :: Extract file /modules/presto-common.metabase-driver.jar -> /plugins/presto-common.metabase-driver.jar
2022-11-01 13:46:00,657 INFO plugins.dependencies :: Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
2022-11-01 13:46:00,659 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? false
2022-11-01 13:46:00,673 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Presto Driver"]
2022-11-01 13:46:00,681 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2022-11-01 13:46:00,682 INFO driver.impl :: Registered driver :googleanalytics ๐
2022-11-01 13:46:00,688 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2022-11-01 13:46:00,689 INFO driver.impl :: Registered driver :druid ๐
2022-11-01 13:46:00,696 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/vertica.html for more details.
2022-11-01 13:46:00,697 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2022-11-01 13:46:00,698 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Presto Driver" "Metabase Vertica Driver"]
2022-11-01 13:46:00,702 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2022-11-01 13:46:00,704 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) ๐
2022-11-01 13:46:00,711 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2022-11-01 13:46:00,712 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) ๐
2022-11-01 13:46:00,720 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2022-11-01 13:46:00,722 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) ๐
2022-11-01 13:46:00,750 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2022-11-01 13:46:00,751 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) ๐
2022-11-01 13:46:00,755 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-common...
2022-11-01 13:46:00,756 INFO driver.impl :: Registered abstract driver :presto-common ๐
2022-11-01 13:46:00,756 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
2022-11-01 13:46:00,758 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase Presto Driver"]
2022-11-01 13:46:00,759 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...
2022-11-01 13:46:00,760 INFO driver.impl :: Registered driver :presto (parents: [:presto-common]) ๐
2022-11-01 13:46:00,767 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2022-11-01 13:46:00,768 INFO driver.impl :: Registered driver :mongo ๐
2022-11-01 13:46:00,776 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.
2022-11-01 13:46:00,782 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2022-11-01 13:46:00,784 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]
2022-11-01 13:46:00,798 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2022-11-01 13:46:00,800 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) ๐
2022-11-01 13:46:00,802 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2022-11-01 13:46:00,804 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) ๐
2022-11-01 13:46:00,823 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2022-11-01 13:46:00,827 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql]) ๐
2022-11-01 13:46:00,855 INFO plugins.dependencies :: Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
2022-11-01 13:46:00,858 INFO plugins.dependencies :: Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
2022-11-01 13:46:00,859 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2022-11-01 13:46:00,861 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:presto-common]) ๐
2022-11-01 13:46:00,867 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2022-11-01 13:46:00,874 INFO db.setup :: Verifying postgres Database Connection ...
2022-11-01 13:46:15,423 INFO db.setup :: Successfully verified PostgreSQL 12.11 application database connection. โ
2022-11-01 13:46:15,425 INFO db.setup :: Running Database Migrations...
2022-11-01 13:46:15,428 INFO db.setup :: Setting up Liquibase...
2022-11-01 13:46:39,981 INFO db.setup :: Liquibase is ready.
2022-11-01 13:46:39,982 INFO db.liquibase :: Checking if Database has unrun migrations...
2022-11-01 13:47:55,860 INFO db.setup :: Database Migrations Current ... โ
2022-11-01 13:47:55,879 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2022-11-01 13:47:56,433 INFO db.data-migrations :: Finished running data migrations.
2022-11-01 13:47:56,434 INFO metabase.util :: Database setup took 1.9 mins
2022-11-01 13:47:57,179 INFO metabase.events :: Starting events listener: :metabase.events.dependencies/Dependencies ๐
2022-11-01 13:47:57,185 INFO metabase.events :: Starting events listener: :metabase.events.activity-feed/ActivityFeed ๐
2022-11-01 13:47:57,190 INFO metabase.events :: Starting events listener: :metabase.events.last-login/LastLogin ๐
2022-11-01 13:47:57,191 INFO metabase.events :: Starting events listener: :metabase.events.persisted-info/PersistedInfo ๐
2022-11-01 13:47:57,192 INFO metabase.events :: Starting events listener: :metabase.events.notifications/Notifications ๐
2022-11-01 13:47:57,193 INFO metabase.events :: Starting events listener: :metabase.events.sync-database/Sync ๐
2022-11-01 13:47:57,193 INFO metabase.events :: Starting events listener: :metabase.events.driver-notifications/DriverNotifications ๐
2022-11-01 13:47:57,194 INFO metabase.events :: Starting events listener: :metabase.events.revision/Revisions ๐
2022-11-01 13:47:57,195 INFO metabase.events :: Starting events listener: :metabase.events.view-log/ViewLog ๐
2022-11-01 13:47:57,228 INFO impl.StdSchedulerFactory :: Using default implementation for ThreadExecutor
2022-11-01 13:47:57,245 INFO core.SchedulerSignalerImpl :: Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
2022-11-01 13:47:57,245 INFO core.QuartzScheduler :: Quartz Scheduler v.2.3.2 created.
2022-11-01 13:47:57,247 INFO jdbcjobstore.JobStoreTX :: Using db table-based data access locking (synchronization).
2022-11-01 13:47:57,249 INFO jdbcjobstore.JobStoreTX :: JobStoreTX initialized.
2022-11-01 13:47:57,250 INFO core.QuartzScheduler :: Scheduler meta-data: Quartz Scheduler (v2.3.2) 'MetabaseScheduler' with instanceId 'c2ac5ebbdaa11667299677230'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
Using job-store 'org.quartz.impl.jdbcjobstore.JobStoreTX' - which supports persistence. and is clustered.
2022-11-01 13:47:57,250 INFO impl.StdSchedulerFactory :: Quartz scheduler 'MetabaseScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
2022-11-01 13:47:57,250 INFO impl.StdSchedulerFactory :: Quartz scheduler version: 2.3.2
2022-11-01 13:47:57,388 INFO core.QuartzScheduler :: Scheduler MetabaseScheduler_$_c2ac5ebbdaa11667299677230 paused.
2022-11-01 13:47:57,389 INFO metabase.task :: Task scheduler initialized into standby mode.
2022-11-01 13:47:57,391 INFO metabase.task :: Initializing task SyncDatabases ๐
2022-11-01 13:47:58,915 INFO task.sync-databases :: Updated default schedules for 0 databases
2022-11-01 13:47:58,916 INFO metabase.task :: Initializing task PersistRefresh ๐
2022-11-01 13:48:06,100 INFO driver.impl :: Initializing driver :mongo...
2022-11-01 13:48:06,102 INFO plugins.classloader :: Added URL file:/plugins/mongo.metabase-driver.jar to classpath
2022-11-01 13:48:06,103 DEBUG plugins.init-steps :: Loading plugin namespace metabase.driver.mongo...
WARNING: random-uuid already refers to: #'clojure.core/random-uuid in namespace: monger.util, being replaced by: #'monger.util/random-uuid
2022-11-01 13:48:07,448 INFO driver.impl :: Registered driver :mongo ๐
2022-11-01 13:48:07,524 INFO metabase.util :: Load lazy loading driver :mongo took 1.4 s
2022-11-01 13:48:07,854 INFO metabase.task :: Initializing task CheckForNewVersions ๐
2022-11-01 13:48:18,659 INFO metabase.task :: Initializing task PersistPrune ๐
2022-11-01 13:48:19,697 INFO metabase.task :: Initializing task SendAnonymousUsageStats ๐
2022-11-01 13:48:46,957 INFO metabase.task :: Initializing task RefreshSlackChannelsAndUsers ๐
2022-11-01 13:49:03,436 INFO metabase.task :: Initializing task SendAbandomentEmails ๐
2022-11-01 13:49:16,308 INFO metabase.task :: Initializing task SendPulses ๐
2022-11-01 13:49:27,398 INFO metabase.task :: Initializing task SendFollowUpEmails ๐
2022-11-01 13:49:27,986 INFO metabase.task :: Initializing task TaskHistoryCleanup ๐
2022-11-01 13:49:28,225 INFO jdbcjobstore.JobStoreTX :: ClusterManager: detected 1 failed or restarted instances.
2022-11-01 13:49:28,225 INFO jdbcjobstore.JobStoreTX :: ClusterManager: Scanning for instance "ece094fe5afb1667279100154"'s failed in-progress jobs.
2022-11-01 13:49:28,397 INFO jdbcjobstore.JobStoreTX :: ClusterManager: ......Cleaned-up 1 other failed job(s).
2022-11-01 13:49:28,421 INFO core.QuartzScheduler :: Scheduler MetabaseScheduler_$_c2ac5ebbdaa11667299677230 started.
2022-11-01 13:49:28,423 INFO metabase.task :: Task scheduler started
2022-11-01 13:49:28,424 INFO metabase.core :: Metabase Initialization COMPLETE
2022-11-01 13:49:28,448 INFO driver.impl :: Initializing driver :sql...
2022-11-01 13:49:28,451 INFO driver.impl :: Initializing driver :sql-jdbc...
2022-11-01 13:49:28,453 INFO driver.impl :: Initializing driver :postgres...
2022-11-01 13:49:28,523 INFO jdbcjobstore.JobStoreTX :: Handling 1 trigger(s) that missed their scheduled fire-time.
2022-11-01 13:49:28,723 INFO task.refresh-slack-channel-user-cache :: Slack is not configured, not refreshing slack user/channel cache.
2022-11-01 14:00:03,244 INFO task.send-pulses :: Sending scheduled pulses...
2022-11-01 14:02:42,647 INFO task.sync-databases :: Starting sync task for Database 2.
2022-11-01 14:02:42,689 INFO sync.util :: STARTING: Sync metadata for mongo Database 2 'Sabbar'
2022-11-01 14:02:42,894 INFO sync.util :: STARTING: step 'sync-timezone' for mongo Database 2 'Sabbar'
2022-11-01 14:02:42,897 INFO sync.util :: FINISHED: step 'sync-timezone' for mongo Database 2 'Sabbar' (2.9 ms)
2022-11-01 14:02:42,900 INFO sync.util :: STARTING: step 'sync-tables' for mongo Database 2 'Sabbar'
2022-11-01 14:02:43,218 INFO sync-metadata.tables :: Found new version for DB: 4.2.3
2022-11-01 14:02:44,096 INFO sync-metadata.tables :: Updating description for tables: (Table 'giggers_applicants' Table 'dismiss_gig_reasons' Table 'partner_locations' Table 'gigs' Table 'hourly_rates' Table 'static_content' Table 'banks' Table 'countries' Table 'blocking_reasons' Table 'gig_roles' Table 'english_levels' Table 'shift_assignments' Table 'education_levels' Table 'dress_codes' Table 'account_deletion_reasons' Table 'users' Table 'audit_trails' Table 'gigger_report_reasons' Table 'giggers_reports' Table 'study_fields' Table 'cities' Table 'partner_blocking_reasons' Table 'tags' Table 'block_from_locations_reasons' Table 'gig_tags' Table 'attires' Table 'gigger_payment_adjustments' Table 'transaction_methods' Table 'cultural_tags' Table 'paymentchecks' Table 'partner_users' Table 'onboarding_file_rejection_reasons' Table 'notifications' Table 'cancel_unassign_reasons' Table 'devices' Table 'paychecks' Table 'giggers_strikes' Table 'classification_reasons' Table 'industries' Table 'giggers_working_motives' Table 'giggers_profile_pictures_guidelines' Table 'giggers_suspension' Table 'reference_numbers' Table 'giggers' Table 'partner_transactions' Table 'active_countries' Table 'shift_applications' Table 'currencies' Table 'payment_reasons' Table 'gig_rejection_reasons' Table 'partnerrates' Table 'gigger_rejection_reasons' Table 'salesmanship_skills' Table 'virtual_ibans' Table 'partners' Table 'groups' Table 'dismissed_gigs' Table 'strike_removal_reasons' Table 'pending_notifications' Table 'lead_sources' Table 'languages' Table 'employment_statuses' Table 'system.profile' Table 'education_institutes' Table 'gigger_replacement_reasons' Table 'partner_bills' Table 'business_size_classifications' Table 'communication_skills' Table 'gigger_pools' Table 'otp' Table 'previous_experiences' Table 'partner_wallets')
2022-11-01 14:02:44,097 INFO sync.util :: FINISHED: step 'sync-tables' for mongo Database 2 'Sabbar' (1.2 s)
2022-11-01 14:02:44,098 INFO sync.util :: STARTING: step 'sync-fields' for mongo Database 2 'Sabbar'
2022-11-01 14:02:56,779 INFO fields.sync-metadata :: Database position of Table 52 'system.profile' Field 'dbstats' has changed from '99' to '83'.
2022-11-01 14:02:56,780 INFO fields.sync-metadata :: Name of Table 52 'system.profile' Field 'dbstats' has changed from 'dbstats' to 'dbStats'.
2022-11-01 14:02:57,548 WARN sync.util :: Error syncing Fields for Table 'Table 52 'system.profile''
java.sql.BatchUpdateException: Batch entry 0 UPDATE "metabase_field" SET "database_position" = 83, "name" = 'dbStats', "updated_at" = now() WHERE "id" = 1305 was aborted: ERROR: duplicate key value violates unique constraint "idx_uniq_field_table_id_parent_id_name"
Detail: Key (table_id, parent_id, name)=(52, 1270, dbStats) already exists. Call getNextException to see other errors in the batch.
at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165)
at org.postgresql.core.ResultHandlerDelegate.handleError(ResultHandlerDelegate.java:52)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2367)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:560)
at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:893)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:916)
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1684)
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__28510.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__28578.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:447)
at toucan.db$execute_BANG_.doInvoke(db.clj:442)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at toucan.db$update_BANG_.invokeStatic(db.clj:526)
at toucan.db$update_BANG_.invoke(db.clj:515)
at toucan.db$update_BANG_.invokeStatic(db.clj:535)
at toucan.db$update_BANG_.invoke(db.clj:515)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66740$update_field_metadata_if_needed_BANG___66745$fn__66746.invoke(sync_metadata.clj:96)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66740$update_field_metadata_if_needed_BANG___66745.invoke(sync_metadata.clj:17)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807$fn__66808$iter__66809__66813$fn__66814.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__5467.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5962.invoke(core.clj:2826)
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__5467.invokeStatic(core.clj:139)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:24)
at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6882)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.sync.util$sum_for_STAR_.invokeStatic(util.clj:519)
at metabase.sync.util$sum_for_STAR_.invoke(util.clj:516)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807$fn__66808.invoke(sync_metadata.clj:117)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807.invoke(sync_metadata.clj:111)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66777$update_nested_fields_metadata_BANG___66782$fn__66783.invoke(sync_metadata.clj:108)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66777$update_nested_fields_metadata_BANG___66782.invoke(sync_metadata.clj:102)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807$fn__66808$iter__66809__66813$fn__66814.invoke(sync_metadata.clj:122)
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__5467.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5962.invoke(core.clj:2826)
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.next(RT.java:713)
at clojure.core$next__5451.invokeStatic(core.clj:64)
at clojure.core.protocols$fn__8249.invokeStatic(protocols.clj:169)
at clojure.core.protocols$fn__8249.invoke(protocols.clj:124)
at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:27)
at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6882)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.sync.util$sum_for_STAR_.invokeStatic(util.clj:519)
at metabase.sync.util$sum_for_STAR_.invoke(util.clj:516)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807$fn__66808.invoke(sync_metadata.clj:117)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807.invoke(sync_metadata.clj:111)
at metabase.sync.sync_metadata.fields$fn__66846$sync_and_update_BANG___66851$fn__66852.invoke(fields.clj:63)
at metabase.sync.sync_metadata.fields$fn__66846$sync_and_update_BANG___66851.invoke(fields.clj:55)
at metabase.sync.sync_metadata.fields$fn__66874$sync_fields_for_table_BANG___66883$fn__66886$fn__66887.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__66874$sync_fields_for_table_BANG___66883$fn__66886.invoke(fields.clj:71)
at metabase.sync.sync_metadata.fields$fn__66874$sync_fields_for_table_BANG___66883.invoke(fields.clj:65)
at clojure.core$partial$fn__5908.invoke(core.clj:2641)
at clojure.core$map$fn__5935.invoke(core.clj:2770)
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__5467.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5962.invoke(core.clj:2826)
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:1790)
at clojure.lang.RestFn.applyTo(RestFn.java:130)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.sync_metadata.fields$fn__66912$sync_fields_BANG___66917$fn__66918.invoke(fields.clj:85)
at metabase.sync.sync_metadata.fields$fn__66912$sync_fields_BANG___66917.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__42320$run_step_with_metadata__42325$fn__42329$fn__42331.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__42320$run_step_with_metadata__42325$fn__42329.invoke(util.clj:383)
at metabase.sync.util$fn__42320$run_step_with_metadata__42325.invoke(util.clj:378)
at metabase.sync.util$fn__42539$run_sync_operation__42544$fn__42545$fn__42553.invoke(util.clj:493)
at metabase.sync.util$fn__42539$run_sync_operation__42544$fn__42545.invoke(util.clj:491)
at metabase.sync.util$fn__42539$run_sync_operation__42544.invoke(util.clj:485)
at metabase.sync.sync_metadata$fn__68479$sync_db_metadata_BANG___68484$fn__68485$fn__68486.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__5910.invoke(core.clj:2647)
at metabase.driver.mongo$fn__96125$f__94576__auto____96126.invoke(mongo.clj:97)
at metabase.driver.mongo.util$do_with_mongo_connection$fn__94567.invoke(util.clj:226)
at metabase.util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)
at metabase.util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)
at metabase.driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)
at metabase.driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)
at metabase.driver.mongo$fn__96125.invokeStatic(mongo.clj:96)
at metabase.driver.mongo$fn__96125.invoke(mongo.clj:94)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__42229.invoke(util.clj:136)
at metabase.sync.util$with_db_logging_disabled$fn__42226.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__42215.invoke(util.clj:112)
at metabase.sync.util$with_sync_events$fn__42210.invoke(util.clj:86)
at metabase.sync.util$with_duplicate_ops_prevented$fn__42201.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__68479$sync_db_metadata_BANG___68484$fn__68485.invoke(sync_metadata.clj:49)
at metabase.sync.sync_metadata$fn__68479$sync_db_metadata_BANG___68484.invoke(sync_metadata.clj:46)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:71)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:62)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:81)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_uniq_field_table_id_parent_id_name"
Detail: Key (table_id, parent_id, name)=(52, 1270, dbStats) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
... 141 more
2022-11-01 14:04:55,569 WARN models.field :: Invalid Field :semantic_type :type/Number: falling back to null
2022-11-01 14:04:56,525 WARN models.field :: Invalid Field :semantic_type :type/Number: falling back to null
2022-11-01 14:05:13,019 WARN driver.common :: Don't know how to map class 'class org.bson.BsonUndefined' to a Field base_type, falling back to :type/*.
2022-11-01 14:05:13,991 INFO fields.sync-metadata :: Database position of Table 12 'shift_assignments' Field 'unBilledAdjustments' has changed from '42' to '59'.
2022-11-01 14:05:13,992 INFO fields.sync-metadata :: Name of Table 12 'shift_assignments' Field 'unBilledAdjustments' has changed from 'unBilledAdjustments' to 'unbilledAdjustments'.
2022-11-01 14:05:17,824 WARN sync.util :: Error syncing Fields for Table 'Table 12 'shift_assignments''
java.sql.BatchUpdateException: Batch entry 0 UPDATE "metabase_field" SET "database_position" = 59, "name" = 'unbilledAdjustments', "updated_at" = now() WHERE "id" = 1155 was aborted: ERROR: duplicate key value violates unique constraint "idx_uniq_field_table_id_parent_id_name"
Detail: Key (table_id, parent_id, name)=(12, 925, unbilledAdjustments) already exists. Call getNextException to see other errors in the batch.
at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165)
at org.postgresql.core.ResultHandlerDelegate.handleError(ResultHandlerDelegate.java:52)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2367)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:560)
at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:893)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:916)
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1684)
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__28510.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__28578.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:447)
at toucan.db$execute_BANG_.doInvoke(db.clj:442)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at toucan.db$update_BANG_.invokeStatic(db.clj:526)
at toucan.db$update_BANG_.invoke(db.clj:515)
at toucan.db$update_BANG_.invokeStatic(db.clj:535)
at toucan.db$update_BANG_.invoke(db.clj:515)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66740$update_field_metadata_if_needed_BANG___66745$fn__66746.invoke(sync_metadata.clj:96)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66740$update_field_metadata_if_needed_BANG___66745.invoke(sync_metadata.clj:17)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807$fn__66808$iter__66809__66813$fn__66814.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__5467.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5962.invoke(core.clj:2826)
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.next(RT.java:713)
at clojure.core$next__5451.invokeStatic(core.clj:64)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:27)
at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6882)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.sync.util$sum_for_STAR_.invokeStatic(util.clj:519)
at metabase.sync.util$sum_for_STAR_.invoke(util.clj:516)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807$fn__66808.invoke(sync_metadata.clj:117)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807.invoke(sync_metadata.clj:111)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66777$update_nested_fields_metadata_BANG___66782$fn__66783.invoke(sync_metadata.clj:108)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66777$update_nested_fields_metadata_BANG___66782.invoke(sync_metadata.clj:102)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807$fn__66808$iter__66809__66813$fn__66814.invoke(sync_metadata.clj:122)
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__5467.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5962.invoke(core.clj:2826)
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.next(RT.java:713)
at clojure.core$next__5451.invokeStatic(core.clj:64)
at clojure.core.protocols$fn__8249.invokeStatic(protocols.clj:169)
at clojure.core.protocols$fn__8249.invoke(protocols.clj:124)
at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:27)
at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6882)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.sync.util$sum_for_STAR_.invokeStatic(util.clj:519)
at metabase.sync.util$sum_for_STAR_.invoke(util.clj:516)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807$fn__66808.invoke(sync_metadata.clj:117)
at metabase.sync.sync_metadata.fields.sync_metadata$fn__66802$update_metadata_BANG___66807.invoke(sync_metadata.clj:111)
at metabase.sync.sync_metadata.fields$fn__66846$sync_and_update_BANG___66851$fn__66852.invoke(fields.clj:63)
at metabase.sync.sync_metadata.fields$fn__66846$sync_and_update_BANG___66851.invoke(fields.clj:55)
at metabase.sync.sync_metadata.fields$fn__66874$sync_fields_for_table_BANG___66883$fn__66886$fn__66887.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__66874$sync_fields_for_table_BANG___66883$fn__66886.invoke(fields.clj:71)
at metabase.sync.sync_metadata.fields$fn__66874$sync_fields_for_table_BANG___66883.invoke(fields.clj:65)
at clojure.core$partial$fn__5908.invoke(core.clj:2641)
at clojure.core$map$fn__5935.invoke(core.clj:2770)
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__5467.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5962.invoke(core.clj:2826)
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:1790)
at clojure.lang.RestFn.applyTo(RestFn.java:130)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.sync_metadata.fields$fn__66912$sync_fields_BANG___66917$fn__66918.invoke(fields.clj:85)
at metabase.sync.sync_metadata.fields$fn__66912$sync_fields_BANG___66917.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__42320$run_step_with_metadata__42325$fn__42329$fn__42331.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__42320$run_step_with_metadata__42325$fn__42329.invoke(util.clj:383)
at metabase.sync.util$fn__42320$run_step_with_metadata__42325.invoke(util.clj:378)
at metabase.sync.util$fn__42539$run_sync_operation__42544$fn__42545$fn__42553.invoke(util.clj:493)
at metabase.sync.util$fn__42539$run_sync_operation__42544$fn__42545.invoke(util.clj:491)
at metabase.sync.util$fn__42539$run_sync_operation__42544.invoke(util.clj:485)
at metabase.sync.sync_metadata$fn__68479$sync_db_metadata_BANG___68484$fn__68485$fn__68486.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__5910.invoke(core.clj:2647)
at metabase.driver.mongo$fn__96125$f__94576__auto____96126.invoke(mongo.clj:97)
at metabase.driver.mongo.util$do_with_mongo_connection$fn__94567.invoke(util.clj:226)
at metabase.util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)
at metabase.util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)
at metabase.driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)
at metabase.driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)
at metabase.driver.mongo$fn__96125.invokeStatic(mongo.clj:96)
at metabase.driver.mongo$fn__96125.invoke(mongo.clj:94)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__42229.invoke(util.clj:136)
at metabase.sync.util$with_db_logging_disabled$fn__42226.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__42215.invoke(util.clj:112)
at metabase.sync.util$with_sync_events$fn__42210.invoke(util.clj:86)
at metabase.sync.util$with_duplicate_ops_prevented$fn__42201.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__68479$sync_db_metadata_BANG___68484$fn__68485.invoke(sync_metadata.clj:49)
at metabase.sync.sync_metadata$fn__68479$sync_db_metadata_BANG___68484.invoke(sync_metadata.clj:46)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:71)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:62)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:81)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_uniq_field_table_id_parent_id_name"
Detail: Key (table_id, parent_id, name)=(12, 925, unbilledAdjustments) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
... 142 more
2022-11-01 14:06:39,313 INFO i18n.impl :: Reading available locales from locales.clj...
2022-11-01 14:06:39,706 INFO util.fonts :: Reading available fonts from /frontend_client/app/fonts
2022-11-01 14:06:50,607 DEBUG middleware.log :: GET /api/session/properties 200 10.3 s (4 DB calls) App DB connections: 2/7 Jetty threads: 4/50 (2 idle, 0 queued) (43 total active threads) Queries in flight: 0 (0 queued)
2022-11-01 14:07:46,947 INFO sync.util :: FINISHED: step 'sync-fields' for mongo Database 2 'Sabbar' (5.0 mins)
2022-11-01 14:07:46,948 INFO sync.util :: STARTING: step 'sync-fks' for mongo Database 2 'Sabbar'
2022-11-01 14:07:47,867 DEBUG middleware.log :: GET /api/user/current 200 1.1 mins (10 DB calls) App DB connections: 2/7 Jetty threads: 3/50 (3 idle, 0 queued) (44 total active threads) Queries in flight: 0 (0 queued)
2022-11-01 14:07:59,986 INFO sync.util :: FINISHED: step 'sync-fks' for mongo Database 2 'Sabbar' (13.0 s)
2022-11-01 14:07:59,988 INFO sync.util :: STARTING: step 'sync-metabase-metadata' for mongo Database 2 'Sabbar'
2022-11-01 14:07:59,993 INFO sync.util :: FINISHED: step 'sync-metabase-metadata' for mongo Database 2 'Sabbar' (5.6 ms)
2022-11-01 14:08:30,118 INFO sync.util :: FINISHED: Sync metadata for mongo Database 2 'Sabbar' (5.8 mins)
2022-11-01 14:08:30,121 INFO sync.util :: STARTING: Analyze data for mongo Database 2 'Sabbar'
2022-11-01 14:08:30,403 INFO sync.util :: STARTING: step 'fingerprint-fields' for mongo Database 2 'Sabbar'
2022-11-01 14:08:43,321 WARN sync.util :: Error fingerprinting Table 52 'system.profile'
com.mongodb.MongoCommandException: Command failed with error 16410 (Location16410): 'Invalid $project :: caused by :: FieldPath field names may not start with '$'.' on server 10.12.3.60:27017. The full response is { "ok" : 0.0, "errmsg" : "Invalid $project :: caused by :: FieldPath field names may not start with '$'.", "code" : 16410, "codeName" : "Location16410" }
at com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:179)
at com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:299)
at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:255)
at com.mongodb.internal.connection.UsageTrackingInternalConnection.sendAndReceive(UsageTrackingInternalConnection.java:99)
at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.sendAndReceive(DefaultConnectionPool.java:444)
at com.mongodb.internal.connection.CommandProtocolImpl.execute(CommandProtocolImpl.java:72)
at com.mongodb.internal.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:200)
at com.mongodb.internal.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:269)
at com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:131)
at com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:123)
at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:242)
at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:233)
at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:136)
at com.mongodb.operation.AggregateOperationImpl$1.call(AggregateOperationImpl.java:193)
at com.mongodb.operation.AggregateOperationImpl$1.call(AggregateOperationImpl.java:189)
at com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:462)
at com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:406)
at com.mongodb.operation.AggregateOperationImpl.execute(AggregateOperationImpl.java:189)
at com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:295)
at com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:41)
at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:179)
at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:161)
at com.mongodb.DBCollection.aggregate(DBCollection.java:1502)
at com.mongodb.DBCollection.aggregate(DBCollection.java:1462)
at com.mongodb.DBCollection.aggregate(DBCollection.java:1447)
at metabase.driver.mongo.execute$aggregate.invokeStatic(execute.clj:114)
at metabase.driver.mongo.execute$aggregate.invoke(execute.clj:108)
at metabase.driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:163)
at metabase.driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)
at metabase.driver.mongo$fn__96251$f__94576__auto____96252.invoke(mongo.clj:238)
at metabase.driver.mongo$fn__96251.invokeStatic(mongo.clj:237)
at metabase.driver.mongo$fn__96251.invoke(mongo.clj:235)
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:67)
at metabase.query_processor.context.default$default_runf.invoke(default.clj:65)
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$identity_qp.invokeStatic(reducible.clj:12)
at metabase.query_processor.reducible$identity_qp.invoke(reducible.clj:9)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52622.invoke(cache.clj:220)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__48143.invoke(permissions.clj:109)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51567.invoke(mbql_to_native.clj:23)
at metabase.query_processor$fn__54098$combined_post_process__54103$combined_post_process_STAR___54104.invoke(query_processor.clj:212)
at metabase.query_processor$fn__54098$combined_pre_process__54099$combined_pre_process_STAR___54100.invoke(query_processor.clj:209)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52543$fn__52548.invoke(resolve_database_and_driver.clj:35)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:75)
at metabase.driver$do_with_driver.invoke(driver.clj:71)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52543.invoke(resolve_database_and_driver.clj:34)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48578.invoke(fetch_source_query.clj:353)
at metabase.query_processor.middleware.store$initialize_store$fn__48766$fn__48767.invoke(store.clj:11)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:42)
at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
at metabase.query_processor.middleware.store$initialize_store$fn__48766.invoke(store.clj:10)
at metabase.query_processor.middleware.normalize_query$normalize$fn__52815.invoke(normalize_query.clj:22)
at metabase.query_processor.reducible$async_qp$qp_STAR___44981$thunk__44983.invoke(reducible.clj:100)
at metabase.query_processor.reducible$async_qp$qp_STAR___44981.invoke(reducible.clj:106)
at metabase.query_processor.reducible$async_qp$qp_STAR___44981.invoke(reducible.clj:91)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.query_processor.reducible$sync_qp$qp_STAR___44992.doInvoke(reducible.clj:126)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.query_processor$process_query.invokeStatic(query_processor.clj:247)
at metabase.query_processor$process_query.doInvoke(query_processor.clj:241)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at clojure.lang.Var.invoke(Var.java:388)
at metabase.db.metadata_queries$fn__67757$table_rows_sample__67766$fn__67769.invoke(metadata_queries.clj:145)
at metabase.db.metadata_queries$fn__67757$table_rows_sample__67766.invoke(metadata_queries.clj:132)
at metabase.sync.analyze.fingerprint$fn__67824$fingerprint_table_BANG___67829$fn__67830.invoke(fingerprint.clj:66)
at metabase.sync.analyze.fingerprint$fn__67824$fingerprint_table_BANG___67829.invoke(fingerprint.clj:46)
at metabase.sync.analyze.fingerprint$fn__68000$fingerprint_fields_BANG___68005$fn__68006$fn__68007.invoke(fingerprint.clj:180)
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.analyze.fingerprint$fn__68000$fingerprint_fields_BANG___68005$fn__68006.invoke(fingerprint.clj:178)
at metabase.sync.analyze.fingerprint$fn__68000$fingerprint_fields_BANG___68005.invoke(fingerprint.clj:174)
at metabase.sync.analyze.fingerprint$fn__68035$fingerprint_fields_for_db_BANG__STAR___68044$fn__68047$fn__68048$fn__68049.invoke(fingerprint.clj:204)
at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.sync.analyze.fingerprint$fn__68035$fingerprint_fields_for_db_BANG__STAR___68044$fn__68047$fn__68048.invoke(fingerprint.clj:200)
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.sync.analyze.fingerprint$fn__68035$fingerprint_fields_for_db_BANG__STAR___68044$fn__68047.invoke(fingerprint.clj:197)
at metabase.sync.analyze.fingerprint$fn__68035$fingerprint_fields_for_db_BANG__STAR___68044.invoke(fingerprint.clj:186)
at metabase.sync.analyze.fingerprint$fn__68035$fingerprint_fields_for_db_BANG__STAR___68044$fn__68045.invoke(fingerprint.clj:191)
at metabase.sync.analyze.fingerprint$fn__68035$fingerprint_fields_for_db_BANG__STAR___68044.invoke(fingerprint.clj:186)
at metabase.sync.analyze.fingerprint$fn__68077$fingerprint_fields_for_db_BANG___68082$fn__68083.invoke(fingerprint.clj:218)
at metabase.sync.analyze.fingerprint$fn__68077$fingerprint_fields_for_db_BANG___68082.invoke(fingerprint.clj:212)
at metabase.sync.analyze$make_analyze_steps$fn__68390.invoke(analyze.clj:104)
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__42320$run_step_with_metadata__42325$fn__42329$fn__42331.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__42320$run_step_with_metadata__42325$fn__42329.invoke(util.clj:383)
at metabase.sync.util$fn__42320$run_step_with_metadata__42325.invoke(util.clj:378)
at metabase.sync.util$fn__42539$run_sync_operation__42544$fn__42545$fn__42553.invoke(util.clj:493)
at metabase.sync.util$fn__42539$run_sync_operation__42544$fn__42545.invoke(util.clj:491)
at metabase.sync.util$fn__42539$run_sync_operation__42544.invoke(util.clj:485)
at metabase.sync.analyze$fn__68402$analyze_db_BANG___68407$fn__68408$fn__68409.invoke(analyze.clj:121)
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__5910.invoke(core.clj:2647)
at metabase.driver.mongo$fn__96125$f__94576__auto____96126.invoke(mongo.clj:97)
at metabase.driver.mongo.util$do_with_mongo_connection$fn__94567.invoke(util.clj:226)
at metabase.util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)
at metabase.util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)
at metabase.driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)
at metabase.driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)
at metabase.driver.mongo$fn__96125.invokeStatic(mongo.clj:96)
at metabase.driver.mongo$fn__96125.invoke(mongo.clj:94)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__42229.invoke(util.clj:136)
at metabase.sync.util$with_db_logging_disabled$fn__42226.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__42215.invoke(util.clj:112)
at metabase.sync.util$with_sync_events$fn__42210.invoke(util.clj:86)
at metabase.sync.util$with_duplicate_ops_prevented$fn__42201.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.analyze$fn__68402$analyze_db_BANG___68407$fn__68408.invoke(analyze.clj:118)
at metabase.sync.analyze$fn__68402$analyze_db_BANG___68407.invoke(analyze.clj:113)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:74)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:62)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:81)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
2022-11-01 14:08:56,943 INFO sync.analyze :: fingerprint-fields Analyzed [*****ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท] ๐ข 10% Table 32 'tabl1'
2022-11-01 14:09:04,898 INFO sync.analyze :: fingerprint-fields Analyzed [**********ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท] ๐ 21% Table 6 'tabl2'