After Migration, IssuesController#update throws SystemStackError (HTTP 500)

Yesterday, I've did an Redmine upgrade from 0.8.3 to 1.1.1. Anything went fine.

When trying to update and Issue, I'll get an HTTP 500 error. In the production.log, I'll having some kind of infinite loop (SystemStackError (stack level too deep).

Processing IssuesController#update (for 192.168.0.2 at 2011-02-08 11:50:19) [PUT]
  Parameters: {"commit"=>"OK", "notes"=>"", "action"=>"update", "_method"=>"put", "authenticity_token"=>"nMix9VB7rqiHdbxKx+cmxIBX+bW/iA+pm+QOyEgHo0Y=", "id"=>"118", 
"issue"=>{"start_date"=>"2011-02-03", "estimated_hours"=>"", "priority_id"=>"4", "parent_issue_id"=>"", "lock_version"=>"0", "done_ratio"=>"0", "assigned_to_id"=>"3", 
"subject"=>"Not offline", "tracker_id"=>"2", "due_date"=>"", "status_id"=>"3", "description"=>"Do not feed data into database when offline"}, "controller"=>"issues", 
"attachments"=>{"1"=>{"description"=>""}}}

SystemStackError (stack level too deep):
  app/models/issue.rb:491:in `soonest_start'
  ...
  app/models/issue.rb:491:in `soonest_start'
  app/models/issue.rb:491:in `soonest_start'
  app/models/issue.rb:491:in `soonest_start'
  app/models/issue.rb:491:in `soonest_start'
  app/models/issue.rb:491:in `soonest_start'
  app/models/issue.rb:306:in `validate'
  app/models/issue.rb:547:in `save_issue_with_child_records'
  app/models/issue.rb:536:in `save_issue_with_child_records'
  app/controllers/issues_controller.rb:170:in `update'
  public/dispatch.fcgi:24

Rendering /usr/share/redmine-1.1.1/public/500.html (500 Internal Server Error)

Ruby is 1.8.7, Rack 1.0.1, Rails 2.3.5. Running on Ubuntu 10.04 via FastCGI@Lighttpd.
Any advice is welcome.

Replies (3)

RE: After Migration, IssuesController#update throws SystemStackError (HTTP 500) - Added by Etienne Massip about 13 years ago

Don't you have some circular dependencies in you issues ?

r4723 (committed after 1.1.1 has been released) fixes a bug with circular dependencies, but maybe not this one...

RE: After Migration, IssuesController#update throws SystemStackError (HTTP 500) - Added by Chris J about 13 years ago

Actually there is something strange in the database. After my upgrade to 0.9.3, I converted the database from SQLite to MySQL to increase performance. This seem not to work properly, since the fields root_id, lft and rgt in the table issues are NULL, while any previous entries have values.

I'll try to create a fresh database and copy over the data only.

RE: After Migration, IssuesController#update throws SystemStackError (HTTP 500) - Added by Chris J about 13 years ago

The problem seems to be solved.

In fact, some fields had a NULL value which causes Redmine to have an infinite loop with soonest_start. I've put the issue ID into root_id and 1 into lft, 2 into rgt for the fields which had NULL values. Now it seems to work as expected.

Thanks.

(1-3/3)

Project

General

Profile

Redmine