Problems with Postgresql after update to 1.0.0

[NikSozonov]

Hawkbit updated from 0.9.0 to 0.10.0 and then to 1.0.0
PostgreSQL 17.6

The problem is that all the rollouts we tried to delete are stuck in the 'Deleting' status. Also, there's a huge number of records in application log about data type errors in PostgreSQL.

Logs from jpa.init 1.0.0

10:55:47.275 [main] INFO  o.e.h.r.jpa.init.HawkbitFlywayDbInit -- Start (migrate): hawkbit@jdbc:postgresql://XXXXXX:6432/hawkbit, table: schema_version, locations: [db/migration], sql-migration-suffixes: POSTGRESQL.sql
10:55:48.450 [main] INFO  org.flywaydb.core.FlywayExecutor -- Database: jdbc:postgresql://XXXXXX:6432/hawkbit (PostgreSQL 17.6)
10:55:48.543 [main] DEBUG o.f.core.internal.command.DbValidate -- Validating migrations ...
10:55:48.620 [main] INFO  o.f.core.internal.command.DbValidate -- Successfully validated 26 migrations (execution time 00:00.074s)
10:55:48.772 [main] INFO  o.f.core.internal.command.DbMigrate -- Current version of schema "public": 1.12.39
10:55:48.782 [main] INFO  o.f.core.internal.command.DbMigrate -- Schema "public" is up to date. No migration necessary.

Application log

2026-04-06T13:11:14.829Z  INFO 1 --- [mgmt-server] [DEFAULT:test] [executor-pool-0] o.e.h.r.j.m.JpaRolloutManagement         : Found 1 active actions for rollout 94
2026-04-06T13:11:14.866Z ERROR 1 --- [mgmt-server] [DEFAULT:] [executor-pool-0] o.e.h.r.jpa.scheduler.JpaRolloutHandler  : Failed to process rollout with id 94
jakarta.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.9.v202601021151-061974965b9a70b72fdcb96dae36a4d6ef5df9ce): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 138
Error Code: 0
Call: UPDATE sp_target t SET t.assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = 1   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)
	bind => [1 parameter bound]
Query: DataModifyQuery(sql="UPDATE sp_target t SET t.assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = 1   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)")
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:313) ~[org.eclipse.persistence.jpa-4.0.9.jar:na]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.updateTargetAssignedDsWithFirstActiveAction(JpaRolloutManagement.java:617) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.forceQuitActionsOfRollout(JpaRolloutManagement.java:572) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.cancelActiveActionsForRollouts(JpaRolloutManagement.java:538) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:172) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.retry.annotation.AnnotationAwareRetryOperationsInterceptor.invoke(AnnotationAwareRetryOperationsInterceptor.java:165) ~[spring-retry-2.0.12.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement$$SpringCGLIB$$0.cancelActiveActionsForRollouts(<generated>) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.handleDeleteRollout(JpaRolloutExecutor.java:279) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute0$6(JpaRolloutExecutor.java:189) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asActor$2(AccessContext.java:174) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.asActor(AccessContext.java:183) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.asActor(AccessContext.java:173) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.execute0(JpaRolloutExecutor.java:189) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute$0(JpaRolloutExecutor.java:161) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.lambda$withSecurityContext$0(AccessContext.java:108) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:159) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:141) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:127) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:107) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute$1(JpaRolloutExecutor.java:161) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at java.base/java.util.Optional.ifPresentOrElse(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.execute(JpaRolloutExecutor.java:159) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor$$SpringCGLIB$$0.execute(<generated>) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at java.base/java.util.Optional.ifPresentOrElse(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.lambda$handleRolloutInNewTransaction$4(JpaRolloutHandler.java:109) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.utils.DeploymentHelper.runInNewTransaction(DeploymentHelper.java:107) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.utils.DeploymentHelper.runInNewTransaction(DeploymentHelper.java:88) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.handleRolloutInNewTransaction(JpaRolloutHandler.java:108) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.lambda$handleAll$0(JpaRolloutHandler.java:82) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at java.base/java.util.Vector.forEach(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.handleAll(JpaRolloutHandler.java:80) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler$$SpringCGLIB$$0.handleAll(<generated>) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.handleAll(RolloutScheduler.java:80) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.lambda$runningRolloutScheduler$2(RolloutScheduler.java:66) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.lambda$forEachTenantAsSystem$0(JpaSystemManagement.java:151) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asSystemAsTenant$4(AccessContext.java:231) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:155) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:145) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:252) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:230) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.lambda$forEachTenantAsSystem$1(JpaSystemManagement.java:149) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at java.base/java.lang.Iterable.forEach(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.forEachTenantAsSystem(JpaSystemManagement.java:149) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:172) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.retry.annotation.AnnotationAwareRetryOperationsInterceptor.invoke(AnnotationAwareRetryOperationsInterceptor.java:165) ~[spring-retry-2.0.12.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement$$SpringCGLIB$$0.forEachTenantAsSystem(<generated>) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.lambda$runningRolloutScheduler$3(RolloutScheduler.java:64) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asSystem$3(AccessContext.java:200) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:155) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:141) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:252) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.context.AccessContext.asSystem(AccessContext.java:199) ~[hawkbit-core-1.0.0.jar:1.0.0]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.runningRolloutScheduler(RolloutScheduler.java:60) ~[hawkbit-repository-jpa-1.0.0.jar:1.0.0]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.runInternal(ScheduledMethodRunnable.java:130) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.lambda$run$2(ScheduledMethodRunnable.java:124) ~[spring-context-6.2.17.jar:6.2.17]
	at io.micrometer.observation.Observation.observe(Observation.java:498) ~[micrometer-observation-1.15.10.jar:1.15.10]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:124) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.config.Task$OutcomeTrackingRunnable.run(Task.java:87) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.security.concurrent.DelegatingSecurityContextRunnable.run(DelegatingSecurityContextRunnable.java:94) ~[spring-security-core-6.5.9.jar:6.5.9]
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:na]
	at java.base/java.lang.Thread.run(Unknown Source) ~[na:na]
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.9.v202601021151-061974965b9a70b72fdcb96dae36a4d6ef5df9ce): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 138
Error Code: 0
Call: UPDATE sp_target t SET t.assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = 1   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)
	bind => [1 parameter bound]
