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
EMAIL PREFERENCES
To: hoo
Cc: Stashbot, Addshore, daniel, aude, Aklapper, hoo, D3r1ck01, Izno, Wikidata-bugs, Mbch331, Jay8g, Krenair
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