Help regarding MySQL Error....

backroger · 03-01-2011, 07:05 AM

Hi guys...

I need help about the error in my website. I have the following error....

Code:

user warning: Got error 134 from storage engine query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:database1' in /var/www/html/web/includes/cache.inc on line 26.

Any help will be much appreciated.

Thanks in advance.

Noway2 · 03-01-2011, 07:41 AM

Searching for the term "Got error 134 from storage engine query" indicates that this is typically caused by corruption of the MySQL database. The solution seems to be to either (attempt) a repair of the tables or a truncate. Apparently there was also a known bug in MySQL that can cause this corruption. I also notice that the threads that it pulls up seem to be on the order of 2-3 years old. What versions of web server, MySQL, and any content manager are you running and especially how recent are they? Have you checked the bug list for these versions?

Also, if you try to access the tables directly with the SQL monitor, does the data look ok?

backroger · 03-01-2011, 08:16 AM

Thanks Noway2...

I'm using RHEL 6.0 and use it as a LAMP. I had a hard crash due to a power supply failure. When I replace it and turn it on, that message appear when I visit the webpage. Yeap...i've search that problem in google and that also came up. I will try to repair the database via phpmyadmin tomorrow since i'm at home now.

Again, thanks.