Page MenuHomePhabricator
Paste P5150

wmf-table-checksum
ActivePublic

Authored by jcrespo on Mar 28 2017, 3:17 PM.
Tags
None
Referenced Files
F7052155:
Mar 28 2017, 3:17 PM
Subscribers
None
$ python3 compare.py dbstore1002 dbstore1002 arbcom_cswiki text old_id
SELECT min(old_id), max(old_id) FROM text
DESCRIBE text
SET SESSION group_concat_max_len = 10000000
SELECT crc32(GROUP_CONCAT(old_text,old_id,old_flags)) FROM text WHERE old_id BETWEEN 1 AND 493 ORDER BY old_id
No differences found.

Event Timeline

jcrespo changed the title of this paste from untitled to wmf-table-checksum.

$ python3 compare.py dbstore1001 dbstore1002 arbcom_enwiki text old_id
SELECT min(old_id), max(old_id) FROM text
DESCRIBE text
SET SESSION group_concat_max_len = 10000000
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 1 AND 1000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 1001 AND 2000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 2001 AND 3000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 3001 AND 4000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 4001 AND 5000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 5001 AND 6000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 6001 AND 7000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 7001 AND 8000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 8001 AND 9000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 9001 AND 10000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 10001 AND 11000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 11001 AND 12000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 12001 AND 13000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 13001 AND 14000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 14001 AND 15000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 15001 AND 16000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 16001 AND 17000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 17001 AND 18000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 18001 AND 19000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 19001 AND 20000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 20001 AND 21000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 21001 AND 22000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 22001 AND 23000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 23001 AND 24000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 24001 AND 25000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 25001 AND 26000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 26001 AND 27000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 27001 AND 28000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 28001 AND 29000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 29001 AND 30000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 30001 AND 31000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 31001 AND 32000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 32001 AND 33000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 33001 AND 34000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 34001 AND 35000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 35001 AND 36000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 36001 AND 37000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 37001 AND 38000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 38001 AND 39000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 39001 AND 40000 ORDER BY old_id
SELECT crc32(GROUP_CONCAT(old_flags,old_id,old_text)) FROM text WHERE old_id BETWEEN 40001 AND 40294 ORDER BY old_id
No differences found.