mitechie
commented
10 years ago Thanks for the report. I'll work on getting mysql into CI and will have to investigate what tweaks to the db migration needs to be done for mysql.
Open jcharaoui opened 10 years ago
mitechie
commented
10 years ago Thanks for the report. I'll work on getting mysql into CI and will have to investigate what tweaks to the db migration needs to be done for mysql.
mitechie
commented
10 years ago I've got this replicated in CI and will work on getting that to pass.
mitechie
commented
10 years ago So in chasing this down the migration needs to be adjusted to drop the right constraint in the right way. Note that mysql required the "type" to be specified per http://alembic.readthedocs.org/en/latest/ops.html#alembic.operations.Operations.drop_constraint:
I've dumped the constraints out in order to figure out what they are. Will have to build a detection that this migration is running in mysql and use the tweaked names/etc to drop the right constraint so the migration can take place.
So lots of data pulled, but more work to be done.
+--------------------+-------------------+-----------------------+----------------+---------------------------+-----------------+
| CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_SCHEMA | TABLE_NAME | CONSTRAINT_TYPE |
+--------------------+-------------------+-----------------------+----------------+---------------------------+-----------------+
| def | jenkins_bookie | PRIMARY | jenkins_bookie | activations | PRIMARY KEY |
| def | jenkins_bookie | activations_ibfk_1 | jenkins_bookie | activations | FOREIGN KEY |
| def | jenkins_bookie | PRIMARY | jenkins_bookie | bmark_readable | PRIMARY KEY |
| def | jenkins_bookie | bmark_readable_ibfk_1 | jenkins_bookie | bmark_readable | FOREIGN KEY |
| def | jenkins_bookie | PRIMARY | jenkins_bookie | bmark_tags | PRIMARY KEY |
| def | jenkins_bookie | bmark_tags_ibfk_1 | jenkins_bookie | bmark_tags | FOREIGN KEY |
| def | jenkins_bookie | bmark_tags_ibfk_2 | jenkins_bookie | bmark_tags | FOREIGN KEY |
| def | jenkins_bookie | PRIMARY | jenkins_bookie | bmarks | PRIMARY KEY |
| def | jenkins_bookie | username | jenkins_bookie | bmarks | UNIQUE |
| def | jenkins_bookie | bmarks_ibfk_1 | jenkins_bookie | bmarks | FOREIGN KEY |
| def | jenkins_bookie | bmarks_ibfk_2 | jenkins_bookie | bmarks | FOREIGN KEY |
| def | jenkins_bookie | PRIMARY | jenkins_bookie | import_queue | PRIMARY KEY |
| def | jenkins_bookie | PRIMARY | jenkins_bookie | logging | PRIMARY KEY |
| def | jenkins_bookie | PRIMARY | jenkins_bookie | stats_bookmarks | PRIMARY KEY |
| def | jenkins_bookie | PRIMARY | jenkins_bookie | tags | PRIMARY KEY |
| def | jenkins_bookie | name | jenkins_bookie | tags | UNIQUE |
| def | jenkins_bookie | PRIMARY | jenkins_bookie | url_hash | PRIMARY KEY |
| def | jenkins_bookie | PRIMARY | jenkins_bookie | users | PRIMARY KEY |
| def | jenkins_bookie | email | jenkins_bookie | users | UNIQUE |
| def | jenkins_bookie | username | jenkins_bookie | users | UNIQUE |
| def | mysql | PRIMARY | mysql | columns_priv | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | db | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | event | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | func | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | help_category | PRIMARY KEY |
| def | mysql | name | mysql | help_category | UNIQUE |
| def | mysql | PRIMARY | mysql | help_keyword | PRIMARY KEY |
| def | mysql | name | mysql | help_keyword | UNIQUE |
| def | mysql | PRIMARY | mysql | help_relation | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | help_topic | PRIMARY KEY |
| def | mysql | name | mysql | help_topic | UNIQUE |
| def | mysql | PRIMARY | mysql | host | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | ndb_binlog_index | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | plugin | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | proc | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | procs_priv | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | proxies_priv | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | servers | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | tables_priv | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | time_zone | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | time_zone_leap_second | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | time_zone_name | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | time_zone_transition | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | time_zone_transition_type | PRIMARY KEY |
| def | mysql | PRIMARY | mysql | user | PRIMARY KEY |
+--------------------+-------------------+-----------------------+----------------+---------------------------+-----------------+
jcharaoui
commented
10 years ago It's working for me now.
mitechie
commented
10 years ago That's awesome, the test suite still doesn't pass on mysql but glad things are working for you. We've got more to do, but getting the new GSoC features out the door on a new server has taken priority over getting mysql passing.
On Debian, using MySQL 5.5.35+dfsg-0+wheezy1 and MySQLdb 1.2.5, installing into an empty database fails with the following error log: