Enable MariaDB/MySQL's Strict Mode
Open, Stalled, LowPublic
Actions

Assigned To

None

Authored By

	JanZerebecki
	Aug 6 2015, 10:16 PM

Description

If you are looking for the full RFC, go to T112637

This task's scope is:

switching to MariaDB's Strict Mode, first on CI (T119371), then on production
Make it so that DB insert/update that would overflow would error out rather than be silently truncated
Generally promote better use of MariaDB by making many things fail precommit and/or fail loudly in production rather than failing quietly

Options discussed:

sql_mode = 'TRADITIONAL' (equivalent to STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER)
sql_mode = ONLY_FULL_GROUP_BY

Often, our non-strict usage is a fountain of bugs and security issues.

Slide by @jcrespo that explains it: https://www.slideshare.net/jynus/query-optimization-with-mysql-57-and-mariadb-10-even-newer-tricks/43 and https://www.slideshare.net/jynus/query-optimization-with-mysql-57-and-mariadb-10-even-newer-tricks/44

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.

Status	Subtype	Assigned	Task
			· · ·
Stalled		None	T108255 Enable MariaDB/MySQL's Strict Mode
Resolved		hashar	T119370 Send deployment-db1 deployment-db2 syslog to beta cluster logstash
Resolved		Krinkle	T119371 Enable MariaDB/MySQL strict mode for MW during development and Jenkins jobs
Open		None	T121489 Field 'ar_page' doesn't have a default value
Resolved		None	T117854 Missing updater for rc_ip field: RecentChange::save: 1406 Data too long for column 'rc_ip'
Resolved		Nikerabbit	T67807 Incorrect integer value: '' for column 'af_hidden'
Resolved		• RobLa-WMF	T112637 RFC: Increase the strictness of mediawiki SQL code and leverage database code blockers for scalability
Open		None	T138031 Category sort keys can exceed the capacity of cl_sortkey, yet that is not correctly handled
Resolved		Nikerabbit	T124628 LiquidThreads does not truncate comments: Data too long for column 'th_change_comment'
Resolved		Ejegg	T145591 CentralNotice: Support MariaDB Strict Mode
Open		None	T147875 SecurePoll should comply with strict mode
Resolved		• Marostegui	T149819 Add primary keys to remaining Flow tables
Open		None	T193246 JobQueueDB::doBatchPush fails with data too long for job_params when purging a template used on a few million pages
Resolved		TK-999	T199323 Checkuser does not truncate data (cuc_comment, cuc_agent, cuc_actiontext) and that causes exceptions with strict mode
Resolved		None	T220274 sql files of extension CreditsSource failing on unit tests due to default on text column
Open	BUG REPORT	None	T294775 Filter for multiple tags on Special:RecentChanges fails with 'recentchanges.rc_namespace' isn't in GROUP BY for sql mode ONLY_FULL_GROUP_BY
Open	BUG REPORT	None	T299826 action=query&list=allpages&apfilterlanglinks=withlanglinks fails with 'page.page_namespace' isn't in GROUP BY for sql mode ONLY_FULL_GROUP_BY
Resolved		None	T304762 Add SpecialPageFatalTest to @group Database
Resolved	BUG REPORT	Diesel_kapasule	T307613 Validate length of user email on Special:ChangeEmail/Special:CreateAccount to avoid database error "Data too long for column 'user_email'" on strict mode
Open		None	T322080 Error 1055: 'wikidb.mw_flow_tree_revision.tree_orig_user_ip' isn't in GROUP BY
Resolved	BUG REPORT	apasternak	T355530 Cannot delete files with non-standard extensions on MySQL in a strict mode
			· · ·

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

One potential issue I see with ONLY_FULL_GROUP_BY is that the optimizer still sucks at dealing with it:

Without ONLY_FULL_GROUP_BY

mysql:wikiadmin@db1083 [enwiki]> explain SELECT page_namespace, page_title, page_id, page_is_redirect FROM page WHERE page_namespace=0 AND page_title>='@' GROUP BY page_title LIMIT 11;
+------+-------------+-------+------+---------------+------------+---------+-------+----------+------------------------------------+
| id   | select_type | table | type | possible_keys | key        | key_len | ref   | rows     | Extra                              |
+------+-------------+-------+------+---------------+------------+---------+-------+----------+------------------------------------+
|    1 | SIMPLE      | page  | ref  | name_title    | name_title | 4       | const | 20324890 | Using index condition; Using where |
+------+-------------+-------+------+---------------+------------+---------+-------+----------+------------------------------------+
1 row in set (0.00 sec)

mysql:wikiadmin@db1083 [enwiki]> SELECT page_namespace, page_title, page_id, page_is_redirect FROM page WHERE page_namespace=0 AND page_title>='@' GROUP BY page_title LIMIT 11;
+----------------+----------------------+----------+------------------+
| page_namespace | page_title           | page_id  | page_is_redirect |
+----------------+----------------------+----------+------------------+
|              0 | @                    |  2214518 |                1 |
|              0 | @!                   | 37696354 |                1 |
|              0 | @$$                  | 21089863 |                1 |
|              0 | @&*!_Smilers         | 20573031 |                1 |
|              0 | @-Bristol            | 23905089 |                1 |
|              0 | @-symbol             | 25176688 |                1 |
|              0 | @440                 | 18159966 |                1 |
|              0 | @ANCAlerts           | 47685646 |                0 |
|              0 | @Andheri             | 42866631 |                0 |
|              0 | @Andheri_(2014_film) | 42914733 |                1 |
|              0 | @BarackObama         | 35944823 |                1 |
+----------------+----------------------+----------+------------------+
11 rows in set (0.09 sec)

mysql:wikiadmin@db1083 [enwiki]> SHOW STATUS LIKE 'Hand%';
+----------------------------+--------+
| Variable_name              | Value  |
+----------------------------+--------+
| Handler_commit             | 2      |
| Handler_delete             | 0      |
| Handler_discover           | 0      |
| Handler_external_lock      | 0      |
| Handler_icp_attempts       | 497545 |
| Handler_icp_match          | 16     |
| Handler_mrr_init           | 0      |
| Handler_mrr_key_refills    | 0      |
| Handler_mrr_rowid_refills  | 0      |
| Handler_prepare            | 0      |
| Handler_read_first         | 0      |
| Handler_read_key           | 1      |
| Handler_read_last          | 0      |
| Handler_read_next          | 11     |
| Handler_read_prev          | 0      |
| Handler_read_rnd           | 0      |
| Handler_read_rnd_deleted   | 0      |
| Handler_read_rnd_next      | 168    |
| Handler_rollback           | 0      |
| Handler_savepoint          | 0      |
| Handler_savepoint_rollback | 0      |
| Handler_tmp_update         | 0      |
| Handler_tmp_write          | 166    |
| Handler_update             | 0      |
| Handler_write              | 0      |
+----------------------------+--------+
25 rows in set (0.00 sec)

With ONLY_FULL_GROUP_BY

mysql:wikiadmin@db1083 [enwiki]> SET SESSION sql_mode = 'TRADITIONAL,ONLY_FULL_GROUP_BY';
Query OK, 0 rows affected (0.00 sec)

mysql:wikiadmin@db1083 [enwiki]> explain SELECT page_namespace, page_title, page_id, page_is_redirect FROM page WHERE page_namespace=0 AND page_title>='@' GROUP BY page_title LIMIT 11;
ERROR 1055 (42000): 'enwiki.page.page_namespace' isn't in GROUP BY
mysql:wikiadmin@db1083 [enwiki]> explain SELECT page_namespace, page_title, page_id, page_is_redirect FROM page WHERE page_namespace=0 AND page_title>='@' GROUP BY page_namespace, page_title, page_id, page_is_redirect LIMIT 11;
+------+-------------+-------+------+---------------+------------+---------+-------+----------+----------------------------------------------------+
| id   | select_type | table | type | possible_keys | key        | key_len | ref   | rows     | Extra                                              |
+------+-------------+-------+------+---------------+------------+---------+-------+----------+----------------------------------------------------+
|    1 | SIMPLE      | page  | ref  | name_title    | name_title | 4       | const | 20324891 | Using index condition; Using where; Using filesort |
+------+-------------+-------+------+---------------+------------+---------+-------+----------+----------------------------------------------------+
1 row in set (0.00 sec)

