Page MenuHomePhabricator

cu_changes auto_increment will hit its max value in wikidatawiki soon
Closed, ResolvedPublic

Description

cu_changes auto_increment in Checkuser extension is signed, and already 68% done now, it'll hit the max value in a year or two. Making it unsigned will give us at least five more years (we did the same with rc_id (T62962: The primary key of recentchanges (rc_id) table should be unsigned)

Not tagging with DBA but subscribing them, feel free to unsubscribe.

Event Timeline

If you create a schema change patch "soon", we can try to proceed with this before or during the DC switch.

Our eternal DBA love isn't enough?!

Change 692630 had a related patch set uploaded (by Ladsgroup; author: Ladsgroup):

[mediawiki/extensions/CheckUser@master] Make cuc_id unsigned

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

Change 692651 had a related patch set uploaded (by Reedy; author: Ladsgroup):

[mediawiki/extensions/CheckUser@REL1_36] Make cuc_id unsigned

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

Change 692652 had a related patch set uploaded (by Reedy; author: Ladsgroup):

[mediawiki/extensions/CheckUser@REL1_35] Make cuc_id unsigned

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

Change 692651 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@REL1_36] Make cuc_id unsigned

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

Change 692652 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@REL1_35] Make cuc_id unsigned

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

Change 692630 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Make cuc_id unsigned

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

Reedy assigned this task to Ladsgroup.

Thank you!

Anything for our amazing DBAs <3