[Wikidata-bugs] [Maniphest] [Closed] T147630: wbc_entity_usage contains invalid entity ids (numeric parts to large)

[hoo]

hoo closed this task as "Resolved". hoo claimed this task. hoo added a comment.

Query:

mysql:wikiadmin@db1045 [wikidatawiki]> SELECT * FROM wbc_entity_usage WHERE LENGTH(eu_entity_id) > 10 AND REPLACE(REPLACE(eu_entity_id, 'Q', ''), 'P', '') > 2147483647;
+-----------+--------------+-----------+------------+----------------+
| eu_row_id | eu_entity_id | eu_aspect | eu_page_id | eu_touched     |
+-----------+--------------+-----------+------------+----------------+
|   1714177 | Q3000000000  | X         |   18497544 | 20160409212853 |
|   1714178 | Q4000000000  | X         |   18497544 | 20160409212853 |
|   1714179 | Q5000000000  | X         |   18497544 | 20160409212853 |
|   1714180 | Q6000000000  | X         |   18497544 | 20160409212853 |
|   1714181 | Q7000000000  | X         |   18497544 | 20160409212853 |
|   1714182 | Q8000000000  | X         |   18497544 | 20160409212853 |
|   1714183 | Q9000000000  | X         |   18497544 | 20160409212853 |
|   1714184 | Q10000000000 | X         |   18497544 | 20160409212853 |
|   3914375 | Q4294967294  | X         |   23223110 | 20160412202754 |
+-----------+--------------+-----------+------------+----------------+
9 rows in set (12.00 sec)

Deleted on s5 master:

mysql:wikiadmin@db1049 [wikidatawiki]> BEGIN;
Query OK, 0 rows affected (0.00 sec)

mysql:wikiadmin@db1049 [wikidatawiki]> DELETE FROM wbc_entity_usage WHERE eu_row_id IN(1714177, 1714178, 1714179, 1714180, 1714181, 1714182, 1714183, 1714184, 3914375);
Query OK, 9 rows affected (0.00 sec)

mysql:wikiadmin@db1049 [wikidatawiki]> COMMIT;
Query OK, 0 rows affected (0.01 sec)

Query afterwards:

mysql:wikiadmin@db1045 [wikidatawiki]> SELECT * FROM wbc_entity_usage WHERE LENGTH(eu_entity_id) > 10 AND REPLACE(REPLACE(eu_entity_id, 'Q', ''), 'P', '') > 2147483647;
Empty set (0.87 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T147630

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: hoo
Cc: Stashbot, Addshore, daniel, aude, Aklapper, hoo, D3r1ck01, Izno, Wikidata-bugs, Mbch331, Jay8g, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs