I've upgraded to 3.0.5 (because indexExists says 'yes' in 2.0.5 to a not-nullable FK column without an index, but 'no' on 3.0.5), and found that when changeset nr. 210 is executing, I get an 'ORA-01000: maximum open cursors exceeded' error. If I run these changesets (in total about 260) on 2.0.5, I don't get the error (but also not the indexes on non-nullable FK columns...hence the upgrade)
This is on an empty DB. If I re-run this (with the dbchangelock removed), it continues, and finalises successfully.
I also get this issue on 3.0.7. It looks like it's related to preconditions. If I remove my preconditions it all works like a charm, but otherwise it quickly slows down and then dies with a ORA-01000.
My guess is that there's a missing statement.close() in the precondition logic.
Fixed. There were Statement objects not being correctly closed in JdbcDatabaseSnapshot