Hi,
My Server configuration in intel i7 processor, 3ghz, 32 gb RAM and 512GB SSD,
After upgrdaing the metabase from older version to newer,iam facing this issue.
Iam Running with 0.48.4.
Kindly help me on this.
Please post logs thanks
Is this immediately after the update or has the update completed and you're able to login?
If immediately after update and you can't login yet then it's just the db upgrade process. Looks like you're running MySQL, so be patient and make a note to use Postgres in the future.
If you're able to login etc, there is a bug mentioned elsewhere in teh forum that could be affecting you.
Hi,
My production database is Mysql and Oracle, and Metabase database is H2, i was upgraded on Dec 22, and then onwards i was facing this issue.
intially after starting the metabase service it work normal, after 5-6 hours they system is working like this. recently i was upgraded my hardware also. still same. i'll share the logs.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.core
Metabase v0.48.4 (62145b0)
Copyright © 2024 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.core Starting Metabase in STANDALONE mode
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.server Launching Embedded Jetty Webserver with config:
{:port 3000}
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.core Starting Metabase version v0.48.4 (62145b0) ...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.core System info:
{"file.encoding" "Cp1252",
"java.runtime.name" "Java(TM) SE Runtime Environment",
"java.runtime.version" "11.0.20+9-LTS-256",
"java.vendor" "Oracle Corporation",
"java.vendor.url" "https://openjdk.java.net/",
"java.version" "11.0.20",
"java.vm.name" "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version" "11.0.20+9-LTS-256",
"os.name" "Windows 10",
"os.version" "10.0",
"user.language" "en",
"user.timezone" "Asia/Calcutta"}
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins Loading plugins in D:\Metabase\plugins...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.classloader Added URL file:/D:/Metabase/plugins/ojdbc8.jar to classpath
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.classloader Added URL file:/D:/Metabase/plugins/ucp.jar to classpath
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :athena...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :athena (parents: [:sql-jdbc])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :bigquery-cloud-sdk (parents: [:sql])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery-cloud-sdk...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.dependencies Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.dependencies Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase BigQuery Driver"]
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :druid
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :druid...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.dependencies Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered abstract driver :google
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :google...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.initialize Dependencies satisfied; these plugins will now be loaded: ["Metabase BigQuery Driver"]
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 WARN metabase.plugins.lazy-loaded-driver Warning: plugin manifest for :bigquery does not include connection properties
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :bigquery (parents: [:sql :google])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :googleanalytics
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :googleanalytics...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :mongo
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :mongo...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.dependencies Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? true
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :oracle...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :oracle (parents: [:sql-jdbc])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered abstract driver :presto-common
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-common...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-jdbc...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :presto-jdbc (parents: [:sql-jdbc])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.dependencies Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.dependencies Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :presto (parents: [:presto-common])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :redshift (parents: [:postgres])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :redshift...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :snowflake...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :snowflake (parents: [:sql-jdbc])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :hive-like...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered abstract driver :hive-like (parents: [:sql-jdbc])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sparksql...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :sparksql (parents: [:hive-like])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :sqlite (parents: [:sql-jdbc])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlite...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlserver...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.driver.impl Registered driver :sqlserver (parents: [:sql-jdbc])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 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 Redirecting… for more details.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.dependencies Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Vertica Driver"]
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.core Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:53+05:30 INFO metabase.db.setup Verifying h2 Database Connection ...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:54+05:30 INFO metabase.db.setup Successfully verified H2 2.1.214 (2022-06-13) application database connection.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:54+05:30 INFO metabase.db.setup Checking if a database downgrade is required...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:54+05:30 INFO metabase.db.setup Running Database Migrations...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:54+05:30 INFO metabase.db.setup Setting up Liquibase...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:54+05:30 INFO metabase.db.liquibase Checking if Database has unrun migrations...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:54+05:30 INFO metabase.db.setup Liquibase is ready.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.db.liquibase No unrun migrations found.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.db.setup Database Migrations Current ...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.util Database setup took 1.1 s
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.impl.StdSchedulerFactory Using default implementation for ThreadExecutor
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.core.SchedulerSignalerImpl Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.core.QuartzScheduler Quartz Scheduler v.2.3.2 created.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.impl.jdbcjobstore.JobStoreTX Using db table-based data access locking (synchronization).
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.impl.jdbcjobstore.JobStoreTX JobStoreTX initialized.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.core.QuartzScheduler Scheduler meta-data: Quartz Scheduler (v2.3.2) 'MetabaseScheduler' with instanceId 'TPServer1707391975266'
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.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.impl.StdSchedulerFactory Quartz scheduler 'MetabaseScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.impl.StdSchedulerFactory Quartz scheduler version: 2.3.2
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.core.QuartzScheduler Scheduler MetabaseScheduler_$TPServer1707391975266 paused.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Task scheduler initialized into standby mode.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task SyncDatabases
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task.sync-databases Updated default schedules for 0 databases
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task PersistRefresh
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.driver.impl Initializing driver :sql...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.driver.impl Initializing driver :mysql...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.driver.impl Initializing driver :sql-jdbc...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.driver.impl Initializing driver :oracle...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.plugins.classloader Added URL file:/D:/Metabase/plugins/oracle.metabase-driver.jar to classpath
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 DEBUG metabase.plugins.init-steps Loading plugin namespace metabase.driver.oracle...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.driver.impl Registered abstract driver :metabase.driver.sql.query-processor.empty-string-is-null/empty-string-is-null
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.driver.impl Registered driver :oracle (parents: [:sql-jdbc :metabase.driver.sql.query-processor.empty-string-is-null/empty-string-is-null])
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 DEBUG metabase.plugins.jdbc-proxy Registering JDBC proxy driver for oracle.jdbc.OracleDriver...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.driver.impl Initializing driver :metabase.driver.sql.query-processor.empty-string-is-null/empty-string-is-null...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.util Load lazy loading driver :oracle took 37.1 ms
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task.persist-refresh Scheduling persistence refreshes for database 69: trigger: metabase.task.PersistenceRefresh.database.trigger.69
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task.persist-refresh Scheduling persistence refreshes for database 198: trigger: metabase.task.PersistenceRefresh.database.trigger.198
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task.persist-refresh Scheduling persistence refreshes for database 327: trigger: metabase.task.PersistenceRefresh.database.trigger.327
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task.persist-refresh Scheduling persistence refreshes for database 391: trigger: metabase.task.PersistenceRefresh.database.trigger.391
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task CheckForNewVersions
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task PersistPrune
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task SendAnonymousUsageStats
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task ModelIndexValues
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task RefreshSlackChannelsAndUsers
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task TruncateAuditTables
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task SendPulses
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task SendFollowUpEmails
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task TaskHistoryCleanup
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Initializing task SendWarnPulseRemovalEmail
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.impl.jdbcjobstore.JobStoreTX ClusterManager: detected 1 failed or restarted instances.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.impl.jdbcjobstore.JobStoreTX ClusterManager: Scanning for instance "TPServer1707255965439"'s failed in-progress jobs.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.impl.jdbcjobstore.JobStoreTX ClusterManager: ......Cleaned-up 1 other failed job(s).
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.core.QuartzScheduler Scheduler MetabaseScheduler$TPServer1707391975266 started.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task Task scheduler started
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.core Metabase Initialization COMPLETE in 18.8 s
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO org.quartz.impl.jdbcjobstore.JobStoreTX Handling 5 trigger(s) that missed their scheduled fire-time.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task.sync-databases Starting sync task for Database 455.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:55+05:30 INFO metabase.task.refresh-slack-channel-user-cache Slack is not configured, not refreshing slack user/channel cache.
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:56+05:30 INFO metabase.driver.impl Initializing driver :h2...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:56+05:30 INFO metabase.util.i18n.impl Reading available locales from locales.clj...
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:56+05:30 INFO metabase.util.fonts Reading available fonts from /frontend_client/app/fonts
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:57+05:30 INFO metabase.public-settings.premium-features GETTING ACTIVE USER COUNT!
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:57+05:30 INFO metabase.public-settings.premium-features => 3
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:57+05:30 DEBUG metabase.server.middleware.log GET /api/session/properties 200 78.8 ms (7 DB calls) App DB connections: 0/3 Jetty threads: 6/50 (1 idle, 0 queued) (42 total active threads) Queries in flight: 0 (0 queued)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:57+05:30 DEBUG metabase.server.middleware.log GET /api/user/current 200 120.8 ms (11 DB calls) App DB connections: 0/3 Jetty threads: 6/50 (1 idle, 0 queued) (43 total active threads) Queries in flight: 0 (0 queued)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:02:57+05:30 DEBUG metabase.server.middleware.log GET /api/database 200 25.1 ms (3 DB calls) App DB connections: 0/3 Jetty threads: 5/50 (2 idle, 0 queued) (45 total active threads) Queries in flight: 0 (0 queued)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.events Loading events namespace: metabase.events.audit-log
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.events Loading events namespace: metabase.events.driver-notifications
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.events Loading events namespace: metabase.events.last-login
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.events Loading events namespace: metabase.events.persisted-info
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.events Loading events namespace: metabase.events.recent-views
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.events Loading events namespace: metabase.events.revision
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.events Loading events namespace: metabase.events.schema
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.events Loading events namespace: metabase.events.sync-database
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.events Loading events namespace: metabase.events.view-log
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.sync.util STARTING: Sync metadata for oracle Database 455 'Santhu Farmers Fresh'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.sync.util STARTING: step 'sync-dbms-version' for oracle Database 455 'Santhu Farmers Fresh'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.sync.util FINISHED: step 'sync-dbms-version' for oracle Database 455 'Santhu Farmers Fresh' (3.5 ms)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.sync.util STARTING: step 'sync-timezone' for oracle Database 455 'Santhu Farmers Fresh'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.sync.sync-metadata.sync-timezone :oracle database 455 default timezone is "+00:00"
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.sync.util FINISHED: step 'sync-timezone' for oracle Database 455 'Santhu Farmers Fresh' (4.4 ms)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:06+05:30 INFO metabase.sync.util STARTING: step 'sync-tables' for oracle Database 455 'Santhu Farmers Fresh'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:07+05:30 INFO metabase.sync.util FINISHED: step 'sync-tables' for oracle Database 455 'Santhu Farmers Fresh' (298.4 ms)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:03:07+05:30 INFO metabase.sync.util STARTING: step 'sync-fields' for oracle Database 455 'Santhu Farmers Fresh'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:04:18+05:30 DEBUG metabase.server.middleware.log GET /api/session/properties 200 31.6 ms (6 DB calls) App DB connections: 0/3 Jetty threads: 6/50 (1 idle, 0 queued) (42 total active threads) Queries in flight: 0 (0 queued)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:04:18+05:30 DEBUG metabase.server.middleware.log GET /api/user/current 200 47.9 ms (10 DB calls) App DB connections: 0/3 Jetty threads: 6/50 (1 idle, 0 queued) (42 total active threads) Queries in flight: 0 (0 queued)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:04:18+05:30 DEBUG metabase.server.middleware.log GET /api/database 200 8.6 ms (3 DB calls) App DB connections: 0/3 Jetty threads: 5/50 (1 idle, 0 queued) (44 total active threads) Queries in flight: 0 (0 queued)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:04:30+05:30 INFO metabase.sync.util FINISHED: step 'sync-fields' for oracle Database 455 'Santhu Farmers Fresh' (1.4 mins)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:04:30+05:30 INFO metabase.sync.util STARTING: step 'sync-fks' for oracle Database 455 'Santhu Farmers Fresh'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:01+05:30 INFO metabase.sync.util FINISHED: step 'sync-fks' for oracle Database 455 'Santhu Farmers Fresh' (30.2 s)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:01+05:30 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for oracle Database 455 'Santhu Farmers Fresh'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:01+05:30 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for oracle Database 455 'Santhu Farmers Fresh' (3.3 ms)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:01+05:30 INFO metabase.sync.util STARTING: step 'sync-table-privileges' for oracle Database 455 'Santhu Farmers Fresh'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:01+05:30 INFO metabase.sync.util FINISHED: step 'sync-table-privileges' for oracle Database 455 'Santhu Farmers Fresh' (281.9 µs)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:01+05:30 INFO metabase.sync.util FINISHED: Sync metadata for oracle Database 455 'Santhu Farmers Fresh' (1.9 mins)
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:01+05:30 INFO metabase.sync.util STARTING: Analyze data for oracle Database 455 'Santhu Farmers Fresh'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:01+05:30 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for oracle Database 455 'Santhu Farmers Fresh'
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:11+05:30 WARN metabase.sync.util Error fingerprinting Table 10,873 'APEX_040000.WWV_DEMO_DEPT'
clojure.lang.ExceptionInfo: Error reducing result rows: oracle/xdb/XMLType {:type :qp}
at metabase.query_processor.context.default$default_reducef$fn__49534.invoke(default.clj:36)
at metabase.query_processor.context.default$default_reducef.invokeStatic(default.clj:33)
at metabase.query_processor.context.default$default_reducef.invoke(default.clj:25)
at metabase.query_processor.context$reducef.invokeStatic(context.clj:70)
at metabase.query_processor.context$reducef.invoke(context.clj:63)
at metabase.query_processor.context.default$default_runf$respond_STAR___49538.invoke(default.clj:45)
at metabase.driver.oracle$remove_rownum_column.invokeStatic(oracle.clj:498)
at metabase.driver.oracle$remove_rownum_column.invoke(oracle.clj:494)
at clojure.core$partial$fn__5908.invoke(core.clj:2642)
at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__78827.invoke(execute.clj:706)
at metabase.driver.sql_jdbc.execute$fn__78622$fn__78623.invoke(execute.clj:388)
at metabase.driver.sql_jdbc.execute$fn__78587$AMPERSAND_f__78588.invoke(execute.clj:334)
at metabase.driver.sql_jdbc.execute$fn__78587$fn__78591.invoke(execute.clj:317)
at metabase.driver.sql_jdbc.execute$fn__78622.invokeStatic(execute.clj:382)
at metabase.driver.sql_jdbc.execute$fn__78622.invoke(execute.clj:380)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:689)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:686)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)
at metabase.driver.sql_jdbc$fn__107316.invokeStatic(sql_jdbc.clj:82)
at metabase.driver.sql_jdbc$fn__107316.invoke(sql_jdbc.clj:80)
at metabase.driver.oracle$fn__123670.invokeStatic(oracle.clj:511)
at metabase.driver.oracle$fn__123670.invoke(oracle.clj:509)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.query_processor.context$executef.invokeStatic(context.clj:60)
at metabase.query_processor.context$executef.invoke(context.clj:49)
at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:44)
at metabase.query_processor.context.default$default_runf.invoke(default.clj:42)
at metabase.query_processor.context$runf.invokeStatic(context.clj:46)
at metabase.query_processor.context$runf.invoke(context.clj:40)
at metabase.query_processor.reducible$identity_qp.invokeStatic(reducible.clj:39)
at metabase.query_processor.reducible$identity_qp.invoke(reducible.clj:36)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___71633.invoke(cache.clj:229)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__65596.invoke(permissions.clj:140)
at metabase.query_processor.middleware.enterprise$check_download_permissions_middleware$fn__71454.invoke(enterprise.clj:51)
at metabase.query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__71464.invoke(enterprise.clj:64)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__70701.invoke(mbql_to_native.clj:24)
at metabase.query_processor$fn__72761$combined_post_process__72766$combined_post_process_STAR___72767.invoke(query_processor.clj:261)
at metabase.query_processor$fn__72761$combined_pre_process__72762$combined_pre_process_STAR___72763.invoke(query_processor.clj:258)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65693.invoke(fetch_source_query.clj:303)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71544$fn__71548.invoke(resolve_database_and_driver.clj:77)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:94)
at metabase.driver$do_with_driver.invoke(driver.clj:89)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71544.invoke(resolve_database_and_driver.clj:76)
at metabase.query_processor.middleware.store$initialize_store$fn__66100$fn__66101.invoke(store.clj:14)
at metabase.query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:164)
at metabase.query_processor.store$do_with_metadata_provider.invoke(store.clj:150)
at metabase.query_processor.middleware.store$initialize_store$fn__66100.invoke(store.clj:13)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database$fn__71541.invoke(resolve_database_and_driver.clj:60)
at metabase.query_processor.middleware.normalize_query$normalize$fn__71846.invoke(normalize_query.clj:38)
at metabase.query_processor.middleware.enterprise$fn__71481$handle_audit_app_internal_queries__71482$fn__71484.invoke(enterprise.clj:96)
at metabase.query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__71492.invoke(enterprise.clj:103)
at metabase.query_processor.reducible$async_qp$qp_STAR___61141$thunk__61143.invoke(reducible.clj:126)
at metabase.query_processor.reducible$async_qp$qp_STAR___61141.invoke(reducible.clj:132)
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.query_processor.reducible$sync_qp$qp_STAR___61153.doInvoke(reducible.clj:153)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at metabase.query_processor$fn__72776$AMPERSAND_f__72778.invoke(query_processor.clj:310)
at metabase.query_processor$fn__72776$fn__72783.invoke(query_processor.clj:290)
at clojure.lang.Var.invoke(Var.java:393)
at metabase.db.metadata_queries$fn__80422$AMPERSAND_f__80423.invoke(metadata_queries.clj:152)
at metabase.db.metadata_queries$fn__80422$fn__80425.invoke(metadata_queries.clj:133)
at metabase.db.metadata_queries$fn__80428.invokeStatic(metadata_queries.clj:156)
at metabase.db.metadata_queries$fn__80428.invoke(metadata_queries.clj:154)
at clojure.lang.MultiFn.invoke(MultiFn.java:252)
at metabase.sync.analyze.fingerprint$fingerprint_table_BANG.invokeStatic(fingerprint.clj:85)
at metabase.sync.analyze.fingerprint$fingerprint_table_BANG.invoke(fingerprint.clj:62)
at metabase.sync.analyze.fingerprint$fingerprint_fields_BANG$fn__81707.invoke(fingerprint.clj:200)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:191)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:184)
at metabase.sync.analyze.fingerprint$fingerprint_fields_BANG.invokeStatic(fingerprint.clj:198)
at metabase.sync.analyze.fingerprint$fingerprint_fields_BANG_.invoke(fingerprint.clj:194)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_$fn__81711$fn__81712.invoke(fingerprint.clj:226)
at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_$fn__81711.invoke(fingerprint.clj:222)
at metabase.query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)
at metabase.query_processor.store$do_with_metadata_provider.invoke(store.clj:150)
at metabase.query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)
at metabase.query_processor.store$do_with_metadata_provider.invoke(store.clj:150)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_.invokeStatic(fingerprint.clj:221)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_.invoke(fingerprint.clj:209)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_.invokeStatic(fingerprint.clj:214)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_.invoke(fingerprint.clj:209)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG_.invokeStatic(fingerprint.clj:240)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG_.invoke(fingerprint.clj:234)
at metabase.sync.analyze$make_analyze_steps$fn__81789.invoke(analyze.clj:105)
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$run_step_with_metadata$fn__57437.doInvoke(util.clj:425)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:132)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:126)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:150)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:146)
at metabase.sync.util$run_step_with_metadata.invokeStatic(util.clj:420)
at metabase.sync.util$run_step_with_metadata.invoke(util.clj:415)
at metabase.sync.util$run_sync_operation$fn__57516.invoke(util.clj:531)
at metabase.sync.util$run_sync_operation.invokeStatic(util.clj:529)
at metabase.sync.util$run_sync_operation.invoke(util.clj:523)
at metabase.sync.analyze$analyze_db_BANG_$fn__81796.invoke(analyze.clj:122)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:191)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:184)
at clojure.core$partial$fn__5910.invoke(core.clj:2647)
at metabase.driver$fn__48897.invokeStatic(driver.clj:725)
at metabase.driver$fn__48897.invoke(driver.clj:725)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__57378.invoke(util.clj:167)
at metabase.sync.util$with_db_logging_disabled$fn__57375.invoke(util.clj:159)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:132)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:126)
at metabase.sync.util$with_start_and_finish_logging$fn__57362.invoke(util.clj:144)
at metabase.sync.util$with_sync_events$fn__57357.invoke(util.clj:118)
at metabase.sync.util$with_duplicate_ops_prevented$fn__57344.invoke(util.clj:90)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:216)
at metabase.sync.util$do_sync_operation.invoke(util.clj:210)
at metabase.sync.analyze$analyze_db_BANG_.invokeStatic(analyze.clj:119)
at metabase.sync.analyze$analyze_db_BANG_.invoke(analyze.clj:114)
at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_.invokeStatic(sync_databases.clj:97)
at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_.invoke(sync_databases.clj:77)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:113)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:101)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:118)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: java.lang.NoClassDefFoundError: oracle/xdb/XMLType
at oracle.jdbc.driver.NamedTypeAccessor.getOracleObject(NamedTypeAccessor.java:249)
at oracle.jdbc.driver.NamedTypeAccessor.getObject(NamedTypeAccessor.java:148)
at oracle.jdbc.driver.NamedTypeAccessor.getObject(NamedTypeAccessor.java:123)
at oracle.jdbc.driver.GeneratedStatement.getObject(GeneratedStatement.java:196)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getObject(GeneratedScrollableResultSet.java:322)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getObject(NewProxyResultSet.java:165)
at metabase.driver.sql_jdbc.execute$fn__78750$fn__78751.invoke(execute.clj:577)
at clojure.core$juxt$fn__5893.invoke(core.clj:2617)
at metabase.driver.sql_jdbc.execute$row_thunk$row_thunk_STAR___78806.invoke(execute.clj:636)
at metabase.query_processor.reducible$reducible_rows$reify__61156.reduce(reducible.clj:176)
at clojure.core$transduce.invokeStatic(core.clj:6946)
at clojure.core$transduce.invokeStatic(core.clj:6942)
at clojure.core$transduce.invoke(core.clj:6933)
at metabase.query_processor.context.default$default_reducef$fn__49534.invoke(default.clj:34)
... 131 more
Caused by: java.lang.ClassNotFoundException: oracle.xdb.XMLType
at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476)
at clojure.lang.DynamicClassLoader.findClass(DynamicClassLoader.java:69)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:588)
at clojure.lang.DynamicClassLoader.loadClass(DynamicClassLoader.java:77)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
... 145 more
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:28+05:30 WARN metabase.sync.util Error fingerprinting Table 11,389 'SNTATM.V_MJ_CAT_VIEW'
clojure.lang.ExceptionInfo: Error executing query: ORA-01722: invalid number
ORA-01722 - Database Error Messages {:driver :oracle, :sql ["-- Metabase" "SELECT" " *" "FROM" " (" " SELECT" " "source"."substring55600" "substring55600"," " "source"."substring55601" "substring55601"," " "source"."substring55602" "substring55602"," " "source"."MJ_CAT" "MJ_CAT"" " FROM" " (" " SELECT" " "SNTATM"."V_MJ_CAT_VIEW"."MJ_CAT" "MJ_CAT"," " "SNTATM"."V_MJ_CAT_VIEW"."PRODUCTDESCRIPTOR" "PRODUCTDESCRIPTOR"," " "SNTATM"."V_MJ_CAT_VIEW"."INVENTORYIDENTIFIER" "INVENTORYIDENTIFIER"," " "SNTATM"."V_MJ_CAT_VIEW"."INVENTORYDESCRIPTOR" "INVENTORYDESCRIPTOR"," " SUBSTR(" " "SNTATM"."V_MJ_CAT_VIEW"."PRODUCTDESCRIPTOR"," " 1," " 1234" " ) "substring55600"," " SUBSTR(" " "SNTATM"."V_MJ_CAT_VIEW"."INVENTORYDESCRIPTOR"," " 1," " 1234" " ) "substring55601"," " SUBSTR(" " "SNTATM"."V_MJ_CAT_VIEW"."INVENTORYIDENTIFIER"," " 1," " 1234" " ) "substring55602"" " FROM" " "SNTATM"."V_MJ_CAT_VIEW"" " ) "source"" " )" "WHERE" " rownum <= 10000"], :params nil, :type :invalid-query}
at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__78827$fn__78828.invoke(execute.clj:698)
at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__78827.invoke(execute.clj:695)
at metabase.driver.sql_jdbc.execute$fn__78622$fn__78623.invoke(execute.clj:388)
at metabase.driver.sql_jdbc.execute$fn__78587$AMPERSAND_f__78588.invoke(execute.clj:334)
at metabase.driver.sql_jdbc.execute$fn__78587$fn__78591.invoke(execute.clj:317)
at metabase.driver.sql_jdbc.execute$fn__78622.invokeStatic(execute.clj:382)
at metabase.driver.sql_jdbc.execute$fn__78622.invoke(execute.clj:380)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:689)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:686)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)
at metabase.driver.sql_jdbc$fn__107316.invokeStatic(sql_jdbc.clj:82)
at metabase.driver.sql_jdbc$fn__107316.invoke(sql_jdbc.clj:80)
at metabase.driver.oracle$fn__123670.invokeStatic(oracle.clj:511)
at metabase.driver.oracle$fn__123670.invoke(oracle.clj:509)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.query_processor.context$executef.invokeStatic(context.clj:60)
at metabase.query_processor.context$executef.invoke(context.clj:49)
at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:44)
at metabase.query_processor.context.default$default_runf.invoke(default.clj:42)
at metabase.query_processor.context$runf.invokeStatic(context.clj:46)
at metabase.query_processor.context$runf.invoke(context.clj:40)
at metabase.query_processor.reducible$identity_qp.invokeStatic(reducible.clj:39)
at metabase.query_processor.reducible$identity_qp.invoke(reducible.clj:36)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___71633.invoke(cache.clj:229)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__65596.invoke(permissions.clj:140)
at metabase.query_processor.middleware.enterprise$check_download_permissions_middleware$fn__71454.invoke(enterprise.clj:51)
at metabase.query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__71464.invoke(enterprise.clj:64)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__70701.invoke(mbql_to_native.clj:24)
at metabase.query_processor$fn__72761$combined_post_process__72766$combined_post_process_STAR___72767.invoke(query_processor.clj:261)
at metabase.query_processor$fn__72761$combined_pre_process__72762$combined_pre_process_STAR___72763.invoke(query_processor.clj:258)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65693.invoke(fetch_source_query.clj:303)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71544$fn__71548.invoke(resolve_database_and_driver.clj:77)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:94)
at metabase.driver$do_with_driver.invoke(driver.clj:89)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71544.invoke(resolve_database_and_driver.clj:76)
at metabase.query_processor.middleware.store$initialize_store$fn__66100$fn__66101.invoke(store.clj:14)
at metabase.query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:164)
at metabase.query_processor.store$do_with_metadata_provider.invoke(store.clj:150)
at metabase.query_processor.middleware.store$initialize_store$fn__66100.invoke(store.clj:13)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database$fn__71541.invoke(resolve_database_and_driver.clj:60)
at metabase.query_processor.middleware.normalize_query$normalize$fn__71846.invoke(normalize_query.clj:38)
at metabase.query_processor.middleware.enterprise$fn__71481$handle_audit_app_internal_queries__71482$fn__71484.invoke(enterprise.clj:96)
at metabase.query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__71492.invoke(enterprise.clj:103)
at metabase.query_processor.reducible$async_qp$qp_STAR___61141$thunk__61143.invoke(reducible.clj:126)
at metabase.query_processor.reducible$async_qp$qp_STAR___61141.invoke(reducible.clj:132)
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.query_processor.reducible$sync_qp$qp_STAR___61153.doInvoke(reducible.clj:153)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at metabase.query_processor$fn__72776$AMPERSAND_f__72778.invoke(query_processor.clj:310)
at metabase.query_processor$fn__72776$fn__72783.invoke(query_processor.clj:290)
at clojure.lang.Var.invoke(Var.java:393)
at metabase.db.metadata_queries$fn__80422$AMPERSAND_f__80423.invoke(metadata_queries.clj:152)
at metabase.db.metadata_queries$fn__80422$fn__80425.invoke(metadata_queries.clj:133)
at metabase.db.metadata_queries$fn__80428.invokeStatic(metadata_queries.clj:156)
at metabase.db.metadata_queries$fn__80428.invoke(metadata_queries.clj:154)
at clojure.lang.MultiFn.invoke(MultiFn.java:252)
at metabase.sync.analyze.fingerprint$fingerprint_table_BANG.invokeStatic(fingerprint.clj:85)
at metabase.sync.analyze.fingerprint$fingerprint_table_BANG.invoke(fingerprint.clj:62)
at metabase.sync.analyze.fingerprint$fingerprint_fields_BANG$fn__81707.invoke(fingerprint.clj:200)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:191)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:184)
at metabase.sync.analyze.fingerprint$fingerprint_fields_BANG_.invokeStatic(fingerprint.clj:198)
at metabase.sync.analyze.fingerprint$fingerprint_fields_BANG_.invoke(fingerprint.clj:194)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_$fn__81711$fn__81712.invoke(fingerprint.clj:226)
at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_$fn__81711.invoke(fingerprint.clj:222)
at metabase.query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)
at metabase.query_processor.store$do_with_metadata_provider.invoke(store.clj:150)
at metabase.query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)
at metabase.query_processor.store$do_with_metadata_provider.invoke(store.clj:150)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_.invokeStatic(fingerprint.clj:221)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_.invoke(fingerprint.clj:209)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_.invokeStatic(fingerprint.clj:214)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG__STAR_.invoke(fingerprint.clj:209)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG_.invokeStatic(fingerprint.clj:240)
at metabase.sync.analyze.fingerprint$fingerprint_fields_for_db_BANG_.invoke(fingerprint.clj:234)
at metabase.sync.analyze$make_analyze_steps$fn__81789.invoke(analyze.clj:105)
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$run_step_with_metadata$fn__57437.doInvoke(util.clj:425)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:132)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:126)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:150)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:146)
at metabase.sync.util$run_step_with_metadata.invokeStatic(util.clj:420)
at metabase.sync.util$run_step_with_metadata.invoke(util.clj:415)
at metabase.sync.util$run_sync_operation$fn__57516.invoke(util.clj:531)
at metabase.sync.util$run_sync_operation.invokeStatic(util.clj:529)
at metabase.sync.util$run_sync_operation.invoke(util.clj:523)
at metabase.sync.analyze$analyze_db_BANG_$fn__81796.invoke(analyze.clj:122)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:191)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:184)
at clojure.core$partial$fn__5910.invoke(core.clj:2647)
at metabase.driver$fn__48897.invokeStatic(driver.clj:725)
at metabase.driver$fn__48897.invoke(driver.clj:725)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__57378.invoke(util.clj:167)
at metabase.sync.util$with_db_logging_disabled$fn__57375.invoke(util.clj:159)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:132)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:126)
at metabase.sync.util$with_start_and_finish_logging$fn__57362.invoke(util.clj:144)
at metabase.sync.util$with_sync_events$fn__57357.invoke(util.clj:118)
at metabase.sync.util$with_duplicate_ops_prevented$fn__57344.invoke(util.clj:90)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:216)
at metabase.sync.util$do_sync_operation.invoke(util.clj:210)
at metabase.sync.analyze$analyze_db_BANG_.invokeStatic(analyze.clj:119)
at metabase.sync.analyze$analyze_db_BANG_.invoke(analyze.clj:114)
at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_.invokeStatic(sync_databases.clj:97)
at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_.invoke(sync_databases.clj:77)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:113)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:101)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:118)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-01722 - Database Error Messages
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:702)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:608)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1277)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1102)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:456)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:482)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:170)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:998)
at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1277)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1207)
at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1415)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2278)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2227)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:330)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
at metabase.driver.sql_jdbc.execute$fn__78746.invokeStatic(execute.clj:560)
at metabase.driver.sql_jdbc.execute$fn__78746.invoke(execute.clj:558)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:568)
at metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:565)
at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__78827$fn__78828.invoke(execute.clj:696)
... 123 more
Caused by: Error : 1722, Position : 7, SQL = -- Metabase
SELECT * FROM (SELECT "source"."substring55600" "substring55600", "source"."substring55601" "substring55601", "source"."substring55602" "substring55602", "source"."MJ_CAT" "MJ_CAT" FROM (SELECT "SNTATM"."V_MJ_CAT_VIEW"."MJ_CAT" "MJ_CAT", "SNTATM"."V_MJ_CAT_VIEW"."PRODUCTDESCRIPTOR" "PRODUCTDESCRIPTOR", "SNTATM"."V_MJ_CAT_VIEW"."INVENTORYIDENTIFIER" "INVENTORYIDENTIFIER", "SNTATM"."V_MJ_CAT_VIEW"."INVENTORYDESCRIPTOR" "INVENTORYDESCRIPTOR", SUBSTR("SNTATM"."V_MJ_CAT_VIEW"."PRODUCTDESCRIPTOR", 1, 1234) "substring55600", SUBSTR("SNTATM"."V_MJ_CAT_VIEW"."INVENTORYDESCRIPTOR", 1, 1234) "substring55601", SUBSTR("SNTATM"."V_MJ_CAT_VIEW"."INVENTORYIDENTIFIER", 1, 1234) "substring55602" FROM "SNTATM"."V_MJ_CAT_VIEW") "source") WHERE rownum <= 10000, Original SQL = -- Metabase
SELECT * FROM (SELECT "source"."substring55600" "substring55600", "source"."substring55601" "substring55601", "source"."substring55602" "substring55602", "source"."MJ_CAT" "MJ_CAT" FROM (SELECT "SNTATM"."V_MJ_CAT_VIEW"."MJ_CAT" "MJ_CAT", "SNTATM"."V_MJ_CAT_VIEW"."PRODUCTDESCRIPTOR" "PRODUCTDESCRIPTOR", "SNTATM"."V_MJ_CAT_VIEW"."INVENTORYIDENTIFIER" "INVENTORYIDENTIFIER", "SNTATM"."V_MJ_CAT_VIEW"."INVENTORYDESCRIPTOR" "INVENTORYDESCRIPTOR", SUBSTR("SNTATM"."V_MJ_CAT_VIEW"."PRODUCTDESCRIPTOR", 1, 1234) "substring55600", SUBSTR("SNTATM"."V_MJ_CAT_VIEW"."INVENTORYDESCRIPTOR", 1, 1234) "substring55601", SUBSTR("SNTATM"."V_MJ_CAT_VIEW"."INVENTORYIDENTIFIER", 1, 1234) "substring55602" FROM "SNTATM"."V_MJ_CAT_VIEW") "source") WHERE rownum <= 10000, Error Message = ORA-01722: invalid number
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:710)
... 144 more
[ecf111b4-3787-47ea-8710-0489fab44cfa] 2024-02-08T17:05:35+05:30 WARN metabase.sync.util Error fingerprinting Table 11,542 'TPEHOSMART.PLAN_TABLE'
clojure.lang.ExceptionInfo: Error executing query: ORA-00932: inconsistent datatypes: expected NUMBER got LONG
ORA-00932 - Database Error Messages {:driver :oracle, :sql ["-- Metabase" "SELECT" " *" "FROM" " (" " SELECT" " "source"."PARTITIONID" "PARTITIONID"," " "source"."POSITION" "POSITION"," " "source"."substring57960" "substring57960"," " "source"."substring57961" "substring57961"," " "source"."TIMESTAMP" "TIMESTAMP"," " "source"."substring57962" "substring57962"," " "source"."substring57963" "substring57963"," " "source"."substring57964" "substring57964"," " "source"."OBJECTINSTANCE" "OBJECTINSTANCE"," " "source"."ID" "ID"," " "source"."substring57965" "substring57965"," " "source"."COSTPRICE" "COSTPRICE"," " "source"."substring57966" "substring57966"," " "source"."substring57967" "substring57967"," " "source"."SEARCHCOLUMNS" "SEARCHCOLUMNS"," " "source"."BYTES" "BYTES"," " "source"."substring57968" "substring57968"," " "source"."substring57969" "substring57969"," " "source"."substring57970" "substring57970"," " "source"."substring57971" "substring57971"," " "source"."substring57972" "substring57972"," " "source"."PARENTID" "PARENTID"," " "source"."CARDINALITY" "CARDINALITY"" " FROM" " (" " SELECT" " "TPEHOSMART"."PLAN_TABLE"."STATEMENTID" "STATEMENTID"," " "TPEHOSMART"."PLAN_TABLE"."TIMESTAMP" "TIMESTAMP"," " "TPEHOSMART"."PLAN_TABLE"."REMARKS" "REMARKS"," " "TPEHOSMART"."PLAN_TABLE"."OPERATION" "OPERATION"," " "TPEHOSMART"."PLAN_TABLE"."OPTIONS" "OPTIONS"," " "TPEHOSMART"."PLAN_TABLE"."OBJECTNODE" "OBJECTNODE"," " "TPEHOSMART"."PLAN_TABLE"."OBJECTOWNER" "OBJECTOWNER"," " "TPEHOSMART"."PLAN_TABLE"."OBJECTNAME" "OBJECTNAME"," " "TPEHOSMART"."PLAN_TABLE"."OBJECTINSTANCE" "OBJECTINSTANCE"," " "TPEHOSMART"."PLAN_TABLE"."OBJECTTYPE" "OBJECTTYPE"," " "TPEHOSMART"."PLAN_TABLE"."OPTIMIZER" "OPTIMIZER"," " "TPEHOSMART"."PLAN_TABLE"."SEARCHCOLUMNS" "SEARCHCOLUMNS"," " "TPEHOSMART"."PLAN_TABLE"."ID" "ID"," " "TPEHOSMART"."PLAN_TABLE"."PARENTID" "PARENTID"," " "TPEHOSMART"."PLAN_TABLE"."POSITION" "POSITION"," " "TPEHOSMART"."PLAN_TABLE"."COSTPRICE" "COSTPRICE"," " "TPEHOSMART"."PLAN_TABLE"."CARDINALITY" "CARDINALITY"," " "TPEHOSMART"."PLAN_TABLE"."BYTES" "BYTES"," " "TPEHOSMART"."PLAN_TABLE"."OTHERTAG" "OTHERTAG"," " "TPEHOSMART"."PLAN_TABLE"."PARTITIONSTART" "PARTITIONSTART"," " "TPEHOSMART"."PLAN_TABLE"."PARTITIONSTOP" "PARTITIONSTOP"," " "TPEHOSMART"."PLAN_TABLE"."PARTITIONID" "PARTITIONID"," " "TPEHOSMART"."PLAN_TABLE"."OTHER" "OTHER"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."OPTIONS", 1, 1234) "substring57965"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."STATEMENTID", 1, 1234) "substring57966"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."OPTIMIZER", 1, 1234) "substring57961"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."PARTITIONSTOP", 1, 1234) "substring57972"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."OBJECTOWNER", 1, 1234) "substring57962"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."OBJECTNAME", 1, 1234) "substring57969"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."REMARKS", 1, 1234) "substring57960"," " SUBSTR(" " "TPEHOSMART"."PLAN_TABLE"."PARTITIONSTART"," " 1," " 1234" " ) "substring57964"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."OPERATION", 1, 1234) "substring57963"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."OBJECTNODE", 1, 1234) "substring57970"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."OTHER", 1, 1234) "substring57971"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."OBJECTTYPE", 1, 1234) "substring57968"," " SUBSTR("TPEHOSMART"."PLAN_TABLE"."OTHERTAG", 1, 1234) "substring57967"" " FROM" " "TPEHOSMART"."PLAN_TABLE"" " ) "source"" " )" "WHERE" " rownum <= 10000"], :params nil, :type :invalid-query}
at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__78827$fn__78828.invoke(execute.clj:698)
at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__78827.invoke(execute.clj:695)
at metabase.driver.sql_jdbc.execute$fn__78622$fn__78623.invoke(execute.clj:388)
at metabase.driver.sql_jdbc.execute$fn__78587$_AMPERSAND_f__78588.invoke(execute.clj:334)
at metabase.driver.sql_jdbc.execute$fn__78587$fn__78591.invoke(execute.clj:317)
at metabase.driver.sql_jdbc.execute$fn__78622.invokeStatic(execute.clj:382)
at metabase.driver.sql_jdbc.execute$fn__78622.invoke(execute.clj:380)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:689)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:686)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)
at metabase.driver.sql_jdbc$fn__107316.invokeStatic(sql_jdbc.clj:82)
at metabase.driver.sql_jdbc$fn__107316.invoke(sql_jdbc.clj:80)
at metabase.driver.oracle$fn__123670.invokeStatic(oracle.clj:511)
at metabase.driver.oracle$fn__123670.invoke(oracle.clj:509)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.query_processor.context$executef.invokeStatic(context.clj:60)
at metabase.query_processor.context$executef.invoke(context.clj:49)
at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:44)
at metabase.query_processor.context.default$default_runf.invoke(default.clj:42)
at metabase.query_processor.context$runf.invokeStatic(context.clj:46)
at metabase.query_processor.context$runf.invoke(context.clj:40)
at metabase.query_processor.reducible$identity_qp.invokeStatic(reducible.clj:39)
at metabase.query_processor.reducible$identity_qp.invoke(reducible.clj:36)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___71633.invoke(cache.clj:229)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__65596.invoke(permissions.clj:140)
at metabase.query_processor.middleware.enterprise$check_download_permissions_middleware$fn__71454.invoke(enterprise.clj:51)
at metabase.query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__71464.invoke(enterprise.clj:64)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__70701.invoke(mbql_to_native.clj:24)
at metabase.query_processor$fn__72761$combined_post_process__72766$combined_post_process_STAR___72767.invoke(query_processor.clj:261)
at metabase.query_processor$fn__72761$combined_pre_process__72762$combined_pre_process_STAR___72763.invoke(query_processor.clj:258)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65693.invoke(fetch_source_query.clj:303)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71544$fn__71548.invoke(resolve_database_and_driver.clj:77)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:94)
at metabase.driver$do_with_driver.invoke(driver.clj:89)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__71544.invoke(resolve_database_and_driver.clj:76)
at metabase.query_processor.middleware.store$initialize_store$fn__66100$fn__66101.invoke(store.clj:14)
at metabase.query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:164)
at metabase.query_processor.store$do_with_metadata_provider.invoke(store.clj:150)
at metabase.query_processor.middleware.store$initialize_store$fn__66100.invoke(store.clj:13)
at
I'll let Luiggi comment on the logs.
You're on H2 still - you reap what you sow.
If that were my server, I'd restore a backup, go back to previous version of Metabase, then migrate from H2 to Postgres before trying another upgrade.
@Luiggi - what would it take to add a warning banner about H2 to the admin console? One that gets slightly bigger each day until you can't see the rest of the settings for the warning.
Hi,
The upgrade was done on dec 2023, and there was lot of changes was happened, i hope its impossible to do all those changes from scratch.
My H2 DB Size is 278MB.
in earlier build there was an issue with the connection to the oracle database, so i was upgraded.
is any chance to downgrade from existing database?