Hi All,
Good Day!
I have also creating Oracle Database in Metabase as a source, but I'm getting this error, sorry I'm a newbie with application.
"Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor (CONNECTION_ID=m7x+XHNrSlexJ75ceuH8UQ==)"
Do I need to install oracle database in the Metabase Server?
Metabase 0.41.6
Ubuntu 20.04
OJDBC11 - 21.1
Thank you very much in advance.
Regards,
RAM
Hi @ramenor
Post "Diagnostic Info" from Admin > Troubleshooting.
Post the full error from Admin > Troubleshooting > Logs.
If you do an internet search for the error returned, then you have found this: https://stackoverflow.com/questions/10786782/ora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-d
Hi Sir @flamber,
Thank you for the response.
Please below information
-- 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/91.0.4472.114 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8-Ubuntu-0ubuntu1.20.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8-Ubuntu-0ubuntu1.20.04",
"os.name": "Linux",
"os.version": "5.11.0-1028-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"mysql",
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MariaDB",
"version": "10.3.32-MariaDB-0ubuntu0.20.04.1"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2022-01-10",
"tag": "v0.41.6",
"branch": "release-x.41.x",
"hash": "296635f"
},
"settings": {
"report-timezone": null
}
}
}
-- Logs --
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:00:59+08:00 INFO metabase.core
Metabase v0.41.6 (296635f release-x.41.x)
Copyright © 2022 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:00:59+08:00 WARN metabase.core WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:00:59+08:00 INFO metabase.core Starting Metabase in STANDALONE mode
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:00:59+08:00 INFO metabase.server Launching Embedded Jetty Webserver with config:
{:port 3000}
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:00:59+08:00 INFO metabase.core Starting Metabase version v0.41.6 (296635f release-x.41.x) ...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:00:59+08:00 INFO metabase.core System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "11.0.13+8-Ubuntu-0ubuntu1.20.04",
"java.vendor" "Ubuntu",
"java.vendor.url" "https://ubuntu.com/",
"java.version" "11.0.13",
"java.vm.name" "OpenJDK 64-Bit Server VM",
"java.vm.version" "11.0.13+8-Ubuntu-0ubuntu1.20.04",
"os.name" "Linux",
"os.version" "5.11.0-1028-aws",
"user.language" "en",
"user.timezone" "Etc/UTC"}
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:00:59+08:00 INFO metabase.plugins Loading plugins in /home/metabase/plugins...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/osdt_core.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/xmlparserv2.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/ons.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/oraclepki.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/xdb.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/rsi.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/simplefan.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/orai18n.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/xmlparserv2_sans_jaxp_services.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/ojdbc11.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/osdt_cert.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/ucp11.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery-cloud-sdk...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :bigquery-cloud-sdk (parents: [:sql]) 
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :google...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered abstract driver :google
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08: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.
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Vertica Driver"]
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlite...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :sqlite (parents: [:sql-jdbc])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :mongo
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :mongo...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :snowflake...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :snowflake (parents: [:sql-jdbc])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Presto Driver" "Metabase Vertica Driver"]
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? false
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? false
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Presto Driver" "Metabase Vertica Driver" "Metabase Presto JDBC Driver"]
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :redshift...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :redshift (parents: [:postgres])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-common...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered abstract driver :presto-common
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.initialize Dependencies satisfied; these plugins will now be loaded: ["Metabase Presto JDBC Driver" "Metabase Presto Driver"]
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-jdbc...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :presto-jdbc (parents: [:presto-common])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :presto (parents: [:presto-common])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlserver...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :sqlserver (parents: [:sql-jdbc])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 WARN metabase.plugins.lazy-loaded-driver Warning: plugin manifest for :bigquery does not include connection properties
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :bigquery (parents: [:sql :google])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? true
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :oracle (parents: [:sql-jdbc])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :oracle...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :hive-like...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered abstract driver :hive-like (parents: [:sql-jdbc])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :sparksql (parents: [:hive-like])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sparksql...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :googleanalytics...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.plugins.dependencies Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :googleanalytics (parents: [:google])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.driver.impl Registered driver :druid
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :druid...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.core Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.db.setup Verifying mysql Database Connection ...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.db.setup Running Database Migrations...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.db.setup Successfully verified MariaDB 10.3.32-MariaDB-0ubuntu0.20.04.1 application database connection. 
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.db.setup Setting up Liquibase...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.db.liquibase Checking if Database has unrun migrations...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:00+08:00 INFO metabase.db.setup Liquibase is ready.
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:01+08:00 INFO metabase.db.liquibase Database has unrun migrations. Waiting for migration lock to be cleared...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:01+08:00 INFO metabase.db.liquibase Migration lock is cleared. Running migrations...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.db.setup Database Migrations Current ...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.db.data-migrations Running all necessary data migrations, this may take a minute.
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.db.data-migrations Finished running data migrations.
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.events Starting events listener: :metabase.events.dependencies/Dependencies 
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.events Starting events listener: :metabase.events.activity-feed/ActivityFeed
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.events Starting events listener: :metabase.events.metabot-lifecycle/MetaBotLifecycle
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.events Starting events listener: :metabase.events.last-login/LastLogin
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.events Starting events listener: :metabase.events.notifications/Notifications
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.events Starting events listener: :metabase.events.sync-database/Sync
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.events Starting events listener: :metabase.events.driver-notifications/DriverNotifications
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.events Starting events listener: :metabase.events.revision/Revisions
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.events Starting events listener: :metabase.events.view-log/ViewLog
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.task Initializing task SyncDatabases 
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.task Initializing task CheckForNewVersions
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.task Initializing task SendAnonymousUsageStats
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.task Initializing task SendAbandomentEmails
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.task Initializing task SendPulses
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.task Initializing task SendFollowUpEmails
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.task Initializing task TaskHistoryCleanup
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:01:02+08:00 INFO metabase.core Metabase Initialization COMPLETE
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.task.sync-databases Starting sync task for Database 2.
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.sync.util STARTING: Sync metadata for mysql Database 2 'Metabase'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.driver.impl Initializing driver :mysql...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.driver.impl Initializing driver :sql-jdbc...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.driver.impl Initializing driver :sql...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for mysql Database 2 'Metabase'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for mysql Database 2 'Metabase' (32.0 ms)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.sync.util STARTING: step 'sync-tables' for mysql Database 2 'Metabase'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for mysql Database 2 'Metabase' (99.3 ms)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.sync.util STARTING: step 'sync-fields' for mysql Database 2 'Metabase'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for mysql Database 2 'Metabase' (738.5 ms)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:00+08:00 INFO metabase.sync.util STARTING: step 'sync-fks' for mysql Database 2 'Metabase'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:01+08:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for mysql Database 2 'Metabase' (288.1 ms)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:01+08:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for mysql Database 2 'Metabase'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:01+08:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for mysql Database 2 'Metabase' (20.0 ms)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:01+08:00 INFO metabase.sync.util FINISHED: Sync metadata for mysql Database 2 'Metabase' (1.3 s)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:01+08:00 INFO metabase.sync.util STARTING: Analyze data for mysql Database 2 'Metabase'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:01+08:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for mysql Database 2 'Metabase'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:01+08:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [·············································] 
10% Table 38 'metabase_database'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [········································] 
20% Table 9 'QRTZ_CALENDARS'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [···································] 
31% Table 53 'revision'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for mysql Database 2 'Metabase' (1.2 s)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.util STARTING: step 'classify-fields' for mysql Database 2 'Metabase'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.analyze classify-fields Analyzed [······························] 
41% Table 51 'dimension'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.analyze classify-fields Analyzed [·························] 
51% Table 13 'pulse_card'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.analyze classify-fields Analyzed [····················] 
61% Table 47 'report_card'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for mysql Database 2 'Metabase' (28.4 ms)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.util STARTING: step 'classify-tables' for mysql Database 2 'Metabase'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.analyze classify-tables Analyzed [***************···············] 
71% Table 14 'dashboard_favorite'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.analyze classify-tables Analyzed [··········] 
82% Table 24 'permissions'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.analyze classify-tables Analyzed [·····] 
92% Table 23 'QRTZ_SIMPROP_TRIGGERS'
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for mysql Database 2 'Metabase' (43.8 ms)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:11:02+08:00 INFO metabase.sync.util FINISHED: Analyze data for mysql Database 2 'Metabase' (1.3 s)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:15:19+08:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 3.9 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 4/50 (3 idle, 0 queued) (45 total active threads) Queries in flight: 0 (0 queued)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:17:01+08:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 1.8 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 4/50 (3 idle, 0 queued) (45 total active threads) Queries in flight: 0 (0 queued)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 INFO metabase.driver.impl Initializing driver :oracle...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 INFO metabase.plugins.classloader Added URL file:/home/metabase/plugins/oracle.metabase-driver.jar to classpath
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 DEBUG metabase.plugins.init-steps Loading plugin namespace metabase.driver.oracle...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 INFO metabase.driver.impl Registered abstract driver :metabase.driver.sql.query-processor.empty-string-is-null/empty-string-is-null
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 INFO metabase.driver.impl Registered driver :oracle (parents: [:sql-jdbc :metabase.driver.sql.query-processor.empty-string-is-null/empty-string-is-null])
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 DEBUG metabase.plugins.jdbc-proxy Registering JDBC proxy driver for oracle.jdbc.OracleDriver...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 INFO metabase.driver.impl Initializing driver :metabase.driver.sql.query-processor.empty-string-is-null/empty-string-is-null...
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 ERROR metabase.driver.util Database connection error
java.sql.SQLRecoverableException: IO Error: Connection closed, connect lapse 72 ms., Authentication lapse 0 ms.
at oracle.jdbc.driver.T4CConnection.handleLogonIOException(T4CConnection.java:946)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:711)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1089)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:733)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:649)
at metabase.plugins.jdbc_proxy$proxy_driver$reify__57518.connect(jdbc_proxy.clj:33)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1111)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.oracle$fn__69762.invokeStatic(oracle.clj:108)
at metabase.driver.oracle$fn__69762.invoke(oracle.clj:105)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__24608.invoke(util.clj:43)
at metabase.util$do_with_timeout$fn__6174.invoke(util.clj:353)
at clojure.core$binding_conveyor_fn$fn__5772.invoke(core.clj:2034)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.io.IOException: Connection closed, connect lapse 72 ms., Authentication lapse 0 ms.
at oracle.jdbc.driver.T4CConnection.handleLogonIOException(T4CConnection.java:941)
... 29 more
Caused by: java.io.IOException: Connection closed, connect lapse 72 ms.
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:202)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:350)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2558)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:667)
... 28 more
Caused by: java.io.IOException: Connection closed
at oracle.net.nt.SSLSocketChannel.readFromSocket(SSLSocketChannel.java:734)
at oracle.net.nt.SSLSocketChannel.unwrapHandshakeMessage(SSLSocketChannel.java:615)
at oracle.net.nt.SSLSocketChannel.doSSLHandshake(SSLSocketChannel.java:461)
at oracle.net.nt.SSLSocketChannel.write(SSLSocketChannel.java:149)
at oracle.net.ns.NIOPacket.writeToSocketChannel(NIOPacket.java:361)
at oracle.net.ns.NIOConnectPacket.writeToSocketChannel(NIOConnectPacket.java:256)
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:157)
... 31 more
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 ERROR metabase.api.database Cannot connect to Database
java.lang.Exception: IO Error: Connection closed, connect lapse 72 ms., Authentication lapse 0 ms.
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:48)
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:31)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at metabase.api.database$test_database_connection.invokeStatic(database.clj:421)
at metabase.api.database$test_database_connection.doInvoke(database.clj:411)
at clojure.lang.RestFn.invoke(RestFn.java:425)
at metabase.api.database$fn__77164$test_connection_details__77169$fn__77170.invoke(database.clj:468)
at metabase.api.database$fn__77164$test_connection_details__77169.invoke(database.clj:450)
at metabase.api.database$fn__77196.invokeStatic(database.clj:488)
at metabase.api.database$fn__77196.invoke(database.clj:474)
at compojure.core$wrap_response$fn__32066.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__32050.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__32055.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:151)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at metabase.server.middleware.auth$enforce_authentication$fn__70370.invoke(auth.clj:14)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at compojure.core$make_context$handler__32106.invoke(core.clj:289)
at compojure.core$make_context$fn__32110.invoke(core.clj:299)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at metabase.api.routes$fn__79847$fn__79850.invoke(routes.clj:56)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
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.server.routes$fn__79992$fn__79993.doInvoke(routes.clj:57)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at compojure.core$make_context$handler__32106.invoke(core.clj:289)
at compojure.core$make_context$fn__32110.invoke(core.clj:299)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at metabase.server.routes$fn__79980$fn__79982.invoke(routes.clj:41)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__77452.invoke(exceptions.clj:98)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__77449.invoke(exceptions.clj:86)
at metabase.server.middleware.log$log_api_call$fn__80447$fn__80448$fn__80449.invoke(log.clj:209)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)
at metabase.server.middleware.log$log_api_call$fn__80447$fn__80448.invoke(log.clj:201)
at toucan.db$do_with_call_counting.invokeStatic(db.clj:216)
at toucan.db$do_with_call_counting.invoke(db.clj:209)
at metabase.server.middleware.log$log_api_call$fn__80447.invoke(log.clj:200)
at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__83660.invoke(browser_cookie.clj:30)
at metabase.server.middleware.security$add_security_headers$fn__59285.invoke(security.clj:147)
at metabase.server.middleware.json$wrap_json_body$fn__82804.invoke(json.clj:62)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__82822.invoke(json.clj:98)
at metabase.server.middleware.offset_paging$handle_paging$fn__59309.invoke(offset_paging.clj:42)
at ring.middleware.keyword_params$wrap_keyword_params$fn__83927.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__83943.invoke(params.clj:69)
at metabase.server.middleware.misc$maybe_set_site_url$fn__34077.invoke(misc.clj:59)
at metabase.server.middleware.session$bind_current_user$fn__44982$fn__44983.invoke(session.clj:257)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:238)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:230)
at metabase.server.middleware.session$bind_current_user$fn__44982.invoke(session.clj:256)
at metabase.server.middleware.session$wrap_current_user_info$fn__44969.invoke(session.clj:216)
at metabase.server.middleware.session$wrap_session_id$fn__44955.invoke(session.clj:162)
at metabase.server.middleware.auth$wrap_api_key$fn__70378.invoke(auth.clj:27)
at ring.middleware.cookies$wrap_cookies$fn__83847.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__34060.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__34085.invoke(misc.clj:76)
at ring.middleware.gzip$wrap_gzip$fn__83889.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__34088.invoke(misc.clj:93)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__83676.invoke(ssl.clj:38)
at metabase.server$async_proxy_handler$fn__80220.invoke(server.clj:71)
at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.sql.SQLRecoverableException: IO Error: Connection closed, connect lapse 72 ms., Authentication lapse 0 ms.
at oracle.jdbc.driver.T4CConnection.handleLogonIOException(T4CConnection.java:946)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:711)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1089)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:733)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:649)
at metabase.plugins.jdbc_proxy$proxy_driver$reify__57518.connect(jdbc_proxy.clj:33)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR.invokeStatic(jdbc.clj:1111)
at clojure.java.jdbc$db_query_with_resultset_STAR.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.oracle$fn__69762.invokeStatic(oracle.clj:108)
at metabase.driver.oracle$fn__69762.invoke(oracle.clj:105)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__24608.invoke(util.clj:43)
at metabase.util$do_with_timeout$fn__6174.invoke(util.clj:353)
at clojure.core$binding_conveyor_fn$fn__5772.invoke(core.clj:2034)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
... 1 more
Caused by: java.io.IOException: Connection closed, connect lapse 72 ms., Authentication lapse 0 ms.
at oracle.jdbc.driver.T4CConnection.handleLogonIOException(T4CConnection.java:941)
... 29 more
Caused by: java.io.IOException: Connection closed, connect lapse 72 ms.
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:202)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:350)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2558)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:667)
... 28 more
Caused by: java.io.IOException: Connection closed
at oracle.net.nt.SSLSocketChannel.readFromSocket(SSLSocketChannel.java:734)
at oracle.net.nt.SSLSocketChannel.unwrapHandshakeMessage(SSLSocketChannel.java:615)
at oracle.net.nt.SSLSocketChannel.doSSLHandshake(SSLSocketChannel.java:461)
at oracle.net.nt.SSLSocketChannel.write(SSLSocketChannel.java:149)
at oracle.net.ns.NIOPacket.writeToSocketChannel(NIOPacket.java:361)
at oracle.net.ns.NIOConnectPacket.writeToSocketChannel(NIOConnectPacket.java:256)
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:157)
... 31 more
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 ERROR metabase.driver.util Database connection error
java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
(CONNECTION_ID=IeKGqGg4RPaYBG8ElLUuZg==)
at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:903)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:708)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1089)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:733)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:649)
at metabase.plugins.jdbc_proxy$proxy_driver$reify__57518.connect(jdbc_proxy.clj:33)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1111)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.oracle$fn__69762.invokeStatic(oracle.clj:108)
at metabase.driver.oracle$fn__69762.invoke(oracle.clj:105)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__24608.invoke(util.clj:43)
at metabase.util$do_with_timeout$fn__6174.invoke(util.clj:353)
at clojure.core$binding_conveyor_fn$fn__5772.invoke(core.clj:2034)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
(CONNECTION_ID=IeKGqGg4RPaYBG8ElLUuZg==)
at oracle.net.ns.NSProtocolNIO.createRefusePacketException(NSProtocolNIO.java:816)
at oracle.net.ns.NSProtocolNIO.handleConnectPacketResponse(NSProtocolNIO.java:396)
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:207)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:350)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2558)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:667)
... 28 more
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 ERROR metabase.api.database Cannot connect to Database
java.lang.Exception: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
(CONNECTION_ID=IeKGqGg4RPaYBG8ElLUuZg==)
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:48)
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:31)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at metabase.api.database$test_database_connection.invokeStatic(database.clj:421)
at metabase.api.database$test_database_connection.doInvoke(database.clj:411)
at clojure.lang.RestFn.invoke(RestFn.java:425)
at metabase.api.database$fn__77164$test_connection_details__77169$fn__77170.invoke(database.clj:468)
at metabase.api.database$fn__77164$test_connection_details__77169.invoke(database.clj:450)
at metabase.api.database$fn__77196.invokeStatic(database.clj:488)
at metabase.api.database$fn__77196.invoke(database.clj:474)
at compojure.core$wrap_response$fn__32066.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__32050.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__32055.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:151)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at metabase.server.middleware.auth$enforce_authentication$fn__70370.invoke(auth.clj:14)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at compojure.core$make_context$handler__32106.invoke(core.clj:289)
at compojure.core$make_context$fn__32110.invoke(core.clj:299)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$make_context$fn__32110.invoke(core.clj:300)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at metabase.api.routes$fn__79847$fn__79850.invoke(routes.clj:56)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
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.server.routes$fn__79992$fn__79993.doInvoke(routes.clj:57)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at compojure.core$make_context$handler__32106.invoke(core.clj:289)
at compojure.core$make_context$fn__32110.invoke(core.clj:299)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__32059.invoke(core.clj:153)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080.invoke(core.clj:197)
at metabase.server.routes$fn__79980$fn__79982.invoke(routes.clj:41)
at compojure.core$routes$fn__32078$f__32079.invoke(core.clj:198)
at compojure.core$routes$fn__32078.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__77452.invoke(exceptions.clj:98)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__77449.invoke(exceptions.clj:86)
at metabase.server.middleware.log$log_api_call$fn__80447$fn__80448$fn__80449.invoke(log.clj:209)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)
at metabase.server.middleware.log$log_api_call$fn__80447$fn__80448.invoke(log.clj:201)
at toucan.db$do_with_call_counting.invokeStatic(db.clj:216)
at toucan.db$do_with_call_counting.invoke(db.clj:209)
at metabase.server.middleware.log$log_api_call$fn__80447.invoke(log.clj:200)
at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__83660.invoke(browser_cookie.clj:30)
at metabase.server.middleware.security$add_security_headers$fn__59285.invoke(security.clj:147)
at metabase.server.middleware.json$wrap_json_body$fn__82804.invoke(json.clj:62)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__82822.invoke(json.clj:98)
at metabase.server.middleware.offset_paging$handle_paging$fn__59309.invoke(offset_paging.clj:42)
at ring.middleware.keyword_params$wrap_keyword_params$fn__83927.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__83943.invoke(params.clj:69)
at metabase.server.middleware.misc$maybe_set_site_url$fn__34077.invoke(misc.clj:59)
at metabase.server.middleware.session$bind_current_user$fn__44982$fn__44983.invoke(session.clj:257)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:238)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:230)
at metabase.server.middleware.session$bind_current_user$fn__44982.invoke(session.clj:256)
at metabase.server.middleware.session$wrap_current_user_info$fn__44969.invoke(session.clj:216)
at metabase.server.middleware.session$wrap_session_id$fn__44955.invoke(session.clj:162)
at metabase.server.middleware.auth$wrap_api_key$fn__70378.invoke(auth.clj:27)
at ring.middleware.cookies$wrap_cookies$fn__83847.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__34060.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__34085.invoke(misc.clj:76)
at ring.middleware.gzip$wrap_gzip$fn__83889.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__34088.invoke(misc.clj:93)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__83676.invoke(ssl.clj:38)
at metabase.server$async_proxy_handler$fn__80220.invoke(server.clj:71)
at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
(CONNECTION_ID=IeKGqGg4RPaYBG8ElLUuZg==)
at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:903)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:708)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1089)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:733)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:649)
at metabase.plugins.jdbc_proxy$proxy_driver$reify__57518.connect(jdbc_proxy.clj:33)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR.invokeStatic(jdbc.clj:1111)
at clojure.java.jdbc$db_query_with_resultset_STAR.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.oracle$fn__69762.invokeStatic(oracle.clj:108)
at metabase.driver.oracle$fn__69762.invoke(oracle.clj:105)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__24608.invoke(util.clj:43)
at metabase.util$do_with_timeout$fn__6174.invoke(util.clj:353)
at clojure.core$binding_conveyor_fn$fn__5772.invoke(core.clj:2034)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
... 1 more
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
(CONNECTION_ID=IeKGqGg4RPaYBG8ElLUuZg==)
at oracle.net.ns.NSProtocolNIO.createRefusePacketException(NSProtocolNIO.java:816)
at oracle.net.ns.NSProtocolNIO.handleConnectPacketResponse(NSProtocolNIO.java:396)
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:207)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:350)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2558)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:667)
... 28 more
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 DEBUG metabase.server.middleware.log POST /api/database 400 566.8 ms (0 DB calls)
{:valid false,
:dbname
"Listener refused the connection with the following error:\nORA-12514, TNS:listener does not currently know of service requested in connect descriptor\n (CONNECTION_ID=IeKGqGg4RPaYBG8ElLUuZg==)",
:message
"Listener refused the connection with the following error:\nORA-12514, TNS:listener does not currently know of service requested in connect descriptor\n (CONNECTION_ID=IeKGqGg4RPaYBG8ElLUuZg==)"}
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:00+08:00 DEBUG metabase.server.middleware.log GET /api/database 200 29.7 ms (4 DB calls) App DB connections: 0/4 Jetty threads: 4/50 (3 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[040f5f65-ba11-4898-851b-42435278fdea] 2022-02-10T17:18:07+08:00 DEBUG metabase.server.middleware.log GET /api/util
Thank you
Hello,
any update ?
