Last modified: 2013-12-02 12:58:35 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T37912, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 35912 - Jenkins: Set up PHPUnit testing on MySQL backend
Jenkins: Set up PHPUnit testing on MySQL backend
Status: NEW
Product: Wikimedia
Classification: Unclassified
Continuous integration (Other open bugs)
unspecified
All All
: Low enhancement with 2 votes (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on: 55788
Blocks: 20343
  Show dependency treegraph
 
Reported: 2012-04-12 14:02 UTC by christian
Modified: 2013-12-02 12:58 UTC (History)
8 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description christian 2012-04-12 14:02:31 UTC
Currently, we run the PHPUnit test suite using the SQLite backend using Jenkins upon committing code into core.

However, Wikimedias's setup relies on MySQL and MySQL is also MediaWiki's suggested DBMS.

Hence, it would be great to have Jenkins additionally run the PHPUnit test suite using the MySQL backend.



P.S.: A similar bug is said to exist in bugzilla—however, I could not find such a bug.
Comment 1 christian 2012-04-12 14:06:10 UTC
*** This bug has been confirmed by popular vote. ***
Comment 2 Ariel T. Glenn 2012-04-12 14:47:39 UTC
fwiw I would love to see this happen, given that WMF's production (and labs) backend is MySQL and not SQLite.
Comment 3 Tim Landscheidt 2012-10-04 12:00:59 UTC
Any update on this?
Comment 4 Ori Livneh 2013-02-24 18:50:37 UTC
Could someone provide examples of the sort of bugs or crashes that would have been caught by using MySQL as the back-end for the unit tests?
Comment 5 Matthew Flaschen 2013-05-23 00:03:32 UTC
There are a couple cases I'm aware of with using SQLite:

1. The math extension can not run all of its tests, since SQLite has global indices.  See https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/extensions/Math.git;a=blob;f=tests/MathDatabaseTest.php;h=f909f7f20cdcf7814d2ac9c08bc777c25401e764;hb=refs/heads/master#l86 .  Judging by that comment, all other databases including MySQL work.
2. Similarly, Echo had an issue since SQLite doesn't have "ALTER TABLE CHANGE" (https://gerrit.wikimedia.org/r/#/c/64594/).

Of course, it's preferable to support multiple databases, including SQLite if possible.  But it would be very useful to also test in MySQL both because the behavior can differ, and because SQLite sometimes just doesn't work for what we currently need.
Comment 6 Antoine "hashar" Musso (WMF) 2013-05-23 09:25:07 UTC
Since I started working on CI we always wanted to test against different database backend.  I am not sure the full test suite is really needed, but we should at least run the installer, that will most probably catch up the commons issues.
Comment 7 Antoine "hashar" Musso (WMF) 2013-12-02 12:58:35 UTC
Not a priority

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links