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 realise there is a similar topic for this, but that one is older than v3.0.5 is. This other post is: