[cas-user] CAS 6.5.2 JPA Google OTP broken

[Gregory G]

Hello,

I have this error with this :

cas.authn.mfa.gauth.jpa.driver-class=org.mariadb.jdbc.Driver
cas.authn.mfa.gauth.jpa.url=jdbc:mariadb://xxx
cas.authn.mfa.gauth.jpa.dialect=org.hibernate.dialect.MariaDB103Dialect

2022-04-07 17:19:44,129 ERROR 
[org.springframework.scheduling.support.TaskUtils$LoggingErrorHandler] - 
<Unexpected error occurred in scheduled task>
javax.persistence.TransactionRequiredException: Executing an update/delete 
query
        at 
org.hibernate.internal.AbstractSharedSessionContract.checkTransactionNeededForUpdateOperation(AbstractSharedSessionContract.java:445)
 
~[hibernate-core-5.6.5.Final.jar!/:5.6.5.Final]
        at 
org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1692)
 
~[hibernate-core-5.6.5.Final.jar!/:5.6.5.Final]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown 
Source) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown 
Source) ~[?:?]
        at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
        at 
org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:406)
 
~[spring-orm-5.3.18.jar!/:5.3.18]
        at com.sun.proxy.$Proxy327.executeUpdate(Unknown Source) ~[?:?]
        at 
org.apereo.cas.gauth.token.GoogleAuthenticatorJpaTokenRepository.cleanInternal(GoogleAuthenticatorJpaTokenRepository.java:42)
 
~[cas-server-support-gauth-jpa-6.5.2.jar!/:6.5.2]
        at 
org.apereo.cas.otp.repository.token.BaseOneTimeTokenRepository.clean(BaseOneTimeTokenRepository.java:21)
 
~[cas-server-support-otp-mfa-core-6.5.2.jar!/:6.5.2]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown 
Source) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown 
Source) ~[?:?]
        at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
        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.$Proxy248.clean(Unknown Source) ~[?:?]
        at 
org.apereo.cas.otp.repository.token.OneTimeTokenRepositoryCleaner.clean(OneTimeTokenRepositoryCleaner.java:29)
 
~[cas-server-support-otp-mfa-core-6.5.2.jar!/:6.5.2]
        at 
org.apereo.cas.config.support.authentication.GoogleAuthenticatorAuthenticationEventExecutionPlanConfiguration$GoogleAuthenticatorOneTimeTokenRepositoryCleaner.clean(GoogleAuthenticatorAuthenticationEventExecutionPlanConfiguration.java:336)
 
~[cas-server-support-gauth-6.5.2.jar!/:6.5.2]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown 
Source) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown 
Source) ~[?:?]
        at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
        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(Unknown 
Source) ~[?:?]
        at java.util.concurrent.FutureTask.runAndReset(Unknown Source) 
~[?:?]
        at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
 
Source) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown 
Source) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown 
Source) ~[?:?]
        at java.lang.Thread.run(Unknown Source) [?:?]

-- 
- 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 cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/ca32b90f-2bf5-4790-b7ca-02ef95c19338n%40apereo.org.