Project

General

Profile

Database mysteriously getting deleted

Added by Kit Menlove about 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 about 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 about 12 years ago

Yes, I have other databases there, but none have been affected.

    (1-2/2)