[
https://issues.apache.org/jira/browse/AIRAVATA-2517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16195056#comment-16195056
]
Marcus Christie commented on AIRAVATA-2517:
-------------------------------------------
This just happened again on iamdev.scigap.org.
{noformat}
...
2017-10-06 15:14:39,846 WARN
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Timer-2) SQL Error: 0,
SQLState: 08S0
1
2017-10-06 15:14:39,846 ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Timer-2) Communications
link failure
The last packet successfully received from the server was 1,947,975
milliseconds ago. The last packet sent successfully to the server was
1,048,058 milliseconds ago.
2017-10-06 15:14:39,852 WARN
[org.hibernate.resource.transaction.backend.jta.internal.synchronization.SynchronizationCallbackCoordinatorTrackingImpl]
(Transaction Reaper Worker 0) HHH000451: Transaction afterCompletion called by
a background thread; delaying afterCompletion processing until the original
thread can handle it. [status=4]
2017-10-06 15:14:39,853 WARN [com.arjuna.ats.arjuna] (Transaction Reaper
Worker 0) ARJUNA012113: TransactionReaper::doCancellations worker
Thread[Transaction Reaper Worker 0,5,main] missed interrupt when cancelling TX
0:ffff0a01000d:2ede7ddb:59c2c7c1:4235b -- exiting as zombie (zombie count
decremented to 0)
2017-10-06 15:14:39,855 ERROR [org.keycloak.services] (Timer-2)
KC-SERVICES0089: Failed to run scheduled task ClearExpiredEvents:
javax.persistence.PersistenceException: org.hibernate.HibernateException:
Transaction was rolled back in a different thread!
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
at
org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
at
org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:492)
at
org.keycloak.models.jpa.JpaRealmProvider.getRealms(JpaRealmProvider.java:99)
at
org.keycloak.models.cache.infinispan.RealmCacheSession.getRealms(RealmCacheSession.java:484)
at
org.keycloak.services.scheduled.ClearExpiredEvents.run(ClearExpiredEvents.java:34)
at
org.keycloak.services.scheduled.ClusterAwareScheduledTaskRunner$1.call(ClusterAwareScheduledTaskRunner.java:56)
at
org.keycloak.services.scheduled.ClusterAwareScheduledTaskRunner$1.call(ClusterAwareScheduledTaskRunner.java:52)
at
org.keycloak.cluster.infinispan.InfinispanClusterProvider.executeIfNotExecuted(InfinispanClusterProvider.java:72)
at
org.keycloak.services.scheduled.ClusterAwareScheduledTaskRunner.runTask(ClusterAwareScheduledTaskRunner.java:52)
at
org.keycloak.services.scheduled.ScheduledTaskRunner.run(ScheduledTaskRunner.java:45)
at
org.keycloak.timer.basic.BasicTimerProvider$1.run(BasicTimerProvider.java:51)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Caused by: org.hibernate.HibernateException: Transaction was rolled back in a
different thread!
at
org.hibernate.resource.transaction.backend.jta.internal.synchronization.SynchronizationCallbackCoordinatorTrackingImpl.processAnyDelayedAfterCompletion(SynchronizationCallbackCoordinatorTrackingImpl.java:90)
at
org.hibernate.internal.SessionImpl.delayedAfterCompletion(SessionImpl.java:627)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1332)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606)
at
org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:483)
... 11 more
...
{noformat}
Oddly I wasn't able to log into the server and I had to reboot it from the
Horizon web client (this is on Jetstream).
> Cannot view Users in seagrid gateway - Keycloak MySQL connection closed
> -----------------------------------------------------------------------
>
> Key: AIRAVATA-2517
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2517
> Project: Airavata
> Issue Type: Bug
> Environment: https://seagrid.org
> Reporter: Eroma
> Assignee: Marcus Christie
> Priority: Critical
> Attachments: Screen Shot 2017-09-14 at 10.49.25 AM.png
>
>
> Cannot view users in the gateway, getting Invalid argument supplied for
> foreach()
> this restrict giving access to new users. or changing roles of existing in
> the gateway.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
