Page MenuHomePhabricator
Create Task
Maniphest T112835

Document stricter MySQL policy and settings for MediaWiki
Closed, ResolvedPublic
Actions

Description

We intend T108255: Enable MariaDB/MySQL's Strict Mode and want T112637: RFC: Increase the strictness of mediawiki SQL code and leverage database code blockers for scalability, so document.

  • recommend debugging settings that display warnings
    • warn that these warnings will become errors
  • new requirements in coding standards: no warnings and primary key on all tables)

Relevant wiki pages

Related Objects
Search...

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
· · ·
Resolved• RobLa-WMFT112637 RFC: Increase the strictness of mediawiki SQL code and leverage database code blockers for scalability
ResolvedjcrespoT112835 Document stricter MySQL policy and settings for MediaWiki
· · ·

Event Timeline

• Spage created this task.Sep 16 2015, 11:32 PM
• Spage claimed this task.
• Spage raised the priority of this task from to Needs Triage.
• Spage updated the task description. (Show Details)
• Spage added projects: Documentation, MediaWiki-Documentation, DBA.
• Spage added subscribers: • Mattflaschen-WMF, Krenair, • RobLa-WMF and 5 others.
• RobLa-WMF added a comment.EditedSep 16 2015, 11:44 PM

Thanks for taking this on @Spage! I think having a single new page which uses T112637 as a foundation would be great. If you know where to look, there's a very alpha pandoc adapter for Remarkup (used by Phab), which I'm guessing could be used to convert it to MediaWiki markup. At that point, pointing the rest of the URLs you list above to that new document would be ideal (summary style, not merely a buried link).

https://www.mediawiki.org/wiki/Development_policy/Database might be a good location for this, but I don't have a strong opinion.

• Spage added a comment.Sep 17 2015, 4:10 PM

For now I added a new section https://www.mediawiki.org/wiki/Development_policy#Database_policy and will link to it from the DB pages. Thanks for the list and tips.

• Spage triaged this task as Medium priority.Nov 5 2015, 12:27 AM
• Spage reassigned this task from • Spage to jcrespo.Nov 5 2015, 12:33 AM
• Spage subscribed.

Hi there.

  • Are we ready to "recommend debugging settings that display [DB] warnings"? Or perhaps the default settings and/or MW-Vagrant settings have been changed

Perhaps this task is complete \o/

jcrespo closed this task as Resolved.Nov 5 2015, 8:04 AM

I think the documentation part of the RFC is covered. I am working with Release-Engineering-Team to push for changes on beta first, then we will enable warnings (totally or partially) to be logged somewhere (we have to be careful not to flood the current system). Those will be handled on separate tickets: T108255 / https://gerrit.wikimedia.org/r/#/c/198661/ ).

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