[
https://issues.jboss.org/browse/WFLY-6412?page=com.atlassian.jira.plugin....
]
Wolf-Dieter Fink commented on WFLY-6412:
----------------------------------------
The same happen for any other database
Here Postgres Stacktrace:
Caused by: org.postgresql.util.PSQLException: ERROR: could not serialize access due to
concurrent update
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:135)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:423)
at com.sun.proxy.$Proxy10.executeUpdate(Unknown Source)
at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)
at
org.jboss.as.ejb3.timerservice.persistence.database.DatabaseTimerPersistence.shouldRun(DatabaseTimerPersistence.java:410)
Timer fails if transaction isolation set to SERIALIZABLE on Oracle
11g
----------------------------------------------------------------------
Key: WFLY-6412
URL:
https://issues.jboss.org/browse/WFLY-6412
Project: WildFly
Issue Type: Bug
Components: EJB
Affects Versions: 8.2.0.Final, 10.0.0.Final
Environment: Linux, JDK8, Oracle DB 11g
Reporter: Gábor Péntek
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.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)