https://bugzilla.wikimedia.org/show_bug.cgi?id=37591
--- Comment #22 from Liangent <[email protected]> 2012-08-03 13:32:07 UTC --- (In reply to comment #2) > mysql> select * from revision where rev_page=46728 order by rev_id desc limit > 10; > +----------+----------+-------------+-----------------------------------------------------------+----------+---------------+----------------+----------------+-------------+---------+---------------+---------------------------------+ > | rev_id | rev_page | rev_text_id | rev_comment > > | rev_user | rev_user_text | rev_timestamp | rev_minor_edit | > rev_deleted | rev_len | rev_parent_id | rev_sha1 | > +----------+----------+-------------+-----------------------------------------------------------+----------+---------------+----------------+----------------+-------------+---------+---------------+---------------------------------+ > | 21416960 | 46728 | 21613695 | consistency > > | 775182 | Cravix | 20120531141052 | 1 > | > 0 | 3421 | 21345461 | 0cu0xuhfnyfcgsfwowsww8qg7byyg6m | Seems relevant revision / archive rows are missing while text is still there: mysql> select * from archive where ar_rev_id=21416960; Empty set (0.07 sec) mysql> select * from archive where ar_timestamp='20120531141052' /* SLOW_OK */; Empty set (40.81 sec) mysql> select * from revision where rev_sha1='0cu0xuhfnyfcgsfwowsww8qg7byyg6m' /* SLOW_OK */; Empty set (16 min 28.74 sec) mysql> select * from revision where rev_text_id=21613695 /* SLOW_OK */; Empty set (43 min 54.86 sec) mysql> select * from text where old_id=21613695; +----------+---------------+-----------+-----------------------+-------------+----------+---------------+---------------+----------------+---------------------+-------------------+ | old_id | old_namespace | old_title | old_text | old_comment | old_user | old_user_text | old_timestamp | old_minor_edit | old_flags | inverse_timestamp | +----------+---------------+-----------+-----------------------+-------------+----------+---------------+---------------+----------------+---------------------+-------------------+ | 21613695 | 0 | | DB://cluster23/398889 | | 0 | | | 0 | utf-8,gzip,external | | +----------+---------------+-----------+-----------------------+-------------+----------+---------------+---------------+----------------+---------------------+-------------------+ 1 row in set (0.03 sec) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
