Mysql::Error: MySQL server has gone away

[keerthi priya]

Hello everyone,

I am trying to create reports and the batch has 750 students. with i trying to create report for that batch i am getting this error in my production . How to solve this thing. kindly help me thanks in advance.


ActiveRecord::StatementInvalid (Mysql::Error: MySQL server has gone away: SELECT * FROM `exam_reports` WHERE (`exam_reports`.`student_id` = 130)  LIMIT 1):
  app/models/exam_report.rb:67:in `generate_normal_report'
  app/models/exam_report.rb:15:in `each'
  app/models/exam_report.rb:15:in `generate_normal_report'
  app/models/exam_report.rb:7:in `each'
  app/models/exam_report.rb:7:in `generate_normal_report'
  app/controllers/exam_reports_controller.rb:77:in `normal_report_generation'
  passenger (3.0.9) lib/phusion_passenger/rack/request_handler.rb:96:in `process_request'
  passenger (3.0.9) lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request'
  passenger (3.0.9) lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop'
  passenger (3.0.9) lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler'
  passenger (3.0.9) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `send'
  passenger (3.0.9) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `handle_spawn_application'
  passenger (3.0.9) lib/phusion_passenger/utils.rb:479:in `safe_fork'
  passenger (3.0.9) lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:180:in `start'
  passenger (3.0.9) lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start'
  passenger (3.0.9) lib/phusion_passenger/spawn_manager.rb:219:in `spawn_rails_application'
  passenger (3.0.9) lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add'
  passenger (3.0.9) lib/phusion_passenger/spawn_manager.rb:214:in `spawn_rails_application'
  passenger (3.0.9) lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize'
  passenger (3.0.9) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
  passenger (3.0.9) lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application'
  passenger (3.0.9) lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application'
  passenger (3.0.9) lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
  passenger (3.0.9) helper-scripts/passenger-spawn-server:99

[Colin Law]

On 3 April 2013 10:31, keerthi priya <emailtoke...@gmail.com> wrote:
> Hello everyone,
>
> I am trying to create reports and the batch has 750 students. with i trying
> to create report for that batch i am getting this error in my production .
> How to solve this thing. kindly help me thanks in advance.
>
>
> ActiveRecord::StatementInvalid (Mysql::Error: MySQL server has gone away:

If no-one comes up with anything more useful then googling for
rails Mysql::Error: MySQL server has gone away
yields numerous hits that may be helpful, starting with [1].

Colin

[1] http://stackoverflow.com/questions/100631/mysql-server-has-gone-away-with-rails