Mysql::Error: MySQL server has gone away

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

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] "MySQL server has gone away" with Ruby on Rails - Stack Overflow