Hello, I am using:
java -Xmx4096m -Xverify:none -cp %CLASSPATH%\h2-1.4.196.jar org.h2.tools.RunScript -url "jdbc:h2:nioMapped:~/%DB_NAME%;LOCK_MODE=0;TRACE_LEVEL_FILE=3;UNDO_LOG=0" -user "admin" -password "admin" -script "D:/dev/sql/sqlscript.sql" and "sqlscript.sql' has a hundred or more: RUNSCRIPT FROM '<filename.sql>'; Basically, I have a master run script running hundreds of sub-RUNSCRIPT. The objective of my master/sub-scripts it to bulk load data. And when I review the log file, database.trace.db, it contains hundreds of LOCKS. For example: 2018-01-03 11:04:28 lock: 1 exclusive write lock requesting for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock added for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock unlock SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock requesting for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock added for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock unlock SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock requesting for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock added for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock unlock SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock requesting for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock added for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock unlock SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock requesting for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock added for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock unlock SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock requesting for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock added for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock unlock SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock requesting for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock added for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock unlock SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock requesting for SYS 2018-01-03 11:04:28 lock: 1 exclusive write lock added for SYS ... ... ... Can anyone please explain why locks are still happening with LOCK_MODE=0? Thanks, Patrick -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
