9 messages in com.googlegroups.h2-databaseRe: Timeout trying to lock... [HYT00-50]
FromSent OnAttachments
Thomas WiradikusumaDec 19, 2007 12:20 am 
Thomas MuellerDec 22, 2007 1:29 am 
Thomas MuellerDec 22, 2007 1:31 am 
Thomas WiradikusumaDec 22, 2007 3:27 am 
Thomas MuellerDec 26, 2007 8:42 am 
Thomas WiradikusumaDec 26, 2007 7:52 pm 
Thomas WiradikusumaDec 26, 2007 8:23 pm 
Thomas MuellerDec 28, 2007 8:05 am 
Thomas WiradikusumaDec 28, 2007 9:14 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: Timeout trying to lock... [HYT00-50]Actions...
From:Thomas Mueller (thom@gmail.com)
Date:Dec 26, 2007 8:42:42 am
List:com.googlegroups.h2-database

Hi,

A possible bug in H2?

I don't think so. Did you get my first response? Here again:

According to the exception code (-50) you are using version 1.0.50 from 2007-06-17. You should consider using a newer version. In newer versions, read committed is the default isolation level (like in most other databases). With older versions (including the version you are using), the default isolation level is serializable, where such scenarios can easily lead to lock timeout.

Regards, Thomas

On Dec 22, 2007 12:27 PM, Thomas Wiradikusuma <wira@gmail.com> wrote:

Exactly. That's why I'm confused. FYI I'm using Spring's @Transactional. The same code works OK in MySQL.

A possible bug in H2?

Regards, Thomas