Questions with field filters not working after update v0.42

Get Help
1

All my questions with field filters broke after updated from v0.41.6 to v0.42.3

image
image1092×606 23.2 KB

The idiom is in portuguese, but says: Failed searching field 2.536. Field does not exist or belongs to another database.

Just by selecting again the same information on field filters, the questions gets back to work. But I can't access 1 by 1 now to fix all broken queries. Is there some way to migrate all, or even, is this a migration problem?

Gonna post the logs bellow.

{
  "browser-info": {
    "language": "pt-BR",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 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.13.0-1019-aws",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "12.10"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.23"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-03-23",
      "tag": "v0.42.3",
      "branch": "release-x.42.x",
      "hash": "33fb268"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
2

[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:07-03:00 INFO metabase.core
Metabase v0.42.3 (33fb268 release-x.42.x)

Copyright © 2022 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:07-03:00 INFO metabase.core Starting Metabase in STANDALONE mode
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:07-03:00 INFO metabase.server Launching Embedded Jetty Webserver with config:
{:port 3000, :host "0.0.0.0"}

[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:07-03:00 INFO metabase.core Starting Metabase version v0.42.3 (33fb268 release-x.42.x) ...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:07-03:00 INFO metabase.core 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.13.0-1019-aws",
"user.language" "en",
"user.timezone" "GMT"}

[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:07-03:00 INFO metabase.plugins Loading plugins in /plugins...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/bigquery.metabase-driver.jar -> /plugins/bigquery.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/presto-jdbc.metabase-driver.jar -> /plugins/presto-jdbc.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/google.metabase-driver.jar -> /plugins/google.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/bigquery-cloud-sdk.metabase-driver.jar -> /plugins/bigquery-cloud-sdk.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:08-03:00 INFO metabase.util.files Extract file /modules/presto-common.metabase-driver.jar -> /plugins/presto-common.metabase-driver.jar
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlserver...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :sqlserver (parents: [:sql-jdbc]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :google...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered abstract driver :google :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :hive-like...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered abstract driver :hive-like (parents: [:sql-jdbc]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :sparksql (parents: [:hive-like]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sparksql...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlite...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :sqlite (parents: [:sql-jdbc]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :redshift...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :redshift (parents: [:postgres]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? false
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Presto Driver"]
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :mongo...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :mongo :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :snowflake...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :snowflake (parents: [:sql-jdbc]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.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.

[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Presto Driver" "Metabase Oracle Driver"]
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-common...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered abstract driver :presto-common :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.initialize Dependencies satisfied; these plugins will now be loaded: ["Metabase Presto Driver"]
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :presto (parents: [:presto-common]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 WARN metabase.plugins.lazy-loaded-driver Warning: plugin manifest for :bigquery does not include connection properties
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :bigquery (parents: [:sql :google]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :googleanalytics...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :googleanalytics (parents: [:google]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery-cloud-sdk...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :bigquery-cloud-sdk (parents: [:sql]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.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.

[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver"]
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :druid :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :druid...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.plugins.dependencies Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-jdbc...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.driver.impl Registered driver :presto-jdbc (parents: [:presto-common]) :truck:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.core Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.db.setup Verifying postgres Database Connection ...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.db.setup Successfully verified PostgreSQL 12.10 application database connection. :white_check_mark:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.db.setup Running Database Migrations...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.db.setup Setting up Liquibase...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.db.liquibase Checking if Database has unrun migrations...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:09-03:00 INFO metabase.db.setup Liquibase is ready.
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:12-03:00 INFO metabase.db.liquibase Database has unrun migrations. Waiting for migration lock to be cleared...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:12-03:00 INFO metabase.db.liquibase Migration lock is cleared. Running migrations...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:12-03:00 INFO metabase.db.setup Database Migrations Current ... :white_check_mark:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:12-03:00 INFO metabase.db.data-migrations Running all necessary data migrations, this may take a minute.
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:12-03:00 INFO metabase.db.data-migrations Finished running data migrations.
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:13-03:00 INFO metabase.util.i18n.impl Reading available locales from locales.clj...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:13-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.dependencies/Dependencies :ear:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:13-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.activity-feed/ActivityFeed :ear:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:13-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.last-login/LastLogin :ear:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:13-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.notifications/Notifications :ear:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:13-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.sync-database/Sync :ear:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:13-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.driver-notifications/DriverNotifications :ear:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:13-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.revision/Revisions :ear:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:13-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.view-log/ViewLog :ear:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:13-03:00 INFO metabase.task Iniciando tarefa SyncDatabases :calendar:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:16-03:00 INFO metabase.task Iniciando tarefa CheckForNewVersions :calendar:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:16-03:00 INFO metabase.task Iniciando tarefa SendAnonymousUsageStats :calendar:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:16-03:00 INFO metabase.task Iniciando tarefa SendAbandomentEmails :calendar:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:16-03:00 INFO metabase.task Iniciando tarefa SendPulses :calendar:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:16-03:00 INFO metabase.task Iniciando tarefa SendFollowUpEmails :calendar:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:16-03:00 INFO metabase.task Iniciando tarefa TaskHistoryCleanup :calendar:
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:16-03:00 INFO metabase.driver.impl Inicializando driver :sql...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:16-03:00 INFO metabase.driver.impl Inicializando driver :postgres...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:16-03:00 INFO metabase.driver.impl Inicializando driver :sql-jdbc...
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:16-03:00 INFO metabase.core Inicialização do Metabase COMPLETA
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:19-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 77.8 ms (4 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 5 / 50 (2 ocioso, 0 na fila) (39 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:20-03:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 288.8 ms (4 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 4 / 50 (2 ocioso, 0 na fila) (39 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:20-03:00 DEBUG metabase.server.middleware.log GET /api/field/2536 200 69.1 ms (7 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 1 / 7 Threads do Jetty: 5 / 50 (2 ocioso, 0 na fila) (39 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:20-03:00 DEBUG metabase.server.middleware.log GET /api/database 200 75.2 ms (3 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 1 / 7 Threads do Jetty: 5 / 50 (2 ocioso, 0 na fila) (39 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:20-03:00 DEBUG metabase.server.middleware.log GET /api/field/2536/values 200 20.5 ms (4 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 6 / 50 (1 ocioso, 0 na fila) (41 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:20-03:00 DEBUG metabase.server.middleware.log GET /api/native-query-snippet 200 19.8 ms (2 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 6 / 50 (1 ocioso, 0 na fila) (41 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:20-03:00 DEBUG metabase.server.middleware.log GET /api/search 200 37.6 ms (3 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (41 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:20-03:00 DEBUG metabase.server.middleware.log GET /api/collection 200 139.6 ms (3 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 1 / 7 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (41 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:22-03:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.9 s (8 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 3 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 1 (0 na fila); postgres DB 8 connections: 0/0 (0 threads blocked)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:25-03:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 32.2 ms (4 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:25-03:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 39.0 ms (4 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:26-03:00 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/16/candidates 200 662.6 ms (7 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 4 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:27-03:00 DEBUG metabase.server.middleware.log GET /api/collection/23 200 10.6 ms (3 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:27-03:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 27.0 ms (4 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 4 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:27-03:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 16.8 ms (2 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 2 / 7 Threads do Jetty: 6 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:27-03:00 DEBUG metabase.server.middleware.log GET /api/collection/23/items 200 64.2 ms (5 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 2 / 7 Threads do Jetty: 6 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:27-03:00 DEBUG metabase.server.middleware.log GET /api/collection/23/items 200 73.2 ms (7 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 4 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:30-03:00 DEBUG metabase.server.middleware.log GET /api/dashboard/85 200 243.8 ms (26 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 4 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:30-03:00 DEBUG metabase.server.middleware.log GET /api/field/3418 200 16.2 ms (6 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 1 / 7 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:30-03:00 DEBUG metabase.server.middleware.log GET /api/field/3235 200 21.8 ms (6 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 1 / 7 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (49 total de threads ativas) Consultas ativas: 0 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:32-03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/85/dashcard/1278/card/780/query 202 [ASYNC: completed] 1.4 s (16 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 2 / 15 Threads do Jetty: 3 / 50 (14 ocioso, 0 na fila) (99 total de threads ativas) Consultas ativas: 13 (0 na fila); postgres DB 8 connections: 0/2 (0 threads blocked)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:33-03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/85/dashcard/1279/card/781/query 202 [ASYNC: completed] 2.6 s (16 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 1 / 15 Threads do Jetty: 3 / 50 (14 ocioso, 0 na fila) (100 total de threads ativas) Consultas ativas: 12 (0 na fila); postgres DB 13 connections: 0/0 (0 threads blocked)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:33-03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/85/dashcard/1280/card/782/query 202 [ASYNC: completed] 2.9 s (16 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 1 / 15 Threads do Jetty: 3 / 50 (14 ocioso, 0 na fila) (100 total de threads ativas) Consultas ativas: 11 (0 na fila); postgres DB 12 connections: 0/0 (0 threads blocked)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:35-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Erro ao processar a consulta: null
{:database_id 20,
:started_at #t "2022-04-02T19:35:31.150682Z[GMT]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error
"Error determining value for parameter "time": Falha ao buscar Campo3.235: Campo não existe, ou pertence a um Banco de Dados diferente.",
:stacktrace
["--> driver.common.parameters.values$fn__78500$value_for_tag__78505$fn__78506.invoke(values.clj:309)"
"driver.common.parameters.values$fn__78500$value_for_tag__78505.invoke(values.clj:302)"
"driver.common.parameters.values$fn__78524$query__GT_params_map__78529$fn__78533$iter__78535__78539$fn__78540.invoke(values.clj:326)"
"driver.common.parameters.values$fn__78524$query__GT_params_map__78529$fn__78533.invoke(values.clj:325)"
"driver.common.parameters.values$fn__78524$query__GT_params_map__78529.invoke(values.clj:316)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613$fn__78617.invoke(sql.clj:46)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:49)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:40)"
"query_processor.middleware.parameters$expand_all$replace_48583__48584.invoke(parameters.clj:58)"
"mbql.util.match.impl$replace_in_collection$iter__27400__27404$fn__27405.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_48583__48584.invoke(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:55)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:76)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:72)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604$fn__48605.invoke(parameters.clj:81)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604.invoke(parameters.clj:78)"
"query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46721$fn__46722.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__46721.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43282$fn__43285.invoke(reducible.clj:108)"],
:error_type :invalid-parameter,
:ex-data
{:tag
{:id "e648b41a-989b-1a7c-c6c7-bdcffb8d4a41",
:name "time",
:display-name "Time",
:type :dimension,
:dimension [:field 3235 nil],
:widget-type :date/range},
:type :invalid-parameter}}
{:status :failed,
:class clojure.lang.ExceptionInfo,
:error
"Erro ao construir o mapa de parâmetros da consulta: Error determining value for parameter "time": Falha ao buscar Campo3.235: Campo não existe, ou pertence a um Banco de Dados diferente.",
:stacktrace
["--> driver.common.parameters.values$fn__78524$query__GT_params_map__78529$fn__78533.invoke(values.clj:334)"
"driver.common.parameters.values$fn__78524$query__GT_params_map__78529.invoke(values.clj:316)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613$fn__78617.invoke(sql.clj:46)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:49)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:40)"
"query_processor.middleware.parameters$expand_all$replace_48583__48584.invoke(parameters.clj:58)"
"mbql.util.match.impl$replace_in_collection$iter__27400__27404$fn__27405.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_48583__48584.invoke(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:55)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:76)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:72)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604$fn__48605.invoke(parameters.clj:81)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604.invoke(parameters.clj:78)"
"query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46721$fn__46722.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__46721.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43282$fn__43285.invoke(reducible.clj:108)"],
:error_type :invalid-parameter,
:ex-data
{:type :invalid-parameter,
:tags
{"time"
{:id "e648b41a-989b-1a7c-c6c7-bdcffb8d4a41",
:name "time",
:display-name "Time",
:type :dimension,
:dimension [:field 3235 nil],
:widget-type :date/range}},
:params nil}}],
:error_type :invalid-parameter,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:native
{:query
"with cement as (\n select \n avg(err_index * intv_index) as index\n from(\n select\n concrete_shipments.code,\n 3abs(sum(abs(inventory_changes.quantity))-sum(shipment_material_locations.formula_weight))/sum(shipment_material_locations.formula_weight) as err_index,\n case\n when concrete_shipments.canceled_at is not null\n then 0.1 \n when concrete_shipments.manual_operation_id is not null\n then 0.5\n else 1 \n end as intv_index\n from concrete_shipments\n join inventory_changes on inventory_changes.concrete_shipment_id=concrete_shipments.id\n join inventory_items on inventory_changes.inventory_item_id=inventory_items.id\n join shipment_materials on shipment_materials.concrete_shipment_id=concrete_shipments.id\n join shipment_material_locations on shipment_material_locations.shipment_material_id=shipment_materials.id\n where inventory_items.material_type='cement'\n and shipment_materials.inventory_item_id=inventory_changes.inventory_item_id\n -- and inventory_changes.quantity > -3800\n and {{time}}\n group by 1, 3) as indexes),\n \n additive as (\n select \n avg(err_index * intv_index) as index\n from(\n select\n concrete_shipments.code,\n 2.5abs(sum(abs(inventory_changes.quantity))-sum(shipment_material_locations.formula_weight))/sum(shipment_material_locations.formula_weight) as err_index,\n case\n when concrete_shipments.canceled_at is not null\n then 0.1 \n when concrete_shipments.manual_operation_id is not null\n then 0.5\n else 1 \n end as intv_index\n from concrete_shipments\n join inventory_changes on inventory_changes.concrete_shipment_id=concrete_shipments.id\n join inventory_items on inventory_changes.inventory_item_id=inventory_items.id\n join shipment_materials on shipment_materials.concrete_shipment_id=concrete_shipments.id\n join shipment_material_locations on shipment_material_locations.shipment_material_id=shipment_materials.id\n where inventory_items.material_type='additive'\n and shipment_materials.inventory_item_id=inventory_changes.inventory_item_id\n -- and inventory_changes.quantity > -40\n and {{time}}\n group by 1, 3) as indexes\n ),\n \n water as (\n select \n avg(err_index * intv_index) as index\n from(\n select\n concrete_shipments.code,\n 1.5*abs(sum(abs(inventory_changes.quantity))-sum(shipment_material_locations.formula_weight))/sum(shipment_material_locations.formula_weight) as err_index,\n case\n when concrete_shipments.canceled_at is not null\n then 0.1 \n when concrete_shipments.manual_operation_id is not null\n then 0.5\n else 1 \n end as intv_index\n from concrete_shipments\n join inventory_changes on inventory_changes.concrete_shipment_id=concrete_shipments.id\n join inventory_items on inventory_changes.inventory_item_id=inventory_items.id\n join shipment_materials on shipment_materials.concrete_shipment_id=concrete_shipments.id\n join shipment_material_locations on shipment_material_locations.shipment_material_id=shipment_materials.id\n where inventory_items.material_type='water'\n and shipment_materials.inventory_item_id=inventory_changes.inventory_item_id\n -- and inventory_changes.quantity > -1500\n and {{time}}\n group by 1, 3\n order by 2 desc) as indexes\n )\n\nselect cement.index+additive.index+water.index from cement, additive, water\n",
:template-tags
{"time"
{:id "e648b41a-989b-1a7c-c6c7-bdcffb8d4a41",
:name "time",
:display-name "Time",
:type :dimension,
:dimension [:field 3235 nil],
:widget-type :date/range}}},
:database 20,
:parameters [],
:async? true,
:cache-ttl nil},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> query_processor.store$fn__37121$fetch_and_store_fields_BANG___37126$fn__37127.invoke(store.clj:218)"
"query_processor.store$fn__37121$fetch_and_store_fields_BANG___37126.invoke(store.clj:196)"
"driver.common.parameters.values$fn__78215$parse_tag__78208__78220$fn__78224.invoke(values.clj:115)"
"driver.common.parameters.values$fn__78215$parse_tag__78208__78220.invoke(values.clj:110)"
"driver.common.parameters.values$fn__78500$value_for_tag__78505$fn__78506.invoke(values.clj:307)"
"driver.common.parameters.values$fn__78500$value_for_tag__78505.invoke(values.clj:302)"
"driver.common.parameters.values$fn__78524$query__GT_params_map__78529$fn__78533$iter__78535__78539$fn__78540.invoke(values.clj:326)"
"driver.common.parameters.values$fn__78524$query__GT_params_map__78529$fn__78533.invoke(values.clj:325)"
"driver.common.parameters.values$fn__78524$query__GT_params_map__78529.invoke(values.clj:316)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613$fn__78617.invoke(sql.clj:46)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:49)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:40)"
"query_processor.middleware.parameters$expand_all$replace_48583__48584.invoke(parameters.clj:58)"
"mbql.util.match.impl$replace_in_collection$iter__27400__27404$fn__27405.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_48583__48584.invoke(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:55)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:76)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:72)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604$fn__48605.invoke(parameters.clj:81)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604.invoke(parameters.clj:78)"
"query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46721$fn__46722.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__46721.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43282$fn__43285.invoke(reducible.clj:108)"],
:card_id 874,
:context :dashboard,
:error "Falha ao buscar Campo3.235: Campo não existe, ou pertence a um Banco de Dados diferente.",
:row_count 0,
:running_time 0,
:ex-data {:field 3235, :database 20},
:data {:rows [], :cols []}}

[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:35-03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/85/dashcard/1425/card/874/query 202 [ASYNC: completed] 4.4 s (12 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 15 Threads do Jetty: 3 / 50 (14 ocioso, 0 na fila) (101 total de threads ativas) Consultas ativas: 10 (0 na fila)
[740d31d7-d8f8-408e-9780-15e94409643c] 2022-04-02T16:35:35-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Erro ao processar a consulta: null

3

Hi @lopesvictor
The error in English is Field does not exist, or belongs to a different Database
You're seeing this issue:
https://github.com/metabase/metabase/issues/14145
You need to make sure that the database selected and the Field Filter are referencing the same database.

4

Oh yes, it's referencing the same database.
When I rollback to version 41.6 it works normally.
When I edit the Field Filter selecting the same database and field, it also works.
I have observed that questions made on Metabase UI, instead of native SQL were successfully migrated, all filters works well.

5

@lopesvictor Post the metadata output of the field by going to the URL /api/field/3235

6

{"description":null,"database_type":"timestamp","semantic_type":null,"table_id":368,"coercion_strategy":null,"table":{"description":null,"entity_type":"entity/GenericTable","schema":"public","db":{"description":null,"features":["full-join","basic-aggregations","nested-field-columns","standard-deviation-aggregations","expression-aggregations","percentile-aggregations","foreign-keys","right-join","left-join","native-parameters","nested-queries","expressions","set-timezone","regex","case-sensitivity-string-filter-options","binning","inner-join","advanced-math-expressions"],"cache_field_values_schedule":"0 0 19 * * ? *","timezone":"UTC","auto_run_queries":true,"metadata_sync_schedule":"0 36 * * * ? *","name":"Superbeton Indaial","settings":null,"caveats":null,"creator_id":null,"is_full_sync":true,"updated_at":"2021-06-14T17:49:37.323626Z","cache_ttl":null,"details":{"host":"34.136.15.42","port":5432,"dbname":"super_indaial","user":"postgres","password":"MetabasePass","ssl":true,"additional-options":null,"tunnel-enabled":false},"is_sample":false,"id":12,"is_on_demand":false,"options":null,"engine":"postgres","initial_sync_status":"complete","refingerprint":null,"created_at":"2021-05-28T18:26:57.162691Z","points_of_interest":null},"show_in_getting_started":false,"name":"concrete_shipments","caveats":null,"updated_at":"2021-05-28T18:27:18.337855Z","active":true,"id":368,"db_id":12,"visibility_type":null,"field_order":"database","initial_sync_status":"complete","display_name":"Concrete Shipments","created_at":"2021-05-28T18:26:57.876468Z","points_of_interest":null},"name":"inserted_at","fingerprint_version":4,"has_field_values":"none","settings":null,"caveats":null,"fk_target_field_id":null,"dimensions":,"updated_at":"2021-05-28T18:27:15.204316Z","custom_position":0,"effective_type":"type/DateTime","active":true,"nfc_path":null,"parent_id":null,"id":3235,"last_analyzed":"2021-05-28T18:27:18.358776Z","position":4,"visibility_type":"normal","preview_display":true,"display_name":"Inserted At","database_position":4,"name_field":null,"fingerprint":{"global":{"distinct-count":4971,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2020-08-02T13:28:12Z","latest":"2021-05-27T18:35:35Z"}}},"created_at":"2021-05-28T18:27:04.007453Z","base_type":"type/DateTime","points_of_interest":null}

7

@lopesvictor The question belongs to database 20, while the field you have selected in the Field Filter variables sidebar belongs to database 12.

You need to fix the variable, so it uses the same database as the question.

8

Thanks @flamber

This issue came along with v42.0, when I rollback to v46.1 for example it works normally.
You can see in the image bellow that the field is blank after update, on all queries involving field filtering with time.

image
image826×1600 54.4 KB

Anyway I already accessed all the queries and filled again that field, now working normally.

9

@lopesvictor Yes, it was a bug in previous versions, which allowed you to save the question with different database references. That was fixed in 42. You need to fix your questions, so they reference the same database. Otherwise you will never be able to use newer versions of Metabase.