In T194125#9253587, @jcrespo wrote:

The truth is that the issue is not MediaWiki, but the historical artefact of 'utf8' in MySQL (and MariaDB)...

Hi, @Firefishy - you are answering to a 4 year old, closed discussion, so you are likely to get very few responses. As a fellow OSMer, I would encourage you to file a new ticket with the problem you suffer or suffered and that way we can help you (through documentation or otherwise).

In T194125#5331955, @jcrespo wrote:

Because T135969 has spilled here, I can see the annoyance with someone using a "bad" encoding, I will try to be a bit conciliatory, however, I don't see any way to solve that, other than documenting (maybe it was done already):

The only encoding supported for mysql is binary, others may work on limited cases, but are unsupported. To migrate to binary run: ALTER TABLE table CONVERT TO CHARACTER SET binary; on all your tables".

If your complain is that lack of documentation, that would be a fair one. If it is that you want to allow full plane UTF-8 characters on utf8(mb3) mysql configuration, that is literally impossible. People should migrate to the supported charset(s). If the developers don't want to support multiple encodings (and I can see why- index length issues, meaning changes that would hide bugs) that is up to them. The good news is that because open source, everyone can become a developer and support additional features! I highly encourage you to do that.

Change 930768 abandoned by Reedy:

[mediawiki/extensions/SecureLinkFixer@REL1_38] Lazy load large domains.php file only when it's really needed

Reason:

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

Change 930767 merged by jenkins-bot:

[mediawiki/extensions/SecureLinkFixer@REL1_39] Lazy load large domains.php file only when it's really needed

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

Change 930768 restored by Reedy:

[mediawiki/extensions/SecureLinkFixer@REL1_38] Lazy load large domains.php file only when it's really needed

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

Change 930766 merged by jenkins-bot:

[mediawiki/extensions/SecureLinkFixer@REL1_40] Lazy load large domains.php file only when it's really needed

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

Change 930768 abandoned by Reedy:

[mediawiki/extensions/SecureLinkFixer@REL1_38] Lazy load large domains.php file only when it's really needed

Reason:

Meh, EOL this month

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

Change 930768 had a related patch set uploaded (by Reedy; author: Thiemo Kreuz (WMDE)):

[mediawiki/extensions/SecureLinkFixer@REL1_38] Lazy load large domains.php file only when it's really needed

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

Change 930767 had a related patch set uploaded (by Reedy; author: Thiemo Kreuz (WMDE)):

[mediawiki/extensions/SecureLinkFixer@REL1_39] Lazy load large domains.php file only when it's really needed

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

Change 930766 had a related patch set uploaded (by Reedy; author: Thiemo Kreuz (WMDE)):

[mediawiki/extensions/SecureLinkFixer@REL1_40] Lazy load large domains.php file only when it's really needed

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

Change 929766 merged by jenkins-bot:

[mediawiki/extensions/SecureLinkFixer@master] Lazy load large domains.php file only when it's really needed

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

Change 929766 had a related patch set uploaded (by Thiemo Kreuz (WMDE); author: Thiemo Kreuz (WMDE)):

[mediawiki/extensions/SecureLinkFixer@master] Lazy load large domains.php file only when it's really needed

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

Change 349479 abandoned by Umherirrender:

[mediawiki/core@master] ApiQueryContributors: Improve query behavior

Reason:

Old outdated patch set

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

https://gerrit.wikimedia.org/r/c/mediawiki/core/+/634409/6 has refactored and restored the test. If this issue returns, we can just mark it as @group Broken again.

Oops, still seen.

Change 571108 merged by jenkins-bot:
[mediawiki/core@REL1_31] rdbms: re-add DB domain sanity checks to LoadBalancer

Change 571108 had a related patch set uploaded (by saper; owner: Aaron Schulz):
[mediawiki/core@REL1_31] rdbms: re-add DB domain sanity checks to LoadBalancer

@WDoranWMF Is this a candidate for review in Clinic Duty?

Please feel free to reopen if the patch did not fix this.

We believe that this is covered by T191231. Please feel free to reopen or comment there if you believe there are aspects of this task that are not covered there.

The quick fix here would be to set user_touched to a timestamp for those three users, on the assumption that it's some old DB corruption that has been fixed at some point, then see if the problem reoccurs.

Change 536761 merged by jenkins-bot:
[mediawiki/core@master] clientpool: Use PHP constants in SquidPurgeClient

Updated trace:

MWException from line 3965 of /srv/mediawiki/workdir/includes/user/User.php: CAS update failed on user_touched. The version of the user to be saved is older than the current version.
#0 /srv/mediawiki/workdir/includes/libs/rdbms/database/Database.php(3992): User->{closure}(Object(Wikimedia\Rdbms\DatabaseMysqli), 'User::saveSetti...')
#1 /srv/mediawiki/workdir/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->doAtomicSection('User::saveSetti...', Object(Closure))
#2 /srv/mediawiki/workdir/includes/libs/rdbms/database/DBConnRef.php(638): Wikimedia\Rdbms\DBConnRef->__call('doAtomicSection', Array)
#3 /srv/mediawiki/workdir/includes/user/User.php(3976): Wikimedia\Rdbms\DBConnRef->doAtomicSection('User::saveSetti...', Object(Closure))
#4 /srv/mediawiki/workdir/includes/user/User.php(795): User->saveSettings()
#5 /srv/mediawiki/workdir/maintenance/edit.php(63): User::newSystemUser('Maintenance scr...', Array)
#6 /srv/mediawiki/workdir/maintenance/doMaintenance.php(107): EditCLI->execute()
#7 /srv/mediawiki/workdir/maintenance/edit.php(132): require_once('/srv/mediawiki/...')
#8 {main}
[10e43c3b08575a3ee48f6310] [no req]   Wikimedia\Rdbms\DBTransactionStateError from line 1433 of /srv/mediawiki/workdir/includes/libs/rdbms/database/Database.php: Cannot execute query from Wikimedia\Rdbms\Database::ping while transaction status is ERROR
Backtrace:
#0 /srv/mediawiki/workdir/includes/libs/rdbms/database/Database.php(1159): Wikimedia\Rdbms\Database->assertQueryIsCurrentlyAllowed(string, string)
#1 /srv/mediawiki/workdir/includes/libs/rdbms/database/Database.php(4322): Wikimedia\Rdbms\Database->query(string, string, integer)
#2 /srv/mediawiki/workdir/includes/libs/rdbms/database/Database.php(703): Wikimedia\Rdbms\Database->ping(NULL)
#3 /srv/mediawiki/workdir/includes/libs/rdbms/database/Database.php(693): Wikimedia\Rdbms\Database->pingAndCalculateLastTrxApplyTime()
#4 /srv/mediawiki/workdir/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1640): Wikimedia\Rdbms\Database->pendingWriteQueryDuration(string)
#5 /srv/mediawiki/workdir/includes/libs/rdbms/loadbalancer/LoadBalancer.php(2144): Wikimedia\Rdbms\LoadBalancer->Wikimedia\Rdbms\{closure}(Wikimedia\Rdbms\DatabaseMysqli)
#6 /srv/mediawiki/workdir/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1656): Wikimedia\Rdbms\LoadBalancer->forEachOpenMasterConnection(Closure)
#7 /srv/mediawiki/workdir/includes/libs/rdbms/lbfactory/LBFactory.php(208): Wikimedia\Rdbms\LoadBalancer->approveMasterChanges(array, string, integer)
#8 /srv/mediawiki/workdir/includes/libs/rdbms/lbfactory/LBFactorySimple.php(125): Wikimedia\Rdbms\LBFactory->Wikimedia\Rdbms\{closure}(Wikimedia\Rdbms\LoadBalancer, string, array)
#9 /srv/mediawiki/workdir/includes/libs/rdbms/lbfactory/LBFactory.php(210): Wikimedia\Rdbms\LBFactorySimple->forEachLB(Closure, array)
#10 /srv/mediawiki/workdir/includes/libs/rdbms/lbfactory/LBFactory.php(269): Wikimedia\Rdbms\LBFactory->forEachLBCallMethod(string, array)
#11 /srv/mediawiki/workdir/maintenance/doMaintenance.php(132): Wikimedia\Rdbms\LBFactory->commitMasterChanges(string)
#12 /srv/mediawiki/workdir/maintenance/edit.php(132): require_once(string)
#13 {main}