Super! I had a devil of time trying to reproduce that one as well. That makes you 2 for 2 for me in the last week -- pretty good.
Your suggestion of increasing the log size got around my sequence performance problem, discussed elsewhere. Thanks! On Mar 15, 2:07 pm, Thomas Mueller <[email protected]> wrote: > 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 > > athttp://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.