Query: DataModifyQuery(sql="UPDATE sp_target t SET t.assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = 1   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:343) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1805) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:917) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:981) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:569) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2067) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:311) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:280) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:266) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:323) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:294) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:88) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:812) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3031) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1860) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1842) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1807) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:303) ~[org.eclipse.persistence.jpa-4.0.9.jar:na]
	... 139 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 138
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2875) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2560) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:429) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:526) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:436) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:196) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:157) ~[postgresql-42.7.10.jar:42.7.10]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-6.3.3.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-6.3.3.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:909) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	... 156 common frames omitted

[strailov]

Hello @NikSozonov .
Indeed it looks like there are some problems with postgresql. We will introduce fixes and release 1.0.1with them as soon as possible.

[strailov]

@NikSozonov 1.0.1 is already available.

[NikSozonov]

Hello @strailov ,
Thanks for the fast response.
Updated to 1.0.1.
Deleted rollouts are still stuck in the "deleting" status, but the log is now different.

2026-04-07T11:18:54.889Z ERROR 1 --- [mgmt-server] [DEFAULT:] [executor-pool-0] o.e.h.r.jpa.scheduler.JpaRolloutHandler  : Failed to process rollout with id 94
jakarta.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.9.v202601021151-061974965b9a70b72fdcb96dae36a4d6ef5df9ce): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "t" of relation "sp_target" does not exist
  Hint: SET target columns cannot be qualified with the relation name.
  Position: 24
Error Code: 0
Call: UPDATE sp_target t SET t.assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)
	bind => [1 parameter bound]
