Project

General

Profile

Actions

Defect #4235

closed

Issues not working

Added by Lex Rivera over 15 years ago. Updated over 15 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
2009-11-17
Due date:
% Done:

0%

Estimated time:
Resolution:
Cant reproduce
Affected version:

Description

Throws error 500 when trying to open. It happens only with one project...
log:

Processing IssuesController#index (for 79.139.136.243 at 2009-11-17 10:59:11) [GET]
  Parameters: {"project_id"=>"rbforest", "action"=>"index", "controller"=>"issues"}
Rendering template within layouts/base                                             
Rendering issues/index.rhtml                                                       

ActionView::TemplateError (SystemStackError: stack level too deep: SELECT * FROM "enumerations" WHERE ("enumerations"."project_id" IS NULL) AND ( ("enumerations"."type" = 'IssuePriority' ) )  ORDER BY position) on line #63 of app/views/queries/_filters.rhtml:                                                                             
60: <tr>                                                                                                                                                                
61: <td>                                                                                                                                                                
62: <table>                                                                                                                                                             
63: <% query.available_filters.sort{|a,b| a[1][:order]<=>b[1][:order]}.each do |filter| %>                                                                              
64:     <% field = filter[0]                                                                                                                                            
65:        options = filter[1] %>                                                                                                                                       
66:     <tr <%= 'style="display:none;"' unless query.has_filter?(field) %> id="tr_<%= field %>" class="filter">                                                         

    app/models/query.rb:164:in `available_filters'
    app/views/queries/_filters.rhtml:63:in `_run_rhtml_app47views47queries47_filters46rhtml_locals_filters_object_query'
    app/views/issues/index.rhtml:17:in `_run_rhtml_app47views47issues47index46rhtml'
    app/views/issues/index.rhtml:11:in `_run_rhtml_app47views47issues47index46rhtml'
    app/controllers/issues_controller.rb:82:in `index'
    app/controllers/issues_controller.rb:71:in `index'
    /dh/passenger/lib/phusion_passenger/rack/request_handler.rb:95:in `process_request'
    /dh/passenger/lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
    /dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler'
    /dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application'
    /dh/passenger/lib/phusion_passenger/utils.rb:183:in `safe_fork'
    /dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application'
    /dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    /dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    /dh/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
    /dh/passenger/lib/phusion_passenger/abstract_server.rb:163:in `start'
    /dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:213:in `start'
    /dh/passenger/lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
    /dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
    /dh/passenger/lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
    /dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
    /dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
    /dh/passenger/lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
    /dh/passenger/lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
    /dh/passenger/lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
    /dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    /dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    /dh/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

Rendering /home/xdevweb/code.x-demon.org/public/500.html (500 Internal Server Error)

Actions #1

Updated by Thomas Pihl over 15 years ago

It's really hard to say without more information.

Are you sure youäre up to date with rails (2.3.4) and all other gems required for devel edition? My first thought would be a mixup in versions.

If you're sure, please provide more information. Run the query manually and validate the result (to make sure database are in a good state).

Make sure not all enums are disabled in that project.

Not really sure what else to suggest.

/T

Actions #2

Updated by Lex Rivera over 15 years ago

I checked all and found that all gems up-to-date (using gem update i updated them anyway)
With sqlite3 checked DB. All sql requests which caused error 500 in redmine working perfectly in sqlite3. Also, "stack too deep" also happens when i try to open repo view, issues or projects settings.

Actions #3

Updated by Jean-Philippe Lang over 15 years ago

I'm not able to reproduce. Is there anything specific to mention about the project on which this error occurs?
Can you have a try with latest trunk (r3083)?

Actions #4

Updated by Lex Rivera over 15 years ago

happens even with latest rev. will try to reinstall it with old DB.

Actions #5

Updated by Lex Rivera over 15 years ago

now happens with settings too... for example, create project

Processing ProjectsController#add (for 79.139.136.243 at 2009-11-21 05:32:48) [POST]
Parameters: {"enabled_modules"=>["issue_tracking", "time_tracking", "news", "documents", "files", "wiki", "repository", "boards"], "commit"=>"Save", "action"=>"add", "authenticity_token"=>"et1xRT/bDMdO6v0HQULBrj+SX0H61giZY6ohrCAfXTc=", "project"=>{"name"=>"dfgdf", "homepage"=>"", "is_public"=>"1", "description"=>"dg", "identifier"=>"sdfd"}, "controller"=>"projects"}

ActiveRecord::StatementInvalid (SystemStackError: stack level too deep: SELECT * FROM "projects" WHERE ("projects"."id" = 1) ):
app/models/project.rb:209:in `find'
app/models/enabled_module.rb:33:in `module_enabled'
app/controllers/projects_controller.rb:77:in `add'
/dh/passenger/lib/phusion_passenger/rack/request_handler.rb:95:in `process_request'
/dh/passenger/lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
/dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler'
/dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application'
/dh/passenger/lib/phusion_passenger/utils.rb:183:in `safe_fork'
/dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:163:in `start'
/dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:213:in `start'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
/dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
/dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
/dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

Rendering /home/xdevweb/code.x-demon.org/public/500.html (500 Internal Server Error)

Actions #6

Updated by Jean-Philippe Lang over 15 years ago

Can you provide the information requested in SubmittingBugs please?

Actions #7

Updated by Lex Rivera over 15 years ago

[ps12894]$ RAILS_ENV="production" ruby script/about
About your application's environment
Ruby version 1.8.7 (x86_64-linux)
RubyGems version 1.3.5
Rack version 1.0
Rails version 2.3.4
Active Record version 2.3.4
Active Resource version 2.3.4
Action Mailer version 2.3.4
Active Support version 2.3.4
Application root /home/xdevweb/code.x-demon.org
Environment production
Database adapter sqlite3
Database schema version 20091114105931

Actions #8

Updated by Lex Rivera over 15 years ago

Well, i can also provide database.

Actions #9

Updated by Jean-Philippe Lang over 15 years ago

Is it big?

Actions #10

Updated by Lex Rivera over 15 years ago

Nope, less than 10 mbytes sqlite, email can handle it.

Actions #11

Updated by Jean-Philippe Lang over 15 years ago

My email address can be found here: http://www.redmine.org/users/1

Actions #12

Updated by Lex Rivera over 15 years ago

DB sent, sorry for such delay.

Actions #13

Updated by Lex Rivera over 15 years ago

Any updates? I still cannot use my redmine installation.

Actions #14

Updated by Jean-Philippe Lang over 15 years ago

  • Status changed from New to Closed
  • Resolution set to Cant reproduce

I've just tested the database you sent me.
Everything is fine with latest trunk (had to run db:migrate), ruby 1.8.7 and sqlite3-ruby (1.2.3) gem.

Actions

Also available in: Atom PDF