I logged into the server, and looked in the httpd error_log, and noticed two
[Wed Oct 19 15:41:31 2011] [error] [client XXXXXX] PHP Fatal error: Call to
a member function getLastActivity() on a non-object in
/var/www/html/pearweb/pear.php.net/public_html/bugs/report.php on line 480
[Wed Oct 19 15:41:34 2011] [error] [client XXXXXX] pearweb errorhandler: DB
Error: unknown error... \n SELECT\n packages.name,
unix_timestamp(releases.releasedate))/86400)) as d\n FROM
releases, packages, aggregated_package_stats a\n
WHERE\n packages.name <> "pearweb"
AND\n packages.name <> "pearweb_phars"
AND\n packages.id = releases.package
AND\n packages.package_type = 'pear'
AND\n a.release_id = releases.id AND\n
a.package_id = packages.id AND\n packages.newpk_id IS
NULL AND\n packages.unmaintained = 0
AND\n a.yearmonth = "2011-10-01
00:00:00"\n ORDER BY d DESC LIMIT 0, 5 [nativecode=145 **
Table './pear/aggregated_package_stats' is marked as crashed and should be
repaired], referer: XXXXXXXX
I stopped Apache, logged in as mysql root, and ran:
repair table pear.aggregated_package_stats;After that, started Apache again, and the website appears to be functioning
It would appear that the package download statistics, which are stored in
the db, could interfere with package downloads in the event that the
database fails. Perhaps we should look into alternative ways of storing the