Hello All...
This is the third time this has happened in the past month or so (twice this week!). We get the errors below when we hit the site.
When I go to the phpMyAdmin at the host, all but 2 of the tables have disappeared from the database.
We contact our host, and they restore the database. This seems to restore the functionality of the site. At first, I chalked it up to bad luck. Now, after two more times this week, I think there's something wrong.
I have many modules installed, including Backup and Migrate and Poormanscron. I'm not sure what would delete the tables in the database, but that doesn't seem right to me. There must be some sort of a conflict?
I tried to google the various error messages, but many of the results reference installation issues. This site has been installed and running for several months without these issues. Now all of the sudden we are getting hit with this.
Does anyone have any clue what might be causing these tables to go missing?
Thanks!
Kevin
--------------------------
Warning: Incorrect information in file: './ntssnrg_MMS/access.frm' query: SELECT 1 FROM access WHERE type = 'host' AND LOWER('68.164.244.31') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /home/ntssnrg/public_html/includes/database.mysqli.inc on line 128
Warning: Incorrect information in file: './ntssnrg_MMS/users.frm' query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '0285ee08f7566a82030b5b06354f4cb9' in /home/ntssnrg/public_html/includes/database.mysqli.inc on line 128
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/ntssnrg/public_html/includes/database.mysqli.inc:128) in /home/ntssnrg/public_html/includes/bootstrap.inc on line 1162
Warning: Incorrect information in file: './ntssnrg_MMS/cache.frm' query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /home/ntssnrg/public_html/includes/database.mysqli.inc on line 128
Warning: Incorrect information in file: './ntssnrg_MMS/variable.frm' query: SELECT * FROM variable in /home/ntssnrg/public_html/includes/database.mysqli.inc on line 128
Warning: Incorrect information in file: './ntssnrg_MMS/cache.frm' query: UPDATE cache SET data = '', created = 1292626960, expire = 0, headers = '', serialized = 0 WHERE cid = 'variables' in /home/ntssnrg/public_html/includes/database.mysqli.inc on line 128
Warning: Incorrect information in file: './ntssnrg_MMS/system.frm' query: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /home/ntssnrg/public_html/includes/database.mysqli.inc on line 128
Warning: Cannot modify header information - headers already sent by (output started at /home/ntssnrg/public_html/includes/database.mysqli.inc:128) in /home/ntssnrg/public_html/includes/bootstrap.inc on line 726
Warning: Cannot modify header information - headers already sent by (output started at /home/ntssnrg/public_html/includes/database.mysqli.inc:128) in /home/ntssnrg/public_html/includes/bootstrap.inc on line 727
Warning: Cannot modify header information - headers already sent by (output started at /home/ntssnrg/public_html/includes/database.mysqli.inc:128) in /home/ntssnrg/public_html/includes/bootstrap.inc on line 728
Warning: Cannot modify header information - headers already sent by (output started at /home/ntssnrg/public_html/includes/database.mysqli.inc:128) in /home/ntssnrg/public_html/includes/bootstrap.inc on line 729
Warning: Incorrect information in file: './ntssnrg_MMS/url_alias.frm' query: SELECT COUNT(pid) FROM url_alias in /home/ntssnrg/public_html/includes/database.mysqli.inc on line 128
Comments
That's weird.
I've been doing sites a long time (over 12 years) and vanishing tables is weird. It could be a module, but that seems really unlikely. I guess you could do a bulk search in your sites/all/modules directory for "DROP TABLE" and see if anything comes up and work from there. There's a slim chance someone is using an sql injection attack to drop your tables. You should make sure all your modules are up to date, particularly security updates. Another possibility is the servers' hard drive is failing. I've had that happen. The early symptoms were lots of tables going corrupt every day or two. If you're on a shared host you can ask them to move you to a new server, or switch hosts even if only for your db server.
Are you sure the tables are actually gone and it's not just a syntax error in a query?
It seemed like they were gone...
Thanks for the response!!
It really seemed like they were gone. When I went to the phpMyAdmin and clicked on the database, only 2 tables were there (semaphore and og_content_type_admin). That was the first two times it happened.
The last time it happened, all the tables showed up in phpMyAdmin, but when I tried to click "browse" on the table, it would give me the same error that drupal was giving me "Warning: Incorrect information in file: './ntssnrg_MMS/access.frm'./ntssnrg_MMS/access.frm". But, I was able to still access/browse semaphore and og_content_type_admin.
The other thing that was different between the two was the first two times the tech at the host said he "repaired" the database. This last time with the corrupted .frm files, he had to do a restore (repair didn't work).
Right now, the only real clues I have are the database tables that remain after the corruption (semaphore and og_content_type_admin).
There are a couple of modules that do need updating. So, I will update those today. I'm hoping that might solve the issue! But only time will tell...