502 bad gateway - again

Yep, another '502 bad gateway' topic.... I know.

I've tried migrating to latest version. I'm running metabase on ubuntu.so I did the following : Stop service, replace JAR, restart service, pray... and guess what: 502 bad gateway...

Service status stated it is running fine.

I've been reading other "502 bad gateway" related questions, but didn't find an answer on where I should start troubleshooting ?

Any help appreciated.

Hi @GAuber
If the service is running fine (meaning Metabase is actually running), then the problem is with your reverse-proxy, so check the config and logs there.
Check the logs of Metabase too.

I can't figure out what is the problem. I think I am gonna install a new server.
If I install a new one with postgres, can I easily migrate data and metabase config to the new server (I am currently running H2 and JAR) ? What would be easier for this migration ?

@GAuber Without you providing logs, then it's impossible to know what is going on.

Yes, it's easy to move to another server.

If you want to move data between two Postgres databases, then use pg_dump or similar tools that the database provides, since it has nothing to do with Metabase.

All the Metabase information is stored in the application database (H2/Postgres/MySQL), so you just have to point to that.

Just make sure that you do things one at the time. Don't try to do everything at once.

Thanks, before migrating to new server, I try to fix the current issue though.
When I execute jave -jar metabase.jar, I have the following error related to the db (H2)
Lots of different queries are failing due to database being read only... Starting with UPDATE QRTZ_SCHEDULER_STATE SET ....

@GAuber Well, that's because you already have Metabase running.
Check which processes are running on your server.

well, there is no process related to metabase running in the same time

@GAuber
What is the full path to the H2 file? Example /opt/metabase/metabase.db.mv.db
Then run these commands:

 ls -l /opt/metabase/metabase.db.mv.db
 lsof /opt/metabase/metabase.db.mv.db

H2 file is located next to the JAR file (/apps/java/metabase.db.mv.db) and when using lsof, there is no result.

is H2 file path mentionned somewhere in config ? Just to make sure this is the right file used by metabase.

@GAuber
You need to post all the output, otherwise no one will be able to help you.
Post all the logs during startup.

Here we go. I think I tried to many things at once and got stuck...

admsdis76@metabase:/apps/java$ java -jar metabase.jar
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2021-12-23 16:37:29,336 INFO metabase.util :: Maximum memory available to JVM: 988,0 MB
2021-12-23 16:37:45,792 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. :unlock:
For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2021-12-23 16:37:49,601 INFO driver.impl :: Registered abstract driver :sql :truck:
:arrow_lower_left: Load driver :sql took 736,1 ms
2021-12-23 16:37:49,616 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) :truck:
Load driver :sql-jdbc took 755,9 ms
2021-12-23 16:37:49,622 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) :truck:
2021-12-23 16:37:49,659 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) :truck:
2021-12-23 16:37:50,643 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) :truck:
2021-12-23 16:37:54,121 INFO metabase.core ::
Metabase v0.41.3.1 (20f9097 release-x.41.x)

Copyright © 2021 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2021-12-23 16:37:54,152 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2021-12-23 16:37:54,153 INFO metabase.core :: Starting Metabase in STANDALONE mode
2021-12-23 16:37:54,201 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000}

2021-12-23 16:37:54,306 INFO metabase.core :: Starting Metabase version v0.41.3.1 (20f9097 release-x.41.x) ...
2021-12-23 16:37:54,401 INFO metabase.core :: System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "11.0.13+8-Ubuntu-0ubuntu1.18.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.18.04",
"os.name" "Linux",
"os.version" "4.15.0-163-generic",
"user.language" "fr",
"user.timezone" "Europe/Paris"}

2021-12-23 16:37:54,413 WARN metabase.plugins :: Metabase cannot use the plugins directory /apps/java/plugins
Please make sure the directory exists and that Metabase has permission to write to it. You can change the directory Metabase uses for modules by setting the environment variable MB_PLUGINS_DIR. Falling back to a temporary directory for now.
java.lang.AssertionError: Assert failed: Metabase does not have permissions to write to plugins directory /apps/java/plugins
(Files/isWritable path)
at metabase.plugins$fn__83221$fn__83222.invoke(plugins.clj:28)
at clojure.lang.Delay.deref(Delay.java:42)
at clojure.core$deref.invokeStatic(core.clj:2324)
at clojure.core$deref.invoke(core.clj:2310)
at metabase.plugins$plugins_dir.invokeStatic(plugins.clj:50)
at metabase.plugins$plugins_dir.invoke(plugins.clj:50)
at metabase.plugins$load_BANG_.invokeStatic(plugins.clj:158)
at metabase.plugins$load_BANG_.invoke(plugins.clj:157)
at metabase.plugins$fn__83320$fn__83321.invoke(plugins.clj:165)
at clojure.lang.Delay.deref(Delay.java:42)
at clojure.core$deref.invokeStatic(core.clj:2324)
at clojure.core$deref.invoke(core.clj:2310)
at metabase.plugins$load_plugins_BANG_.invokeStatic(plugins.clj:167)
at metabase.plugins$load_plugins_BANG_.invoke(plugins.clj:167)
at metabase.core$init_BANG_.invokeStatic(core.clj:86)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$_main.invokeStatic(core.clj:168)
at metabase.core$_main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
2021-12-23 16:37:54,422 INFO metabase.plugins :: Loading plugins in /tmp...
2021-12-23 16:37:55,226 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.

