Page MenuHomePhabricator

Add wb_property_info table to Wikidata and populate
Closed, ResolvedPublic

Description

wb_property_info table needs to be added to wikidata and the schema change reviewed.

the schema patch is in the WikibaseLib extension (in the Wikibase gerrit repo)

https://git.wikimedia.org/blob/mediawiki%2Fextensions%2FWikibase.git/2604e7f495c996aa10587d9a4d6648cef9aca431/lib%2Fincludes%2Fstore%2Fsql%2Fwb_property_info.sql

Once added, the rebuildPropertyInfo.php needs to be run.

Then we can change the config setting for wikidata to enable use of the table.


Version: wmf-deployment
Severity: enhancement

Details

Reference
bz51631

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:46 AM
bzimport set Reference to bz51631.

Assigning to Sean for his review.

Discussed this previously in a separate email thread.

The schema seems fine, has a PK suitable for OSC, etc. Good to go.

Assigning to Reedy to do the actual rollout (according to Aude on that elusive email thread Sean mentioned, Reedy should be able to handle this).

(In reply to comment #0)

wb_property_info table needs to be added to wikidata and the schema change
reviewed.

Make that wikidatawiki AND testwikidatawiki

Tables created on both wikis.

reedy@tin:/a/common/php-1.22wmf12$ mwscript extensions/Wikibase/repo/maintenance/rebuildPropertyInfo.php --wiki=testwikidatawiki
...Update 'Wikibase\RebuildPropertyInfo' already logged as completed.
reedy@tin:/a/common/php-1.22wmf12$ mwscript extensions/Wikibase/repo/maintenance/rebuildPropertyInfo.php --wiki=testwikidatawiki --force
Updated 3 properties, up to ID 16.
Done. Updated 3 property info entries.
reedy@tin:/a/common/php-1.22wmf12$ mwscript extensions/Wikibase/repo/maintenance/rebuildPropertyInfo.php --wiki=testwikidatawiki --force --rebuild-all
Updated 9 properties, up to ID 16.
Done. Updated 9 property info entries.
reedy@tin:/a/common/php-1.22wmf12$

What options do we want to run with for testwikidata?

(In reply to comment #5)

What options do we want to run with for testwikidata?

Uh, wikidatawiki

the default options are fine.

Default options are to rebuild only the missing rows (everything is missing, so it will add everything), start at row 0 and and batch size of 100.

if you want, batch-size can be increased but this will not be a large table so default is okay.