Last modified: 2014-09-15 15:30:49 UTC
Imported from RT #550: sync-dblist and other scripts that synchronize dblists (I think scap does this, maybe sync-common-all does as well) should check that each DB listed in each dblist exists and refuse to sync if that's not the case. This was suggested on wikitech-l after SUL broke due to the addition of a nonexistent DB to all.dblist . I've also previously broken SUL the same way by adding an empty line to all.dblist . See https://lists.wikimedia.org/pipermail/wikitech-l/2011-January/051347.html [Editor's note: url changed from RT ticket to point to what I think is the correct email thread.]
1) How do we verify that a db exists? Attempt to connect to it via a maintenance script or other means? 2) Do all dblist files need to be checked or just all.dblist?
If we ever manage to publicly expose the list of database name actually deployed on the cluster, we could then add an integration test on operations/mediawiki-config.git that would refuse to have the .dblist change merged. Fail early for the win!