I'm not sure about the test case, but it seems following: 1. Open connection, set auto commit false. 2. Try insert row to table with PK which already has this row - exception thrown. 3. Close connection. 4. Drop table via some other connection - timeout trying to lock table.
Both 1.3.176 and 1.4.191 are affected. >From brief debugging I can see that RegularTable has 1 entry in locksShared at step 4. During step 3 session.hasPendingTransactions returns false (seems no row was inserted, so no undo to generate). -- 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.
