Database mysteriously getting deleted
Added by Kit Menlove over 12 years ago
I have a strange problem that I'm having a hard time getting to the bottom of. I installed Redmine 2.0.1 on Ruby 1.8.7 with Rails 3.2.3.
At random times (once or twice a week), the database gets deleted and I get a "rake aborted! Unknown database" error. As far as MySQL is concerned, the database ceases to exist, though it is still shown in cPanel's MySQL Databases page (with a size of 0.00 MB).
Any ideas on what could be causing this?
Notes:- If you couldn't tell, I'm using Passenger for deployment.
- I installed the mysql2 gem that includes the C bindings, though only after Redmine was installed if that makes a difference.
- I have receive_imap running every 5 minutes via a cron job, but the issue still occurs when the cron job is disabled.
- The production.log file contains the following entries repeated, none of which seem to be related to the database issue:
OpenIdAuthentication.store is nil. Using in-memory store.
Creating scope :open. Overwriting existing method Version.open.
Creating scope :active. Overwriting existing method User.active.
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at rails_apps/bp_redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
- RubyGems 1.7.2 and MySQL 5.1.63.
Replies (2)
RE: Database mysteriously getting deleted - Added by William Roush over 12 years ago
Do you have any other databases hosted on this MySQL box, are they affected?
RE: Database mysteriously getting deleted - Added by Kit Menlove over 12 years ago
Yes, I have other databases there, but none have been affected.