2021-12-23 16:37:55,229 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2021-12-23 16:37:55,252 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2021-12-23 16:37:55,276 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2021-12-23 16:37:55,276 INFO driver.impl :: Registered driver :mongo :truck:
2021-12-23 16:37:55,283 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2021-12-23 16:37:55,284 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) :truck:
2021-12-23 16:37:55,289 INFO plugins.dependencies :: Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2021-12-23 16:37:55,290 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2021-12-23 16:37:55,291 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Google Analytics Driver" "Metabase Oracle Driver"]
2021-12-23 16:37:55,294 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2021-12-23 16:37:55,295 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2021-12-23 16:37:55,295 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Google Analytics Driver" "Metabase Oracle Driver" "Metabase BigQuery Driver"]
2021-12-23 16:37:55,304 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2021-12-23 16:37:55,304 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql]) :truck:
2021-12-23 16:37:55,309 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2021-12-23 16:37:55,310 INFO driver.impl :: Registered driver :druid :truck:
2021-12-23 16:37:55,315 INFO 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.

2021-12-23 16:37:55,316 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2021-12-23 16:37:55,316 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Google Analytics Driver" "Metabase Oracle Driver" "Metabase Vertica Driver" "Metabase BigQuery Driver"]
2021-12-23 16:37:55,427 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2021-12-23 16:37:55,428 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) :truck:
2021-12-23 16:37:55,429 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2021-12-23 16:37:55,430 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) :truck:
2021-12-23 16:37:55,481 INFO plugins.dependencies :: Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
2021-12-23 16:37:55,491 INFO plugins.dependencies :: Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? false
2021-12-23 16:37:55,493 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Presto JDBC Driver" "Metabase Google Analytics Driver" "Metabase Oracle Driver" "Metabase Vertica Driver" "Metabase BigQuery Driver"]
2021-12-23 16:37:55,498 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2021-12-23 16:37:55,499 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) :truck:
2021-12-23 16:37:55,589 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2021-12-23 16:37:55,604 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) :truck:
2021-12-23 16:37:55,616 INFO plugins.dependencies :: Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
2021-12-23 16:37:55,617 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? false
2021-12-23 16:37:55,625 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Presto JDBC Driver" "Metabase Google Analytics Driver" "Metabase Oracle Driver" "Metabase Vertica Driver" "Metabase Presto Driver" "Metabase BigQuery Driver"]
2021-12-23 16:37:55,635 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :google...
2021-12-23 16:37:55,640 INFO driver.impl :: Registered abstract driver :google :truck:
2021-12-23 16:37:55,642 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2021-12-23 16:37:55,653 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2021-12-23 16:37:55,655 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase BigQuery Driver" "Metabase Google Analytics Driver"]
2021-12-23 16:37:55,666 WARN plugins.lazy-loaded-driver :: Warning: plugin manifest for :bigquery does not include connection properties
2021-12-23 16:37:55,667 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery...
2021-12-23 16:37:55,668 INFO driver.impl :: Registered driver :bigquery (parents: [:sql :google]) :truck:
2021-12-23 16:37:55,670 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2021-12-23 16:37:55,683 INFO driver.impl :: Registered driver :googleanalytics (parents: [:google]) :truck:
2021-12-23 16:37:55,708 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2021-12-23 16:37:55,709 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) :truck:
2021-12-23 16:37:55,724 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-common...
2021-12-23 16:37:55,727 INFO driver.impl :: Registered abstract driver :presto-common :truck:
2021-12-23 16:37:55,730 INFO plugins.dependencies :: Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
2021-12-23 16:37:55,737 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
2021-12-23 16:37:55,739 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase Presto Driver" "Metabase Presto JDBC Driver"]
2021-12-23 16:37:55,740 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...
2021-12-23 16:37:55,752 INFO driver.impl :: Registered driver :presto (parents: [:presto-common]) :truck:
2021-12-23 16:37:55,754 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2021-12-23 16:37:55,756 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:presto-common]) :truck:
2021-12-23 16:37:55,757 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2021-12-23 16:37:55,761 WARN db.env :: WARNING: Using Metabase with an H2 application database is not recommended for production deployments. For production deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If you decide to continue to use H2, please be sure to back up the database file regularly. For more information, see https://metabase.com/docs/latest/operations-guide/migrating-from-h2.html
2021-12-23 16:37:55,767 INFO db.setup :: Verifying h2 Database Connection ...
2021-12-23 16:37:56,392 INFO db.setup :: Successfully verified H2 1.4.197 (2018-03-18) application database connection. :white_check_mark:
2021-12-23 16:37:56,393 INFO db.setup :: Running Database Migrations...
2021-12-23 16:37:56,396 INFO db.setup :: Setting up Liquibase...
2021-12-23 16:37:56,441 INFO db.setup :: Liquibase is ready.
2021-12-23 16:37:56,448 INFO db.liquibase :: Checking if Database has unrun migrations...
2021-12-23 16:37:59,306 INFO db.setup :: Database Migrations Current ... :white_check_mark:
2021-12-23 16:37:59,347 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2021-12-23 16:37:59,361 INFO db.data-migrations :: Finished running data migrations.
Database setup took 3,6 s
2021-12-23 16:37:59,691 INFO metabase.events :: Début de lécoute des événements : :metabase.events.dependencies/Dependencies :ear:
2021-12-23 16:37:59,706 INFO metabase.events :: Début de lécoute des événements : :metabase.events.activity-feed/ActivityFeed :ear:
2021-12-23 16:37:59,711 INFO metabase.events :: Début de lécoute des événements : :metabase.events.metabot-lifecycle/MetaBotLifecycle :ear:
2021-12-23 16:37:59,712 INFO metabase.events :: Début de lécoute des événements : :metabase.events.last-login/LastLogin :ear:
2021-12-23 16:37:59,713 INFO metabase.events :: Début de lécoute des événements : :metabase.events.notifications/Notifications :ear:
2021-12-23 16:37:59,713 INFO metabase.events :: Début de lécoute des événements : :metabase.events.sync-database/Sync :ear:
2021-12-23 16:37:59,714 INFO metabase.events :: Début de lécoute des événements : :metabase.events.driver-notifications/DriverNotifications :ear:
2021-12-23 16:37:59,715 INFO metabase.events :: Début de lécoute des événements : :metabase.events.revision/Revisions :ear:
2021-12-23 16:37:59,716 INFO metabase.events :: Début de lécoute des événements : :metabase.events.view-log/ViewLog :ear:
2021-12-23 16:37:59,874 ERROR jdbcjobstore.JobStoreTX :: ClusterManager: Error managing cluster: Failure updating scheduler state when checking-in: The database is read only; SQL statement:
UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND INSTANCE_NAME = ? [90097-197]
org.quartz.JobPersistenceException: Failure updating scheduler state when checking-in: The database is read only; SQL statement:
UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND INSTANCE_NAME = ? [90097-197] [See nested exception: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND INSTANCE_NAME = ? [90097-197]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterCheckIn(JobStoreSupport.java:3393)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3250)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3857)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.initialize(JobStoreSupport.java:3842)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:678)
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:526)
at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
at clojurewerkz.quartzite.scheduler$start.invokeStatic(scheduler.clj:31)
at clojurewerkz.quartzite.scheduler$start.invoke(scheduler.clj:27)
at metabase.task$start_scheduler_BANG_.invokeStatic(task.clj:157)
at metabase.task$start_scheduler_BANG_.invoke(task.clj:148)
at metabase.core$init_BANG_.invokeStatic(core.clj:103)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$main.invokeStatic(core.clj:168)
at metabase.core$main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND INSTANCE_NAME = ? [90097-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1989)
at org.h2.table.Table.checkWritingAllowed(Table.java:1201)
at org.h2.engine.User.hasRight(User.java:114)
at org.h2.engine.User.checkRight(User.java:100)
at org.h2.command.dml.Update.update(Update.java:97)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:153)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateSchedulerState(StdJDBCDelegate.java:2930)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterCheckIn(JobStoreSupport.java:3387)
... 20 more
2021-12-23 16:37:59,884 INFO metabase.task :: Initialisation de la tâche SyncDatabases :calendar:
2021-12-23 16:37:59,931 ERROR metabase.task :: Erreur lors de linitialisation de la tâche {0}
org.quartz.JobPersistenceException: Couldn't store job: The database is read only; SQL statement:
UPDATE QRTZ_JOB_DETAILS SET DESCRIPTION = ?, JOB_CLASS_NAME = ?, IS_DURABLE = ?, IS_NONCONCURRENT = ?, IS_UPDATE_DATA = ?, REQUESTS_RECOVERY = ?, JOB_DATA = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND JOB_NAME = ? AND JOB_GROUP = ? [90097-197] [See nested exception: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
UPDATE QRTZ_JOB_DETAILS SET DESCRIPTION = ?, JOB_CLASS_NAME = ?, IS_DURABLE = ?, IS_NONCONCURRENT = ?, IS_UPDATE_DATA = ?, REQUESTS_RECOVERY = ?, JOB_DATA = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND JOB_NAME = ? AND JOB_GROUP = ? [90097-197]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1107)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$3.execute(JobStoreSupport.java:1079)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$45.execute(JobStoreSupport.java:3726)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3798)
at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3722)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1075)
at org.quartz.core.QuartzScheduler.addJob(QuartzScheduler.java:920)
at org.quartz.impl.StdScheduler.addJob(StdScheduler.java:269)
at clojurewerkz.quartzite.scheduler$add_job.invokeStatic(scheduler.clj:77)
at clojurewerkz.quartzite.scheduler$add_job.invoke(scheduler.clj:74)
at metabase.task$fn__70708$add_job_BANG___70713$fn__70714.invoke(task.clj:203)
at metabase.task$fn__70708$add_job_BANG___70713.invoke(task.clj:199)
at metabase.task.sync_databases$job_init.invokeStatic(sync_databases.clj:247)
at metabase.task.sync_databases$job_init.invoke(sync_databases.clj:243)
at metabase.task.sync_databases$fn__84688.invokeStatic(sync_databases.clj:278)
at metabase.task.sync_databases$fn__84688.invoke(sync_databases.clj:276)
at metabase.task$init_tasks_BANG
$fn__70566.invoke(task.clj:84)
at metabase.task$init_tasks_BANG
.invokeStatic(task.clj:80)
at metabase.task$init_tasks_BANG_.invoke(task.clj:76)
at metabase.task$start_scheduler_BANG_.invokeStatic(task.clj:158)
at metabase.task$start_scheduler_BANG_.invoke(task.clj:148)
at metabase.core$init_BANG_.invokeStatic(core.clj:103)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$main.invokeStatic(core.clj:168)
at metabase.core$main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
UPDATE QRTZ_JOB_DETAILS SET DESCRIPTION = ?, JOB_CLASS_NAME = ?, IS_DURABLE = ?, IS_NONCONCURRENT = ?, IS_UPDATE_DATA = ?, REQUESTS_RECOVERY = ?, JOB_DATA = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND JOB_NAME = ? AND JOB_GROUP = ? [90097-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1989)
at org.h2.table.Table.checkWritingAllowed(Table.java:1201)
at org.h2.engine.User.hasRight(User.java:114)
at org.h2.engine.User.checkRight(User.java:100)
at org.h2.command.dml.Update.update(Update.java:97)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:153)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateJobDetail(StdJDBCDelegate.java:686)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1099)
... 31 more
2021-12-23 16:37:59,933 INFO metabase.task :: Initialisation de la tâche CheckForNewVersions :calendar:
2021-12-23 16:37:59,964 ERROR jdbcjobstore.JobStoreTX :: MisfireHandler: Error handling misfires: Couldn't store trigger 'DEFAULT.metabase.task.sync-and-analyze.trigger.1' for 'DEFAULT.metabase.task.sync-and-analyze.job' job:The database is read only; SQL statement:
UPDATE QRTZ_TRIGGERS SET JOB_NAME = ?, JOB_GROUP = ?, DESCRIPTION = ?, NEXT_FIRE_TIME = ?, PREV_FIRE_TIME = ?, TRIGGER_STATE = ?, TRIGGER_TYPE = ?, START_TIME = ?, END_TIME = ?, CALENDAR_NAME = ?, MISFIRE_INSTR = ?, PRIORITY = ?, JOB_DATA = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]
org.quartz.JobPersistenceException: Couldn't store trigger 'DEFAULT.metabase.task.sync-and-analyze.trigger.1' for 'DEFAULT.metabase.task.sync-and-analyze.job' job:The database is read only; SQL statement:
UPDATE QRTZ_TRIGGERS SET JOB_NAME = ?, JOB_GROUP = ?, DESCRIPTION = ?, NEXT_FIRE_TIME = ?, PREV_FIRE_TIME = ?, TRIGGER_STATE = ?, TRIGGER_TYPE = ?, START_TIME = ?, END_TIME = ?, CALENDAR_NAME = ?, MISFIRE_INSTR = ?, PRIORITY = ?, JOB_DATA = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197] [See nested exception: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
UPDATE QRTZ_TRIGGERS SET JOB_NAME = ?, JOB_GROUP = ?, DESCRIPTION = ?, NEXT_FIRE_TIME = ?, PREV_FIRE_TIME = ?, TRIGGER_STATE = ?, TRIGGER_TYPE = ?, START_TIME = ?, END_TIME = ?, CALENDAR_NAME = ?, MISFIRE_INSTR = ?, PRIORITY = ?, JOB_DATA = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1212)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1026)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:975)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3174)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3934)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3955)
Caused by: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
UPDATE QRTZ_TRIGGERS SET JOB_NAME = ?, JOB_GROUP = ?, DESCRIPTION = ?, NEXT_FIRE_TIME = ?, PREV_FIRE_TIME = ?, TRIGGER_STATE = ?, TRIGGER_TYPE = ?, START_TIME = ?, END_TIME = ?, CALENDAR_NAME = ?, MISFIRE_INSTR = ?, PRIORITY = ?, JOB_DATA = ? WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1989)
at org.h2.table.Table.checkWritingAllowed(Table.java:1201)
at org.h2.engine.User.hasRight(User.java:114)
at org.h2.engine.User.checkRight(User.java:100)
at org.h2.command.dml.Update.update(Update.java:97)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:153)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTrigger(StdJDBCDelegate.java:1226)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1207)
... 5 more
2021-12-23 16:37:59,976 ERROR metabase.task :: Erreur à la replanification du job
org.quartz.JobPersistenceException: Couldn't remove trigger: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197] [See nested exception: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1495)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$11.execute(JobStoreSupport.java:1463)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3798)
at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1459)
at org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:1090)
at org.quartz.impl.StdScheduler.rescheduleJob(StdScheduler.java:312)
at metabase.task$fn__70625$reschedule_task_BANG___70630$fn__70631.invoke(task.clj:178)
at metabase.task$fn__70625$reschedule_task_BANG___70630.invoke(task.clj:172)
at metabase.task$fn__70657$schedule_task_BANG___70662$fn__70663.invoke(task.clj:190)
at metabase.task$fn__70657$schedule_task_BANG___70662.invoke(task.clj:182)
at metabase.task.upgrade_checks$fn__82790.invokeStatic(upgrade_checks.clj:49)
at metabase.task.upgrade_checks$fn__82790.invoke(upgrade_checks.clj:39)
at metabase.task$init_tasks_BANG
$fn__70566.invoke(task.clj:84)
at metabase.task$init_tasks_BANG
.invokeStatic(task.clj:80)
at metabase.task$init_tasks_BANG_.invoke(task.clj:76)
at metabase.task$start_scheduler_BANG_.invokeStatic(task.clj:158)
at metabase.task$start_scheduler_BANG_.invoke(task.clj:148)
at metabase.core$init_BANG_.invokeStatic(core.clj:103)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$main.invokeStatic(core.clj:168)
at metabase.core$main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1989)
at org.h2.table.Table.checkWritingAllowed(Table.java:1201)
at org.h2.engine.User.hasRight(User.java:114)
at org.h2.engine.User.checkRight(User.java:100)
at org.h2.command.dml.Delete.update(Delete.java:65)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:153)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.deleteExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:43)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTriggerExtension(StdJDBCDelegate.java:1581)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTrigger(StdJDBCDelegate.java:1565)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.deleteTriggerAndChildren(JobStoreSupport.java:1351)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1485)
... 27 more
2021-12-23 16:37:59,984 INFO metabase.task :: Initialisation de la tâche SendAnonymousUsageStats :calendar:
2021-12-23 16:37:59,992 ERROR metabase.task :: Erreur à la replanification du job
org.quartz.JobPersistenceException: Couldn't remove trigger: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197] [See nested exception: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1495)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$11.execute(JobStoreSupport.java:1463)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3798)
at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1459)
at org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:1090)
at org.quartz.impl.StdScheduler.rescheduleJob(StdScheduler.java:312)
at metabase.task$fn__70625$reschedule_task_BANG___70630$fn__70631.invoke(task.clj:178)
at metabase.task$fn__70625$reschedule_task_BANG___70630.invoke(task.clj:172)
at metabase.task$fn__70657$schedule_task_BANG___70662$fn__70663.invoke(task.clj:190)
at metabase.task$fn__70657$schedule_task_BANG___70662.invoke(task.clj:182)
at metabase.task.send_anonymous_stats$fn__85083.invokeStatic(send_anonymous_stats.clj:36)
at metabase.task.send_anonymous_stats$fn__85083.invoke(send_anonymous_stats.clj:25)
at metabase.task$init_tasks_BANG
$fn__70566.invoke(task.clj:84)
at metabase.task$init_tasks_BANG
.invokeStatic(task.clj:80)
at metabase.task$init_tasks_BANG_.invoke(task.clj:76)
at metabase.task$start_scheduler_BANG_.invokeStatic(task.clj:158)
at metabase.task$start_scheduler_BANG_.invoke(task.clj:148)
at metabase.core$init_BANG_.invokeStatic(core.clj:103)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$main.invokeStatic(core.clj:168)
at metabase.core$main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1989)
at org.h2.table.Table.checkWritingAllowed(Table.java:1201)
at org.h2.engine.User.hasRight(User.java:114)
at org.h2.engine.User.checkRight(User.java:100)
at org.h2.command.dml.Delete.update(Delete.java:65)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:153)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.deleteExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:43)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTriggerExtension(StdJDBCDelegate.java:1581)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTrigger(StdJDBCDelegate.java:1565)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.deleteTriggerAndChildren(JobStoreSupport.java:1351)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1485)
... 27 more
2021-12-23 16:37:59,997 INFO metabase.task :: Initialisation de la tâche SendAbandomentEmails :calendar:
2021-12-23 16:38:00,003 ERROR metabase.task :: Erreur à la replanification du job
org.quartz.JobPersistenceException: Couldn't remove trigger: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197] [See nested exception: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1495)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$11.execute(JobStoreSupport.java:1463)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3798)
at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1459)
at org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:1090)
at org.quartz.impl.StdScheduler.rescheduleJob(StdScheduler.java:312)
at metabase.task$fn__70625$reschedule_task_BANG___70630$fn__70631.invoke(task.clj:178)
at metabase.task$fn__70625$reschedule_task_BANG___70630.invoke(task.clj:172)
at metabase.task$fn__70657$schedule_task_BANG___70662$fn__70663.invoke(task.clj:190)
at metabase.task$fn__70657$schedule_task_BANG___70662.invoke(task.clj:182)
at metabase.task.follow_up_emails$fn__80047.invokeStatic(follow_up_emails.clj:146)
at metabase.task.follow_up_emails$fn__80047.invoke(follow_up_emails.clj:136)
at metabase.task$init_tasks_BANG
$fn__70566.invoke(task.clj:84)
at metabase.task$init_tasks_BANG
.invokeStatic(task.clj:80)
at metabase.task$init_tasks_BANG_.invoke(task.clj:76)
at metabase.task$start_scheduler_BANG_.invokeStatic(task.clj:158)
at metabase.task$start_scheduler_BANG_.invoke(task.clj:148)
at metabase.core$init_BANG_.invokeStatic(core.clj:103)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$main.invokeStatic(core.clj:168)
at metabase.core$main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1989)
at org.h2.table.Table.checkWritingAllowed(Table.java:1201)
at org.h2.engine.User.hasRight(User.java:114)
at org.h2.engine.User.checkRight(User.java:100)
at org.h2.command.dml.Delete.update(Delete.java:65)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:153)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.deleteExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:43)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTriggerExtension(StdJDBCDelegate.java:1581)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTrigger(StdJDBCDelegate.java:1565)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.deleteTriggerAndChildren(JobStoreSupport.java:1351)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1485)
... 27 more
2021-12-23 16:38:00,007 INFO metabase.task :: Initialisation de la tâche SendPulses :calendar:
2021-12-23 16:38:00,013 ERROR metabase.task :: Erreur à la replanification du job
org.quartz.JobPersistenceException: Couldn't remove trigger: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197] [See nested exception: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1495)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$11.execute(JobStoreSupport.java:1463)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3798)
at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1459)
at org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:1090)
at org.quartz.impl.StdScheduler.rescheduleJob(StdScheduler.java:312)
at metabase.task$fn__70625$reschedule_task_BANG___70630$fn__70631.invoke(task.clj:178)
at metabase.task$fn__70625$reschedule_task_BANG___70630.invoke(task.clj:172)
at metabase.task$fn__70657$schedule_task_BANG___70662$fn__70663.invoke(task.clj:190)
at metabase.task$fn__70657$schedule_task_BANG___70662.invoke(task.clj:182)
at metabase.task.send_pulses$fn__82503.invokeStatic(send_pulses.clj:121)
at metabase.task.send_pulses$fn__82503.invoke(send_pulses.clj:103)
at metabase.task$init_tasks_BANG
$fn__70566.invoke(task.clj:84)
at metabase.task$init_tasks_BANG
.invokeStatic(task.clj:80)
at metabase.task$init_tasks_BANG_.invoke(task.clj:76)
at metabase.task$start_scheduler_BANG_.invokeStatic(task.clj:158)
at metabase.task$start_scheduler_BANG_.invoke(task.clj:148)
at metabase.core$init_BANG_.invokeStatic(core.clj:103)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$main.invokeStatic(core.clj:168)
at metabase.core$main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1989)
at org.h2.table.Table.checkWritingAllowed(Table.java:1201)
at org.h2.engine.User.hasRight(User.java:114)
at org.h2.engine.User.checkRight(User.java:100)
at org.h2.command.dml.Delete.update(Delete.java:65)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:153)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.deleteExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:43)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTriggerExtension(StdJDBCDelegate.java:1581)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTrigger(StdJDBCDelegate.java:1565)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.deleteTriggerAndChildren(JobStoreSupport.java:1351)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1485)
... 27 more
2021-12-23 16:38:00,021 INFO metabase.task :: Initialisation de la tâche SendFollowUpEmails :calendar:
2021-12-23 16:38:00,030 ERROR metabase.task :: Erreur à la replanification du job
org.quartz.JobPersistenceException: Couldn't remove trigger: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197] [See nested exception: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1495)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$11.execute(JobStoreSupport.java:1463)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3798)
at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1459)
at org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:1090)
at org.quartz.impl.StdScheduler.rescheduleJob(StdScheduler.java:312)
at metabase.task$fn__70625$reschedule_task_BANG___70630$fn__70631.invoke(task.clj:178)
at metabase.task$fn__70625$reschedule_task_BANG___70630.invoke(task.clj:172)
at metabase.task$fn__70657$schedule_task_BANG___70662$fn__70663.invoke(task.clj:190)
at metabase.task$fn__70657$schedule_task_BANG___70662.invoke(task.clj:182)
at metabase.task.follow_up_emails$fn__79966.invokeStatic(follow_up_emails.clj:78)
at metabase.task.follow_up_emails$fn__79966.invoke(follow_up_emails.clj:68)
at metabase.task$init_tasks_BANG
$fn__70566.invoke(task.clj:84)
at metabase.task$init_tasks_BANG
.invokeStatic(task.clj:80)
at metabase.task$init_tasks_BANG_.invoke(task.clj:76)
at metabase.task$start_scheduler_BANG_.invokeStatic(task.clj:158)
at metabase.task$start_scheduler_BANG_.invoke(task.clj:148)
at metabase.core$init_BANG_.invokeStatic(core.clj:103)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$main.invokeStatic(core.clj:168)
at metabase.core$main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1989)
at org.h2.table.Table.checkWritingAllowed(Table.java:1201)
at org.h2.engine.User.hasRight(User.java:114)
at org.h2.engine.User.checkRight(User.java:100)
at org.h2.command.dml.Delete.update(Delete.java:65)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:153)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.deleteExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:43)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTriggerExtension(StdJDBCDelegate.java:1581)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTrigger(StdJDBCDelegate.java:1565)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.deleteTriggerAndChildren(JobStoreSupport.java:1351)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1485)
... 27 more
2021-12-23 16:38:00,039 INFO metabase.task :: Initialisation de la tâche TaskHistoryCleanup :calendar:
2021-12-23 16:38:00,051 ERROR metabase.task :: Erreur à la replanification du job
org.quartz.JobPersistenceException: Couldn't remove trigger: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197] [See nested exception: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1495)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$11.execute(JobStoreSupport.java:1463)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3798)
at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1459)
at org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:1090)
at org.quartz.impl.StdScheduler.rescheduleJob(StdScheduler.java:312)
at metabase.task$fn__70625$reschedule_task_BANG___70630$fn__70631.invoke(task.clj:178)
at metabase.task$fn__70625$reschedule_task_BANG___70630.invoke(task.clj:172)
at metabase.task$fn__70657$schedule_task_BANG___70662$fn__70663.invoke(task.clj:190)
at metabase.task$fn__70657$schedule_task_BANG___70662.invoke(task.clj:182)
at metabase.task.task_history_cleanup$fn__83471.invokeStatic(task_history_cleanup.clj:41)
at metabase.task.task_history_cleanup$fn__83471.invoke(task_history_cleanup.clj:31)
at metabase.task$init_tasks_BANG
$fn__70566.invoke(task.clj:84)
at metabase.task$init_tasks_BANG
.invokeStatic(task.clj:80)
at metabase.task$init_tasks_BANG_.invoke(task.clj:76)
at metabase.task$start_scheduler_BANG_.invokeStatic(task.clj:158)
at metabase.task$start_scheduler_BANG_.invoke(task.clj:148)
at metabase.core$init_BANG_.invokeStatic(core.clj:103)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$main.invokeStatic(core.clj:168)
at metabase.core$main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'MetabaseScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [90097-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1989)
at org.h2.table.Table.checkWritingAllowed(Table.java:1201)
at org.h2.engine.User.hasRight(User.java:114)
at org.h2.engine.User.checkRight(User.java:100)
at org.h2.command.dml.Delete.update(Delete.java:65)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:153)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.deleteExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:43)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTriggerExtension(StdJDBCDelegate.java:1581)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.deleteTrigger(StdJDBCDelegate.java:1565)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.deleteTriggerAndChildren(JobStoreSupport.java:1351)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1485)
... 27 more
2021-12-23 16:38:00,073 INFO driver.impl :: Initialisation du pilote :sql
2021-12-23 16:38:00,074 INFO driver.impl :: Initialisation du pilote :sql-jdbc
2021-12-23 16:38:00,076 INFO driver.impl :: Initialisation du pilote :h2
2021-12-23 16:38:00,083 ERROR metabase.core :: Linitialisation de Metabase a ÉCHOUÉ
org.h2.jdbc.JdbcBatchUpdateException: The database is read only; SQL statement:
UPDATE "METABASE_DATABASE" SET "DETAILS" = ?, "UPDATED_AT" = now() WHERE "ID" = 1 [90097-197]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1295)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)
at clojure.java.jdbc$execute_batch.invokeStatic(jdbc.clj:598)
at clojure.java.jdbc$execute_batch.invoke(jdbc.clj:591)
at clojure.java.jdbc$db_do_execute_prepared_statement$fn__20677.invoke(jdbc.clj:1057)
at clojure.java.jdbc$db_transaction_STAR
.invokeStatic(jdbc.clj:807)
at clojure.java.jdbc$db_transaction_STAR
.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_do_execute_prepared_statement.invokeStatic(jdbc.clj:1056)
at clojure.java.jdbc$db_do_execute_prepared_statement.invoke(jdbc.clj:1042)
at clojure.java.jdbc$db_do_prepared.invokeStatic(jdbc.clj:1080)
at clojure.java.jdbc$db_do_prepared.invoke(jdbc.clj:1060)
at clojure.java.jdbc$execute_BANG_$execute_helper__20745.invoke(jdbc.clj:1464)
at clojure.java.jdbc$execute_BANG_.invokeStatic(jdbc.clj:1468)
at clojure.java.jdbc$execute_BANG_.invoke(jdbc.clj:1435)
at toucan.db$execute_BANG_.invokeStatic(db.clj:427)
at toucan.db$execute_BANG_.doInvoke(db.clj:422)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at toucan.db$update_BANG_.invokeStatic(db.clj:482)
at toucan.db$update_BANG_.invoke(db.clj:471)
at toucan.db$update_BANG_.invokeStatic(db.clj:491)
at toucan.db$update_BANG_.invoke(db.clj:471)
at toucan.db$update_BANG_.invokeStatic(db.clj:499)
at toucan.db$update_BANG_.doInvoke(db.clj:471)
at clojure.lang.RestFn.invoke(RestFn.java:470)
at metabase.sample_data$update_sample_dataset_if_needed_BANG_.invokeStatic(sample_data.clj:42)
at metabase.sample_data$update_sample_dataset_if_needed_BANG_.invoke(sample_data.clj:38)
at metabase.core$init_BANG_.invokeStatic(core.clj:119)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$main.invokeStatic(core.clj:168)
at metabase.core$main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement:
UPDATE "METABASE_DATABASE" SET "DETAILS" = ?, "UPDATED_AT" = now() WHERE "ID" = 1 [90097-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1989)
at org.h2.table.Table.checkWritingAllowed(Table.java:1201)
at org.h2.engine.User.hasRight(User.java:114)
at org.h2.engine.User.checkRight(User.java:100)
at org.h2.command.dml.Update.update(Update.java:97)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1277)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)
at clojure.java.jdbc$execute_batch.invokeStatic(jdbc.clj:598)
at clojure.java.jdbc$execute_batch.invoke(jdbc.clj:591)
at clojure.java.jdbc$db_do_execute_prepared_statement$fn__20677.invoke(jdbc.clj:1057)
at clojure.java.jdbc$db_transaction_STAR
.invokeStatic(jdbc.clj:807)
at clojure.java.jdbc$db_transaction_STAR
.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_do_execute_prepared_statement.invokeStatic(jdbc.clj:1056)
at clojure.java.jdbc$db_do_execute_prepared_statement.invoke(jdbc.clj:1042)
at clojure.java.jdbc$db_do_prepared.invokeStatic(jdbc.clj:1080)
at clojure.java.jdbc$db_do_prepared.invoke(jdbc.clj:1060)
at clojure.java.jdbc$execute_BANG_$execute_helper__20745.invoke(jdbc.clj:1464)
at clojure.java.jdbc$execute_BANG_.invokeStatic(jdbc.clj:1468)
at clojure.java.jdbc$execute_BANG_.invoke(jdbc.clj:1435)
at toucan.db$execute_BANG_.invokeStatic(db.clj:427)
at toucan.db$execute_BANG_.doInvoke(db.clj:422)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at toucan.db$update_BANG_.invokeStatic(db.clj:482)
at toucan.db$update_BANG_.invoke(db.clj:471)
at toucan.db$update_BANG_.invokeStatic(db.clj:491)
at toucan.db$update_BANG_.invoke(db.clj:471)
at toucan.db$update_BANG_.invokeStatic(db.clj:499)
at toucan.db$update_BANG_.doInvoke(db.clj:471)
at clojure.lang.RestFn.invoke(RestFn.java:470)
at metabase.sample_data$update_sample_dataset_if_needed_BANG_.invokeStatic(sample_data.clj:42)
at metabase.sample_data$update_sample_dataset_if_needed_BANG_.invoke(sample_data.clj:38)
at metabase.core$init_BANG_.invokeStatic(core.clj:119)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:135)
at metabase.core$start_normally.invoke(core.clj:129)
at metabase.core$_main.invokeStatic(core.clj:168)
at metabase.core$_main.doInvoke(core.clj:162)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
2021-12-23 16:38:00,092 INFO metabase.core :: Metabase en cours darrêt...
2021-12-23 16:38:00,109 INFO metabase.server :: Arrêt du serveur web Jetty intégré
2021-12-23 16:38:00,135 INFO metabase.core :: Arrêt de Metabase EFFECTIF

@GAuber
Post the output of ls -l /app/java/
I'm guessing that some files are not writable for the user admsdis76, which you're logged in as.
You need to upgrade to 0.41.5: https://github.com/metabase/metabase/releases/latest

yes. You are absolutely right. Will investigate further and upgrade as advised.