Re: [h2] Re: With LOCK_MODE=0, log file still has hundreds of locks

2018-01-05 Thread Patrick H
I don't see how calling RUNSCRIPT is abnormal, but OK. I'll see about adding fix: this.lockMode = ci.getProperty("LOCK_MODE", Constants.DEFAULT_LOCK_MODE); to constructor: Database(ConnectionInfo ci, String cipher) On Friday, January 5, 2018 at 11:09:39 AM UTC-8, Noel Grandin wrote: > > LOC

Re: [h2] Re: With LOCK_MODE=0, log file still has hundreds of locks

2018-01-05 Thread Noel Grandin
LOCK_MODE=0 is not something we have a lot of test coverage for, so I only know that is works for normal cases.​ You're more than welcome to submit patches to fix your specific use-case. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubsc

Re: [h2] Re: With LOCK_MODE=0, log file still has hundreds of locks

2018-01-05 Thread Patrick H
> Why this is happening for you I don't know. Are you suggesting it doesn't happen to you? Has there been any testing that focuses on RUNSCRIPT being used in a SQL script file? >From my testing calling RUNSCRIPT seems to seriously alter the designed behavior of H2. Locking is unreliable and