Error reported during Metabase sync task, sync not completing missing things like binning

This just happened to us and we’re on the latest version of metabase 0.35.3. Postgres db would not sync, BigQuery does. Error log shows the usual “fingerprint” step error, doesn’t seem to affect anything, plus a failure on sync step. I added a new version of the postgres db and it sync’d fine. Still couldn’t get the old one to until i found this thread. I looked for all pk’s and found one that was a date. I changed it from a PK constraint to a regular index and voila, the sync started working again.

Postgres query for checking pk’s for ref:

       kcu.table_name,
       tco.constraint_name,
       kcu.ordinal_position as position,
       kcu.column_name as key_column
from information_schema.table_constraints tco
join information_schema.key_column_usage kcu 
     on kcu.constraint_name = tco.constraint_name
     and kcu.constraint_schema = tco.constraint_schema
     and kcu.constraint_name = tco.constraint_name
where tco.constraint_type = 'PRIMARY KEY'
order by kcu.table_schema,
         kcu.table_name,
         position;```