Actions
Defect #8654
closedMysql::Error: MySQL server has gone away
Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
2011-06-21
Due date:
% Done:
0%
Estimated time:
Resolution:
Invalid
Affected version:
Description
Suddenly I can't update old issues on my Redmine installation. Everytime I try, I get redmine 500 error. On the log, I got this:
ActiveRecord::StatementInvalid (Mysql::Error: MySQL server has gone away: SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 0) ): app/models/issue.rb:102:in `after_initialize' app/models/issue.rb:351:in `init_journal' app/models/issue.rb:841:in `create_journal' app/models/issue.rb:553:in `save_issue_with_child_records' app/models/issue.rb:535:in `save_issue_with_child_records' app/controllers/issues_controller.rb:170:in `update' passenger (2.2.15) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request' passenger (2.2.15) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop' passenger (2.2.15) lib/phusion_passenger/railz/application_spawner.rb:441:in `start_request_handler' passenger (2.2.15) lib/phusion_passenger/railz/application_spawner.rb:381:in `handle_spawn_application' passenger (2.2.15) lib/phusion_passenger/utils.rb:252:in `safe_fork' passenger (2.2.15) lib/phusion_passenger/railz/application_spawner.rb:377:in `handle_spawn_application' passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:352:in `__send__' passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:352:in `main_loop' passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously' passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:163:in `start' passenger (2.2.15) lib/phusion_passenger/railz/application_spawner.rb:222:in `start' passenger (2.2.15) lib/phusion_passenger/spawn_manager.rb:253:in `spawn_rails_application' passenger (2.2.15) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add' passenger (2.2.15) lib/phusion_passenger/spawn_manager.rb:247:in `spawn_rails_application' passenger (2.2.15) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize' passenger (2.2.15) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize' passenger (2.2.15) lib/phusion_passenger/spawn_manager.rb:246:in `spawn_rails_application' passenger (2.2.15) lib/phusion_passenger/spawn_manager.rb:145:in `spawn_application' passenger (2.2.15) lib/phusion_passenger/spawn_manager.rb:278:in `handle_spawn_application' passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:352:in `__send__' passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:352:in `main_loop' passenger (2.2.15) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously' Rendering /home/storage/9/12/08/proprietariodireto/rails_apps/redmine/public/500.html (500 Internal Server Error) Processing IssuesController#update (for 201.74.132.152 at 2011-06-20 21:55:12) [PUT] Parameters: {"time_entry"=>{"comments"=>"", "activity_id"=>"", "hours"=>""}, "commit"=>"Submit", "notes"=>"Passado o Kaizen.", "action"=>"update", "_method"=>"put", "authenticity_token"=>"/GSQMZigMjNsiWN0HM0Th7vQr+pA2SkmjGtZW6L21UQ=", "id"=>"23", "issue"=>{"start_date"=>"2011-06-13", "estimated_hours"=>"", "priority_id"=>"4", "parent_issue_id"=>"", "lock_version"=>"0", "done_ratio"=>"0", "assigned_to_id"=>"4", "subject"=>"Kaizen Wladimir", "tracker_id"=>"4", "due_date"=>"2011-06-17", "status_id"=>"5", "description"=>"Wladimir estarĂ¡ ocupado com o Kaizen."}, "controller"=>"issues", "attachments"=>{"1"=>{"description"=>""}}}
Running on Linux with mySQL server. Strange thing is that mySQL server is up and running fine, and I can do anything else on Redmine except updating old issues (I can even create and update new ones). WTF??
On the error, it says:
SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 0
but there are no status with id=0. And I didn't change the default statuses, it was working fine and suddenly I can't update old issues anymore. Can someone take a look at it?
Actions