mysql error with rake db:migrate

db_migrate_fail

: fedora1test:pts/0%; RAILS_ENV=integration rake db:migrate
(in /opt/heracles/scholarsphere)
SOLRIZER: loading field name mappings from /usr/local/rvm/gems/ree-1.8.7-2011.03@scholarsphere/gems/solrizer-1.2.0/config/solr_mappings.yml
resetting mappings for Solrizer::FieldMapper::Default
==  AddMissingIndexes: migrating ==============================================
-- add_index(:domain_terms_local_authorities, [:local_authority_id, :domain_term_id], {:name=>"dtla_by_ids1"})
rake aborted!
An error has occurred, all later migrations canceled:

Index name 'dtla_by_ids1' on table 'domain_terms_local_authorities' already exists

Tasks: TOP => db:migrate
(See full trace by running task with --trace)

work_around

: fedora1test:pts/0%; rake db:schema:load !$rake db:schema:load RAILS_ENV=integration(in /opt/heracles/scholarsphere)SOLRIZER: loading field name mappings from /usr/local/rvm/gems/ree-1.8.7-2011.03@scholarsphere/gems/solrizer-1.2.0/config/solr_mappings.ymlresetting mappings for Solrizer::FieldMapper::Default-- create_table("bookmarks", {:force=>true})
   -> 0.0106s-- create_table("checksum_audit_logs", {:force=>true})   -> 0.0055s-- add_index("checksum_audit_logs", ["pid", "dsid"], {:name=>"by_pid_and_dsid"})   -> 0.0049s
-- create_table("delayed_jobs", {:force=>true})
   -> 0.0079s
-- add_index("delayed_jobs", ["priority", "run_at"], {:name=>"delayed_jobs_priority"})
   -> 0.0491s
-- create_table("domain_terms", {:force=>true})
   -> 0.0045s
-- add_index("domain_terms", ["model", "term"], {:name=>"terms_by_model_and_term"})
   -> 0.0048s
-- create_table("domain_terms_local_authorities", {:force=>true, :id=>false})
   -> 0.0038s
-- add_index("domain_terms_local_authorities", ["domain_term_id", "local_authority_id"], {:name=>"dtla_by_ids2"})
   -> 0.0044s
-- add_index("domain_terms_local_authorities", ["local_authority_id", "domain_term_id"], {:name=>"dtla_by_ids1"})
   -> 0.0047s
-- create_table("local_authorities", {:force=>true})
   -> 0.0038s
-- create_table("local_authority_entries", {:force=>true})
   -> 0.0040s
-- add_index("local_authority_entries", ["local_authority_id", "label"], {:name=>"entries_by_term_and_label"})
   -> 0.0456s
-- add_index("local_authority_entries", ["local_authority_id", "uri"], {:name=>"entries_by_term_and_uri"})
   -> 0.0051s
-- create_table("searches", {:force=>true})
   -> 0.0044s
-- add_index("searches", ["user_id"], {:name=>"index_searches_on_user_id"})
   -> 0.0047s
-- create_table("superusers", {:force=>true})
   -> 0.0038s
-- create_table("users", {:force=>true})
   -> 0.0044s
-- add_index("users", ["email"], {:unique=>true, :name=>"index_users_on_email"})
   -> 0.0049s
-- add_index("users", ["reset_password_token"], {:unique=>true, :name=>"index_users_on_reset_password_token"})
   -> 0.0051s
-- initialize_schema_migrations_table()
   -> 0.0005s
-- assume_migrated_upto_version(20120402215635, ["db/migrate"])
   -> 0.0017s