Query: DataModifyQuery(sql="UPDATE sp_target t SET t.assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)")
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:313) ~[org.eclipse.persistence.jpa-4.0.9.jar:na]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.updateTargetAssignedDsWithFirstActiveAction(JpaRolloutManagement.java:617) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.forceQuitActionsOfRollout(JpaRolloutManagement.java:572) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.cancelActiveActionsForRollouts(JpaRolloutManagement.java:538) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:172) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.retry.annotation.AnnotationAwareRetryOperationsInterceptor.invoke(AnnotationAwareRetryOperationsInterceptor.java:165) ~[spring-retry-2.0.12.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement$$SpringCGLIB$$0.cancelActiveActionsForRollouts(<generated>) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.handleDeleteRollout(JpaRolloutExecutor.java:279) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute0$6(JpaRolloutExecutor.java:189) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asActor$2(AccessContext.java:174) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.asActor(AccessContext.java:183) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.asActor(AccessContext.java:173) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.execute0(JpaRolloutExecutor.java:189) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute$0(JpaRolloutExecutor.java:161) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.lambda$withSecurityContext$0(AccessContext.java:108) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:159) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:141) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:127) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:107) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute$1(JpaRolloutExecutor.java:161) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at java.base/java.util.Optional.ifPresentOrElse(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.execute(JpaRolloutExecutor.java:159) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor$$SpringCGLIB$$0.execute(<generated>) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at java.base/java.util.Optional.ifPresentOrElse(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.lambda$handleRolloutInNewTransaction$4(JpaRolloutHandler.java:109) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.utils.DeploymentHelper.runInNewTransaction(DeploymentHelper.java:107) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.utils.DeploymentHelper.runInNewTransaction(DeploymentHelper.java:88) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.handleRolloutInNewTransaction(JpaRolloutHandler.java:108) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.lambda$handleAll$0(JpaRolloutHandler.java:82) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at java.base/java.util.Vector.forEach(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.handleAll(JpaRolloutHandler.java:80) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler$$SpringCGLIB$$0.handleAll(<generated>) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.handleAll(RolloutScheduler.java:80) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.lambda$runningRolloutScheduler$2(RolloutScheduler.java:66) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.lambda$forEachTenantAsSystem$0(JpaSystemManagement.java:151) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asSystemAsTenant$4(AccessContext.java:231) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:155) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:145) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:252) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:230) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.lambda$forEachTenantAsSystem$1(JpaSystemManagement.java:149) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at java.base/java.lang.Iterable.forEach(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.forEachTenantAsSystem(JpaSystemManagement.java:149) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:172) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.retry.annotation.AnnotationAwareRetryOperationsInterceptor.invoke(AnnotationAwareRetryOperationsInterceptor.java:165) ~[spring-retry-2.0.12.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement$$SpringCGLIB$$0.forEachTenantAsSystem(<generated>) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.lambda$runningRolloutScheduler$3(RolloutScheduler.java:64) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asSystem$3(AccessContext.java:200) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:155) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:141) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:252) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.context.AccessContext.asSystem(AccessContext.java:199) ~[hawkbit-core-1.0.1.jar:1.0.1]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.runningRolloutScheduler(RolloutScheduler.java:60) ~[hawkbit-repository-jpa-1.0.1.jar:1.0.1]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.runInternal(ScheduledMethodRunnable.java:130) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.lambda$run$2(ScheduledMethodRunnable.java:124) ~[spring-context-6.2.17.jar:6.2.17]
	at io.micrometer.observation.Observation.observe(Observation.java:498) ~[micrometer-observation-1.15.10.jar:1.15.10]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:124) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.config.Task$OutcomeTrackingRunnable.run(Task.java:87) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.security.concurrent.DelegatingSecurityContextRunnable.run(DelegatingSecurityContextRunnable.java:94) ~[spring-security-core-6.5.9.jar:6.5.9]
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:na]
	at java.base/java.lang.Thread.run(Unknown Source) ~[na:na]
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.9.v202601021151-061974965b9a70b72fdcb96dae36a4d6ef5df9ce): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "t" of relation "sp_target" does not exist
  Hint: SET target columns cannot be qualified with the relation name.
  Position: 24
Error Code: 0
Call: UPDATE sp_target t SET t.assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)
	bind => [1 parameter bound]
