Can I increase the amount of time a session will wait for a locked table to become unlocked before it times out?
After a few minutes I get an error on an INSERTY statement against a table locked by another session:
Code: Select all
dbadmin=> insert into test01 values (1); ERROR 5156: Unavailable: initiator locks for query - Locking failure: Timed out I locking Table:vdb001.test1. X held by [user dbadmin (select * from test01 for update;)]. Your current transaction isolation level is READ COMMITTED