Page MenuHomePhabricator

wmfdata-r cannot query MariaDB
Closed, ResolvedPublic

Description

Trying to query MariaDB using the newly renamed wmfdata-r package fails with the following error:

Error in connection_details(database, use_x1 = use_x1) : 
  no shard map found; use update_shardmap() to download latest shard mapping

Attempting to update the shard map with update_shardmap() fails, the list is output to the console rather that stored in a file.

This appears to be due to lines 49 and 72 in R/mysql.R referencing the old package name, which results in system.file() returning an empty string. If those two lines are updated to use package = "wmfdata" the shard map can be stored on disk and MariaDB queried without errors. A patch for this is incoming.

Event Timeline

Change 622200 had a related patch set uploaded (by Nettrom; owner: Nettrom):
[wikimedia/discovery/wmf@master] Update package names to store shard mapping correctly

https://gerrit.wikimedia.org/r/622200

nettrom_WMF moved this task from Next 2 weeks to Needs Review on the Product-Analytics (Kanban) board.

Patch uploaded, moving to the review column for @mpopov to review.

Change 622200 merged by Bearloga:
[wikimedia/discovery/wmf@master] Update package names to store shard mapping correctly

https://gerrit.wikimedia.org/r/622200

Thank you so much!!! Merged and updated the shard map that v0.9.1 ships with. This also prompted me to double check if the old package name is referenced anywhere else and it should be all good now.