]
Wolf-Dieter Fink updated WFLY-8043:
-----------------------------------
Summary: Timer fails if transaction isolation set to SERIALIZABLE (was: Timer fails
if transaction isolation set to SERIALIZABLE on Oracle 11g)
Timer fails if transaction isolation set to SERIALIZABLE
--------------------------------------------------------
Key: WFLY-8043
URL:
https://issues.jboss.org/browse/WFLY-8043
Project: WildFly
Issue Type: Bug
Components: EJB
Affects Versions: 8.2.0.Final, 10.0.0.Final
Environment: Linux, JDK8, Oracle DB 11g
Reporter: Wolf-Dieter Fink
If the transaction isolation level is set to SERIALIZABLE if one node aquires the row
lock via the
UPDATE JBOSS_EJB_TIMER..
the other nodes throw an
ORA-08177: can't serialize access for this transaction
exception.
The timer thats row threw the exception never runs any more, not even in case the other
nodes were shut down.
The serialization exception is also thrown upon server/application startup sometimes.