Subject Re: [Firebird-Java] Jaybird 2.2.11 READ_COMMITTED Deadlocks
Author Sascha Horn
Post date 2016-11-15T11:00:09Z

Hello Mark,

the hint with no_rec_version was the right one.

isql really uses no_rec_version by default.
I reconfigured the xaDatasource to use no_rec_version and everything works like expected.

Thank you.

Sascha

Am 14.11.2016 um 20:58 schrieb Mark Rotteveel mark@... [Firebird-Java]:
 

Right now I don't have time to try it out, but I believe the difference
is that ISQL defaults to no_rec_version, while Jaybird defaults to
rec_version. I'll try to find some time to give a better researched
answer later this week.

Note however that - again iirc - even with no_rec_version you can get
that exception depending on which transaction was started first (eg try
to commit terminal two first, then terminal one). And your Java code is
more susceptible to data races than doing two updates manually in a
controlled fashion in two terminals.

You can try changing the isolation definition to use no_rec_version.

Mark

On 2016-11-14 20:34, Sascha Horn s.horn@... [Firebird-Java] wrote:
> Sure.
>
> isql
>
> I open two terminals and run isql.
>
> Connect both isql with the same database (connect test.fdb user
> USERNAME password password;).
>
> Terminal 1: set transaction read committed;
>
> Terminal 1: UPDATE ITEM_TYPES SET ITEM_TYPE = 1 WHERE ITEM_TYPE = 1;
>
> Terminal 2: set transaction read committed;
>
> Terminal 2: UPDATE ITEM_TYPES SET ITEM_TYPE = 1 WHERE ITEM_TYPE = 1;
>
> Terminal 1: commit;
>
> Terminal 2 commit;
>
> java (JBOSS) client server call
>
> Stateless SessionBean ContainerManagedTransactions
>
> @Resource(mappedName = "java:/jdbc/TestDB")
> private DataSource dataSource;
>
> public void test() throws Exception{
>
> try (Connection con = dataSource.getConnection()){
>
> try (Statement stmt = con.createStatement()){
>
> stmt.executeUpdate("UPDATE ITEM_TYPES SET ITEM_TYPE = 1
> WHERE ITEM_TYPE = 1");
>
> // simulate work
>
> Thread.sleep(5000);
>
> }
>
> }
>
> }
>
> Two clients call the test() method at the same time.
>
> when the first client has finished the test() call, the second one
> gets this deadlock.
>
> In my opinion this is no deadlock. This behavior is expected with NO
> WAIT, but i use WAIT.

It is expected for the combination rec_version and wait as used by
Jaybird.

>
> Sascha
> Am 14.11.2016 um 18:52 schrieb 'Mark Rotteveel' mark@...
> [Firebird-Java]:
>
>> Could you post the Java code, and what you do in isql?
>>
>> Iirc this error should occur in isql as well.
>>
>> Mark
>> ----- Bericht beantwoorden -----
>> Van: "Sascha Horn s.horn@... [Firebird-Java]"
>> <Firebird-Java@yahoogroups.com>
>> Aan: <Firebird-Java@yahoogroups.com>
>> Onderwerp: [Firebird-Java] Jaybird 2.2.11 READ_COMMITTED Deadlocks
>> Datum: ma, nov. 14, 2016 16:16
>>
>> Hello,
>>
>> i use FBXADataSource in JBoss Application Server.
>> Firebird SuperServer v2.5.6 on linux.
>>
>> The isolation level is set to READ_COMMITTED.
>>
>> Now i execute the following statement in two separate transactions:
>>
>> UPDATE ITEM_TYPES SET ITEM_TYPE = 1 WHERE ITEM_TYPE = 1;
>>
>> My expectations are, that the second transaction waits until first
>> transaction commits.
>> After that it procees with the update statement.
>>
>> In isql this works as expected.
>>
>> In JBoss using FBXADataSource the following exception is thrown:
>>
>> update conflicts with concurrent updateconcurrent transaction number
>> is
>> 36123
>> at
>>
> de.procar.ecaros2.server.ItemModuleBean.test(ItemModuleBean.java:12834)
>>
>> [ecaros2-server-DEV.jar:DEV]
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> [rt.jar:1.8.0_111]
>> at
>>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>
>> [rt.jar:1.8.0_111]
>> at
>>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>
>> [rt.jar:1.8.0_111]
>> at java.lang.reflect.Method.invoke(Method.java:498)
>> [rt.jar:1.8.0_111]
>> at
>>
> org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:278)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:330)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:242)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.remote.EJBRemoteTransactionPropagatingInterceptor.processInvocation(EJBRemoteTransactionPropagatingInterceptor.java:79)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.security.AuthorizationInterceptor.processInvocation(AuthorizationInterceptor.java:116)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:86)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.as.ejb3.remote.protocol.versionone.MethodInvocationMessageHandler.invokeMethod(MethodInvocationMessageHandler.java:332)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.as.ejb3.remote.protocol.versionone.MethodInvocationMessageHandler.access$100(MethodInvocationMessageHandler.java:69)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.as.ejb3.remote.protocol.versionone.MethodInvocationMessageHandler$1.run(MethodInvocationMessageHandler.java:202)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>>
>> [rt.jar:1.8.0_111]
>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>> [rt.jar:1.8.0_111]
>> at
>>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>
>> [rt.jar:1.8.0_111]
>> at
>>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>
>> [rt.jar:1.8.0_111]
>> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_111]
>> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
>> Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception.
>> 335544336. deadlockupdate conflicts with concurrent updateconcurrent
>>
>> transaction number is 36123
>> at
>>
> org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:262)
>>
>> [jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11
>> date=201608071009)]
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> [rt.jar:1.8.0_111]
>> at
>>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>
>> [rt.jar:1.8.0_111]
>> at
>>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>
>> [rt.jar:1.8.0_111]
>> at java.lang.reflect.Method.invoke(Method.java:498)
>> [rt.jar:1.8.0_111]
>> at
>>
> org.firebirdsql.ds.StatementHandler.invoke(StatementHandler.java:112)
>>
>> [jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11
>> date=201608071009)]
>> at com.sun.proxy.$Proxy173.executeUpdate(Unknown Source)
>> at
>>
> org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:375)
>> at
>>
> de.procar.sql.bundle.basic.BundleContainer.executeLockStatement(BundleContainer.java:388)
>>
>> [ecaros2-sqlbundle-DEV.jar:DEV]
>> at
>>
> de.procar.sql.bundle.basic.DefaultSQLBundle.lockContainer(DefaultSQLBundle.java:865)
>>
>> [ecaros2-sqlbundle-DEV.jar:DEV]
>> at
>>
> de.procar.ecaros2.server.MainClientDataSourceBean.lockContainer(MainClientDataSourceBean.java:800)
>>
>> [ecaros2-server-DEV.jar:DEV]
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> [rt.jar:1.8.0_111]
>> at
>>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>
>> [rt.jar:1.8.0_111]
>> at
>>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>
>> [rt.jar:1.8.0_111]
>> at java.lang.reflect.Method.invoke(Method.java:498)
>> [rt.jar:1.8.0_111]
>> at
>>
> org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:257)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:332)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:242)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.security.AuthorizationInterceptor.processInvocation(AuthorizationInterceptor.java:116)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:86)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)
>>
>> [jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
>>
>> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
>> at
>>
> org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
>>
>> [jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
>> at
>>
> de.procar.ecaros2.server.MainClientDataSourceLocal$$$view154.lockContainer(Unknown
>>
>> Source) [ecaros2-server-DEV.jar:DEV]
>> at
>>
> de.procar.ecaros2.server.ItemModuleBean.test(ItemModuleBean.java:12819)
>>
>> [ecaros2-server-DEV.jar:DEV] ... 58 more
>> Caused by: org.firebirdsql.gds.GDSException: deadlockupdate
>> conflicts
>> with concurrent updateconcurrent transaction number is 36123
>> at
>>
> org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2120)
>>
>> [jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11
>> date=201608071009)]
>> at
>>
> org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2070)
>>
>> [jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11
>> date=201608071009)]
>> at
>>
> org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlExecute2(AbstractJavaGDSImpl.java:1162)
>>
>> [jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11
>> date=201608071009)]
>> at
>>
> org.firebirdsql.gds.impl.GDSHelper.executeStatement(GDSHelper.java:251)
>>
>> [jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11
>> date=201608071009)]
>> at
>>
> org.firebirdsql.jdbc.AbstractStatement.internalExecute(AbstractStatement.java:1371)
>>
>> [jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11
>> date=201608071009)]
>> at
>>
> org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:258)
>>
>> [jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11
>> date=201608071009)] ... 121 more
>>
>> Debugging the FBXADataSource shows that the following transaction
>> parameters are used:
>> 9 = isc_tpb_write
>> 6 = isc_tpb_wait
>> 15 = isc_tpb_read_committed
>> 17 = isc_tpb_rec_version
>>
>> Any ideas what went wrong?
>> This is reproduceable.
>>
>> I will attach my jboss datasource configuration.
>>
>> Thanks in advance.
>>
>> Regards.
>>
>> --
>> Mit freundlichen Grüßen,
>>
>> Sascha Horn
>> Dipl. Ing. Informationstechnik (BA)
>>
>> procar informatik AG
>> Software Entwicklung
>>
>> Stammsitz in Darmstadt:
>>
>> procar informatik AG
>> Heinrich-Hertz-Str. 1
>> 64295 Darmstadt
>>
>> Geschäftsstelle Berlin:
>>
>> Justus-von-Liebig-Str.7
>> 12489 Berlin-Adlershof
>>
>> Geschäftsstelle Leipzig:
>>
>> Schongauer Straße 29-31
>> 04328 Leipzig
>>
>> Telefon (Zentrale): +49 6151/85048-0
>> Fax (Zentrale): +49 6151/85048-29
>>
>> mailto:info@...
>> http://www.procar.de
>> http://www.facebook.com/procar.de
>>
>> Amtsgericht Darmstadt HRB 8268
>> USt.-IdNr. DE195354166
>> Vorstand: Dipl.-Ing. Volker Holthaus, Karl-Heinz Schlapp
>> Vorsitzender des Aufsichtsrats: Dipl.-Ing. Wilfried Holthaus
>> ============================================================
>>
>> Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
>> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
>> E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
>> Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren
>> sowie
>> die unbefugte Weitergabe dieser Mail ist nicht gestattet.
>>
>> This e-mail may contain confidential and/or privileged information.
>> If
>> you are not the intended recipient (or have received this e-mail in
>> error) please notify the sender immediately and destroy this e-mail.
>> Any
>> unauthorised copying, disclosure or distribution of the material in
>> this
>> e-mail is strictly forbidden.
>>
>> [Non-text portions of this message have been removed]
>>
>> ------------------------------------
>> Posted by: Sascha Horn <s.horn@...>
>> ------------------------------------
>>
>> ------------------------------------
>>
>> Yahoo Groups Links
>>
>>
>>
> --
> Mit freundlichen Grüßen,
>
> Sascha Horn
> Dipl. Ing. Informationstechnik (BA)
>
> procar informatik AG
> Software Entwicklung
>
> Stammsitz in Darmstadt:
>
> Heinrich-Hertz-Str. 1
> 64295 Darmstadt
>
> Geschäftsstelle in Berlin:
>
> Justus-von-Liebig-Str.7
> 12489 Berlin-Adlershof
>
> Telefon (Zentrale): +49 6151/85048-0
> Fax (Zentrale): +49 6151/85048-29
>
> mailto:s.horn@...
> http://www.procar.de
> http://www.facebook.com/procar.de
>
> Amtsgericht Darmstadt HRB 8268
> USt.-IdNr. DE195354166
> Vorstand: Dipl.-Ing. Volker Holthaus, Karl-Heinz Schlapp
> Vorsitzender des Aufsichtsrats: Dipl.-Ing. Wilfried Holthaus
> ============================================================
>
> Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
> E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
> Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie
> die unbefugte Weitergabe dieser Mail ist nicht gestattet.
>
> This e-mail may contain confidential and/or privileged information. If
> you are not the intended recipient (or have received this e-mail in
> error) please notify the sender immediately and destroy this e-mail.
> Any unauthorised copying, disclosure or distribution of the material
> in this e-mail is strictly forbidden.
>
>
>
> Links:
> ------
> [1]
> https://groups.yahoo.com/neo/groups/Firebird-Java/info;_ylc=X3oDMTJlbmw2dGpvBF9TAzk3MzU5NzE0BGdycElkAzIwOTUyNzkEZ3Jwc3BJZAMxNzA1MDA2NzY0BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTQ3OTE1MjgzNQ--
> [2]
> https://groups.yahoo.com/neo;_ylc=X3oDMTJkbWZ2cGVvBF9TAzk3NDc2NTkwBGdycElkAzIwOTUyNzkEZ3Jwc3BJZAMxNzA1MDA2NzY0BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNDc5MTUyODM1
> [3] https://info.yahoo.com/privacy/us/yahoo/groups/details.html
> [4] https://info.yahoo.com/legal/us/yahoo/utos/terms/


-- 
Mit freundlichen Grüßen,

Sascha Horn
Dipl. Ing. Informationstechnik (BA)

procar informatik AG
Software Entwicklung

Stammsitz in Darmstadt:

procar informatik AG
Heinrich-Hertz-Str. 1
64295 Darmstadt

Geschäftsstelle Berlin:

Justus-von-Liebig-Str.7
12489 Berlin-Adlershof

Geschäftsstelle Leipzig:

Schongauer Straße 29-31
04328 Leipzig


Telefon (Zentrale): +49 6151/85048-0
Fax (Zentrale):     +49 6151/85048-29

mailto:info@...
http://www.procar.de
http://www.facebook.com/procar.de

Amtsgericht Darmstadt HRB 8268
USt.-IdNr. DE195354166
Vorstand: Dipl.-Ing. Volker Holthaus, Karl-Heinz Schlapp
Vorsitzender des Aufsichtsrats: Dipl.-Ing. Wilfried Holthaus
============================================================

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie
die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in
error) please notify the sender immediately and destroy this e-mail. Any
unauthorised copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.