Internal server errors after migrate from Trac
Added by Alexander Sapozhnikov over 2 years ago
I've try to migrate project from Trac 0.11.7 as shown in RedmineMigrate to Redmine 1.0.2. Data was successfully copied but I saw some problems:
I make migration procedure:
- New field «Resolution» appears in Issues (I remove that field).
- Some pages in Redmine now doesn't work (Issue list, Migrated issues) — I see Internal Server error, but new issues, which made after migration, shows correctly.
I see in log/production.log:
Processing IssuesController#index (for MY.IP.HERE at 2010-10-11 13:36:41) [GET]
Parameters: {"project_id"=>"PROJECTNAME", "action"=>"index", "controller"=>"issues"}
Rendering template within layouts/base
Rendering issues/index.rhtml
ActionView::TemplateError (comparison of Fixnum with nil failed) on line #16 of app/views/issues/_list.rhtml:
13: </tr></thead>
14: <% previous_group = false %>
15: <tbody>
16: <% issue_list(issues) do |issue, level| -%>
17: <% if @query.grouped? && (group = @query.group_by_column.value(issue)) != previous_group %>
18: <% reset_cycle %>
19: <tr class="group open">
app/helpers/issues_helper.rb:24:in `issue_list'
app/helpers/issues_helper.rb:23:in `each'
app/helpers/issues_helper.rb:23:in `issue_list'
app/views/issues/_list.rhtml:16
app/views/issues/_list.rhtml:1:in `_run_rhtml_app47views47issues47_list46rhtml_locals_issues_list_object_query'
app/views/issues/index.rhtml:63:in `_run_rhtml_app47views47issues47index46rhtml'
app/controllers/issues_controller.rb:84
app/controllers/issues_controller.rb:83:in `index'
thin (1.2.4) lib/thin/connection.rb:76:in `pre_process'
thin (1.2.4) lib/thin/connection.rb:74:in `catch'
thin (1.2.4) lib/thin/connection.rb:74:in `pre_process'
thin (1.2.4) lib/thin/connection.rb:57:in `process'
thin (1.2.4) lib/thin/connection.rb:42:in `receive_data'
eventmachine (0.12.10) lib/eventmachine.rb:256:in `run_machine'
eventmachine (0.12.10) lib/eventmachine.rb:256:in `run'
thin (1.2.4) lib/thin/backends/base.rb:57:in `start'
thin (1.2.4) lib/thin/server.rb:156:in `start'
thin (1.2.4) lib/thin/controllers/controller.rb:80:in `start'
thin (1.2.4) lib/thin/runner.rb:174:in `send'
thin (1.2.4) lib/thin/runner.rb:174:in `run_command'
thin (1.2.4) lib/thin/runner.rb:140:in `run!'
thin (1.2.4) bin/thin:6
/usr/local/bin/thin:19:in `load'
/usr/local/bin/thin:19
Rendering /usr/local/www/redmine/public/500.html (500 Internal Server Error)I make migration procedure:
rake db:migrate RAILS_ENV=production (in /usr/local/www/redmine) rake db:migrate:upgrade_plugin_migrations RAILS_ENV=production (in /usr/local/www/redmine) Cannot find old migration table - assuming nothing needs to be done rake db:migrate_plugins RAILS_ENV=production (in /usr/local/www/redmine) Migrating engines... Migrating acts_as_activity_provider... Migrating acts_as_attachable... Migrating acts_as_customizable... Migrating acts_as_event... Migrating acts_as_list... Migrating acts_as_rated... Migrating acts_as_searchable... Migrating acts_as_taggable_on_steroids... Migrating acts_as_tree... Migrating acts_as_versioned... Migrating acts_as_viewed... Migrating acts_as_watchable... Migrating awesome_nested_set... Migrating classic_pagination... Migrating coderay-0.9.2... Migrating gravatar... Migrating menu_link... Migrating open_id_authentication... Migrating prepend_engine_views... Migrating redmine_knowledgebase... Migrating redmine_opensearch... Migrating rfpdf... Migrating ruby-net-ldap-0.0.4...
I restart server, but this restart didn't help.
I've try clear cache:
rake tmp:cache:clear rake tmp:sessions:clearand restart server again, but errors still remains.
Replies (4)
RE: Internal server errors after migrate from Trac - Added by Alexander Sapozhnikov over 2 years ago
I found fields lft and rgt in table issues are NULL for migrated issues and not NULL for other (new and old) ones.
I fix it:
mysql> UPDATE issues SET lft=1 WHERE lft IS NULL; Query OK, 11 rows affected (0.04 sec) Rows matched: 11 Changed: 11 Warnings: 0 mysql> UPDATE issues SET rgt=2 WHERE rgt IS NULL; Query OK, 11 rows affected (0.03 sec) Rows matched: 11 Changed: 11 Warnings: 0Now I can see issue list at http://SITE/projects/PROJECTNAME/issues and issues.
Now problem is solved. But when I will make next migration, I'll see this bug again? I saw lib/tasks/migrate_from_trac.rake but I saw no occurrences of lft and rgt fields.
I've use Redmine 1.0.2 under FreeBSD 7.2 (upgraded 1 week ago via portupgrade).
Sometimes when I edit imported tasks redmine hangs: process ruby18 eats CPU and memory.
RE: Internal server errors after migrate from Trac - Added by Alexander Sapozhnikov over 2 years ago
I execute:
mysql> UPDATE issues SET root_id=id WHERE root_id IS NULL;Now Redmine work better and not hangs.
RE: Internal server errors after migrate from Trac - Added by Felix Schäfer over 2 years ago
Could you open a ticket for that please? Thanks.
Re: ticket for that - Added by Alexander Sapozhnikov over 2 years ago
#6632 Incomplete migration from Trac to Redmine
(1-4/4)