If I start a transaction (set autocommit=0 in the command line utility),
then do an "insert" in one session, then open a second session and try
to do a select on that table, before the first session has committed, the
select just hangs. Once I commit in the first session, my select
Scott,
did you try to do the insert and select on the same database page?
In BDB there is page level locking used, and the behavior you
describe sounds like that the insert has placed a page level lock
on the page where you try to do the select. Then it is correct behavior
of the database that
