8 Replies Latest reply on Aug 15, 2014 10:57 AM by Jeremy Whiting

    Premature transaction timeout.

    Jeremy Whiting Expert

      Hi,

      Since this hibernate HHH-7689 issue has been fixed I have been able to use an internal benchmark. The benchmark uses jdbc batching to prepare initial data for a benchmark run with a relational database like PostgreSQL.

       

      Depending on the environment I use the loading of data takes different amounts of time. I am seeing a problem on "slow" hardware. ie my local laptop and desktop versus dedicated servers.

      What I am seeing is the loading of data fail. Loading the data takes a while so the Recovery Manager rightly detects a timeout and aborts the transaction. Using the default of 300 seconds.

       

      To get round this I've attempted two things. By setting the default-timeout attribute on the coordinator-environment element in the server configuration file.

       

      <coordinator-environment default-timeout="300"/>

       

      a) Set a adequately high timeout (in seconds). e.g. 1200 (an hour)

      <coordinator-environment default-timeout="1200"/>

      b) disable the timeout. Using -1

      <coordinator-environment default-timeout="-1"/>

       

      In both situations I find the Recovery Manager does not do what I am expecting. Which is avoid timing out the long running transaction sufficiently long enough for the data to load.

       

      To demonstrate test case a) is attached a Wildfly 8.1 server log file. With TRACE logging enabled for "com.arjuna.ats.arjuna" category. The data loading was initiated after the server completed the start-up sequence. This demonstrates the recovery manager aborting the transaction at 10:34:10,274 after 694 seconds (11 minutes 34).

       

      I wonder if the tx is being marked abort for other reasons. Is there a different category I can use to show this ?

       

      Regards,

      Jeremy

       

      Tested hibernate-core

       

      4.3.1.Final Wildfly 8.1.0.Final

      4.2.14.Final in EAP 6.3.0.Beta

       

      Using PostgreSQL 9.2.8.

      $ java -version

      java version "1.7.0_65"

      OpenJDK Runtime Environment (fedora-2.5.1.2.fc19-x86_64 u65-b17)

      OpenJDK 64-Bit Server VM (build 24.65-b04, mixed mode)

      $ uname -a

      Linux burtha02-f19 3.14.13-100.fc19.x86_64 #1 SMP Fri Jul 18 02:36:00 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux