redmineにログイン出来ない ・・・ MySQLのエラー

久々に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
タイトルとURLをコピーしました