Query: DataModifyQuery(sql="UPDATE sp_target t SET t.assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:343) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1805) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:917) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:981) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:569) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2067) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:311) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:280) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:266) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:323) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:294) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:88) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:812) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3031) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1860) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1842) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1807) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:303) ~[org.eclipse.persistence.jpa-4.0.9.jar:na]
	... 139 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: column "t" of relation "sp_target" does not exist
  Hint: SET target columns cannot be qualified with the relation name.
  Position: 24
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2875) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2560) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:429) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:526) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:436) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:196) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:157) ~[postgresql-42.7.10.jar:42.7.10]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-6.3.3.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-6.3.3.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:909) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	... 156 common frames omitted```

[strailov]

 @NikSozonov  just released 1.0.2.
Hopefully you shouldn't have problems anymore ...

[NikSozonov]

@strailov New rollouts are working fine after the update. Most old ones are deleted, except for two.

Stuck rollouts

   {
      "createdBy": "test",
      "createdAt": 1774519426953,
      "lastModifiedBy": "test",
      "lastModifiedAt": 1774519444151,
      "name": "test-2-1",
      "description": "",
      "id": 88,
      "targetFilterQuery": "controllerId==XXX-uav-*",
      "distributionSetId": 2,
      "status": "deleting",
      "totalTargets": 2,
      "forcetime": 0,
      "deleted": false,
      "type": "soft",
      "weight": 1000,
      "dynamic": false,
      "_links": {
        "self": {
          "href": "https://XXX/rest/v1/rollouts/88"
        }
      }
    },
    {
      "createdBy": "test",
      "createdAt": 1774519708418,
      "lastModifiedBy": "test",
      "lastModifiedAt": 1774519721952,
      "name": "test-2-2",
      "description": "",
      "id": 89,
      "targetFilterQuery": "controllerId==XXX-uav-*",
      "distributionSetId": 2,
      "status": "deleting",
      "totalTargets": 2,
      "forcetime": 0,
      "deleted": false,
      "type": "soft",
      "weight": 1000,
      "dynamic": false,
      "_links": {
        "self": {
          "href": "https://XXX/rest/v1/rollouts/89"
        }
      }
    }

Log

2026-04-08T07:30:22.744Z  INFO 1 --- [mgmt-server] [DEFAULT:test] [executor-pool-0] o.e.h.r.j.m.JpaRolloutManagement         : Found 0 active actions for rollout 88
2026-04-08T07:30:22.747Z ERROR 1 --- [mgmt-server] [DEFAULT:] [executor-pool-0] o.e.h.r.jpa.scheduler.JpaRolloutHandler  : Failed to process rollout with id 88
jakarta.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.9.v202601021151-061974965b9a70b72fdcb96dae36a4d6ef5df9ce): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 185
Error Code: 0
Call: UPDATE sp_target t SET assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)
	bind => [1 parameter bound]
Query: DataModifyQuery(sql="UPDATE sp_target t SET assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)")
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:313) ~[org.eclipse.persistence.jpa-4.0.9.jar:na]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.updateTargetAssignedDsWithFirstActiveAction(JpaRolloutManagement.java:617) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.forceQuitActionsOfRollout(JpaRolloutManagement.java:572) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.cancelActiveActionsForRollouts(JpaRolloutManagement.java:538) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:172) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.retry.annotation.AnnotationAwareRetryOperationsInterceptor.invoke(AnnotationAwareRetryOperationsInterceptor.java:165) ~[spring-retry-2.0.12.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement$$SpringCGLIB$$0.cancelActiveActionsForRollouts(<generated>) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.handleDeleteRollout(JpaRolloutExecutor.java:279) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute0$6(JpaRolloutExecutor.java:189) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asActor$2(AccessContext.java:174) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asActor(AccessContext.java:183) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asActor(AccessContext.java:173) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.execute0(JpaRolloutExecutor.java:189) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute$0(JpaRolloutExecutor.java:161) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.lambda$withSecurityContext$0(AccessContext.java:108) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:159) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:141) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:127) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:107) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute$1(JpaRolloutExecutor.java:161) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/java.util.Optional.ifPresentOrElse(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.execute(JpaRolloutExecutor.java:159) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor$$SpringCGLIB$$0.execute(<generated>) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/java.util.Optional.ifPresentOrElse(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.lambda$handleRolloutInNewTransaction$4(JpaRolloutHandler.java:109) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.utils.DeploymentHelper.runInNewTransaction(DeploymentHelper.java:107) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.utils.DeploymentHelper.runInNewTransaction(DeploymentHelper.java:88) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.handleRolloutInNewTransaction(JpaRolloutHandler.java:108) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.lambda$handleAll$0(JpaRolloutHandler.java:82) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/java.util.Vector.forEach(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.handleAll(JpaRolloutHandler.java:80) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler$$SpringCGLIB$$0.handleAll(<generated>) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.handleAll(RolloutScheduler.java:80) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.lambda$runningRolloutScheduler$2(RolloutScheduler.java:66) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.lambda$forEachTenantAsSystem$0(JpaSystemManagement.java:151) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asSystemAsTenant$4(AccessContext.java:231) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:155) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:145) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:252) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:230) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.lambda$forEachTenantAsSystem$1(JpaSystemManagement.java:149) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/java.lang.Iterable.forEach(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.forEachTenantAsSystem(JpaSystemManagement.java:149) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:172) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.retry.annotation.AnnotationAwareRetryOperationsInterceptor.invoke(AnnotationAwareRetryOperationsInterceptor.java:165) ~[spring-retry-2.0.12.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement$$SpringCGLIB$$0.forEachTenantAsSystem(<generated>) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.lambda$runningRolloutScheduler$3(RolloutScheduler.java:64) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asSystem$3(AccessContext.java:200) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:155) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:141) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:252) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asSystem(AccessContext.java:199) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.runningRolloutScheduler(RolloutScheduler.java:60) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.runInternal(ScheduledMethodRunnable.java:130) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.lambda$run$2(ScheduledMethodRunnable.java:124) ~[spring-context-6.2.17.jar:6.2.17]
	at io.micrometer.observation.Observation.observe(Observation.java:498) ~[micrometer-observation-1.15.10.jar:1.15.10]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:124) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.config.Task$OutcomeTrackingRunnable.run(Task.java:87) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.security.concurrent.DelegatingSecurityContextRunnable.run(DelegatingSecurityContextRunnable.java:94) ~[spring-security-core-6.5.9.jar:6.5.9]
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:na]
	at java.base/java.lang.Thread.run(Unknown Source) ~[na:na]
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.9.v202601021151-061974965b9a70b72fdcb96dae36a4d6ef5df9ce): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 185
Error Code: 0
Call: UPDATE sp_target t SET assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)
	bind => [1 parameter bound]
Query: DataModifyQuery(sql="UPDATE sp_target t SET assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:343) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1805) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:917) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:981) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:569) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2067) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:311) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:280) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:266) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:323) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:294) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:88) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:812) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3031) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1860) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1842) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1807) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:303) ~[org.eclipse.persistence.jpa-4.0.9.jar:na]
	... 139 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 185
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2875) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2560) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:429) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:526) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:436) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:196) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:157) ~[postgresql-42.7.10.jar:42.7.10]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-6.3.3.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-6.3.3.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:909) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	... 156 common frames omitted

2026-04-08T07:30:22.752Z  INFO 1 --- [mgmt-server] [DEFAULT:test] [executor-pool-0] o.e.h.r.j.m.JpaRolloutManagement         : Found 0 active actions for rollout 89
2026-04-08T07:30:22.754Z ERROR 1 --- [mgmt-server] [DEFAULT:] [executor-pool-0] o.e.h.r.jpa.scheduler.JpaRolloutHandler  : Failed to process rollout with id 89
jakarta.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.9.v202601021151-061974965b9a70b72fdcb96dae36a4d6ef5df9ce): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 185
Error Code: 0
Call: UPDATE sp_target t SET assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)
	bind => [1 parameter bound]
Query: DataModifyQuery(sql="UPDATE sp_target t SET assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)")
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:313) ~[org.eclipse.persistence.jpa-4.0.9.jar:na]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.updateTargetAssignedDsWithFirstActiveAction(JpaRolloutManagement.java:617) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.forceQuitActionsOfRollout(JpaRolloutManagement.java:572) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement.cancelActiveActionsForRollouts(JpaRolloutManagement.java:538) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:172) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.retry.annotation.AnnotationAwareRetryOperationsInterceptor.invoke(AnnotationAwareRetryOperationsInterceptor.java:165) ~[spring-retry-2.0.12.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.management.JpaRolloutManagement$$SpringCGLIB$$0.cancelActiveActionsForRollouts(<generated>) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.handleDeleteRollout(JpaRolloutExecutor.java:279) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute0$6(JpaRolloutExecutor.java:189) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asActor$2(AccessContext.java:174) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asActor(AccessContext.java:183) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asActor(AccessContext.java:173) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.execute0(JpaRolloutExecutor.java:189) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute$0(JpaRolloutExecutor.java:161) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.lambda$withSecurityContext$0(AccessContext.java:108) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:159) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:141) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:127) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:107) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.lambda$execute$1(JpaRolloutExecutor.java:161) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/java.util.Optional.ifPresentOrElse(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor.execute(JpaRolloutExecutor.java:159) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutExecutor$$SpringCGLIB$$0.execute(<generated>) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/java.util.Optional.ifPresentOrElse(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.lambda$handleRolloutInNewTransaction$4(JpaRolloutHandler.java:109) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.utils.DeploymentHelper.runInNewTransaction(DeploymentHelper.java:107) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.utils.DeploymentHelper.runInNewTransaction(DeploymentHelper.java:88) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.handleRolloutInNewTransaction(JpaRolloutHandler.java:108) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.lambda$handleAll$0(JpaRolloutHandler.java:82) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/java.util.Vector.forEach(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler.handleAll(JpaRolloutHandler.java:80) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.scheduler.JpaRolloutHandler$$SpringCGLIB$$0.handleAll(<generated>) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.handleAll(RolloutScheduler.java:80) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.lambda$runningRolloutScheduler$2(RolloutScheduler.java:66) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.lambda$forEachTenantAsSystem$0(JpaSystemManagement.java:151) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asSystemAsTenant$4(AccessContext.java:231) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:155) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:145) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:252) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:230) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.lambda$forEachTenantAsSystem$1(JpaSystemManagement.java:149) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/java.lang.Iterable.forEach(Unknown Source) ~[na:na]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement.forEachTenantAsSystem(JpaSystemManagement.java:149) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:172) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.retry.annotation.AnnotationAwareRetryOperationsInterceptor.invoke(AnnotationAwareRetryOperationsInterceptor.java:165) ~[spring-retry-2.0.12.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.proceed(AuthorizationManagerBeforeMethodInterceptor.java:268) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.attemptAuthorization(AuthorizationManagerBeforeMethodInterceptor.java:263) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:196) ~[spring-security-core-6.5.9.jar:6.5.9]
	at org.springframework.security.config.annotation.method.configuration.DeferringMethodInterceptor.invoke(DeferringMethodInterceptor.java:44) ~[spring-security-config-6.5.9.jar:6.5.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728) ~[spring-aop-6.2.17.jar:6.2.17]
	at org.eclipse.hawkbit.repository.jpa.management.JpaSystemManagement$$SpringCGLIB$$0.forEachTenantAsSystem(<generated>) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.lambda$runningRolloutScheduler$3(RolloutScheduler.java:64) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.lambda$asSystem$3(AccessContext.java:200) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asActor(Mdc.java:155) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.asTenantAsActor0(Mdc.java:141) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuth(Mdc.java:80) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.Mdc.withAuthRe(Mdc.java:93) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.withSecurityContext(AccessContext.java:137) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asSystemAsTenant(AccessContext.java:252) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.context.AccessContext.asSystem(AccessContext.java:199) ~[hawkbit-core-1.0.2.jar:1.0.2]
	at org.eclipse.hawkbit.repository.jpa.scheduler.RolloutScheduler.runningRolloutScheduler(RolloutScheduler.java:60) ~[hawkbit-repository-jpa-1.0.2.jar:1.0.2]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.runInternal(ScheduledMethodRunnable.java:130) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.lambda$run$2(ScheduledMethodRunnable.java:124) ~[spring-context-6.2.17.jar:6.2.17]
	at io.micrometer.observation.Observation.observe(Observation.java:498) ~[micrometer-observation-1.15.10.jar:1.15.10]
	at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:124) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.config.Task$OutcomeTrackingRunnable.run(Task.java:87) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-6.2.17.jar:6.2.17]
	at org.springframework.security.concurrent.DelegatingSecurityContextRunnable.run(DelegatingSecurityContextRunnable.java:94) ~[spring-security-core-6.5.9.jar:6.5.9]
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:na]
	at java.base/java.lang.Thread.run(Unknown Source) ~[na:na]
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.9.v202601021151-061974965b9a70b72fdcb96dae36a4d6ef5df9ce): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 185
Error Code: 0
Call: UPDATE sp_target t SET assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)
	bind => [1 parameter bound]
Query: DataModifyQuery(sql="UPDATE sp_target t SET assigned_distribution_set = ( SELECT a.distribution_set   FROM sp_action a   WHERE a.target = t.id AND a.active = TRUE   ORDER BY a.id ASC   LIMIT 1) WHERE t.id IN (?)")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:343) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1805) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:917) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:981) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:569) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2067) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:311) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:280) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:266) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:323) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:294) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:88) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:812) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3031) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1860) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1842) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1807) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:303) ~[org.eclipse.persistence.jpa-4.0.9.jar:na]
	... 139 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 185
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2875) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2560) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:429) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:526) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:436) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:196) ~[postgresql-42.7.10.jar:42.7.10]
	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:157) ~[postgresql-42.7.10.jar:42.7.10]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-6.3.3.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-6.3.3.jar:na]
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:909) ~[org.eclipse.persistence.core-4.0.9.jar:na]
	... 156 common frames omitted

[NikSozonov]

Maybe delete these rollouts using an SQL query?

[strailov]

Deleting directly rollout entities may solve the case, but it could leave some data in database related to those rollouts which potentially could cause problems.
I've released 1.0.3 with fix for this, and also for a case with dynamic rollouts.

[NikSozonov]

At this time, there are no errors and rollouts are working. Thank you!