Timeout Trying to lock table

[edwardsk]

I get the following error while a long running query is in the process
of executing... and an attempt to call an insert statement (batch of
inserts via preparedStatement).

Timeout trying to lock table PAST_SCOREBOARD_CHANNEL_DATA [50200-107]


Please note we are using MULTI_THREADED=1 in our db connection url.

[kedwards]

Also, it should be noted that the inserts are happening on one thread
on a server and the queries are "on demand" from a user's client
application.

[Thomas Mueller]

Hi,

I'm afraid I don't have a good solution for this problem.

You can increase the lock timeout:
http://www.h2database.com/html/grammar.html#setlocktimeout

You can try if the MVCC mode works for you:
http://www.h2database.com/html/advanced.html#mvcc

Regards,
Thomas