Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By Gunnar Langemark on
I recently upgraded Langemarks Cafe to 4.6.5
I have been very satisfied.
Now it seems I have a database problem at hand.
Last night my site went dead.
This morning I was able to access it. I also took a look at the database.
It was a little f..... up.
I had to drop the sessions table and restore a "new" one.
I also had to empty the cache.
But the node counter table was "busy" as well (that's what PhpMyAdmin calls it).
I can't do anything with it.
It is - i think - quite important data - as opposed to the sessions and the cache.
How can I fix it? Does anyone have an idea.
I'm aware this is not really a drupal specific question, but it is sure specific to my drupal database.
Best
Gunnar
Comments
Got my hosting support to help
Got my hosting support to help me out.
This is off course a db problem which is not really Drupal related.
What happens is: I can't just remove the table - because it holds important data. I can't just kill MySQL as it is a shared installation it runs on. So someone with root or similar, must access the db and kick the said table somehow, or he must kill the process and restart it.
Now you know, if you have a similar problem.
Gunnar Langemark
http://www.langemark.com