hoo (Marius Hoch)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Friday

  • Clear sailing ahead.

User Details

User Since
Oct 3 2014, 12:09 PM (142 w, 5 d)
Availability
Available
LDAP User
Hoo man
MediaWiki User
Hoo man

Recent Activity

Tue, Jun 20

Sjoerddebruin awarded T168434: Property suggester data treats P279 as classifying, while the PropertySuggester extension does not a Like token.
Tue, Jun 20, 5:30 PM · Wikidata-Sprint, Mediawiki-extensions-PropertySuggester, Wikidata

Sun, Jun 18

hoo added a comment to T166056: Add mw.wikibase.entity:getStatements for convenience.

@Lydia_Pintscher This was requested during the Vienna Hackathon.

Sun, Jun 18, 10:14 AM · Easy, MediaWiki-extensions-WikibaseClient, Wikidata
hoo closed T163815: Lua error: "The ID entered is unknown to the system. Please use a valid entity ID." with valid q-code as Resolved.

The problem seems no longer reproducible, so I guess the module(s) in question have been fixed.

Sun, Jun 18, 10:13 AM · MediaWiki-extensions-WikibaseClient, Wikidata
hoo closed T64925: Use alternative separator character when calling wbparsevalue as Resolved.
Sun, Jun 18, 9:52 AM · Patch-For-Review, Wikidata-Sprint, Wikidata, MediaWiki-extensions-WikibaseRepository
hoo closed T64925: Use alternative separator character when calling wbparsevalue, a subtask of T167226: All text after a pipe character is silently removed when saving a monolingual text property, as Resolved.
Sun, Jun 18, 9:52 AM · Wikibase-JavaScript-Api, MediaWiki-extensions-WikibaseRepository, Wikidata

Thu, Jun 1

Lucie awarded T162244: [Story] Search index 10,000 article placeholders on cywiki for testing and evaluation purposes a Pterodactyl token.
Thu, Jun 1, 9:14 AM · Patch-For-Review, Wikidata, ArticlePlaceholder

Wed, May 31

hoo added a comment to T163551: Huge number of duplicate rows in wb_terms.