mysql:wikiadmin@db1083 [enwiki]> SELECT page_namespace, page_title, page_id, page_is_redirect FROM page WHERE page_namespace=0 AND page_title>='@' GROUP BY page_namespace, page_title, page_id, page_is_redirect LIMIT 11;
+----------------+----------------------+----------+------------------+
| page_namespace | page_title           | page_id  | page_is_redirect |
+----------------+----------------------+----------+------------------+
|              0 | @                    |  2214518 |                1 |
|              0 | @!                   | 37696354 |                1 |
|              0 | @$$                  | 21089863 |                1 |
|              0 | @&*!_Smilers         | 20573031 |                1 |
|              0 | @-Bristol            | 23905089 |                1 |
|              0 | @-symbol             | 25176688 |                1 |
|              0 | @440                 | 18159966 |                1 |
|              0 | @ANCAlerts           | 47685646 |                0 |
|              0 | @Andheri             | 42866631 |                0 |
|              0 | @Andheri_(2014_film) | 42914733 |                1 |
|              0 | @BarackObama         | 35944823 |                1 |
+----------------+----------------------+----------+------------------+
11 rows in set (32.67 sec)

mysql:wikiadmin@db1083 [enwiki]> SHOW STATUS LIKE 'Hand%';
+----------------------------+----------+
| Variable_name              | Value    |
+----------------------------+----------+
| Handler_commit             | 2        |
| Handler_delete             | 0        |
| Handler_discover           | 0        |
| Handler_external_lock      | 0        |
| Handler_icp_attempts       | 12637141 |
| Handler_icp_match          | 12139612 |
| Handler_mrr_init           | 0        |
| Handler_mrr_key_refills    | 0        |
| Handler_mrr_rowid_refills  | 0        |
| Handler_prepare            | 0        |
| Handler_read_first         | 0        |
| Handler_read_key           | 1        |
| Handler_read_last          | 0        |
| Handler_read_next          | 12139611 |
| Handler_read_prev          | 0        |
| Handler_read_rnd           | 0        |
| Handler_read_rnd_deleted   | 0        |
| Handler_read_rnd_next      | 168      |
| Handler_rollback           | 1        |
| Handler_savepoint          | 0        |
| Handler_savepoint_rollback | 0        |
| Handler_tmp_update         | 0        |
| Handler_tmp_write          | 166      |
| Handler_update             | 0        |
| Handler_write              | 0        |
+----------------------------+----------+
25 rows in set (0.00 sec)

That was a silly toy example and it still took a lot longer to return the 11 rows. The optimizer seems to fail in the same way if the GROUP BY contains any fields that aren't part of the index being used for grouping (or that are but are constant in the WHERE clause).

The particularly fun part about this example is that "WHERE page_namespace=0 GROUP BY page_title" already uniquely specifies a result row since name_title is a unique index.

I suppose we could always cheat...

mysql:wikiadmin@db1083 [enwiki]> SELECT 0 AS page_namespace, page_title, MAX(page_id) AS page_id, MAX(page_is_redirect) AS page_is_redirect FROM page WHERE page_namespace=0 AND page_title>='@' GROUP BY page_title LIMIT 11;
+----------------+----------------------+----------+------------------+
| page_namespace | page_title           | page_id  | page_is_redirect |
+----------------+----------------------+----------+------------------+
|              0 | @                    |  2214518 |                1 |
|              0 | @!                   | 37696354 |                1 |
|              0 | @$$                  | 21089863 |                1 |
|              0 | @&*!_Smilers         | 20573031 |                1 |
|              0 | @-Bristol            | 23905089 |                1 |
|              0 | @-symbol             | 25176688 |                1 |
|              0 | @440                 | 18159966 |                1 |
|              0 | @ANCAlerts           | 47685646 |                0 |
|              0 | @Andheri             | 42866631 |                0 |
|              0 | @Andheri_(2014_film) | 42914733 |                1 |
|              0 | @BarackObama         | 35944823 |                1 |
+----------------+----------------------+----------+------------------+
11 rows in set (0.09 sec)

This was fixed on 5.7: http://mysqlserverteam.com/mysql-5-7-only_full_group_by-improved-recognizing-functional-dependencies-enabled-by-default/ which given the other large issue we have with the optimizer we should seriously consider (I would have to check MariaDB 10.1).

My rationale is that 5.7, for external users, has this mode enabled by default, and we should be compatible with it. Enforcing it would be a second thought. But given the past experiences, I think it would fix more issues than it break things.

Let's give a chance to beta, which should be stricter than production, and not the other way round!

Platonides subscribed.Jun 29 2016, 9:23 PM

I have myself have no idea how to enable strict mode / which part of puppet config files have to be tweaked. The beta cluster database are also still running on Precise instance and MariaDB 5.5 , we might want to migrate them to migrate them to Jessie and MariaDB 5.10 first (that is T138778)

This is not blocked by that- it only needs to be enabled on config (see my comment on the child ticket).

TerraCodes subscribed.Jul 6 2016, 5:27 PM

hashar closed subtask T119370: Send deployment-db1 deployment-db2 syslog to beta cluster logstash as Resolved.Jul 14 2016, 12:12 PM

greg moved this task from Next: Feature to Backlog on the Beta-Cluster-Infrastructure board.Aug 5 2016, 8:56 PM

Nikerabbit added a subtask: T124628: LiquidThreads does not truncate comments: Data too long for column 'th_change_comment'.Aug 24 2016, 11:24 AM

Nikerabbit closed subtask T124628: LiquidThreads does not truncate comments: Data too long for column 'th_change_comment' as Resolved.Aug 25 2016, 1:13 PM

AndyRussG added a subtask: T145591: CentralNotice: Support MariaDB Strict Mode.Sep 13 2016, 10:42 PM

• MZMcBride subscribed.Sep 13 2016, 11:24 PM

Tgr mentioned this in T147537: Database::select with the condition [ 'somecolumn' => false ] will match unexpectedly on (almost) any string value in MySQL non-strict mode.Oct 6 2016, 1:10 AM

Nikerabbit mentioned this in T147852: MW unable to bypass MySQL strict mode by setting $wgSQLMode to blank.Oct 11 2016, 2:43 PM

Huji added a subtask: T147875: SecurePoll should comply with strict mode.Oct 11 2016, 6:15 PM

• RobLa-WMF mentioned this in T147875: SecurePoll should comply with strict mode.Oct 11 2016, 7:25 PM

Thanks @Huji for noting the SecurePoll strict mode problems (T147875).

I'll note this task still seems to be unassigned. @hashar, is the Beta cluster running in strict mode?

The beta cluster databases have been migrated to Jessie / MariaDB 5.10 T138778 and their config file is https://github.com/wikimedia/operations-puppet/blob/d3a05afd154/templates/mariadb/beta.my.cnf.erb

On beta I would guess it is about setting $wgSQLMode via operations/mediawiki-config , maybe that already has been done. For CI the task is T119371.

I am lurking on this task but reasonably have zero free time to lead the effort.

jcrespo mentioned this in T146444: Improve mediawiki data redaction.Oct 18 2016, 7:23 AM

Krinkle closed subtask T117854: Missing updater for rc_ip field: RecentChange::save: 1406 Data too long for column 'rc_ip' as Resolved.Oct 26 2016, 9:45 PM

Catrope created subtask T149819: Add primary keys to remaining Flow tables.Nov 2 2016, 5:22 PM

jcrespo added a project: Epic.Nov 7 2016, 4:03 PM

Ejegg closed subtask T145591: CentralNotice: Support MariaDB Strict Mode as Resolved.Nov 23 2016, 11:59 PM

jcrespo mentioned this in T153899: Gerrit: Convert gerrit's db caractor encoding from utf8 to utf8mb4 to prevent truncation of astral characters.Dec 22 2016, 9:11 AM

• Marostegui closed subtask T149819: Add primary keys to remaining Flow tables as Resolved.Jan 23 2017, 3:48 PM

jcrespo mentioned this in T162050: Implement GTID-MySQL support for mediawiki.Apr 3 2017, 3:07 PM

Krinkle subscribed.Apr 18 2017, 6:25 AM

• Phabricator_maintenance removed a subscriber: yuvipanda.Jun 7 2017, 6:48 PM

jcrespo mentioned this in T161232: Bump MediaWiki's minimum supported MySQL Version to 5.5.8.Jun 30 2017, 12:38 PM

daniel mentioned this in T171295: Fatal error: Argument 4 passed to WikibaseQuality\ConstraintReport\Constraint::__construct() must be array.Jul 21 2017, 4:49 PM

• Marostegui mentioned this in T150949: Set barracuda InnoDB file format as the default configuration everywhere.Dec 1 2017, 10:32 AM

Krinkle unsubscribed.Dec 2 2017, 12:57 AM

jcrespo updated the task description. (Show Details)Apr 27 2018, 9:04 AM

Nikerabbit added a subtask: T193246: JobQueueDB::doBatchPush fails with data too long for job_params when purging a template used on a few million pages.Apr 27 2018, 3:24 PM

https://gerrit.wikimedia.org/r/#/c/429386/ would enable sql_mode = TRADITIONAL via includes/DevelopmentSettings.php which is loaded by CI. Tracked by sub task T119371.

hashar updated the task description. (Show Details)Apr 27 2018, 8:37 PM

Krinkle moved this task from Untriaged to Rdbms library on the MediaWiki-libs-Rdbms board.Jul 28 2018, 11:44 PM

Nikerabbit added a subtask: T199323: Checkuser does not truncate data (cuc_comment, cuc_agent, cuc_actiontext) and that causes exceptions with strict mode.Aug 1 2018, 3:06 PM

• Marostegui updated the task description. (Show Details)Jan 9 2019, 7:17 PM

• Marostegui moved this task from Triage to Backlog on the DBA board.Jan 23 2019, 6:39 AM

Krinkle mentioned this in T220056: MediaWiki database policy and/or guidelines (2019).Apr 3 2019, 11:54 PM

Umherirrender added a subtask: T220274: sql files of extension CreditsSource failing on unit tests due to default on text column.Apr 6 2019, 7:31 PM

Umherirrender closed subtask T220274: sql files of extension CreditsSource failing on unit tests due to default on text column as Resolved.Apr 11 2019, 3:41 PM

Lucas_Werkmeister_WMDE mentioned this in T224523: Wire up DatabasePropertyTermStore in WikibaseRepo.May 29 2019, 4:53 PM

Lucas_Werkmeister_WMDE mentioned this in T225805: DatabaseTermIdsAcquirer fails on terms longer than 255 bytes.Jun 14 2019, 12:34 PM

Krinkle moved this task from Rdbms library to Rdbms: MySQL support on the MediaWiki-libs-Rdbms board.Jul 23 2019, 5:39 PM

Restricted Application added a project: Platform Engineering. · View Herald TranscriptJul 23 2019, 5:39 PM

Krinkle removed projects: Platform Engineering, OKR-Work.Jul 23 2019, 5:39 PM

jcrespo mentioned this in T240405: WikiPage::updateCategoryCounts causing replication lag due to long-running writes on commonswiki.Dec 11 2019, 3:15 PM

Krinkle closed subtask T119371: Enable MariaDB/MySQL strict mode for MW during development and Jenkins jobs as Resolved.Mar 20 2020, 5:48 PM

Reedy mentioned this in T260633: BotPasswords doesn't validate length of resultant bp_grants JSON.Aug 18 2020, 12:45 AM

Reedy mentioned this in T260631: BotPasswords doesn't validate length of resultant bp_restrictions JSON.

Reedy closed subtask T199323: Checkuser does not truncate data (cuc_comment, cuc_agent, cuc_actiontext) and that causes exceptions with strict mode as Resolved.Aug 18 2020, 12:53 AM

Aklapper removed subscribers: Anomie, • RobLa-WMF.Oct 16 2020, 5:02 PM

Ammarpad mentioned this in T270032: Find a solution for cl_timestamp.Dec 31 2020, 12:59 PM

Krinkle added a project: Sustainability (Incident Followup).Mar 8 2021, 9:19 PM

Reedy mentioned this in T277379: OAuth doesn't validate length of oarc_grants and oarc_oauth2_allowed_grants JSON.Mar 13 2021, 5:06 PM

Reedy mentioned this in T277388: OAuth doesn't validate length of oarc_version (CVE-2021-31555).Mar 13 2021, 6:07 PM

LSobanski subscribed.Mar 25 2021, 11:06 AM

For CI that got done by setting TRADITIONAL in DevelopmentSettings.php https://gerrit.wikimedia.org/r/c/mediawiki/core/+/429386/4/includes/DevelopmentSettings.php

That was the purpose of T119371

Umherirrender added a subtask: T294775: Filter for multiple tags on Special:RecentChanges fails with 'recentchanges.rc_namespace' isn't in GROUP BY for sql mode ONLY_FULL_GROUP_BY.Nov 1 2021, 3:54 PM

