#4830 (ok 4.4.5) Maximum execution time exceeded in Util.class.php

[Olaf van der Spek]

This is 4.4.0 but that milestone is missing.

When attempting to browse a certain table:
2015-04-02 13:31:18: (mod_fastcgi.c.2695) FastCGI-stderr: PHP Fatal error: Maximum execution time of 30 seconds exceeded in /srv/router/phpMyAdmin-4.4.0-english/libraries/dbi/DBIMysqli.class.php on line 594
2015-04-02 13:32:03: (mod_fastcgi.c.2695) FastCGI-stderr: PHP Fatal error: Maximum execution time of 30 seconds exceeded in /srv/router/phpMyAdmin-4.4.0-english/libraries/Util.class.php on line 295
2015-04-02 13:35:17: (mod_fastcgi.c.2695) FastCGI-stderr: PHP Fatal error: Maximum execution time of 30 seconds exceeded in /srv/router/phpMyAdmin-4.4.0-english/libraries/Util.class.php on line 302

[Olaf van der Spek]

Got a sample table for you. demo PMA does handle this one but is quite slow (8s or so). What hardware does it run?

[Marc Delisle]

Thanks for the sample data. I can reproduce the 8s browse delay. When I go from 100 to 50 columns I reduce the delay to 4s. Looking at it.

[Marc Delisle]

Caused by:
https://github.com/phpmyadmin/phpmyadmin/commit/516f62561bb6d5551d0d9801ec4e0b48ed449e18

[Marc Delisle]

Another suggested patch; with this, I go from 8 to 2 seconds on your sample table.

[Olaf van der Spek]

I don't have "$columnCount = $this->__get('fields_cnt');" in that file. Is this against 4.4.4?

[Marc Delisle]

It's against QA_4_4. See https://github.com/phpmyadmin/phpmyadmin/commit/c1ed2803d6c5d29ee4f46cbd1dc19944f0918c76

[Marc Delisle]

Patch confirmed by Madhura and merged for 4.4.5. Olaf, please confirm when you have time.

[Olaf van der Spek]

Is it not yet in 4.5.0-dev (running on demo)?
I'll try locally.

[Marc Delisle]

I just checked and it's in the demo.

[Marc Delisle]

Olaf,
any feedback?

[Olaf van der Spek]

Will test in 4h.

[Olaf van der Spek]

A lot better, but still kinda slow (5.5s). Thx!

[Marc Delisle]

You tested on this system? "This system is a bit older and slower, it's a AMD Athlon(tm) XP 2500+ with 512mb memory"

[Olaf van der Spek]

Yep, that one. It's still a big improvement.