Currently ORES wp10 scale can't be loaded in PetScan.
Database query failed. Problem with euwiki?
It would be great to add this, so we can download assesments via PetScan.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T195604 Extend feature extractors for euwiki articlequality model | |||
| Open | None | T197871 Add articlequality model in PetScan | |||
| Resolved | Ladsgroup | T198358 Enable ores extension wp10 storage in Basque Wikipedia |
Event Timeline
Comment Actions
Who maintains petscan? It seems like we should get them involved. We're working on bringing wp10 predictions to MediaWiki, so if petscan uses the database table, it should have access to recent wp10 predictions.
Comment Actions
I run PetScan.
The reason this fails is because neither ores_classification nor oresc_model tables are available on the euwiki database replicas on Labs. Nothing I can do about that.
Comment Actions
@Ladsgroup, it looks like we're blocking here. Should we create a new task for enabling ORES ext and wp10 tracking to euwiki?
Comment Actions
It does work, however, since there is currently not a single page on euwiki where the latest revision has a wp10 score, the results will be empty.
All pages with wp10 scores on the latest (current) revision:
SELECT page_title,ores_classification.* FROM ores_classification,page WHERE page_namespace=0 AND page_latest=oresc_rev AND oresc_model IN (SELECT oresm_id FROM ores_model WHERE oresm_is_current=1 AND oresm_name="wp10")
So I think this can be closed because PetScan is working and data is exposed in the replica. That there is no useful data is not a bug, or a bug of either the ORES or replication setup.
Comment Actions
Because "wp10" is obsolete and discarded, the correct name is "articlequality"
MariaDB [euwiki_p]> SELECT page_title,ores_classification.* FROM ores_classification,page WHERE page_namespace=0 AND page_latest=oresc_rev AND oresc_model IN (SELECT oresm_id FROM ores_model WHERE oresm_is_current=1 AND oresm_name="articlequality") limit 5; +----------------------------+----------+-----------+-------------+-------------+-------------------+--------------------+ | page_title | oresc_id | oresc_rev | oresc_model | oresc_class | oresc_probability | oresc_is_predicted | +----------------------------+----------+-----------+-------------+-------------+-------------------+--------------------+ | !!! | 1702150 | 8347930 | 80 | 0 | 0.165 | 0 | | 'Ndrangheta | 1395761 | 8004600 | 80 | 0 | 0.175 | 0 | | (H)ilbeltza | 1701817 | 8347515 | 80 | 0 | 0.195 | 0 | | 1._linea | 1702146 | 8347926 | 80 | 0 | 0.110 | 0 | | 1._linea_(Malagako_metroa) | 1692998 | 8336689 | 80 | 0 | 0.387 | 0 | +----------------------------+----------+-----------+-------------+-------------+-------------------+--------------------+ 5 rows in set (0.09 sec)