Support

Admin Tools

#25105 Repair table hangs at 50% completion

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by on Wednesday, 08 June 2016 17:20 CDT

Monday, 09 May 2016 09:05 CDT

hdeleo
 Admin Tools Repair and Optimize tables was working fine in Joomla 3.4.8. An upgrade to Joomla 3.5.1 resulted in a number of crashes, traced finally to mixed collation issues because MySQL 5.1.73 doesn't support multibyte collation. I then used admin tools to set the database collation to Joomla default, and the crashes stopped. PHPMyAdmin reports the database collation is utf8_general_ci. Joomla's Fix Database reports database is up to date with no problems.

In Joomla 3.5.1, when I use Admin Tools to Repair and Optimize Tables, the progress bar hangs at 50%" completion, then I receive a Gateway Timeout error. My host responded to my trouble ticket with this:

"I've increased all of the variables for the site that I can: Post sizes, time outs, etc."

I tried Repair and Optimize Tables again and got the same Gateway Timeout error.

So I used phpmyadmin to first Repair all tables. About one-half of the tables are OK, the rest report:

"The storage engine for the table doesn't support r..." I assume the last word is "repair"

InnoDB is the storage engine for the tables with the above note. Is this why Admin Tools hangs on Repair? How do I repair tables that are using the InnoDB storage engine?

Thank you,
Hank

Monday, 09 May 2016 10:45 CDT

nicholas
If there is a table that's too big or too broken it's possible that MySQL will take a long time to return a result. Since Admin Tools has to run inside Joomla! and respect the default limits on the public web server, the web server may issue a timeout before MySQL returns a result.

phpMyAdmin, on the other hand, runs under a different web server that's reserved to cPanel users for site administration. As such, it is configured differently and has far more lax restrictions. This is why it can complete long running operations without timing out.

Basically, nobody can do much about it. Use phpMyAdmin to make sure that no table is broken and periodically optimize your (big) tables with it.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 08 June 2016 17:20 CDT

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
Edited by on 2016-06-08 17:20 CDT

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!