I had a strange thing happen the other day -- due to a bunch of tables in the db getting corrupted, my site ended up spamming our entire user base with 40+ messages each. The messages in question were generated by the "Advanced User" module (http://drupal.org/project/advuser) as well as "Notify" (http://drupal.org/project/notify).
"Advanced User" is set up to email administrators each time a user account is modified in some way, or if a new user registers at the site. Yet due to the db corruption, all users were spammed with these admin-only messages, and the "from" address was actually that of my server provider, and not the addy associated with the site.
"Notify" notifies users of new content. Multiple, duplicate messages were emailed out every cron run until the problem could be fixed.
Here's the tables that were corrupted:
abuse
accesslog
avatar_approval
blocks
book
cache
cache_block
cache_content
cache_filter
cache_menu
cache_page
cache_views
comments
files
flatforum
flood
forum
history
legal_accepted
menu
node
node_access
node_comment_statistics
node_counter
node_revisions
poll_choices
poll_votes
profile_values
search_dataset
search_index
search_total
sequences
sessions
shoutbox
spam_log
spam_tracker
term_data
term_hierarchy
term_node
troll_ip_track
url_alias
user_postcounts
usernode
users
variable
votingapi_cache
votingapi_vote
watchdog
Most of the tables were marked as "clients are using or haven't closed the table properly" although cache_block and variable were marked as "crashed".
I should also note that when this massive problem happened, all site settings were unavailable, the theme was messed up, and I couldn't even set the site to "offline". I had to create a dummy index.php file to put the site offline while I repaired the db.
We're still trying to figure out what happened, but what really concerns me is the massive spamming of users that occurred, especially sending emails for admin eyes only.
Site info:
Drupal 5.7
File system Writable (public download method)
JQuery Update Installed correctly
The current installed version of JQuery is 1.2.1
MySQL database 5.0.51a
PHP 5.2.5
PHP register globals Disabled
Unicode library PHP Mbstring Extension
Web server Apache/2.2.8 (FreeBSD) mod_ssl/2.2.8 OpenSSL/0.9.8g DAV/2 PHP/5.2.5 with Suhosin-Patch
Comments
Have you managed to figure
Have you managed to figure out what caused this issue?
Cheers,
G
My Drupal sites:
Unfortunately no, we never
Unfortunately no, we never determined what caused this massive crash. Once the db tables were repaired, the site worked just fine. As to what lead to it all, I don't have a clue...and it hasn't happened again. *touch wood*
Wish I could be more helpful...
Check error logs
Why don't you check the error logs on your site. Possible you could have information there as to what caused it. Administer => Reports => recent log entries
Ron
just checked but this
just checked but this happened back in April, and my logs don't go back that far, sorry.