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

Reply via email to