Change Details

We're planning to finally drop the archive.ar_text and archive.ar_flags flags columns. In preparation for that, though, we need to make sure that things won't break when MediaWiki stops writing to these fields before we can do the future schema change to drop them. Unfortunately MySQL doesn't allow BLOB columns to have a default value, so we'll have to do something slower. The linked ALTER to make the columns nullable is the best I could come up with, but if you know of (and want to use) a trigger or something that will prevent "Field 'ar_text' doesn't have a default value" errors when these columns aren't supplied in an INSERT that would be fine with me. From the checklist at https://wikitech.wikimedia.org/wiki/Schema_changes: # **ALTERs to run:** https://gerrit.wikimedia.org/r/#/c/393929/7/maintenance/archives/patch-nullable-ar_text.sql # **Where to run those changes:** all.dblist # **When to run those changes:** No time constraint. # **If the schema change is backwards compatible:** Yes. # **If the schema change has been tested already on some of the test/beta wikis:** Not yet. # **if the data should be made available on the labs replicas and/or dumps:** N/A, there is no new data in this change * Progress: ** s1 *** [x] codfw *** [] eqiad progress: T185128#4104574 ** s2 *** [x] codfw *** [x] eqiad progress: T185128#3985091 ** s3 *** [x] codfw *** [x] eqiad progress: T185128#4096781 ** s4 *** [x] codfw *** [x] eqiad progress: T185128#4034296 ** s5 *** [x] codfw progress: T185128#3962758 *** [x] eqiad ** s6 *** [x] codfw *** [x] eqiad progress: T185128#3977743 ** s7 *** [x] codfw *** [x] eqiad progress: T185128#4023552 ** s8 *** [] codfw *** [] eqiad ** [x] labswiki (m5) ** [x] labtestwiki (labtestweb2001)

We're planning to finally drop the archive.ar_text and archive.ar_flags flags columns. In preparation for that, though, we need to make sure that things won't break when MediaWiki stops writing to these fields before we can do the future schema change to drop them. Unfortunately MySQL doesn't allow BLOB columns to have a default value, so we'll have to do something slower. The linked ALTER to make the columns nullable is the best I could come up with, but if you know of (and want to use) a trigger or something that will prevent "Field 'ar_text' doesn't have a default value" errors when these columns aren't supplied in an INSERT that would be fine with me. From the checklist at https://wikitech.wikimedia.org/wiki/Schema_changes: # **ALTERs to run:** https://gerrit.wikimedia.org/r/#/c/393929/7/maintenance/archives/patch-nullable-ar_text.sql # **Where to run those changes:** all.dblist # **When to run those changes:** No time constraint. # **If the schema change is backwards compatible:** Yes. # **If the schema change has been tested already on some of the test/beta wikis:** Not yet. # **if the data should be made available on the labs replicas and/or dumps:** N/A, there is no new data in this change * Progress: ** s1 *** [x] codfw *** [x] eqiad progress: T185128#4104574 ** s2 *** [x] codfw *** [x] eqiad progress: T185128#3985091 ** s3 *** [x] codfw *** [x] eqiad progress: T185128#4096781 ** s4 *** [x] codfw *** [x] eqiad progress: T185128#4034296 ** s5 *** [x] codfw progress: T185128#3962758 *** [x] eqiad ** s6 *** [x] codfw *** [x] eqiad progress: T185128#3977743 ** s7 *** [x] codfw *** [x] eqiad progress: T185128#4023552 ** s8 *** [] codfw *** [] eqiad ** [x] labswiki (m5) ** [x] labtestwiki (labtestweb2001)

We're planning to finally drop the archive.ar_text and archive.ar_flags flags columns. In preparation for that, though, we need to make sure that things won't break when MediaWiki stops writing to these fields before we can do the future schema change to drop them. Unfortunately MySQL doesn't allow BLOB columns to have a default value, so we'll have to do something slower. The linked ALTER to make the columns nullable is the best I could come up with, but if you know of (and want to use) a trigger or something that will prevent "Field 'ar_text' doesn't have a default value" errors when these columns aren't supplied in an INSERT that would be fine with me. From the checklist at https://wikitech.wikimedia.org/wiki/Schema_changes: # **ALTERs to run:** https://gerrit.wikimedia.org/r/#/c/393929/7/maintenance/archives/patch-nullable-ar_text.sql # **Where to run those changes:** all.dblist # **When to run those changes:** No time constraint. # **If the schema change is backwards compatible:** Yes. # **If the schema change has been tested already on some of the test/beta wikis:** Not yet. # **if the data should be made available on the labs replicas and/or dumps:** N/A, there is no new data in this change * Progress: ** s1 *** [x] codfw *** [x] eqiad progress: T185128#4104574 ** s2 *** [x] codfw *** [x] eqiad progress: T185128#3985091 ** s3 *** [x] codfw *** [x] eqiad progress: T185128#4096781 ** s4 *** [x] codfw *** [x] eqiad progress: T185128#4034296 ** s5 *** [x] codfw progress: T185128#3962758 *** [x] eqiad ** s6 *** [x] codfw *** [x] eqiad progress: T185128#3977743 ** s7 *** [x] codfw *** [x] eqiad progress: T185128#4023552 ** s8 *** [] codfw *** [] eqiad ** [x] labswiki (m5) ** [x] labtestwiki (labtestweb2001)