Page MenuHomePhabricator

Merl (Merl)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Tuesday

  • Clear sailing ahead.

User Details

User Since
Oct 20 2014, 7:06 PM (496 w, 5 d)
Availability
Available
LDAP User
Merl
MediaWiki User
Unknown

Recent Activity

Jun 19 2016

Merl added a comment to T121279: Figure out a way to keep MerlBot running when the HTTP POST loophole is closed.

Hi, i have tried to read a lot of discussions to get back to the current state of discussion.
What i really don't understand is why i should not possible to set up a special sge execution host with ubuntu 14.04 and openjdk 8 as ppa.

Jun 19 2016, 7:21 PM · Cloud-Services, Toolforge

May 12 2016

Merl added a comment to T135006: tools.merlbot stopped working.

Hi, sorry i am inactive atm and will not be able so access my tools in the next weeks.

May 12 2016, 10:46 AM · Community-Tech-Tool-Labs, Patch-For-Review, User-bd808, Cloud-Services, Toolforge

Jan 14 2016

Merl added a comment to T70881: Provide resource for db access in grid.

Today dewiki has high replag since about 12 hours (>3hours replag).

Jan 14 2016, 1:20 AM · Cloud-Services, Toolforge

Dec 13 2015

Merl added a comment to T121094: Throttling linkwatcher tool user as it is consuming 100% CPU.

Because my bot (dbuser s51826) also runs queries on linkwatcher_linklog if have checked statistics of my script. Mainly to exclude a deadlock problem or table locks caused by my script.

Dec 13 2015, 2:57 PM · linkwatcher, Stewards-and-global-tools, Toolforge
Merl added a parent task for T121279: Figure out a way to keep MerlBot running when the HTTP POST loophole is closed: T69556: merl tools (tracking).
Dec 13 2015, 2:29 PM · Cloud-Services, Toolforge
Merl added a subtask for T69556: merl tools (tracking): T121279: Figure out a way to keep MerlBot running when the HTTP POST loophole is closed.
Dec 13 2015, 2:29 PM · Tracking-Neverending, Tools
Merl added a parent task for T121094: Throttling linkwatcher tool user as it is consuming 100% CPU: T69556: merl tools (tracking).
Dec 13 2015, 2:28 PM · linkwatcher, Stewards-and-global-tools, Toolforge
Merl added a subtask for T69556: merl tools (tracking): T121094: Throttling linkwatcher tool user as it is consuming 100% CPU.
Dec 13 2015, 2:28 PM · Tracking-Neverending, Tools

Dec 11 2015

Merl added a comment to T121279: Figure out a way to keep MerlBot running when the HTTP POST loophole is closed.

Btw: i am running funtoo/gentoo on my two year old laptop and emerging jdk8 with a clean compile cache uses about 6GB of ram, 7 GB temp space, but completes within 40 minutes and not 3.5 hours as mentioned in T121020#1870527

Dec 11 2015, 10:41 PM · Cloud-Services, Toolforge
Merl added a comment to T121279: Figure out a way to keep MerlBot running when the HTTP POST loophole is closed.

Are there any plans to support ubuntu 16.04 as sge execution nodes next year? If so the easiest solution would be to keep the ssl force exception for labs until this is available at tools.

Dec 11 2015, 10:35 PM · Cloud-Services, Toolforge

Dec 10 2015

Merl added a subtask for T105794: Insecure POST traffic: T121020: Update Java 7 to Java 8.
Dec 10 2015, 12:19 AM · User-notice-archive, MW-1.27-release (WMF-deploy-2016-02-02_(1.27.0-wmf.12)), MW-1.27-release-notes, SRE, Patch-For-Review, Traffic, HTTPS
Merl added a parent task for T121020: Update Java 7 to Java 8: T105794: Insecure POST traffic.
Dec 10 2015, 12:19 AM · Patch-For-Review, Cloud-Services, Toolforge
Merl added a comment to T121020: Update Java 7 to Java 8.

Two additional reasons:
First one is caused by wikimedia plan to change to ssl only, please read my comment at T105794#1574563. So I need Java 1.8 to keep my bot working.

Dec 10 2015, 12:18 AM · Patch-For-Review, Cloud-Services, Toolforge

Sep 10 2015

Merl added a comment to T108190: Split notifications into Alerts and Messages.

The new notification design looks horrible in modern skin with its grey rounded icon boxes. Also the boxes are too high to fit in the bBody navigation bar.

Sep 10 2015, 7:54 PM · User-notice-archive, WMF-deploy-2015-09-15_(1.26wmf23), WMF-deploy-2015-09-08_(1.26wmf22), OKR-Work, Patch-For-Review, Collaboration-Team-Archive-2015-2016, Notifications

Sep 1 2015

Merl added a comment to T110994: SGE queues all overloaded / jobs not submitting although load averages are low.
np_load_avg=1.810000 (= 0.060000 + 0.50 * 14.000000 with nproc=4) >= 1.75
= np_load_avg +  job_load_adjustments * [weight number of jobs started in the last 7,5 Minutes]

0,5 is job_load_adjustments shown in "qconf -ssconf"
14 is the sum of a new job number factor. If a new job is started is increased by 1. This value will decrease within 7.5 minutes (load_adjustment_decay_time) to 0 for each job. The sum of all these [0..1] values for jobs started in the last 7,5 Minutes is 14 in this case.

Sep 1 2015, 4:40 PM · Toolforge, Cloud-Services

Aug 26 2015

Merl added a comment to T105794: Insecure POST traffic.

I am a java expert. And i am using a libary which normally needs java 1.8. I rewrote some parts, so that i can use the libary with java 1.7 on labs.
Problem is that this library in this limited rewrite version does not know ssl protocol, but i have added a trigger which adds ssl support when getting a redirect answer from server.
This was quite simply the implement, but rewriting the whole code the have full ssl support with java 1.7 is imo too much unnecessary work.
The first http request of my bot is always a sitematrix request on meta and then a http siteinfo request on local wikis. While doing these first requests the bot changes to https. So when doing the login action later my bot is already using https.

Aug 26 2015, 8:44 AM · User-notice-archive, MW-1.27-release (WMF-deploy-2016-02-02_(1.27.0-wmf.12)), MW-1.27-release-notes, SRE, Patch-For-Review, Traffic, HTTPS

Jul 27 2015

Merl added a comment to T105794: Insecure POST traffic.

^ Added Merl (I'm guessing is the maintainer of MerlBot).

Jul 27 2015, 11:10 PM · User-notice-archive, MW-1.27-release (WMF-deploy-2016-02-02_(1.27.0-wmf.12)), MW-1.27-release-notes, SRE, Patch-For-Review, Traffic, HTTPS
Merl added a comment to T107081: create database view for azbwiki and add domain azbwiki.labsdb to nameserver.

But host file is still missing the update

$ date && mysql -hazbwiki.labsdb 
Mon Jul 27 20:33:27 UTC 2015 
ERROR 2005 (HY000): Unknown MySQL server host 'azbwiki.labsdb' (0)
Jul 27 2015, 8:35 PM · Cloud-Services, Cloud-VPS
Merl added a subtask for T107081: create database view for azbwiki and add domain azbwiki.labsdb to nameserver: T106305: Create Wikipedia South Azerbaijani.
Jul 27 2015, 8:28 PM · Cloud-Services, Cloud-VPS
Merl added a parent task for T106305: Create Wikipedia South Azerbaijani: T107081: create database view for azbwiki and add domain azbwiki.labsdb to nameserver.
Jul 27 2015, 8:28 PM · RelEng-Archive-FY201718-Q1, Wiki-Setup (Create), WMF-deploy-2015-07-14_(1.26wmf14), Wikimedia-Language-setup
Merl created T107081: create database view for azbwiki and add domain azbwiki.labsdb to nameserver.
Jul 27 2015, 8:27 PM · Cloud-Services, Cloud-VPS
Merl added a comment to T74316: Add Aliases Field to Special:NewItem.

@Ricordisamoa Thx. Feature is now already added to my bot. Using this new parameter value does not show any error on old version. It is only useless until core is merge into wmf live version.

Jul 27 2015, 2:44 PM · patch-welcome, Wikidata, MediaWiki-extensions-WikibaseRepository
Merl created T107004: meta_p.wiki is missing url value for wikipedia wikis and lang value is wrong.
Jul 27 2015, 6:13 AM · Cloud-Services, Cloud-VPS
Merl created T107002: action=sitematrix&smsiteprop=url|code is not showing url value for wikipedias since 1.26wmf15 .
Jul 27 2015, 5:37 AM · MediaWiki-Action-API

Jul 17 2015

Merl created T106151: write irc bot to report high replag of s{1,2,3}.labsdb on #wikimedia-labsdb.
Jul 17 2015, 3:43 PM · Technical-Tool-Request, Data-Services

Jul 5 2015

Merl created T104806: hideanons=1 on Special:recentchanges hides all wikidata changes including edits done by registered users on wikidata.
Jul 5 2015, 3:53 PM · MediaWiki-extensions-WikibaseClient, Wikidata

Jun 25 2015

Merl created T103863: do not add wiki info to meta_p.wiki if they do not exist on labs dbs.
Jun 25 2015, 4:13 PM · Cloud-VPS, Cloud-Services
Merl added a parent task for T96468: Create Wikipedia Goan Konkani: T103794: add domain alias gomwiki.labsdb and lrcwiki.labsdb for s3.labsdb.
Jun 25 2015, 7:17 AM · Wiki-Setup (Create), Roadmap, WMF-deploy-2015-06-09_(1.26wmf9), WMF-deploy-2015-05-27_(1.26wmf8), Notice, MW-1.26-release, WMF-deploy-2015-06-16_(1.26wmf10), Patch-For-Review, Wikimedia-Language-setup
Merl added subtasks for T103794: add domain alias gomwiki.labsdb and lrcwiki.labsdb for s3.labsdb: T96468: Create Wikipedia Goan Konkani, T102026: Create Wikipedia Northern Luri.
Jun 25 2015, 7:17 AM · Cloud-VPS, Cloud-Services
Merl added a parent task for T102026: Create Wikipedia Northern Luri: T103794: add domain alias gomwiki.labsdb and lrcwiki.labsdb for s3.labsdb.
Jun 25 2015, 7:17 AM · Wiki-Setup (Create), Wikidata, WMF-deploy-2015-06-16_(1.26wmf10), WMF-deploy-2015-05-27_(1.26wmf8), WMF-deploy-2015-06-09_(1.26wmf9), MW-1.26-release, Roadmap, Notice, Patch-For-Review, Wikimedia-Language-setup
Merl added a subtask for T69556: merl tools (tracking): T103794: add domain alias gomwiki.labsdb and lrcwiki.labsdb for s3.labsdb.
Jun 25 2015, 7:16 AM · Tracking-Neverending, Tools
Merl added a parent task for T103794: add domain alias gomwiki.labsdb and lrcwiki.labsdb for s3.labsdb: T69556: merl tools (tracking).
Jun 25 2015, 7:16 AM · Cloud-VPS, Cloud-Services
Merl created T103794: add domain alias gomwiki.labsdb and lrcwiki.labsdb for s3.labsdb.
Jun 25 2015, 7:15 AM · Cloud-VPS, Cloud-Services

Jun 19 2015

Ricordisamoa awarded T31120: ApiQueryLogEvents: let letype accept multiple values a Like token.
Jun 19 2015, 2:05 PM · MediaWiki-Action-API

Jun 3 2015

Merl added a comment to T72711: missing database entries at categorylinks table on dewiki db.

And currently again:

$ mysql -hs5.labsdb -vvve "select page_id, page_latest, cl_to from dewiki_p.page left join dewiki_p.categorylinks on page_id=cl_from where page_id IN(79660,165384,4948096)";
+---------+-------------+-------+
| page_id | page_latest | cl_to |
+---------+-------------+-------+
|   79660 |   142745685 | NULL  |
|  165384 |   142747515 | NULL  |
| 4948096 |   142743883 | NULL  |
+---------+-------------+-------+
3 rows in set (0.00 sec)
Jun 3 2015, 3:20 PM · DBA, Cloud-Services, Cloud-VPS

May 22 2015

Merl added a comment to T72711: missing database entries at categorylinks table on dewiki db.

Same problem again after two rollbacks:

May 22 2015, 10:00 AM · DBA, Cloud-Services, Cloud-VPS

May 1 2015

Merl created T97767: Add tools-bastion-02 as administrative hosts for sge.
May 1 2015, 1:06 PM · Cloud-Services, Cloud-VPS

Feb 5 2015

Merl added a parent task for T88682: Page with prefix "Wikipedia:" got somehow in NS 0 in database: T50930: Database replication problems - production and labs (tracking).
Feb 5 2015, 1:08 PM · WMF-General-or-Unknown
Merl added a subtask for T50930: Database replication problems - production and labs (tracking): T88682: Page with prefix "Wikipedia:" got somehow in NS 0 in database.
Feb 5 2015, 1:08 PM · SRE, DBA, Cloud-Services, Tracking-Neverending

Jan 30 2015

Merl added a subtask for T50930: Database replication problems - production and labs (tracking): T88183: Replag on labsdb.
Jan 30 2015, 11:39 PM · SRE, DBA, Cloud-Services, Tracking-Neverending
Merl added a parent task for T88183: Replag on labsdb: T50930: Database replication problems - production and labs (tracking).
Jan 30 2015, 11:39 PM · Cloud-Services, SRE, Toolforge

Jan 28 2015

Merl added a comment to T87716: Missing rows from categorylinks on production servers (dewiki).

Because of these error i had to stop my bot last night. That is why i have now no updated list. But i can post you some old examples
http://de.wikipedia.org/w/index.php?title=Heinrich_VII._von_Kranlucken&oldid=138229063
http://de.wikipedia.org/w/index.php?title=Caparezza&oldid=138234404
http://de.wikipedia.org/w/index.php?title=Katalogabbruch&oldid=138234568

Jan 28 2015, 8:28 AM · WMF-General-or-Unknown
Merl added a comment to T87716: Missing rows from categorylinks on production servers (dewiki).

http://de.wikipedia.org/wiki/Freswick_Castle (pageid 6741664)

Jan 28 2015, 8:17 AM · WMF-General-or-Unknown
Merl updated subscribers of T87716: Missing rows from categorylinks on production servers (dewiki).
Jan 28 2015, 12:05 AM · WMF-General-or-Unknown
Merl added subtasks for T87716: Missing rows from categorylinks on production servers (dewiki): T69556: merl tools (tracking), T50930: Database replication problems - production and labs (tracking).
Jan 28 2015, 12:04 AM · WMF-General-or-Unknown
Merl added a parent task for T69556: merl tools (tracking): T87716: Missing rows from categorylinks on production servers (dewiki).
Jan 28 2015, 12:04 AM · Tracking-Neverending, Tools
Merl added a parent task for T50930: Database replication problems - production and labs (tracking): T87716: Missing rows from categorylinks on production servers (dewiki).
Jan 28 2015, 12:04 AM · SRE, DBA, Cloud-Services, Tracking-Neverending
Merl renamed T87716: Missing rows from categorylinks on production servers (dewiki) from to Database servers having missing rows (on labs and api production servers).
Jan 28 2015, 12:02 AM · WMF-General-or-Unknown

Nov 29 2014

Merl created T76258: update tables page_props (wikibase_item) and langlinks on purge when requested with forcelinkupdate.
Nov 29 2014, 12:28 AM · TestMe, Wikidata, MediaWiki-extensions-WikibaseClient

Nov 27 2014

Merl closed T69602: Performance problem on database server s5 using commonswiki, a subtask of T69556: merl tools (tracking), as Resolved.
Nov 27 2014, 8:12 AM · Tracking-Neverending, Tools
Merl closed T69602: Performance problem on database server s5 using commonswiki as Resolved.

Some scripts are still getting a lock timeouts on first run, but nothing in compare with the initial reported problem here.

Nov 27 2014, 8:12 AM · Performance Issue, Toolforge
Merl closed T69602: Performance problem on database server s5 using commonswiki, a subtask of T60791: Missing Toolserver features in Tools (tracking), as Resolved.
Nov 27 2014, 8:12 AM · User-bd808, Community-Tech-Tool-Labs, Cloud-Services, Tracking-Neverending, Toolforge
Merl closed T69602: Performance problem on database server s5 using commonswiki, a subtask of T50930: Database replication problems - production and labs (tracking), as Resolved.
Nov 27 2014, 8:12 AM · SRE, DBA, Cloud-Services, Tracking-Neverending
Merl closed T76070: replication for s5 source wikis (dewiki/wikidata) stopped on labs1002 (dewiki.labsdb) as Resolved.

database is up to date again:

$ mysql -hdewiki.labsdb -e "select rc_timestamp, now(), now()-rc_timestamp as lag from recentchanges order by rc_timestamp desc limit 1;" dewiki_p
+----------------+---------------------+-----+
| rc_timestamp   | now()               | lag |
+----------------+---------------------+-----+
| 20141127080645 | 2014-11-27 08:06:49 |   4 |
+----------------+---------------------+-----+

I don't know who or what solved this problem but it does not exists anymore, so i am closing this bug.

Nov 27 2014, 8:08 AM · Wikimedia-Labs-General
Merl removed subtasks for T76070: replication for s5 source wikis (dewiki/wikidata) stopped on labs1002 (dewiki.labsdb) : T50930: Database replication problems - production and labs (tracking), T69556: merl tools (tracking).
Nov 27 2014, 8:05 AM · Wikimedia-Labs-General

Nov 26 2014

Merl added subtasks for T76070: replication for s5 source wikis (dewiki/wikidata) stopped on labs1002 (dewiki.labsdb) : T69556: merl tools (tracking), T50930: Database replication problems - production and labs (tracking).
Nov 26 2014, 7:37 PM · Wikimedia-Labs-General
Merl created T76070: replication for s5 source wikis (dewiki/wikidata) stopped on labs1002 (dewiki.labsdb) .
Nov 26 2014, 7:36 PM · Wikimedia-Labs-General
Merl updated subscribers of T75493: tables views missing for s5 databases (dewiki_p/wikidatawiki_p) on s3.labsdb.
Nov 26 2014, 5:44 PM · Wikimedia-Labs-General
Merl merged task T75511: wikidata (federated?) database not available for many wikis into T75493: tables views missing for s5 databases (dewiki_p/wikidatawiki_p) on s3.labsdb.
Nov 26 2014, 5:44 PM · Cloud-Services, Cloud-VPS
Merl added a comment to T75975: tables views missing for idwiki_p (source s3) on s3.labsdb.

see also T75493 for the same problem with s5 as source database cluster

Nov 26 2014, 8:34 AM · Wikimedia-Labs-General
Merl added subtasks for T75975: tables views missing for idwiki_p (source s3) on s3.labsdb: T69556: merl tools (tracking), T50930: Database replication problems - production and labs (tracking).
Nov 26 2014, 8:29 AM · Wikimedia-Labs-General
Merl created T75975: tables views missing for idwiki_p (source s3) on s3.labsdb.
Nov 26 2014, 8:28 AM · Wikimedia-Labs-General

Nov 25 2014

Merl reopened T75861: maiwiki: s3.labsdb server alias maiwiki.labsdb missing in /etc/hosts as "Open".

Ok, but the dns problem still exists:

Nov 25 2014, 4:34 PM · Cloud-VPS, Toolforge, Cloud-Services
Merl created T75861: maiwiki: s3.labsdb server alias maiwiki.labsdb missing in /etc/hosts.
Nov 25 2014, 11:55 AM · Cloud-VPS, Toolforge, Cloud-Services