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.
