MySQL Issues

[mozsumo]

I have been having many persistent MySQL issues with my Drupal site on Lotus. Quite often, my admin pages fill up with hundreds of MySQL errors. They're are tons and tons of errors like this:

Warning: MySQL server has gone away query: INSERT INTO drupal_watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:373947:\"Lost connection to MySQL server during query\nquery: UPDATE drupal_cache_update SET data = 'a:49:{s:8:\\"addtoany\\";a:10:{s:5:\\"title\\";s:32:\\"Add to Any Share/Bookmark Button\\";s:10:\\"short_name\\";s:8:\\"addtoany\\";s:10:\\"dc:creator\\";s:12:\\"patPrzybilla\\";s:11:\\"api_version\\";s:3:\\"6.x\\";s:17:\\"recommended_major\\";s:1:\\"2\\";s:16:\\"supported_majors\\";s:1:\\"2\\";s:13:\\"default_major\\";s:1 in /home/mozsumo/public_html/includes/database.mysqli.inc on line 128

.
Sometimes it doesn't have any, and sometimes it has thousands or more. What can I do?

 

[adamparkzer]

Did you try reinstalling a clean copy of Drupal? The one you have right now might have errors in it.

 

[jtwhite]

It's probably due to a high server load. I searched on Google about the "Warning: MySQL server has gone away," and found this on the MySQL website:

Quoted from: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection.

Which means the server was probably experiencing a high load.

 

[mozsumo]

since this happens frequently, I will try AdamParkzer's suggestion. I will just connect my new installation of Drupal to the same database so I keep all info.

 

[adamparkzer]

since this happens frequently, I will try AdamParkzer's suggestion. I will just connect my new installation of Drupal to the same database so I keep all info.

Sounds good.

Feel free to post back and let us know if you have any more questions, or if you are still having problems after your new installation.

 

[mozsumo]

AHHHH! I am still having issues.

This made it worse. I don't know what to do! If you need to see it, let me know. I will arrange for you to have admin privileges to see what it looks like. (or, if you want, i can post a screenshot, but you wont be able to see the whole thing. There is SO MUCH)

Now, it has more errors and it says that I don't have any administrative items.