Sorry for cross-posting!
Reminder: Technical Advice IRC meeting again **tomorrow 3-4 pm UTC** on
#wikimedia-tech.
The Technical Advice IRC meeting is open for all volunteer developers,
topics and questions. This can be anything from "how to get started" over
"who would be the best contact for X" to specific questions on your project.
If you know already what you would like to discuss or ask, please add your
topic to the next meeting: https://www.mediawiki.org/
wiki/Technical_Advice_IRC_Meeting
This meeting is an offer by WMDE’s tech team.
Hope to see you there!
Michi (for WMDE’s tech team)
--
Michael F. Schönitzer
Wikimedia Deutschland e.V. | Tempelhofer Ufer 23-24 | 10963 Berlin
Tel. (030) 219 158 26-0
http://wikimedia.de
Stellen Sie sich eine Welt vor, in der jeder Mensch an der Menge allen
Wissens frei teilhaben kann. Helfen Sie uns dabei!
http://spenden.wikimedia.de/
Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e.V.
Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter
der Nummer 23855 B. Als gemeinnützig anerkannt durch das Finanzamt für
Körperschaften I Berlin, Steuernummer 27/681/51985.
On Sun, Oct 8, 2017 at 8:22 AM, Fæ <faewik(a)gmail.com> wrote:
> On 8 October 2017 at 15:06, Nitin Gadia <nittyjee(a)gmail.com> wrote:
>> Why am I being sent emails? Where did this come from?
>
> See https://wikitech.wikimedia.org/wiki/User:BryanDavis/Rebranding_Cloud_Servic…
>
> The WMF marketing/rebranding exercise included renaming the email list
> you were subscribed to. It may be less confusing if the footer of the
> email list mentioned the previous name; probably for at least 12
> months.
Thanks for the suggestion Fæ. I've updated the mailman footer settings
to include "(formerly labs-l(a)lists.wikimedia.org)" and made the
displayed list name more descriptive. I have also made similar changes
for the cloud-announce(a)lists.wikimedia.org list.
Bryan
--
Bryan Davis Wikimedia Foundation <bd808(a)wikimedia.org>
[[m:User:BDavis_(WMF)]] Manager, Cloud Services Boise, ID USA
irc: bd808 v:415.839.6885 x6855
I deployed a new version of the jsub command at 2017-10-05T22:42Z. The
major change was porting the script from Python2 to Python3.
Unfortunately I did not test all code paths with the new script. When
invoked as `jstart` or `jsub -continuous ...` it would fail with an
error [0]:
Traceback (most recent call last):
File "/usr/bin/jstart", line 662, in <module>
main()
File "/usr/bin/jstart", line 654, in main
(out, err) = proc.communicate(qsub_stdin)
File "/usr/lib/python3.4/subprocess.py", line 960, in communicate
stdout, stderr = self._communicate(input, endtime, timeout)
File "/usr/lib/python3.4/subprocess.py", line 1602, in _communicate
input_view = memoryview(self._input)
TypeError: memoryview: str object does not have the buffer interface
At 2017-10-06T15:33Z I deployed a fix for this problem. `jstart` and
`jsub -continuous ...` are now working again. I apologize for the
interruption of service. I'm going to try and add an automated test
for this code path to help catch any similar errors in the future.
[0]: https://phabricator.wikimedia.org/T177614
Bryan
--
Bryan Davis Wikimedia Foundation <bd808(a)wikimedia.org>
[[m:User:BDavis_(WMF)]] Manager, Cloud Services Boise, ID USA
irc: bd808 v:415.839.6885 x6855
Hi,
Sometimes I get questions on how to control queries running for longer
than intended on the wikireplicas. Since MariaDB 10.1 (the version
used on tools and the new wikireplicas), one can run:
SET max_statement_time = 300; [0]
And all subsequent queries on the same connection will be killed if
the run longer than 5 minutes. For example:
mariadb[(none)]> SET max_statement_time = 10;
Query OK, 0 rows affected (0.00 sec)
mariadb[(none)]> SELECT sleep(20);
+-----------+
| sleep(20) |
+-----------+
| 1 |
+-----------+
1 row in set (10.00 sec)
It works on quarry, too! [1] But not on the old wikireplicas.
This is of course not required, but 1) it will win you karma, by
making your requests not run longer you intended (making resources
available for others), and 2) it can limit the execution on web-based
tools, as it is unlikely that a user will wait for longer than 1-5
minutes on a browser- an error will be a better feedback and a freezed
loading page.
Regards,
[0] <url:https://mariadb.com/kb/en/library/server-system-variables/#max_statemen…>
[1] <url:https://quarry.wmflabs.org/query/22003>
--
Jaime Crespo
<http://wikimedia.org>
A proposal is up in <https://phabricator.wikimedia.org/T177427> to
move the notification bots (icinga-wm, shinken-wm, wikibugs) out of
the #wikimedia-cloud Freenode IRC channel and into a channel primarily
intended for notifications/monitoring. The intent of this change would
be to make #wikimedia-cloud less noisy for support questions and
discussions between Cloud Services users.
Your feedback is welcome.
Bryan
--
Bryan Davis Wikimedia Foundation <bd808(a)wikimedia.org>
[[m:User:BDavis_(WMF)]] Manager, Cloud Services Boise, ID USA
irc: bd808 v:415.839.6885 x6855
In order to rebuild a server of questionable stability, I'm going to
move the following instances on Wednesday:
|+--------------------------+---------------------+--------+||
||| Name | Tenant ID | Status | ||
||+--------------------------+---------------------+--------+||
||| cindy | pluggableauth | ACTIVE | ||
||| deployment-kafka-jumbo-1 | deployment-prep | ACTIVE | ||
||| oidc-google | pluggableauth | ACTIVE | ||
||| proton-staging | reading-web-staging | ACTIVE | ||
||| search-jessie | search | ACTIVE | ||
||| smtp-test1 | project-smtp | ACTIVE | ||
||| suggestbot-prod | suggestbot | ACTIVE | ||
||| twlight-prod | twl | ACTIVE | ||
||| twlight-staging | twl | ACTIVE | ||||
||| wikibrain-embeddings-02 | wikibrain | ACTIVE | ||
||| wikikids | wmam | ACTIVE | ||
||| zim-proto | mobile | ACTIVE | ||
||+--------------------------+---------------------+--------+|
Migration will cause the affected instances to be offline for some time
(potentially more than an hour depending on the size of the instance)
and rebooted. If you need me work on your server at a particular time
of day, or need a stay of execution, please let me know. Otherwise I'll
start going down the list at the beginning of my workday on Wednesday,
around 14:00 UTC.
Sorry for the inconvenience!
-Andrew
_______________________________________________
Cloud-announce mailing list
Cloud-announce(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/cloud-announce
Sorry for cross-posting!
Reminder: Technical Advice IRC meeting again **today 3-4 pm UTC** on
#wikimedia-tech.
The Technical Advice IRC meeting is open for all volunteer developers,
topics and questions. This can be anything from "how to get started" over
"who would be the best contact for X" to specific questions on your project.
If you know already what you would like to discuss or ask, please add your
topic to the next meeting:
https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting
This meeting is an offer by WMDE’s tech team.
Hope to see you there!
Michi (for WMDE’s tech team)
--
Michael F. Schönitzer
Wikimedia Deutschland e.V. | Tempelhofer Ufer 23-24 | 10963 Berlin
Tel. (030) 219 158 26-0
http://wikimedia.de
Stellen Sie sich eine Welt vor, in der jeder Mensch an der Menge allen
Wissens frei teilhaben kann. Helfen Sie uns dabei!
http://spenden.wikimedia.de/
Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e.V.
Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter
der Nummer 23855 B. Als gemeinnützig anerkannt durch das Finanzamt für
Körperschaften I Berlin, Steuernummer 27/681/51985.
I’ve been exploring the enwiki database. I can find the page row for [[Iron]]
> MariaDB [enwiki_p]> select page_title from page where page_id = 14734;
> +------------+
> | page_title |
> +------------+
> | Iron |
> +------------+
It looks like it has the right number of revisions:
> MariaDB [enwiki_p]> select count(*) from revision where rev_page = 14734;
> +----------+
> | count(*) |
> +----------+
> | 5560 |
> +----------+
But, all of the rev_text_ids are 0
> MariaDB [enwiki_p]> select rev_text_id from revision where rev_page = 14734 and rev_text_id != 0;
> Empty set (0.02 sec)
The schema description <https://www.mediawiki.org/wiki/Manual:Revision_table> seems pretty straight-forward. What am I not understanding?