https://bugzilla.wikimedia.org/show_bug.cgi?id=32551

Bawolff (Brian Wolff) <bawolff...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |bawolff...@gmail.com

--- Comment #20 from Bawolff (Brian Wolff) <bawolff...@gmail.com> ---
There are a significant number (~700 a month) of files where during upload an
entry in page table is created, but page_latest = 0 (and log_page also seems to
be 0). If we just count upload entries with log_page = 0 (Which seems to be
symtomatic of the issue, but I haven't 100% verified it can't happen in other
situations)

MariaDB [commonswiki_p]> select substr( log_timestamp, 1, 6) as YYYYMM,
count(*) as 'uploads missing log_page' from logging_logindex  where
log_type='upload' and log_timestamp > '20121000000000' and log_page = 0 group
by substr( log_timestamp, 1, 6);
+--------+--------------------------+
| YYYYMM | uploads missing log_page |
+--------+--------------------------+
| 201210 |                     1323 |
| 201211 |                      572 |
| 201212 |                      624 |
| 201301 |                     1179 |
| 201302 |                      666 |
| 201303 |                      762 |
| 201304 |                      955 |
| 201305 |                      637 |
| 201306 |                      598 |
| 201307 |                      555 |
| 201308 |                      818 |
| 201309 |                     3268 |
| 201310 |                      808 |
| 201311 |                      852 |
| 201312 |                      806 |
| 201401 |                     1116 |
| 201402 |                      435 |
+--------+--------------------------+
17 rows in set (7.08 sec)


This is not a good thing.

-- 
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to