Oracle JDBC Driver

mgalvani · August 2, 2019, 6:34pm

Metabase version: 0.32.10
O.S: Ubuntu
Running: tried both docker and jar mode and had the same error.
Metabase DB: H2
Data Source: Oracle

I’m trying to connect to a Oracle 12c database, but my metabase menu doesn’t show ‘Oracle’ optional when adding a new database.

Said that, I looked for help here and saw a lot of people recommending installing Oracle Drivers on metabase/plugins.
After I did that, everytime I try to start metabase it crashes. If I remove ojdbc(7/8).jar from /plugins, metabase starts normally.

Is there an official driver? Already tried https://metabase.com/docs/v0.32.1/administration-guide/databases/oracle.html

Errors:

- When I start metabase WITHOUT ojdbc8.jar inside /plugins:
08-02 18:32:39 INFO 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.

08-02 18:32:39 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
08-02 18:32:39 INFO plugins.dependencies :: Plugins with unsatisfied deps: [“Metabase Vertica Driver” “Metabase Oracle Driver”]

- When I start metabase WITH ojdbc8.jar inside /plugins:
08-02 18:31:05 INFO metabase.core :: Starting Metabase version v0.32.10 (5d40681 release-0.32.x) …
08-02 18:31:05 INFO metabase.core :: System timezone is ‘Etc/UTC’ …
08-02 18:31:05 INFO metabase.plugins :: Loading plugins in /home/ubuntu/metabase/plugins…
08-02 18:31:05 ERROR metabase.core :: Metabase Initialization FAILED
java.util.zip.ZipException: zip END header not found
at jdk.zipfs/jdk.nio.zipfs.ZipFileSystem.zerror(ZipFileSystem.java:1713)
at jdk.zipfs/jdk.nio.zipfs.ZipFileSystem.findEND(ZipFileSystem.java:1029)
at jdk.zipfs/jdk.nio.zipfs.ZipFileSystem.initCEN(ZipFileSystem.java:1038)
at jdk.zipfs/jdk.nio.zipfs.ZipFileSystem.(ZipFileSystem.java:128)
at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.newFileSystem(ZipFileSystemProvider.java:136)
at java.base/java.nio.file.FileSystems.newFileSystem(FileSystems.java:413)
at metabase.plugins.files$file_exists_in_archive_QMARK_.invokeStatic(files.clj:134)
at metabase.plugins.files$file_exists_in_archive_QMARK_.doInvoke(files.clj:131)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at metabase.plugins$has_manifest_QMARK_.invokeStatic(plugins.clj:107)
at metabase.plugins$has_manifest_QMARK_.invoke(plugins.clj:106)
at clojure.core$sort_by$fn__5978.invoke(core.clj:3131)
at clojure.lang.AFunction.compare(AFunction.java:51)
at java.base/java.util.TimSort.countRunAndMakeAscending(TimSort.java:360)
at java.base/java.util.TimSort.sort(TimSort.java:220)
at java.base/java.util.Arrays.sort(Arrays.java:1441)
at clojure.core$sort.invokeStatic(core.clj:3115)
at clojure.core$sort_by.invokeStatic(core.clj:3119)
at clojure.core$sort_by.invokeStatic(core.clj:3119)
at clojure.core$sort_by.invoke(core.clj:3119)
at metabase.plugins$init_plugins_BANG_.invokeStatic(plugins.clj:115)
at metabase.plugins$init_plugins_BANG_.invoke(plugins.clj:109)
at metabase.plugins$load_plugins_BANG_.invokeStatic(plugins.clj:137)
at metabase.plugins$load_plugins_BANG_.invoke(plugins.clj:121)
at metabase.core$init_BANG_.invokeStatic(core.clj:67)
at metabase.core$init_BANG_.invoke(core.clj:55)
at metabase.core$start_normally.invokeStatic(core.clj:122)
at metabase.core$start_normally.invoke(core.clj:116)
at metabase.core$_main.invokeStatic(core.clj:142)
at metabase.core$_main.doInvoke(core.clj:137)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
08-02 18:31:05 INFO metabase.core :: Metabase Shutting Down …
08-02 18:31:05 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
08-02 18:31:05 INFO metabase.core :: Metabase Shutdown COMPLETE

flamber · August 2, 2019, 6:50pm

Hi @mgalvani
Interesting, it seems one of the drivers or perhaps the metabase.jar is corrupted.

Can you verify that the metabase.jar matches this checksum 360b97a4d9c948388e054d2e1fe5f309f527bf174073bc3a20f9a6a837e7fc37 ?

