Stashbot added a comment.
Mentioned in SAL (#wikimedia-operations) [2017-10-30T09:08:42Z] Drop wb_entity_per_page page from s3 and s5 - T177601TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, Sta
Marostegui added a comment.
There have been no errors so I will be dropping this table on Monday (because I do not want to drop stuff on a Friday :-) )TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marosteg
Marostegui added a comment.
I have renamed this table on the following servers
s5: wikidatawiki: db1092
root@db1092[wikidatawiki]> set session sql_log_bin=0;
Query OK, 0 rows affected (0.00 sec)
root@db1092[wikidatawiki]> rename table wb_entity_per_page to T177601_wb_entity_per_page;
Query OK, 0
Stashbot added a comment.
Mentioned in SAL (#wikimedia-operations) [2017-10-23T08:09:17Z] Rename wb_entity_per_page table on s5 db1092 and s3 db1077 - T177601TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: M
Marostegui added a comment.
In T177601#3698866, @Ladsgroup wrote:
A backup would be great, all crazy things can happen. One thing that would be great to know is to see if it's being read / written at all, I know it can be tricky and if it's too much hassle, let's move forward with back up in hand
Ladsgroup added a comment.
@hoo, you are right but re-generating it might take some time.TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: Marostegui, jcrespo, daniel, Aklapper, hoo, gerritbot, Mag
Ladsgroup added a comment.
A backup would be great, all crazy things can happen. One thing that would be great to know is to see if it's being read / written at all, I know it can be tricky and if it's too much hassle, let's move forward with back up in hand just in case.TASK DETAILhttps://phabrica
hoo added a comment.
In T177601#3698864, @Marostegui wrote:
Does this need to be backuped or can it just be dropped?
Ideally I will rename it on a production slave and leave it like that for a few days before killing it.
If we really wanted/ needed to, we could easily re-generate the data from
Marostegui added a comment.
Does this need to be backuped or can it just be dropped?
Ideally I will rename it on a production slave and leave it like that for a few days before killing it.TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings
Marostegui added a comment.
In T177601#3690074, @Ladsgroup wrote:
By "It" I meant the dropping, I'm sorry for the confusion, will update the task description.
Clear now! Sorry for making you re-write it, but better be safe than sorry :)TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PR
Ladsgroup added a comment.
By "It" I meant the dropping, I'm sorry for the confusion, will update the task description.TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: Marostegui, jcrespo, daniel,
Marostegui added a comment.
In T177601#3689891, @Ladsgroup wrote:
@Marostegui : No, it's the other way around. It needs to be dropped in these two wikis only because it's a repo database and the table doesn't exist in client wikis.
Then the original task description is a bit confusing:
We want
Marostegui added a comment.
@Ladsgroup just to be clear, it needs to be dropped everywhere except from wikidatawiki (s5) and testwikidatawiki (s3)?TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc:
Ladsgroup added a comment.
Sure. Thanks!TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: daniel, Aklapper, hoo, gerritbot, Magnus, Ricordisamoa, matej_suchanek, Bamyers99, Tobi_WMDE_SW, Pasleim, P
Marostegui added a comment.
In T177601#3665510, @Ladsgroup wrote:
It's merged but not deployed, we should wait for a week if train doesn't get stuck (more if it does)
Sounds good - can you ping us once we are good to proceed?TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCESht
Ladsgroup added a comment.
It's merged but not deployed, we should wait for a week if train doesn't get stuck (more if it does)TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: daniel, Aklapper, ho
Ladsgroup added a comment.
This is something for the DBAs, this patch only does it for the beta cluster, I was thinking do you need .sql file or you can directly do "DROP TABLE foo" too?TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/p
Marostegui added a comment.
Hi @Ladsgroup - I am a bit confused with this ticket.
Is this something you will do? Or something the DBAs have to do (and hence the #blocked-on-schema-change )?TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/setting
gerritbot added a comment.
Change 382693 merged by jenkins-bot:
[mediawiki/extensions/Wikibase@master] Drop wb_entity_per_page table if it exists
https://gerrit.wikimedia.org/r/382693TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/pan
gerritbot added a comment.
Change 382693 had a related patch set uploaded (by Ladsgroup; owner: Amir Sarabadani):
[mediawiki/extensions/Wikibase@master] Drop wb_entity_per_page table if it exists
https://gerrit.wikimedia.org/r/382693TASK DETAILhttps://phabricator.wikimedia.org/T177601EMAIL PREFERE
20 matches
Mail list logo