I broke unimus by attempting to update it

[igoldstein]

how do i fix it ?

Code: Select all

[root@unimus unimus]# tail -f /var/log/unimus/unimus.log
2023-06-27 19:31:49.607  INFO 1847 --- [SimpleAsyncTaskExecutor-1] .s.b.b.s.DatabaseConnectionCheckBootStep : Database connection test passed
2023-06-27 19:31:49.608  INFO 1847 --- [SimpleAsyncTaskExecutor-1] n.u.s.b.b.step.DatabaseUpdateBootStep    : Connecting to database 
2023-06-27 19:31:49.611  INFO 1847 --- [SimpleAsyncTaskExecutor-1] n.u.s.b.b.step.DatabaseUpdateBootStep    : Updating database schema
2023-06-27 19:32:50.447 ERROR 1847 --- [SimpleAsyncTaskExecutor-1] n.u.s.b.b.step.DatabaseUpdateBootStep    : Failed to update database schema. Reason = 'liquibase.exception.LockException: java.lang.ClassCastException: java.time.LocalDateTime cannot be cast to java.util.Date'
2023-06-27 19:33:11.474  INFO 2006 --- [main] software.netcore.bootstrap.UnimusServer  : Starting UnimusServer v2.3.3 using Java 1.8.0_312 on unimus with PID 2006 (/opt/unimus/Unimus.jar started by root in /opt/unimus)
2023-06-27 19:33:11.476  INFO 2006 --- [main] software.netcore.bootstrap.UnimusServer  : The following profiles are active: unix,unimus-unix,jar,unimus,core,LOCAL,PUBLIC
2023-06-27 19:34:04.666  INFO 2006 --- [main] software.netcore.bootstrap.UnimusServer  : Started UnimusServer in 55.351 seconds (JVM running for 57.343)
2023-06-27 19:34:04.748  INFO 2006 --- [multicaster-20] s.netcore.starter.AppStartTimeMonitor    : Application started in: 44.034 seconds
2023-06-27 19:34:48.151  INFO 2325 --- [main] software.netcore.bootstrap.UnimusServer  : Starting UnimusServer v2.3.3 using Java 1.8.0_312 on unimus with PID 2325 (/opt/unimus/Unimus.jar started by root in /opt/unimus)
2023-06-27 19:34:48.154  INFO 2325 --- [main] software.netcore.bootstrap.UnimusServer  : The following profiles are active: unix,unimus-unix,jar,unimus,core,LOCAL,PUBLIC
2023-06-27 19:35:43.200  INFO 2325 --- [main] software.netcore.bootstrap.UnimusServer  : Started UnimusServer in 56.921 seconds (JVM running for 58.825)
2023-06-27 19:35:43.291  INFO 2325 --- [multicaster-20] s.netcore.starter.AppStartTimeMonitor    : Application started in: 45.548 seconds
2023-06-27 19:35:44.026  INFO 2325 --- [SimpleAsyncTaskExecutor-1] s.b.b.s.LoggingPathAccessibilityBootStep : Checking logging subsystem
2023-06-27 19:35:44.029  INFO 2325 --- [SimpleAsyncTaskExecutor-1] .s.b.b.s.DatabaseConnectionCheckBootStep : Testing database connection
2023-06-27 19:35:44.376  INFO 2325 --- [SimpleAsyncTaskExecutor-1] .s.b.b.s.DatabaseConnectionCheckBootStep : Database connection test passed
2023-06-27 19:35:44.376  INFO 2325 --- [SimpleAsyncTaskExecutor-1] n.u.s.b.b.step.DatabaseUpdateBootStep    : Connecting to database 
2023-06-27 19:35:44.379  INFO 2325 --- [SimpleAsyncTaskExecutor-1] n.u.s.b.b.step.DatabaseUpdateBootStep    : Updating database schema
2023-06-27 19:36:45.049 ERROR 2325 --- [SimpleAsyncTaskExecutor-1] n.u.s.b.b.step.DatabaseUpdateBootStep    : Failed to update database schema. Reason = 'liquibase.exception.LockException: java.lang.ClassCastException: java.time.LocalDateTime cannot be cast to java.util.Date'

[Tomas]

how do i fix it ?

This happens when a database upgrade is interrupted - for example when after an update, Unimus starts the DB upgrade procedure, and the service is restarted / killed during the update.

This is easily recoverable, but how to recover it depends on which DB type and OS you are using. Please let us know the DB and the OS, and we can provide instructions for fixing this.