Metabase wont sync new tables . Keep getting "WARN sync.util :: Error in sync step Sync metadata for postgres Database"

Get Help
1

None of the sync tasks are showing up in tasks logs.

Metabase Diagnostic Info

{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "1.8.0_302-b08",
    "java.vendor": "Red Hat, Inc.",
    "java.vendor.url": "https://www.redhat.com/",
    "java.version": "1.8.0_302",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "25.302-b08",
    "os.name": "Linux",
    "os.version": "3.10.0-1160.42.2.el7.x86_64",
    "user.language": "en",
    "user.timezone": "Africa/Johannesburg"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "mysql",
      "sqlserver"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "13.7"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.23"
      }
    },
    "run-mode": "prod",
    "version": {
      "tag": "v0.41.6",
      "date": "2022-01-10",
      "branch": "release-x.41.x",
      "hash": "296635f"
    },
    "settings": {
      "report-timezone": "Africa/Harare"
    }
  }
}

Error logs:

2022-06-13 14:42:11,066 WARN sync.util :: Error syncing _metabase_metadata table for postgres Database 30 'Data Warehouse Prod'
Jun 13 14:42:11 Metabase[8851]: org.postgresql.util.PSQLException: This connection has been closed.

2

Hi @JasonD
Seems like your database responds to Metabase with a table called _metabase_metadata, which is not a table that exists normally, but a special table where Metabase can read some information from instead of trying to manually sync and guess the structure of your database.
Remove this table, or make sure that Metabase cannot see/access it.

And upgrade to Java 11: https://www.metabase.com/docs/latest/operations-guide/java-versions.html

Latest release is 0.43.3: https://github.com/metabase/metabase/releases/latest

3

Thanks for the reply @flamber . Turns out it was an unrelated issue. One of the materialized views in our DB got stuck and blocked the Metabase sync from running. After resolving the sync task ran without issue.