Run sha256sum metabase.jar
And can you also run sha256sum/home/ubuntu/metabase/plugins/* just to check the drivers - post the result here.

Also, it might be related to this issue, since both 0.32.10 and 0.33.0-RC1 are using a lot of the same core code:
https://github.com/metabase/metabase/issues/10475

mgalvani · August 2, 2019, 7:02pm

Hey there!

First of all, thanks a lot for your time.

I’m not sure if it is related with the issue you mentioned. I tried with 0.31 version and it didn’t work as well.
Metabase doesn’t recognize oracle plugin when it’s started.
I’m currently using Java 8. Will try to use Java 10 to see what happens.

There it goes:

360b97a4d9c948388e054d2e1fe5f309f527bf174073bc3a20f9a6a837e7fc37 metabase.jar

4d737c00430c0c185818ff3847a5cd44e6ff7083b483e9cc70ae4e6fdcf4b993 /home/ubuntu/metabase/plugins/bigquery.metabase-driver.jar
65cac8c4b5f3b0fb604b78d2dc16b64754a13914f4c4b3c4f9f180c02109c943 /home/ubuntu/metabase/plugins/druid.metabase-driver.jar
75c818e708509e6bbefb091fcbd8210740a0aabd7e7dc5a83cc815186b753527 /home/ubuntu/metabase/plugins/google.metabase-driver.jar
ea42217b87dbf9880bc80df106910494c3a7e9a6f52580c356e9b56ab0be3de9 /home/ubuntu/metabase/plugins/googleanalytics.metabase-driver.jar
91f1089be4414e342b2b3ffc7221201ca62a7d47ca3971205db62c0559283d75 /home/ubuntu/metabase/plugins/mongo.metabase-driver.jar
8de61002636f3eab96d6653d2aa0e372646da79dfabfbf1a4791e1713068bc1b /home/ubuntu/metabase/plugins/oracle.metabase-driver.jar
bce6ec3a77d55a0fc10d8d73fd51691e0de951558d256a48d829918ac006afa3 /home/ubuntu/metabase/plugins/presto.metabase-driver.jar
b21ce85a61e1a004261f0b1b5a135df4d02017cb9461b75da3a51c5359a1cb83 /home/ubuntu/metabase/plugins/redshift.metabase-driver.jar
9b33a19d6f77b09a8cba22bd16c40faab85d524766e6a62c43800921b235ac9e /home/ubuntu/metabase/plugins/snowflake.metabase-driver.jar
75ed3461bcc6b4eeaa35f4d9f8ea1aeab92027a311703f394280d095ec84942b /home/ubuntu/metabase/plugins/sparksql.metabase-driver.jar
17d2e3a14c3d13b9766225e8cec30dc935272140c1937c7411d09a7e47c2e794 /home/ubuntu/metabase/plugins/sqlite.metabase-driver.jar
2acceeb2603c7d44814164c233ffef276e13af78316c479f8eac7ff595834466 /home/ubuntu/metabase/plugins/sqlserver.metabase-driver.jar
7ebf44bf63ba2af4e9ae24473b91527d1d3666620737cda7845fea6af108fba6 /home/ubuntu/metabase/plugins/vertica.metabase-driver.jar

flamber · August 2, 2019, 7:14pm

@mgalvani
Okay, do not try Java 10 - either use Java 8 or Java 11. Are you using the latest Java 8u221?
Remember to backup your metadata (your H2 database) before attempting to downgrade, since it might corrupt your metadata.
You could try 0.32.9 instead.
Can you also post the checksum of ojdbc8.jar, since Metabase is only failing when you add that - or maybe you should try downloading it again.

EDIT: The sha1sum ojdbc8.jar should be 60f439fd01536508df32658d0a416c49ac6f07fb

camsaul · August 14, 2019, 6:40pm

@mgalvani did using Java 11 work for you?

camsaul · August 14, 2019, 7:11pm

@mgalvani I was able to connect to Oracle with no problem with a fresh install of Metabase 0.32.10 (using the JAR) and ojdbc8.jar from here https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/jdbc-ucp-19c-5460552.html

I think the file you downloaded is incomplete or otherwise corrupted. The SHA1 sum for the version I downloaded is 967c0b1a2d5b1435324de34a9b8018d294f8f47b

flamber · August 14, 2019, 7:17pm

@camsaul Should the Oracle link in the docs be changed to something more generic?
https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html

camsaul · August 14, 2019, 7:17pm

Yeah, probably

camsaul · August 14, 2019, 7:18pm

@flamber want to open a PR?

ami · August 19, 2019, 9:50pm

I’m also having this issue since uprading to 32.10. Tried with both openjdk 8 and 11, no dice.

flamber · August 19, 2019, 10:01pm

Hi @ami
What issues are you having specially? Are you seeing errors?
Have you tried with Oracle Java instead of OpenJDK?
Which version of Oracle JDBC driver are you trying with?
Can you post the Metabase log from the startup - specifically all the INFO plugins.* is interesting.

ami · August 20, 2019, 3:46pm

Hi! I was getting these: java.util.zip.ZipException: zip END header not found

I built out a new VM with java 11 (instead of 8) and started from scratch. Now it’s working.

mgalvani · August 21, 2019, 11:33pm

Hey there!

The problem actually was my ojdbc7.jar file.

Solution is: on oracle website, download instant_client for the exact same version of the database you want to connect to.
Example: my database ir oracle 12c, so I download ‘Instant client for oracle 12c’.
Once I extracted the instant_client.zip file to /opt/oracle it gave me both ‘ojbc7.jar’ and ‘ojdbc8.jar’ files.

All I had to do was ‘# cp ojdbc7.jar /path-to-metabase/plugins’

Didn’t have to set any environment variable or other changes.

I think the great secret here is to use the same ojdbc*.jar file that’s zipped inside instant_client.zip.

@ami try this method with java 8. It would be nice if you could start a fresh ubuntu instance to remove possible dirty you might have with old files and version.

If you need more help, reach me on twitter.com/mgalvani

wagnerflores · October 2, 2020, 8:38pm

Estou com o mesmo problema! Já tentei de tudo, copiei o odbc do instant_client e eliminou o problema de travar a aplicação mas ainda nao aparece a opção do banco oracle para escolher

IvanSilverio · June 2, 2022, 5:19pm

I have the same problem.

Created the app/plugins directory
I copied the ojdbc8.jar from
https://download.oracle.com/otn-pub/otn_software/jdbc/215/ojdbc8.jar

Version: v0.43.1

Using Docker

Error log:

[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-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.

[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins.dependencies Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Presto JDBC Driver" "Metabase Oracle Driver" "Metabase Vertica Driver" "Metabase Presto Driver"]
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 DEBUG metabase.plugins.lazy-loaded-driver Regist

flamber · June 2, 2022, 5:20pm

@IvanSilverio
Post "Diagnostic Info" from Admin > Troubleshooting.

IvanSilverio · June 2, 2022, 7:25pm

[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.core 
Metabase v0.43.1 (7f1a1c4 release-x.43.x) 

Copyright © 2022 Metabase, Inc. 

Metabase Enterprise Edition extensions are NOT PRESENT.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.core Starting Metabase in STANDALONE mode
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.server Launching Embedded Jetty Webserver with config: 
 {:port 3000, :host "0.0.0.0"}

[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.core Starting Metabase version v0.43.1 (7f1a1c4 release-x.43.x) ...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.core System info:
 {"file.encoding" "UTF-8",
 "java.runtime.name" "OpenJDK Runtime Environment",
 "java.runtime.version" "11.0.15+10",
 "java.vendor" "Eclipse Adoptium",
 "java.vendor.url" "https://adoptium.net/",
 "java.version" "11.0.15",
 "java.vm.name" "OpenJDK 64-Bit Server VM",
 "java.vm.version" "11.0.15+10",
 "os.name" "Linux",
 "os.version" "5.17.5-300.fc36.x86_64",
 "user.language" "en",
 "user.timezone" "GMT"}

[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins Loading plugins in /plugins...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :hive-like...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.driver.impl Registered abstract driver :hive-like (parents: [:sql-jdbc]) 🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sparksql...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.driver.impl Registered driver :sparksql (parents: [:hive-like]) 🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlserver...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.driver.impl Registered driver :sqlserver (parents: [:sql-jdbc]) 🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins.dependencies Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins.dependencies Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? false
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Presto JDBC Driver"]
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlite...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.driver.impl Registered driver :sqlite (parents: [:sql-jdbc]) 🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-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.

[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins.dependencies Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Presto JDBC Driver" "Metabase Vertica Driver"]
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :redshift...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.driver.impl Registered driver :redshift (parents: [:postgres]) 🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins.dependencies Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? false
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins.dependencies Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Presto JDBC Driver" "Metabase Vertica Driver" "Metabase Presto Driver"]
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :druid...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.driver.impl Registered driver :druid  🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :mongo...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.driver.impl Registered driver :mongo  🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-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.

[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:58-03:00 INFO metabase.plugins.dependencies Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Presto JDBC Driver" "Metabase Oracle Driver" "Metabase Vertica Driver" "Metabase Presto Driver"]
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :snowflake...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.driver.impl Registered driver :snowflake (parents: [:sql-jdbc]) 🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :googleanalytics...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.driver.impl Registered driver :googleanalytics  🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery-cloud-sdk...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.driver.impl Registered driver :bigquery-cloud-sdk (parents: [:sql]) 🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-common...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.driver.impl Registered abstract driver :presto-common  🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.plugins.dependencies Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.plugins.dependencies Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 DEBUG metabase.plugins.initialize Dependencies satisfied; these plugins will now be loaded: ["Metabase Presto Driver" "Metabase Presto JDBC Driver"]
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.driver.impl Registered driver :presto (parents: [:presto-common]) 🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-jdbc...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.driver.impl Registered driver :presto-jdbc (parents: [:presto-common]) 🚚
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.core Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.db.setup Verifying h2 Database Connection ...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.db.setup Successfully verified H2 1.4.197 (2018-03-18) application database connection. ✅
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.db.setup Running Database Migrations...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:34:59-03:00 INFO metabase.db.setup Setting up Liquibase...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:00-03:00 INFO metabase.db.setup Liquibase is ready.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:00-03:00 INFO metabase.db.liquibase Checking if Database has unrun migrations...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.db.setup Database Migrations Current ...  ✅
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.db.data-migrations Running all necessary data migrations, this may take a minute.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.db.data-migrations Finished running data migrations.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.util Database setup took 3.0 s
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.dependencies/Dependencies 👂
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.activity-feed/ActivityFeed 👂
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.last-login/LastLogin 👂
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.notifications/Notifications 👂
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.sync-database/Sync 👂
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.driver-notifications/DriverNotifications 👂
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.revision/Revisions 👂
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.events Inicializando listener de eventos: :metabase.events.view-log/ViewLog 👂
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO org.quartz.impl.StdSchedulerFactory Using default implementation for ThreadExecutor
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO org.quartz.core.SchedulerSignalerImpl Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO org.quartz.core.QuartzScheduler Quartz Scheduler v.2.3.2 created.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO org.quartz.impl.jdbcjobstore.JobStoreTX Using db table-based data access locking (synchronization).
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO org.quartz.impl.jdbcjobstore.JobStoreTX JobStoreTX initialized.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO org.quartz.core.QuartzScheduler Scheduler meta-data: Quartz Scheduler (v2.3.2) 'MetabaseScheduler' with instanceId 'e8f12aae6a481654086902311'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  Using job-store 'org.quartz.impl.jdbcjobstore.JobStoreTX' - which supports persistence. and is clustered.

[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO org.quartz.impl.StdSchedulerFactory Quartz scheduler 'MetabaseScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO org.quartz.impl.StdSchedulerFactory Quartz scheduler version: 2.3.2
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO org.quartz.core.QuartzScheduler Scheduler MetabaseScheduler_$_e8f12aae6a481654086902311 paused.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.util.i18n.impl Reading available locales from locales.clj...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task Task scheduler initialized into standby mode.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task Iniciando tarefa SyncDatabases 📆
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.models.database A agenda de sinc/análise do banco de dados :h2  'Sample Database' mudou! 
 Metadado de Sinc era: "0 50 * * * ? *", agora é: "0 36 * * * ? *" 
 Valor do Campo de Cache era: "0 50 0 * * ? *", agora é: "0 0 1 * * ? *"
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task.sync-databases Scheduling sync/analyze for database 1: trigger: metabase.task.sync-and-analyze.trigger.1
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task.sync-databases Scheduling field-values for database 1: trigger: metabase.task.update-field-values.trigger.1
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.driver.impl Inicializando driver :sql...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.driver.impl Inicializando driver :sql-jdbc...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.driver.impl Inicializando driver :h2...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.models.database A agenda de sinc/análise do banco de dados :sqlserver  'Tabela Cidadão - View Processo.Rio' mudou! 
 Metadado de Sinc era: "0 50 * * * ? *", agora é: "0 1 * * * ? *" 
 Valor do Campo de Cache era: "0 50 0 * * ? *", agora é: "0 0 12 * * ? *"
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task.sync-databases Scheduling sync/analyze for database 2: trigger: metabase.task.sync-and-analyze.trigger.2
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task.sync-databases Scheduling field-values for database 2: trigger: metabase.task.update-field-values.trigger.2
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task.sync-databases Updated default schedules for 2 databases
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task Iniciando tarefa CheckForNewVersions 📆
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task Iniciando tarefa SendAnonymousUsageStats 📆
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task Iniciando tarefa RefreshSlackChannelsAndUsers 📆
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task Iniciando tarefa SendAbandomentEmails 📆
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task Iniciando tarefa SendPulses 📆
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task Iniciando tarefa SendFollowUpEmails 📆
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:02-03:00 INFO metabase.task Iniciando tarefa TaskHistoryCleanup 📆
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:03-03:00 INFO org.quartz.impl.jdbcjobstore.JobStoreTX ClusterManager: Scanning for instance "e8f12aae6a481654000310317"'s failed in-progress jobs.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:03-03:00 INFO org.quartz.impl.jdbcjobstore.JobStoreTX ClusterManager: detected 1 failed or restarted instances.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:03-03:00 INFO org.quartz.core.QuartzScheduler Scheduler MetabaseScheduler_$_e8f12aae6a481654086902311 started.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:03-03:00 INFO metabase.task Task scheduler started
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:03-03:00 INFO metabase.core Inicialização do Metabase COMPLETA
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:03-03:00 INFO metabase.task.refresh-slack-channel-user-cache O Slack não está configurado, não será possível atualizar o cache de usuários e canais.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:07-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 73.5 ms (5 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 5 / 50 (2 ocioso, 0 na fila) (39 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:07-03:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 562.4 ms (10 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 4 / 50 (1 ocioso, 0 na fila) (42 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:08-03:00 DEBUG metabase.server.middleware.log GET /api/bookmark 200 78.5 ms (1 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 2 / 4 Threads do Jetty: 9 / 50 (1 ocioso, 0 na fila) (45 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:08-03:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 113.9 ms (5 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 3 / 4 Threads do Jetty: 9 / 50 (1 ocioso, 0 na fila) (45 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:08-03:00 DEBUG metabase.server.middleware.log GET /api/database 200 179.3 ms (3 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 8 / 50 (1 ocioso, 0 na fila) (45 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:08-03:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 347.8 ms (2 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 2 / 4 Threads do Jetty: 6 / 50 (1 ocioso, 0 na fila) (45 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:08-03:00 DEBUG metabase.server.middleware.log GET /api/activity/recent_views 200 286.2 ms (8 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 5 / 50 (2 ocioso, 0 na fila) (45 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:08-03:00 DEBUG metabase.server.middleware.log GET /api/activity/popular_items 200 330.3 ms (10 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 5 / 50 (2 ocioso, 0 na fila) (45 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:18-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 60.2 ms (5 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 5 / 50 (4 ocioso, 0 na fila) (45 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:18-03:00 DEBUG metabase.server.middleware.log GET /api/setting 200 60.7 ms (4 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 4 / 50 (4 ocioso, 0 na fila) (45 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:18-03:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 38.6 ms (11 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 4 / 50 (4 ocioso, 0 na fila) (45 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:35:30-03:00 DEBUG metabase.server.middleware.log GET /api/database 200 19.0 ms (3 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 4 / 50 (4 ocioso, 0 na fila) (45 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.task.sync-databases Iniciando tarefa de sincronização para o Banco de Dados 1.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util STARTING: Sync metadata for h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-timezone' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-timezone' para h2 Banco de dados 1 'Sample Database' (479.6 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-tables' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.sync-metadata.tables Atualizando descrições para as tabelas: (Tabela  'PUBLIC.PEOPLE' Tabela  'PUBLIC.REVIEWS' Tabela  'PUBLIC.ORDERS' Tabela  'PUBLIC.PRODUCTS')
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-tables' para h2 Banco de dados 1 'Sample Database' (59.4 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-fields' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-fields' para h2 Banco de dados 1 'Sample Database' (223.2 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-fks' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-fks' para h2 Banco de dados 1 'Sample Database' (20.5 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-metabase-metadata' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-metabase-metadata' para h2 Banco de dados 1 'Sample Database' (129.8 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:01-03:00 INFO metabase.sync.util FINISHED: Sync metadata for h2 Banco de dados 1 'Sample Database' (962.2 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:01-03:00 INFO metabase.sync.util STARTING: Analyze data for h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T09:36:01-03:00 INFO metabase.sync.util STARTING: passo 'fingerprint-fields' para h2 Banco de dados 1 'Sample Database'
[
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:00-03:00 DEBUG metabase.plugins.jdbc-proxy Registrando driver de proxy JDBC para com.microsoft.sqlserver.jdbc.SQLServerDriver...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:00-03:00 INFO metabase.util Carregando Metabase driver :sqlserver took 96.9 ms
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-timezone' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-timezone' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (485.3 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-tables' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:02-03:00 INFO metabase.sync.util FINISHED: passo 'sync-tables' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (1.6 s)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:02-03:00 INFO metabase.sync.util STARTING: passo 'sync-fields' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:02-03:00 INFO metabase.sync.util FINISHED: passo 'sync-fields' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (99.6 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:02-03:00 INFO metabase.sync.util STARTING: passo 'sync-fks' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:02-03:00 INFO metabase.sync.util FINISHED: passo 'sync-fks' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (19.9 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:02-03:00 INFO metabase.sync.util STARTING: passo 'sync-metabase-metadata' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.util FINISHED: passo 'sync-metabase-metadata' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (1.5 s)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.util FINISHED: Sync metadata for sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (3.8 s)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.util STARTING: Analyze data for sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.util STARTING: passo 'fingerprint-fields' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [************······································] 😒   25% Tabela 5 'TCidadao.vw_cidadao_ProcessoRio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.util FINISHED: passo 'fingerprint-fields' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (6.3 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.util STARTING: passo 'classify-fields' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.analyze classify-fields Analyzed [*************************·························] 😬   50% Tabela 5 'TCidadao.vw_cidadao_ProcessoRio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.util FINISHED: passo 'classify-fields' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (3.0 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.util STARTING: passo 'classify-tables' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.analyze classify-tables Analyzed [*************************************·············] 😋   75% Tabela 5 'TCidadao.vw_cidadao_ProcessoRio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.util FINISHED: passo 'classify-tables' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (4.0 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:01:03-03:00 INFO metabase.sync.util FINISHED: Analyze data for sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (25.7 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.task.sync-databases Iniciando tarefa de sincronização para o Banco de Dados 1.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util STARTING: Sync metadata for h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-timezone' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-timezone' para h2 Banco de dados 1 'Sample Database' (8.4 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-tables' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.sync-metadata.tables Atualizando descrições para as tabelas: (Tabela  'PUBLIC.PEOPLE' Tabela  'PUBLIC.REVIEWS' Tabela  'PUBLIC.ORDERS' Tabela  'PUBLIC.PRODUCTS')
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-tables' para h2 Banco de dados 1 'Sample Database' (19.0 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-fields' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-fields' para h2 Banco de dados 1 'Sample Database' (131.8 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-fks' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-fks' para h2 Banco de dados 1 'Sample Database' (13.5 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-metabase-metadata' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-metabase-metadata' para h2 Banco de dados 1 'Sample Database' (125.4 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util FINISHED: Sync metadata for h2 Banco de dados 1 'Sample Database' (314.4 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util STARTING: Analyze data for h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.util STARTING: passo 'fingerprint-fields' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T10:36:00-03:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [*******···········································] 😞   15% Tabela 2 'PUBLIC.ORDERS'

[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-01T12:01:03-03:00 INFO metabase.sync.util FINISHED: Analyze data for sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (18.1 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:17:22-03:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 32.0 ms (11 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 6 / 50 (1 ocioso, 0 na fila) (48 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:17:22-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 115.3 ms (5 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 1 / 4 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (48 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:17:22-03:00 DEBUG metabase.server.middleware.log GET /api/setting 200 135.0 ms (4 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (48 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:17:24-03:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 13.9 ms (11 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 6 / 50 (1 ocioso, 0 na fila) (50 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:17:24-03:00 DEBUG metabase.server.middleware.log GET /api/setting 200 42.5 ms (4 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (50 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:17:24-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 39.4 ms (5 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 4 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (50 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:17:25-03:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 33.7 ms (11 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) (50 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:17:25-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 43.5 ms (5 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) (50 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:17:25-03:00 DEBUG metabase.server.middleware.log GET /api/setting 200 62.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) (50 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:17:46-03:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 4.9 ms (1 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) (50 total de threads ativas) Consultas ativas: 0 (0 na fila)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:23:48-03:00 INFO org.quartz.impl.jdbcjobstore.JobStoreTX Handling 8 trigger(s) that missed their scheduled fire-time.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:23:48-03:00 INFO metabase.task.send-pulses Enviando pulsos agendados...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:23:54-03:00 ERROR metabase.task.upgrade-checks Erro ao buscar informação sobre versão; usando nil como valor de version-info
java.net.UnknownHostException: static.metabase.com: Try again
	at java.base/java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method)
	at java.base/java.net.InetAddress$PlatformNameService.lookupAllHostAddr(Unknown Source)
	at java.base/java.net.InetAddress.getAddressesFromNameService(Unknown Source)
	at java.base/java.net.InetAddress$NameServiceAddresses.get(Unknown Source)
	at java.base/java.net.InetAddress.getAllByName0(Unknown Source)
	at java.base/java.net.InetAddress.getAllByName(Unknown Source)
	at java.base/java.net.InetAddress.getAllByName(Unknown Source)
	at org.apache.http.impl.conn.SystemDefaultDnsResolver.resolve(SystemDefaultDnsResolver.java:45)
	at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:112)
	at org.apache.http.impl.conn.BasicHttpClientConnectionManager.connect(BasicHttpClientConnectionManager.java:313)
	at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:393)
	at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:236)
	at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186)
	at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)
	at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110)
	at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)
	at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)
	at clj_http.core$request.invokeStatic(core.clj:621)
	at clj_http.core$request.invoke(core.clj:546)
	at clj_http.core$request.invokeStatic(core.clj:547)
	at clj_http.core$request.invoke(core.clj:546)
	at clojure.lang.Var.invoke(Var.java:384)
	at clj_http.client$wrap_request_timing$fn__32215.invoke(client.clj:1083)
	at clj_http.headers$wrap_header_map$fn__31309.invoke(headers.clj:152)
	at clj_http.client$wrap_query_params$fn__32105.invoke(client.clj:817)
	at clj_http.client$wrap_basic_auth$fn__32111.invoke(client.clj:840)
	at clj_http.client$wrap_oauth$fn__32116.invoke(client.clj:857)
	at clj_http.client$wrap_user_info$fn__32125.invoke(client.clj:877)
	at clj_http.client$wrap_url$fn__32197.invoke(client.clj:1035)
	at clj_http.client$wrap_decompression$fn__31892.invoke(client.clj:416)
	at clj_http.client$wrap_input_coercion$fn__32017.invoke(client.clj:630)
	at clj_http.client$wrap_additional_header_parsing$fn__32042.invoke(client.clj:685)
	at clj_http.client$wrap_output_coercion$fn__32004.invoke(client.clj:574)
	at clj_http.client$wrap_exceptions$fn__31845.invoke(client.clj:250)
	at clj_http.client$wrap_accept$fn__32057.invoke(client.clj:728)
	at clj_http.client$wrap_accept_encoding$fn__32064.invoke(client.clj:750)
	at clj_http.client$wrap_content_type$fn__32051.invoke(client.clj:711)
	at clj_http.client$wrap_form_params$fn__32162.invoke(client.clj:959)
	at clj_http.client$wrap_nested_params$fn__32183.invoke(client.clj:993)
	at clj_http.client$wrap_flatten_nested_params$fn__32192.invoke(client.clj:1017)
	at clj_http.client$wrap_method$fn__32130.invoke(client.clj:893)
	at clj_http.cookies$wrap_cookies$fn__31221.invoke(cookies.clj:128)
	at clj_http.links$wrap_links$fn__31649.invoke(links.clj:63)
	at clj_http.client$wrap_unknown_host$fn__32200.invoke(client.clj:1046)
	at clj_http.client$request_STAR_.invokeStatic(client.clj:1174)
	at clj_http.client$request_STAR_.invoke(client.clj:1167)
	at clj_http.client$get.invokeStatic(client.clj:1180)
	at clj_http.client$get.doInvoke(client.clj:1176)
	at clojure.lang.RestFn.invoke(RestFn.java:423)
	at metabase.task.upgrade_checks$get_version_info.invokeStatic(upgrade_checks.clj:18)
	at metabase.task.upgrade_checks$get_version_info.invoke(upgrade_checks.clj:15)
	at metabase.task.upgrade_checks.CheckForNewVersions.execute(upgrade_checks.clj:30)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:23:54-03:00 ERROR metabase.analytics.stats O envio de estatísticas de uso falhou
java.net.UnknownHostException: xuq0fbkk0j.execute-api.us-east-1.amazonaws.com: Try again
	at java.base/java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method)
	at java.base/java.net.InetAddress$PlatformNameService.lookupAllHostAddr(Unknown Source)
	at java.base/java.net.InetAddress.getAddressesFromNameService(Unknown Source)
	at java.base/java.net.InetAddress$NameServiceAddresses.get(Unknown Source)
	at java.base/java.net.InetAddress.getAllByName0(Unknown Source)
	at java.base/java.net.InetAddress.getAllByName(Unknown Source)
	at java.base/java.net.InetAddress.getAllByName(Unknown Source)
	at org.apache.http.impl.conn.SystemDefaultDnsResolver.resolve(SystemDefaultDnsResolver.java:45)
	at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:112)
	at org.apache.http.impl.conn.BasicHttpClientConnectionManager.connect(BasicHttpClientConnectionManager.java:313)
	at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:393)
	at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:236)
	at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186)
	at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)
	at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110)
	at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)
	at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)
	at clj_http.core$request.invokeStatic(core.clj:621)
	at clj_http.core$request.invoke(core.clj:546)
	at clj_http.core$request.invokeStatic(core.clj:547)
	at clj_http.core$request.invoke(core.clj:546)
	at clojure.lang.Var.invoke(Var.java:384)
	at clj_http.client$wrap_request_timing$fn__32215.invoke(client.clj:1083)
	at clj_http.headers$wrap_header_map$fn__31309.invoke(headers.clj:152)
	at clj_http.client$wrap_query_params$fn__32105.invoke(client.clj:817)
	at clj_http.client$wrap_basic_auth$fn__32111.invoke(client.clj:840)
	at clj_http.client$wrap_oauth$fn__32116.invoke(client.clj:857)
	at clj_http.client$wrap_user_info$fn__32125.invoke(client.clj:877)
	at clj_http.client$wrap_url$fn__32197.invoke(client.clj:1035)
	at clj_http.client$wrap_decompression$fn__31892.invoke(client.clj:416)
	at clj_http.client$wrap_input_coercion$fn__32017.invoke(client.clj:630)
	at clj_http.client$wrap_additional_header_parsing$fn__32042.invoke(client.clj:685)
	at clj_http.client$wrap_output_coercion$fn__32004.invoke(client.clj:574)
	at clj_http.client$wrap_exceptions$fn__31845.invoke(client.clj:250)
	at clj_http.client$wrap_accept$fn__32057.invoke(client.clj:728)
	at clj_http.client$wrap_accept_encoding$fn__32064.invoke(client.clj:750)
	at clj_http.client$wrap_content_type$fn__32051.invoke(client.clj:711)
	at clj_http.client$wrap_form_params$fn__32162.invoke(client.clj:959)
	at clj_http.client$wrap_nested_params$fn__32183.invoke(client.clj:993)
	at clj_http.client$wrap_flatten_nested_params$fn__32192.invoke(client.clj:1017)
	at clj_http.client$wrap_method$fn__32130.invoke(client.clj:893)
	at clj_http.cookies$wrap_cookies$fn__31221.invoke(cookies.clj:128)
	at clj_http.links$wrap_links$fn__31649.invoke(links.clj:63)
	at clj_http.client$wrap_unknown_host$fn__32200.invoke(client.clj:1046)
	at clj_http.client$request_STAR_.invokeStatic(client.clj:1174)
	at clj_http.client$request_STAR_.invoke(client.clj:1167)
	at clj_http.client$post.invokeStatic(client.clj:1192)
	at clj_http.client$post.doInvoke(client.clj:1188)
	at clojure.lang.RestFn.invoke(RestFn.java:423)
	at metabase.analytics.stats$send_stats_BANG_.invokeStatic(stats.clj:397)
	at metabase.analytics.stats$send_stats_BANG_.invoke(stats.clj:393)
	at metabase.analytics.stats$phone_home_stats_BANG_.invokeStatic(stats.clj:406)
	at metabase.analytics.stats$phone_home_stats_BANG_.invoke(stats.clj:402)
	at metabase.task.send_anonymous_stats.SendAnonymousUsageStats.execute(send_anonymous_stats.clj:18)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:36:00-03:00 INFO metabase.task.sync-databases Iniciando tarefa de sincronização para o Banco de Dados 1.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:36:00-03:00 INFO metabase.sync.util STARTING: Sync metadata for h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-timezone' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-timezone' para h2 Banco de dados 1 'Sample Database' (9.0 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-tables' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:36:00-03:00 INFO metabase.sync.sync-metadata.tables Atualizando descrições para as tabelas: (Tabela  'PUBLIC.PEOPLE' Tabela  'PUBLIC.REVIEWS' Tabela  'PUBLIC.ORDERS' Tabela  'PUBLIC.PRODUCTS')
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-tables' para h2 Banco de dados 1 'Sample Database' (18.4 ms)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:36:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-fields' para h2 Banco de dados 1 'Sample Database'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T07:36:00-03:00 INFO metabase.sync.util FINISHED: passo 'sync-fields' para h2 Banco de dados 1 'Sample Database' (84.3 ms)

....


[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:00:00-03:00 INFO metabase.sync.util STARTING: passo 'update-field-values' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:00:00-03:00 INFO metabase.task.send-pulses Enviando pulsos agendados...
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:01:00-03:00 INFO metabase.task.sync-databases Iniciando tarefa de sincronização para o Banco de Dados 2.
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:01:00-03:00 INFO metabase.sync.util STARTING: Sync metadata for sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:01:00-03:00 INFO metabase.sync.util STARTING: passo 'sync-timezone' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:02:46-03:00 INFO metabase.sync.util FINISHED: passo 'sync-timezone' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (1.8 mins)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:02:46-03:00 INFO metabase.sync.util FINISHED: Sync metadata for sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio' (1.8 mins)
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:02:46-03:00 INFO metabase.sync.util STARTING: Analyze data for sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:02:46-03:00 INFO metabase.sync.util STARTING: passo 'fingerprint-fields' para sqlserver Banco de dados 2 'Tabela Cidadão - View Processo.Rio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:02:46-03:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [************······································] 😒   25% Tabela 5 'TCidadao.vw_cidadao_ProcessoRio'
[286c80b8-3a1b-4531-9f95-1d4ba16bc6f2] 2022-06-02T09:02:46-03:00 ERROR metabase.models.field-values Erro ao buscar valores de campo
java.sql.SQLException: Connections could not be acquired from the underlying database!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
	at metabase.driver.sql_jdbc.execute$fn__53779.invokeStatic(execute.clj:190)
	at metabase.driver.sql_jdbc.execute$fn__53779.invoke(execute.clj:188)
	at clojure.lang.MultiFn.invoke(MultiFn.java:239)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:497)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)
	at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)
	at metabase.driver.sql_jdbc$fn__83551.invokeStatic(sql_jdbc.clj:54)
	at metabase.driver.sql_jdbc$fn__83551.invoke(sql_jdbc.clj:52)
	at clojure.lang.MultiFn.invoke(MultiFn.java:244)
	at metabase.query_processor.context$executef.invokeStatic(context.clj:59)
	at metabase.query_processor.context$executef.invoke(context.clj:48)
	at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:67)
	at metabase.query_processor.context.default$default_runf.invoke(default.clj:65)
	at metabase.query_processor.context$runf.invokeStatic(context.clj:45)
	at metabase.query_processor.context$runf.invoke(context.clj:39)
	at metabase.query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)
	at metabase.query_processor.reducible$identity_qp.invoke(reducible.clj:9)
	at metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___51444.invoke(cache.clj:220)
	at metabase.query_processor.middleware.permissions$check_query_permissions$fn__47226.invoke(permissions.clj:109)
	at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__50385.invoke(mbql_to_native.clj:23)
	at metabase.query_processor$fn__52917$combined_post_process__52922$combined_post_process_STAR___52923.invoke(query_processor.clj:207)
	at metabase.query_processor$fn__52917$combined_pre_process__52918$combined_pre_process_STAR___52919.invoke(query_processor.clj:204)
	at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51365$fn__51370.invoke(resolve_database_and_driver.clj:35)
	at metabase.driver$do_with_driver.invokeStatic(driver.clj:75)
	at metabase.driver$do_with_driver.invoke(driver.clj:71)
	at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51365.invoke(resolve_database_and_driver.clj:34)
	at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47469.invoke(fetch_source_query.clj:281)
	at metabase.query_processor.middleware.store$initialize_store$fn__47657$fn__47658.invoke(store.clj:11)
	at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:44)
	at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
	at metabase.query_processor.middleware.store$initialize_store$fn__47657.invoke(store.clj:10)
	at metabase.query_processor.middleware.normalize_query$normalize$fn__51637.invoke(normalize_query.clj:22)
	at metabase.query_processor.reducible$async_qp$qp_STAR___44196$thunk__44198.invoke(reducible.clj:100)
	at metabase.query_processor.reducible$async_qp$qp_STAR___44196.invoke(reducible.clj:106)
	at metabase.query_processor.reducible$async_qp$qp_STAR___44196.invoke(reducible.clj:91)
	at metabase.query_processor.reducible$async_qp$qp_STAR___44196.invoke(reducible.clj:88)
	at clojure.lang.AFn.applyToHelper(AFn.java:154)
	at clojure.lang.AFn.applyTo(AFn.java:144)
	at clojure.core$apply.invokeStatic(core.clj:667)
	at clojure.core$apply.invoke(core.clj:662)
	at metabase.query_processor.reducible$sync_qp$qp_STAR___44207.doInvoke(reducible.clj:126)
	at clojure.lang.RestFn.applyTo(RestFn.java:137)
	at clojure.core$apply.invokeStatic(core.clj:669)
	at clojure.core$apply.invoke(core.clj:662)
	at metabase.query_processor$process_query.invokeStatic(query_processor.clj:242)
	at metabase.query_processor$process_query.doInvoke(query_processor.clj:236)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.db.metadata_queries$qp_query$fn__65643.invoke(metadata_queries.clj:21)
	at metabase.db.metadata_queries$qp_query.invokeStatic(metadata_queries.clj:20)
	at metabase.db.metadata_queries$qp_query.invoke(metadata_queries.clj:18)
	at metabase.db.metadata_queries$field_query.invokeStatic(metadata_queries.clj:31)
	at metabase.db.metadata_queries$field_query.invoke(metadata_queries.clj:29)
	at metabase.db.metadata_queries$fn__65663$field_distinct_values__65672$fn__65675.invoke(metadata_queries.clj:76)
	at metabase.db.metadata_queries$fn__65663$field_distinct_values__65672.invoke(metadata_queries.clj:69)
	at metabase.db.metadata_queries$fn__65663$field_distinct_values__65672$fn__65673.invoke(metadata_queries.clj:73)
	at metabase.db.metadata_queries$fn__65663$field_distinct_values__65672.invoke(metadata_queries.clj:69)
	at clojure.lang.Var.invoke(Var.java:384)
	at metabase.models.field_values$distinct_values.invokeStatic(field_values.clj:132)
	at metabase.models.field_values$distinct_values.invoke(field_values.clj:124)
	at metabase.models.field_values$create_or_update_field_values_BANG_.invokeStatic(field_values.clj:154)
	at metabase.models.field_values$create_or_update_field_values_BANG_.doInvoke(field_values.clj:148)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at metabase.sync.field_values$fn__65540$update_field_values_for_field_BANG___65545$fn__65546.invoke(field_values.clj:23)
	at metabase.sync.field_values$fn__65540$update_field_values_for_field_BANG___65545.invoke(field_values.clj:21)
	at metabase.sync.field_values$fn__65566$update_field_values_for_table_BANG___65571$fn__65572$fn__65573$fn__65574.invoke(field_values.clj:44)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
	at metabase.sync.field_values$fn__65566$update_field_values_for_table_BANG___65571$fn__65572$fn__65573.invoke(field_values.clj:42)
	at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
	at clojure.core$reduce.invokeStatic(core.clj:6829)
	at clojure.core$reduce.invoke(core.clj:6812)
	at metabase.sync.field_values$fn__65566$update_field_values_for_table_BANG___65571$fn__65572.invoke(field_values.clj:41)
	at metabase.sync.field_values$fn__65566$update_field_values_for_table_BANG___65571.invoke(field_values.clj:38)
	at clojure.core$map$fn__5884.invoke(core.clj:2757)
	at clojure.lang.LazySeq.sval(LazySeq.java:42)
	at clojure.lang.LazySeq.seq(LazySeq.java:51)
	at clojure.lang.Cons.next(Cons.java:39)
	at clojure.lang.RT.boundedLength(RT.java:1793)
	at clojure.lang.RestFn.applyTo(RestFn.java:130)
	at clojure.core$apply.invokeStatic(core.clj:669)
	at clojure.core$apply.invoke(core.clj:662)
	at metabase.sync.field_values$fn__65593$update_field_values_for_database_BANG___65598$fn__65599.invoke(field_values.clj:52)
	at metabase.sync.field_values$fn__65593$update_field_values_for_database_BANG___65598.invoke(field_values.clj:50)
	at clojure.lang.AFn.applyToHelper(AFn.java:154)
	at clojure.lang.AFn.applyTo(AFn.java:144)
	at clojure.core$apply.invokeStatic(core.clj:669)
	at clojure.core$apply.invoke(core.clj:662)
	at metabase.sync.util$fn__41544$run_step_with_metadata__41549$fn__41553$fn__41555.doInvoke(util.clj:388)
	at clojure.lang.RestFn.invoke(RestFn.java:397)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
	at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:117)
	at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:114)
	at metabase.sync.util$fn__41544$run_step_with_metadata__41549$fn__41553.invoke(util.clj:383)
	at metabase.sync.util$fn__41544$run_step_with_metadata__41549.invoke(util.clj:378)
	at metabase.sync.util$fn__41760$run_sync_operation__41765$fn__41766$fn__41774.invoke(util.clj:489)
	at metabase.sync.util$fn__41760$run_sync_operation__41765$fn__41766.invoke(util.clj:487)
	at metabase.sync.util$fn__41760$run_sync_operation__41765.invoke(util.clj:481)
	at metabase.sync.field_values$fn__65619$update_field_values_BANG___65624$fn__65625$fn__65626.invoke(field_values.clj:67)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
	at clojure.core$partial$fn__5859.invoke(core.clj:2634)
	at metabase.driver$fn__32608.invokeStatic(driver.clj:592)
	at metabase.driver$fn__32608.invoke(driver.clj:592)
	at clojure.lang.MultiFn.invoke(MultiFn.java:239)
	at metabase.sync.util$sync_in_context$fn__41453.invoke(util.clj:136)
	at metabase.sync.util$with_db_logging_disabled$fn__41450.invoke(util.clj:127)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
	at metabase.sync.util$with_start_and_finish_logging$fn__41439.invoke(util.clj:112)
	at metabase.sync.util$with_sync_events$fn__41434.invoke(util.clj:86)
	at metabase.sync.util$with_duplicate_ops_prevented$fn__41425.invoke(util.clj:65)
	at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179)
	at metabase.sync.util$do_sync_operation.invoke(util.clj:176)
	at metabase.sync.field_values$fn__65619$update_field_values_BANG___65624$fn__65625.invoke(field_values.clj:65)
	at metabase.sync.field_values$fn__65619$update_field_values_BANG___65624.invoke(field_values.clj:61)
	at metabase.task.sync_databases$update_field_values_BANG_.invokeStatic(sync_databases.clj:88)
	at metabase.task.sync_databases$update_field_values_BANG_.invoke(sync_databases.clj:78)
	at metabase.task.sync_databases.UpdateFieldValues.execute(sync_databases.clj:92)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
	... 123 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 10.70.1.34, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
	at

flamber · June 3, 2022, 10:32am

@IvanSilverio I was looking for "Diagnostic Info", not the logs.
I don't know how you are running Metabase, but Metabase will create a plugins directory. The ojdbc8.jar file has to be added to that directory.
https://www.metabase.com/docs/latest/administration-guide/databases/oracle.html#when-running-from-a-jar

IvanSilverio · June 4, 2022, 11:52am

Excuses. Thank you for your help. I run the metabase in docker

{
"browser-info": {
"language": "pt-BR",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.15+10",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.15",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.15+10",
"os.name": "Linux",
"os.version": "5.17.5-300.fc36.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2022-05-16",
"tag": "v0.43.1",
"branch": "release-x.43.x",
"hash": "7f1a1c4"
},
"settings": {
"report-timezone": null
}
}
}

flamber · June 5, 2022, 9:13am

@IvanSilverio Then read this: https://www.metabase.com/docs/latest/administration-guide/databases/oracle.html#when-running-from-docker

And migrate away from H2:
https://www.metabase.com/docs/latest/operations-guide/running-metabase-on-docker.html