On Mon, Mar 4, 2013 at 7:59 AM, Hans-Rudolf Hotz wrote:
> @ 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
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
The problem is that, like you pointed out, mysql allows identifier lengths
of 255 for everything except indexes, which are stuck at 64. Most of the
index names in Galaxy are auto-generated by SqlAlchemy, the ORM layer we
use, based on the names of the tables and columns, and quite a few of these
c
As for the error I encountered, it complained identifier of the index is
too long. There is identifier length limit in MySQL which is 64:
http://dev.mysql.com/doc/refman/5.5/en/identifiers.html
But the
"ix_repository_repository_dependency_association_tool_shed_repository_id"
is 71 char long.
Any
HI Hans,
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.
Cheers,
Derrick
On Fri, Mar 1,
Hi Derrick
This is interesting. we are also using MySQL and I got an error at the
same step. However in my case the error message was:
" (OperationalError) (1050, "Table
'repository_repository_dependency_association' already exists") "
the same was also the case for the repository_dependenc
Hi guys,
I was given the following error when upgrading the database from 109 to 110:
0109_add_repository_dependency_tables DEBUG 2013-03-01 15:14:15,554
Creating repository_repository_dependency_association table failed:
(OperationalError) (1059, "Identifier name
'ix_repository_repository_depend