All of my dashboards and question i have been working on past two month are gone after a simple server restart, i have it connected to postgresql.
please help…!!!
Hi @kal.el
How are you running Metabase? Docker, JAR, Linux, Windows, …?
You’re not providing any information on how you are hosting Metabase, so it’s difficult to help, but if you were using environment variables, then you need to set those again after a restart, so Metabase can connect to the right application database.
1 Like
hi @flamber, sorry for so little info, i am really bumped, i am using Linux (Ubuntu) server
metabase version v0.35.1, i am using Postgresql 9.6 as a database for metabase…all of the dashboards before 2 months are available, but after that all of the data has been vanished.
@kal.el So it sounds like you have not setup Metabase as a service?
https://www.metabase.com/docs/latest/operations-guide/running-metabase-on-debian.html
How are you starting Metabase? If you just use java -jar metabase.jar, then you need to define the environment variables again, though I would highly recommend that you configure it as a service.
https://www.metabase.com/docs/latest/operations-guide/configuring-application-database.html#postgres
Nothing is lost - you can check the data in the Postgres database.
But this underlines the reason to make sure you have backups.
Just want to recommend our new hosted service as well:
https://www.metabase.com/start/hosted/
1 Like
i already did, and i am running it as a service
below is my metabase.service file
[Unit]
Description=Metabase server
[Service]
Restart=on-failure
WorkingDirectory=/home/odoo/metabase
Environment=MB_DB_TYPE=postgres
Environment=MB_DB_DBNAME=XXXX
Environment=MB_DB_PORT=5432
Environment=MB_DB_USER=XXXX
Environment=MB_DB_PASS=******
Environment=MB_DB_HOST=localhost
ExecStart=/usr/bin/java -jar /home/******/metabase/metabase.jar
[Install]
WantedBy=multi-user.target
- Post “Diagnostic Info” from Admin > Troubleshooting.
- Check the Postgres database if it has ever had data.
i already did, PG does not have any new collections or dashboard in it.
eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:30+05:00 WARN metabase.core WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:30+05:00 INFO metabase.core Starting Metabase in STANDALONE mode
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:30+05:00 INFO metabase.server Launching Embedded Jetty Webserver with config:
{:port 3000}
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:30+05:00 INFO metabase.core Starting Metabase version v0.35.1 (e67f169 release-0.35.x) …
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:30+05:00 INFO metabase.core System info:
{“file.encoding” “UTF-8”,
“java.runtime.name” “OpenJDK Runtime Environment”,
“java.runtime.version” “1.8.0_242-8u242-b08-0ubuntu3~16.04-b08”,
“java.vendor” “Private Build”,
“java.vendor.url” “http://java.oracle.com/”,
“java.version” “1.8.0_242”,
“java.vm.name” “OpenJDK 64-Bit Server VM”,
“java.vm.version” “25.242-b08”,
“os.name” “Linux”,
“os.version” “4.4.0-171-generic”,
“user.language” “en”,
“user.timezone” “Etc/UTC”}
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:30+05:00 INFO metabase.plugins Loading plugins in /home/odoo/metabase/plugins…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05: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.
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.plugins.dependencies Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: [“Metabase Vertica Driver”]
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlserver…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered abstract driver :sql 
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered abstract driver :sql-jdbc (parents: [:sql])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :sqlserver (parents: [:sql-jdbc])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.plugins.dependencies Plugin ‘Metabase BigQuery Driver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: [“Metabase Vertica Driver” “Metabase BigQuery Driver”]
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.plugins.dependencies Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :hive-like…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered abstract driver :hive-like (parents: [:sql-jdbc])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :sparksql (parents: [:hive-like])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sparksql…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered abstract driver :google
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :google…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.initialize Dependencies satisfied; these plugins will now be loaded: [“Metabase BigQuery Driver”]
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.plugins.dependencies Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :bigquery (parents: [:sql :google])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlite…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :sqlite (parents: [:sql-jdbc])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :presto (parents: [:sql])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :redshift…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :postgres (parents: [:sql-jdbc])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :redshift (parents: [:postgres])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :mongo
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :mongo…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :druid…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :druid
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :snowflake (parents: [:sql-jdbc])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :snowflake…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05: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.
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.plugins.dependencies Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: [“Metabase Vertica Driver” “Metabase Oracle Driver”]
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :googleanalytics…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.plugins.dependencies Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.plugins.dependencies Plugin ‘Metabase Google Analytics Driver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :googleanalytics (parents: [:google])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :h2 (parents: [:sql-jdbc])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Registered driver :mysql (parents: [:sql-jdbc])
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.core Setting up and migrating Metabase DB. Please sit tight, this may take a minute…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.db Verifying postgres Database Connection …
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Initializing driver :sql…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Initializing driver :sql-jdbc…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.driver.impl Initializing driver :postgres…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.db Successfully verified PostgreSQL 9.6.17 application database connection. 
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.db Running Database Migrations…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:31+05:00 INFO metabase.db Setting up Liquibase…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:32+05:00 INFO metabase.db Liquibase is ready.
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:32+05:00 INFO metabase.db.liquibase Checking if Database has unrun migrations…
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.db Database Migrations Current …
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.db.migrations Running all necessary data migrations, this may take a minute.
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.db.migrations Finished running data migrations.
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.events Starting events listener: metabase.events.activity-feed 
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.events Starting events listener: metabase.events.dependencies
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.events Starting events listener: metabase.events.driver-notifications
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.events Starting events listener: metabase.events.last-login
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.events Starting events listener: metabase.events.metabot-lifecycle
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.events Starting events listener: metabase.events.notifications
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.events Starting events listener: metabase.events.revision
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.events Starting events listener: metabase.events.sync-database
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:33+05:00 INFO metabase.events Starting events listener: metabase.events.view-log
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:34+05:00 INFO metabase.task Initializing task SyncDatabases 
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:34+05:00 INFO metabase.task Initializing task CheckForNewVersions
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:34+05:00 INFO metabase.task Initializing task SendAnonymousUsageStats
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:34+05:00 INFO metabase.task Initializing task SendAbandomentEmails
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:34+05:00 INFO metabase.task Initializing task SendPulses
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:34+05:00 INFO metabase.task Initializing task SendFollowUpEmails
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:34+05:00 INFO metabase.task Initializing task TaskHistoryCleanup
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:34+05:00 INFO metabase.core Metabase Initialization COMPLETE
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:38+05:00 WARN metabase.routes.index Locale ‘en’ not found.
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:40+05:00 DEBUG metabase.middleware.log GET /api/session/properties 200 5.8 ms (0 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (1 idle, 0 queued) (40 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:41+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c 200 630.0 ms (17 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (1 idle, 0 queued) (41 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:41+05:00 INFO metabase.api.card Question’s average execution duration is 123.0 ms; using ‘magic’ TTL of 1000.0 ms 
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:41+05:00 INFO metabase.query-processor.middleware.cache Query took 276.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/988 202 [ASYNC: completed] 493.1 ms (7 DB calls) App DB connections: 4/4 Jetty threads: 4/50 (1 idle, 0 queued) (62 total active threads) Queries in flight: 5 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/89 202 [ASYNC: completed] 543.7 ms (6 DB calls) App DB connections: 4/4 Jetty threads: 4/50 (1 idle, 0 queued) (62 total active threads) Queries in flight: 3 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/861 202 [ASYNC: completed] 513.6 ms (6 DB calls) App DB connections: 4/4 Jetty threads: 4/50 (1 idle, 0 queued) (62 total active threads) Queries in flight: 3 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/123 202 [ASYNC: completed] 391.7 ms (6 DB calls) App DB connections: 5/5 Jetty threads: 4/50 (1 idle, 0 queued) (64 total active threads) Queries in flight: 1 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/1211 202 [ASYNC: completed] 441.6 ms (6 DB calls) App DB connections: 6/7 Jetty threads: 4/50 (1 idle, 0 queued) (64 total active threads) Queries in flight: 1 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/91 202 [ASYNC: completed] 592.7 ms (6 DB calls) App DB connections: 7/7 Jetty threads: 4/50 (1 idle, 0 queued) (64 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 INFO metabase.api.card Question’s average execution duration is 99.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 INFO metabase.api.card Question’s average execution duration is 51.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 INFO metabase.api.card Question’s average execution duration is 277.0 ms; using ‘magic’ TTL of 3.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 INFO metabase.api.card Question’s average execution duration is 3.8 s; using ‘magic’ TTL of 38.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 INFO metabase.query-processor.middleware.cache Query took 87.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 INFO metabase.query-processor.middleware.cache Query took 95.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 INFO metabase.query-processor.middleware.cache Query took 127.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/53 202 [ASYNC: completed] 234.8 ms (6 DB calls) App DB connections: 2/15 Jetty threads: 4/50 (2 idle, 0 queued) (75 total active threads) Queries in flight: 5 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/51 202 [ASYNC: completed] 238.8 ms (6 DB calls) App DB connections: 2/15 Jetty threads: 4/50 (2 idle, 0 queued) (75 total active threads) Queries in flight: 4 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/1019 202 [ASYNC: completed] 218.0 ms (6 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (2 idle, 0 queued) (76 total active threads) Queries in flight: 3 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/827 202 [ASYNC: completed] 258.0 ms (6 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (2 idle, 0 queued) (77 total active threads) Queries in flight: 2 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 INFO metabase.api.card Question’s average execution duration is 769.0 ms; using ‘magic’ TTL of 8.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:42+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/1442 202 [ASYNC: completed] 402.1 ms (6 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 2 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:43+05:00 INFO metabase.query-processor.middleware.cache Query took 977.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:43+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/1377 202 [ASYNC: completed] 1.0 s (6 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 1 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:46+05:00 INFO metabase.query-processor.middleware.cache Query took 4.0 s to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:14:46+05:00 DEBUG metabase.middleware.log GET /api/public/dashboard/36a87ce7-a457-4d6c-a3ff-a75515686d7c/card/795 202 [ASYNC: completed] 4.2 s (6 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:15+05:00 DEBUG metabase.middleware.log GET /api/user/current 200 45.4 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:15+05:00 DEBUG metabase.middleware.log GET /api/session/properties 200 26.2 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:15+05:00 DEBUG metabase.middleware.log GET /api/database 200 55.9 ms (4 DB calls) App DB connections: 1/15 Jetty threads: 6/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:15+05:00 DEBUG metabase.middleware.log GET /api/collection/root/items 200 46.5 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:15+05:00 DEBUG metabase.middleware.log GET /api/collection/root 200 9.8 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:16+05:00 DEBUG metabase.middleware.log GET /api/collection/36 200 14.7 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:17+05:00 DEBUG metabase.middleware.log GET /api/collection/36/items 200 17.3 ms (7 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:20+05:00 DEBUG metabase.middleware.log GET /api/dashboard/749 200 23.2 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:26+05:00 DEBUG metabase.middleware.log GET /api/collection/200 200 6.1 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:26+05:00 DEBUG metabase.middleware.log GET /api/collection/200/items 200 19.1 ms (7 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:27+05:00 DEBUG metabase.middleware.log GET /api/dashboard/195 200 46.6 ms (11 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (78 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:27+05:00 INFO metabase.api.card Question’s average execution duration is 87.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:27+05:00 DEBUG metabase.middleware.log POST /api/card/955/query 202 [ASYNC: completed] 207.2 ms (7 DB calls) App DB connections: 3/15 Jetty threads: 5/50 (2 idle, 0 queued) (81 total active threads) Queries in flight: 2 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:27+05:00 DEBUG metabase.middleware.log POST /api/card/956/query 202 [ASYNC: completed] 206.1 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (2 idle, 0 queued) (81 total active threads) Queries in flight: 1 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:27+05:00 INFO metabase.query-processor.middleware.cache Query took 212.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:27+05:00 DEBUG metabase.middleware.log POST /api/card/957/query 202 [ASYNC: completed] 255.8 ms (7 DB calls) App DB connections: 2/15 Jetty threads: 5/50 (2 idle, 0 queued) (81 total active threads) Queries in flight: 1 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:15:28+05:00 DEBUG metabase.middleware.log GET /api/database/34/metadata 200 1.1 s (9 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (81 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:32+05:00 DEBUG metabase.middleware.log GET /api/collection/36 200 6.8 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (4 idle, 0 queued) (71 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:34+05:00 DEBUG metabase.middleware.log GET /api/dashboard/749 200 7.8 ms (4 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (4 idle, 0 queued) (73 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:37+05:00 DEBUG metabase.middleware.log GET /api/collection/3 200 7.4 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (4 idle, 0 queued) (73 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:37+05:00 DEBUG metabase.middleware.log GET /api/collection/3/items 200 13.3 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (4 idle, 0 queued) (73 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:38+05:00 DEBUG metabase.middleware.log GET /api/dashboard/323 200 135.1 ms (33 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (4 idle, 0 queued) (73 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 3.9 s; using ‘magic’ TTL of 39.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 256.0 ms; using ‘magic’ TTL of 3.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 263.0 ms; using ‘magic’ TTL of 3.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 234.0 ms; using ‘magic’ TTL of 2.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 99.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 198.0 ms; using ‘magic’ TTL of 2.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 115.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 102.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 148.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 68.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/862/query 202 [ASYNC: completed] 173.7 ms (7 DB calls) App DB connections: 4/15 Jetty threads: 4/50 (1 idle, 0 queued) (88 total active threads) Queries in flight: 4 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/891/query 202 [ASYNC: completed] 172.1 ms (7 DB calls) App DB connections: 3/15 Jetty threads: 4/50 (1 idle, 0 queued) (88 total active threads) Queries in flight: 4 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 83.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/991/query 202 [ASYNC: completed] 115.6 ms (7 DB calls) App DB connections: 4/15 Jetty threads: 4/50 (1 idle, 0 queued) (88 total active threads) Queries in flight: 3 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/827/query 202 [ASYNC: completed] 220.2 ms (7 DB calls) App DB connections: 2/15 Jetty threads: 4/50 (1 idle, 0 queued) (88 total active threads) Queries in flight: 2 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/989/query 202 [ASYNC: completed] 127.4 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (1 idle, 0 queued) (88 total active threads) Queries in flight: 1 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 51.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 70.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 58.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 40.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 199.0 ms; using ‘magic’ TTL of 2.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 59.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/992/query 202 [ASYNC: completed] 105.8 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (1 idle, 0 queued) (93 total active threads) Queries in flight: 5 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 36.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 20.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1180/query 202 [ASYNC: completed] 55.9 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (1 idle, 0 queued) (93 total active threads) Queries in flight: 4 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 83.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1179/query 202 [ASYNC: completed] 91.7 ms (7 DB calls) App DB connections: 2/15 Jetty threads: 4/50 (1 idle, 0 queued) (93 total active threads) Queries in flight: 3 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 108.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1020/query 202 [ASYNC: completed] 135.4 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (1 idle, 0 queued) (93 total active threads) Queries in flight: 2 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/993/query 202 [ASYNC: completed] 144.7 ms (7 DB calls) App DB connections: 2/15 Jetty threads: 4/50 (1 idle, 0 queued) (93 total active threads) Queries in flight: 1 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 149.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1181/query 202 [ASYNC: completed] 44.1 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (1 idle, 0 queued) (96 total active threads) Queries in flight: 3 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1182/query 202 [ASYNC: completed] 31.7 ms (7 DB calls) App DB connections: 3/15 Jetty threads: 5/50 (1 idle, 0 queued) (96 total active threads) Queries in flight: 2 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 320.0 ms; using ‘magic’ TTL of 3.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 530.0 ms; using ‘magic’ TTL of 5.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 791.0 ms; using ‘magic’ TTL of 8.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 105.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1211/query 202 [ASYNC: completed] 171.0 ms (7 DB calls) App DB connections: 3/15 Jetty threads: 5/50 (1 idle, 0 queued) (99 total active threads) Queries in flight: 4 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 64.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 179.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 65.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 57.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1051/query 202 [ASYNC: completed] 244.9 ms (9 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (1 idle, 0 queued) (100 total active threads) Queries in flight: 5 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1442/query 202 [ASYNC: completed] 128.8 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (1 idle, 0 queued) (101 total active threads) Queries in flight: 4 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 29.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1949/query 202 [ASYNC: completed] 66.2 ms (7 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (1 idle, 0 queued) (101 total active threads) Queries in flight: 3 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 308.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1441/query 202 [ASYNC: completed] 360.9 ms (7 DB calls) App DB connections: 2/15 Jetty threads: 5/50 (1 idle, 0 queued) (101 total active threads) Queries in flight: 2 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.api.card Question’s average execution duration is 82.0 ms; using ‘magic’ TTL of 1000.0 ms
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 INFO metabase.query-processor.middleware.cache Query took 15.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:40+05:00 DEBUG metabase.middleware.log POST /api/card/1987/query 202 [ASYNC: completed] 35.4 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (1 idle, 0 queued) (102 total active threads) Queries in flight: 2 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:41+05:00 INFO metabase.query-processor.middleware.cache Query took 709.0 ms to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:41+05:00 DEBUG metabase.middleware.log POST /api/card/1377/query 202 [ASYNC: completed] 773.8 ms (7 DB calls) App DB connections: 2/15 Jetty threads: 4/50 (1 idle, 0 queued) (102 total active threads) Queries in flight: 1 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:43+05:00 INFO metabase.query-processor.middleware.cache Query took 3.4 s to run; miminum for cache eligibility is 60.0 s
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:16:43+05:00 DEBUG metabase.middleware.log POST /api/card/795/query 202 [ASYNC: completed] 3.4 s (7 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (1 idle, 0 queued) (102 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:34:15+05:00 DEBUG metabase.middleware.log GET /api/setting 200 2.8 ms (0 DB calls) App DB connections: 1/15 Jetty threads: 6/50 (1 idle, 0 queued) (89 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:34:15+05:00 DEBUG metabase.middleware.log GET /api/session/properties 200 11.3 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 7/50 (0 idle, 0 queued) (91 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:34:15+05:00 DEBUG metabase.middleware.log GET /api/setup/admin_checklist 200 21.0 ms (11 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (1 idle, 0 queued) (94 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:34:19+05:00 DEBUG metabase.middleware.log GET /api/util/bug_report_details 200 11.4 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (1 idle, 0 queued) (94 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:34:23+05:00 DEBUG metabase.middleware.log GET /api/task 200 21.5 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (1 idle, 0 queued) (94 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:34:35+05:00 DEBUG metabase.middleware.log GET /api/task/info 200 8.0 ms (0 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (1 idle, 0 queued) (94 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:36:18+05:00 DEBUG metabase.middleware.log GET /api/task/info 200 2.4 ms (0 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (91 total active threads) Queries in flight: 0 (0 queued)
[eef5b448-ed94-4fe3-b2f9-e58a7443b0bc] 2020-09-18T17:36:23+05:00 DEBUG metabase.middleware.log GET /api/util/bug_report_details 200 8.0 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (2 idle, 0 queued) (91 total active threads) Queries in flight: 0 (0 queued)
@kal.el
I was asking for “Diagnostic Info”, not the log.
I can see it’s connecting to Postgres. I guess you weren’t using Postgres before (or a different database, I don’t know your setup), which means that there probably is a metabase.db.mv.db file somewhere on your system, which has data from right before you restarted.
1 Like
i am using PostgreSQL from last 6 months, i migrated from MV to PostgreSQL, you helped me in that as well.
“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/85.0.4183.102 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “1.8.0_242-8u242-b08-0ubuntu3~16.04-b08”,
“java.vendor”: “Private Build”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_242”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “25.242-b08”,
“os.name”: “Linux”,
“os.version”: “4.4.0-171-generic”,
“user.language”: “en”,
“user.timezone”: “Etc/UTC”
},
“metabase-info”: {
“databases”: [
“postgres”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “9.6.17”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.8”
}
},
“run-mode”: “prod”,
“version”: {
“tag”: “v0.35.1”,
“date”: “2020-04-02”,
“branch”: “release-0.35.x”,
“hash”: “e67f169”
},
“settings”: {
“report-timezone”: null
}
}
}
@kal.el
Migration is one thing, running Metabase is another.
So you might have migrated data from H2 to Postgres, but that doesn’t mean that you configured the service to correctly use the Postgres database.
I don’t know your setup or how you configured things, and unless you still have the startup logs from when you started the service 2 months ago (not 6 months ago), then it’s hard to tell which application database it was using.
Check your system for any files called metabase.db.mv.db
i am searching for metabase.db.mv.db in system but i think if it were using this file it should be in same folder as metabase.jar file. but its not there.
i couldn’t find any metabase.db.mv.db in my server.
@kal.el If you have logs from the past couple of days, then there might be some indication of which application database it was using.
Make sure to check all your schemas in Postgres. And if you have multiple Postgres, then make sure you didn’t accidentally configure Metabase to the wrong one.
i checked it, i have only one DB for metabase and its the same i am using right now. also i check every table it has data from a month before but not last month’s data, it all gone.
@kal.el I don’t know where you were writing the application data for two months, but it’s not possible to run Metabase without it connecting to an application database, where Metabase read/writes all it’s information.
its exactly what doesn’t make sense to me. i couldn’t find any MV DB file and i only have one metabase DB in my PostgreSQL server, this DB has all the data before 2 months all questions and dashboards but nothing after that, i also checked by creating a new Dashboard and it saved in it and after restarting server once again it is still there. but i couldn’t find any thing from past two month.
its really strange…!!! all of my work has been lost.