Hi, I can reproduce the problem and will try to fix it. Thanks for your mail!
Regards, Thomas On Tue, Mar 9, 2010 at 7:28 AM, [email protected] <[email protected]> wrote: > I've been getting a bunch of locking errors: > > Timeout trying to lock table "SYS"; SQL statement: > select nextval('owi_qstr_seq') from system_range(1, 214) [50200-126] > > When I try to access a sequence as above while 'analyze' is running; I > haven't tried to reproduce this in a small test case but it happens > all the time. > > A bit of history; in the 1.1.x series, this was a common occurence > with no problem running with no MVCC, but MULTI_THREADED turned on. > The operations in question happen in 2 different connections to the > same embedded db. > > Since the 1.2.x series, this happens fairly often. > > As an aside, when did analyze change to not allowing 'analyze tbl' as > a syntax; I used it as Postgres does for years assuming I could > analyze on specific tables, and then at some (recent) point that > started throwing an exception (1.1.118 maybe?). > > Ring a bell for anyone? > > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
