Re: [galaxy-dev] Problem upgrading DB from 72 to 73 (SQLite)

On Wed, Feb 2, 2011 at 1:27 PM, Peter Cock p.j.a.cock@googlemail.com wrote:

Should I file a bug report?

$ sh manage_db.sh upgrade 72 -> 73...

Migration script to add 'ldda_parent_id' column to the implicitly_converted_dataset_association table.

Adding ldda_parent_id column to implicitly_converted_dataset_association table failed: SQLite does not support ALTER TABLE ADD FOREIGN KEY; see http://www.sqlite.org/lang_altertable.html done

Concerningly, although the upgrade says it fails, it looks like some of it worked:

$ sh manage_db.sh db_version 73

Shouldn't each update step be one big transaction that gets rolled back to leave things in a known state (in this case, schema version 72)?

Peter