Page MenuHomePhabricator
Create Task
Maniphest T57788

Jenkins: Create shell wrapper to setup MySQL database
Closed, ResolvedPublic8 Estimated Story Points
Actions

Description

To test out automatic MediaWiki release, we would need a MySQL database setup on a per job / per build basis.

To achieve that, a shell sript needs to be written that would use a jenkins user having create database / create user rights. The script would take in parameter a database name, user and password to create, that can later on be used by the Job to initialize the database and run tests with it.

This is a blocker for automatic MediaWiki release and will let us run unit tests using a MySQL database in addition to Sqlite backed tests.

So, that is quite important :-] Have been requested for mw/core PHPunit testing in bug 35912.

Version: wmf-deployment
Severity: enhancement

Details

Reference
bz55788
SubjectRepoBranchLines +/-
mediawiki-core-qunit-karma: Use mysql instead of sqliteintegration/configmaster+19 -6
mw-teardown-mysql: Include mw-teardown.shintegration/jenkinsmaster+1 -1
Implement mw-install-mysql and mw-teardown-mysqlintegration/jenkinsmaster+47 -3
mw-setup: Move LocalSettings.php from mw-install-sqlite to mw-setupintegration/jenkinsmaster+5 -5
Customize query in gerrit

Related Objects
Search...

Event Timeline

• bzimport raised the priority of this task from to Low.Nov 22 2014, 2:39 AM
• bzimport added a project: Continuous-Integration-Infrastructure.
• bzimport set Reference to bz55788.
• bzimport added a subscriber: Unknown Object (MLST).
hashar created this task.Oct 16 2013, 1:19 PM
hashar added a comment.Oct 16 2013, 1:19 PM

High priority, needs to get that done by end of week.

hashar added a comment.Nov 18 2013, 11:48 PM

Back in pool, that is not really a priority right now.

hashar added a comment.Dec 2 2013, 12:58 PM

Not a priority

• demon unsubscribed.Dec 16 2014, 6:05 PM
Krinkle moved this task from Untriaged to Next on the Continuous-Integration-Infrastructure board.Mar 2 2015, 3:00 PM
Krinkle raised the priority of this task from Low to High.Mar 18 2015, 1:38 AM
Krinkle set Security to None.

Raising priority per https://phabricator.wikimedia.org/T37912#1078582 and because SQLite is continuing to be unstable and cause critical problems and failing jobs blocking feature development in other departments (eg. T89180).

Krinkle claimed this task.Mar 18 2015, 4:29 PM
Krinkle moved this task from Next to In-progress on the Continuous-Integration-Infrastructure board.
Krinkle added a parent task: T89180: Jenkins jobs using MediaWiki frequently fail due to database locks .
Krinkle removed a subscriber: Unknown Object (MLST).
gerritbot subscribed.Mar 18 2015, 7:12 PM

Change 197710 had a related patch set uploaded (by Krinkle):
mw-setup: Move LocalSettings.php from mw-install-sqlite to mw-setup

https://gerrit.wikimedia.org/r/197710

gerritbot added a project: Patch-For-Review.Mar 18 2015, 7:12 PM

Change 197710 merged by jenkins-bot:
mw-setup: Move LocalSettings.php from mw-install-sqlite to mw-setup

https://gerrit.wikimedia.org/r/197710

awight subscribed.Mar 19 2015, 12:39 AM
gerritbot added a comment.Mar 19 2015, 2:41 AM

Change 197847 had a related patch set uploaded (by Krinkle):
Implement mw-install-mysql and mw-teardown-mysql

https://gerrit.wikimedia.org/r/197847

gerritbot added a comment.Mar 19 2015, 2:56 AM

Change 197847 merged by jenkins-bot:
Implement mw-install-mysql and mw-teardown-mysql

https://gerrit.wikimedia.org/r/197847

gerritbot added a comment.Mar 19 2015, 5:39 PM

Change 197956 had a related patch set uploaded (by Krinkle):
mw-teardown-mysql: Include mw-teardown.sh

https://gerrit.wikimedia.org/r/197956

gerritbot added a comment.Mar 19 2015, 5:41 PM

Change 197956 merged by jenkins-bot:
mw-teardown-mysql: Include mw-teardown.sh

https://gerrit.wikimedia.org/r/197956

gerritbot added a comment.Mar 19 2015, 9:45 PM

Change 197958 had a related patch set uploaded (by Krinkle):
Convert MediaWiki jobs from sqlite to mysql

https://gerrit.wikimedia.org/r/197958

Jdforrester-WMF added a project: VisualEditor 2014/15 Q3 blockers.Mar 20 2015, 12:10 AM
Krinkle closed this task as Resolved.Mar 20 2015, 8:21 AM
Krinkle mentioned this in T89180: Jenkins jobs using MediaWiki frequently fail due to database locks .

The mw-install-mysql.sh is merged and deployed. It is already used by the qunit and qunit-karma jobs. Using it for PHPUnit jobs is T37912.

Jdforrester-WMF edited a custom field.Mar 20 2015, 3:54 PM
Jdforrester-WMF moved this task from Nominated to Done on the VisualEditor 2014/15 Q3 blockers board.
gerritbot added a comment.Mar 20 2015, 5:14 PM

Change 197958 merged by jenkins-bot:
mediawiki-core-qunit-karma: Use mysql instead of sqlite

https://gerrit.wikimedia.org/r/197958

Krinkle moved this task from In-progress to Done on the Continuous-Integration-Infrastructure board.Mar 20 2015, 6:09 PM
Krinkle mentioned this in rCICF79c9ba57f811: mediawiki-core-qunit-karma: Use mysql instead of sqlite.Mar 23 2015, 3:56 PM
Krinkle mentioned this in rCIJE1a178a17c697: mw-setup: Move LocalSettings.php from mw-install-sqlite to mw-setup.Mar 24 2015, 5:39 PM
Krinkle mentioned this in rCIJE5776ae65e166: mw-teardown-mysql: Include mw-teardown.sh.
Krinkle mentioned this in rCIJEbb49b5b4ec7f: Implement mw-install-mysql and mw-teardown-mysql.
Jdforrester-WMF added a project: WMF-deploy-2015-03-25_(1.25wmf23).Mar 25 2015, 6:48 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits