upgrade failing

Unimus support forum
Post Reply
tslytsly
Posts: 14
Joined: Mon Jun 01, 2020 7:57 am

Thu Jan 06, 2022 8:28 am

Hi,
I'm trying to upgrade to the latest build, log4j :( , but the upgrade is failing:

The script runs, but the webpage says:
Failed to start Unimus
Could not upgrade the database.
Please contact support or restart Unimus and try again.

last error in the logs is this:

Code: Select all

2022-01-06 08:15:24.447 ERROR 2233941 --- [SimpleAsyncTaskExecutor-1] n.u.b.d.LiquibaseChangeExecListenerImpl  : Failed to execute, rolling-back transaction

org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [update push_history_job set canceled = ?, result = ? where push_history_job.id = ?]; Cannot convert class com.sun.proxy.$Proxy287 to SQL type requested due to com.mysql.cj.exceptions.CJException - Start position [1] cannot exceed overall CLOB length [0]; nested exception is java.sql.SQLException: Cannot convert class com.sun.proxy.$Proxy287 to SQL type requested due to com.mysql.cj.exceptions.CJException - Start position [1] cannot exceed overall CLOB length [0]
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:110)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
        at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667)
        at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:960)
        at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:981)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:328)
        at net.unimus.business.database.LiquibaseChangeExecListenerImpl.lambda$updatingPushHistoryJob$31(LiquibaseChangeExecListenerImpl.java:1529)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
        at net.unimus.business.database.LiquibaseChangeExecListenerImpl.updatingPushHistoryJob(LiquibaseChangeExecListenerImpl.java:1500)
        at net.unimus.business.database.LiquibaseChangeExecListenerImpl.ran(LiquibaseChangeExecListenerImpl.java:439)
        at liquibase.changelog.visitor.UpdateVisitor.fireRan(UpdateVisitor.java:79)
        at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:57)
        at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111)
        at liquibase.Scope.lambda$child$0(Scope.java:160)
        at liquibase.Scope.child(Scope.java:169)
        at liquibase.Scope.child(Scope.java:159)
        at liquibase.Scope.child(Scope.java:138)
        at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:110)
        at liquibase.Scope.lambda$child$0(Scope.java:160)
        at liquibase.Scope.child(Scope.java:169)
        at liquibase.Scope.child(Scope.java:159)
        at liquibase.Scope.child(Scope.java:138)
        at liquibase.Scope.child(Scope.java:222)
        at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94)
        at liquibase.Scope.lambda$child$0(Scope.java:160)
        at liquibase.Scope.child(Scope.java:169)
        at liquibase.Scope.child(Scope.java:159)
        at liquibase.Scope.child(Scope.java:138)
        at liquibase.Scope.child(Scope.java:222)
        at liquibase.Scope.child(Scope.java:226)
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:66)
        at liquibase.Liquibase.lambda$null$0(Liquibase.java:273)
        at liquibase.Scope.lambda$child$0(Scope.java:160)
        at liquibase.Scope.child(Scope.java:169)
        at liquibase.Scope.child(Scope.java:159)
        at liquibase.Scope.child(Scope.java:138)
        at liquibase.Scope.child(Scope.java:222)
        at liquibase.Liquibase.lambda$update$1(Liquibase.java:272)
        at liquibase.Scope.lambda$child$0(Scope.java:160)
        at liquibase.Scope.child(Scope.java:169)
        at liquibase.Scope.child(Scope.java:159)
        at liquibase.Scope.child(Scope.java:138)
        at liquibase.Liquibase.runInScope(Liquibase.java:2322)
        at liquibase.Liquibase.update(Liquibase.java:216)
        at liquibase.Liquibase.update(Liquibase.java:202)
        at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:322)
        at net.unimus.business.database.DatabaseUpdateSupport.update(DatabaseUpdateSupport.java:56)
        at net.unimus.business.database.Database.update(Database.java:246)
        at net.unimus.business.database.Database$$FastClassBySpringCGLIB$$47ee56e2.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
        at net.unimus.business.database.Database$$EnhancerBySpringCGLIB$$1192e1df.update(<generated>)
        at net.unimus.system.bootstrap.boot.step.DatabaseUpdate.run(DatabaseUpdate.java:33)
        at net.unimus.system.bootstrap.boot.Boot.boot(Boot.java:94)
        at net.unimus.system.bootstrap.boot.Boot$$FastClassBySpringCGLIB$$e357c3b1.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
        at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.sql.SQLException: Cannot convert class com.sun.proxy.$Proxy287 to SQL type requested due to com.mysql.cj.exceptions.CJException - Start position [1] cannot exceed overall CLOB length [0]
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
        at com.mysql.cj.jdbc.ClientPreparedStatement.setObject(ClientPreparedStatement.java:1674)
        at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:409)
        at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:231)
        at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:146)
        at org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl.setValues(PreparedStatementCreatorFactory.java:283)
        at org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl.createPreparedStatement(PreparedStatementCreatorFactory.java:241)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
        ... 65 common frames omitted
Caused by: com.mysql.cj.exceptions.CJException: Start position [1] cannot exceed overall CLOB length [0]
        at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:100)
        at com.mysql.cj.ClientPreparedQueryBindings.setClob(ClientPreparedQueryBindings.java:403)
        at com.mysql.cj.AbstractQueryBindings.setObject(AbstractQueryBindings.java:1005)
        at com.mysql.cj.AbstractQueryBindings.setObject(AbstractQueryBindings.java:302)
        at com.mysql.cj.AbstractQueryBindings.setObject(AbstractQueryBindings.java:293)
        at com.mysql.cj.jdbc.ClientPreparedStatement.setObject(ClientPreparedStatement.java:1672)
        ... 71 common frames omitted
Caused by: java.sql.SQLException: Start position [1] cannot exceed overall CLOB length [0]
        at org.hibernate.engine.jdbc.ClobProxy.invoke(ClobProxy.java:129)
        at com.sun.proxy.$Proxy287.getSubString(Unknown Source)
        at com.mysql.cj.ClientPreparedQueryBindings.setClob(ClientPreparedQueryBindings.java:396)
        ... 75 common frames omitted

2022-01-06 08:15:24.519 ERROR 2233941 --- [SimpleAsyncTaskExecutor-1] n.u.s.b.boot.step.DatabaseUpdate         : Failed to update database schema. Reason = 'liquibase.exception.LiquibaseException: java.lang.RuntimeException: Failed to set canceled boolean value in push history jobs'
Vik@Unimus
Posts: 38
Joined: Thu Aug 05, 2021 6:35 pm

Fri Jan 07, 2022 12:41 pm

Hello,

Thank you for reaching out. Would you mind submitting a support ticket via our Portal? You can also attach Unimus' log you can find at:
Linux - /var/log/unimus
Windows - C:\ProgramData\Unimus\log

Thank you.
Post Reply