[Wikidata-bugs] [Maniphest] T237102: Increase the size of wbt_text_in_lang.wbxl_language

2020-10-07 Thread WMDE-leszek 
WMDE-leszek closed this task as "Resolved".
WMDE-leszek moved this task from Test (Verification) to Done on the 
Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board.
WMDE-leszek added a comment.


  much obliged

TASK DETAIL
  https://phabricator.wikimedia.org/T237102

WORKBOARD
  https://phabricator.wikimedia.org/project/board/3539/

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup, WMDE-leszek
Cc: WMDE-leszek, Marostegui, Amire80, Aklapper, Addshore, alaa_wmde, Ladsgroup, 
Hazizibinmahdi, Akuckartz, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Jonas, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T237102: Increase the size of wbt_text_in_lang.wbxl_language

2020-10-07 Thread Ladsgroup 
Ladsgroup added a comment.


  Sure:
  
wikiadmin@10.192.32.183(testwikidatawiki)> desc wbt_text_in_lang;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra  |
+---+--+--+-+-++
| wbxl_id   | int(10) unsigned | NO   | PRI | NULL| auto_increment |
| wbxl_language | varbinary(20)| NO   | MUL | NULL||
| wbxl_text_id  | int(10) unsigned | NO   | MUL | NULL||
+---+--+--+-+-++
3 rows in set (0.00 sec)

TASK DETAIL
  https://phabricator.wikimedia.org/T237102

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup
Cc: WMDE-leszek, Marostegui, Amire80, Aklapper, Addshore, alaa_wmde, Ladsgroup, 
Hazizibinmahdi, Akuckartz, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Jonas, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T237102: Increase the size of wbt_text_in_lang.wbxl_language

2020-10-06 Thread WMDE-leszek 
WMDE-leszek added a comment.


  thanks @Ladsgroup. I could have asked more clearly. I was trying to ask if 
the structure of the table on wikidata/test wikidata can be looked at only by 
dialing in to production servers, or are those tables maybe replicated 
somewhere where mortals like me could look at them. I should have remembered 
they are not replicated, and your answer seems to confirm this.
  Could you please run the `describe` on test wikidata's database for me as 
well? This would be the last step to confirm this task is done.

TASK DETAIL
  https://phabricator.wikimedia.org/T237102

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup, WMDE-leszek
Cc: WMDE-leszek, Marostegui, Amire80, Aklapper, Addshore, alaa_wmde, Ladsgroup, 
Hazizibinmahdi, Akuckartz, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Jonas, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T237102: Increase the size of wbt_text_in_lang.wbxl_language

2020-10-06 Thread Ladsgroup 
Ladsgroup added a comment.


  In T237102#6521036 , 
@WMDE-leszek wrote:
  
  > @Addshore @Ladsgroup how would I confirm this is done?
  
  on local instance:
  
MariaDB [(none)]> use repo;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [repo]> desc wbt_text_in_lang;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra  |
+---+--+--+-+-++
| wbxl_id   | int(10) unsigned | NO   | PRI | NULL| auto_increment |
| wbxl_language | varbinary(20)| NO   | MUL | NULL||
| wbxl_text_id  | int(10) unsigned | NO   | MUL | NULL||
+---+--+--+-+-++
3 rows in set (0.003 sec)
  
  the wbxl_language should varbinary 20 and not 10
  
  On production:
  
amsa@amsa-Latitude-7480:~$ ssh mwmaint2001.codfw.wmnet

ladsgroup@mwmaint2001:~$ sql wikidatawiki


wikiadmin@10.192.48.86(wikidatawiki)> desc wbt_text_in_lang;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra  |
+---+--+--+-+-++
| wbxl_id   | int(10) unsigned | NO   | PRI | NULL| auto_increment |
| wbxl_language | varbinary(20)| NO   | MUL | NULL||
| wbxl_text_id  | int(10) unsigned | NO   | MUL | NULL||
+---+--+--+-+-++
3 rows in set (0.00 sec)
  
  Preferably double checking this on testwikidatawiki as well

TASK DETAIL
  https://phabricator.wikimedia.org/T237102

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup
Cc: WMDE-leszek, Marostegui, Amire80, Aklapper, Addshore, alaa_wmde, Ladsgroup, 
Hazizibinmahdi, Akuckartz, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Jonas, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T237102: Increase the size of wbt_text_in_lang.wbxl_language

2020-10-06 Thread WMDE-leszek 
WMDE-leszek added a comment.


  @Addshore @Ladsgroup how would I confirm this is done?

TASK DETAIL
  https://phabricator.wikimedia.org/T237102

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup, WMDE-leszek
Cc: WMDE-leszek, Marostegui, Amire80, Aklapper, Addshore, alaa_wmde, Ladsgroup, 
Hazizibinmahdi, Akuckartz, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Jonas, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T237102: Increase the size of wbt_text_in_lang.wbxl_language

2020-09-03 Thread Marostegui 
Marostegui changed the task status from "Stalled" to "Open".
Marostegui added a comment.


  The master was altered finally, so this is unblocked

TASK DETAIL
  https://phabricator.wikimedia.org/T237102

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup, Marostegui
Cc: Marostegui, Amire80, Aklapper, Addshore, alaa_wmde, Ladsgroup, 
Hazizibinmahdi, Akuckartz, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Jonas, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T237102: Increase the size of wbt_text_in_lang.wbxl_language

2020-09-03 Thread Marostegui 
Marostegui closed subtask T237120: Schema change on production for increase the 
size of wbt_text_in_lang.wbxl_language as Resolved.

TASK DETAIL
  https://phabricator.wikimedia.org/T237102

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup, Marostegui
Cc: Amire80, Aklapper, Addshore, alaa_wmde, Ladsgroup, Hazizibinmahdi, 
Akuckartz, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Jonas, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T237102: Increase the size of wbt_text_in_lang.wbxl_language

2020-09-02 Thread Marostegui 
Marostegui changed the status of subtask T237120: Schema change on production 
for increase the size of wbt_text_in_lang.wbxl_language from 
Stalled to Open.

TASK DETAIL
  https://phabricator.wikimedia.org/T237102

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup, Marostegui
Cc: Amire80, Aklapper, Addshore, alaa_wmde, Ladsgroup, Hazizibinmahdi, 
Akuckartz, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Jonas, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs