Thanks for the reply, will chk and update u
On Fri, Mar 7, 2014 at 6:57 AM, Jay Medrano <[email protected]> wrote: > Log-in to mysql, drop the table displayed in the error message, and re-run > the migrate step. Repeat for each table. This typically happens when > upgrading after performing a roll-back. Make sure you have a backup handy > in case this doesn't work :). > > mysql -u root -p > Enter password: > >use gitlab_databasename; > >drop table XXXX; > >quit; > > re-run command: > sudo -u git -H bundle exec rake db:migrate RAILS_ENV=production > > On Wednesday, February 26, 2014 1:13:57 AM UTC-8, Purushothaman M wrote: >> >> Hi, >> >> we upgrading from Gitlab CE 6.5 to 6.6 stable edition, everything went >> fine until we ran the command for db migration. >> >> sudo -u git -H bundle exec rake db:migrate RAILS_ENV=production >> >> == CreateMergeRequestDiffs: migrating ============================== >> ========== >> -- create_table(:merge_request_diffs) >> rake aborted! >> An error has occurred, all later migrations canceled: >> >> Mysql2::Error: Table 'merge_request_diffs' already exists: CREATE TABLE >> `merge_request_diffs` (`id` int(11) DEFAULT NULL auto_increment PRIMARY >> KEY, `state` varchar(255) DEFAULT 'collected' NOT NULL, `st_commits` >> longtext, `st_diffs` longtext, `merge_request_id` int(11) NOT NULL, >> `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB/home/git/gitlab/ >> vendor/bundle/ruby/1.9.1/gems/activerecord-4.0.3/lib/active_ >> record/connection_adapters/abstract_mysql_adapter.rb:287:in `query' >> >> this is an live server. pls help. >> >> p.s: Env info: >> >> System information >> System: Ubuntu 13.04 >> Current User: git >> Using RVM: no >> Ruby Version: 1.9.3p392 >> Gem Version: 1.8.23 >> Bundler Version:1.3.5 >> Rake Version: 10.1.1 >> >> GitLab information >> Version: 6.6.0 >> Revision: 490f99d >> Directory: /home/git/gitlab >> DB Adapter: mysql2 >> URL: http://server.abc.com >> HTTP Clone URL: http://server.abc.com/some-project.git >> SSH Clone URL: [email protected]:some-project.git >> Using LDAP: yes >> Using Omniauth: no >> >> GitLab Shell >> Version: 1.8.0 >> Repositories: /home/git/repositories/ >> Hooks: /home/git/gitlab-shell/hooks/ >> Git: /usr/bin/git >> >> >> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "GitLab" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/gitlabhq/hHw9XRQmsUc/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- urs, purushoth "If you love something, let it free. If it comes back to you it's yours, if it doesn't, it never was." -- You received this message because you are subscribed to the Google Groups "GitLab" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
