1. Marcin Kuzminski
  2. RhodeCode
  3. Issues

Issues

Issue #705 resolved

Upgrade From 1.3.6 -> 1.5.1 Creating Duplicate indexes

William Roush
created an issue
2012-12-29 16:25:59,096 INFO sqlalchemy.engine.base.Engine ()
2012-12-29 16:26:01,090 INFO sqlalchemy.engine.base.Engine COMMIT
2012-12-29 16:26:01,091 INFO sqlalchemy.engine.base.Engine CREATE INDEX uem_email_idx ON user_email_map (email)
2012-12-29 16:26:01,091 INFO sqlalchemy.engine.base.Engine ()
2012-12-29 16:26:02,442 INFO sqlalchemy.engine.base.Engine COMMIT
2012-12-29 16:26:02,443 INFO sqlalchemy.engine.base.Engine CREATE INDEX uem_email_idx ON user_email_map (email)
2012-12-29 16:26:02,443 INFO sqlalchemy.engine.base.Engine ()
2012-12-29 16:26:02,443 INFO sqlalchemy.engine.base.Engine ROLLBACK

If I disable that Index, I get this!

2012-12-29 16:38:21,713 INFO sqlalchemy.engine.base.Engine ()
2012-12-29 16:38:21,865 INFO sqlalchemy.engine.base.Engine COMMIT
2012-12-29 16:38:21,865 INFO sqlalchemy.engine.base.Engine CREATE INDEX cs_revision_idx ON changeset_statuses (revision)
2012-12-29 16:38:21,865 INFO sqlalchemy.engine.base.Engine ()
2012-12-29 16:38:22,077 INFO sqlalchemy.engine.base.Engine COMMIT
2012-12-29 16:38:22,077 INFO sqlalchemy.engine.base.Engine CREATE INDEX cs_version_idx ON changeset_statuses (version)
2012-12-29 16:38:22,077 INFO sqlalchemy.engine.base.Engine ()
2012-12-29 16:38:22,403 INFO sqlalchemy.engine.base.Engine COMMIT
2012-12-29 16:38:22,403 INFO sqlalchemy.engine.base.Engine CREATE INDEX cs_revision_idx ON changeset_statuses (revision)
2012-12-29 16:38:22,404 INFO sqlalchemy.engine.base.Engine ()
2012-12-29 16:38:22,404 INFO sqlalchemy.engine.base.Engine ROLLBACK

There is only one Index declaration on these, so there isn't some kind of funny regressed typo or something. It wont even get me to 1.4.0 (which is the step it's failing on).

Any ideas?

Comments (2)

  1. William Roush reporter

    Marcin pointed out on IRC to upgrade to 1.4.x first, then 1.5.x. So deleted the 1.5.1 egg, ran "easy_install -U rhodecode==1.4.0", when running the update you'll get dependency errors, roll back all required dependencies the same way as above, the upgrade will succeed and then do "easy_install -U rhodecode" again to get up to 1.5.1, dependencies will complain again, update those, upgrade worked.

  2. Log in to comment