I tried upgrading from 1.21.3 to 1.22.0 last night. It worked on one server (PHP 5.5.3 and mySQL 5.5.34) but not on the second one (PHP 5.3.27 and mySQL 5.1.68) with exactly the same codebase. There were no errors in the Apache error_log, but I'll describe the symptoms and maybe someone might have a theory what to try next...?
On server #1, I deployed 1.22.0 and copied my /images and LocalSettings.php files from 1.21.3, then ran update.php. Everything worked. I copied the same files to server #2, ran update.php, and saw no errors.
Then I hit the main page (whatever.com/wiki/Home) as an anonymous user. When the home page rendered, it had this error message printed at the bottom:
Notice: Uncommitted DB writes (transaction from DatabaseBase::query (WikiPage::pageData)). in ...../w/includes/db/Database.php on line 3944
I clicked "Log In", and the home page just sat there. Running a "ps uax" I saw these processes:
me 16283 0.5 1.0 160180 43948 ? S 23:45 0:00 /usr/bin/php /home/me/public_html/w/index.php me 16286 0.0 0.0 0 0 ? Z 23:45 0:00 [bash] <defunct> me 16287 0.0 0.4 134764 17532 ? S 23:45 0:00 /usr/bin/php /home/me/public_html/w/maintenance/runJobs.php --maxjobs 1 me 16295 0.4 1.0 160036 43856 ? S 23:45 0:00 /usr/bin/php /home/me/public_html/w/index.php me 16296 0.0 0.0 0 0 ? Z 23:45 0:00 [bash] <defunct> me 16297 0.1 0.4 134764 17544 ? S 23:45 0:00 /usr/bin/php /home/me/public_html/w/maintenance/runJobs.php --maxjobs 1 me 16847 0.1 0.4 87388 17468 ? S 23:46 0:00 /usr/bin/php /home/me/public_html/w/index.php me 16856 0.1 0.4 87388 17480 ? S 23:46 0:00 /usr/bin/php /home/me/public_html/w/index.php me 16878 0.1 0.4 87388 17468 ? S 23:46 0:00 /usr/bin/php /home/me/public_html/w/index.php
I checked the job queue with maintenance/showJobs.php, and there were 0 jobs.
The processes were not exiting (my browser was still spinning), so I killed them by hand.
Then I tried it again: restored the database back to 1.21.3, reinstalled the 1.22.0 update a second time, and reran update.php. The same problems occurred.
That is all I know at the present time. Any tips appreciated.
DanB
Bartosz Dziewonski writes:
https://bugzilla.wikimedia.org/show_bug.cgi?id=47375 https://bugzilla.wikimedia.org/show_bug.cgi?id=56269
Thanks, I saw those bug reports too. However, none of those reports says anything about the wiki being unresponsive, just that the errors are emitted. In my case, I also can't log in: the browser just spins, and no errors are produced in the httpd error log.
Perhaps this error message is only a symptom of some larger issue?
DanB
mediawiki-l@lists.wikimedia.org