久々にredmineにログインしようと思ったらエラーが出た。
普通に閲覧する分には問題なかったのに。
★エラーメッセージ(ブラウザ上)
Internal error An error occurred on the page you were trying to access. If you continue to experience problems please contact your Redmine administrator for assistance. If you are the Redmine administrator, check your log files for details about the error. Back
★エラーメッセージ(ログファイル)
ActiveRecord::StatementInvalid (Mysql2::Error: Got error -1 from storage engine: UPDATE `users` SET `last_login_on` = '2013-11-09 17:52:47', `updated_on` = '2013-11-09 17:52:47' WHERE `id` = 1): /usr/local/lib/ruby/gems/1.9.1/gems/mysql2-0.2.18/lib/active_record/connection_adapters/mysql2_adapter.rb:265:in `execute' /usr/local/lib/ruby/gems/1.9.1/gems/mysql2-0.2.18/lib/active_record/connection_adapters/mysql2_adapter.rb:282:in `update_sql' app/models/user.rb:162:in `try_to_login' app/controllers/account_controller.rb:143:in `password_authentication' app/controllers/account_controller.rb:138:in `authenticate_user' app/controllers/account_controller.rb:30:in `login' <internal:prelude>:10:in `synchronize' passenger (3.0.17) lib/phusion_passenger/rack/request_handler.rb:96:in `process_request' passenger (3.0.17) lib/phusion_passenger/abstract_request_handler.rb:516:in `accept_and_process_next_request' passenger (3.0.17) lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop' passenger (3.0.17) lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler' passenger (3.0.17) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `block in handle_spawn_application' passenger (3.0.17) lib/phusion_passenger/utils.rb:470:in `safe_fork' passenger (3.0.17) lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application' passenger (3.0.17) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' passenger (3.0.17) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' passenger (3.0.17) lib/phusion_passenger/abstract_server.rb:180:in `start' passenger (3.0.17) lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start' passenger (3.0.17) lib/phusion_passenger/spawn_manager.rb:219:in `block (2 levels) in spawn_rails_application' passenger (3.0.17) lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add' passenger (3.0.17) lib/phusion_passenger/spawn_manager.rb:214:in `block in spawn_rails_application' passenger (3.0.17) lib/phusion_passenger/abstract_server_collection.rb:82:in `block in synchronize' <internal:prelude>:10:in `synchronize' passenger (3.0.17) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize' passenger (3.0.17) lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application' passenger (3.0.17) lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application' passenger (3.0.17) lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application' passenger (3.0.17) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' passenger (3.0.17) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' passenger (3.0.17) helper-scripts/passenger-spawn-server:99:in `<main>' Rendering /public/500.html (500 Internal Server Error)
原因は、redmineというよりもMySQLにあった。
my.cnfに「innodb_force_recovery」がONになっていて、
それが許可されてないとエラーにあった。
とりあえずそれをoffにしたら動作した。
★MySQLの実行エラー
#1030 Got error from storage engine
★MySQLのエラーログ
InnoDB: A new raw disk partition was initialized or InnoDB: innodb_force_recovery is on: we do not allow InnoDB: database modifications by the user. Shut down InnoDB: mysqld and edit my.cnf so that newraw is replaced InnoDB: with raw, and innodb_force_... is removed
