Are you running on multiple nodes? If so, do you have the register cleaner only running on a single node?
On Tuesday, April 12, 2022 at 9:22:56 PM UTC-5 Anitha C wrote: > Anyone ran into the following issue in CAS v6.5.0 that is configured to > use JPA ticket registry and JPA ticket registry cleaner? > > 2022-04-12 15:50:27,090 ERROR > [org.apereo.cas.ticket.registry.DefaultTicketRegistryCleaner] - <Batch > update returned unexpected row count from update [0]; actual row count: 0; > expected: 1; statement executed: update Postgres_Jpa_Ticket_Entity set > body=?, creation_Time=?, parent_Id=?, principal_Id=?, type=? where id=?> > javax.persistence.OptimisticLockException: Batch update returned > unexpected row count from update [0]; actual row count: 0; expected: 1; > statement executed: update Postgres_Jpa_Ticket_Entity set body=?, > creation_Time=?, parent_Id=?, principal_Id=?, type=? where id=? > at > org.hibernate.internal.ExceptionConverterImpl.wrapStaleStateException(ExceptionConverterImpl.java:238) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:93) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1705) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.apereo.cas.ticket.registry.JpaTicketRegistry.deleteTicketGrantingTickets(JpaTicketRegistry.java:227) > > ~[cas-server-support-jpa-ticket-registry-6.5.0.jar:6.5.0] > at > org.apereo.cas.ticket.registry.JpaTicketRegistry.lambda$deleteSingleTicket$1(JpaTicketRegistry.java:198) > > ~[cas-server-support-jpa-ticket-registry-6.5.0.jar:6.5.0] > at > org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) > > ~[spring-tx-5.3.18.jar:5.3.18] > at > org.apereo.cas.ticket.registry.JpaTicketRegistry.deleteSingleTicket(JpaTicketRegistry.java:192) > > ~[cas-server-support-jpa-ticket-registry-6.5.0.jar:6.5.0] > at > org.apereo.cas.ticket.registry.AbstractTicketRegistry.deleteTicket(AbstractTicketRegistry.java:142) > > ~[cas-server-core-tickets-api-6.5.0.jar:6.5.0] > at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) ~[?:?] > at > jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > > ~[?:?] > at > jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > ~[?:?] > at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) > > ~[spring-aop-5.3.18.jar:5.3.18] > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) > > ~[spring-aop-5.3.18.jar:5.3.18] > at com.sun.proxy.$Proxy265.deleteTicket(Unknown Source) ~[?:?] > at > org.apereo.cas.ticket.registry.DefaultTicketRegistryCleaner.lambda$cleanTicket$0(DefaultTicketRegistryCleaner.java:56) > > ~[cas-server-core-tickets-api-6.5.0.jar:6.5.0] > at org.jooq.lambda.Unchecked.lambda$supplier$38(Unchecked.java:1695) > ~[jool-0.9.14.jar:?] > at > org.apereo.cas.util.lock.DefaultLockRepository.lambda$execute$0(DefaultLockRepository.java:33) > > ~[cas-server-core-api-util-6.5.0.jar:6.5.0] > at java.util.Optional.map(Optional.java:265) ~[?:?] > at > org.apereo.cas.util.lock.DefaultLockRepository.execute(DefaultLockRepository.java:31) > > ~[cas-server-core-api-util-6.5.0.jar:6.5.0] > at > org.apereo.cas.ticket.registry.DefaultTicketRegistryCleaner.cleanTicket(DefaultTicketRegistryCleaner.java:48) > > ~[cas-server-core-tickets-api-6.5.0.jar:6.5.0] > at > java.util.stream.ReferencePipeline$4$1.accept(ReferencePipeline.java:212) > ~[?:?] > at > java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177) > ~[?:?] > at > java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195) > ~[?:?] > at > java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195) > ~[?:?] > at > java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195) > ~[?:?] > at java.util.Iterator.forEachRemaining(Iterator.java:133) ~[?:?] > at > java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801) > > ~[?:?] > at > java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484) ~[?:?] > at > java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474) > ~[?:?] > at > java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913) > ~[?:?] > at > java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:?] > at java.util.stream.IntPipeline.reduce(IntPipeline.java:491) ~[?:?] > at java.util.stream.IntPipeline.sum(IntPipeline.java:449) ~[?:?] > at > org.hibernate.query.spi.IntStreamDecorator.sum(IntStreamDecorator.java:185) > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.apereo.cas.ticket.registry.DefaultTicketRegistryCleaner.cleanInternal(DefaultTicketRegistryCleaner.java:69) > > ~[cas-server-core-tickets-api-6.5.0.jar:6.5.0] > at > org.apereo.cas.ticket.registry.DefaultTicketRegistryCleaner.clean(DefaultTicketRegistryCleaner.java:39) > > ~[cas-server-core-tickets-api-6.5.0.jar:6.5.0] > at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) ~[?:?] > at > jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > > ~[?:?] > at > jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > ~[?:?] > at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) > > ~[spring-aop-5.3.18.jar:5.3.18] > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) > > ~[spring-aop-5.3.18.jar:5.3.18] > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) > > ~[spring-aop-5.3.18.jar:5.3.18] > at > org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) > > ~[spring-tx-5.3.18.jar:5.3.18] > at > org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) > > ~[spring-tx-5.3.18.jar:5.3.18] > at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) > > ~[spring-tx-5.3.18.jar:5.3.18] > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) > > ~[spring-aop-5.3.18.jar:5.3.18] > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) > > ~[spring-aop-5.3.18.jar:5.3.18] > at com.sun.proxy.$Proxy316.clean(Unknown Source) ~[?:?] > at > org.apereo.cas.config.CasCoreTicketsSchedulingConfiguration$TicketRegistryCleanerScheduler.run(CasCoreTicketsSchedulingConfiguration.java:94) > > ~[cas-server-core-tickets-6.5.0.jar:6.5.0] > at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) ~[?:?] > at > jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > > ~[?:?] > at > jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > ~[?:?] > at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] > at > org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84) > > ~[spring-context-5.3.18.jar:5.3.18] > at > org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) > > ~[spring-context-5.3.18.jar:5.3.18] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) > ~[?:?] > at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) > ~[?:?] > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) > > ~[?:?] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) > > ~[?:?] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) > > ~[?:?] > at java.lang.Thread.run(Thread.java:829) [?:?] > Caused by: org.hibernate.StaleStateException: Batch update returned > unexpected row count from update [0]; actual row count: 0; expected: 1; > statement executed: update Postgres_Jpa_Ticket_Entity set body=?, > creation_Time=?, parent_Id=?, principal_Id=?, type=? where id=? > at > org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:67) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:54) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.engine.jdbc.batch.internal.BatchingBatch.checkRowCounts(BatchingBatch.java:151) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:126) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:106) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:148) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:633) > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?] > at > org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:57) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1367) > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1471) > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.query.internal.AbstractProducedQuery.doExecuteUpdate(AbstractProducedQuery.java:1714) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > at > org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1696) > > ~[hibernate-core-5.6.5.Final.jar:5.6.5.Final] > -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/cc018d6c-f78c-4262-9e3c-ef8977962be3n%40apereo.org.