My suggestion is, once the fix for not introducing new duplicates (https://gerrit.wikimedia.org/r/354550) is in, to list all duplicate row ids in a text file (generated via a query similar to the one I already mentioned). Then we can delete these in batches using a maintenance script reading from the file of term_row_id to delete.

Wed, May 31, 5:05 PM · Patch-For-Review, User-aude, Wikidata-Sprint, Wikidata, MediaWiki-extensions-WikibaseRepository
hoo closed T162244: [Story] Search index 10,000 article placeholders on cywiki for testing and evaluation purposes as Resolved.

All placeholders up to (including) https://cy.wikipedia.org/wiki/Arbennig:Am_y_Pwnc/Q16956 are now indexable!

Wed, May 31, 4:35 PM · Patch-For-Review, Wikidata, ArticlePlaceholder
hoo closed T162244: [Story] Search index 10,000 article placeholders on cywiki for testing and evaluation purposes, a subtask of T150178: Wikidata 2017 Q2 goals, as Resolved.
Wed, May 31, 4:35 PM · Wikidata
hoo added a comment to T162244: [Story] Search index 10,000 article placeholders on cywiki for testing and evaluation purposes.
mysql:wikiadmin@db1092 [wikidatawiki]> SELECT page_title FROM page INNER JOIN wb_entity_per_page ON epp_page_id = page_id INNER JOIN page_props AS pp_sl ON pp_sl.pp_page = page_id AND pp_sl.pp_propname = 'wb-sitelinks' INNER JOIN page_props AS pp_st ON pp_st.pp_page = page_id AND pp_st.pp_propname = 'wb-claims' WHERE pp_st.pp_value > 2 AND pp_sl.pp_value > 3 AND NOT EXISTS(SELECT 1 FROM wb_items_per_site WHERE ips_site_id = 'cywiki' AND ips_item_id = epp_entity_id) ORDER BY epp_entity_id ASC LIMIT 10000,1;
+------------+
| page_title |
+------------+
| Q16956     |
+------------+
1 row in set (0.58 sec)
Wed, May 31, 4:10 PM · Patch-For-Review, Wikidata, ArticlePlaceholder
hoo updated the task description for T151717: Usage tracking: record which statement group is used.
Wed, May 31, 3:12 PM · Wikidata-Sprint, Patch-For-Review, DBA, User-Daniel, Wikidata, MediaWiki-extensions-WikibaseClient

May 28 2017

Lucie awarded T155103: Create a truthy nt dump a Love token.
May 28 2017, 9:45 AM · User-Hydriz, Dumps-Generation, Wikidata

May 27 2017

hoo created P5495 hoo's T132839-Workarounds.sh.
May 27 2017, 5:52 PM
hoo created P5494 Production $wgPropertySuggesterDeprecatedIds (2017-05-27).
May 27 2017, 5:46 PM

May 22 2017

hoo moved T154948: media legends displayed in all languages in image boxes from Incoming to Doing on the ArticlePlaceholder board.
May 22 2017, 4:16 PM · Patch-For-Review, Design, Wikidata, ArticlePlaceholder
hoo moved T166067: Remove vertical whitespace from AboutTopic pages from Incoming to To Do Next on the ArticlePlaceholder board.
May 22 2017, 4:15 PM · Wikidata, ArticlePlaceholder
hoo merged task T165770: Remove whitespace between boxes into T166067: Remove vertical whitespace from AboutTopic pages.
May 22 2017, 4:14 PM · Wikidata, ArticlePlaceholder
hoo merged T165770: Remove whitespace between boxes into T166067: Remove vertical whitespace from AboutTopic pages.
May 22 2017, 4:14 PM · Wikidata, ArticlePlaceholder
hoo created T166067: Remove vertical whitespace from AboutTopic pages.
May 22 2017, 3:44 PM · Wikidata, ArticlePlaceholder
hoo created T166059: Track time spent in Wikibase Client data access functionality (parser functions/ Lua) during page renders.
May 22 2017, 2:34 PM · Performance, MediaWiki-extensions-WikibaseClient, Wikidata
hoo added a parent task for T166056: Add mw.wikibase.entity:getStatements for convenience: T112073: Lua in Wikibase (tracking).
May 22 2017, 1:31 PM · Easy, MediaWiki-extensions-WikibaseClient, Wikidata
hoo added a subtask for T112073: Lua in Wikibase (tracking): T166056: Add mw.wikibase.entity:getStatements for convenience.
May 22 2017, 1:31 PM · Tracking, Wikidata
hoo created T166056: Add mw.wikibase.entity:getStatements for convenience.
May 22 2017, 1:31 PM · Easy, MediaWiki-extensions-WikibaseClient, Wikidata
hoo added a comment to T142903: Get sitelink from Item without loading the full Item (via Lua)..

Thinking about this more, we could provide a mw.wikibase.getUserLanguageSitelink( entityId, 'wikipedia' )/mw.wikibase.entity:getUserLanguageSitelink( entityId, 'wikipedia' ) which would return the sitelink on the Wikipedia which has the user's language or nil if there's none. Implementing a fallback here for finding other potentially relevant Wikipedias would be possible (based on Language fallbacks), but I'm not sure that's very useful.

May 22 2017, 1:28 PM · MediaWiki-extensions-WikibaseClient, Wikidata
hoo added a comment to T151717: Usage tracking: record which statement group is used.

I ran the numbers briefly and both kowiki and trwiki don't look as interesting to me. Therefore I would suggest going with elwiki, which has the following usages currently:

May 22 2017, 11:37 AM · Wikidata-Sprint, Patch-For-Review, DBA, User-Daniel, Wikidata, MediaWiki-extensions-WikibaseClient
hoo added projects to T166042: Put Wikibase Statements (and possibly other parts of entities) into restbase: RESTBase, Wikidata.
May 22 2017, 10:28 AM · RESTBase-API, Services (designing), Wikidata, RESTBase
hoo created T166042: Put Wikibase Statements (and possibly other parts of entities) into restbase.
May 22 2017, 10:28 AM · RESTBase-API, Services (designing), Wikidata, RESTBase
hoo added a parent task for T99899: [Story] Allow looking up Entities by external identifiers.: T112073: Lua in Wikibase (tracking).
May 22 2017, 9:36 AM · Story, Wikidata
hoo added a subtask for T112073: Lua in Wikibase (tracking): T99899: [Story] Allow looking up Entities by external identifiers..
May 22 2017, 9:36 AM · Tracking, Wikidata
hoo updated subscribers of T99899: [Story] Allow looking up Entities by external identifiers..
May 22 2017, 9:35 AM · Story, Wikidata

May 21 2017

hoo updated the task description for T95663: [Story] Use composer-merge-plugin to include Wikidata components in mediawiki-vendor.
May 21 2017, 12:32 PM · Release-Engineering-Team (Kanban), Story, Wikidata
hoo updated the task description for T95663: [Story] Use composer-merge-plugin to include Wikidata components in mediawiki-vendor.
May 21 2017, 12:31 PM · Release-Engineering-Team (Kanban), Story, Wikidata
hoo added a comment to T165947: Make the OSM gadget resizable.

Changes by @simon04 applied to meta: https://meta.wikimedia.org/w/index.php?diff=16792401&oldid=15240696.

May 21 2017, 8:54 AM · Gadgets, Wikimedia-Hackathon-2017
hoo created P5469 mwgrep MediaWiki:OSM.js (May 2017).
May 21 2017, 8:42 AM · Gadgets

May 20 2017

hoo added a comment to T165860: Request for +2 rights on mediawiki/* for Ladsgroup.

+1 Definitively

May 20 2017, 10:53 AM · Release-Engineering-Team (Kanban), Repository-Ownership-Requests

May 19 2017

hoo closed T111641: [Bug] Warning: Attempted to serialize unserializable builtin class Closure$jsonConfigIsStorage (from Changes/ChangeHandlerTest.php (173): mergeMwGlobalArrayValue) as Resolved.

Workaround is in place, now we can just wait for someone to fix this in HHVM.

May 19 2017, 7:45 PM · MW-1.30-release-notes (WMF-deploy-2017-05-23_(1.30.0-wmf.2)), Patch-For-Review, HHVM, Upstream, MediaWiki-extensions-WikibaseClient, Wikidata
hoo updated subscribers of T156832: [RfC] Decide whether to index not-notable placeholders.

When discussing this with @Fnielsen he mentioned that there might be Items which are very interesting for the certain audience of a Wikipedia (like Danish paintings might be very interesting to readers of the Danish Wikipedia). But these Items often fail to meet our notability criteria, as they are mostly interesting for a certain audience.

May 19 2017, 7:24 PM · ArticlePlaceholder, Wikidata
hoo added a comment to T162244: [Story] Search index 10,000 article placeholders on cywiki for testing and evaluation purposes.

We plan to deploy this on Wednesday May 31.

May 19 2017, 7:05 PM · Patch-For-Review, Wikidata, ArticlePlaceholder
hoo committed rWDBRab256d82d206: Add ValueView to Wikidata.localisation.php entry point (authored by aude).
Add ValueView to Wikidata.localisation.php entry point
May 19 2017, 7:01 PM
hoo committed rWDBR6e07f4a5372c: Add (empty) composer test script (authored by aude).
Add (empty) composer test script
May 19 2017, 7:01 PM
hoo merged task T71054: Warning: Attempted to serialize unserializable builtin class Closure$... into T111641: [Bug] Warning: Attempted to serialize unserializable builtin class Closure$jsonConfigIsStorage (from Changes/ChangeHandlerTest.php (173): mergeMwGlobalArrayValue).
May 19 2017, 6:50 PM · MediaWiki-Unit-tests
hoo merged task T165093: Attempted to serialize unserializable builtin class Closure into T111641: [Bug] Warning: Attempted to serialize unserializable builtin class Closure$jsonConfigIsStorage (from Changes/ChangeHandlerTest.php (173): mergeMwGlobalArrayValue).
May 19 2017, 6:50 PM · HHVM, MediaWiki-Unit-tests
hoo merged tasks T165093: Attempted to serialize unserializable builtin class Closure, T71054: Warning: Attempted to serialize unserializable builtin class Closure$... into T111641: [Bug] Warning: Attempted to serialize unserializable builtin class Closure$jsonConfigIsStorage (from Changes/ChangeHandlerTest.php (173): mergeMwGlobalArrayValue).
May 19 2017, 6:50 PM · MW-1.30-release-notes (WMF-deploy-2017-05-23_(1.30.0-wmf.2)), Patch-For-Review, HHVM, Upstream, MediaWiki-extensions-WikibaseClient, Wikidata
hoo renamed T165799: "Wikidata Dump Downloads" Grafana Dashboard no longer updating from "Wikidata Dump Downloads" no longer updating to "Wikidata Dump Downloads" Grafana Dashboard no longer updating.
May 19 2017, 6:31 PM · WMDE-Analytics-Engineering, Wikidata
hoo created T165799: "Wikidata Dump Downloads" Grafana Dashboard no longer updating.
May 19 2017, 6:31 PM · WMDE-Analytics-Engineering, Wikidata
hoo added a comment to T144476: [feature request] add count of external-ids to rdf (Wikidata).

According to @Smalyshev the service has recently been reloaded:

SELECT (COUNT(*) as ?count) WHERE {
  ?a wikibase:statements ?b
}
May 19 2017, 6:19 PM · Discovery, Wikidata-Query-Service, Wikidata
hoo claimed T163551: Huge number of duplicate rows in wb_terms.
May 19 2017, 6:11 PM · Patch-For-Review, User-aude, Wikidata-Sprint, Wikidata, MediaWiki-extensions-WikibaseRepository
hoo added a comment to T165770: Remove whitespace between boxes .

How is the Lua module supposed to estimate the size of the box? Is that even feasible?

May 19 2017, 2:41 PM · Wikidata, ArticlePlaceholder
hoo removed a project from T163815: Lua error: "The ID entered is unknown to the system. Please use a valid entity ID." with valid q-code: Patch-For-Review.

After the next Wikidata deploy, you should be able to see what exactly is causing the problems in question so that it should be easier to locate the problem.

May 19 2017, 2:13 PM · MediaWiki-extensions-WikibaseClient, Wikidata

May 18 2017

hoo moved T151717: Usage tracking: record which statement group is used from Proposed to Review on the Wikidata-Sprint board.
May 18 2017, 12:33 PM · Wikidata-Sprint, Patch-For-Review, DBA, User-Daniel, Wikidata, MediaWiki-extensions-WikibaseClient
hoo added a project to T151717: Usage tracking: record which statement group is used: Wikidata-Sprint.
May 18 2017, 12:33 PM · Wikidata-Sprint, Patch-For-Review, DBA, User-Daniel, Wikidata, MediaWiki-extensions-WikibaseClient

May 12 2017

hoo updated subscribers of T164783: RDF dumps do not have 'latest' link.

I don't like to have stable links with BETA in them (like https://dumps.wikimedia.org/wikidatawiki/entities/latest-all-BETA.ttl.bz2), thus I would prefer to add https://dumps.wikimedia.org/wikidatawiki/entities/latest-all.ttl.bz2.

May 12 2017, 10:48 AM · Patch-For-Review, Wikidata

May 11 2017

hoo added a comment to T164994: Enable wbgetsuggestions API to get recommended properties even if they have existed in an item.

We don't have a hard limit in the suggester, but we have a probability cut-off. So if an item has a lot of statements already, we might just not find any further relevant properties.

May 11 2017, 8:11 PM · Wikidata-Sprint, Patch-For-Review, MediaWiki-API, Wikidata

May 10 2017

hoo added a comment to T164783: RDF dumps do not have 'latest' link.

I don't think we should add this before we declare the RDF dumps stable, thus I added T112127: [Story] Move RDF ontology from beta to release status as a subtask/ dependency for this.

May 10 2017, 10:24 PM · Patch-For-Review, Wikidata
hoo added a subtask for T164783: RDF dumps do not have 'latest' link: T112127: [Story] Move RDF ontology from beta to release status.
May 10 2017, 10:23 PM · Patch-For-Review, Wikidata
hoo added a parent task for T112127: [Story] Move RDF ontology from beta to release status: T164783: RDF dumps do not have 'latest' link.
May 10 2017, 10:23 PM · Patch-For-Review, Story, Wikidata-Query-Service, Discovery, Wikidata
hoo added a comment to T151681: DispatchChanges: Avoid long-lasting connections to the master DB .

With the current state, we still have the same amount of connections to the master DBs, but we don't use GET_LOCK etc. on them anymore. The queries are unchanged also (despite the GET_LOCK etc.).

May 10 2017, 6:25 PM · User-Daniel, Performance, DBA, Wikidata

May 9 2017

hoo closed T164682: Reset Cornelius Kibelka's 2FA as Resolved.

2fa has been removed, you should be able to log in by just using your user name + password again.

May 9 2017, 9:08 AM · Support-and-Safety, Labs, wikitech.wikimedia.org

May 7 2017

hoo added a comment to T163815: Lua error: "The ID entered is unknown to the system. Please use a valid entity ID." with valid q-code.

@hoo is there anything we can do here?

May 7 2017, 5:24 PM · MediaWiki-extensions-WikibaseClient, Wikidata

May 4 2017

Ladsgroup awarded T163551: Huge number of duplicate rows in wb_terms a Heartbreak token.
May 4 2017, 7:03 PM · Patch-For-Review, User-aude, Wikidata-Sprint, Wikidata, MediaWiki-extensions-WikibaseRepository

May 3 2017

hoo added a comment to T160506: Update constraint table.

Since the API and user script announcement, several constraints have been fixed, such as this one which used to report two violations on every date of birth in Wikidata. Can we do another reload? We should also announce it to the community so that they know they should get in any necessary changes before the date in question (say, next Wednesday, 2017-05-10).

May 3 2017, 10:26 AM · Wikibase-Quality, Wikibase-Quality-Constraints, Wikidata
hoo closed T163748: Can't create an item redirect over existing item, if item has deleted revisions as Resolved.

Will be fixed with the next deploy.

May 3 2017, 9:14 AM · Wikidata-Sprint, MediaWiki-extensions-WikibaseRepository, Wikidata

Apr 28 2017

hoo added a comment to T95663: [Story] Use composer-merge-plugin to include Wikidata components in mediawiki-vendor.

Any updates here? For us it's good enough if we can manually update the vendor "build" when needed, we don't need any automatism here that reacts upon Wikibase wmf-branch changes.

Apr 28 2017, 8:08 AM · Release-Engineering-Team (Kanban), Story, Wikidata

Apr 26 2017

hoo closed T109825: [Task] Use uppercase entity ID in wb_changes table., a subtask of T110528: [Task] Use JOIN to find changes relevant for a given wiki, as Resolved.
Apr 26 2017, 4:23 PM · Performance, Wikidata
hoo closed T109825: [Task] Use uppercase entity ID in wb_changes table. as Resolved.

Works in production (on test.wikidata), will go live on Wikidata later today.

Apr 26 2017, 4:23 PM · Technical-Debt, Wikidata

Apr 25 2017

hoo closed T163770: globalblocks table not updated when block changed as Invalid.

Those block changes were to the local block, though, weren't they?

Apr 25 2017, 8:01 AM · Stewards-and-global-tools, GlobalBlocking
hoo added a project to T163770: globalblocks table not updated when block changed: Stewards-and-global-tools.
Apr 25 2017, 7:38 AM · Stewards-and-global-tools, GlobalBlocking
hoo added a project to T163770: globalblocks table not updated when block changed: GlobalBlocking.
Apr 25 2017, 7:38 AM · Stewards-and-global-tools, GlobalBlocking
hoo created T163770: globalblocks table not updated when block changed.
Apr 25 2017, 7:37 AM · Stewards-and-global-tools, GlobalBlocking
hoo added a comment to T163748: Can't create an item redirect over existing item, if item has deleted revisions.

The semantics of Title::isDeleted seem to be utterly broken. It does not say if a page is currently deleted, but if there was ever a revision deleted, and how much. Can we please deprecate this shit and rename it to hasDeletedRevisons or something?

Apr 25 2017, 6:24 AM · Wikidata-Sprint, MediaWiki-extensions-WikibaseRepository, Wikidata
hoo added a comment to T161529: Create Wikipedia Doteli.

Wikidata confirmed: https://www.wikidata.org/w/index.php?diff=478497603

Apr 25 2017, 6:17 AM · Patch-For-Review, Wikimedia-Site-requests
hoo renamed T163748: Can't create an item redirect over existing item, if item has deleted revisions from Can't created an item redirect if item has deleted revisions to Can't created an item redirect over existing item, if item has deleted revisions.
Apr 25 2017, 6:15 AM · Wikidata-Sprint, MediaWiki-extensions-WikibaseRepository, Wikidata
hoo added a comment to T163748: Can't create an item redirect over existing item, if item has deleted revisions.

What I meant is that: You can't turn an Item into a redirect if it has one or more deleted revisions.

Apr 25 2017, 6:03 AM · Wikidata-Sprint, MediaWiki-extensions-WikibaseRepository, Wikidata

Apr 24 2017

hoo added projects to T163748: Can't create an item redirect over existing item, if item has deleted revisions: Wikidata, MediaWiki-extensions-WikibaseRepository.
Apr 24 2017, 10:04 PM · Wikidata-Sprint, MediaWiki-extensions-WikibaseRepository, Wikidata
hoo created T163748: Can't create an item redirect over existing item, if item has deleted revisions.
Apr 24 2017, 10:02 PM · Wikidata-Sprint, MediaWiki-extensions-WikibaseRepository, Wikidata
hoo added a comment to T163551: Huge number of duplicate rows in wb_terms.

Probably at least 10% of the table are duplicates (at least 129M/2).

Apr 24 2017, 3:59 PM · Patch-For-Review, User-aude, Wikidata-Sprint, Wikidata, MediaWiki-extensions-WikibaseRepository
hoo updated the task description for T163551: Huge number of duplicate rows in wb_terms.
Apr 24 2017, 3:50 PM · Patch-For-Review, User-aude, Wikidata-Sprint, Wikidata, MediaWiki-extensions-WikibaseRepository
hoo added a comment to T163551: Huge number of duplicate rows in wb_terms.

Number of rows which occur at least twice (excludes aliases, for performance reasons):

Apr 24 2017, 3:49 PM · Patch-For-Review, User-aude, Wikidata-Sprint, Wikidata, MediaWiki-extensions-WikibaseRepository
hoo closed T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover, a subtask of T163495: Mediawiki revision-related queries are failing with high rate for enwiki on codfw, as Resolved.
Apr 24 2017, 12:00 PM · Patch-For-Review, codfw-rollout, Wikimedia-Incident, MediaWiki-General-or-Unknown
hoo closed T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover as Resolved.

Both problems have been addressed.

Apr 24 2017, 12:00 PM · Patch-For-Review, Wikidata
hoo added a comment to T163144: Restoration of deleted items broken on Wikidata.

It likely has not been deployed yet. Thanks for checking.
@hoo when will it be deployed?

Apr 24 2017, 11:35 AM · Wikidata-Sprint, Patch-For-Review, Regression, Wikidata

Apr 23 2017

hoo added a comment to T101253: [RFC] How to track description usage.

Is this still relevant?

Apr 23 2017, 8:17 PM · RfC, Wikidata, MediaWiki-extensions-WikibaseClient
hoo added a comment to T110528: [Task] Use JOIN to find changes relevant for a given wiki.

Is this still relevant?

Apr 23 2017, 8:16 PM · Performance, Wikidata
hoo closed T163144: Restoration of deleted items broken on Wikidata as Resolved by committing rEWBA3ac3e853a9dc: Rely on ContentHandler::supportsDirectEditing being false.
Apr 23 2017, 3:27 PM · Wikidata-Sprint, Patch-For-Review, Regression, Wikidata

Apr 21 2017

hoo added a comment to T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover.
<hoo> jynus: For the first query in https://phabricator.wikimedia.org/T163544 how many term_entity_id would be ok?
<hoo> Right now we don't batch there at all, but I can add that rather easily
<hoo> Would 10 be ok?
<jynus> I would say 9
<jynus> I thin 10 is the limit to start getting in some cases bad queries
<jynus> (approximate cardinality)
<hoo> Ok, that's fine
Apr 21 2017, 2:46 PM · Patch-For-Review, Wikidata
hoo added projects to T163551: Huge number of duplicate rows in wb_terms: MediaWiki-extensions-WikibaseRepository, Wikidata.
Apr 21 2017, 1:26 PM · Patch-For-Review, User-aude, Wikidata-Sprint, Wikidata, MediaWiki-extensions-WikibaseRepository
hoo created T163551: Huge number of duplicate rows in wb_terms.
Apr 21 2017, 1:25 PM · Patch-For-Review, User-aude, Wikidata-Sprint, Wikidata, MediaWiki-extensions-WikibaseRepository
hoo claimed T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover.

I'm looking into this and will see what we can do.

Apr 21 2017, 12:43 PM · Patch-For-Review, Wikidata
hoo updated subscribers of T163548: Drop the useless wb_terms keys "wb_terms_entity_type" and "wb_terms_type" on "wb_terms" table.
Apr 21 2017, 12:36 PM · Patch-For-Review, Wikidata, DBA, Schema-change
hoo added projects to T163548: Drop the useless wb_terms keys "wb_terms_entity_type" and "wb_terms_type" on "wb_terms" table: Schema-change, DBA, Wikidata.
Apr 21 2017, 12:35 PM · Patch-For-Review, Wikidata, DBA, Schema-change
hoo updated the task description for T163548: Drop the useless wb_terms keys "wb_terms_entity_type" and "wb_terms_type" on "wb_terms" table.
Apr 21 2017, 12:34 PM · Patch-For-Review, Wikidata, DBA, Schema-change
hoo updated the task description for T163548: Drop the useless wb_terms keys "wb_terms_entity_type" and "wb_terms_type" on "wb_terms" table.
Apr 21 2017, 12:33 PM · Patch-For-Review, Wikidata, DBA, Schema-change
hoo created T163548: Drop the useless wb_terms keys "wb_terms_entity_type" and "wb_terms_type" on "wb_terms" table.
Apr 21 2017, 12:25 PM · Patch-For-Review, Wikidata, DBA, Schema-change

Apr 19 2017

hoo closed T155103: Create a truthy nt dump as Resolved.

The first truthy nt dump can be found at https://dumps.wikimedia.org/wikidatawiki/entities/20170418/. New truthy nt dumps will appear weekly on https://dumps.wikimedia.org/wikidatawiki/entities/ at about the same time (mid to late Wednesday UTC).

Apr 19 2017, 4:51 PM · User-Hydriz, Dumps-Generation, Wikidata
hoo created T163328: Add the truthy nt dump to dcat-AP.
Apr 19 2017, 2:23 PM · User-LokalProfil, Dumps-Generation, Wikidata
hoo added a comment to T149522: Create Wikisource Eastern Punjabi.

Wikidata specific steps taken and confirmed: https://www.wikidata.org/w/index.php?diff=476527413.

Apr 19 2017, 8:23 AM · Patch-For-Review, Wikimedia-Site-requests, Wikisource
hoo added a comment to T95663: [Story] Use composer-merge-plugin to include Wikidata components in mediawiki-vendor.

@Reedy We have our "dependency template" in the wikidata/build-resources repo. It's mostly just straight-forward pulling things in via composer, but we also do some evil-ish magic in build/tasks/updatecomposer.js.

Apr 19 2017, 7:59 AM · Release-Engineering-Team (Kanban), Story, Wikidata
hoo added a comment to T105398: Add flaggedrevs.fr_user index for UserMerge queries.

Is this still needed?

Apr 19 2017, 7:03 AM · Schema-change, DBA, MediaWiki-extensions-FlaggedRevs, MediaWiki-extensions-UserMerge

Apr 18 2017

hoo added a comment to T151717: Usage tracking: record which statement group is used.

We want to collect additional information on one of these wikis for a while

If that doesn't involve a schema change, sure.

Apr 18 2017, 7:53 AM · Wikidata-Sprint, Patch-For-Review, DBA, User-Daniel, Wikidata, MediaWiki-extensions-WikibaseClient

Apr 13 2017

hoo added a comment to T155103: Create a truthy nt dump.

The first truthy nt dump should appear next Tuesday (probably late UTC).

Apr 13 2017, 5:34 PM · User-Hydriz, Dumps-Generation, Wikidata