The platform verification task takes a long time to execute on a big (200+ projects) platform. It seems the indexing of the packages in the frontend eats its own brain for around two minutes:

[...]
apache on ceres has been restarted [3.5 sec, 36.82 MB]                                                                                                                                                                                 [notice]
Use of undefined constant PROVISION_CONTEXT_SITE - assumed 'PROVISION_CONTEXT_SITE' verify.provision.inc:52 [3.5 sec, 36.82 MB]                                                                                                        [notice]
Template loaded: /srv/aegir/.drush/provision/provision_drushrc.tpl.php [3.5 sec, 36.82 MB]                                                                                                                                             [notice]
Changed permissions of /var/aegir/platforms/prod-drupal-5.23-1.0/drushrc.php to 600 [3.5 sec, 36.82 MB]                                                                                                                               [message]
Generated config Platform Drush configuration file [3.5 sec, 36.82 MB]                                                                                                                                                                [message]
Changed permissions of /var/aegir/platforms/prod-drupal-5.23-1.0/drushrc.php to 400 [3.5 sec, 36.82 MB]                                                                                                                               [message]
Command dispatch complete [3.5 sec, 36.82 MB]                                                                                                                                                                                          [notice]
Peak memory usage was 12.44 MB [3.5 sec, 36.82 MB]                                                                                                                                                                                     [memory]


Command dispatch complete [166.83 sec, 38.79 MB]                                                                                                                                                                                       [notice]
 Timer  Cum (sec)  Count  Avg (msec)
 page   166.618    1      166618.04

Peak memory usage was 39.34 MB [166.83 sec, 38.79 MB]                                                                                                                                                                                  [memory]

... almost three minutes... An strace shows me it's the hosting_package_* tables that suffer the load.

Comments

omega8cc’s picture

omega8cc commented

This is probably related to the old hidden issue mig5 found when working on another issue, see this comment: http://drupal.org/node/907248#comment-3429476 and this: http://drupal.org/node/907248#comment-3436884

In short, hosting_package_* tables in your database are probably full of old zombies.

This has been fixed in alpha14 for new installs, but upgraded instances needs some healing probably.

anarcat’s picture

anarcat commented
Status: Active » Postponed (maintainer needs more info)

I suspect #969326: Schema prevents install on MariaDB may (also?) play a role here. Since I have committed a patch to fix that bug, I think this should be retested. I'll also take a look to see if i have zombies to kill (shotgun!).

Anonymous’s picture

Anonymous (not verified) commented

Would this also be fixed by your recent indexing working on the packages table? #1033072: migrate interface takes forever (litterally) to load

anarcat’s picture

anarcat commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)

Interesting! Probably yes!

Let's close this as a dupe then.

@omega8cc - if you have suggestions on how to cleanup older installs, please document in #1034520: Cleanup zombie entries in hosting_package_* tables?.