Cant sync view

So, i’ve created a view in my postgres by necessity. When I synchronize the db the view appears, but when I try to do queries on it the columns aren’t available to filter but i can summarize by count of rows and its ok.

My view:

On Admin -> Data Model:

The Diagnostic Info and Logs about the view are below.

Diagnostic Info:
“browser-info”: {
“language”: “en-US”,
“platform”: “Linux x86_64”,
“userAgent”: “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36”,
“vendor”: “Google Inc.”
“system-info”: {
“file.encoding”: “UTF-8”,
“”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.7+10-post-Ubuntu-2ubuntu218.04”,
“java.vendor”: “Ubuntu”,
“java.vendor.url”: “”,
“java.version”: “11.0.7”,
“”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.7+10-post-Ubuntu-2ubuntu218.04”,
“”: “Linux”,
“os.version”: “4.15.0-96-generic”,
“user.language”: “en”,
“user.timezone”: “Etc/UTC”
“metabase-info”: {
“databases”: [
“hosting-env”: “unknown”,
“application-database”: “h2”,
“application-database-details”: {
“database”: {
“name”: “H2”,
“version”: “1.4.197 (2018-03-18)”
“jdbc-driver”: {
“name”: “H2 JDBC Driver”,
“version”: “1.4.197 (2018-03-18)”
“run-mode”: “prod”,
“version”: {
“date”: “2020-05-28”,
“tag”: “v0.35.4”,
“branch”: “release-0.35.x”,
“hash”: “b3080fa”
“settings”: {
“report-timezone”: “America/Sao_Paulo”


  • [ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:26:31-03:00 INFO metabase.sync.sync-metadata.tables We found new tables: (Table ‘jira.new_operacoes’)

  • [ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:26:31-03:00 INFO metabase.sync.sync-metadata.tables Updating descriptions for tables: (Table ‘jira.new_operacoes’)‘jira.new_operacoes’"

  • [ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:31:43-03:00 INFO metabase.api.table Table ‘new_operacoes’ is visible. Resynchronizing

  • [ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:31:43-03:00 ERROR metabase.sync.util Error syncing Fields for Table ‘Table 341 ‘jira.new_operacoes’’

  • [ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:33:34-03:00 ERROR metabase.sync.util Error syncing Fields for Table ‘Table 341 ‘jira.new_operacoes’’

Hi @johhen
This is most likely fixed in the new 0.36.0 release, so I would recommend that you try that version. Remember to backup before upgrading, since you cannot downgrade and have to revert to backup in case of downgrade.

And you should migrate away from H2, if you are using Metabase in production:

1 Like