Hi Derrick and Dannon

@ Derrick

Yours happened when upgrading from 108 - 109 (which didn't happen to me).

If you have a chance to upgrade to release_2013.02.08, your database
will be upgrade from 109 - 110, I am very interested to see if the index
creation error happens to you as well.


We are talking about the same step (it is all part of our upgrade to the 2013.02.08 release which in my case involved changing the db from 107 to 110), see: ~/lib/galaxy/model/migrate/versions0109_add_repository_dependency_tables.py

Nevertheless, thanks for identifying the actual cause of the problem ie:
>There is identifier length limit in MySQL which is 64


So I am just puzzled, why I don't get this particular error message. I asked our sysadmin again, and he claims not to see this error in the logs (for our developments server upgraded last week and our production server upgraded today).


@ Dannon

> While we definitely do recommend that if you have the option to
> choose, go with postgres, Galaxy should function both now and in the
> future with MySQL.  In this case, your galaxy will function just fine
> without that index.

I assume there are a lot of 'old' Galaxy servers using MySQL around, where the 'galaxy admin' (like me) would love to switch to postgres. Maybe we can do a community effort putting together a "MySQL-to-postgres" protocol for a defined Galaxy release? And after that release, only postgres is supported. I am sure this would make a lot of things easier.....something to discuss in Oslo?


Regards, Hans-Rudolf

___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:

 http://lists.bx.psu.edu/

Reply via email to