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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
