Hi Assaf,

We're aware of and hopefully have fixed at least some of these errors. Migration scripts 11 and 16 should fix the errors found in scripts 10 and 15, respectively; have you found this to be the case?

For the problems in scripts 13 and 17, we'll have to create yet another script to create the indices.

Thanks,
J.

On Tue, Jan 19, 2010 at 3:34 PM, Assaf Gordon <gordon@cshl.edu> wrote:
Hello,

When running galaxy for the first time (sh run.sh) and connecting to a MySQL 5.0 server, the following errors happen:
===============
0010_hda_display_at_authz_table DEBUG 2010-01-19 14:49:37,695 Creating history_dataset_association_display_at_authorization table failed: (OperationalError) (1059, "Identifier name 'ix_history_dataset_association_display_at_authorization_update_time' is too long") u'CREATE INDEX ix_history_dataset_association_display_at_authorization_update_time ON history_dataset_association_display_at_authorization (update_time)' ()

0013_change_lib_item_templates_to_forms DEBUG 2010-01-19 14:50:12,272 Creating library_dataset_dataset_info_association table failed: (OperationalError) (1059, "Identifier name 'ix_library_dataset_dataset_info_association_library_dataset_dataset_association_id' is too long") u'CREATE INDEX ix_library_dataset_dataset_info_association_library_dataset_dataset_association_id ON library_dataset_dataset_info_association (library_dataset_dataset_association_id)' ()

0015_tagging DEBUG 2010-01-19 14:50:53,975 Creating history_dataset_association_tag_association table failed: (OperationalError) (1059, "Identifier name 'ix_history_dataset_association_tag_association_history_dataset_association_id' is too long") u'CREATE INDEX ix_history_dataset_association_tag_association_history_dataset_association_id ON history_dataset_association_tag_association (history_dataset_association_id)' ()

0017_library_item_indexes DEBUG 2010-01-19 14:50:56,813 Adding index 'ix_library_folder_name' to library_folder table failed: (OperationalError) (1170, "BLOB/TEXT column 'name' used in key specification without a key length") 'CREATE INDEX ix_library_folder_name ON library_folder (name)' ()
=====================

Three of them (10,13,15) happen because the auto-generated key name (based on the table's name and column) is too long.
The other (17) is because in MySQL, creating an index on a "Text" field requires a length (index on VARCHAR doesn't require it).

The current workaround is to create these indices manually.

While MySQL 5.0 is a bit too old, it is still the standard version on debian/stable and CentOS 5.4, so I have to use it.

-gordon
_______________________________________________
galaxy-dev mailing list
galaxy-dev@lists.bx.psu.edu
http://lists.bx.psu.edu/listinfo/galaxy-dev