Restricted Application added a project: Performance-Team. · View Herald TranscriptNov 1 2021, 3:54 PM

hashar unsubscribed.Nov 8 2021, 3:05 PM

• dpifke edited projects, added Performance-Team (Radar); removed Performance-Team.Nov 8 2021, 7:59 PM

• dpifke moved this task from Limbo to Watching on the Performance-Team (Radar) board.

The need from Wikimedia-Rdbms was to add the option and any additional support. I believe that part is done. (Ideally that would've been a subtask, but alas, better next time.)

Umherirrender added a subtask: T299826: action=query&list=allpages&apfilterlanglinks=withlanglinks fails with 'page.page_namespace' isn't in GROUP BY for sql mode ONLY_FULL_GROUP_BY.Jan 22 2022, 12:09 PM

taavi added a subtask: T304759: GlobalUsersPager should work with ONLY_FULL_GROUP_BY SQL mode.Mar 26 2022, 9:29 AM

taavi removed a subtask: T304759: GlobalUsersPager should work with ONLY_FULL_GROUP_BY SQL mode.Mar 26 2022, 1:42 PM

taavi added a subtask: T304762: Add SpecialPageFatalTest to @group Database.

Umherirrender added a subtask: T307613: Validate length of user email on Special:ChangeEmail/Special:CreateAccount to avoid database error "Data too long for column 'user_email'" on strict mode.May 4 2022, 6:40 PM

Diesel_kapasule changed the status of subtask T307613: Validate length of user email on Special:ChangeEmail/Special:CreateAccount to avoid database error "Data too long for column 'user_email'" on strict mode from Open to In Progress.May 13 2022, 10:00 AM

Diesel_kapasule closed subtask T307613: Validate length of user email on Special:ChangeEmail/Special:CreateAccount to avoid database error "Data too long for column 'user_email'" on strict mode as Resolved.Jul 1 2022, 10:18 AM

Reedy mentioned this in T313491: 'cr_status' isn't in GROUP BY.Jul 21 2022, 12:25 PM

Daimona subscribed.Sep 3 2022, 1:35 PM

I fail to see how this task is related to incident followup, or sustainability. So removing the tag. Adding the sprint week tag as I was triaging this task for the SRE sprint week.

Additionally, given the low activity:

Set as stalled
Lower priority.

Additionally: strict mode is on by default since mariadb 10.2, this has nothing to do with production usage at this point. Maybe another task should be opened?

In T108255#8709276, @Joe wrote:

I fail to see how this task is related to incident followup, or sustainability. So removing the tag. Adding the sprint week tag as I was triaging this task for the SRE sprint week.

I want to remember this was detected as a mitigation to a MW incident/bug in which, if the flag was enabled on testing, the issue would have been caught earlier. But I don't remember the details.

In T108255#8709284, @Joe wrote:

Additionally: strict mode is on by default since mariadb 10.2, this has nothing to do with production usage at this point. Maybe another task should be opened?

I believe ONLY_FULL_GROUP_BY is not enabled, which was part of the above scope. Strict is technically only STRICT_TRANS_TABLES.

Reedy added a subtask: T322080: Error 1055: 'wikidb.mw_flow_tree_revision.tree_orig_user_ip' isn't in GROUP BY.Jun 26 2023, 4:51 PM

Addshore unsubscribed.Jun 27 2023, 12:33 PM

LSobanski unsubscribed.Jul 14 2023, 8:33 AM

Krinkle removed a project: Performance-Team (Radar).Aug 7 2023, 1:46 AM

Krinkle removed subscribers: • MZMcBride, gerritbot.

Pppery closed subtask T304762: Add SpecialPageFatalTest to @group Database as Resolved.Dec 20 2023, 7:47 PM

Reedy added a subtask: T355530: Cannot delete files with non-standard extensions on MySQL in a strict mode.Jan 25 2024, 1:16 PM

TK-999 closed subtask T355530: Cannot delete files with non-standard extensions on MySQL in a strict mode as Resolved.Feb 6 2024, 3:51 PM

jcrespo mentioned this in T359176: Long-titled archived files can get its path metadata truncated due to not having enough storage space, leading to orphan, non accesible files (was: Two files on commons have invalid UTF-8 characters in path metadata).Mar 5 2024, 3:14 PM